Yearly return on your cash, before tax (unsold) — Furnished flat-share in Melun — LMNP · ID 02LMNPLMNP MWRR before tax

This page shows the yearly return on the money you put in if you do not sell, before any tax. Result for year 25: 7.84% per year.

Where each number comes from

Each link opens the page that calculates that figure.

Loan paid off (equity built) Equity from Loan
Property value increase Appreciation
Your rental account, before any tax LMNP account, before-tax stage
1. Cash flow before tax (rent − costs − loan payments) Cash Flow

Year:

Part 1. Cash at purchase and payments after the purchaseMoney injected

Year 0: the cash at purchase, €60,233. After that, whatever you add to keep your rental account before tax at €0 or more (a payment after the purchase). Before tax there is no tax to pay, so only the rent’s own shortfalls count.

Year	Opening	Interest¹	Cash flow before tax, per year	Put in (payment after the purchase)²	Closing
1	€1,044	€42	€5,555	€0	€6,640
2	€6,640	€266	€5,512	€0	€12,418
3	€12,418	€497	€5,469	€0	€18,384
4	€18,384	€735	€5,425	€0	€24,545
5	€24,545	€982	€5,381	€0	€30,908
6	€30,908	€1,236	€5,336	€0	€37,480
7	€37,480	€1,499	€5,291	€0	€44,270
8	€44,270	€1,771	€5,244	€0	€51,285
9	€51,285	€2,051	€5,198	€0	€58,534
10	€58,534	€2,341	€5,150	€0	€66,026
11	€66,026	€2,641	€5,102	€0	€73,769
12	€73,769	€2,951	€5,053	€0	€81,772
13	€81,772	€3,271	€5,004	€0	€90,047
14	€90,047	€3,602	€4,953	€0	€98,602
15	€98,602	€3,944	€4,902	€0	€107,449
16	€107,449	€4,298	€4,851	€0	€116,597
17	€116,597	€4,664	€4,799	€0	€126,060
18	€126,060	€5,042	€4,745	€0	€135,848
19	€135,848	€5,434	€4,692	€0	€145,973
20	€145,973	€5,839	€4,637	€0	€156,449
21	€156,449	€6,258	€12,199	€0	€174,907
22	€174,907	€6,996	€12,143	€0	€194,046
23	€194,046	€7,762	€12,086	€0	€213,894
24	€213,894	€8,556	€12,029	€0	€234,479
25	€234,479	€9,379	€11,970	€0	€255,828

Part 2. Final amount at year 25

Equity (day-1 + loan paid off)€125,000
+Value increase (end of year)€16,599
+Rental account before tax€255,828
=Final amount€397,428

\text{Final amount} = \text{Equity (day-1 + loan paid off)} + \text{Value increase (end of year)} + \text{Rental account before tax}

= \text{\text{€}125{,}000} + \text{\text{€}16{,}599} + \text{\text{€}255{,}828}

= \text{\text{€}397{,}428}

Final amount€397,428
−Total cash put in (Part 1)€60,233
=Total profit€337,195

\text{Total profit} = \text{Final amount} - \text{Total cash put in (Part 1)}

= \text{\text{€}397{,}428} - \text{\text{€}60{,}233}

= \text{\text{€}337{,}195}

The same figure as what the property is worth to you (unsold), Part 1 (year 25).

Part 3. The formula

R = 7.83930313%: Σ Inj_t × (1 + R)^(25 − t) = €397,427.64; minus the final amount €397,427.64 = €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. ResultResult + proof

Cash at purchase and payments after the purchase€60,233Total cash put in

Final amount€397,428

Multiple6.606.60× money put in

Yearly return (MWRR)7.84%

Part 5. Yearly return by holding period (MWRR)MWRR by year

Year	Final amount	Yearly return (MWRR)¹
1	€26,224	-56.46%
2	€36,720	-21.92%
3	€47,543	-7.58%
4	€58,705	-0.64%
5	€70,218	3.12%
6	€82,094	5.30%
7	€94,345	6.62%
8	€106,986	7.45%
9	€120,030	7.96%
10	€133,490	8.28%
11	€147,382	8.47%
12	€161,722	8.58%
13	€176,524	8.62%
14	€191,805	8.63%
15	€207,583	8.60%
16	€223,875	8.55%
17	€240,700	8.49%
18	€258,076	8.42%
19	€276,023	8.34%
20	€294,561	8.26%
21	€313,709	8.18%
22	€333,543	8.09%
23	€354,088	8.01%
24	€375,374	7.92%
25	€397,428	7.84%