Loading...
List assets and debts and download an Excel file that totals both sides and the difference.
Net worth is everything you own valued at what it would fetch today, less everything you owe. It is one number, and on its own it says less than people think: the same figure held in cash and held in a house are very different positions.
What you own
| Asset | Kind | Value | Remove |
|---|---|---|---|
What you owe
| Debt | Kind | Value | Remove |
|---|---|---|---|
Net worth
$210,950.00
Own
$447,200.00
Owe
$236,250.00
Reachable
$53,700.00
Tied up
$393,500.00
The download is a real Excel workbook with four tabs, not a comma separated list with a spreadsheet extension. Everything you entered is already in it.
1. Assets
One row per account or item, with its kind and current value. The total at the bottom is a SUM formula rather than a pasted number.
2. Liabilities
The same for what you owe, at the balance outstanding today rather than the amount originally borrowed.
3. Summary
Each category totalled with a SUMIF against the tabs above, the share of assets each one represents, the net figure, and the split between what you could reach this year and what is tied up.
4. Details
The date the statement is as at, how many entries it covers and the currency it is in.
Keep each quarter as its own file rather than overwriting one. The direction is the useful part, and a single sheet cannot show it.
| Line | Formula in the file | Amount | Share |
|---|---|---|---|
| Cash and savings | =SUMIF(Assets!B:B,A2,Assets!C:C) | $15,200.00 | 3.4% |
| Investments | =SUMIF(Assets!B:B,A3,Assets!C:C) | $38,500.00 | 8.6% |
| Retirement accounts | =SUMIF(Assets!B:B,A4,Assets!C:C) | $74,000.00 | 16.5% |
| Property | =SUMIF(Assets!B:B,A5,Assets!C:C) | $310,000.00 | 69.3% |
| Vehicles | =SUMIF(Assets!B:B,A6,Assets!C:C) | $9,500.00 | 2.1% |
| Net worth | =B7-B11 | $210,950.00 |
Every category total is a SUMIF against the assets tab, so adding an account in Excel updates the summary without touching it. The share column is a TEXT formula, which is why it survives as a percentage rather than arriving as a decimal.
Excel
Double click the download. If Excel shows a yellow protected view bar, click Enable Editing so the formulas calculate.
Google Sheets
Upload it to Drive and open it, or use File then Import then Upload inside an existing sheet. Formatting and formulas both carry across.
Numbers on a Mac
Open it directly. Numbers converts the workbook and keeps the totals working, though the yellow header fill may shift slightly.
Formula
Net worth = total assets - total liabilities | Category total = SUMIF(kind column, kind, value column)Assets = What you own, valued at what it would sell for today
Liabilities = What you owe, at the balance outstanding rather than the amount borrowed
Liquid = The part you could turn into money this year, which here is cash and investments
Worked Example
A flat, a pension and three debts
Did you know? The Federal Reserve runs a Survey of Consumer Finances every three years, and it reports the median rather than the average for a reason: a small number of very large fortunes drag the average far above what a typical household holds. When a headline quotes average net worth, it is usually describing almost nobody.
Estimate monthly spousal support using income disparity and marriage length. Educational use only.
Generate a full amortization schedule showing each payment's principal and interest split.
Calculate auto loan payments with down payment, trade-in, and amortization schedule.
Find break-even units and revenue. Analyze profit at any volume with contribution margin.
Calculate capital gains tax with short-term and long-term rates. Includes NIIT and residence exclusion.
Calculate expected returns using CAPM based on beta, risk-free rate, and market return.