What the property is worth to you (unsold, before tax) — T2 in Melun — SCI à l’IS · ID 01SCI ISProperty Networth

This page shows how the loan paid off, the property value increase and the company's savings account (with the company tax paid added back) add up to what the property is worth to you, unsold and before tax. Result for year 1: €10,653.

Where each number comes from

Each link opens the page that calculates that figure.

  1. Loan paid off (equity built) Equity from Loan
  2. Property value increase Appreciation
  3. Savings account for the rent you keep (below €0 = cash borrowed from your other properties or a lender) Reinvestment/Financing Account
    1. Rent kept after all costs (cash flow) Cash Flow
    2. Interest paid to you by the company Compte-Courant Cash Effect
      1. Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
    3. Company tax paid each year IS Ledger
      1. Profit the tax office sees (cumulative) Cumulative Pool
        1. Profit after allowed deductions Taxable Profit
          1. Interest on the money you lent your company Compte Courant
            1. Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
          2. Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation
      2. Profit after allowed deductions Taxable Profit
        1. Interest on the money you lent your company Compte Courant
          1. Cash you add when the company is short (payments after the purchase) Owner payments after the purchase
        2. Wear-and-tear deduction (depreciation: building, improvements, furniture) Depreciation

Each amount in the worked lines is rounded to the cent, so a line can differ by €0.01.

Part 1. The savings account, before company taxCum. Cash Flow with interest (IS added back)

Everything that went into the company's savings account: the cash left in it after the purchase, the cash you added when the company ran short (payments after the purchase), every year's rent kept after costs, the interest the account earned, and the compte-courant cash effect (your 31.4% tax on the interest the company pays you — compte courant page). It equals the real account's closing balance plus the company tax paid out of it so far.

"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 payments after the purchase can include cash you added only to pay the company tax (the account would have stayed above €0 without it); that tax is then added back as well, so such cash counts twice here — the yearly return before tax leaves it out (Part 3).

Year 1: savings account before company tax = €0.00 + €579.57 − €579.57 + €0.00 + €0.00 = €0.00.

Year 1: the same figure from the real account — closing €0.00 + company tax paid so far €0.00 = €0.00. Company tax: its own page.

YearCash left after the purchase1Σ Cash you added (payments after the purchase)2Σ Rent kept3Σ Account interest4Σ CC cash effect5Savings before tax6Real closing7Σ Company tax paid8
1€0€580-€580€0€0€0€0€0
2€0€1,131-€1,131€0€0€0€0€0
3€0€1,655-€1,655€0€0€0€0€0
4€0€2,152-€2,152€0€0€0€0€0
5€0€2,622-€2,622€0€0€0€0€0
6€0€3,066-€3,066€0€0€0€0€0
7€0€3,483-€3,483€0€0€0€0€0
8€0€3,876-€3,876€0€0€0€0€0
9€0€4,243-€4,243€0€0€0€0€0
10€0€4,587-€4,587€0€0€0€0€0
11€0€4,906-€4,906€0€0€0€0€0
12€0€5,202-€5,202€0€0€0€0€0
13€0€5,476-€5,476€0€0€0€0€0
14€0€5,727-€5,727€0€0€0€0€0
15€0€5,957-€5,957€0€0€0€0€0
16€0€6,167-€6,167€0€0€0€0€0
17€0€6,356-€6,356€0€0€0€0€0
18€0€6,526-€6,526€0€0€0€0€0
19€0€6,677-€6,677€0€0€0€0€0
20€0€7,061-€6,810€0€0€251€0€251
21€0€7,529-€6,926€0€0€603€0€603
22€0€8,002-€7,026€0€0€976€0€976
23€0€8,481-€7,111€0€0€1,371€0€1,371
24€0€8,969-€7,180€0€0€1,788€0€1,788
25€0€9,464-€7,236€0€0€2,228€0€2,228
Part 2. Loan paid off and value increaseEquity & Appreciation

Day-1 equity is what you own on day one (price − loan, plus any value uplift); Σ loan paid off is the principal repaid since (its own page). Σ appreciation is the value gained by the END of the year — one period more than the appreciation page's start-of-year figure, so it matches what selling in this same year would be worth.

YearDay-1 equityΣ Loan paid off1Σ Appreciation (end of year)2
1€6,500€3,533€620
2€6,500€7,147€1,243
3€6,500€10,843€1,869
4€6,500€14,625€2,499
5€6,500€18,493€3,131
6€6,500€22,450€3,767
7€6,500€26,498€4,406
8€6,500€30,638€5,048
9€6,500€34,874€5,693
10€6,500€39,206€6,341
11€6,500€43,639€6,993
12€6,500€48,172€7,648
13€6,500€52,810€8,306
14€6,500€57,554€8,968
15€6,500€62,407€9,633
16€6,500€67,371€10,301
17€6,500€72,449€10,972
18€6,500€77,644€11,647
19€6,500€82,958€12,325
20€6,500€88,393€13,007
21€6,500€93,954€13,692
22€6,500€99,642€14,381
23€6,500€105,460€15,072
24€6,500€111,412€15,768
25€6,500€117,500€16,467
Part 3. What the property is worth to you (unsold, before tax), assembledProperty Networth

Year 1: €6,500.00 + €3,532.77 + €620.00 + €0.00 = €10,652.77.

Not a gain: it includes the money you put in. The gain is on the yearly return pages and the cash you walk away with.

Year 1: this is also the yearly return before tax's final amount (€10,652.77) — no payment after the purchase so far only paid company tax.

What the property is worth to you (unsold, before tax) — Year 1€10,653Property Networth
YearDay-1 equityΣ Loan paid offΣ AppreciationSavings before tax1Networth2Property NetworthPayments after the purchase that only paid company tax3Before-tax MWRR final amount4
1€6,500€3,533€620€0€10,653€0€10,653
2€6,500€7,147€1,243€0€14,890€0€14,890
3€6,500€10,843€1,869€0€19,213€0€19,213
4€6,500€14,625€2,499€0€23,623€0€23,623
5€6,500€18,493€3,131€0€28,124€0€28,124
6€6,500€22,450€3,767€0€32,717€0€32,717
7€6,500€26,498€4,406€0€37,403€0€37,403
8€6,500€30,638€5,048€0€42,186€0€42,186
9€6,500€34,874€5,693€0€47,067€0€47,067
10€6,500€39,206€6,341€0€52,048€0€52,048
11€6,500€43,639€6,993€0€57,132€0€57,132
12€6,500€48,172€7,648€0€62,320€0€62,320
13€6,500€52,810€8,306€0€67,616€0€67,616
14€6,500€57,554€8,968€0€73,022€0€73,022
15€6,500€62,407€9,633€0€78,540€0€78,540
16€6,500€67,371€10,301€0€84,172€0€84,172
17€6,500€72,449€10,972€0€89,922€0€89,922
18€6,500€77,644€11,647€0€95,791€0€95,791
19€6,500€82,958€12,325€0€101,783€0€101,783
20€6,500€88,393€13,007€251€108,151€251€107,900
21€6,500€93,954€13,692€603€114,748€603€114,146
22€6,500€99,642€14,381€976€121,498€976€120,522
23€6,500€105,460€15,072€1,371€128,403€1,371€127,032
24€6,500€111,412€15,768€1,788€135,468€1,788€133,680
25€6,500€117,500€16,467€2,228€142,695€2,228€140,467