PS3_Spreadsheet

PS3_Spreadsheet - 183 Net income $195 $341 Total debt 1,106...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Ottawa Corporation Financial Statements, 2006 and Projected 2007 ($ millions) INCOME STATEMENT BALANCE SHEET Actual Projected Actual Projected 2006 2007 2006 2007 Sales $3,500 $4,025 Cash $150 $173 COGS 2,775 3,019 A/R 540 621 Operating expense 360 403 Inventory 1,050 1,208 EBIT 365 604 Total current assets 1,740 2,001 Interest expense 68 80 1,578 1,815 EBT 297 524 Total Assets 3,318 3,816 Tax 102
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 183 Net income $195 $341 Total debt 1,106 1,208 Shareholders' equity 2,212 2,416 Assumptions for 2007 Total liabilities & equity $3,318 $3,625 Sales growth rate 15.00% COGS/sales 75.0% Oper. Exp./sales 10.0% External funding required Dividend payout ratio 40.0% Sustainable growth rate Tax rate 35.0% Interest rate on debt 7.2% Total debt/equity 50.0%...
View Full Document

Ask a homework question - tutors are online