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 1: -56.46% 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

Part 2. Final amount at year 1

Equity (day-1 + loan paid off)€18,958
+Value increase (end of year)€625
+Rental account before tax€6,640
=Final amount€26,224

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

= \text{\text{€}18{,}958} + \text{\text{€}625} + \text{\text{€}6{,}640}

= \text{\text{€}26{,}224}

Final amount€26,224
−Total cash put in (Part 1)€60,233
=Total profit(-€34,009)

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

= \text{\text{€}26{,}224} - \text{\text{€}60{,}233}

= -\text{\text{€}34{,}009}

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

Part 3. The formula

R = −56.46258920%: Σ Inj_t × (1 + R)^(1 − t) = €26,223.69; minus the final amount €26,223.69 = €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€26,224

Multiple0.440.44× money put in

Yearly return (MWRR)-56.46%

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%