Skip to content

Retirement Corpus Tracker

Track the monthly growth of your retirement corpus with this Excel sheet.  This is a combination of the low-stress retirement calculator and the visual SIP tracker.

On popular demand, I have now included the possibility to track the growth of real estate (or any other) investment.

The user will have to first use the retirement calculator. The inputs of this sheet are used for tracking the corpus each month.

The monthly investment made in

  1. equity (stocks or mf)
  2. taxable debt
  3. tax-free debt
  4. any other instrument

should be entered by the user along with the total actual value of the instrument.  

The progress of the each instrument can be tracked in the same sheet. The total investment can also be graphically tracked.

How to use

  • This is meant only for disciplined investors.
  • Use it once a month, preferably the month end.
  • Enter the investments and value of the instruments and track them.
  • Even if the instrument grows at exactly the same rate at which you expect it, there will be a small difference between the actual and expected value. This can be safely ignored.
  • An experimental feature, how long would my corpus last? has been included.  Please let me know if this gives meaningful numbers.

Screenshot of the input sheet (click to enlarge)

retirement-tracker-1

Screenshot of the corpus growth graph

retirement-tracker-2

Have used some dummy numbers to generate this. Your graph with real numbers will look way better!

Download the retirement corpus tracker 

Have included some dummy data. Please delete before use.

Create a "from start to finish" financial plan with this free robo advisory software template


Free Apps for your Android Phone

Install Financial Freedom App! (Google Play Store)


Install Freefincal Retirement Planner App! (Google Play Store)


Find out if you have enough to say "FU" to your employer (Google Play Store)


About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

8 thoughts on “Retirement Corpus Tracker

  1. ashalanshu

    Dear Pattu, this one is very realistic as one can feel the growth on mly basis. Also can take corrective actions if the things are looking offtrack.

    Thanks

    Ashal

    Reply
  2. ashalanshu

    Dear Pattu, this one is very realistic as one can feel the growth on mly basis. Also can take corrective actions if the things are looking offtrack.

    Thanks

    Ashal

    Reply

Do let us know what you think about the article

%d bloggers like this: