Yearly return, unsold, before tax — T3 in Melun — réel foncier · ID 05Réel foncierMoney-weighted return (MWRR) on what the property is worth to you before tax

Year 20: 5.82% a year on your cash, without selling.

Where each number comes from

Each link opens the page that calculates that figure.

  1. Loan paid off (equity built) Equity from Loan
  2. Property value increase Appreciation
  3. Your rental account, before tax the same account with no income tax, social or flat tax
    1. Cash flow before tax (rent − costs − loan payments) Cash Flow
Part 1. Cash at purchase and payments after the purchase

€33,400 at the start (year 0), then €26,156 of payments after the purchase, each in its own year.

Part 2. The final amount, year 20
  • Equity you own (day-1 equity + loan paid off)€121,513
  • +Value increase€36,331
  • +Your rental account, before tax€0
  • =What the property is worth to you before tax€157,844
Part 3. The formula

R = 5.81625649%: Σ Inj_t × (1 + R)^(20 − t) = €157,844.50; minus the final amount €157,844.50 = €0.00 — R is the rate that makes this €0. Each amount is put in at the end of its year t and grows from the next year on, for N − t years (the cash at purchase, year 0, for all N).

Part 4. The result
Total cash put in€59,556
Final amount€157,844
Multiple2.65
Yearly return5.82%
Part 5. Every year
YearFinal amountYearly return1
1€10,812-74.54%
2€16,782-37.31%
3€22,914-19.35%
4€29,215-10.08%
5€35,690-4.78%
6€42,344-1.52%
7€49,1820.61%
8€56,2112.05%
9€63,4363.06%
10€70,8653.79%
11€78,5024.32%
12€86,3564.72%
13€94,4335.02%
14€102,7405.24%
15€111,2845.42%
16€120,0745.55%
17€129,1165.65%
18€138,4205.72%
19€147,9935.78%
20€157,8445.82%
21€167,9835.84%
22€178,4305.86%
23€189,3085.87%
24€200,6345.88%
25€212,4215.88%