{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter_02

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

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

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."

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

View Full Document
quire that  xcel.
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!

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

View Full Document
Chapter 2 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!
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}