Additional funds needed

Morrissey Technologies Inc.'s 2014 financial statements are shown here.

Suppose that in 2015, sales increase by 15% over 2014 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2014 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its Operating costs/Sales ratio to 87.5% and increase its total debt-to-assets ratio to 30%. (It believes that its current debt ratio is too low relative to the industry average.) The firm will raise 30% of 2015 forecasted total debt as notes payable, and it will issue long-term bonds for the remainder. The firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 13%. Assume that any common stock issuances or repurchases can be made at the firm's current stock price of $45.

1. Construct the forecasted financial statements assuming that these changes are made. What are the firm's forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? Round your answers to the nearest cent.b. If the profit margin remains at 5% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In otherwords, what is the firm's sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.) Round your answer to two decimal places. ANSWER: %

Morrissey Technologies Inc.: Balance Sheet as of December 31, 2014 Cash $180,000 Accounts payable $360,000 Receivables 360,000 Notes payable 56,000 Inventories 720,000 Accrued liabilities 180,000 Total current assets $1,260,000 Total current liabilities $596,000 Long-term debt 100,000 Fixed assets 1,440,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 $2,700,000 Total liabilities and equity Morrissey Technologies Inc.: Income Statement for December 31, 2014 Sales $3,600,000 Operating costs including 3,279,720 depreciation EBIT $320,280 Interest 20,280 $300,000 120,000 Taxes (40%) Net Income $180,000 $45.00 Per Share Data: Common stock price Earnings per share (EPS) Dividends per share (DPS) $1.80 $1.08 Morrissey Technologies Inc. Pro Forma Income Statement December 31, 2015 2014 2015 Pro Forma Sales $3,600,000 $ 4140000 Operating costs (includes depreciation) 3,279,720 $ 3622500 EBIT $320,280 $ 517500 Interest expense 20,280 $ EBT $300,000 $ Taxes (40%) 120,000 $ Net Income $180,000 $ Dividends $ 108000 $ X Addition to RE $ $ $ Morrissey Technologies Inc. Pro Forma Balance Statement December 31, 2015 2014 2015 Pro Forma Cash $180,000 $ 207000 Accounts receivable 360,000 $ 414000 Inventories 720,000 $ 828000 Fixed assets 1,440,000 1656000 Total assets $2,700,000 3105000 Payables + accruals $540,000 $ Short-term bank loans 56,000 $ $ $ $ Total current liabilities $596,000 $ $ Long-term bonds 100,000 $ Total debt $696,000 $ Common stock 1,800,000 $ $ Retained earnings 204,000 $ Total common equity $2,004,000 $ $ 2173500 Total liab. and equity $2,700,000 $ $ 3105000