Please show formulas for how you got all orange box answers using tbe information in green boxes. Please also include how you found the NPV profile with each discount rate using excel.

Given \begin{tabular}{|c|c|} \hline Cost of Tester (Year 0) & 250,000 \\ \hline Installation and training costs & 10,000 \\ \hline CAPEX (Year 5) & 100,000 \\ \hline Annual cost samings & 70,000 \\ \hline Salvage value & 5,000 \\ \hline Book Value & 0.00 \\ \hline Depreciation & Straight Line \\ \hline Project Life & 10 years \\ \hline Tax rate & 30% \\ \hline Cost of Capital & 12% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{17}{|c|}{ Solution } \\ \hline a. & & & & & & & & & Year & & & & & & & \\ \hline & & 0 & 1 & 2 & 3 & & 4 & & 5 & & 6 & & 7 & 8 & 9 & 10 \\ \hline \multicolumn{17}{|l|}{ Investment Outlays } \\ \hline Equipment purchases & s & (250,000) & & & & & & & & & & & & & & \\ \hline instalation costs & & (10,000) & & & & & & & & & & & & & & \\ \hline Initial Oulay & 5 & (260,000) & & & & & & & & & & & & & & \\ \hline \multicolumn{17}{|l|}{ Free Cash Flows } \\ \hline Operating Expense Sawngs & & & $70,000 & $70.000 & $70.000 & 3 & 70.000 & 3 & 70,000 & s & 70.000 & 3 & 70,000 & 570,000 & $70.000 & $70,000 \\ \hline Less: Deprecaton Expense & & & 24,500 & 24,500 & 24,500 & & 24.500 & & 24,500 & & 49000 & & 49,000 & 49,000 & 40.000 & 49,000 \\ \hline Additional Operating income & & & 545,500 & 5.45 .500 & $45.500 & 5 & 45,500 & 5 & 45,500 & 5 & 21,000 & 5 & 21,000 & $21,000 & $21.000 & $21,000 \\ \hline Less: Taues & & s. & 31.850 & 31,850 & 31,050 & & 31,050 & & 31.850 & & 14.700 & & 14.700 & 14.700 & 14,700 & 14700 \\ \hline NOPAT & & & $12.650 & $13.650 & $13,650 & 5 & 13.650 & 5 & 13.650 & 3 & 8,300 & 5 & 6.300 & $6.300 & 36,300 & 58,300 \\ \hline Plus: Depreciation & & & 24,500 & 24,500 & 24,500 & & 24,500 & & 24500 & & 49,000 & & 49,000 & 49.000 & 49,000 & 49.000 \\ \hline Less: CAPEX & & (280.000) & & = & = & & & & (100,000) & & & & = & - & 3 & - \\ \hline Less Working Capital & & = & & - & = & & . & & & & . & & - & = & = & = \\ \hline Free Cash Flow & 5 & (260,000) & 538.150 & 538.150 & 5.38,150 & 5 & 38,150 & 5 & (61.850) & 5 & 55.300 & 5 & 55,300 & 555,300 & $55,300 & $55.300 \\ \hline \multirow{2}{*}{\multicolumn{17}{|c|}{ b. }} \\ \hline & & & & & & & & & & & & & & & & \\ \hline Internal Rate of Return & & & & & & & & & & & & & & & & \\ \hline \end{tabular}