What's inside
- Up to 25 accounts and debts, 5 years of monthly balances, all on one simple input tab
- Dashboard: assets, debts and net worth for the latest month, change from the month before and over 12 months, and your debt-to-asset ratio
- Breakdown by category: cash, investments, retirement, home, vehicles; mortgage, car loans, student loans, credit cards
- Chart of the latest 24 months
- A warning when an account has no balance for the latest month, so a forgotten account doesn't make your net worth look lower than it is
- Sample file: 11 accounts over 18 months. Net worth $233,988, up $50,586 over 12 months
Checked, not just designed: 440 formulas, zero errors, and every dashboard figure, category total and chart value was recomputed independently from the raw balances in 8 scenarios, including skipped months and all 60 months filled.
Works in Excel and Google Sheets.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.