Marketplace Deal
Cologne Studio – Ehrenfeld
Cologne, Germany · Apartment
Deal Score
86/ 100
Excellent
Gross Yield
6.51%
Cap Rate
4.65%
Faktor
15.4×
Pre-Tax Cashflow
-38 €
/moTax Refund (AfA)
-12 €
/moAfter-Tax Cashflow
-50 €
/moDSCR
0.95
EKR (Cash-on-Cash)
8.60%
Total Invested
69.500 €
AI Investment Commentary
AI analysis temporarily unavailable. Review the metrics above for your investment decision.
Year 1 Cashflow Breakdown
Einnahmen & Ausgaben — monthly view
-50 €
after-tax / month
+
Gross Rental IncomeKaltmiete
950 €-
Vacancy Deduction4% Leerstand
−38 €=
Effective IncomeNettomieteinnahmen
912 €-
Mortgage InterestZinszahlung (Jahr 1)
−368 €-
Principal RepaymentTilgung
−349 €-
Operating ExpensesHausgeld & Verwaltung
−233 €=
Pre-Tax CashflowCashflow vor Steuern
38 €-
AfA Depreciation (2%)Abschreibung p.a. (steuerlich)
−284 €+
Tax Refund (42% rate)Steuerrückerstattung
12 €=
After-Tax CashflowCashflow nach Steuern
50 €Faktor
15.4×
AfA Base (80%)
170.100 €
Annual AfA
3.402 €
Annual Tax Refund
-139 €
Annual Breakdown
Net Annual Cashflow-457 €
10-Year Equity & Cashflow
Property Value Projection
Year 10235.185 €
10-Year Annual Projection
Annual Summary — interest, principal, tax refund & cashflow
| Year | Zinsen Interest | Tilgung Principal | CF vor St. Pre-Tax | Steuerrückerstattung Tax Refund | CF nach St. After-Tax | Monatlich After-Tax/mo |
|---|---|---|---|---|---|---|
| Year 1 | −4.410 € | 4.191 € | -185 € | -254 € | -439 € | -37 € |
| Year 2 | −4.257 € | 4.345 € | +96 € | -436 € | -340 € | -28 € |
| Year 3 | −4.098 € | 4.504 € | +386 € | -625 € | -239 € | -20 € |
| Year 4 | −3.933 € | 4.668 € | +686 € | -820 € | -134 € | -11 € |
| Year 5 | −3.762 € | 4.839 € | +995 € | -1.021 € | -26 € | -2 € |
| Year 6 | −3.585 € | 5.016 € | +1.313 € | -1.230 € | +83 € | +7 € |
| Year 7 | −3.401 € | 5.200 € | +1.642 € | -1.445 € | +197 € | +16 € |
| Year 8 | −3.211 € | 5.390 € | +1.982 € | -1.667 € | +315 € | +26 € |
| Year 9 | −3.014 € | 5.588 € | +2.332 € | -1.897 € | +435 € | +36 € |
| Year 10 | −2.809 € | 5.792 € | +2.693 € | -2.135 € | +558 € | +47 € |
| 10-Year Total | −36.480 € | 49.533 € | +11.940 € | +-11.530 € | +410 € | avg 3 €/mo |
Financial Summary
Purchase Price
175.000 €
Down Payment
52.500 €
Loan Amount
122.500 €
Monthly Mortgage
717 €
NOI (Annual)
8.144 €
Annual Debt Service
8.601 €
German Tax Analysis (AfA / Steuerrückerstattung)
AfA Rate
2% p.a.
Annual AfA Deduction
3.402 €
Year 1 Interest Paid
4.410 €
Taxable Rental Income (V+V)
332 €
Annual Tax Refund
-139 €
After-Tax Annual Cashflow
-597 €