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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started