In: Finance
4) Jennifer will need to pay $200 at the end of every month for the next 12 months, except for the payment of the 10th month. What is the value assuming a rate of 4% compounded quarterly? a) 2261.01 b) 2155.49 c) 2199.02 d) 237.88
Correct Option B 2155.49
Step - 1
First of all we will calculate the effective annual rate
Effective Annual Rate = (1 + R/N)^N - 1
where
R = Annual Nominal Rate
N = Number of compounding period
Effective Annual Rate = (1 + R/N)^N - 1
Effective Annual Rate = (1 + 0.04/4)^4 - 1 = 4.0604%
Step 2 - Calculation of present value factor
To calculate the present value factor we have to use the following formulae
Present Value factor for 1 month = 1.040604 ^ (1/12) = 1.003322
Present Value factor for 2 month = 1.040604 ^ (2/12) = 1.006656
| Month | Present Value Factor | 
| 1 | 1.003322 | 
| 2 | 1.006656 | 
| 3 | 1.010000 | 
| 4 | 1.013356 | 
| 5 | 1.016722 | 
| 6 | 1.020100 | 
| 7 | 1.023489 | 
| 8 | 1.026889 | 
| 9 | 1.030301 | 
| 10 | 1.033724 | 
| 11 | 1.037158 | 
| 12 | 1.040604 | 

Step 3 - Calculation of present value of all the cash flows
| Month | Cash Flow | Present Value Factor | Present Value | 
| 1 | 200 | 1.003322 | 199.34 | 
| 2 | 200 | 1.006656 | 198.68 | 
| 3 | 200 | 1.010000 | 198.02 | 
| 4 | 200 | 1.013356 | 197.36 | 
| 5 | 200 | 1.016722 | 196.71 | 
| 6 | 200 | 1.020100 | 196.06 | 
| 7 | 200 | 1.023489 | 195.41 | 
| 8 | 200 | 1.026889 | 194.76 | 
| 9 | 200 | 1.030301 | 194.12 | 
| 10 | 1.033724 | 0.00 | |
| 11 | 200 | 1.037158 | 192.83 | 
| 12 | 200 | 1.040604 | 192.20 | 
| Present Value | 2,155.49 | 
Present Value of cash flow = 2155.49
