Prepare an accounting equation worksheet

Assignment Help Accounting Basics
Reference no: EM13844672

The 2006 Annual Report for Kelloggs is on the Vspace site, in the chapter 6 folder. Please open the Annual Report and access the financial statements (income statement, referred to in Kelloggs annual report as statement of earnings; the statement of shareholders equity; and the consolidated balance sheet. In this transaction analysis, record the transactions and adjustments described below directly into the financial statements. Start with the three financial statements (income statement, retained earnings portion of statement of stockholders' equity, balance sheet), entering the 2006 numbers for those financials. Then record the transactions and adjustments, using a column to record each, to the right of the 2006 numbers.

You need not prepare an accounting equation worksheet. As transactions are recorded, be sure the financial statements are updated accordingly; arriving at final balances after all transactions have been recorded. Please make one change to the balance sheet. The balance sheet shows-

1 Kellogg's borrowed $2,400 million, issuing long-term debt.

2 Inventories sold during the period, on account, terms 2/10, n/30, $480 million.

The cost of these inventories was $192 million.

3 Salaries paid, $432.2 million.

4 Received payment from $500 million of accounts receivables. Terms for these receivables were 2/10, n/30, and they were paid within the 10-day discount period.

5 Defective inventories were returned to Kellogg. Their sales price was $38 million and their cost was $14.3 million. Accounts receivable was credited for these customers. Because these inventories were defective (milk was mistakenly added to each box of cereal), they were not returned to inventory.

6 Cash receipts from customer accounts receivables, not within the 10-day discount period totaled $11.8 million.

7 Declared and paid cash dividends of $403.9 million.

8 Payments on debt (current maturities), reduction in the principle amount of the debt totaled $204.4 million (reduction in debt), payment for interest $22 million (interest expense) total paid, $226.4 million.

9 Acquired additional inventories, on account, $528.9, terms 3/10, n/45.

10 Made cash payments of $400.0 on the inventories purchased in #9, within the discount period.

11 Paid the remainder owed from #9, not within the discount period.

12 Kellogg's purchases equipment and buildings, $34 million, financing with notes payable.

13 Year end depreciation on property, $112 million.

14 Poorly trained employees accidentally placed Cocoa Puffs in Eggos boxes, and vice versa. As a result, $111.3 of inventories had to be destroyed and written off.

15 Other current liabilities include unearned revenues of $458.0 resulting from gift certificates purchased by customers, not yet redeemed. $215 are redeemed in this transaction (cost of the inventories sold was $110.

16 Cash sales of inventories $816 million, cost of sales $612 million.

17 Kellogg uses FIFO in costing and counting raw materials inventories. An examination of purchase invoices shows raw materials purchases during the year as follows: December 17, 72 million pounds @ $.50 per pound; Nov. 22, 120 million pounds @ $.46 per pound; Oct. 29, 270 million pounds @ $.44 per pound; Oct. 1, 1,809 million pounds @ $.20 per pound, Aug. 8, 642 million pounds @ $.18 per pound, June 2, 180 million pounds @ $.17 per pound. A physical count of raw materials shows 665 million pounds were in warehouses at December 31. Adjust cost of goods sold for the correction to inventories.

18 A lower of cost or market comparison is then made, and it is determined that some of the inventories need to be written down further, to market, the write-down totals $43 million.

19 Year end estimate of bad debts, based on an analysis of accounts receivable, is $79 million.

Reference no: EM13844672

Questions Cloud

Explain the role of culture in how institutions are shaped : Explain the role of culture in how these institutions are shaped
Current environmental policy for critical evaluation : What market deficiencies problem is the government trying to rectify - How successful is the current policy in rectifying the problem?
The work environment in the mills : In what ways did working in the Lowell Mills shape a young woman's self-image, world paradigm, and redefine her place in the society. Consider the following questions as you respond. The work environment in the Mills
Why a landfill coming to your community will be harmful : An introduction stating your foundation as to why a landfill coming to your community will be harmful, instead of beneficial, A minimum of five disadvantages to bringing the landfill to Williamsville, MEE 5901, Advanced Solid Waste Management
Prepare an accounting equation worksheet : You need not prepare an accounting equation worksheet. As transactions are recorded, be sure the financial statements are updated accordingly.
Research paper on teenage pregnancy : RESEARCH PAPER ON TEENAGE PREGNANCY-Must create a picot question: comprehensive sex education vs. Abstinence
Additional amounts to take advantage of quantity discounts : What trade-offs are involved in each of these aspects of inventory management? Buying additional amounts to take advantage of quantity discounts. Treating holding cost as a percentage of unit prices instead of as a constant amount.
Product should be manufactured to maximize profits : Andrew McCarroll is trying to determine how many units each of two cordless telephones to produce each day. One of these is the standard model; the other one is the deluxe model. The profit per unit on the standard model is $40, on the deluxe model $..
What supply chain logistics alternatives : What supply chain logistics alternatives are available in JIT environments? How does each work in a make-to-stock versus a make-to-order environment? What objective customer service measurements are available in JIT environments? Compare and contrast..

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd