HW1 - Chapter 2 Problems 1-27 Input boxes in tan Output...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 2 Problems 1-27 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-In."
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
k"
Background image of page 2
Chapter 2 Question 1 Input area: Current assets $5,300 Net fixed assets 26,000 Current liabilities $3,900 Long-term debt 14,200 Output area: Balance sheet Current assets $5,300 Current liabilities $3,900 Net fixed assets 26,000 Long-term debt 14,200 Owner's equity 13,200 Total liabilities Total assets $31,300 +total equity $31,300 Owner's equity $13,200 Net working capital $1,400
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Question 2 Input area: Sales $493,000 Costs 210,000 Depreciation expense 35,000 Interest expense 19,000 Tax rate 35% Cash dividends $50,000 Output area: Income Statement Sales $493,000 Costs 210,000 Depreciation expense 35,000 EBIT $248,000 Interest expense 19,000 EBT $229,000 Taxes (35%) 80,150 Net income $148,850 Addition to retained earnings $98,850
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/14/2011 for the course ACC 345 taught by Professor Rerext during the Summer '11 term at Ohio State.

Page1 / 12

HW1 - Chapter 2 Problems 1-27 Input boxes in tan Output...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online