| 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,-1000,,1) | $55,228.86 |
| Value of investment account now | C4+C5 | $100,456.55 |
| Value of IRA now | FV(7%,45-22,-4000,,1) | $228,706.68 |
| Amount accumulated at early retirement | C6+C8 | $329,163.23 |
| PV at age 45 | C10 | $329,163.23 |
| PV at age 55 | FV(8%,55-45,,-C10) | $710,638.72 |
| FV of anuity due at age 55 | FV(8%,55-45,-1000,,1) | $15,645.49 |
| Total value of investment at age 55 | C13+C14 | $726,284.21 |
| Amount to withdraw each January 1 upon early retirement | PMT(8%,65-55,-C15,,1) | $100,220.15 |
PROVEN STERLING
eFISHERtvm.xlsx
