Question

In: Accounting

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 = 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.

  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


Option a. -$9000

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.
Based on the data below, what is the AFN for Pear Computer at the end of...
Based on the data below, what is the AFN for Pear Computer at the end of next year? Sales growth rate 12% S0 $7,500 A0* $3,550 current operating assets A0*/ S0 47.330% required assets per $ in sales L0*               500 current spontaneous liabilities L0*/ S0 6.670% spontaneous liabilities per $ in sales Current Profit margin (M) 4.400% Most recent Payout ratio 22.730%
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...
a) AFN equation Broussard Skateboard's sales are expected to increase by 25% from $7.2 million in...
a) AFN equation Broussard Skateboard's sales are expected to increase by 25% from $7.2 million in 2016 to $9.00 million in 2017. Its assets totaled $3 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, 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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT