{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":58,"n_cols":27,"rows_kept":58,"cut":false,"hidden":false,"merged":[[5,14,5,20],[5,22,5,25],[5,6,5,13],[0,0,0,26]]}
["CALCULATEUR ACHAT-LOCATION-MISE DE FONDS © Dany Provost"]
[]
["Budget total disponible par mois pour te loger",null,2000,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,{"$f":"(1+D33)^12-1","v":3.0225000000001279E-2}]
["Prix mensuel de ton loyer actuel",null,1200,null,null,null,{"$f":"1+C8","v":1.02},null,null,null,null,null,null,null,null,null,{"$f":"C5+3","v":8},null,null,{"$f":"C39","v":0.05},null,{"$f":"C8","v":0.02},null,null,{"$f":"D33*12","v":2.9814200695785331E-2}]
["Durée d'attente avant d'acheter (en années)",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q4+Q3-1","v":22},null,null,null,null,null,null,null,{"$f":"Y3/Y4","v":1.0137786455658366}]
["Tu veux donc acheter en:",null,{"$f":"YEAR(TODAY())+Duree","v":2026},null,null,null,"Budget",null,null,null,null,null,null,null,"REER",null,null,null,null,null,null,"Maison","Prêt hypothécaire",null,null,null,"Richesse nette"]
["Coût de ta résidence envisagée (incluant les taxes non remboursées, le cas échéant)",null,300000,null,"Année","Proprio",null,null,null,null,null,null,"Budget",null,"Solde début","Dépôt","Remb RAP","Retrait impos","Retrait RAP","Rendement","Solde fin","Valeur fin","Solde début","Versement","intérêt","Solde fin","Fin"]
["Augmentation annuelle de la valeur de ta résidence",null,0.02,null,null,null,"Taxes","Prêt","Loyer","Coûts suppl.","Remb RAP","Total","disponible","Écart",null,"déductible",null,null,null,null,null,null,null,null,null,0]
["Taxes foncières annuelles en pourcentage de la valeur",null,0.01,null,1,{"$f":"E9>$C$5","v":false},{"$f":"$C$10*$G$4^(E9-1)*F9+($C$31+$C$16*$G$4^(E9-1))*(E9=$C$5+1)","v":0},{"$f":"-X9","v":0},{"$f":"$C$4*12*$G$4^(E9-1)*NOT(F9)","v":14400},{"$f":"$C$35*12*$G$4^(E9-1)*F9","v":0},{"$f":"Q9","v":0},{"$f":"SUM(G9:K9)","v":14400},{"$f":"$C$3*$G$4^(E9-1)*12","v":24000},{"$f":"M9-L9","v":9600},{"$f":"C38","v":0},{"$f":"MAX(0,N9/(1-$C$37))","v":15267.175572519083},{"$f":"-SUM($S$9:$S$55)/$Q$3*AND(E9>=$Q$4,E9<=$Q$5)","v":0},{"$f":"MIN(0,N9/(1-$C$37))","v":0},{"$f":"-($C$29+$C$31)*(E9=$C$5+1)","v":0},{"$f":"(O9+S9)*$T$4+SUM(P9:R9)*$T$4/2","v":381.67938931297709},{"$f":"SUM(O9:T9)","v":15648.854961832061},{"$f":"$C$7*(1+$V$4)^(E9)*(E9>$C$5)","v":0},{"$f":"($C$29/$C$28-$C$29+$C$30)*(E9=$C$5+1)+Z8","v":0},{"$f":"-($C$34*12)*(E9>$C$5)*(E9<=$C$5+$C$18)","v":0},{"$f":"-X9-(W9-Z9)","v":0},{"$f":"W9*(1+$Y$3)+X9*$Y$5","v":0},{"$f":"U9*(1-$C$37)+V9-Z9+(SUM($Q$9:Q9,$S$9:S9))*$C$37","v":9840}]
["Taxes annuelles calculées en dollars actuels",null,{"$f":"C7*C9","v":3000},null,2,{"$f":"E10>$C$5","v":false},0,{"$f":"-X10","v":0},{"$f":"$C$4*12*$G$4^(E10-1)*NOT(F10)","v":14688},0,{"$f":"Q10","v":0},{"$f":"SUM(G10:K10)","v":14688},{"$f":"$C$3*$G$4^(E10-1)*12","v":24480},{"$f":"M10-L10","v":9792},{"$f":"U9","v":15648.854961832061},15572.519083969464,0,0,0,{"$f":"(O10+S10)*$T$4+SUM(P10:R10)*$T$4/2","v":1171.7557251908397},{"$f":"SUM(O10:T10)","v":32393.129770992364},{"$f":"$C$7*(1+$V$4)^(E10)*(E10>$C$5)","v":0},0,0,{"$f":"-X10-(W10-Z10)","v":0},{"$f":"W10*(1+$Y$3)+X10*$Y$5","v":0},{"$f":"U10*(1-$C$37)+V10-Z10+(SUM($Q$9:Q10,$S$9:S10))*$C$37","v":20368.8}]
["Table taxe mutation (taxe de Bienvenue) de ton secteur",null,null,null,3,false,0,0,14981.76,0,0,14981.76,24969.600000000002,9987.840000000002,{"$f":"U10","v":32393.129770992364},15883.969465648857,0,0,0,2016.7557251908397,50293.854961832061,0,0,0,0,0,{"$f":"U11*(1-$C$37)+V11-Z11+(SUM($Q$9:Q11,$S$9:S11))*$C$37","v":31624.776000000002}]
[null,0,5.0000000000000001E-3,null,4,false,0,0,15281.395199999999,0,0,15281.395199999999,25468.991999999998,10187.596799999999,50293.854961832061,16201.64885496183,0,0,0,2919.7339694656494,69415.237786259546,0,0,0,0,0,{"$f":"U12*(1-$C$37)+V12-Z12+(SUM($Q$9:Q12,$S$9:S12))*$C$37","v":43648.301520000001}]
[null,50000,0.01,null,5,false,0,0,15587.023104,0,0,15587.023104,25978.37184,10391.348736,69415.237786259546,16525.681832061069,0,0,0,3883.9039351145043,89824.823553435126,0,0,0,0,0,{"$f":"U13*(1-$C$37)+V13-Z13+(SUM($Q$9:Q13,$S$9:S13))*$C$37","v":56481.849050400007}]
[null,250000,1.4999999999999999E-2,null,6,true,7648.7129783085602,17512.152569838272,0,1987.3454457600001,0,27148.210993906832,26497.9392768,-650.27171710683251,89824.823553435126,0,0,-1034.1471328034868,-34146.652255108565,2758.054886596241,57402.079052119319,337848.72577920003,308369.76833376003,-17512.152569838272,9079.1825045336118,299936.79826845537,{"$f":"U14*(1-$C$37)+V14-Z14+(SUM($Q$9:Q14,$S$9:S14))*$C$37","v":61331.117501620989}]
[null,500000,0.02,null,7,true,3378.487257792,17512.152569838272,0,2027.0923546752001,0,22917.732182305474,27027.898062336004,4110.1658800305304,57402.079052119319,6536.5233461045327,0,0,0,3033.5170362585795,66972.119434482433,344605.70029478392,299936.79826845537,-17512.152569838272,8824.2959843097451,291248.94168292684,{"$f":"U15*(1-$C$37)+V15-Z15+(SUM($Q$9:Q15,$S$9:S15))*$C$37","v":82793.589995163347}]
["La taxe de mutation, en dollars d'aujourd'hui, est donc de:",null,{"$f":"MIN(C7,B13)*C12+MAX(0,MIN(C7-B13,B14-B13))*C13+MAX(0,MIN(C7-B14,B15-B14))*C14+MAX(0,C7-B15)*C15","v":3000},null,8,true,3446.0570029478395,17512.152569838272,0,2067.6342017687039,2276.4434836739042,25302.28725822872,27568.456023582716,2266.1687653539957,66972.119434482433,3603.9579601685682,2276.4434836739042,0,0,3495.6160078201838,76348.13688614509,351497.81430067966,291248.94168292684,-17512.152569838272,8561.7055190121719,282298.49463210074,{"$f":"U16*(1-$C$37)+V16-Z16+(SUM($Q$9:Q16,$S$9:S16))*$C$37","v":105376.80664663039}]
["Taux intérêt de ton futur prêt hypothécaire",null,0.03,null,9,true,3514.9781430067965,17512.152569838272,0,2108.9868858040782,2276.4434836739042,25412.561082323053,28119.825144054372,2707.2640617313191,76348.13688614509,4305.4453907940824,2276.4434836739042,0,0,3981.9540661689543,86911.97982678203,358527.77058669325,282298.49463210074,-17512.152569838272,8291.1782569009192,273077.52031916339,{"$f":"U17*(1-$C$37)+V17-Z17+(SUM($Q$9:Q17,$S$9:S17))*$C$37","v":129115.29750779358}]
["Durée d'amortissement de ton prêt (en années)",null,25,{"$f":"((1+$T$4)^C5-1)/T4","v":5.5256312500000027},10,true,3585.2777058669326,17512.152569838272,0,2151.1666235201596,2276.4434836739042,25525.040382899271,28682.221646935461,3157.1812640361895,86911.97982678203,5020.9625700321076,2276.4434836739042,0,0,4528.0341426817513,98737.420023169791,365698.32599842711,273077.52031916339,-17512.152569838272,8012.4743082923778,263577.8420576175,{"$f":"U18*(1-$C$37)+V18-Z18+(SUM($Q$9:Q18,$S$9:S18))*$C$37","v":154066.38379770177}]
[null,null,null,null,11,true,3656.9832599842712,17512.152569838272,0,2194.1899559905628,2276.4434836739042,25639.769269487009,29255.866079874173,3616.0968103871637,98737.420023169791,5750.7900928549043,2276.4434836739042,0,0,5137.5518405717103,111902.20544027032,373012.29251839558,263577.8420576175,-17512.152569838272,7725.346532837164,253791.03602061639,{"$f":"U19*(1-$C$37)+V19-Z19+(SUM($Q$9:Q19,$S$9:S19))*$C$37","v":180290.18924608384}]
["Taxe de vente (si tu achètes une résidence neuve)",null,9.9750000000000005E-2,null,12,true,3730.1229251839559,17512.152569838272,0,2238.0737551103734,2276.4434836739042,25756.792733806509,29840.983401471647,4084.1906676651379,111902.20544027032,6495.2141661341248,2276.4434836739042,0,0,5814.4017132587178,126488.26480333708,380472.53836876358,253791.03602061639,-17512.152569838272,7429.5403203688002,243708.42377114692,{"$f":"U20*(1-$C$37)+V20-Z20+(SUM($Q$9:Q20,$S$9:S20))*$C$37","v":207849.77729455748}]
[null,null,null,null,13,true,3804.7253836876357,17512.152569838272,0,2282.8352302125813,2276.4434836739042,25876.156667412397,30437.803069501086,4561.6464020886888,126488.26480333708,7254.5267208789573,2276.4434836739042,0,0,6562.6874952806756,142581.92250317062,388081.98913613881,243708.42377114692,-17512.152569838272,7124.7933651285675,233321.06456643721,{"$f":"U21*(1-$C$37)+V21-Z21+(SUM($Q$9:Q21,$S$9:S21))*$C$37","v":236811.29504943753}]
["Table SCHL (va voir si elle est à jour en cliquant ici)",0,0,null,14,true,3880.8198913613883,17512.152569838272,0,2328.4919348168328,2276.4434836739042,25997.9078796904,31046.559130891103,5048.651251200703,142581.92250317062,8029.0255267186749,2276.4434836739042,0,0,7386.7328504183461,160274.12436398154,395843.62891886162,233321.06456643721,-17512.152569838272,6810.8354331662085,222619.74742976515,{"$f":"U22*(1-$C$37)+V22-Z22+(SUM($Q$9:Q22,$S$9:S22))*$C$37","v":267244.12432005}]
[null,0.85,2.8000000000000001E-2,null,15,true,3958.4362891886162,17512.152569838272,0,2375.06177351317,2276.4434836739042,26122.094116213964,31667.49031350893,5545.3961972949655,160274.12436398154,8819.0143086751996,2276.4434836739042,0,0,8291.0926630078047,179660.67481933846,403760.50149723876,222619.74742976515,-17512.152569838272,6487.3881227102793,211594.98298263716,{"$f":"U23*(1-$C$37)+V23-Z23+(SUM($Q$9:Q23,$S$9:S23))*$C$37","v":299221.04009302339}]
[null,0.9,3.1E-2,null,16,true,4037.6050149723878,17512.152569838272,0,2422.5630089834326,2276.4434836739042,26248.764077468,32300.840119779099,6052.0760423110987,179660.67481933846,9624.8028662708311,2276.4434836739042,0,0,9280.5648997155404,200842.48606899873,411835.71152718359,211594.98298263716,-17512.152569838272,6154.164617295839,200236.99503009472,{"$f":"U24*(1-$C$37)+V24-Z24+(SUM($Q$9:Q24,$S$9:S24))*$C$37","v":332818.37681043672}]
[null,0.95,0.04,null,17,true,4118.3571152718359,17512.152569838272,0,2471.0142691631017,2276.4434836739042,26377.967437947114,32946.856922174687,6568.8894842275731,200842.48606899873,10446.707195018405,2276.4434836739042,0,0,10360.203070417245,223925.8398181083,420072.42575772729,200236.99503009472,-17512.152569838272,5810.8694314302084,188535.71189168666,{"$f":"U25*(1-$C$37)+V25-Z25+(SUM($Q$9:Q25,$S$9:S25))*$C$37","v":368116.20283796836}]
[null,null,null,null,18,true,4200.7242575772734,17512.152569838272,0,2520.4345545463639,2276.4434836739042,26509.754865635816,33605.794060618187,7096.0391949823716,223925.8398181083,11285.04961034092,2276.4434836739042,0,0,11535.329318255786,249022.66223037892,428473.87427288183,188535.71189168666,-17512.152569838272,5457.1981485718243,176480.75747042021,{"$f":"U26*(1-$C$37)+V26-Z26+(SUM($Q$9:Q26,$S$9:S26))*$C$37","v":405198.50352836488}]
[{"$f":"\"Ta mise de fonds possible en RAP selon le solde prévu de ton REER en \"&YEAR(TODAY())+Duree&\" (\" &TEXT(C46,\"### ### ##0\")&\" $)\"","v":"Ta mise de fonds possible en RAP selon le solde prévu de ton REER en 2026 (84 361 $)"},null,{"$f":"IF(C46<C47,A47,INDEX(A47:A50,MATCH(C46,C47:C50)))","v":0.2},null,19,true,4284.7387427288186,17512.152569838272,0,2570.8432456372907,2276.4434836739042,26644.178041878287,34277.909941830541,7633.731899952254,249022.66223037892,12140.158873969869,2276.4434836739042,0,0,12811.548170460041,276250.8127584827,437043.35175833944,176480.75747042021,-17512.152569838272,5092.83715118904,164061.44205177098,{"$f":"U27*(1-$C$37)+V27-Z27+(SUM($Q$9:Q27,$S$9:S27))*$C$37","v":444153.37330568314}]
["La mise de fonds que tu veux réellement faire (en pourcentage)",null,0.1,null,20,true,4370.433517583394,17512.152569838272,0,2622.2601105500366,2276.4434836739042,26781.289681645609,34963.468140667159,8182.1784590215502,276250.8127584827,13012.370322871422,2276.4434836739042,0,0,14194.760983087768,305734.3875481158,445784.21879350627,164061.44205177098,-17512.152569838272,4717.4633426603359,151266.75282459304,{"$f":"U28*(1-$C$37)+V28-Z28+(SUM($Q$9:Q28,$S$9:S28))*$C$37","v":485073.21721688891}]
[{"$f":"\"Ta mise de fonds calculée en dollars de \"&YEAR(TODAY())+Duree","v":"Ta mise de fonds calculée en dollars de 2026"},null,{"$f":"C7*C28*(1+C8)^C5","v":33122.424096000002},null,21,true,4457.8421879350626,17512.152569838272,0,2674.7053127610375,2276.4434836739042,26921.143554208276,35662.737503480501,8741.5939492722246,305734.3875481158,13902.026000750993,2276.4434836739042,0,0,15691.181114516414,337604.03814705712,454699.90316937637,151266.75282459304,-17512.152569838272,4330.7438607688782,138085.34411552365,{"$f":"U29*(1-$C$37)+V29-Z29+(SUM($Q$9:Q29,$S$9:S29))*$C$37","v":528054.96241958253}]
[{"$f":"\"Ta prime SCHL prévue en dollars de \"&YEAR(TODAY())+Duree","v":"Ta prime SCHL prévue en dollars de 2026"},null,{"$f":"INDEX(C22:C25,MATCH((1-C28),B22:B25,1))*C7*(1+C8)^C5","v":10267.951469760001},null,22,true,4546.9990316937638,17512.152569838272,0,2728.1994190162582,2276.4434836739042,27063.794504222202,36375.99225355011,9312.1977493279082,337604.03814705712,14809.474792188148,2276.4434836739042,0,0,17307.349864249409,371997.30628716858,463793.90123276389,138085.34411552365,-17512.152569838272,3932.3357825372332,124505.52732822261,{"$f":"U30*(1-$C$37)+V30-Z30+(SUM($Q$9:Q30,$S$9:S30))*$C$37","v":573200.28009791288}]
[{"$f":"\"La taxe sur ta prime SCHL en dollars de \"&YEAR(TODAY())+Duree","v":"La taxe sur ta prime SCHL en dollars de 2026"},null,{"$f":"C30*C20","v":1024.22815910856},null,23,true,4637.9390123276389,17512.152569838272,0,2782.7634073965837,0,24932.854989562496,37103.512098621111,12170.657109058615,371997.30628716858,19355.370720513063,0,0,0,19083.749582371256,410436.4265900529,473069.77925741911,124505.52732822261,-17512.152569838272,3521.8858201410294,110515.26057852537,{"$f":"U31*(1-$C$37)+V31-Z31+(SUM($Q$9:Q31,$S$9:S31))*$C$37","v":620636.94371871895}]
[null,null,null,null,24,true,4730.6977925741912,17512.152569838272,0,2838.4186755445148,0,25081.269037956979,37845.582340593523,12764.313302636543,410436.4265900529,20299.480443124274,0,0,0,21029.308340580756,451765.21537375788,482531.17484256753,110515.26057852537,-17512.152569838272,3099.030007631427,96102.138016318524,{"$f":"U32*(1-$C$37)+V32-Z32+(SUM($Q$9:Q32,$S$9:S32))*$C$37","v":670499.00425326789}]
[null,null,null,{"$f":"(1+C17/2)^(1/6) -1","v":2.4845167246487776E-3},25,true,4825.3117484256754,17512.152569838272,0,2895.1870490554052,0,25232.651367319355,38602.493987405403,13369.842620086049,451765.21537375788,21262.472360187734,0,0,0,23119.822577692586,496147.51031163818,492181.79833941889,96102.138016318524,-17512.152569838272,2663.3933781886844,81253.378824668936,{"$f":"U33*(1-$C$37)+V33-Z33+(SUM($Q$9:Q33,$S$9:S33))*$C$37","v":722905.97399870807}]
[{"$f":"\"Versements mensuels sur ton prêt hypothécaire\"&IF(C30>0,\", incluant la prime SCHL\",\"\")","v":"Versements mensuels sur ton prêt hypothécaire, incluant la prime SCHL"},null,{"$f":"(C7*(1+C8)^(C5)-C29+C30)/D34","v":1459.3460474865226},{"$f":"(1-(1+D33)^-(12*C18))/D33","v":211.30681709446154},26,true,4921.8179833941886,17512.152569838272,0,2953.0907900365132,0,25387.061343268972,39374.543867153508,13987.482523884537,496147.51031163818,22244.724115592457,0,0,0,25363.493618471719,543755.72804570233,502025.43430620729,81253.378824668936,-17512.152569838272,2214.5896316210528,65955.815886451717,{"$f":"U34*(1-$C$37)+V34-Z34+(SUM($Q$9:Q34,$S$9:S34))*$C$37","v":777983.22021489323}]
["Coût additionnels en coûts divers (électricité…) lorsque tu seras propriétaire",null,150,null,27,true,5020.2543430620726,17512.152569838272,0,3012.1526058372438,0,25544.559518737587,40162.034744496581,14617.475225758993,543755.72804570233,23246.620906105269,0,0,0,27768.951924937748,594771.30087674537,512065.94299233134,65955.815886451717,-17512.152569838272,1752.2207918134263,50195.884108426872,{"$f":"U35*(1-$C$37)+V35-Z35+(SUM($Q$9:Q35,$S$9:S35))*$C$37","v":835862.25287520199}]
[null,null,null,null,28,true,5120.6594299233138,17512.152569838272,0,3072.3956579539881,0,25705.207657715575,40965.275439386511,15260.067781670936,594771.30087674537,24268.555632428332,0,0,0,30345.278934647977,649385.13544382178,522307.26185217808,50195.884108426872,-17512.152569838272,1275.8768538226104,33959.60839241121,{"$f":"U36*(1-$C$37)+V36-Z36+(SUM($Q$9:Q36,$S$9:S36))*$C$37","v":896681.02662684198}]
["Ton taux d'impôt pour tes cotisations et retraits au REER",null,0.37119999999999997,null,29,true,5223.0726185217809,17512.152569838272,0,3133.8435711130687,0,25869.068759473124,41784.580948174247,15915.512188701123,649385.13544382178,25310.929053277865,0,0,0,33102.029998523038,707798.09449562267,532753.40708922152,33959.60839241121,-17512.152569838272,785.13542030601457,17232.591242878952,{"$f":"U37*(1-$C$37)+V37-Z37+(SUM($Q$9:Q37,$S$9:S37))*$C$37","v":960584.25766519015}]
["Ton solde REER aujourd'hui",null,0,null,30,true,5327.5340708922158,17512.152569838272,0,3196.5204425353295,0,26036.207083265817,42620.272567137727,16584.065483871909,707798.09449562267,26374.149942544384,0,0,0,36049.258473344744,770221.50291151181,543408.47523100604,17232.591242878952,-17512.152569838272,279.56132696138229,2.0627339836210012E-9,{"$f":"U38*(1-$C$37)+V38-Z38+(SUM($Q$9:Q38,$S$9:S38))*$C$37","v":1027723.7562617626}]
["Le taux de rendement annuel de ton REER",null,0.05,null,31,true,5434.0847523100601,0,0,3260.4508513860364,0,8694.5356036960966,43472.678018480481,34778.142414784386,770221.50291151181,55308.750659644378,0,0,0,39893.7939120667,865424.04748322291,554276.64473562606,2.0627339836210012E-9,0,6.2346134654947548E-11,2.1250801182759488E-9,{"$f":"U39*(1-$C$37)+V39-Z39+(SUM($Q$9:Q39,$S$9:S39))*$C$37","v":1098455.2857930746}]
["Nombre années que tu prendras pour rembourser ton RAP (normalement 15)",null,15,null,32,true,5542.76644735626,0,0,3325.6598684137562,0,8868.4263157700152,44342.13157885008,35473.705263080061,865424.04748322291,56414.925672837242,0,0,0,44681.575515982076,966520.5486720422,565362.1776303387,2.1250801182759488E-9,0,6.4230546574893304E-11,2.1893106648508421E-9,{"$f":"U40*(1-$C$37)+V40-Z40+(SUM($Q$9:Q40,$S$9:S40))*$C$37","v":1173110.2986353168}]
[null,null,null,null,33,true,{"$f":"$C$10*$G$4^(E41-1)*F41+($C$31+$C$16*$G$4^(E41-1))*(E41=$C$5+1)","v":5653.6217763033865},0,0,{"$f":"$C$35*12*$G$4^(E41-1)*F41","v":3392.1730657820322},0,9045.7948420854191,45228.974210427092,36183.179368341676,966520.5486720422,{"$f":"MAX(0,N41/(1-$C$37))","v":57543.224186294014},0,{"$f":"MIN(0,N41/(1-$C$37))","v":0},{"$f":"-($C$29+$C$31)*(E41=$C$5+1)","v":0},49764.608038259459,1073828.3808965958,576669.42118294549,{"$f":"($C$29/$C$28-$C$29+$C$30)*(E41=$C$5+1)+Z40","v":2.1893106648508421E-9},{"$f":"-($C$34*12)*(E41>$C$5)*(E41<=$C$5+$C$18)","v":0},6.6171914845119468E-11,2.2554825796959616E-9,{"$f":"U41*(1-$C$37)+V41-Z41+(SUM($Q$9:Q41,$S$9:S41))*$C$37","v":1251892.7070907226}]
["Année où tu veux calculer ta richette nette",null,8,null,34,true,5766.6942118294546,0,0,3460.0165270976731,0,9226.7107389271277,46133.553694635644,36906.842955708518,1073828.3808965958,58694.088670019904,0,0,0,55158.771261580288,1187681.2408281961,588202.80960660439,2.2554825796959616E-9,0,6.8171960971313347E-11,2.3236545406672749E-9,{"$f":"U42*(1-$C$37)+V42-Z42+(SUM($Q$9:Q42,$S$9:S42))*$C$37","v":1335016.7738393717}]
[{"$f":"\"Ta richesse nette dans \"&C42&\" ans\"","v":"Ta richesse nette dans 8 ans"},null,{"$f":"INDEX(AA9:AA58,C42)","v":105376.80664663039},null,35,true,5882.028096066043,0,0,3529.2168576396261,0,9411.2449537056691,47056.224768528344,37644.979814822676,{"$f":"U42","v":1187681.2408281961},59867.970443420287,{"$f":"-SUM($S$9:$S$55)/$Q$3*AND(E43>=$Q$4,E43<=$Q$5)","v":0},0,0,60880.761302495317,1308429.9725741118,599966.86579873646,2.3236545406672749E-9,0,{"$f":"-X43-(W43-Z43)","v":7.0232458491671177E-11},{"$f":"W43*(1+$Y$3)+X43*$Y$5","v":2.3938869991589461E-9},{"$f":"U43*(1-$C$37)+V43-Z43+(SUM($Q$9:Q43,$S$9:S43))*$C$37","v":1422707.6325533357}]
[null,null,null,null,36,true,5999.668657987364,0,0,3599.8011947924183,0,9599.4698527797827,47997.349263898912,38397.879411119131,1308429.9725741118,61065.329852288691,0,0,0,66948.131875012812,1436443.4343014131,611966.2031147111,2.3938869991589461E-9,0,7.2355234549582287E-11,2.4662422337085284E-9,{"$f":"U44*(1-$C$37)+V44-Z44+(SUM($Q$9:Q44,$S$9:S44))*$C$37","v":1515201.834603437}]
["Estimation de la mise de fonds",null,null,null,37,true,6119.6620311471106,0,0,3671.7972186882666,0,9791.4592498353777,48957.296249176892,39165.836999341511,1436443.4343014131,62286.636449334459,0,0,0,73379.337626304012,1572109.4083770516,624205.52717700542,2.4662422337085284E-9,0,7.4542171513843486E-11,2.5407844052223719E-9,{"$f":"U45*(1-$C$37)+V45-Z45+(SUM($Q$9:Q45,$S$9:S45))*$C$37","v":1612747.9231644929}]
["Solde REER disponible estimé",null,{"$f":"C38*(1+$C$39)^(C5+1)+12*(C3-C4)/(1-C37)*D18","v":84360.782442748125},null,38,true,6242.0552717700539,0,0,3745.2331630620324,0,9987.2884348320858,49936.442174160438,39949.153739328351,1572109.4083770516,63532.369178321169,0,0,0,80193.779648310607,1715835.5572036833,636689.63772054564,2.5407844052223719E-9,0,7.679520864784957E-11,2.6175796138702214E-9,{"$f":"U46*(1-$C$37)+V46-Z46+(SUM($Q$9:Q46,$S$9:S46))*$C$37","v":1715607.0360902192}]
[0.05,null,{"$f":"$C$7*A47*(1+$C$8)^$C$5","v":16561.212048000001},null,39,true,6366.8963772054558,0,0,3820.1378263232737,0,10187.034203528729,50935.171017643646,40748.136814114914,1715835.5572036833,64803.016561887584,0,0,0,87411.853274231355,1868050.4270398023,649423.43047495629,2.6175796138702214E-9,0,7.9116343829230672E-11,2.6966959576994521E-9,{"$f":"U47*(1-$C$37)+V47-Z47+(SUM($Q$9:Q47,$S$9:S47))*$C$37","v":1824053.5389975812}]
[0.1,null,{"$f":"C47*2","v":33122.424096000002},null,40,true,6494.2343047495624,0,0,3896.5405828497373,0,10390.7748875993,51953.874437996499,41563.099550397201,1868050.4270398023,66099.076893125311,0,0,0,95054.998274318248,2029204.5022072459,662411.89908445557,2.6966959576994521E-9,0,8.150763532146924E-11,2.7782035930209213E-9,{"$f":"U48*(1-$C$37)+V48-Z48+(SUM($Q$9:Q48,$S$9:S48))*$C$37","v":1938375.6900723691}]
[0.15,null,{"$f":"C47*3","v":49683.636144000004},null,41,true,6624.1189908445558,0,0,3974.4713945067333,0,10598.59038535129,52992.951926756439,42394.361541405146,2029204.5022072459,67421.058430987818,0,0,0,103145.75157113699,2199771.3122093705,675660.13706614461,2.7782035930209213E-9,0,8.3971203599060819E-11,2.8621747966199822E-9,{"$f":"U49*(1-$C$37)+V49-Z49+(SUM($Q$9:Q49,$S$9:S49))*$C$37","v":2058876.3381833942}]
[0.2,null,{"$f":"C47*4","v":66244.848192000005},null,42,true,6756.6013706614467,0,0,4053.9608223968676,0,10810.562193058315,54052.810965291574,43242.248772233259,2199771.3122093705,68769.479599607599,0,0,0,111707.80260045873,2380248.5944094369,689173.33980746754,2.8621747966199822E-9,0,8.6509233227842825E-11,2.948684029847825E-9,{"$f":"U50*(1-$C$37)+V50-Z50+(SUM($Q$9:Q50,$S$9:S50))*$C$37","v":2185873.6559721185}]
[null,null,null,null,43,true,6891.7333980746753,0,0,4135.0400388448052,0,11026.77343691948,55133.867184597402,44107.093747677922,2380248.5944094369,70144.869191599748,0,0,0,120766.05145026185,2571159.5150512983,702956.8066036168,2.948684029847825E-9,0,8.9123974802154345E-11,3.0378080046499793E-9,{"$f":"U51*(1-$C$37)+V51-Z51+(SUM($Q$9:Q51,$S$9:S51))*$C$37","v":2319701.90966787}]
[null,null,null,null,44,true,7029.5680660361677,0,0,4217.7408396217006,0,11247.308905657868,56236.544528289342,44989.235622631473,2571159.5150512983,71547.766575431728,0,0,0,130346.6699169507,2773053.9515436809,717015.94273568923,3.0378080046499793E-9,0,9.1817746940549571E-11,3.1296257515905289E-9,{"$f":"U52*(1-$C$37)+V52-Z52+(SUM($Q$9:Q52,$S$9:S52))*$C$37","v":2460712.2674663528}]
[null,null,null,null,45,true,7170.1594273568926,0,0,4302.0956564141352,0,11472.255083771028,57361.275418855133,45889.020335084104,2773053.9515436809,72978.721906940365,0,0,0,140477.16562485756,2986509.8390754787,731356.26159040292,3.1296257515905289E-9,0,9.4592938341827589E-11,3.2242186899323565E-9,{"$f":"U53*(1-$C$37)+V53-Z53+(SUM($Q$9:Q53,$S$9:S53))*$C$37","v":2609273.6484010606}]
[null,null,null,null,46,true,7313.5626159040294,0,0,4388.1375695424176,0,11701.700185446447,58508.500927232242,46806.800741785795,2986509.8390754787,74438.296345079187,0,0,0,151186.44936240092,3212134.584782959,745983.38682221109,3.2242186899323565E-9,0,9.7452009903209497E-11,3.321670699835566E-9,{"$f":"U54*(1-$C$37)+V54-Z54+(SUM($Q$9:Q54,$S$9:S54))*$C$37","v":2765773.6137337326}]
[null,null,null,null,47,true,7459.8338682221111,0,0,4475.9003209332668,0,11935.734189155377,59678.670945776888,47742.936756621508,3212134.584782959,75927.062271980772,0,0,0,162504.9057959475,3450566.5528508872,760903.05455865513,3.321670699835566E-9,0,1.0039749690253432E-10,3.4220681967381003E-9,{"$f":"U55*(1-$C$37)+V55-Z55+(SUM($Q$9:Q55,$S$9:S55))*$C$37","v":2930619.3029912901}]
[null,null,null,null,48,true,7609.0305455865509,0,0,4565.4183273519302,0,12174.448872938481,60872.244364692408,48697.795491753925,3450566.5528508872,77445.603517420357,0,0,0,174464.4677304799,3702476.6240987875,776121.11564982834,3.4220681967381003E-9,0,1.0343201124641351E-10,3.5255002079845138E-9,{"$f":"U56*(1-$C$37)+V56-Z56+(SUM($Q$9:Q56,$S$9:S56))*$C$37","v":3104238.4168831422}]
[null,null,null,null,49,true,7761.2111564982833,0,0,4656.7266938989696,0,12417.937850397253,62089.689251986259,49671.751401589005,3702476.6240987875,78994.515587768765,0,0,0,187098.69409463363,3968569.8337811902,791643.53796282492,3.5255002079845138E-9,0,1.0655824378633624E-10,3.6320584517708501E-9,{"$f":"U57*(1-$C$37)+V57-Z57+(SUM($Q$9:Q57,$S$9:S57))*$C$37","v":3287080.249444434}]
[null,null,null,null,50,true,7916.4353796282494,0,0,4749.8612277769498,0,12666.296607405198,63331.483037025995,50665.186429620793,3968569.8337811902,80574.405899524165,{"$f":"-SUM($S$9:$S$55)/$Q$3*AND(E58>=$Q$4,E58<=$Q$5)","v":0},0,0,200442.85183654763,4249587.0915172622,807476.40872208145,3.6320584517708501E-9,0,1.0977896670477897E-10,3.741837418475629E-9,{"$f":"U58*(1-$C$37)+V58-Z58+(SUM($Q$9:Q58,$S$9:S58))*$C$37","v":3479616.7718681321}]