Where your rent goes, year after year — T3 in Melun — réel foncier · ID 05Réel foncierRent split → money lost / capital repaid / cash kept

This page shows where each year's rent goes: the money lost, the capital repaid and the cash kept after tax. Result for year 20: of €13,867 rent, €9,695 is lost, €7,858 repays the loan and €3,687 of cash after tax is missing (paid from your pocket) — profit €4,171, 30.08% of the rent.

Where each number comes from

Each link opens the page that calculates that figure.

  1. Cash flow before tax (rent − costs − loan payments) Cash Flow
  2. Income tax, social contributions and cash flow after tax Taxable income × (your bracket + 17.2%), tax saved on other income, CSG tax back the next year
  3. Loan paid off (equity built) Equity from Loan
Part 1. From the rent to the money lostLost_t = running costs + loan interest + tax of the year

The running costs and the loan interest are the ones of the cash flow page; the tax of the year comes from the tax page. Added together they are the red top part of each bar: money that is spent and never comes back.

YearRent of the year1Loan interestBorrower insuranceTaxe foncièreCo-ownership chargesHome insurance, accountant, bank fees2Income tax + social contributions of the year (net of credits)3Money lost4
1€10,450€5,296€180€1,260€1,680€180-€3,210€5,386
2€10,607€5,155€180€1,285€1,714€180€0€8,514
3€10,766€5,009€180€1,311€1,748€180€0€8,427
4€10,927€4,857€180€1,337€1,783€180€0€8,337
5€11,091€4,701€180€1,364€1,818€180€0€8,243
6€11,258€4,539€180€1,391€1,855€180€737€8,881
7€11,426€4,371€180€1,419€1,892€180€1,567€9,610
8€11,598€4,198€180€1,447€1,930€180€1,661€9,597
9€11,772€4,019€180€1,476€1,968€180€1,790€9,615
10€11,948€3,834€180€1,506€2,008€180€1,923€9,631
11€12,128€3,643€180€1,536€2,048€180€2,059€9,645
12€12,310€3,445€180€1,567€2,089€180€2,198€9,659
13€12,494€3,241€180€1,598€2,131€180€2,341€9,670
14€12,682€3,029€180€1,630€2,173€180€2,487€9,680
15€12,872€2,810€180€1,663€2,217€180€2,638€9,688
16€13,065€2,584€180€1,696€2,261€180€2,792€9,694
17€13,261€2,350€180€1,730€2,306€180€2,951€9,697
18€13,460€2,109€180€1,764€2,352€180€3,114€9,699
19€13,662€1,859€180€1,800€2,399€180€3,281€9,698
20€13,867€1,600€180€1,836€2,447€180€3,452€9,695
21€14,075€1,333€180€1,872€2,496€180€3,628€9,690
22€14,286€1,056€180€1,910€2,546€180€3,809€9,682
23€14,500€771€180€1,948€2,597€180€3,995€9,671
24€14,718€475€180€1,987€2,649€180€4,186€9,657
25€14,938€169€180€2,027€2,702€180€4,382€9,640

A negative tax is a net credit (for example a deficit that lowers your tax on other income): it reduces the money lost.

Part 2. A loan payment splits into interest and capitalPayment = Interest + Principal (+ Insurance); Profit = Principal + Cash flow

Only the interest part of the loan payment is lost; the capital repaid lowers what you owe the bank, so it is yours. That is why the profit (rent − costs) is larger than the cash flow by exactly the capital repaid.

YearLoan interestCapital repaid1Cash flow (before tax)2Profit (before tax)3
1€5,296€4,162-€2,308€1,854
2€5,155€4,303-€2,210€2,093
3€5,009€4,450-€2,111€2,339
4€4,857€4,601-€2,011€2,590
5€4,701€4,758-€1,909€2,848
6€4,539€4,919-€1,807€3,113
7€4,371€5,087-€1,703€3,384
8€4,198€5,260-€1,597€3,662
9€4,019€5,439-€1,491€3,948
10€3,834€5,624-€1,383€4,240
11€3,643€5,815-€1,274€4,541
12€3,445€6,013-€1,164€4,849
13€3,241€6,218-€1,053€5,165
14€3,029€6,429-€940€5,489
15€2,810€6,648-€826€5,822
16€2,584€6,874-€710€6,164
17€2,350€7,108-€593€6,514
18€2,109€7,350-€475€6,874
19€1,859€7,600-€356€7,244
20€1,600€7,858-€235€7,623
21€1,333€8,125-€112€8,013
22€1,056€8,402€11€8,413
23€771€8,688€137€8,824
24€475€8,983€263€9,246
25€169€9,289€391€9,680
Part 3. What is left for you: capital repaid + cash = profitRent = Lost + Principal + Cash after tax; share kept = Profit after tax ÷ Rent

The cash kept after tax is the cash flow minus the tax of the year. What is left for you, the profit after tax, is the capital repaid plus that cash — the top of the green part of the bar — and equally the rent minus the money lost. The share of the rent you keep is that profit divided by the rent, shown next to the year when you point at the chart.

  • Rent of the year€13,867
  • −Money lost€9,695
  • =Profit after tax€4,171
  • Capital repaid€7,858
  • +Cash kept after tax(-€3,687)
  • =Profit after tax€4,171

Year 20: €4,171 of the €13,867 rent stays yours — 30.08% of the rent.

