Outlaws is a general goods retail chain in the High Plains region. Forecast the financial statements for Outlaws for Year 7. Use the percent of sales method based on Year 6 and the assumptions listed below. Please note the ratios provided in the table which are useful for making the forecast. Sales growth of 5.5%. The cost of debt is 6.25%. The tax rate is 35%. The depreciation rate is 6%. CAPEX is $300 Million. The following accounts are constant: Goodwill and common stock. Long term debt is the PLUG variable. No dividends.
Forecast the financial statements for Outlaws. What are the additional funds needed (AFN)in Year 7? The AFN is the change in the plug account from Year 6 to Year 7.
\(\begin{array}{|c|c|c|c}
\hline & \text { Year 6 } & \text { Ratios } & \text { Forecast } \
\hline \text { Revenue } & \$ 29,210 & & \$ 30,817 \
\hline \text { COGS } & 22,152 & 0.758370 & \
\hline \text { SG\&A } & 5,245 & 0.179562 & \
\hline \text { Dep. Exp. } & 621 & & \
\hline \text { EBIT } & 1,192 & & \
\hline \text { Int. Exp. } & 277 & & \
\hline \text { EBT } & 915 & & \
\hline \text { Inc. Taxes } & 288 & & \
\hline \text { Net Income } & \$ 627 & & \
\hline\mathbf { \text { ASSETS }} & \mathbf {\text { Year } 6 }& \mathbf {\text { Ratios } }& \mathbf {\text { Forecast } }\
\hline \text { Total Current Assets } & \$ 4,385 & 0.150120 & \
\hline \text { PP\&E } & 9,637 & & \
\hline \text { Goodwill } & 678 & & 678 \
\hline \text { Total Assets } & \$ 14,700 & & \
\hline \text { LIABILITIES AND } & & & \
\text { OWNR'S EQUITY } & & & \
\hline \text { Total Current Liabilities } & 3,651 & 0.124991 & \
\hline \text { Long Term Debt } & 4,208 & & \
\hline \text { Total Liabilities } & \$ 7,859 & & \
\hline \text { Owner's Equity } & & & \
\hline \text { Common Stock } & 1,192 & & 1,192 \
\hline \text { Retained Earnings } & 5,089 & & \
\hline \text { Total Owner's Equity } & 6,281 & & \
\hline \text { Total Liabilities \& Owner's } & & & \
\text { Equity } & \$ 14,700 & & \
\hline
\end{array}\)

Question

Outlaws is a general goods retail chain in the High Plains region. Forecast the financial statements for Outlaws for Year 7. Use the percent of sales method based on Year 6 and the assumptions listed below. Please note the ratios provided in the table which are useful for making the forecast. Sales growth of 5.5%. The cost of debt is 6.25%. The tax rate is 35%. The depreciation rate is 6%. CAPEX is $300 Million. The following accounts are constant: Goodwill and common stock. Long term debt is the PLUG variable. No dividends.
Forecast the financial statements for Outlaws. What are the additional funds needed (AFN)in Year 7? The AFN is the change in the plug account from Year 6 to Year 7.
\(\begin{array}{|c|c|c|c}
\hline & \text { Year 6 } & \text { Ratios } & \text { Forecast } \
\hline \text { Revenue } & \$ 29,210 & & \$ 30,817 \
\hline \text { COGS } & 22,152 & 0.758370 & \
\hline \text { SG\&A } & 5,245 & 0.179562 & \
\hline \text { Dep. Exp. } & 621 & & \
\hline \text { EBIT } & 1,192 & & \
\hline \text { Int. Exp. } & 277 & & \
\hline \text { EBT } & 915 & & \
\hline \text { Inc. Taxes } & 288 & & \
\hline \text { Net Income } & \$ 627 & & \
\hline\mathbf { \text { ASSETS }} & \mathbf {\text { Year } 6 }& \mathbf {\text { Ratios } }& \mathbf {\text { Forecast } }\
\hline \text { Total Current Assets } & \$ 4,385 & 0.150120 & \
\hline \text { PP\&E } & 9,637 & & \
\hline \text { Goodwill } & 678 & & 678 \
\hline \text { Total Assets } & \$ 14,700 & & \
\hline \text { LIABILITIES AND } & & & \
 \text { OWNR'S EQUITY } & & & \
\hline \text { Total Current Liabilities } & 3,651 & 0.124991 & \
\hline \text { Long Term Debt } & 4,208 & & \
\hline \text { Total Liabilities } & \$ 7,859 & & \
\hline \text { Owner's Equity } & & & \
\hline \text { Common Stock } & 1,192 & & 1,192 \
\hline \text { Retained Earnings } & 5,089 & & \
\hline \text { Total Owner's Equity } & 6,281 & & \
\hline \text { Total Liabilities \& Owner's } & & & \
 \text { Equity } & \$ 14,700 & & \
\hline
\end{array}\)

Quizplus · Accepted Answer

The AFN is the change in the plug account from Year 6 to Year 7. In this case, the plug account is Long Term Debt. The Long Term Debt in Year 6 is $4,208 million and the Long Term Debt in Year 7 is $4,589 million. Therefore, the AFN is $4,589 million - $4,208 million = -$381 million.

Outlaws Is a General Goods Retail Chain in the High