How much do you need to pay?

Now that you know how much money total you need to save, let's create a table to examine the amount per month to save based on years to retirement and the expected return rate during these saving years.

This example allows you to extend your skills with the pmt() function to monthly amounts, as previous exercises used yearly amounts. Use =pmt((1+Annual Rate)^(1/12)-1, Years*12, 0, -Nest Egg) as the formula filling in the cells for each value.