Question

Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next...

Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions.

Last year's sales = S0 $350 Last year's accounts payable $40
Sales growth rate = g 30% Last year's notes payable $50
Last year's total assets = A0* $540 Last year's accruals $30
Last year's profit margin = PM 5% Target payout ratio 60%

Select the correct answer.

a. $129.6
b. $127.3
c. $131.9
d. $134.2
e. $125.0
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Additional Funds Needed [AFN] for the coming year

Expected Next Year Sales

Expected Next Year Sales = Last year sales x (1 + Growth Rate)

= $350 Million x (1 + 0.30)

= $350 Million x 1.30

= $455.00 Million

After Tax profit Margin

After Tax profit Margin = Expected Next Year Sales x Profit Margin

= $455.00 Million x 5.00%

= $22.75 Million

Dividend Pay-out

Dividend Pay-out = After Tax profit Margin x Dividend Pay-out Ratio

= $22.75 Million x 60%

= $13.65 Million

Additions to Retained Earnings

Additions to Retained Earnings = After Tax profit Margin - Dividend Pay-out

= $22.75 Million - $13.65 Million

= $9.10 Million

Increase in Total Assets

Increase in Total Assets = Total Assets x Percentage of Increase in sales

= $540 Million x 30%

= $162.00 Million

Increase in Spontaneous liabilities

Increase in Spontaneous liabilities = [Accounts Payable + Accruals] x Percentage of Increase in sales

= [$40 Million + $30 Million] x 30%

= $70 Million x 30%

= $21.00 Million

Additional Funds Needed [AFN]

Therefore, the Additional Funds Needed [AFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings

= $162.00 Million - $21.00 Million - $9.10 Million

= $131.90 Million

“Hence, the Additional Funds Needed (AFN) for the coming year will be $131.90 Million “

Add a comment
Know the answer?
Add Answer to:
Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year

    (a) Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions.Last year's sales = S0$350Last year's accounts payable$40Sales growth rate = g30%Last year's notes payable$50Last year's total assets...

  • (a) Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations...

    (a) Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions. Last year’s sales = S0 $350 Last year's accounts payable $40 Sales growth rate = g 30%...

  • NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.)   Daniel Sawyer, the CEO of the Sawyer...

    NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.)   Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions. Last year's sales = S0 $350 Last year's accounts...

  • Reno is initiating planning for the company's operations next year, and he wants you to forecast...

    Reno is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions. Last year's sales = $250 Sales growth rate = 28% Last year's total assets = $450 Last year's profit margin = 4% Last year's accounts...

  • If u stock's dividend is expected to grow at a constant rate of 5% a year,...

    If u stock's dividend is expected to grow at a constant rate of 5% a year, which of the following statements is CORRECT? The stock is in equilibrium. O The stock's dividend yield is 5% The price of the stock is expected to decline in the future. The stock's required retum must be equal to or less than 5% O The stock's price one year from now is expected to be 5% above the current price. O The expected return...

  • Help this is due in 20 minssss Gerald Stanton, the CEO of the Stanton Group, is...

    Help this is due in 20 minssss Gerald Stanton, the CEO of the Stanton Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). 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? Dollars are in millions. Last year's sales (So-$350 Sales growth rate (g)-26% Last year's total...

  • 16. Chua Chang & Wu Inc. is planning its operations for next year, and the CEO...

    16. Chua Chang & Wu Inc. is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? $200,000 Last year's sales = So Sales growth rate =g Last year's total assets = Ao* Last year's profit margin =PM 40% $127,500 20.0% Last year's accounts $50,000 payable Last year's notes...

  • ChangWu Inc. is planning its operations for next year, and the CEO wants you to forecast...

    ChangWu Inc. is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN) using data shown below. What is the additional funds needed (AFN) for the coming year? Last yr's sales = S0 $200,000 Last yr's accounts payable $50,000 Sales growth rate = g 40% Last yr's notes payable $15,000 Last yr's total assets = A*0 $162,500 Last year's accruals $20,000 Last yr's profit margin = M 20.0% Target payout ratio...

  • 1. In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast...

    1. 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,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT