Question

In: Finance

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* $690 Last year's accruals $30
Last year's profit margin = PM 5% Target payout ratio 60%

Select the correct answer.

a. $180.4
b. $169.9
c. $173.4
d. $166.4
e. $176.9

Solutions

Expert Solution

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* $690 Last year's accruals $30
Last year's profit margin = PM 5% Target payout ratio 60%

Formula for Additional Funds Needed(AFN):-

AFN = (Total Assets/Last year's Sales)*Change in sales - (Spontaneous Liabilities/Last year's Sales)*Change in sales - [Forecasted Sales*Profit Margin*(1-Payout Ratio]

where, Change in Sales = Last year's sales*Sales growth rate

=$350 millions*30%

=$105 million

Spontaneous Liabilities = Accounts Payable + Accruals

=$40 million + $30 million

=$70 million

Note - (Notes Payable are not part of Spontaneous Liab)

Forecasted Sales = Last year's sales*(1+Sales growth rate)

=$350 million*(1+0.30)

=$455 million

Calculating AFN: (Amounts in millions)

= [($690/$350)*$105] - [($70/$350)*$105] - [$455*5%*(1-0.60)]

= $207 - $21 - $9.1

=$176.9

So, the AFN for the coming year is $176.9 millions

Hence, Option E

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating


Related Solutions

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...
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...
Bob, the CFO of Bob Supply Group, is initiating planning for the company’s operations next year,...
Bob, the CFO of Bob Supply 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 = $350    Last year’s accounts payable = $40 Sales growth rate = 20% Last...
Garret is initiating planning for the company's operations nextyear, and he wants you to forecast...
Garret 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 = $250Sales growth rate = 28%Last year's total assets = $450Last year's profit margin = 4%Last year's accounts payable = $30Last year's notes...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company 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? 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* $127,500 Last year's accruals $20,000 Last year's profit...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company 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? 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* $127,500 Last year's accruals $20,000 Last year's profit...
Chua Chang & Wu Inc. is planning its operations for next year, and the CEO wants...
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? 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* $127,500 Last year's accruals $20,000...
Clayton Industries is planning its operations for next year. Ronnie Clayton, the CEO, wants you to...
Clayton Industries is planning its operations for next year. Ronnie Clayton, 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? Dollars are in millions. Last year's sales = S0 $350 Last yr's accounts payable $40 Sales growth rate = g 30% Last yr's notes payable $50 Last year's total assets = A0* $360 Last yr's...
Question 1A A CEO of a multihospital system is planning to expand operations into various states....
Question 1A A CEO of a multihospital system is planning to expand operations into various states. It will take several years to get certificate of need (CON) approvals so that the new facilities can be constructed. The eventual cost (in millions of dollars) of building a facility will differ among states, depending upon finances, labor, and the economic and political climate. An outside consulting firm estimated the costs for the new facilities as based on declining, similar, or improving economies,...
Client X operates in the US currently and is planning to expand operations globally next year....
Client X operates in the US currently and is planning to expand operations globally next year. As a result, management is considering preparing financial statements in accordance with IFRS rather than with US GAAP. Client X contacted you for clarification and recommendations regarding the following issues: Whether interest cost on construction of a new warehouse may be included in the cost of the new warehouse.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT