Yearly return if you sell in year N (money-weighted) — Furnished flat-share in Melun — SCI à l’IS · ID 04SCI ISMWRR — After Sale
This page shows how the money-weighted yearly return if you sell is worked out: every euro you put in, grown at one rate from the year you put it in, must add up to the cash you walk away with if you sell in year 1. Result if you sell in year 1: -69.47% per year.
Where each number comes from
Each link opens the page that calculates that figure.
- Rent kept after all costs (cash flow) Cash Flow
- Interest paid to you by the company Compte-Courant Cash Effect
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Savings account for the rent you keep (below €0 = cash borrowed from your other properties or a lender) Reinvestment/Financing Account
- Rent kept after all costs (cash flow) Cash Flow
- Interest paid to you by the company Compte-Courant Cash Effect
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Company tax paid each year IS Ledger
- Profit the tax office sees (cumulative) Cumulative Pool
- Profit after allowed deductions Taxable Profit
- Interest on the money you lent your company Compte Courant
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Interest on the money you lent your company Compte Courant
- Profit after allowed deductions Taxable Profit
- Profit after allowed deductions Taxable Profit
- Interest on the money you lent your company Compte Courant
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Interest on the money you lent your company Compte Courant
- Profit the tax office sees (cumulative) Cumulative Pool
- Company tax paid each year IS Ledger
- Profit the tax office sees (cumulative) Cumulative Pool
- Profit after allowed deductions Taxable Profit
- Interest on the money you lent your company Compte Courant
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Savings account for the rent you keep (below €0 = cash borrowed from your other properties or a lender) Reinvestment/Financing Account
- Rent kept after all costs (cash flow) Cash Flow
- Interest paid to you by the company Compte-Courant Cash Effect
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Interest on the money you lent your company Compte Courant
- Profit after allowed deductions Taxable Profit
- Profit after allowed deductions Taxable Profit
- Interest on the money you lent your company Compte Courant
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Savings account for the rent you keep (below €0 = cash borrowed from your other properties or a lender) Reinvestment/Financing Account
- Rent kept after all costs (cash flow) Cash Flow
- Interest paid to you by the company Compte-Courant Cash Effect
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
- Interest on the money you lent your company Compte Courant
- Profit the tax office sees (cumulative) Cumulative Pool
- Cost of selling Selling Cost Ledger
- Company tax on the sale profit IS on gain
- Profit on the sale (capital gain) Capital Gain
- Profit the tax office sees, including the sale Pool with Sale
- Profit the tax office sees (cumulative) Cumulative Pool
- Profit on the sale (capital gain) Capital Gain
- Profit after allowed deductions Taxable Profit
- Exit tax (on the payout) Impôt (exit distribution tax)
- Money available at sale (before exit tax) Total Distributable Ledger
- What the sale leaves after the loan and fees Net Sale Proceeds Ledger
- Savings account for the rent you keep (below €0 = cash borrowed from your other properties or a lender) Reinvestment/Financing Account
- Total company tax if you sell in year N IS at Exit Ledger (Cum IS at Exit)
- Profit on the sale (capital gain) Capital Gain
- Profit the tax office sees, including the sale Pool with Sale
- Profit the tax office sees (cumulative) Cumulative Pool
- Profit on the sale (capital gain) Capital Gain
- Profit after allowed deductions Taxable Profit
- Interest on the money you lent your company Compte Courant
- Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
- Money available at sale (before exit tax) Total Distributable Ledger
Part 1. What you paid inMoney injected
Company lender rate > 0: shortfalls are covered by a lender's short-term loan (not your money). Rate = 0: shortfalls are paid by you and counted here. The company's lender rate (one for the whole company: the portfolio's setting, else the first property's) is 0.00%, so you cover shortfalls personally — each year you put in exactly what keeps the company account at €0 (the payment after the purchase shown on the Savings account page, which also joins your compte courant and is paid back at the sale).
Year 0 is the initial investment; after that, the injections are the payments after the purchase of the savings account page, Part 3. Each is made at the end of its year and grows from the next year on.
| Year | Injected1 |
|---|---|
| 0 | €60,233 |
| 1 | €0 |
Part 2. Final amount at year N
| Year | Cash Flow | Interest paid to you by the companyCompte-Courant Cash Effect | Reinvestment/Financing Interest | Company tax (IS), this yearIS Annual | Total |
|---|---|---|---|---|---|
| 1 | €5,555 | -€490 | €42 | €0 | €5,106 |
What's added at Year 1 from selling the property. Sale IS is specifically the sale-driven portion of the pooled IS bracket call (IS at Exit Ledger's own isOnCapitalGainDisplay), not the full combined bracket figure. The bank loan's own financing cost is already inside Cash Flow (the loan annuity) and inside Remaining Loan Balance here — it is not added again. The Compte-Courant loan balance is deliberately not its own line here either — its tax-reducing effect is already inside Impôt below (repaying it lowers the taxable distribution base before the rate is applied, see Net Cash to Associates) — adding the balance again would double it.
- Cash left in the company account after the purchase (paid back)€1,044
- +Gross Sale Price€125,625
- −Selling Agency Fee€6,281
- −Loan Payoff Costs€1,060
- −Remaining Loan Balance€106,042
- −Sale IS€0
- −Exit tax (on the payout)€0
- =Exit-Year Extras€13,286
Each amount in the worked lines is rounded to the cent, so a line can differ by €0.01.
Year 1: sale extras = €1,044.04 (cash left in the company after the purchase, paid back) + €125,625.00 (sale price) − €6,281.25 (agency fee) − €1,060.42 (loan payoff costs) − €106,041.76 (loan left) − €0.00 (the tax on the sale gain, IS at Exit Part 3) − €0.00 (its exit tax on the payout, Net cash page) = €13,285.61.
Sources: Cost of selling (sale price, fees, loan left) · Total company tax if you sell (the tax on the sale gains) · Cash you walk away with (the exit tax).
- Σ Totals (years 1–1)€5,106
- +Exit-Year Extras€13,286
- −Initial Investment€60,233
- =Total Profit(-€41,841)
Any deficit year's own negative Total is still counted here in full (the loss is real) — but that same amount is also added to Total Injected (Part 1), so it cancels out of the Final Amount below without disappearing from Total Profit.
- Total Injected (Part 1)€60,233
- +Total Profit(-€41,841)
- =Final Amount (FV_final)€18,392
Year 1: final amount = total injected €60,232.55 + €5,106.09 (Σ totals) + €13,285.61 (Year 1 sale extras) − €60,232.55 (initial investment) = €18,391.70.
Year 1: this equals the cash you walk away with, €18,391.70 (its page) — the money available at sale minus the exit tax.
Part 3. Cumulative chart
Cumulative build-up to the final amount
- Cash at purchase (day one)€0
- Rent kept after all costs (that year)€5,555
- Interest paid to you by the company-€490
- Interest earned (or paid) on the rent you keep€42
- What the sale leaves after the loan and fees€12,242
- Cash left in the company account after the purchase (paid back)€1,044
- Total profit-€41,841
Bars are drawn only for Year 0 (the initial investment) and Year 1 (that year's own amounts plus the Year 1 extras); the in-between years' amounts are too small to read at this scale, so they aren't drawn — hover any year for its full breakdown. Y-axis uses a compressed (signed arcsinh) scale; hover values and labels still show real, untransformed euro amounts. The total profit line tracks the running net profit through each year (starting at −€60,233, ending at Total Profit — the same Total Profit figure shown in Part 2) — add back Total Injected (Part 1), not just the Year 0 investment, to get the Final Amount from Part 2. No breakeven marker here deliberately — most of Total Profit lands all at once at Year N (Exit-Year Extras), so a mid-chart zero-crossing on the cumulative line wouldn't mean you'd actually recovered your money at that point, only that the running Total_t sum did.
Part 4. The formula
Each euro injected, compounded at R from its own injection year, equals the final amount. Built up in 3 steps: first the total actually injected, then the final amount it grew into, then R itself.
Step 1 — Total Injected
- Inj_0€60,233
- =Total Injected€60,233
Every other year (Inj_t for t not shown above) is €0 — omitted from the sum above rather than listing 1 zero rows.
Step 2 — Final Amount (FV_final)
- Σ Totals (years 1–1)€5,106
- +Exit-Year Extras€13,286
- −Initial Investment€60,233
- =Total Profit (Part 2)(-€41,841)
- Total Injected (Step 1)€60,233
- +Total Profit(-€41,841)
- =Final Amount (FV_final)€18,392
Step 3 — Solve for R
R ≈ −69.4655%: Σ Inj_t × (1 + R)^(1 − t) = €18,391.70; minus the final amount €18,391.70 = €0.00 — R is the rate that makes this €0. Each injection is made at the end of its year t and grows from the next year on, for N − t years (the initial investment, Year 0, for all N).
Part 5. ResultResult + proof
Depends on the rate idle cash earns in the Reinvestment/Financing Account — see Reinvestment/Financing Account.
Part 6. Yearly return by sell year (MWRR)MWRR by year
MWRR by exit year — the exact same method as Part 4, recomputed for every year 1 through 25 instead of just Year 1. Use the year selector above to view any one of these years in full detail.
| Year | Final Amount | MWRR1 |
|---|---|---|
| 1 | €18,392 | -69.47% |
| 2 | €28,374 | -31.37% |
| 3 | €38,650 | -13.75% |
| 4 | €46,833 | -6.10% |
| 5 | €53,654 | -2.29% |
| 6 | €60,657 | 0.12% |
| 7 | €67,847 | 1.72% |
| 8 | €75,229 | 2.82% |
| 9 | €82,807 | 3.60% |
| 10 | €90,587 | 4.17% |
| 11 | €98,574 | 4.58% |
| 12 | €106,773 | 4.89% |
| 13 | €115,191 | 5.11% |
| 14 | €123,677 | 5.27% |
| 15 | €132,268 | 5.38% |
| 16 | €141,095 | 5.46% |
| 17 | €150,203 | 5.52% |
| 18 | €159,557 | 5.56% |
| 19 | €169,165 | 5.59% |
| 20 | €179,034 | 5.60% |
| 21 | €189,130 | 5.60% |
| 22 | €199,525 | 5.60% |
| 23 | €210,233 | 5.59% |
| 24 | €221,263 | 5.57% |
| 25 | €232,626 | 5.55% |