Chapter_04 - Chapter 4 Input boxes in tan Output boxes in...

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

View Full Document Right Arrow Icon
Chapter 4 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 req the "Analysis ToolPak" or "Solver Add-In" be installed in Ex To install these, click on the Office button  then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and  "Solver Add-In," then click "OK."
Background image of page 1

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

View Full DocumentRight Arrow Icon
quire that  xcel.
Background image of page 2
Chapter 4 Question 5 Input area: Sales Current assets Current liabilities Costs Fixed assets Long-term debt Taxable income $- Equity Taxes - Total assets $- Total $- Net income $- Sales increase Payout ratio Tax rate Output area: Pro forma income statement Pro forma balance sheet Sales $- Current assets $- Current liabilities $- Costs - Fixed assets - Long-term debt - Taxable income $- Equity - Taxes (0%) - Total $- Total $- Net income $- Dividends $- Add. To RE $- External financing $-
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 6 Input area: Sales Current assets Costs Fixed assets Taxable income $- Total Taxes - Net income $- Payout ratio Tax rate Output area: Income statement Sales $- Current assets Costs - Fixed assets Taxable income $- Taxes
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.

Page1 / 12

Chapter_04 - Chapter 4 Input boxes in tan Output boxes in...

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