All calculators are downloadable Excel spreadsheets that allow you to save and amend your own personal data.With this spreadsheet, enter your personal data in the purple coloured cells.

net worth and asset allocation spreadsheet

As some assets do well and others do poorly, our desired asset allocation can drift over time. This can create a situation where we are invested too heavily (or not enough) in our preferred investments.

All you need to do is enter your current assets in the purple cells and your results will be provided in the peach box, as well as 6 pie charts for an easy visual. The pie charts showing your asset allocations in specific asset categories and broad asset categories and both including the house (if you are a homeowner) and excluding the house. The graphs will also show you your split of growth assets (such as shares and property) relative to conservative assets (such as cash and bonds). The last two graphs excluding your current home if you are a homeowner.

I have pre filled some purple cells to give you an example of how it may look, but delete or add any numbers as your situation requires.

For more information on the importance of a correct asset allocation, have a read of our article here.

Then if you need help deciding how much you may need to buy or sell to rebalance to your original preferences, you can check out our rebalancing calculator on the investment calculator page.

Since you have entered all your asset holdings I thought it would also be good to add a net worth tracker to this calculator too. You’ve done most of the hard work already. For your net worth you just need to add your liabilities, and your net worth number will be provided.

From there you can use the net worth table in rows 129 to 148 to track your net worth over time. The great thing about this table is you can enter your net worth as often (maximum of monthly) or as little as you like, and the % change in your net worth from one date to another will still be calculated.

If you have any feedback or improvements to suggest feel free to get in touch.

For more calculators, click here