Yearly return if you sell (after all taxes) — Furnished flat-share in Melun — LMNP · ID 02LMNPLMNP MWRR after sale
This page shows the yearly return on the money you put in if you sell, after every tax. Result for year 25: 5.57% per year.
Where each number comes from
Each link opens the page that calculates that figure.
- Cash you end up with if you sell Rental account + cash from the sale after tax
- Your rental account, year by year LMNP personal rental account (opening, interest, flat tax, tax, payments after the purchase, closing)
- Tax and cash left each year LMNP income tax, social contributions, after-tax cash flow
- Income you are taxed on each year LMNP taxable income (régime réel: result, losses, wear-and-tear)
- Profit per year Cash flow page: rent − costs − loan interest, before tax
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Cash flow before tax (rent − costs − loan payments) Cash Flow
- Income you are taxed on each year LMNP taxable income (régime réel: result, losses, wear-and-tear)
- Tax and cash left each year LMNP income tax, social contributions, after-tax cash flow
- Tax on the gain when you sell Plus-value des particuliers (LMNP resale)
- What the sale leaves after the loan and fees Net Sale Proceeds Ledger
- Wear-and-tear actually deducted Depreciation used (taxable-income page), taken off the purchase price at resale
- Profit per year Cash flow page: rent − costs − loan interest, before tax
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Your rental account, year by year LMNP personal rental account (opening, interest, flat tax, tax, payments after the purchase, closing)
- Your rental account, year by year LMNP personal rental account (opening, interest, flat tax, tax, payments after the purchase, closing)
- Tax and cash left each year LMNP income tax, social contributions, after-tax cash flow
- Income you are taxed on each year LMNP taxable income (régime réel: result, losses, wear-and-tear)
- Profit per year Cash flow page: rent − costs − loan interest, before tax
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Cash flow before tax (rent − costs − loan payments) Cash Flow
- Income you are taxed on each year LMNP taxable income (régime réel: result, losses, wear-and-tear)
- Tax and cash left each year LMNP income tax, social contributions, after-tax cash flow
Part 1. The short answerKey figures
You own the flat yourself and rent it out furnished under the LMNP “régime réel”: the rent minus the real costs and a yearly wear-and-tear deduction is added to your income and taxed each year, and the gain is taxed when you sell. Figures below are for selling at the end of year 25.
No income tax until year 2: until then the result is either negative (year 1: the purchase fees) or covered by wear-and-tear (this year's and the amount saved); past losses come only after that, within their 10 years.
Part 2. Cash at purchase and payments after the purchaseMoney injected
Year 0: the cash at purchase, €60,233. After that, the cash you add whenever your rental account would go below €0 (a payment after the purchase): €0 through year 25.
| Year | Rental account after the purchase, before your payment | Put in (payment after the purchase)1 | Rental account (closing) |
|---|---|---|---|
| 1 | €6,627 | €0 | €6,627 |
| 2 | €12,115 | €0 | €12,115 |
| 3 | €14,876 | €0 | €14,876 |
| 4 | €17,742 | €0 | €17,742 |
| 5 | €20,596 | €0 | €20,596 |
| 6 | €23,433 | €0 | €23,433 |
| 7 | €26,251 | €0 | €26,251 |
| 8 | €28,884 | €0 | €28,884 |
| 9 | €31,494 | €0 | €31,494 |
| 10 | €34,070 | €0 | €34,070 |
| 11 | €36,608 | €0 | €36,608 |
| 12 | €39,105 | €0 | €39,105 |
| 13 | €41,556 | €0 | €41,556 |
| 14 | €43,956 | €0 | €43,956 |
| 15 | €46,301 | €0 | €46,301 |
| 16 | €48,300 | €0 | €48,300 |
| 17 | €50,238 | €0 | €50,238 |
| 18 | €52,097 | €0 | €52,097 |
| 19 | €53,871 | €0 | €53,871 |
| 20 | €55,553 | €0 | €55,553 |
| 21 | €64,757 | €0 | €64,757 |
| 22 | €74,188 | €0 | €74,188 |
| 23 | €83,848 | €0 | €83,848 |
| 24 | €93,742 | €0 | €93,742 |
| 25 | €103,877 | €0 | €103,877 |
Part 3. Final amount at year 25
| Year | Cash flow after taxAfter-tax cash flow | Interest after the flat tax | Total |
|---|---|---|---|
| 1 | €5,555 | €29 | €5,583 |
| 2 | €5,305 | €182 | €5,487 |
| 3 | €2,429 | €332 | €2,762 |
| 4 | €2,458 | €408 | €2,866 |
| 5 | €2,366 | €487 | €2,853 |
| 6 | €2,272 | €565 | €2,837 |
| 7 | €2,176 | €643 | €2,819 |
| 8 | €1,913 | €720 | €2,633 |
| 9 | €1,817 | €793 | €2,610 |
| 10 | €1,712 | €864 | €2,576 |
| 11 | €1,604 | €935 | €2,538 |
| 12 | €1,492 | €1,005 | €2,497 |
| 13 | €1,378 | €1,073 | €2,451 |
| 14 | €1,260 | €1,140 | €2,400 |
| 15 | €1,139 | €1,206 | €2,345 |
| 16 | €729 | €1,270 | €1,999 |
| 17 | €612 | €1,325 | €1,938 |
| 18 | €480 | €1,379 | €1,859 |
| 19 | €344 | €1,430 | €1,774 |
| 20 | €204 | €1,478 | €1,683 |
| 21 | €7,680 | €1,524 | €9,204 |
| 22 | €7,655 | €1,777 | €9,431 |
| 23 | €7,624 | €2,036 | €9,660 |
| 24 | €7,593 | €2,301 | €9,894 |
| 25 | €7,562 | €2,572 | €10,134 |
- Cash left in your rental account after the purchase€1,044
- +Cash from the sale after tax€129,909
- =Added in year 25, the year you sell€130,953
- Money into your rental account, years 1–25€102,833
- +Added in year 25, the year you sell€130,953
- −Cash at purchase€60,233
- =Total profit€173,553
- Total cash put in (Part 2)€60,233
- +Total profit€173,553
- =Final amount€233,786
Check: the final amount is also your rental account at the end of year 25 (€103,876.85) + the cash from the sale after tax (€129,908.92) = €233,785.76 — cash you end up with if you sell.
Part 4. The formula
R = 5.57460673%: Σ Inj_t × (1 + R)^(25 − t) = €233,785.76; minus the final amount €233,785.76 = €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 5. ResultResult + proof
Part 6. Yearly return by sale year (MWRR)MWRR by year
The same method for every sale year. Every year uses the projected sale price for that year, except the year you plan to sell (25), which uses your own sale price when you entered one.
| Year | Cash you end up with if you sell | Yearly return (MWRR)1 |
|---|---|---|
| 1 | €18,869 | -68.67% |
| 2 | €28,690 | -30.98% |
| 3 | €35,105 | -16.47% |
| 4 | €41,650 | -8.81% |
| 5 | €48,332 | -4.31% |
| 6 | €60,899 | 0.18% |
| 7 | €68,923 | 1.94% |
| 8 | €76,038 | 2.96% |
| 9 | €83,398 | 3.68% |
| 10 | €91,005 | 4.21% |
| 11 | €98,861 | 4.61% |
| 12 | €106,969 | 4.90% |
| 13 | €115,329 | 5.12% |
| 14 | €123,944 | 5.29% |
| 15 | €132,816 | 5.41% |
| 16 | €141,795 | 5.50% |
| 17 | €151,009 | 5.56% |
| 18 | €160,462 | 5.59% |
| 19 | €170,155 | 5.62% |
| 20 | €180,088 | 5.63% |
| 21 | €190,187 | 5.63% |
| 22 | €200,397 | 5.62% |
| 23 | €211,189 | 5.61% |
| 24 | €222,317 | 5.59% |
| 25 | €233,786 | 5.57% |