Rent (Year 20)€13,867
Money lost (Year 20)€9,695
Capital repaid€7,858
Cash kept after tax-€3,687
Profit after tax€4,171
Share of the rent you keep30.08%
YearRent of the yearMoney lost1Capital repaidIncome tax + social contributions of the year (net of credits)2Cash kept after tax3Profit after tax4Share of the rent you keep5
1€10,450€5,386€4,162-€3,210€902€5,06448.45%
2€10,607€8,514€4,303€0-€2,210€2,09319.73%
3€10,766€8,427€4,450€0-€2,111€2,33921.72%
4€10,927€8,337€4,601€0-€2,011€2,59023.70%
5€11,091€8,243€4,758€0-€1,909€2,84825.68%
6€11,258€8,881€4,919€737-€2,543€2,37621.11%
7€11,426€9,610€5,087€1,567-€3,270€1,81715.90%
8€11,598€9,597€5,260€1,661-€3,259€2,00117.25%
9€11,772€9,615€5,439€1,790-€3,281€2,15718.33%
10€11,948€9,631€5,624€1,923-€3,306€2,31819.40%
11€12,128€9,645€5,815€2,059-€3,333€2,48220.47%
12€12,310€9,659€6,013€2,198-€3,362€2,65121.54%
13€12,494€9,670€6,218€2,341-€3,393€2,82422.60%
14€12,682€9,680€6,429€2,487-€3,427€3,00223.67%
15€12,872€9,688€6,648€2,638-€3,463€3,18424.74%
16€13,065€9,694€6,874€2,792-€3,502€3,37125.81%
17€13,261€9,697€7,108€2,951-€3,544€3,56426.87%
18€13,460€9,699€7,350€3,114-€3,589€3,76127.94%
19€13,662€9,698€7,600€3,281-€3,636€3,96329.01%
20€13,867€9,695€7,858€3,452-€3,687€4,17130.08%
21€14,075€9,690€8,125€3,628-€3,741€4,38531.15%
22€14,286€9,682€8,402€3,809-€3,798€4,60432.23%
23€14,500€9,671€8,688€3,995-€3,859€4,82933.30%
24€14,718€9,657€8,983€4,186-€3,923€5,06034.38%
25€14,938€9,640€9,289€4,382-€3,991€5,29835.47%

A negative cash kept after tax is drawn below zero on the chart: the rent did not cover all the costs and the capital repaid, and the difference came out of your pocket.

The interest on your rental account (earned, or paid to a lender) and the flat tax on the interest earned are not on this chart; the tax shown is the year’s income tax and social contributions as worked out for your regime: see “Your wealth over time”.

Each amount in the worked lines is rounded to the cent, so a line can differ by €0.01.

Part 4. Month by month (year 20)

Year 20 in detail — the year picked above: the rent, the costs and the profit of the year, then what you pay every month.

Rent, costs and profit (Cash Flow & Profit)

  • Rent per year (months actually rented)1Total Income — Annual
    €13,867
  • Cash flow before tax, per year2Cash Flow — Annual
    -€235
  • Profit per year (income − costs, before tax)3Profit = Total Gain — Annual
    €7,623
  • …kept as cash4…of which kept as cash
    -€235
  • Of which used to pay down the loan5
    €7,858

Your tax this year (réel foncier, the statement year)

  • Rent collected1rent as entered × months rented, grown each year
    €13,867
  • − The tenant’s charges included in the rent2recoverable charges (provisions), not taxed
    -€1,022
  • = Gross rent3revenus bruts fonciers, excluding the tenant’s charges
    €12,845
  • − Loan interest and loan insurance4intérêts et frais d’emprunt: offset first by the gross rent
    -€1,780
  • − Other deductible charges5taxe foncière, co-ownership, insurance, accountant, utilities, €20, works − the recoverable charges
    -€3,437
  • = Result of the year6revenu ou déficit foncier (negative = a deficit)
    €7,627
  • = Taxable income7the year’s result after past deficits, never below €0
    €7,627
  • Income tax8taxable income × your bracket (TMI)
    €2,288
  • Social contributions (17.2%)9taxable income × 17.2% (prélèvements sociaux on rental income)
    €1,312
  • Cash flow before tax10cash flow: rent − every cost − the loan payment (same figure as above, Month by month)
    -€235
  • CSG tax back received (from last year)11last year’s taxable income × 6.8% × your bracket
    €148
  • Cash flow after the yearly tax12cash flow − income tax − social + CSG tax back received + tax saved on your other income
    -€3,687

Every year: Your tax each year →

What you pay every month (Obligations)

  • Loan payment (interest + principal + insurance)1Loan payment (P+I+Insurance)
    €803
  • Building charges (syndic)2
    €204
  • Property tax (taxe foncière)3
    €153
  • Home insurance(given)
    €13
  • Accountant fees(given)
    €0
  • Bank fees(given)
    €2
  • Total per month4TOTAL MONTHLY OBLIGATION
    €1,175

Loan principal/interest (the “Your inputs and one-off costs” section's loan repayment schedule) reflect Year 20's figures — for a bank-stated loan, the bank's payment, split into interest and principal as in the projection; property tax/syndic reflect Year 20's figures grown at their own rates (the “Your inputs and one-off costs” section). Insurance, accountant, and bank fees have no growth assumption in this model, so they stay at their entered monthly amount every year. The income tax and social contributions above are paid once a year, not monthly.