Yearly return before tax (money-weighted) — Furnished flat-share in Melun — SCI à l’IS · ID 04SCI ISMWRR — Before Tax
This page shows how the money-weighted yearly return before tax is worked out: every euro you put in, grown at one rate from the year you put it in, must add up to what the property is worth to you at year 1. Result for year 1: -57.28% 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
- Loan paid off (equity built) Equity from Loan
- Property value increase Appreciation
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 — any year's own deficit shows as a real injection below. Measured against this page's own before-tax account (cash flow + compte-courant cash effect + interest, no company tax): company tax doesn't exist before tax, so money you only had to add to pay it is not an injection here (the after-tax pages count it).
"Before tax" means the company tax paid is added back to the real account. The interest inside is what the account really earned — after each year's tax had been paid out of it at year end — so this is not a world where no tax was ever paid.
The injections below use a stricter before-tax account: no company tax at all (not paid, then added back — never paid). The table below lets it earn interest on its own balance, only to decide the injections: the final amount keeps the interest actually earned (line above). So the money you had to add only to pay company tax is not an injection here, and this page's final amount is the net worth (which adds the tax back) minus those payments after the purchase — Part 2 shows the figure. Each injection is made at the end of its year and grows from the next year on.
Year 0: the initial investment, €60,233. After that, the injections come from the company's own before-tax account below: it opens with the cash left after the purchase and, each year, adds the account interest, the rent kept and the compte-courant cash effect — but no company tax.
Each amount in the worked lines is rounded to the cent, so a line can differ by €0.01.
Year 1: before injection = €1,044.04 + €41.76 + €5,554.65 − €490.32 = €6,150.13. Injection = max(−€6,150.13, €0) = €0.00.
| Year | Opening1 | Account interest2 | Rent kept | CC cash effect3 | Before injection4 | Injected5 | Closing6 |
|---|---|---|---|---|---|---|---|
| 1 | €1,044 | €42 | €5,555 | -€490 | €6,150 | €0 | €6,150 |
Part 2. Final amount at year N
| Year | Cash Flow | Interest paid to you by the companyCompte-Courant Cash Effect | Reinvestment/Financing Interest | Total |
|---|---|---|---|---|
| 1 | €5,555 | -€490 | €42 | €5,106 |
What's added at Year 1, on top of the recurring cash-flow account above: the property's own built-up equity and appreciation — the same 3 terms Property Networth assembles from, alongside its own Closing Balance (this page's own Σ Totals above). Full ledgers on Equity from Loan and Appreciation.
- Day-1 Equity€15,000
- +Cash left in the company account after the purchase (paid back)€1,044
- +Σ Loan paid off (equity built)€3,958
- +Σ Appreciation (end-of-year)€625
- =Year N Extras€20,627
- Σ Totals (years 1–1)€5,106
- +Year N Extras€20,627
- −Initial Investment€60,233
- =Total Profit(-€34,499)
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. Final Amount below is this page's own before-tax net worth: Property Networth with the company's real payments after the purchase (which include cash that only paid company tax) replaced by the injections above — the two coincide when no payment after the purchase paid tax.
- Total Injected (Part 1)€60,233
- +Total Profit(-€34,499)
- =Final Amount (FV_final)€25,733
Year 1: final amount = total injected €60,232.55 + €5,106.09 (Σ totals) + €20,627.28 (Year 1 extras) − €60,232.55 (initial investment) = €25,733.37.
Year 1: this is also the yearly return before tax's final amount (€25,733.37) — no payment after the purchase so far only paid company tax. (What the property is worth to you, unsold, before 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
- Equity on day one (price − loan)€15,000
- Loan paid off (equity built)€3,958
- Property value increase€625
- Cash left in the company account after the purchase (paid back)€1,044
- Total profit-€34,499
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 (Year N 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
- +Year N Extras€20,627
- −Initial Investment€60,233
- =Total Profit (Part 2)(-€34,499)
- Total Injected (Step 1)€60,233
- +Total Profit(-€34,499)
- =Final Amount (FV_final)€25,733
Step 3 — Solve for R
R ≈ −57.2766%: Σ Inj_t × (1 + R)^(1 − t) = €25,733.37; minus the final amount €25,733.37 = €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 | €25,733 | -57.28% |
| 2 | €35,706 | -23.01% |
| 3 | €45,971 | -8.61% |
| 4 | €56,523 | -1.58% |
| 5 | €67,354 | 2.26% |
| 6 | €78,473 | 4.51% |
| 7 | €89,887 | 5.89% |
| 8 | €101,604 | 6.75% |
| 9 | €113,630 | 7.31% |
| 10 | €125,974 | 7.66% |
| 11 | €138,645 | 7.87% |
| 12 | €151,652 | 8.00% |
| 13 | €165,002 | 8.06% |
| 14 | €178,707 | 8.08% |
| 15 | €192,776 | 8.06% |
| 16 | €207,218 | 8.03% |
| 17 | €222,040 | 7.98% |
| 18 | €237,253 | 7.91% |
| 19 | €252,867 | 7.84% |
| 20 | €268,893 | 7.77% |
| 21 | €285,339 | 7.69% |
| 22 | €302,272 | 7.61% |
| 23 | €319,705 | 7.53% |
| 24 | €337,656 | 7.45% |
| 25 | €356,140 | 7.37% |