Question

The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales.

CROSBY, INC. 2017 Income Statement
Sales				$	980,760
Costs					792,960
Other expenses					20,060
Earnings before interest and taxes				$	167,740
Interest paid					14,740
Taxable income				$	153,000
Taxes (21%)					32,130
Net income				$	120,870
Dividends	$	39,250
Addition to retained earnings		81,620

CROSBY, INC. Balance Sheet as of December 31, 2017
Assets				Liabilities and Owners’ Equity
Current assets				Current liabilities
Cash	$	27,920		Accounts payable	$	71,720
Accounts receivable		42,630		Notes payable		17,620
Inventory		95,910		Total	$	89,340
Total	$	166,460		Long-term debt	$	170,000
Fixed assets				Owners’ equity
Net plant and equipment	$	455,980		Common stock and paid-in surplus	$	140,000
				Retained earnings		223,100
				Total	$	363,100
Total assets	$	622,440		Total liabilities and owners’ equity	$	622,440

What is the EFN if the firm was operating at only 80 percent of capacity in 2017? Assume that fixed assets are sold so that the company has a 100 percent asset utilization. (A negative answer should be indicated by a minus sign.)

Answer 1

E17 H AMOUNT 2 $ 86,064 $ 17,620 $ 103,684 $ 170,000 X ✓ fc =(SUM(F3:F5)+C2*E15)-H13 A B C D E F 1 Income Statement ASSETS AMOUNT LIABILITIES & SHAREHOLDER'S EQUITY Sales $ 1,176,912 CURRENT ASSETS: LIABILITIES: 3 Less: Costs $ 951,552 Cash $ 33,504 Account Payable 4. Less: Other expenses $ 24,072 Account Receivable $ 51,156 Notes Payable 5 EBIT $ 201,288 Inventory $ 115,092 6 Less: Interest $ 14,740 Total EBT $ 186,548 Total $ 199,752 Long Term Debt 8 Less: Tax @ 21% $ 39,175 FIXED ASSETS: Net income $ 147,373 Net plant and equipment $ 547,176 SHAREHOLDER'S EQUITY 10 Less: Dividends $ 47,856 Common Shareholder's Equity 11 Retained Earnings $ 99,517 Accumulated Retained Earnings Total 13 TOTAL OF ASSETS $ 746,928 TOTAL OF LIABILITES & SAHREHOLDER'S EQUITY 14 15 Full capacity ratio 0.37194 =455980/(980760/80%) 16 17 External financing is needed (EFN)| 9 $ 140,000 $ 322,617 $ 462,617 $ 736,301 | 12 $98,808

Please rate thumbs up