In: Finance
Your eccentric (and rich uncle) is thrilled that you are pursuing your undergraduate in business administration. For the next 40 years (starting 1 year from now; last payment 40 years from now), he will pay you $2000 every odd year (1st, 3rd, etc.) and $3000 every even year (2nd, 4th, etc.). The relevant discount rate is 5% per year. What is the present value of all the money you will receive from this source over the next 40 years?
Please explain with formulas and step by step.
Calculate the present value of all money received using discount factor of 5% | |||||
Year | Cash flow | Discount factor @ 5% (1/((1+r)^n)) | Present value (Cash flow*Discount factor) | ||
1 | $2,000 | 0.95238 | 1/(1.05^1) | $1,904.76 | |
2 | $3,000 | 0.90703 | 1/(1.05^2) | $2,721.09 | |
3 | $2,000 | 0.86384 | 1/(1.05^3) | $1,727.68 | |
4 | $3,000 | 0.82270 | 1/(1.05^4) | $2,468.11 | |
5 | $2,000 | 0.78353 | 1/(1.05^5) | $1,567.05 | |
6 | $3,000 | 0.74622 | 1/(1.05^6) | $2,238.65 | |
7 | $2,000 | 0.71068 | 1/(1.05^7) | $1,421.36 | |
8 | $3,000 | 0.67684 | 1/(1.05^8) | $2,030.52 | |
9 | $2,000 | 0.64461 | 1/(1.05^9) | $1,289.22 | |
10 | $3,000 | 0.61391 | 1/(1.05^10) | $1,841.74 | |
11 | $2,000 | 0.58468 | 1/(1.05^11) | $1,169.36 | |
12 | $3,000 | 0.55684 | 1/(1.05^12) | $1,670.51 | |
13 | $2,000 | 0.53032 | 1/(1.05^13) | $1,060.64 | |
14 | $3,000 | 0.50507 | 1/(1.05^14) | $1,515.20 | |
15 | $2,000 | 0.48102 | 1/(1.05^15) | $962.03 | |
16 | $3,000 | 0.45811 | 1/(1.05^16) | $1,374.33 | |
17 | $2,000 | 0.43630 | 1/(1.05^17) | $872.59 | |
18 | $3,000 | 0.41552 | 1/(1.05^18) | $1,246.56 | |
19 | $2,000 | 0.39573 | 1/(1.05^19) | $791.47 | |
20 | $3,000 | 0.37689 | 1/(1.05^20) | $1,130.67 | |
21 | $2,000 | 0.35894 | 1/(1.05^21) | $717.88 | |
22 | $3,000 | 0.34185 | 1/(1.05^22) | $1,025.55 | |
23 | $2,000 | 0.32557 | 1/(1.05^23) | $651.14 | |
24 | $3,000 | 0.31007 | 1/(1.05^24) | $930.20 | |
25 | $2,000 | 0.29530 | 1/(1.05^25) | $590.61 | |
26 | $3,000 | 0.28124 | 1/(1.05^26) | $843.72 | |
27 | $2,000 | 0.26785 | 1/(1.05^27) | $535.70 | |
28 | $3,000 | 0.25509 | 1/(1.05^28) | $765.28 | |
29 | $2,000 | 0.24295 | 1/(1.05^29) | $485.89 | |
30 | $3,000 | 0.23138 | 1/(1.05^30) | $694.13 | |
31 | $2,000 | 0.22036 | 1/(1.05^31) | $440.72 | |
32 | $3,000 | 0.20987 | 1/(1.05^32) | $629.60 | |
33 | $2,000 | 0.19987 | 1/(1.05^33) | $399.75 | |
34 | $3,000 | 0.19035 | 1/(1.05^34) | $571.06 | |
35 | $2,000 | 0.18129 | 1/(1.05^35) | $362.58 | |
36 | $3,000 | 0.17266 | 1/(1.05^36) | $517.97 | |
37 | $2,000 | 0.16444 | 1/(1.05^37) | $328.87 | |
38 | $3,000 | 0.15661 | 1/(1.05^38) | $469.82 | |
39 | $2,000 | 0.14915 | 1/(1.05^39) | $298.30 | |
40 | $3,000 | 0.14205 | 1/(1.05^40) | $426.14 | |
Present value | $42,688.46 | ||||
Thus, present value of all money is $42,688.46 | |||||