Question

Green Caterpillar Garden Supplies Inc. reported sales of $720,000 at the end of last year; but this year, sales are expected to grow by 10%. Green Caterpillarexpects to maintain its current profit margin of 23% and dividend payout ratio of 30%. The firm’s total assets equalled $450,000 and were operated at full capacity. Green Caterpillar’s balance sheet shows the following current liabilities: accounts payable of $80,000, notes payable of $35,000, and accrued liabilities of $70,000. Based on the AFN (Additional Funds Needed) equation, what is the firm’s AFN for the coming year? -$121,890 -$97,512 -$102,388 -$107,263 A negatively-signed AFN value represents: a shortage of internally generated funds that must be raised outside the company to finance the company’s forecasted future growth. a point at which the funds generated within the firm equal the demands for funds to finance the firm’s future expected sales requirements. a surplus of internally generated funds that can be invested in physical or financial assets or paid out as additional dividends. Because of its excess funds, Green Caterpillar is thinking about raising its dividend payout ratio to satisfy shareholders. What percentage of its earnings can Green Caterpillar pay to shareholders without needing to raise any external capital? (Hint: What can Green Caterpillar increase its dividend payout ratio to before the AFN becomes positive?) 83.5% 79.3% 75.2% 58.5%

Answer 1

AFN = Assets*% increase in Sales – (Accounts payable+ Accruals)*% increase in sales – Increased sales*Profit Margin*(1-Payout ratio)

= 450,000*10% - (80,000+70,000)*10% - 720,000*110%*23%*70%

= -$97,512

Negative AFN represents

a surplus of internally generated funds that can be invested in physical or financial assets or paid out as additional dividends

Let the % paid be x

0 = 45000 – 150,000 – 720,000*110%*23%*(1-x)

0 = 30,000 – 182,160*(1-x)

X = 83.53%

i.e. 83.5%