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.
| Type | Existing building |
|---|---|
| Purchase price | €260,000 |
| State | North Rhine-Westphalia |
| Year built | 1995 |
| Base rent per month | €780 |
| Service charge per month | €330 |
| Equity | €52,000 |
| Interest | 4.2% |
| Repayment | 1.5% |
| Fixed rate | 10 years |
| Depreciation | straight-line |
| Taxable income | €70,000, single filing |
| Agent fee at purchase | 3.57% |
| Property transfer tax | 6.5% |
| Sale after | 15 years |
| Assumed ETF return | 6.0% per year |
| Assumptions, defaults in the calculator | |
| Land share, not depreciable | 25.0% |
| Vacancy | 3.0%, plus a tenant change every 6 years with 2 months of vacancy |
| Upkeep per year | €650 |
| Chargeable service charge per month | €200 |
| Rent increase | 2.0% per year |
| Cost increase | 2.5% per year |
| Value increase | 1.5% per year |
| Selling costs | 3.57% |
| Follow-up rate after the fixed period | 5.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
All values as a table (example A)
| Year | Flat | ETF | Cash 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.
Free, no account. Saving needs an account.