17 Case model - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

View Full Document Right Arrow Icon
17 Case model 3/22/2010 7:10 Chapter 17. Financial Planning and Forecasting INPUT DATA (for New World Chemicals) (MILLIONS OF DOLLARS) A. BALANCE SHEETS 2005 2006E Assets Cash and securities $20 $25 Accounts receivable 240 300 Inventory 240 300 Total current assets $500 $625 Net fixed assets 500 625 Total assets $1,000 $1,250 Liabilities and equity $100 $125 Notes payable 100 190 Total current liabilities $200 $315 Long-term debt 100 190 Common stock 500 500 Retained earnings 200 245 Total liabilities and equity $1,000 $1,250 B. INCOME STATEMENTS 2005 2006E Sales $2,000.00 $2,500.00 Less: variable costs 1,200.00 1,500.00 Fixed costs 700.00 875.00 EBIT $100.00 $125.00 Interest 16.00 16.00 EBT $84.00 $109.00 Taxes 40% 33.60 43.60 Net Income $50.40 $65.40 Dividends (30%) $15.12 $19.62 Addition to Retained Earnings $35.28 $45.78 This spreadsheet model is designed to be used in conjunction with the chapter's integrated case and the related PowerPoint slide presentation. TABLE IC17-1 Financial Statements and other data on NWC A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
Background image of page 1

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

View Full DocumentRight Arrow Icon
C. KEY RATIOS INDUSTRY COMMENT Basic earning power 10.00% 10.00% 20.00% Profit margin 2.52% 2.62% 4.00% Return on equity 7.20% 8.78%
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

17 Case model - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

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