Posted: January 13th, 2016

Download the appropriate version of the Excel file and open it in your computer. The files are located in the Books and Resources area of this week.

Download the appropriate version of the Excel file and open it in your computer. The files are located in the Books and Resources area of this week.

Note the tabs in the file: Intro, Future Value, Present Value, FV of an Annuity, PV of an Annuity, Amortized Loans 1, and Uneven Cash Flows 1. Each of these tabs provides detailed information on how to solve time value of money problems and each also (near the bottom of the page) has practice problems for you to solve using Excel time value of money functions.

Solve every practice problem in the tabs. Then, create a well-organized Word document listing your final numerical answers for each of the practice problems. You do not need to show your work; only display your final numerical answers. However, be sure that your mentor, to whom you are submitting these answers, can easily figure out what tabs and questions your numbers are answering.