What the property is worth to you (unsold, before tax) — Furnished flat-share in Melun — SCI à l’IS · ID 04SCI 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: €25,733.

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 — none in this projection), 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 = €1,044.04 + €0.00 + €5,554.65 + €41.76 − €490.32 = €6,150.13.

Year 1: the same figure from the real account — closing €6,150.13 + company tax paid so far €0.00 = €6,150.13. 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€1,044€0€5,555€42-€490€6,150€6,150€0
2€1,044€0€11,067€288-€994€11,405€11,405€0
3€1,044€0€16,536€744-€1,512€16,812€16,418€394
4€1,044€0€21,961€1,401-€2,044€22,362€21,168€1,194
5€1,044€0€27,342€2,247-€2,590€28,044€26,013€2,031
6€1,044€0€32,678€3,288-€3,151€33,859€30,954€2,905
7€1,044€0€37,969€4,526-€3,728€39,811€35,993€3,818
8€1,044€0€43,214€5,966-€4,321€45,903€41,081€4,821
9€1,044€0€48,411€7,609-€4,930€52,135€46,270€5,865
10€1,044€0€53,561€9,460-€5,555€58,510€51,559€6,951
11€1,044€0€58,663€11,522-€6,198€65,031€56,952€8,079
12€1,044€0€63,716€13,800-€6,858€71,702€62,450€9,252
13€1,044€0€68,720€16,298-€7,537€78,525€68,056€10,470
14€1,044€0€73,673€19,021-€8,234€85,504€73,770€11,734
15€1,044€0€78,576€21,971-€8,950€92,641€79,595€13,046
16€1,044€0€83,427€25,155-€9,686€99,940€85,445€14,495
17€1,044€0€88,225€28,573-€10,442€107,400€91,406€15,994
18€1,044€0€92,970€32,229-€11,219€115,025€97,480€17,544
19€1,044€0€97,662€36,128-€12,017€122,817€103,670€19,147
20€1,044€0€102,299€40,275-€12,837€130,781€109,976€20,804
21€1,044€0€114,499€44,674-€13,680€146,537€124,020€22,517
22€1,044€0€126,642€49,635-€14,546€162,775€138,481€24,294
23€1,044€0€138,728€55,174-€15,435€179,511€153,374€26,138
24€1,044€0€150,757€61,309-€16,349€196,761€168,710€28,051
25€1,044€0€162,727€68,058-€17,288€214,541€184,506€30,035
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€15,000€3,958€625
2€15,000€8,048€1,253
3€15,000€12,275€1,884
4€15,000€16,641€2,519
5€15,000€21,154€3,156
6€15,000€25,816€3,797
7€15,000€30,634€4,441
8€15,000€35,613€5,088
9€15,000€40,757€5,739
10€15,000€46,072€6,393
11€15,000€51,564€7,049
12€15,000€57,240€7,710
13€15,000€63,104€8,373
14€15,000€69,163€9,040
15€15,000€75,424€9,710
16€15,000€81,894€10,384
17€15,000€88,579€11,061
18€15,000€95,487€11,741
19€15,000€102,625€12,425
20€15,000€110,000€13,112
21€15,000€110,000€13,803
22€15,000€110,000€14,497
23€15,000€110,000€15,194
24€15,000€110,000€15,895
25€15,000€110,000€16,599
Part 3. What the property is worth to you (unsold, before tax), assembledProperty Networth

Year 1: €15,000.00 + €3,958.24 + €625.00 + €6,150.13 = €25,733.37.

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 (€25,733.37) — no payment after the purchase so far only paid company tax.

What the property is worth to you (unsold, before tax) — Year 1€25,733Property Networth
YearDay-1 equityΣ Loan paid offΣ AppreciationSavings before tax1Networth2Property Networth
1€15,000€3,958€625€6,150€25,733
2€15,000€8,048€1,253€11,405€35,706
3€15,000€12,275€1,884€16,812€45,971
4€15,000€16,641€2,519€22,362€56,523
5€15,000€21,154€3,156€28,044€67,354
6€15,000€25,816€3,797€33,859€78,473
7€15,000€30,634€4,441€39,811€89,887
8€15,000€35,613€5,088€45,903€101,604
9€15,000€40,757€5,739€52,135€113,630
10€15,000€46,072€6,393€58,510€125,974
11€15,000€51,564€7,049€65,031€138,645
12€15,000€57,240€7,710€71,702€151,652
13€15,000€63,104€8,373€78,525€165,002
14€15,000€69,163€9,040€85,504€178,707
15€15,000€75,424€9,710€92,641€192,776
16€15,000€81,894€10,384€99,940€207,218
17€15,000€88,579€11,061€107,400€222,040
18€15,000€95,487€11,741€115,025€237,253
19€15,000€102,625€12,425€122,817€252,867
20€15,000€110,000€13,112€130,781€268,893
21€15,000€110,000€13,803€146,537€285,339
22€15,000€110,000€14,497€162,775€302,272
23€15,000€110,000€15,194€179,511€319,705
24€15,000€110,000€15,895€196,761€337,656
25€15,000€110,000€16,599€214,541€356,140