Question: 2009 Income Statement Sales $2,000 Variable Cost $1,200 Fixed Cost $700 Earnings before Interest and Taxes(EBIT) $100 Interest $16 Earnings before taxes $84 Taxes $33.60

2009 Income Statement
Sales $2,000
Variable Cost $1,200
Fixed Cost $700
Earnings before Interest and Taxes(EBIT) $100
Interest $16
Earnings before taxes $84
Taxes $33.60
Net Income $50.40
Dividends $15.12
Addition to Reatined Earnings $35.28
2009 Balance Sheet
Cash and Securities $20 Accounts Payable and Accruals $100
Accounts Receivables $240 Notes Payable $100
Inventories $240 Total Current Liabilities $200
Total Current Assets $500
Long Term Debt $100
Net Fixed Assets $500 Common Stock $500
Retained Earnings $200
Total Assets $1,000 Total Liabilities and Equity $1,000

2009 Key Ratios
NWC INDUSTRY
Profit Margin 2.52% 4%
Return on Equity 7.20% 15.60%
Days Sales Outstanding(360 Days) 43.20 days 32 days
Inventory Turnover 5.00X 8.00X
Fixed Assets Turnover 4.00X 5.00X
Total Assets Turnover 2.00X 2.50X
Total Debt Ratio 30% 36%
Times Interest Earned 6.25X 9.40x
Current ratio 2.50X 3.00x
Payout Ratio 30% 30%

1) Assume that NWC was operating at full capacity in 2009 with respect to all assets. Estimate the 2010 financial requirement using the projected financial statement approach (External financing needs). Assume that (1) each type of asset as well as payable, accruals, and fixed and variable costs grow at the same rate as sales; (2) the payout ratio and tax rate will be held constant.

2) Suppose you now learn that NWCs fixed assets were operated at only 75% of capacity. How would the existence of excess capacity in fixed assets affect the additional funds needed during 2010?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!