(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% | Last year's notes payable | $50 |
Last year's total assets = A0* | $500 | Last year's accruals | $30 |
Last year's profit margin = PM | 5% | Target payout ratio | 60% |
(b) Weber Interstate Paving Co. had $450 million of sales and $225 million of fixed assets last year, so its FA/Sales ratio was 50%. However, its fixed assets were used at only 65% of capacity. If the company had been able to sell off enough of its fixed assets at book value so that it was operating at full capacity, with sales held constant at $450 million, how much cash (in millions) would it have generated?
Solution to the FIRST QUESTION
Additional Funds Needed [AFN] for the coming year
Expected Next Year Sales
Expected Next Year Sales = Last year sales x (1 + Growth Rate)
= $350 x (1 + 0.30)
= $350 x 1.30
= $455
After Tax profit Margin
After Tax profit Margin = Expected Next Year Sales x Profit Margin
= $455 x 5.00%
= $22.75
Dividend Pay-out
Dividend Pay-out = After Tax profit Margin x Dividend Pay-out Ratio
= $22.75 x 60%
= $13.65
Additions to Retained Earnings
Additions to Retained Earnings = After Tax profit Margin - Dividend Pay-out
= $22.75 – 13.65
= $9.10
Increase in Total Assets
Increase in Total Assets = Total Assets x Percentage of Increase in sales
= $500 x 30%
= $150.00
Increase in Spontaneous liabilities
Increase in Spontaneous liabilities = [Accounts Payable + Accruals] x Percentage of Increase in sales
= [$40 + $30] x 30%
= $70 x 30%
= $21.00
Additional Funds Needed [AFN]
Therefore, the Additional Funds Needed [AFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings
= $150.00 - $21.00 - $9.10
= $119.90
“Hence, the Additional Funds Needed (AFN) for the coming year will be $119.90”
PLEASE BE NOTED (More than 1 Question)
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 $350 Last year's accounts payable $40 Sales growth rate = g 30%...
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...
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 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, 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...
Weber Interstate Paving Co. had $450 million of sales and $225 million of fixed assets last year, so its FA/Sales ratio was 50%. However, its fixed assets were used at only 90% of capacity. If the company had been able to sell off enough of its fixed assets at book value so that it was operating at full capacity, with sales held constant at $450 million, how much cash (in millions) would it have generated? Select the correct answer.
Weber Interstate Paving Co. had $450 million of sales and $225 million of fixed assets last year, so its FA/Sales ratio was 50%. However, its fixed assets were used at only 75% of capacity. If the company had been able to sell off enough of its fixed assets at book value so that it was operating at full capacity, with sales held constant at $450 million, how much cash (in millions) would it have generated? Select the correct answer. a....
Weber Interstate Paving Co. had $450 million of sales and $225 million of fixed assets last year, so its FA/Sales ratio was 50%. However, its fixed assets were used at only 85% of capacity. If the company had been able to sell off enough of its fixed assets at book value so that it was operating at full capacity, with sales held constant at $450 million, how much cash (in millions) would it have generated? Select the correct answer. a....
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 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...