Cashcolt

Property calculator: is the rented flat really worth it?

Work through an investment flat with all costs, taxes and the sale. And compare it with an ETF that receives the same money.

Reviewed by Marc · Updated 22 Nov 2026Free, no account

The short version

  • The gross rental yield in the listing says little. In example A, 3.6% gross becomes 2.4% net. On your equity, 2.1% a year is left after interest, taxes and sale.
  • Always compare with an ETF that receives the same money: your equity plus every monthly top-up.
  • Tax decides. With special depreciation (example B) or monument depreciation (example C), the flat can beat the ETF.
  • Plan for more than ten years. Selling earlier means tax on the gain and often a prepayment penalty.
  • The calculator is free and needs no account.
01 / Calculator

Your flat, worked through

This is what the calculator looks like with example A. You run your own numbers in the app, free and without an account.

Purchase
Purchase price
260,000€
State
North Rhine-Westphalia
Year built
1995
Base rent per month
780€
Service charge per month
330€
Agent fee at purchase
3.57%
Financing
Equity
52,000€
Interest
4.2%
Repayment
1.5%
Fixed rate
10years
Tax and sale
Taxable income
70,000€
Depreciation
straight-line
Sale after
15years
Assumed ETF return
6.0% p. a.
Gross rental yield
3.6%net 2.4%
Avg. top-up in years with a shortfall (years 1 to 10)
€337per month. Years without a shortfall count as €0. €54,274 in total over 15 years
Avg. net cash flow after tax per month (years 1 to 10)
−€337Plus and minus netted. A minus is money you top up.
Return on your equity (IRR)
2.1%per year, after everything
After 15 years
€135,167Flat, ETF: €195,884
Your result: wealth at sale, flat against ETFFlat: from −€11,547 in year 1 to €135,167 in year 15. ETF: from €58,420 to €195,884.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€11,547ETF€195,884Flat€135,167Your result: wealth at sale, flat against ETFFlat: from −€11,547 in year 1 to €135,167 in year 15. ETF: from €58,420 to €195,884.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€11,547ETF€195,884Flat€135,167

In years with a shortfall you top up €337 a month on average over years 1 to 10, and the net cash flow after tax averages −€337. If you sell after 15 years, you keep €135,167. With the same money in the ETF it would be €195,884.

Calculate with your numbers

Free, no account. Saving needs an account.

02 / Examples

Three worked examples

Same interest, same repayment, same ETF assumption. What changes is the property, the depreciation and the income. Every calculation assumes a sale after 15 years.

Example AETF wins

Existing flat in North Rhine-Westphalia: the ETF wins clearly

A rented existing flat in North Rhine-Westphalia, built in 1995, for €260,000. It earns €780 base rent a month, the service charge is €330. You bring €52,000 of equity, the loan runs at 4.2% with 1.5% repayment, fixed for 10 years. Depreciation is straight-line.

Inputs
TypeExisting building
Purchase price€260,000
StateNorth Rhine-Westphalia
Year built1995
Base rent per month€780
Service charge per month€330
Equity€52,000
Interest4.2%
Repayment1.5%
Fixed rate10 years
Depreciationstraight-line
Taxable income€70,000, single filing
Agent fee at purchase3.57%
Property transfer tax6.5%
Sale after15 years
Assumed ETF return6.0% per year
Assumptions, defaults in the calculator
Land share, not depreciable25.0%
Vacancy3.0%, plus a tenant change every 6 years with 2 months of vacancy
Upkeep per year€650
Chargeable service charge per month€200
Rent increase2.0% per year
Cost increase2.5% per year
Value increase1.5% per year
Selling costs3.57%
Follow-up rate after the fixed period5.0%

Result

