In: Finance
The Optical Scam Company has forecast a sales growth rate of 20
percent for next year. Current assets, fixed assets, and short-term
debt are proportional to sales. The current financial statements
are shown here:
  
| INCOME STATEMENT | |||||
| Sales | $ | 32,400,000 | |||
| Costs | 28,531,000 | ||||
| Taxable income | $ | 3,869,000 | |||
| Taxes | 1,354,150 | ||||
| Net income | $ | 2,514,850 | |||
| Dividends | $ | 1,005,940 | |||
| Addition to retained earnings | 1,508,910 | ||||
| BALANCE SHEET | |||||||
| Assets | Liabilities and Equity | ||||||
| Current assets | $ | 7,400,000 | Short-term debt | $ | 7,128,000 | ||
| Long-term debt | 3,969,000 | ||||||
| Fixed assets | 17,872,000 | ||||||
| Common stock | $ | 2,941,000 | |||||
| Accumulated retained earnings | 11,234,000 | ||||||
| Total equity | $ | 14,175,000 | |||||
| Total assets | $ | 25,272,000 | Total liabilities and equity | $ | 25,272,000 | ||
  
a. Calculate the external funds needed for next
year using the equation from the chapter. (Do not round
intermediate calculations.)
  
External financing needed      
    $   
  
b-1. Prepare the firm’s pro forma balance sheet
for next year. (Do not round intermediate
calculations.)
   
| BALANCE SHEET | |||||||
| Assets | Liabilities and equity | ||||||
| Current assets | $ | Short-term debt | $ | ||||
| Fixed assets | Long-term debt | ||||||
| Common stock | $ | ||||||
| Accumulated retained earnings | |||||||
| Total equity | $ | ||||||
| Total assets | $ | Total liabilities and equity | $ | ||||
b-2. Calculate the external funds needed.
(Do not round intermediate calculations.)
  
External financing needed      
    $  
c. Calculate the sustainable growth rate for the
company based on the current financial statements. (Do not
round intermediate calculations. Enter your answer as a percent
rounded to 2 decimal places, e.g., 32.16.)
  
Sustainable growth rate      
      %