CN Railways is North America's fifth largest railway. Forecast the financial statements for CN for Year 11. Use the percent of sales method based on Year 10 and the assumptions listed below. Please note the ratios to sales provided in the table which are useful for making the forecast. Sales growth of 10%. The cost of debt is 4.59%. The tax rate is 31.943%. The depreciation rate is 3%. CAPEX is $1,600 Million. The following accounts are constant: Intangible assets, Deferred taxes, and Common Stock. Long term debt is the PLUG variable. No dividends.
Forecast the financial statements for CN. What are the additional funds needed (AFN)in Year 11? The AFN is the change in the plug account from Year 10 to Year 11.
CN Railway Company
Income Statement and Balance Sheet
As of December 31, Year 10 ($ 000,000's)
\(\begin{array}{|c|c|c|c|}
\hline& \text { Year 10 } & \text { Ratios } & \text { Forecast } \
\hline \text { Revenue } & \$ 6,110 & & \$ 6,721 \
\hline \text { COGS } & 2,550 & 0,417349 & \
\hline \text { Dep. Exp. } & 499 & & \
\hline \text { SGRA } & 1,945 & 0.318331 & \
\hline \text { EBIT } & 1,116 & & \
\hline \text { Int. Exp. } & 277 & & \
\hline \text { Income before Taxes } & 839 & & \
\hline \text { Income Taxes } & 268 & & \
\hline \text { Net income } & \$ 571 & & \
\hline \text { ASSETS } & \text { Yar } 10 & \text { Ratios } & \text { Forecast } \
\hline \text { Total Current Assets } & 1,163 & 0.190344 & \
\hline \text { PP\&E } & 16,898 & & \
\hline \text { Intangible assets } & 863 & & 863 \
\hline \text { Total assets } & \$ 18,924 & & \
\hline \text { Total Current liabilities } & 2,134 & 0.349264 & \
\hline \text { Deferred Taxes } & 5,160 & & 5,160 \
\hline \text { Long-term debt } & 5,003 & & \
\hline \text { Common Stock } & 3,558 & & 3,558 \
\hline \text { Retained earnings } & 2,762 & & \
\hline \text { Total Owner's Equity } & 6,627 & & \
\hline \text { Total liabilities and Owner's } & & & \
\text { equity } & 18,924 & & \
\hline
\end{array}\)

Question

CN Railways is North America's fifth largest railway. Forecast the financial statements for CN for Year 11. Use the percent of sales method based on Year 10 and the assumptions listed below. Please note the ratios to sales provided in the table which are useful for making the forecast. Sales growth of 10%. The cost of debt is 4.59%. The tax rate is 31.943%. The depreciation rate is 3%. CAPEX is $1,600 Million. The following accounts are constant: Intangible assets, Deferred taxes, and Common Stock. Long term debt is the PLUG variable. No dividends.
Forecast the financial statements for CN. What are the additional funds needed (AFN)in Year 11? The AFN is the change in the plug account from Year 10 to Year 11.
CN Railway Company
Income Statement and Balance Sheet
As of December 31, Year 10 ($ 000,000's)
\(\begin{array}{|c|c|c|c|} 
\hline& \text { Year 10 } & \text { Ratios } & \text { Forecast } \ 
\hline \text { Revenue } & \$ 6,110 & & \$ 6,721 \
\hline \text { COGS } & 2,550 & 0,417349 & \
\hline \text { Dep. Exp. } & 499 & & \
\hline \text { SGRA } & 1,945 & 0.318331 & \
\hline \text { EBIT } & 1,116 & & \
\hline \text { Int. Exp. } & 277 & & \
\hline \text { Income before Taxes } & 839 & & \
\hline \text { Income Taxes } & 268 & & \
\hline \text { Net income } & \$ 571 & & \
\hline \text { ASSETS } &  \text { Yar } 10 & \text { Ratios } & \text { Forecast } \
\hline \text { Total Current Assets } & 1,163 & 0.190344 & \
\hline \text { PP\&E } & 16,898 & & \
\hline \text { Intangible assets } & 863 & & 863 \
\hline \text { Total assets } & \$ 18,924 & & \
\hline \text { Total Current liabilities } & 2,134 & 0.349264 & \
\hline \text { Deferred Taxes } & 5,160 & & 5,160 \
\hline \text { Long-term debt } & 5,003 & & \
\hline \text { Common Stock } & 3,558 & & 3,558 \
\hline \text { Retained earnings } & 2,762 & & \
\hline \text { Total Owner's Equity } & 6,627 & & \
\hline \text { Total liabilities and Owner's } & & & \
\text { equity } & 18,924 & & \
\hline
\end{array}\)

Quizplus · Accepted Answer

The Answer of CN Railways is North America's fifth largest railway. Forecast the financial statements for CN for Year 11. Use the percent of sales method based on Year 10 and the assumptions listed below. Please note the ratios to sales provided in the table which are useful for making the forecast. Sales growth of 10%. The cost of debt is 4.59%. The tax rate is 31.943%. The depreciation rate is 3%. CAPEX is $1,600 Million. The following accounts are constant: Intangible assets, Deferred taxes, and Common Stock. Long term debt is the PLUG variable. No dividends.
Forecast the financial statements for CN. What are the additional funds needed (AFN)in Year 11? The AFN is the change in the plug account from Year 10 to Year 11.
CN Railway Company
Income Statement and Balance Sheet
As of December 31, Year 10 ($ 000,000's)
\(\begin{array}{|c|c|c|c|} 
\hline& \text { Year 10 } & \text { Ratios } & \text { Forecast } \ 
\hline \text { Revenue } & \$ 6,110 & & \$ 6,721 \
\hline \text { COGS } & 2,550 & 0,417349 & \
\hline \text { Dep. Exp. } & 499 & & \
\hline \text { SGRA } & 1,945 & 0.318331 & \
\hline \text { EBIT } & 1,116 & & \
\hline \text { Int. Exp. } & 277 & & \
\hline \text { Income before Taxes } & 839 & & \
\hline \text { Income Taxes } & 268 & & \
\hline \text { Net income } & \$ 571 & & \
\hline \text { ASSETS } &  \text { Yar } 10 & \text { Ratios } & \text { Forecast } \
\hline \text { Total Current Assets } & 1,163 & 0.190344 & \
\hline \text { PP\&E } & 16,898 & & \
\hline \text { Intangible assets } & 863 & & 863 \
\hline \text { Total assets } & \$ 18,924 & & \
\hline \text { Total Current liabilities } & 2,134 & 0.349264 & \
\hline \text { Deferred Taxes } & 5,160 & & 5,160 \
\hline \text { Long-term debt } & 5,003 & & \
\hline \text { Common Stock } & 3,558 & & 3,558 \
\hline \text { Retained earnings } & 2,762 & & \
\hline \text { Total Owner's Equity } & 6,627 & & \
\hline \text { Total liabilities and Owner's } & & & \
\text { equity } & 18,924 & & \
\hline
\end{array}\)

CN Railways Is North America's Fifth Largest Railway A)$64 Million B)$165 Million C)$342 Million D)$580 Million E)$965 Million

CN Railways Is North America's Fifth Largest Railway A)$64 Million
B)$165 Million
C)$342 Million
D)$580 Million
E)$965 Million