Chapter_02 - Chapter 2 Input boxes in tan Output boxes in...

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

View Full Document Right Arrow Icon
Chapter 2 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 2 Questions 2-4 Input area: Sales Costs Depreciation expense Interest expense Tax rate Cash dividends Shares outstanding Output area: Income Statement Sales $- Costs - Depreciation expense - EBIT $- Interest expense - EBT $- Taxes (0%) - Net income $- Addition to retained earnings $- Earnings per share #DIV/0! Dividends per share #DIV/0!
Background image of page 3

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

View Full DocumentRight Arrow Icon
Question 6 Input area: Taxable income Taxable income 0 - 50,000 50,001 - 75,000 75,001 - 100,000 100,001 - 335,000 335,001 - 10,000,000 10,000,001 - 15,000,000 15,000,001 - 18,333,333 18,333,334 + Output area: Taxes: 0% $50,000 0% (50,000) 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 $- Average tax rate: $- = #DIV/0! 0
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/16/2011 for the course FIN 521 taught by Professor Varney during the Spring '11 term at Andrew Jackson.

Page1 / 13

Chapter_02 - Chapter 2 Input boxes in tan Output boxes in...

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

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