Time Value of Money: Annuity Cash Flows Other TVM Functions in MS Excel: Annuity Payment =PMT(RATE, NPER, PV, [FV], [TYPE]) Net Periods: =NPER(RATE, PMT, PV, [FV], [TYPE]) Solving for rate: =RATE(NPER, PMT, PV, [FV], [TYPE]) Example Question 1. \begin{tabular}{|l|l|l|l|l|} \hline NPER & RATE & PV & PMT & FV \\ \hline & & & & \\ \hline \end{tabular} Question 2. Question 3. Question 5. a) b) \begin{tabular}{|c|c|c|c|c|} \hline NPER & RATE & PV & PMT & FV \\ \hline NPER & RATE & PV & PMT & FV \\ \hline & & & & \\ \hline \end{tabular} Question 6. a) b) \begin{tabular}{|c|c|c|c|c|} \hline N & IN & PV & PMT & FV \\ \hline & & & & \\ \hline N & IN & PV & PMT & FV \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|l} Which option would be a better choice for Jill? \\ \hline \end{tabular} What else should Jill consider in this situation? Question 7. MBA\#: \begin{tabular}{|c|c|c|c|c|c|c|} \hline N & I/ & PV & PMT & FV & Total cost & Net Value \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} Which MBA program is more valuable from TVM perspective when considering present value of average salary after graducation? \begin{tabular}{l} Which MBA program is more valuable from TVM perspective when \\ considering present value of average salary after graducation? \\ \hline \end{tabular} What else should you consider when choosing a graduate program