1. Time Value Money / using excel sheet
At retirement, an investor plans to withdraw $40,000 per year. The investor assumes that he/she can earn an average 6% return over the 25 years they expect to make withdrawals. How much must this investor have accumulated in order to achieve their objective of withdrawing $40,000 per year?
2. What if the investor wants to withdraw $3,600 per month?