Project · Spreadsheet

Household budget & investment calculator

An Excel template I built for my own financial planning: income and expenses with frequency conversion, analysis by category, a year overview, a calculator for property investments and a repayment plan that shows what special repayments really achieve. It runs directly in the browser; the file is available on request.

All figures stay on this device.

The page calculates exclusively in the browser. No server requests, no third-party scripts, no external fonts, no tracking pixels. Data is saved only after explicit permission via the switch below, and then only on this device.

Verifiable: developer tools → Network → reload. After the page has loaded, the list stays empty.

Income / month
–
–
Expenses / month
–
–
Surplus / month
–
–
Savings rate
–
–

Analysis by category

CategoryMonthlyYearly ShareDistribution
Total – – 100 %

Purely annual costs

Expenses with the frequency “yearly” – insurance, vehicle tax, holidays. They do not occur every month, but they tear a hole in the budget in the month they fall due. That is why they are shown separately here.

Total of annual items –
Equivalent monthly reserve –

Income

What comes in. With the frequency “yearly”, the annual amount goes into the field; the conversion to a monthly figure happens automatically.

DescriptionSourceAmountFrequency MonthlyYearlyNote
Total income – –

Expenses

Choose a category from the list – the analysis in the dashboard is based on it. Frequency “yearly” again means: enter the annual amount.

Filter:
DescriptionCategoryAmountFrequency MonthlyYearlyNote
Total expenses – –

Charts

Everything is calculated from the entries – drawn as SVG, without a charting library.

Expenses by category

Income · Expenses · Surplus

Largest expense items

Year overview

The actual monthly figures. They reveal the outliers that get lost in the monthly average: car insurance in March, the holiday in August, the Christmas bonus in December.

Income Expenses Balance
Item

Investment & financing

For a property or another investment financed with a loan. The instalment, cash flow and returns are calculated from the key figures.

A · Investment

Financing requirement –

B · Loan

Monthly instalment (interest + repayment) –
hence: initial repayment –
hence: term (at a fixed rate) –

C · Running account per month

Operating surplus –
− Loan instalment –
− Tax (simplified) –
Net cash flow / month –

D · Returns

Gross rental yield p. a. –
Net rental yield p. a. –
Return on equity (cash flow) p. a. –
Repayment share / month (wealth building) –
Economic result incl. repayment –

E · Effect on the budget

Household surplus / month (from the dashboard) –
+ Net cash flow of the investment –
Freely available afterwards –
Planning tool, not financial or tax advice. The tax is heavily simplified – with property, interest and depreciation usually reduce the tax burden considerably. This should be worked through with a tax adviser.

Repayment plan

Two scenarios compared: the base instalment only versus the base instalment plus a monthly special repayment and an annual lump-sum repayment. The difference in interest is usually surprisingly large.

Inputs

Loan, interest and instalment come from the Investment tab.

Scenario 1 · base instalment only

Term–
Debt-free in–
Total interest –

Scenario 2 · with special repayment

Term–
Debt-free in–
Total interest –

The difference

Interest saved –
Debt-free sooner by –

End of the fixed-rate period

Fixed rate runs until –
repaid by then –
interest paid by then –
Remaining debt · base instalment only –
Remaining debt · with special repayment –

This remaining debt has to be refinanced at the end of the fixed-rate period – at an interest rate nobody knows today. The term above only applies as long as the interest rate stays the same.

Remaining debt over time

Scenario 1 – base instalment only Scenario 2 – with special repayment

Interest and repayment per year · base instalment only

At first, almost the entire instalment goes on interest. Each year, more of it shifts to repayment – which is why the debt falls ever faster later on.

Interest share Repayment share

Plan in detail

No.Month S1 remainingS1 interestS1 repayment S2 remainingS2 interestS2 repayment S2 special

Contact

Questions about how it is built, the decisions behind it, or how it might carry over to another case.

Arithmetic check Arithmetic task, shown as an image

No Google captcha, no cookies, nothing passed to third parties. Prefer e-mail? info@timobritz.de.