Prepare a schedule in excel to correct the net income

Assignment Help Financial Accounting

Reference no: EM131145867

Present your solution to the following problem in an Excel document.

The 2009 and 2010 financial statements of Daffney Company contain the following errors:

1. The ending inventory was overstated by $10,000 on December 31, 2009 and overstated by $7,000 on December 31, 2010.

2. A four-year insurance policy which cost $22,000 was charged to insurance expense when it was paid in advance on January 1, 2009.

3. Depreciation for equipment in the amount of $15,000 was not included in the 2009 financial statements.

4. A new roof and windows in the amount of $30,000 which are classified as capital expenditures were charged to expense in 2009 for a building. In turn, this caused depreciation in the amount of $5000, which was not recorded in the financial statements for 2010.

5. There were $10,000 of wages earned by employees in 2009 and not paid until 2010; these were recorded as an expense in 2009 instead of 2010.

Daffney Company reported net income of $100,000 in 2009 and $110,000 in 2010.

Please prepare a schedule in Excel to correct the net income for 2009 and 2010. Please start the schedule with the reported income for 2009 and 2010 and then work to a corrected figure. For this exercise, do not pay attention to income taxes.

Reference no: EM131145867

Questions Cloud

How does the pattern of cash dividend payments change over : List the five stages of the industry life cycle. How does the pattern of cash dividend payments change over the cycle? (A general statement is all that is required.)

What is the implication for the investor : Do leading indicators tend to give longer warnings before peaks or before troughs? What is the implication for the investor?

Explain three business risks or threats that might threaten : Explain three business risks or threats that might threaten Whole Foods ability to accomplish their financial goals for the next 3 years. Use examples and references to support your response.

How much risk-free arbitrage profit could you make on 1 : Suppose you observe the following 1-year interest rates, spot exchange rates and futures prices. Futures contracts are available on €10,000. How much risk-free arbitrage profit could you make on 1 contract at maturity from this mispricing?

Prepare a schedule in excel to correct the net income : Please prepare a schedule in Excel to correct the net income for 2009 and 2010. Please start the schedule with the reported income for 2009 and 2010 and then work to a corrected figure.

Which do you consider to be the easiest to avoid or fix : Monroe and Cox provide eight pricing practices of companies that have a negative effect on profitability. Which do you consider to be the easiest to avoid or fix?

Describe the three guidelines for costing system refinement : Describe the three guidelines for costing system refinement. Explain what an activity based approach to designing a costing system would entail and contain.

Determine the optimal values of the decision variables : Solve the problem using graphical linear programming and answer the question. use simultaneous equations to determine the optimal values of the decision variables.

Define the process you would use to manage costs : Using activity based costing and management, define the process you would use to manage costs and the overall efforts associated with these activities in your business.

User Account

All Pages