Thursday, December 06, 2018

Net Worth Calculator Template - Excel Workbook

Beside compiling net worth, this template provides more information than just list of assets and liabilities. You can download this Net Worth Calculator (Excel Workbook) here.

It will let you know, based on your assets and liabilities list,
  1. the income generated by assets and the rate of return on the assets
  2. the asset appreciation rate of your assets and whether it beats inflation
  3. the amount readily available for emergency like accident, job loss, deposit to buy property, etc.
  4. the proportion of your borrowings which is non productive 

Dashboard view for Summary


From the perspective of financial planning, we need a few things from our portfolio of assets.



We need the portfolio to provide passive income to cover our living expenses after our retirement. We need the portfolio to grow in value higher than inflation so that we can continue to live the same lifestyle we want. We need it to be readily available as cash for emergency.

However, different classes of assets meet difference requirements. For instance,

  • while your home will grow in value beating inflation, it is not liquid and it does not generate income.
  • while your fixed deposits give you interest income (despite low) and readily available as cash, it will not grow in value and subject to loss of value due to inflation


We need to structure our portfolio with proper combination of assets classes and loans, to meet all the needs above.


This Net Worth Calculator is meant to provide useful information for you to have a long term view to plan and manage your assets and liabilities.
  • Are your assets generating income lower than that of savings deposits rate? 
  • Are your assets value appreciation high enough to beat inflation?
  • Are you keeping too little assets that is readily convertible to cash for emergency like job loss, accident, etc.?
  • What is your return on assets? what is your assets appreciation rate? both information is useful for long term projection of your retirement fund.

Enter your list of assets in 5 different categories/ classes. Enter market value, annual income and value appreciation growth rate of each line.

Enter your assets value, income and growth rate in the highlighted cells.

Enter your list of loans and liabilities in 5 different categories/ classes. Enter the outstanding loan amount and the interest expense for one year.

Enter your loan value and interest rates in the highlighted cells.

Understand how each category of your assets performed and the cost of your liabilities.
Understand each category of your assets and how they serve your
purpose for income, growth and liquidity.
Can the assets be improved? Can the combination be improved?




Review the analysis and thinking thoroughly on how to
  • improve your assets,
  • improve your liabilities,
  • improve your combinations of assets, and
  • improve your combinations of assets and liabilities

Review & carefully think through the analysis and actions suggested. 

You will learn new perspective of your portfolio by just go through the exercise itself compiling your own net worth. You may download the Net Worth Calculator here or use the Excel online version.

I am curious to know whether this workbook is useful to you and how it can be improved. Feel free to leave comments below.



Tuesday, November 27, 2018

Retirement Planning Calculator

This Excel template is a Retirement Planning Calculator. (You need to DOWNLOAD the Excel file to your desktop. It may not work on browser.)

It helps you to calculate the value of your retirement fund based on a few simple factors like your age, monthly savings, savings balances, inflation rate, desired living expenses at retirement, etc. It produces the chart below.

Retirement Fund Value Chart

Enter a few simple variables in the highlighted color cells to calculate the fund value at retirement age and your age it can cover your retirement living expenses.

Retirement Fund Calculator. Click the image to see the full size of image.



You can download the Retirement Planning Calculator Excel file here.

Good Retirement Planning


The shape of the graph above is a tad bit depressing as it seems you may outlive your retirement fund. There is a better way to plan.

A good retirement planning will give you a more inspiring chart like the one below. You can be sure the retirement fund will beat inflation, outlive you and leave something for your children.

A good retirement planning. 


This graph trend is possible when your fund gives you good returns and its value increases over the years. This is possible if you invest wisely in property and dividend stocks. These are the assets that will beat inflation and provide incomes, i.e. rental & dividend, without depleting its own value.

I added a variable, annual "Asset appreciation" rate of the fund. This is an ANNUAL rate. The annual rate for assets in cash or fixed deposit is zero. The annual rate for landed property is around 5% - 8%.

You can download the Retirement Planning Calculator Excel file here.