A simple way to take stock of our financial health

Financial health refers to 'where we stand today' with respect to our finances and what we need to do in the coming years to handle future expenses and financial goals.

In this post, I would like to describe a simple exercise to assess our personal financial health. This process can be automated with the integrated financial planning template.

The process in which expenses, investment amount needed for financial goals, along with expected salary are projected into the future was a pivotal exercise in my financial learning curve.

The idea is to create a table with the following entries:

  • We take our current salary and project it in future with some reasonable growth rate.
  • Do the same with current expenses with an assumed inflation rate
  • Determine the total investment amount required for all out goals and if possible  increase it at some rate for the coming years.
  • Determine the amount that we can invest each month - now and in future (increased or decreased at some rate).
  • Consider any current and future liabilities.

We might end up with something like this. This is a screenshot from the above-mentioned financial planning template.

click to enlarge. 

The red cells are those years when we will be investing less than required  for our goals.  If there are too many red cells, then goal priorities and inputs may have to be altered.

This exercise can be a confidence booster for a few and scary for many - including me.

  1. This is only a projection with assumed inputs. The future can turn out better (or ..) than this.
  2. If we keep out head down and invest systematically with a solid strategy in place, with a bit of luck, and in time, the number of red cells may come down.
  3. I did not lose sight of this hope when I first did this exercise 6 years ago, and I would urge you to do the same.
  4. Like any other goal-planning exercise, it is  important to do this assessment once a year.
  5. In some cases, the red cells (inability to invest enough) can be reduced with small changes in lifestyle.

After I did this exercise, I had a clear idea of where I stand and what I can hope for in future. To be frank, I was disappointed that a couple of my wants could not be accommodated after accounting for my needs. Well, we can't have everything, can we? 

Download the Integrated Financial Planning Template


Register for the Hyderabad DIY Investor Workshop Nov 27th 2016

Check out the latest mutual fund returns listing


Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- (Rs. 359/- at Amazon.in). Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

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.

Do more with freefincal!

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.

6 thoughts on “A simple way to take stock of our financial health

  1. Rahul

    Thank you for this post. I am using something similar for the last 5+ years to track where I am. However I have added another "feature" by which I try to gauge how much insurance cover is required. I come up with the amount by doing a NPV of all the future expenses and reducing this number by the current assets. In my mind this is the delta that needs to be filled by my insurance cover. This will take care of all the future expenses, goals and maintain the standard of living. As I do this calculation for each year, I can also see a trend on when my insurance cover reduces (as I achieve goals, meet or beat my savings target for the year) to a point when I no longer need a insurance cover. Please let me know your thoughts.


Do let us know what you think about the article