Week 3 Discussion

Project your Social Security benefits on the organization’s website (Amazon). Many retirement plans suggest that you should create a lump sum of cash to generate enough interest income equal to about 80% of your current income. Calculate how much money you would have to save each month from now until retirement in order to achieve a lump sum large enough to yield interest income equal to 80% of your current income. How much would you need to save each month? Let’s discuss this. If you would like some help with the time value of money calculations, Excel can be a very handy tool.

Review the site, which provides instructions on how to do time value of money calculations in Excel.

Excel Formula Coach