Quote:
Originally Posted by user_id
I think you may want to review the chapter on NPV... I seriously wonder where you think the $769 magically materializes from.
|
All assuming 1%
Column 1 = month number
Column 2 = monthly payment
Column 3 = NPV equation for that month
1___$125 ___ =125 / 1.01^1
2___$125 ___ =125 / 1.01^2
3___$125 ___ =125 / 1.01^3
4___$125 ___ =125 / 1.01^4
5___$125 ___ =125 / 1.01^5
6___$125 ___ =125 / 1.01^6
7___$125 ___ =125 / 1.01^7
8___$125 ___ =125 / 1.01^8
9___$125 ___ =125 / 1.01^9
10__$125 ___ =125 / 1.01^10
11__$125 ___ =125 / 1.01^11
12__$125 ___ =125 / 1.01^12
13__$125 ___ =125 / 1.01^13
14__$125 ___ =125 / 1.01^14
15__$125 ___ =125 / 1.01^15
16__$125 ___ =125 / 1.01^16
17__$125 ___ =125 / 1.01^17
18__$125 ___ =125 / 1.01^18
19__$125 ___=125 / 1.01^19
20__$125 ___ =125 / 1.01^20
21__$125___ =125 / 1.01^21
22__$125 ___ =125 / 1.01^22
23__$125 ___ =125 / 1.01^23
24__$2125___=2125 / 1.01^24
Do the math from column 3, the total equals$ 4,230.56. NPV of paying all at once is $5,000 (obviously).
$5,000 - $4,230.56 = $769.44.
Dude - it is basic math. Let me know if you need help computing the values in column 3. I can do it, but I don't want to take that much time typing out all of the answers for each period in this thread. Copy the third column (after the = sign) into excel and do the math yourself.