Question

In: Finance

In your internship with LLT Inc. you have been asked to forecast the firm's additional funds...

  1. In your internship with LLT 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? (5 points)

Last year's sales = S0

$200,000

Sales growth rate = g

40%

Last year's total assets = A0*

$135,000

Last year's profit margin = PM

20.0%

Last year's accounts payable

$50,000

Last year's notes payable

$15,000

Last year's accruals

$20,000

Target payout ratio

25.0%

Solutions

Expert Solution

Last Year:

Saes = $200,000
Total Assets = $135,000
Profit Margin = 20.00%

Retention Ratio = 1 - Payout Ratio
Retention Ratio = 1 - 0.25
Retention Ratio = 0.75

Spontaneous Current Liabilities = Accounts Payable + Accruals
Spontaneous Current Liabilities = $50,000 + $20,000
Spontaneous Current Liabilities = $70,000

Next Year:

Growth Rate = 40%

Sales = $200,000 * 1.40
Sales = $280,000

Net Income = Sales * Profit Margin
Net Income = $280,000 * 20.00%
Net Income = $56,000

Addition to Retained Earnings = Net Income * Retention Ratio
Addition to Retained Earnings = $56,000 * 0.75
Addition to Retained Earnings = $42,000

Increase in Total Assets = $135,000 * 40.00%
Increase in Total Assets = $54,000

Increase in Spontaneous Current Liabilities = $70,000 * 40.00%
Increase in Spontaneous Current Liabilities = $28,000

Additional Funds Needed = Increase in Total Assets - Increase in Spontaneous Current Liabilities - Addition to Retained Earnings
Additional Funds Needed = $54,000 - $28,000 - $42,000
Additional Funds Needed = -$16,000


Related Solutions

In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the...
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 =...
In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the...
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 =...
In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the...
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 =...
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,...
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,...
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 35%, which the firm's investment bankers have recommended. Based on the AFN equation,...
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 50%, which the firm's investment bankers have recommended. Based on the AFN equation,...
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 40%, which the firm's investment bankers have recommended. Based on the AFN equation,...
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 40%, which the firm's investment bankers have recommended. Based on the AFN equation,...
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 70%, which the firm's investment bankers have recommended. Based on the AFN equation,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT