Wk2 Excel All you have to do is click on the up loaded link and fill in the answers.
julier21
02WrittenAssignment_ApplicationofFutureValueandPresentValue-1.xlsxFuture Value
| Module 02 Written Assignment - Application of Future Value and Present Value | |
| Complete problems 1 and 2 below. | |
| 1. | Calculate the future value in ten years of $2,000 received today if your investments pay: |
| a. | 6 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| PV | |
| FV | |
| b. | 8 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| PV | |
| FV | |
| c. | 10 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| PV | |
| FV | |
| d. | 10 percent compounded semiannually |
| Rate | |
| Nper | |
| PMT | |
| PV | |
| FV | |
| e. | 10 percent compounded quarterly |
| Rate | |
| Nper | |
| PMT | |
| PV | |
| FV | |
| 2. | What is the relationship between future values and interest rates and future values and the number of compounding periods per year? |
Present Value
| Module 02 Written Assignment - Application of Future Value and Present Value | |
| Complete problems 1 and 2 below. | |
| 1. | Calculate the present value in ten years of $2,000 received today if your investments pay: |
| a. | 6 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| FV | |
| PV | |
| b. | 8 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| FV | |
| PV | |
| c. | 10 percent compounded annually |
| Rate | |
| Nper | |
| PMT | |
| FV | |
| PV | |
| d. | 10 percent compounded semiannually |
| Rate | |
| Nper | |
| PMT | |
| FV | |
| PV | |
| e. | 10 percent compounded quarterly |
| Rate | |
| Nper | |
| PMT | |
| FV | |
| PV | |
| 2. | What is the relationship between present values and interest rates and present values and the number of compounding periods per year? |
