What the sale leaves after the loan and fees — T3 in Melun — réel foncier · ID 05Réel foncierNet Sale Proceeds Ledger

A sale at the end of year 20 would leave €147,343 after the agency fee and the loan, before the tax on the gain.

Where each number comes from

This figure is calculated from the inputs only.

Sale price (year 20)€201,331
Agency fee (year 20)€10,067
Loan payoff costs (year 20)€435
What the sale leaves (year 20)€147,343
YearSale priceAgency feeLoan payoff costsLoan left to repay1What the sale leaves (before tax)
1€166,650€8,333€1,558€155,838€921
2€168,317€8,416€1,515€151,535€6,850
3€170,000€8,500€1,471€147,085€12,944
4€171,700€8,585€1,425€142,484€19,206
5€173,417€8,671€1,377€137,727€25,642
6€175,151€8,758€1,328€132,807€32,258
7€176,902€8,845€1,277€127,720€39,060
8€178,671€8,934€1,225€122,461€46,053
9€180,458€9,023€1,170€117,022€53,243
10€182,263€9,113€1,114€111,398€60,638
11€184,085€9,204€1,056€105,583€68,242
12€185,926€9,296€996€99,570€76,064
13€187,785€9,389€934€93,352€84,110
14€189,663€9,483€869€86,923€92,388
15€191,560€9,578€803€80,276€100,904
16€193,475€9,674€734€73,402€109,666
17€195,410€9,771€663€66,294€118,683
18€197,364€9,868€589€58,944€127,962
19€199,338€9,967€513€51,345€137,513
20€201,331€10,067€435€43,487€147,343
21€203,345€10,167€354€35,361€157,462
22€205,378€10,269€270€26,960€167,880
23€207,432€10,372€183€18,272€178,606
24€209,506€10,475€93€9,289€189,649
25€211,601€10,580€0€0€201,021