Question

Given the financial statements below for Dragonfly Enterprises, what is the external financing need for a pro forma increase in sales of 25% if the firm is operating at 92% capacity? Enter your answer as the nearest whole (e.g., 123), but do not include the $ sign.

  

Dragonfly Enterprises
Income Statement ($ Million)		2011
Sales		370
Cost of Goods Sold		226
Selling, General, & Admin Exp.		62
Depreciation		20
Earnings Before Interest & Taxes		62
Interest Expense		12
Taxable Income		50
Taxes at 40%		20
Net Income		30
Dividends		9
Addition to Retained Earnings		21
Balance Sheets as of 12-31
Assets	2010	2011
Cash	10	10
Account Receivable	46	50
Inventory	43	45
Total Current Assets	99	105
Net Fixed Assets	166	195
Total Assets	265	300
Liabilities and Owners Equity	2010	2011
Accounts Payable	26	30
Notes Payable	0	0
Total Current Liabilities	26	30
Long-Term Debt	140	150
Common Stock	22	22
Retained Earnings	77	98
Total Liab. and Owners Equity	265	300

Answer 1

Current dividend payout = 9/30 = 0.3 of Net Income

Retained earnings are forecasted as follows

Income Statement ($ Million)		2011	Forecast
Sales		370	462.5
Cost of Goods Sold		226	282.5
Selling, General, & Admin Exp.		62	77.5
Depreciation		20	20
Earnings Before Interest & Taxes		62	57.5
Interest Expense		12	12
Taxable Income		50	45.5
Taxes at 40%		20	18.2
Net Income		30	27.3
Dividends		9	8.19
Addition to Retained Earnings		21	19.11

Forecasted sales = 370*125%=462.5

Full capacity sales = 370*100/92 = 402.1739

Since the full capacity sales< Forecasted sales,

EFN= Change in current assets- Change in spontaneous liabilities -Retained earnings

= 105*25% - 30*25% -19.11

=-0.36

WORKINGS