SHOW FORMULAS

THANKS,

94 Question 17 95 Using the same information given in the previous question, use the NPV function in Excel to find the present value of this lease. \begin{tabular}{|c|c|} \hline 96 & Mon \\ \hline 98 & 1 \\ \hline 99 & 2 \\ \hline 00 & 3 \\ \hline 01 & 4 \\ \hline 02 & 5 \\ \hline 03 & 6 \\ \hline 04 & 7 \\ \hline 05 & 8 \\ \hline 06 & 9 \\ \hline 07 & 10 \\ \hline 08 & 11 \\ \hline 10 & 12 \\ \hline 11 & 13 \\ \hline 12 & 14 \\ \hline 13 & 15 \\ \hline 14 & 16 \\ \hline 15 & 18 \\ \hline 16 & 19 \\ \hline 18 & 20 \\ \hline 25 & 21 \\ \hline 20 & 22 \\ \hline 21 & 23 \\ \hline 25 & 24 \\ \hline 25 & 25 \\ \hline \end{tabular} 94 Question 17 95 Using the same information given in the previous question, use the NPV function in Excel to find the present value of this lease. \begin{tabular}{|c|c|} \hline 96 & Mon \\ \hline 98 & 1 \\ \hline 99 & 2 \\ \hline 00 & 3 \\ \hline 01 & 4 \\ \hline 02 & 5 \\ \hline 03 & 6 \\ \hline 04 & 7 \\ \hline 05 & 8 \\ \hline 06 & 9 \\ \hline 07 & 10 \\ \hline 08 & 11 \\ \hline 10 & 12 \\ \hline 11 & 13 \\ \hline 12 & 14 \\ \hline 13 & 15 \\ \hline 14 & 16 \\ \hline 15 & 18 \\ \hline 16 & 19 \\ \hline 18 & 20 \\ \hline 25 & 21 \\ \hline 20 & 22 \\ \hline 21 & 23 \\ \hline 25 & 24 \\ \hline 25 & 25 \\ \hline \end{tabular}