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.
- Loan paid off (equity built) Equity from Loan
- Property value increase Appreciation
- 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
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.
| Year | Cash left after the purchase1 | Σ Cash you added (payments after the purchase)2 | Σ Rent kept3 | Σ Account interest4 | Σ CC cash effect5 | Savings before tax6 | Real 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.
| Year | Day-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.
| Year | Day-1 equity | Σ Loan paid off | Σ Appreciation | Savings before tax1 | Networth2Property 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 |