C13 8 9 10 11 12 13 45 14 15

C13 fx=B13/(1+B3)A13 \begin{tabular}{|c|c|c|c|c|c|} \hline & A & & & B & C \\ \hline 8 & Year & & & sh Flow & PV \\ \hline 9 & & 1 & $ & (750,000) & $(681,818) \\ \hline 10 & & 2 & $ & 285,000 & $235,537 \\ \hline 11 & & 3 & $ & 211,000 & \$ 158,527 \\ \hline 12 & & 4 & $ & 203,000 & \$ 138,652 \\ \hline 13 & & 5 & $ & 195,000 & \$ 121,080 \\ \hline 14 & & 6 & $ & 125,000 & \$ 125,000 \\ \hline \end{tabular} \begin{tabular}{l|l} NPV (manual) & \$ 96,978 \\ NPV (excel formula) & \$ 42,537 \end{tabular} ROI Net Profit Investment ow C13 fx=B13/(1+B3)A13 \begin{tabular}{|c|c|c|c|c|c|} \hline & A & & & B & C \\ \hline 8 & Year & & & sh Flow & PV \\ \hline 9 & & 1 & $ & (750,000) & $(681,818) \\ \hline 10 & & 2 & $ & 285,000 & $235,537 \\ \hline 11 & & 3 & $ & 211,000 & \$ 158,527 \\ \hline 12 & & 4 & $ & 203,000 & \$ 138,652 \\ \hline 13 & & 5 & $ & 195,000 & \$ 121,080 \\ \hline 14 & & 6 & $ & 125,000 & \$ 125,000 \\ \hline \end{tabular} \begin{tabular}{l|l} NPV (manual) & \$ 96,978 \\ NPV (excel formula) & \$ 42,537 \end{tabular} ROI Net Profit Investment ow