Problem
In Excel, calculate the total monthly payment pension that can be withdrawn from 10,000 investment over 20 years of retirement given 8% annual rate of return by using the built in cash flow functions in Excel to perform all calculations. Formula must show interest rate reducing each month until it reaches zero at the end of the 20 years.