Gross rental yield
3.6%net 2.4%
Avg. top-up in years with a shortfall (years 1 to 10)
€337per month. Years without a shortfall count as €0. €54,274 in total over 15 years
Avg. net cash flow after tax per month (years 1 to 10)
−€337Plus and minus netted. A minus is money you top up.
Return on your equity (IRR)
2.1%per year, after everything
After 15 years
€135,167Flat, ETF: €195,884
Example A: wealth at sale, flat against ETF, years 1 to 15Flat: from −€11,547 in year 1 to €135,167 in year 15. ETF: from €58,420 to €195,884.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€11,547ETF€195,884Flat€135,167Example A: wealth at sale, flat against ETF, years 1 to 15Flat: from −€11,547 in year 1 to €135,167 in year 15. ETF: from €58,420 to €195,884.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€11,547ETF€195,884Flat€135,167
All values as a table (example A)
YearFlatETFCash flow after tax
1−€11,547€58,420−€3,726
2−€580€65,166−€3,710
3€10,623€72,259−€3,698
4€22,067€79,723−€3,686
5€33,758€87,582−€3,677
6€41,726€99,724−€7,273
7€49,940€108,643−€3,664
8€58,391€118,050−€3,661
9€67,080€127,977−€3,661
10€76,017€138,458−€3,662
11€103,471€147,884−€2,044
12€111,044€162,011−€5,924
13€118,845€172,698−€1,987
14€126,883€183,976−€1,962
15€135,167€195,884−€1,940

Verdict: The ETF wins clearly.

After 15 years the ETF is €60,717 ahead, and in none of the 15 years is the flat ahead. From year 1 to 10 the average top-up in years with a shortfall is €337 a month, and the average net cash flow after tax is −€337. Over 15 years you top up €54,274 in total. 3.6% gross in the listing becomes 2.4% net. On your equity, 2.1% a year is left after interest, taxes and sale.

Calculate with your numbers

Free, no account. Saving needs an account.

Example BFlat wins from year 11

New build in Bavaria with special depreciation: the flat beats the ETF

A new-build flat in Bavaria with 78 m², purchase price €420,000, no agent. Planned base rent €1,250, service charge €280. €90,000 of equity, 4.2% interest, 1.5% repayment, fixed for 10 years. Depreciation is declining balance, plus special depreciation under § 7b. No rent comes in during the first year, but €5,355 of interest is already due.

Inputs
TypeNew build
Purchase price€420,000
StateBavaria
Year built2026
Living area78 m²
Base rent per month€1,250
Service charge per month€280
Equity€90,000
Interest4.2%
Repayment1.5%
Fixed rate10 years
Depreciationdeclining balance plus special depreciation § 7b
Taxable income€95,000, single filing
Agent fee at purchase0.0%
Property transfer tax3.5%
Sale after15 years
Assumed ETF return6.0% per year
Assumptions, defaults in the calculator
Land share, not depreciable25.0%
Vacancy3.0%, plus a tenant change every 6 years with 2 months of vacancy
Upkeep per year€300
Chargeable service charge per month€190
Rent increase2.0% per year
Cost increase2.5% per year
Value increase1.5% per year
Selling costs3.57%
Follow-up rate after the fixed period5.0%

Result

Gross rental yield
3.6%net 3.0%
Avg. top-up in years with a shortfall (years 1 to 10)
€111per month. Years without a shortfall count as €0. €20,691 in total over 15 years
Avg. net cash flow after tax per month (years 1 to 10)
+€98Plus and minus netted. A minus is money you top up.
Return on your equity (IRR)
7.1%per year, after everything
After 15 years
€232,670Flat, ETF: €181,222
Example B: wealth at sale, flat against ETF, years 1 to 15Flat: from €25,184 in year 1 to €232,670 in year 15. ETF: from €97,320 to €181,222.0€50k€100k€150k€200k€250kYear 151015After year 10: fixed rateand speculation period endETF€181,222Flat€232,670Example B: wealth at sale, flat against ETF, years 1 to 15Flat: from €25,184 in year 1 to €232,670 in year 15. ETF: from €97,320 to €181,222.0€50k€100k€150k€200k€250kYear 151015After year 10: fixed rateand speculation period endETF€181,222Flat€232,670
All values as a table (example B)
YearFlatETFCash flow after tax
1€25,184€97,320−€2,838
2€25,798€101,911€497
3€29,673€99,338€7,818
4€30,823€97,254€7,256
5€32,957€95,664€6,711
6€39,509€97,905€2,853
7€50,279€108,754−€5,443
8€61,625€116,061−€1,469
9€73,546€124,001−€1,686
10€85,802€132,602−€1,896
11€182,559€140,048−€267
12€194,541€148,081−€416
13€206,877€161,496−€5,162
14€219,582€171,016−€693
15€232,670€181,222−€822

