For above question Annuity X can be calculated using excel
A | B | C | D | E | F | G | H | |||
1 | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
2 | Cash Flow | -4000 | 1.14 | 1.2996 | 1.481544 | 1.60006752 | 1.728073 | 1.866319 | 1.959635 | 2.057616 |
Formula | (=1*1.4) | A2*1.14 | B2*1.14 | C2*1.08 | D2*1.08 | E2*1.08 | F2*1.05 | G2*1.05 | ||
NPV of Cash flows assuming 1S of cash flows | $8.41 | Formula=NPV(10%,A2:H2) | PV of all cash flows assuming annuity as 1$ | |||||||
PMT | $475.72 | (=4000/NPV of 1$ cash flow) |
Please Discuss in case of Doubt
Best of Luck. God Bless
Please Rate Well
Get Answers For Free
Most questions answered within 1 hours.