Question

ADDITIONAL FUNDS NEEDED

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

Morrissey Technologies Inc.: Balance Sheet as of December 31, 2016
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		Total liabilities and equity	$2,700,000

Morrissey Technologies Inc.: Income Statement for December 31, 2016
	Sales	$3,600,000
	Operating costs including depreciation	3,279,720
	EBIT	$320,280
	Interest	20,280
	EBT	$300,000
	Taxes (40%)	120,000
	Net Income	$180,000
	Per Share Data:
	Common stock price	$45.00
	Earnings per share (EPS)	$1.80
	Dividends per share (DPS)	$1.08

Suppose that in 2017, sales increase by 15% over 2016 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2016 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 89% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities-to-assets ratio currently is too low relative to the industry average.) The firm will raise 30% of the 2017 forecasted interest-bearing 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.
   

   Morrissey Technologies Inc. Pro Forma Income Statement December 31, 2017
   	2016		2017
   Sales	$3,600,000		$
   Operating costs (includes depreciation)	3,279,720
   EBIT	$320,280		$
   Interest expense	20,280
   EBT	$300,000		$
   Taxes (40%)	120,000
   Net Income	$180,000		$
   Dividends	$		$
   Addition to retained earnings	$		$

   Morrissey Technologies Inc. Pro Forma Balance Statement December 31, 2017
   	2016		2017
   Assets
   Cash	$180,000		$
   Accounts receivable	360,000
   Inventories	720,000
   Fixed assets	1,440,000
   Total assets	$2,700,000		$
   Liabilities and Equity
   Payables + accruals	$540,000		$
   Short-term bank loans	56,000
   Total current liabilities	$596,000		$
   Long-term bonds	100,000
   Total liabilities	$696,000		$
   Common stock	1,800,000
   Retained earnings	204,000
   Total common equity	$2,004,000		$
   Total liabilities and equity	$2,700,000		$

2. 
   
3. 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 other words, 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 1

Morrissey Technologies Inc. Pro Forma Income Statement December 31, 2017
	2016		2017
Sales	$36,00,000		$41,40,000
Operating costs (includes depreciation)	32,79,720		$36,84,600
EBIT	$3,20,280		$4,55,400
Interest expense	20,280		25245.09
EBT	$3,00,000		$4,30,155
Taxes (40%)	1,20,000		$1,72,062
Net Income	$1,80,000		$2,58,093
Dividends	$1,08,000		$1,54,856
Addition to retained earnings	$72,000		$1,03,237
	5%
Morrissey Technologies Inc. Pro Forma Balance Statement December 31, 2017
	2016		2017
Assets
Cash	$1,80,000		$5,31,000
Accounts receivable	3,60,000		414000
Inventories	7,20,000		7,20,000
Fixed assets	14,40,000		14,40,000
Total assets	$27,00,000		$31,05,000
Liabilities and Equity
Payables + accruals	$5,40,000		$7,37,307
Short-term bank loans	56,000		56,000
Notes Payable
Total current liabilities	$5,96,000		$7,93,307
Long-term bonds	1,00,000		1,38,193
Total liabilities	$6,96,000		$9,31,500
Common stock	18,00,000		18,66,263
Retained earnings	2,04,000		$3,07,237
Total common equity	$20,04,000		$21,73,500
Total liabilities and equity	$27,00,000		$31,05,000

The total debt =