Verdict: The new build beats the ETF if you hold it for more than ten years.

After 15 years the flat is €51,448 ahead, and the return on your equity is 7.1% a year. Declining-balance and special depreciation carry this: they lower the tax, and in years 2 to 6 the cash flow after tax is positive. Until year 10 the ETF is still ahead. Only after that does a sale trigger neither tax on the gain nor a prepayment penalty. The calculator checks the special depreciation through the living area: the building share with closing costs is about €332,000, which on 78 m² is roughly €4,260 per m². That is below the limit of €5,200 per m², but at most €4,000 per m² is funded, so €312,000.

Calculate with your numbers

Free, no account. Saving needs an account.

Example CFlat wins from year 11

Listed old building in Saxony: the depreciation pays off mostly at a high tax rate

An old building in Saxony from 1908, purchase price €340,000. Of that, €170,000 goes to the renovation of a listed monument, depreciated at the higher rate under § 7i EStG. Base rent €980, service charge €330, €70,000 of equity, 4.2% interest. Your taxable income: €110,000.

Inputs
TypeExisting building
Purchase price€340,000
StateSaxony
Year built1908
Base rent per month€980
Service charge per month€330
Equity€70,000
Interest4.2%
Repayment1.5%
Fixed rate10 years
Depreciationstraight-line plus monument depreciation § 7i on €170,000
Taxable income€110,000, single filing
Agent fee at purchase3.57%
Property transfer tax5.5%
Sale after15 years
Assumed ETF return6.0% per year
Assumptions, defaults in the calculator
Land share, not depreciable25.0%
Vacancy3.0%, plus a tenant change every 6 years with 2 months of vacancy
Upkeep per year€1,200
Chargeable service charge per month€200
Rent increase2.0% per year
Cost increase2.5% per year
Value increase1.5% per year
Selling costs3.57%
Follow-up rate after the fixed period5.0%

Result

Gross rental yield
3.5%net 2.3%
Avg. top-up in years with a shortfall (years 1 to 10)
€12per month. Years without a shortfall count as €0. €14,453 in total over 15 years
Avg. net cash flow after tax per month (years 1 to 10)
+€115Plus and minus netted. A minus is money you top up.
Return on your equity (IRR)
7.2%per year, after everything
After 15 years
€180,778Flat, ETF: €141,496
Example C: wealth at sale, flat against ETF, years 1 to 15Flat: from −€9,099 in year 1 to €180,778 in year 15. ETF: from €71,448 to €141,496.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€9,099ETF€141,496Flat€180,778Example C: wealth at sale, flat against ETF, years 1 to 15Flat: from −€9,099 in year 1 to €180,778 in year 15. ETF: from €71,448 to €141,496.0€50k€100k€150k€200kYear 151015After year 10: fixed rateand speculation period end−€9,099ETF€141,496Flat€180,778
All values as a table (example C)
YearFlatETFCash flow after tax
1−€9,099€71,448€2,174
2€5,081€73,012€2,164
3€9,081€74,704€2,152
4€13,024€76,534€2,135
5€17,250€78,511€2,117
6€21,766€84,534−€1,493
7€26,581€87,037€2,072
8€31,701€89,738€2,043
9€38,805€94,424€238
10€45,565€99,426€201
11€139,636€102,514€2,386
12€149,469€110,044−€1,523
13€159,596€119,969−€3,813
14€170,028€130,441−€3,811
15€180,778€141,496−€3,812

