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. $\begin{array}{l}
\begin{array}{lll}
\text { Last year's sales }=\mathrm{S}_{0} & \$ 350 & \text { Last year's accounts payal } &\$ 40 \
\text { Sales growth rate }=g & 30 \% & \text { Last year's notes payable } & \$ 50 \
\text { Last year's total assets }=\mathrm{A}_{0} * & \$ 500 & \text { Last year's accruals }& \$ 30 \
\text { Last year's profit margin }=\mathrm{PM} & 5 \% & \text { Target payout ratio } & 60 \%
\end{array}\
\begin{array}{r}
\end{array}
\end{array}$

Question

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. $\begin{array}{l}
\begin{array}{lll}
\text { Last year's sales }=\mathrm{S}_{0} & \$ 350 & \text { Last year's accounts payal } &\$ 40 \
\text { Sales growth rate }=g & 30 \% & \text { Last year's notes payable } & \$ 50 \
\text { Last year's total assets }=\mathrm{A}_{0} * & \$ 500 & \text { Last year's accruals }& \$ 30  \
\text { Last year's profit margin }=\mathrm{PM} & 5 \% & \text { Target payout ratio } & 60 \%
\end{array}\
\begin{array}{r}
\end{array}
\end{array}$

Quizplus · Accepted Answer

$\begin{array}{l} \text { Last year's sales }=\mathrm{S}_{0} & \$ 350\ \text { Sales growth rate }=\mathrm{g} & 30\% \ \text { Forecasted sales }=\mathrm{S}_{0} \times(1+\mathrm{g}) & \$455\ \Delta \mathrm{S}=\text { change in sales }=\mathrm{S}_{1}-\mathrm{S}_{0}=\mathrm{S}_{0} \times \mathrm{g} & \$105\ \text { Last year's total assets }=\mathrm{A}_{0}{ }^{*}=\mathrm{A}_{0}{ }^{*} \text { since full capacity } & \$500\ \text { Last year's accounts payable } & \$40\ \text { Last year's notes payable. Not spontaneous, } \ \quad \text { so does not enter AFN calculation } & \$50\ \text { Last year's accruals } & \$30\ L_{0}{ }^{*}=\text { payables }+\text { accruals } & \$70\ \text { Profit margin = M } &5.0\%\ \text { Target payout ratio }&60.0\% \end{array}$ AFN = (A₀^*/S₀)F1F1F1S1F1F1F10S F1F1F1S1F1F1F10 (L₀^*/S₀)F1F1F1S1F1F1F10S F1F1F1S1F1F1F10 Profit margin F1F1F1S1F1F1F10 S₁ F1F1F1S1F1F1F10 (1 F1F1F1S1F1F1F10 Payout) AFN = $150.0 F1F1F1S1F1F1F10 $21.0 F1F1F1S1F1F1F10 $9.1 = $119.9

Daniel Sawyer,the CEO of the Sawyer Group,is Initiating Planning for the Company's