Question: Use a sensitivity analysis to illustrate how much the NPV varies for reasonable changes of the key driver inputs. (Clearly explain your sensitivity analysis process.

 Use a sensitivity analysis to illustrate how much the NPV variesfor reasonable changes of the key driver inputs. (Clearly explain your sensitivityanalysis process. Which inputs did you change and why?) WACC Calculation CapitalStructure Debt-to-Total Capitalization Equity-to-Total Capitalization 56.4% 43.6% Cost of Debt Cost of

Use a sensitivity analysis to illustrate how much the NPV varies for reasonable changes of the key driver inputs. (Clearly explain your sensitivity analysis process. Which inputs did you change and why?)

WACC Calculation Capital Structure Debt-to-Total Capitalization Equity-to-Total Capitalization 56.4% 43.6% Cost of Debt Cost of Debt Tax Rate After-tax Cost of Debt \begin{tabular}{|r|} \hline 38.9% \\ \hline 4.7% \\ \hline \end{tabular} Cost of Equity Risk-free Rate (1) Market Risk Premium (2) Levered Beta Size Premium (3) Cost of Equity 12.2% WACC 8.0% Balance Sheet Cash and Cash Equivalents Accounts Receivable Inventories Deferred Income Tax and Qther \begin{tabular}{|c|r|r|r|} \hline 2002 & \multicolumn{1}{c}{2003} & \multicolumn{1}{c|}{2004} & \multicolumn{1}{c|}{2005} \\ \hline$171.1 & $249.1 & $174.8 & $276.9 \\ 225.4 & 254.5 & 238.5 & 256.7 \\ 839.6 & 860.9 & 992.2 & 961.6 \\ 51.6 & 100.3 & 83.4 & 120.5 \\ \hline $1,287.7 & $1,464.8 & $1,488.9 & $1,615.7 \\ \hline \end{tabular} Property. Plant and Equipment, net Goodwill, net Dther Long-Term Assets Total Assets Accounts Payable Customer Advances Dther Payables \begin{tabular}{|r|r|r|r|} \hline 218.5 & 189.4 & 202.3 & 217.4 \\ 45.0 & 68.3 & 73.3 & 99.0 \\ 106.6 & 197.5 & 89.7 & 111.6 \\ \hline $370.1 & $455.2 & $365.3 & $428.0 \\ \hline 500.0 & & & \\ 137.8 & 138.0 & 475.0 & 475.0 \\ 127.2 & 117.9 & 145.2 & 153.9 \\ \hline $1,135.1 & $1,211.2 & $1,084.7 & $1,173.2 \\ \hline 10.0 & & & \\ \hline 1,054.8 & 1,009.0 & 963.9 & 970.6 \\ {[133.5]} & {[127.7]} & {[109.2]} & {[99.5]} \\ \hline[16.9] & 32.3 & 54.0 & 26.5 \\ \hline $914.4 & $923.6 & $918.7 & $907.6 \\ \hline & & & \\ \hline $2.049.5 & $2,134.8 & $2,003.4 & $2.080.8 \\ \hline \hline \end{tabular} aah Net Working Capital (Increase) i Decrease in Net Working Capital \begin{tabular}{|r|r|r|r|} \hline 917.6 & 1,009.6 & 1,123.6 & 1,187.7 \\ \hline & {[92.0]} & {[114.0]} & {[64.1]} \\ \hline \end{tabular} Bulunce Sheef stssumptions Curent dssefs Days Sales Dutstanding (DSD) Days Inventory Held (DIH) Prepaid and Dther Current Assets [\% Change in Inventory Currentiabikies Days Payable Qutstanding (DPQ) Accrued Liabilities [\% of sales] Dther Current Liabilities [\% of sales] \begin{tabular}{llll} 62.2 & 53.6 & 59.2 & 56.9 \\ 3.3% & 4.8% & 5.2% & 6.3% \\ 7.7% & 13.7% & 6.3% & 7.2% \\ \hline \end{tabular} WACC Calculation Capital Structure Debt-to-Total Capitalization Equity-to-Total Capitalization 56.4% 43.6% Cost of Debt Cost of Debt Tax Rate After-tax Cost of Debt \begin{tabular}{|r|} \hline 38.9% \\ \hline 4.7% \\ \hline \end{tabular} Cost of Equity Risk-free Rate (1) Market Risk Premium (2) Levered Beta Size Premium (3) Cost of Equity 12.2% WACC 8.0% Balance Sheet Cash and Cash Equivalents Accounts Receivable Inventories Deferred Income Tax and Qther \begin{tabular}{|c|r|r|r|} \hline 2002 & \multicolumn{1}{c}{2003} & \multicolumn{1}{c|}{2004} & \multicolumn{1}{c|}{2005} \\ \hline$171.1 & $249.1 & $174.8 & $276.9 \\ 225.4 & 254.5 & 238.5 & 256.7 \\ 839.6 & 860.9 & 992.2 & 961.6 \\ 51.6 & 100.3 & 83.4 & 120.5 \\ \hline $1,287.7 & $1,464.8 & $1,488.9 & $1,615.7 \\ \hline \end{tabular} Property. Plant and Equipment, net Goodwill, net Dther Long-Term Assets Total Assets Accounts Payable Customer Advances Dther Payables \begin{tabular}{|r|r|r|r|} \hline 218.5 & 189.4 & 202.3 & 217.4 \\ 45.0 & 68.3 & 73.3 & 99.0 \\ 106.6 & 197.5 & 89.7 & 111.6 \\ \hline $370.1 & $455.2 & $365.3 & $428.0 \\ \hline 500.0 & & & \\ 137.8 & 138.0 & 475.0 & 475.0 \\ 127.2 & 117.9 & 145.2 & 153.9 \\ \hline $1,135.1 & $1,211.2 & $1,084.7 & $1,173.2 \\ \hline 10.0 & & & \\ \hline 1,054.8 & 1,009.0 & 963.9 & 970.6 \\ {[133.5]} & {[127.7]} & {[109.2]} & {[99.5]} \\ \hline[16.9] & 32.3 & 54.0 & 26.5 \\ \hline $914.4 & $923.6 & $918.7 & $907.6 \\ \hline & & & \\ \hline $2.049.5 & $2,134.8 & $2,003.4 & $2.080.8 \\ \hline \hline \end{tabular} aah Net Working Capital (Increase) i Decrease in Net Working Capital \begin{tabular}{|r|r|r|r|} \hline 917.6 & 1,009.6 & 1,123.6 & 1,187.7 \\ \hline & {[92.0]} & {[114.0]} & {[64.1]} \\ \hline \end{tabular} Bulunce Sheef stssumptions Curent dssefs Days Sales Dutstanding (DSD) Days Inventory Held (DIH) Prepaid and Dther Current Assets [\% Change in Inventory Currentiabikies Days Payable Qutstanding (DPQ) Accrued Liabilities [\% of sales] Dther Current Liabilities [\% of sales] \begin{tabular}{llll} 62.2 & 53.6 & 59.2 & 56.9 \\ 3.3% & 4.8% & 5.2% & 6.3% \\ 7.7% & 13.7% & 6.3% & 7.2% \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!