| Question | Working | Answers |
| value of CD | FV(7.25%,10,,-5000) | $10,068.00 |
| Value of reinvested CD | FV(6.75%,45-22,,-C2) | $45,227.68 |
| Value of Annuities due, | FV(6.75%,45-22,-1500,,1) | $82,843.29 |
| Value of investment account now | C4+C5 | $128,070.98 |
| Value of IRA now | FV(7%,45-22,-2000,,1) | $114,353.34 |
| Amount accumulated at early retirement | C6+C8 | $242,424.32 |
| PV at age 45 | C10 | $242,424.32 |
| PV at age 55 | FV(8%,55-45,,-C10) | $523,375.92 |
| FV of anuity due at age 55 | FV(8%,55-45,-1500,,1) | $23,468.23 |
| Total value of investment at age 55 | C13+C14 | $546,844.15 |
| Amount to withdraw each January 1 upon early retirement | PMT(8%,65-55,-C15,,1) | $75,459.17 |
PROVEN STERLING
eFISHERtvm.xlsx
