Share via

How to build an interactive retirement calculator in Excel

Anonymous
2021-07-22T18:45:29+00:00

Hello,

First post here.

I maintain my retirement details in a spreadsheet. I maintain income that I will receive from my pension, if I retire early vs. at the allowed retirement age. I also have social security income at various ages. Lastly, I track the current value of my retirement accounts.

I want to use this data to understand 'what if' scenarios. e.g.

  • with the anticipated retirement incomes, while maintaining the current monthly expenses, how long will the savings last if I retire at age 62
  • running the same scenario for different ages - 65, 67, 70, etc.
  • I also want to these calculations to incorporate a percentage increase in annual expenses to reflect inflation

Is this easily doable in Excel? If yes, can you point me in the right direction?

Thanks in advance.

rado

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-07-22T21:09:16+00:00

    It's always a pleasure to help in any way, I'll close the topic here, so that your case can help other people with the same question.

    If you can, I would be grateful if you can rate my answer.,

    Good work for you.

    André

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-07-22T19:25:29+00:00

    Hi

    My name is André. I am an independent consultant.

    >First of all, it's a pleasure to have you here with us.

    As for your question, the answer is quite subjective.

    Yes, it is possible to do it easily here in excel.

    However, it is necessary to have knowledge of the calculation routines.

    What I recommend is downloading a ready-made template, and studying the changes you want to perform. The example I'm going to leave here, it's an official microsoft template, very well elaborated.

    take a look and see if you like it.

    https://templates.office.com/en-us/retirement-f...

    Answer here so I can continue helping you.

    André.

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2021-07-22T20:46:36+00:00

    Yes, just click on unhide on the bottom bar.

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2021-07-22T21:08:52+00:00

    Excellent! Thanks.

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2021-07-22T20:01:08+00:00

    Thanks Andre. I will download and try it out.

    0 comments