| Chapter 4 Question 2 |
| Compute the future value of $100 at an 5 percent interest rate for the following: |
| | (a.) | 5 years into the future. |
| | (b.) | 10 years into the future. |
| | (c.) | 15 years into the future. |
| | (a.) | Interest rate (RATE) | 5% |
| | | Number of periods (NPER) | 5 |
| | | Payment (PMT) | $ - 0 | | Payment is zero because this problem does not involve an annual payment, just a one-time, lump-sum payment. |
| | | Present value (PV) | $ (100.00) | | Excel wants a negative number here to show that this is cash outflow for you at the beginning for this investment. |
| | | FUTURE VALUE (FV) | $127.63 |
| | (b.) | Interest rate (RATE) |
| | | Number of periods (NPER) |
| | | Payment (PMT) | $ - 0 |
| | | Present value (PV) |
| | | FUTURE VALUE (FV) | $0.00 |
| | (c.) | Interest rate (RATE) |
| | | Number of periods (NPER) |
| | | Payment (PMT) | $ - 0 |
| | | Present value (PV) |
| | | FUTURE VALUE (FV) | $0.00 |
JJJQQQZZZ
Chapter4Question2.xlsx
