Information (Date for questions)Question1 (Use &-Year MACRS) Question 2Question 3

Please use excel format.

Net Working Capital Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Ending NWC NWC cash flow Salvage Value Pretax salvage value: Taxes on sale: Aftertax salvage value: Project Cash Flows Year OCF Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Change in NWC Capital spending Total cash flow NPV IRR \begin{tabular}{|} \hline \\ \hline \\ \hline \end{tabular} Minimum Target Price \$ 148.10 What-if Analysis Net Working Capital Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Ending NWC NWC cash flow Salvage Value Pretax salvage value: Taxes on sale: Aftertax salvage value: Project Cash Flows Year OCF Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Change in NWC Capital spending Total cash flow NPV IRR \begin{tabular}{|} \hline \\ \hline \\ \hline \end{tabular} Minimum Target Price \$ 148.10 What-if Analysis