Verdict: The monument depreciation pays off mostly at a high tax rate.

With €110,000 of taxable income you get €11,062 of tax back in the first year. The cash flow after tax is already positive in year 1: +€2,174. You top up in one of the first 10 years, in year 6. The average top-up in years with a shortfall is €12 a month, and the average net cash flow after tax over years 1 to 10 is +€115. After 15 years the flat is €39,282 ahead of the ETF, but here too only after year 10. With a lower income, the same depreciation brings back less.

Calculate with your numbers

Free, no account. Saving needs an account.

03 / Methodology

How Cashcolt calculates

Every year on its own, from purchase to sale. The full derivation is on the methodology page.

  1. Loan as an annuity

    Interest and repayment from your interest rate and initial repayment, month by month.

  2. Fixed rate and follow-up rate

    After the fixed rate period, Cashcolt keeps calculating with the follow-up rate, preset to 5.0%. Selling earlier means a prepayment penalty: in example A, €30,304 in the first year.

  3. Vacancy and upkeep

    3.0% is deducted from the rent, plus a tenant change every 6 years with 2 months of vacancy. Upkeep and the part of the service charge you cannot pass on count as running costs, 2.5% more expensive each year.

  4. Depreciation under § 7, § 7b and § 7i EStG

    The building share is depreciated; 25.0% land share stays out. Straight-line under § 7, or 5.0% declining balance for new builds. § 7b: 4 years at 5.0% on top, for new builds with EH40 and the QNG seal, basis capped at €4,000 per m², and not at all above €5,200 building cost per m². § 7i: 8 years at 9.0%, then 4 years at 7.0% on the renovation. The tax follows from your income.

  5. Sale and speculation period

    The value rises 1.5% a year. A sale counts 3.57% selling costs and the remaining debt. Within 10 years the gain is taxable; after more than 10 years it is tax-free.

  6. ETF with flat-rate tax

    The same money, equity plus every top-up, in the ETF. Gains after flat-rate tax (25.0%) and solidarity surcharge, with a 30.0% partial exemption for equity funds.

Methodology in detail

04 / Questions

Frequently asked questions

Why is the yield in the listing higher than in the calculator?

The listing divides the annual rent by the purchase price. Closing costs, service charge, vacancy, interest and taxes are missing. The calculator deducts vacancy, costs and closing costs: in example A, 2.4% net remain instead of 3.6% gross. What is left after interest, taxes and sale is the return on your equity, 2.1% a year in example A.

Why does Cashcolt compare with an ETF?

Because you could invest the money differently. The comparison puts your equity and every monthly top-up into an ETF and deducts the flat-rate tax. That shows whether the effort of owning the flat pays off.

What does the ten-year rule mean when selling?

If you sell a rented flat within 10 years of buying it, the gain is taxable (§ 23 EStG). After more than 10 years it is tax-free. That is why the flat curve jumps after year 10: from then on a sale triggers neither tax on the gain nor a prepayment penalty, provided the fixed rate has ended by then.

Which depreciation applies to my flat?

That depends on the year of construction. Straight-line is 2.0% a year for buildings completed between 1925 and 2022, 2.5% for older ones and 3.0% for new builds from 2023. New builds can alternatively use 5.0% declining balance. Special depreciation under § 7b can come on top: 4 years at 5.0%, for new builds with EH40 and the QNG seal. The basis is capped at €4,000 per m², and it does not apply above €5,200 building cost per m². Listed monuments fall under § 7i: 8 years at 9.0%, then 4 years at 7.0% on the renovation costs. Only the building share is depreciated, not the land.

Is the calculator really free?

Yes. You need no account and no email address. You only need an account once you want to save flats or calculate several together.

Does the calculator replace tax advice?

No. It shows how costs, taxes and a sale play out with your assumptions. For your tax return and special cases such as § 7b or § 7i, ask a tax advisor.

Author and date

All your flats in one place.

With an account you save flats, calculate them all together with one tax and plan the follow-up financing. 30 days of everything, free.