How add a row in Retirement Planner

Hi. My Retirement Planner runs out when I am 90, I want to add 10 more years. I think it only forecasts 35 yrs. Any way to add rows without breaking the formulas?

Hi @KathleenMc12 based on the FAQ you can. I can’t tell the row here but it says “Use the number value in the Cash Flow Forecast sheet in cell A1 to adjust the number of future years in the Cash Flow Forecast and the Retirement Planner. Since the original sheet only goes down to row 79, if you add years that go below row 79 of the Retirement Planner, you will need to manually fill down all of row 79 (including the hidden part of the sheet) to fill down to your final year. Some of the table columns use formulas in each cell.” . Please review the FAQs to check if this indeed addresses the query you have.

It also seems to mention an adjustment>> here

Hi @KathleenMc12

@twalane is correct. The range of years gets set for both sheets in the Cash Flow Forecast cell A1.
Thanks @twalane !!

1 Like