In: Accounting
In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year?
Last year's sales = S0 | $200,000 | Last year's accounts payable | $50,000 |
Sales growth rate = g | 40% | Last year's notes payable | $15,000 |
Last year's total assets = A0* | $152,500 | Last year's accruals | $20,000 |
Last year's profit margin = PM | 20.0% | Target payout ratio | 25.0% |
Select the correct answer.
|
|||
|
|||
|
|||
|
|||
|
AFN = Increased in Assets - Increased in Liabilities - Addition to Retained Earnings
= [Current Level of Spontaneous Assets * Sales Growth] - [Current Level of Spontaneous Liabilities * Sales Growth] - [New Level of Sales * Profit Margin * Retention Ratio]
= [$152,500 * 0.40] - [($50,000 + $20,000) * 0.40] - [{$200,000 * (1 + 0.40)} * 0.20 * (1 - 0.25)]
= $61,000 - $28,000 - $42,000 = -$9,000
Option a. -$9000
Option a. -$9000