Question

In: Finance

2. More on the AFN (Additional Funds Needed) equation Blue Elk Manufacturing reported sales of $743,000...

2. More on the AFN (Additional Funds Needed) equation

Blue Elk Manufacturing reported sales of $743,000 at the end of last year, but this year, sales are expected to grow by 8%. Blue Elk expects to maintain its current profit margin of 24% and dividend payout ratio of 20%. The following information was taken from Blue Elk’s balance sheet:

Total assets: $400,000
Accounts payable: $65,000
Notes payable: $40,000
Accrued liabilities: $80,000

Based on the AFN equation, the firm’s AFN for the current year is _______ .

A positively signed AFN value represents:

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.

A shortage of internally generated funds that must be raised outside the company to finance the company’s forecasted future growth.

Because of its excess funds, Blue Elk Manufacturing is thinking about raising its dividend payout ratio to satisfy shareholders. Blue Elk could pay out _______ of its earnings to shareholders without needing to raise any external capital.(Hint: What can Blue Elk increase its dividend payout ratio to before the AFN becomes positive?)

Solutions

Expert Solution

1] AFN is given by the equation:
AFN = (A/S) x (Δ Sales) - (L/S) x (Δ Sales) - (PM x FS x (1-d))
where,
A / S = Assets that change directly with sales.
Δ sales = Change in sales
L / S = Liabilities that change directly with sales
PM = Profit Margin on Sales = net income / sales.
FS = Forecasted Sales
d = dividend payout ratio
(1 - d) = retention ratio
Substituting required values in the above equation we have,
Additional funds needed = (400000/743000)*743000*8%-(145000/743000)*743000*8%-743000*108%*24%*(1-20%) = $           (133,668)
Based on the AFN equation, the firm’s AFN for the current year =. $           (133,668)
2] A positively 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.
3] Equate AFN to 0, with payout ratio as the unknown figure.
0 = (400000/743000)*743000*8%-(145000/743000)*743000*8%-743000*108%*24%*(1-p), where p = payout ratio
Solving for p:
743000*108%*24%*(1-p) = (400000/743000)*743000*8%-(145000/743000)*743000*8% =
192585.6*(1-p) = 20400
1-p = 20400/192585.6 = 10.59%
p = 1-10.59% = 89.41%
Blue Elk could pay out 89.41% of its earnings to shareholders without needing to raise any external capital.

Related Solutions

More on the AFN (Additional Funds Needed) equation Bohemian Manufacturing Company reported sales of $720,000 at...
More on the AFN (Additional Funds Needed) equation Bohemian Manufacturing Company reported sales of $720,000 at the end of last year; but this year, sales are expected to grow by 6%. Bohemian expects to maintain its current profit margin of 24% and dividend payout ratio of 15%. The firm’s total assets equaled $425,000 and were operated at full capacity. Bohemian’s balance sheet shows the following current liabilities: accounts payable of $75,000, notes payable of $35,000, and accrued liabilities of $70,000....
2. More on the AFN (Additional Funds Needed) equation Fuzzy Button Clothing Company reported sales of...
2. More on the AFN (Additional Funds Needed) equation Fuzzy Button Clothing Company reported sales of $743,000 at the end of last year; but this year, sales are expected to grow by 6%. Fuzzy Button expects to maintain its current profit margin of 20% and dividend payout ratio of 10%. The firm’s total assets equaled $475,000 and were operated at full capacity. Fuzzy Button’s balance sheet shows the following current liabilities: accounts payable of $65,000, notes payable of $40,000, and...
Blue Elk Manufacturing reported sales of $743,000 at the end of last year; but this year,...
Blue Elk Manufacturing reported sales of $743,000 at the end of last year; but this year, sales are expected to grow by 6%. Blue Elkexpects to maintain its current profit margin of 22% and dividend payout ratio of 20%. The firm’s total assets equaled $500,000 and were operated at full capacity. Blue Elk’s balance sheet shows the following current liabilities: accounts payable of $80,000, notes payable of $35,000, and accrued liabilities of $60,000. Based on the AFN (Additional Funds Needed)...
3. More on the AFN (Additional Funds Needed) equation Fuzzy Button Clothing Company reported sales of...
3. More on the AFN (Additional Funds Needed) equation Fuzzy Button Clothing Company reported sales of $743,000 at the end of last year, but this year, sales are expected to grow by 10%. Fuzzy Button expects to maintain its current profit margin of 23% and dividend payout ratio of 15%. The following information was taken from Fuzzy Button’s balance sheet: Total assets: $500,000 Accounts payable: $80,000 Notes payable: $45,000 Accrued liabilities: $75,000 a) Based on the AFN equation, the firm’s...
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.
1. The Additional Funds Needed (AFN) equation Cold Duck Manufacturing Inc. has the following end-of-year balance...
1. The Additional Funds Needed (AFN) equation Cold Duck Manufacturing Inc. has the following end-of-year balance sheet: Cold Duck Manufacturing Inc. Balance Sheet For the Year Ended on December 31 Assets Liabilities Current Assets: Current Liabilities: Cash and equivalents $150,000 Accounts payable $250,000 Accounts receivable 400,000 Accrued liabilities 150,000 Inventories 350,000 Notes payable 100,000 Total Current Assets $900,000 Total Current Liabilities $500,000 Net Fixed Assets: Long-Term Bonds 1,000,000 Net plant and equipment $2,100,000 Total Debt $1,500,000 (cost minus depreciation) Common...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year,...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year, sales are expected to grow by 7%. Blue Elk expects to maintain its current profit margin of 21% and dividend payout ratio of 30%. The following information was taken from Blue Elk’s balance sheet: Total assets: $400,000 Accounts payable: $80,000 Notes payable: $35,000 Accrued liabilities: $70,000 Based on the AFN equation, the firm’s AFN for the current year is _________. a. -86,174 b. -105,324...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year,...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year, sales are expected to grow by 8%. Blue Elk expects to maintain its current profit margin of 23% and dividend payout ratio of 10%. The following information was taken from Blue Elk’s balance sheet: Total assets: $400,000 Accounts payable: $80,000 Notes payable: $45,000 Accrued liabilities: $80,000 Based on the AFN equation, the firm’s AFN for the current year is _____ . A positively signed...
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,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT