The Time Value of Money Assignment 2-A is a worksheet that has examples and problems of each type of TVM equation and Bond Valuation. Please review the examples, then calculate the problems using Excel. I have given you the answers to each problem. I want you to enter the proper Excel equation. If the answer you get does not match the one I have provided, then try again. Keep entering equations until you get the correct answer. For help, refer to the examples (similar problems that have been worked for you) that have been provided. Please don’t cut and paste formulas on the spreadsheet, I expect you to enter all formulas manually.
Once you enter the first part of a formula in Excel, the whole formula will appear in a pop-up box. So, Excel shows you what to input next. For more help in this, you can click the fx to the left of the address bar. When you do this, a pop-up box will appear that has a definition of each input that needs to be added (when you click in the entry box for that input).
To grade this portion of the assignment, I will first check that you have calculated the correct answer, then I will click in the cell and look for a formula. This worksheet is a learning tool designed to help you learn how to calculate TVM equations in Excel. Once you have submitted the spreadsheet, you may then move on to The Assignment 2-B.
