Accounting AFN

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 = S₀	$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 = A₀*	$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.

a. - $9,000

b. - $9,010

c. - $9,030

d. - $9,020

e. - $8,990

Solutions

Expert Solution

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

Rahul Kumar Agarwal answered 3 years ago

Next > < Previous

Related Solutions

Question Briefly define the Additional Funds Needed (AFN) Equation Method. The AFN equation shows that external...

Question Briefly define the Additional Funds Needed (AFN) Equation Method. The AFN equation shows that external financing requirements depend on five key factors. Briefly define each.

What are the key factors on which external financing depends, asindicated by the AFN equation?...

What are the key factors on which external financing depends, as indicated by the AFN equation? Please explain your answer and give examples

5. Answer the following questions related to AFN. a. The following equation is sometimes used to...

5. Answer the following questions related to AFN. a. The following equation is sometimes used to forecast funding requirements: AFN= (A0*/S0)(S) – (L0*/S0)( S) – MS1(1- POR) What key assumption do we make when using this equation? Under what conditions might this assumption not hold? What would be the more general formula for AFN? b. Name five key factors that affect a firm’s external financing requirements. Explain how each one affects the requirements? c. What is meant by the term...

Use the AFN equation to forecast Broussard’s additiona lfunds needed for the coming year.

12.1 Broussard Skateboard’s sales are expected to increase by 15% from $8millionin 2013 to$ 9.2 million in 2014. Its assets totaled $5million at the end of 2013. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2013, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals .Theafter- tax profit marginis forecasted to be 6%, and the...

(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year....

(AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 65%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year...

AFN equation Broussard Skateboard's sales are expected to increase by 25% from $8.8 million in 2019...

AFN equation Broussard Skateboard's sales are expected to increase by 25% from $8.8 million in 2019 to $11.00 million in 2020. Its assets totaled $3 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to...

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington...

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 30%, which the firm's investment bankers have recommended. Based on the AFN equation,...

Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the...

Corporate Valuation and Financial Planning: Forecasted Financial Statements The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key ratios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its -Select-income statementcashflow statementcash budgetCorrect 1 of Item 1 which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry...

AFN EQUATION Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6...

AFN EQUATION Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $4 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%....

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington...

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 60%, which the firm's investment bankers have recommended. Based on the AFN equation,...

Subjects