Please complete the Excel sheet showing the formulas used.

Your company is evaluating a new product and you are required to provide a financial evaluation and recommendation Operations has given the following estimates: VMC $60 per unit each year Fixed Mfg Costs $25,000 each year Working capital required for this project: $20,000 is required up front; subsequent years is estimated to be 15% of $ sales Cost of Machinery $800,000 Machine depreciated using 7-years MACRS table (provided on next tab) Anticipate salvage value: 20% of original cost of machine Prior to start-up and caused by the installation of the new machine, production will be disrupted causing the loss of 500 units selling for $50 with a VMC of $30 Info from the CFO: Marginal tax rate: 21% Required rate of return: 15% Assume 0 inflation She has asked you to calculate the following and asked for your recommendation, accept or reject the project NPV IRR Payback \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & Year0 & Year1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year7 & Year 8 & 1 & 114.29% \\ \hline Unit Sales & & & & & & & & & & 2 & 224.49% \\ \hline Unit Price & & & & & & & & & & 3 & 317.49% \\ \hline \multirow[t]{2}{*}{ Unit VMC } & & & & & & & & & & 4 & 412.49% \\ \hline & & & & & & & & & & 5 & 8.93% \\ \hline Revenues & & & & & & & & & & 6 & 8.92% \\ \hline Variable Costs & & & & & & & & & & 7 & 8.93% \\ \hline Fixed Costs & & & & & & & & & & 8 & 4.46% \\ \hline \multicolumn{12}{|l|}{ Depreciation } \\ \hline \multicolumn{12}{|l|}{ EBIT } \\ \hline \multicolumn{12}{|l|}{ Taxes @ 21\% } \\ \hline \multicolumn{12}{|l|}{ Net Income } \\ \hline & & & & & & & & & & & \\ \hline \multicolumn{12}{|l|}{ + Depreciation } \\ \hline \multicolumn{12}{|l|}{NWC} \\ \hline \multicolumn{12}{|l|}{ + NWC Recovery } \\ \hline \multicolumn{12}{|c|}{ Capital Spending } \\ \hline \multicolumn{12}{|l|}{ \pm Salvage Value } \\ \hline Total Cash Flow & $ & $ & - & $ & $ & $ & - & $ & $ & & \\ \hline Cum Cash Flow & $ & $ & $ & $ & - & $ & - & $ & $ & & \\ \hline \multicolumn{12}{|l|}{ Payback } \\ \hline NPV @ 15\% & $0 & & & & & & & & & & \\ \hline IRR & \#NUM! & & & & & & & & & & \\ \hline \end{tabular}