Pro Templates

Documentation

Net Worth Tracker

Pro Version

Getting Started

Here is how to get started with our Net Worth Tracker Pro template.

Net Worth Dashboard

Here is how to use the Net Worth Dashboard and how to understand all the insights.

Net Worth Projection

Here is how to use the Net Worth Projection to model your potential future net worth development.

Here is an overview of all input fields and what they do

End-of-Projection: The year up until the projection is modelled and visualized.

Output Mode: Choose between nominal and inflation-adjusted output values. The inflation rate used for inflation adjustment is the Personal Inflation rate in the Fundamentals section.

Input Mode Extra CF: Choose if you want the initial amount entered for your extra cashflows should be treated as nominal value or as the present value (PV). Nominal value means the amount you enter is taken exactly as stated, assuming it reflects the value in the start year without adjusting for inflation. The amount you enter represents the value in today’s money, meaning what it would be worth right now. The model will then internally adjust this value for the entered starting year using your personal inflation rate.

Input Mode Retirem. Income: Choose if you want the initial amount entered for your retirement income should be treated as nominal value or as the present value (PV). Nominal value means the amount you enter is taken exactly as stated, assuming it reflects the value in the start year without adjusting for inflation. The amount you enter represents the value in today’s money, meaning what it would be worth right now. The model will then internally adjust this value for the entered starting year using your personal inflation rate.

Initial Annual Net Income: Your initial main income per year after taxes. This should only cover your base income (e.g. job). Additional income can be listed as extra cashflow.

Initial Annual Expenses: Your initial expenses per year.

Income Growth: The annual growth rate you expect your base net income to grow at.

Personal Inflation Rate: The estimated rate at which your individual cost of living and purchasing power changes over time. In the Personal Finance Suite, it is used for two key purposes: To grow your base expenses nominally over time and to discount future cashflows in inflation-adjusted mode.

Desired annual expenses (in PV): This input is not used in the model, but as a reference level for multiple metrics in the Metrics Projection section.

% of Surplus to Liabilities: This value determined how much % of the surplus (after deducting the expenses from the income) in a year should be contributed to reduce debt (liabilities). 

Asset Gain (IRR): The assumed annual asset gain by which the total assets grow each year

Liability Costs (ECR): The assumed annual liability costs (interest) by which the total liabilities grow each year

Min. Principal Repayment Rate: The minimum % of your outstanding liabilities that will be paid down using your monthly surplus, no matter how your surplus allocation is set. Even if you set “% of Surplus to Liabilities = 0%” (meaning your surplus would normally go 100% into assets), this setting ensures a minimum debt repayment level is always maintained.

Your Birthday: Your birthday date which is used to display your age in different years in various parts of the worksheet.

Retirement Start Year: The first year of your retirement. That means, the year before that is the last year of your main profession (e.g. job).

Retirement Annual Net Income: The annual net income (e.g. state pension) you will receive starting in your retirement start year.

Retirement Income Growth : The annual growth rate of your retirement net income.

Taxable Fraction of Asset Sale: The percentage of your asset sales that is subject to taxation.

Avg. Effective Tax Rate: The estimated average tax rate applied to the taxable portion of the sale.

Annual Tax-Free Allowance: The amount of realized gains per year that remains tax-free and will be deducted from taxable gains before the effective tax rate is applied.

FAQ

Find answers to the most asked questions for this template.

Transactions Tracking

Credit card payments should be tracked differently depending on what part of the balance you are paying down:

  1. Payments that cover last month’s spending
    These payments are simply settling what you already consumed. They do not reduce your interest-bearing outstanding balance.
    → Classify them as Transfer in the budget type column.

  2. Payments that reduce your outstanding credit card debt
    These payments directly lower the balance on which interest is charged, meaning they are effectively paying down debt.
    → Classify them as Debt in the budget type column.

Why the distinction matters:
Only the second type of payment reduces your actual debt and future interest costs. Treating the first as “spending” again would double-count it in your budget, which is why it belongs in the Transfer category instead.

It depends on where the dividend goes after it’s paid out:

  1. Dividend stays in your brokerage/broker account
    If the dividend is paid out but remains inside the same brokerage account and you don’t have a separate asset position listed for that cash, then you do not track it as a transaction.
    → Your net worth doesn’t change across your tracked asset positions, so there is nothing to log.

  2. Dividend is paid into another explicitly listed asset account (e.g. bank account, savings, cash position, etc.)
    If the dividend leaves your brokerage account and lands in a separate asset account that you have listed as an individual asset position, then you should track two transactions to reflect the movement correctly:

    • Transaction 1: Dividend moving out of your brokerage account
      → Budget type: Dividend (or your suite’s income label)

    • Transaction 2: Dividend moving into your other listed asset account (e.g. your bank)
      → Budget type: Transfer

Why two entries?
Because the dividend changes the value between two tracked asset positions. One records the income event, the other records the asset movement. This ensures your net worth stays accurate and nothing is double-counted.

Other

All calculation worksheets are hidden. You can unhide them by right-clicking on any of the visible worksheet tabs at the bottom and then click on “Unhide”. This will open a window allowing you to select which worksheets you want to unhide.