Question

The most recent financial statements for Cardinal, Inc., are shown here: Income Statement Balance Sheet Sales $23,500 Assets $121,000 Debt $31,600 Costs 16,700 Equity 89,400 Taxable income $6,800 Total $121,000 Total $121,000 Taxes (24%) 1,632 Net income $5,168 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,560 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be $28,300. What is the external financing needed?

Answer 1

$20,370.5

Step-by-step explanation:

Net Profit Margin = Net Profit / Sales= 5,168 / 23500 = 0.219915 = 21.99%

Dividend Payout Ratio = Dividends / Net profit = $1,560/$5,168 = 0.3018576 = 30.19%

Increase in Assets = Total Assets / Current Sales * Change in Sales

Increase in Assets = 121,000 /23,500 * (28,300-23,500)

Increase in Assets = 5.1489362 * 4800

Increase in Assets = $24714.89

Increase in Current Liabilities = Current Liabilities / Current Sales * Change in Sales = 0

Earnings Retained = Revised sales * Net profit margin * (1- dividend payout ratio)

Earnings Retained = $28,300 * 21.99% * (1 - 30.19%)

Earnings Retained = $28,300 * 0.2199 * 0.6981

Earnings Retained = $4344.39497

Earnings Retained = $4344.39

External Financing Needed = Increase in Assets - Increase in Current Liabilities - Earnings Retained

External Financing Needed = $24714.89 - $0 - $4344.39

External Financing Needed = $20,370.5