{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculatrice","Calculations","Renonciation"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Calculatrice","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Paramètres du prêt"]
["PDSF",60000]
["Montant du prêt1",80000,{"$f":"Calculations!P3","v":"Max de $90000"}]
["Taux d'intérêt2",0.06]
["Terme en mois",60]
[]
["Province","BC"]
["Plan valeur variable acheté?","Oui"]
[]
["Crédit en concession du Plan valeur ",5000]
[]
["Paramètres du Plan valeur variable"]
["Dépréciation3",{"$f":"Calculations!S3","v":0.21}]
["Inflation",{"$f":"Calculations!S4","v":2.5000000000000001E-2}]
["Taxes de vente 4",0.12]
[]
[]
["Remarques"]
["1 Credit en concession plafonnant à 150 % du PDSF"]
["2 Taux cumulé mensuellement (le taux mensuel en vigueur est le taux soumissionné  / 12)"]
["3 Environ 21 % par année, en moyenne"]
["http://www.consumerreports.org/cro/2012/12/what-that-car-really-costs-to-own/index.htm"]
["4 Le taux d'imposition de la TPS et de la TVP/TVQ ou de la TVH. La taxe de luxe n'est pas calculée"]

{"sheet":"Calculations","index":1,"n_rows":98,"n_cols":19,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
["Fin de mois","Plan valeur variable  ","Solde du prêt","Intérêt","Paiement","Valeur non amortie ","Prix d'un véhicule neuf","Engagement cumulé - prêt et remplacement ","Rabais total","Engagement cumulé après rabais","Valeur non amortie incluant le crédit en concession du Plan valeur",null,null,null,null,{"$f":"Calculatrice!$B$4*1.5","v":90000}]
[0,{"$f":"MAX(C2-F2,0)","v":12800},{"$f":"Calculatrice!B5","v":80000},0,0,{"$f":"Calculatrice!$B$4*(1+$S$5)","v":67200},{"$f":"F2","v":67200},{"$f":"G2-F2+B2","v":12800},{"$f":"B2*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},{"$f":"MAX(0,H2-I2)","v":12800},{"$f":"F2+Calculatrice!$B$12","v":72200},null,null,null,null,"Message d'erreur - montant du prêt"]
[{"$f":"A2+1","v":1},{"$f":"MAX(C3-F3,0)","v":12824.811800260693},{"$f":"MAX(C2+D3-E3,0)","v":78853.375877645769},{"$f":"Calculatrice!$B$6/12*C2","v":400},{"$f":"$P$6","v":1546.6241223542331},{"$f":"F2*((1-$S$3)*(1+$S$4))^(1/12)","v":66028.564077385076},{"$f":"G2*((1+$S$4)^(1/12))","v":67338.420997333436},{"$f":"G3-F3+B3","v":14134.668720209054},{"$f":"B3*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},{"$f":"MAX(0,H3-I3)","v":14134.668720209054},{"$f":"F3+Calculatrice!$B$12","v":71028.564077385076},null,null,null,null,{"$f":"IF(Calculatrice!$B$5=(Calculatrice!$B$4*1.5),\"\",\"Max de $\"&Calculatrice!$B$4*1.5)","v":"Max de $90000"},null,"Dépréciation3",0.21]
[2,12823.469912635919,{"$f":"MAX(C3+D4-E4,0)","v":77701.018634679771},{"$f":"Calculatrice!$B$6/12*C3","v":394.26687938822886},{"$f":"$P$6","v":1546.6241223542331},{"$f":"F3*((1-$S$3)*(1+$S$4))^(1/12)","v":64877.548722043852},{"$f":"G3*((1+$S$4)^(1/12))","v":67477.127119257682},15423.04830984975,{"$f":"B4*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},15423.04830984975,{"$f":"F4+Calculatrice!$B$12","v":69877.548722043852},null,null,null,null,null,null,"Inflation",2.5000000000000001E-2]
[3,12796.301644529529,76542.89960549894,{"$f":"Calculatrice!$B$6/12*C4","v":388.50509317339885},1546.6241223542331,63746.597960969411,67616.118953082725,16665.822636642843,{"$f":"B5*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},16665.822636642843,{"$f":"F5+Calculatrice!$B$12","v":68746.597960969404},null,null,null,null,"Paiement mensuel",null,"Taux d'imposition",{"$f":"Calculatrice!B17","v":0.12}]
[4,12743.627954666641,75378.989981172199,{"$f":"Calculatrice!$B$6/12*C5","v":382.7144980274947},1546.6241223542331,62635.362026505558,67755.397087328281,17863.663015489365,{"$f":"B6*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},17863.663015489365,{"$f":"F6+Calculatrice!$B$12","v":67635.362026505551},null,null,null,null,{"$f":"IF(Calculatrice!$B$5>(Calculatrice!$B$4*1.5),0,PMT(Calculatrice!$B$6/12,Calculatrice!$B$7,-Calculatrice!$B$5))","v":1546.6241223542331}]
[5,12665.763560549218,74209.260808723833,{"$f":"Calculatrice!$B$6/12*C6","v":376.89494990586098},1546.6241223542331,61543.497248174615,67894.96211172636,19017.228424100962,{"$f":"B7*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},19017.228424100962,{"$f":"F7+Calculatrice!$B$12","v":66543.497248174623},null,null,null,null,null,null,"Plan valeur variable acheté?"]
[6,12563.017044022301,73033.682990413217,{"$f":"Calculatrice!$B$6/12*C7","v":371.04630404361916},1546.6241223542331,60470.665946390916,68034.814617223688,20127.165714855073,{"$f":"B8*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},20127.165714855073,{"$f":"F8+Calculatrice!$B$12","v":65470.665946390916},null,null,null,null,null,null,"Oui"]
[7,12435.690954983962,71852.227283011045,{"$f":"Calculatrice!$B$6/12*C8","v":365.16841495206609},1546.6241223542331,59416.536328027083,68174.955195984279,21194.109822941158,{"$f":"B9*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},21194.109822941158,{"$f":"F9+Calculatrice!$B$12","v":64416.536328027083},null,null,null,null,null,null,"Non"]
[8,12284.081913271053,70664.864297071865,{"$f":"Calculatrice!$B$6/12*C9","v":359.2611364150552},1546.6241223542331,58380.782383800812,68315.38444139187,22218.683970862112,{"$f":"B10*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},22218.683970862112,{"$f":"F10+Calculatrice!$B$12","v":63380.782383800812}]
[9,12108.480708752606,69471.564496202991,{"$f":"Calculatrice!$B$6/12*C10","v":353.32432148535935},1546.6241223542331,57363.083787450385,68456.102948052503,23201.499869354724,{"$f":"B11*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},23201.499869354724,{"$f":"F11+Calculatrice!$B$12","v":62363.083787450385},null,null,null,null,null,null,"Privilège Plan valeur "]
[10,11909.172399661969,68272.298196329779,{"$f":"Calculatrice!$B$6/12*C11","v":347.35782248101498},1546.6241223542331,56363.125796667809,68597.111311796994,24143.157914791154,{"$f":"B12*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},24143.157914791154,{"$f":"F12+Calculatrice!$B$12","v":61363.125796667809},null,null,null,null,null,null,{"$f":"IF(Calculatrice!$B$10=Calculations!$R$8,0,0)","v":0}]
[11,11686.43640919833,67067.035564957201,{"$f":"Calculatrice!$B$6/12*C12","v":341.3614909816489},1546.6241223542331,55380.599155758871,68738.410129683471,25044.247383122929,{"$f":"B13*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},25044.247383122929,{"$f":"F13+Calculatrice!$B$12","v":60380.599155758871},null,null,null,null,null,null,{"$f":"IF(Calculatrice!$B$10=Calculations!$R$8,5000,5000)","v":5000}]
[12,11440.546620427725,65855.746620427759,{"$f":"Calculatrice!$B$6/12*C13","v":335.335177824786},1546.6241223542331,54415.200000000033,68879.999999999913,25905.346620427605,{"$f":"B14*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},25905.346620427605,{"$f":"F14+Calculatrice!$B$12","v":59415.200000000033},null,null,null,null,null,null,{"$f":"IF(Calculatrice!$B$10=Calculations!$R$8,\"\",7500)","v":""}]
[13,11171.771469513071,64638.401231175667,{"$f":"Calculatrice!$B$6/12*C14","v":329.2787331021388},1546.6241223542331,53466.629761662596,69021.881522266674,26727.023230117149,{"$f":"B15*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},26727.023230117149,{"$f":"F15+Calculatrice!$B$12","v":58466.629761662596},null,null,null,null,null,null,{"$f":"IF(Calculatrice!$B$10=Calculations!$R$8,\"\",10000)","v":""}]
[14,10880.374037302274,63414.969114977313,{"$f":"Calculatrice!$B$6/12*C15","v":323.19200615587835},1546.6241223542331,52534.59507767504,69164.055297239029,27509.834256866263,{"$f":"B16*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},27509.834256866263,{"$f":"F16+Calculatrice!$B$12","v":57534.59507767504}]
[15,10566.612139302953,62185.419838197966,{"$f":"Calculatrice!$B$6/12*C16","v":317.07484557488658},1546.6241223542331,51618.807698895012,69306.521926909685,28254.326367317626,{"$f":"B17*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},28254.326367317626,{"$f":"F17+Calculatrice!$B$12","v":56618.807698895012}]
[16,10230.738414071813,60949.722815034722,{"$f":"Calculatrice!$B$6/12*C17","v":310.92709919098985},1546.6241223542331,50718.984400962909,69449.28201451138,28961.036027620285,{"$f":"B18*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},28961.036027620285,{"$f":"F18+Calculatrice!$B$12","v":55718.984400962909}]
[17,9873.0004100462393,59707.847306755662,{"$f":"Calculatrice!$B$6/12*C18","v":304.74861407517363},1546.6241223542331,49834.846896709423,69592.336164519409,29630.489677856225,{"$f":"B19*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},29630.489677856225,{"$f":"F19+Calculatrice!$B$12","v":54834.846896709423}]
[18,9493.6406708451323,58459.762420935207,{"$f":"Calculatrice!$B$6/12*C19","v":298.53923653377831},1546.6241223542331,48966.121750090075,69735.684982654173,30263.20390340923,{"$f":"B20*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},30263.20390340923,{"$f":"F20+Calculatrice!$B$12","v":53966.121750090075}]
[19,9092.8968190656888,57205.437110685649,{"$f":"Calculatrice!$B$6/12*C20","v":292.29881210467602},1546.6241223542331,48112.54029161996,69879.329075883768,30859.685603329497,{"$f":"B21*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},30859.685603329497,{"$f":"F21+Calculatrice!$B$12","v":53112.54029161996}]
[20,8671.0016386021161,55944.840173884848,{"$f":"Calculatrice!$B$6/12*C21","v":286.02718555342824},1546.6241223542331,47273.838535282732,70023.269052426549,31420.432155745933,{"$f":"B22*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},31420.432155745933,{"$f":"F22+Calculatrice!$B$12","v":52273.838535282732}]
[21,8228.1831555120662,54677.94025240004,{"$f":"Calculatrice!$B$6/12*C22","v":279.72420086942424},1546.6241223542331,46449.757096887974,70167.505521753701,31945.931580377794,{"$f":"B23*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},31945.931580377794,{"$f":"F23+Calculatrice!$B$12","v":51449.757096887974}]
[22,7764.6647174560276,53404.705831307809,{"$f":"Calculatrice!$B$6/12*C23","v":273.38970126200019},1546.6241223542331,45640.041113851781,70312.039094591804,32436.662698196051,{"$f":"B24*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},32436.662698196051,{"$f":"F24+Calculatrice!$B$12","v":50640.041113851781}]
[23,7280.6650717343509,52125.105238110118,{"$f":"Calculatrice!$B$6/12*C24","v":267.02352915653904},1546.6241223542331,44844.440166375767,70456.870382925452,32893.095288284036,{"$f":"B25*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},32893.095288284036,{"$f":"F25+Calculatrice!$B$12","v":49844.440166375767}]
[24,6776.3984419463886,50839.106641946441,{"$f":"Calculatrice!$B$6/12*C25","v":260.6255261905506},1546.6241223542331,44062.708200000052,70601.999999999811,33315.690241946148,{"$f":"B26*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},33315.690241946148,{"$f":"F26+Calculatrice!$B$12","v":49062.708200000052}]
[25,6252.0746032956304,49546.678052801944,{"$f":"Calculatrice!$B$6/12*C26","v":254.19553320973222},1546.6241223542331,43294.603449506314,70747.428560323242,33704.899714112558,{"$f":"B27*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},33704.899714112558,{"$f":"F27+Calculatrice!$B$12","v":48294.603449506314}]
[26,5707.8989565643351,48247.787320711723,{"$f":"Calculatrice!$B$6/12*C27","v":247.73339026400973},1546.6241223542331,42539.888364147388,70893.156679669904,34061.167272086852,{"$f":"B28*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},34061.167272086852,{"$f":"F28+Calculatrice!$B$12","v":47539.888364147388}]
[27,5144.0726007807898,46942.402134961048,{"$f":"Calculatrice!$B$6/12*C28","v":241.23893660355861},1546.6241223542331,41798.329534180259,71039.184975082331,34384.928041682862,{"$f":"B29*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},34384.928041682862,{"$f":"F29+Calculatrice!$B$12","v":46798.329534180259}]
[28,4560.7924046018888,45630.490023281622,{"$f":"Calculatrice!$B$6/12*C29","v":234.71201067480524},1546.6241223542331,41069.697618679733,71185.514064874078,34676.608850796234,{"$f":"B30*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},34676.608850796234,{"$f":"F30+Calculatrice!$B$12","v":46069.697618679733}]
[29,3958.2510764333274,44312.0183510438,{"$f":"Calculatrice!$B$6/12*C30","v":228.15245011640812},1546.6241223542331,40353.767274610473,71332.144568632313,34936.628370455168,{"$f":"B31*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},34936.628370455168,{"$f":"F31+Calculatrice!$B$12","v":45353.767274610473}]
[30,3336.6372333093386,42986.954320444791,{"$f":"Calculatrice!$B$6/12*C31","v":221.56009175521899},1546.6241223542331,39650.317087135452,71479.077107220452,35165.397253394338,{"$f":"B32*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35165.397253394338,{"$f":"F32+Calculatrice!$B$12","v":44650.317087135452}]
[31,2696.1354685535043,41655.264969692784,{"$f":"Calculatrice!$B$6/12*C32","v":214.93477160222395},1546.6241223542331,38959.129501139279,71626.312302780789,35363.318270195014,{"$f":"B33*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35363.318270195014,{"$f":"F33+Calculatrice!$B$12","v":43959.129501139279}]
[32,{"$f":"MAX(C34-F34,0)","v":2036.9264182418046},40316.917172187015,{"$f":"Calculatrice!$B$6/12*C33","v":208.27632484846393},1546.6241223542331,38279.990753945211,71773.850778737135,35530.786443033729,{"$f":"B34*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35530.786443033729,{"$f":"F34+Calculatrice!$B$12","v":43279.990753945211}]
[{"$f":"A34+1","v":33},1359.1868264886652,38971.877635693716,{"$f":"Calculatrice!$B$6/12*C34","v":201.58458586093508},1546.6241223542331,37612.690809205051,71921.693159797462,35668.189177081076,{"$f":"B35*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35668.189177081076,{"$f":"F35+Calculatrice!$B$12","v":42612.690809205051}]
[34,663.08960957646195,37620.112901517954,{"$f":"Calculatrice!$B$6/12*C35","v":194.85938817846858},1546.6241223542331,36957.023291941492,72069.840071956511,35775.906389591481,{"$f":"B36*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35775.906389591481,{"$f":"F36+Calculatrice!$B$12","v":41957.023291941492}]
[35,0,36261.589343671316,{"$f":"Calculatrice!$B$6/12*C36","v":188.10056450758978},1546.6241223542331,36312.785424722788,72218.292142498496,35905.506717775708,{"$f":"B37*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},35905.506717775708,{"$f":"F37+Calculatrice!$B$12","v":41312.785424722788}]
[36,0,34896.273168035441,{"$f":"Calculatrice!$B$6/12*C37","v":181.30794671835659},1546.6241223542331,35679.777964950052,72367.049999999712,36687.27203504966,{"$f":"B38*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},36687.27203504966,{"$f":"F38+Calculatrice!$B$12","v":40679.777964950052}]
[37,0,33524.130411521386,{"$f":"Calculatrice!$B$6/12*C38","v":174.4813658401772},1546.6241223542331,35057.805143237747,72516.114274331238,37458.309131093491,{"$f":"B39*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},37458.309131093491,{"$f":"F39+Calculatrice!$B$12","v":40057.805143237747}]
[38,0,32145.12694122476,{"$f":"Calculatrice!$B$6/12*C39","v":167.62065205760695},1546.6241223542331,34446.674602868356,72665.485596661572,38218.810993793217,{"$f":"B40*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},38218.810993793217,{"$f":"F40+Calculatrice!$B$12","v":39446.674602868356}]
[39,0,30759.228453576648,{"$f":"Calculatrice!$B$6/12*C40","v":160.7256347061238},1546.6241223542331,33846.197340302475,72815.164599459313,38968.967259156838,{"$f":"B41*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},38968.967259156838,{"$f":"F41+Calculatrice!$B$12","v":38846.197340302475}]
[40,0,29366.400473490296,{"$f":"Calculatrice!$B$6/12*C41","v":153.79614226788325},1546.6241223542331,33256.187646725928,72965.151916495844,39708.964269769916,{"$f":"B42*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},39708.964269769916,{"$f":"F42+Calculatrice!$B$12","v":38256.187646725928}]
[41,0,27966.608353503514,{"$f":"Calculatrice!$B$6/12*C42","v":146.83200236745148},1546.6241223542331,32676.463050615846,73115.448182848035,40438.985132232192,{"$f":"B43*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},40438.985132232192,{"$f":"F43+Calculatrice!$B$12","v":37676.463050615843}]
[42,0,26559.817272916796,{"$f":"Calculatrice!$B$6/12*C43","v":139.83304176751759},1546.6241223542331,32106.84426130795,73266.054034900866,41159.209773592913,{"$f":"B44*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},41159.209773592913,{"$f":"F44+Calculatrice!$B$12","v":37106.844261307953}]
[43,0,25145.992236927144,{"$f":"Calculatrice!$B$6/12*C44","v":132.79908636458399},1546.6241223542331,31547.155113547549,73416.970110350216,41869.81499680267,{"$f":"B45*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},41869.81499680267,{"$f":"F45+Calculatrice!$B$12","v":36547.155113547546}]
[44,0,23725.098075757545,{"$f":"Calculatrice!$B$6/12*C45","v":125.72996118463573},1546.6241223542331,30997.222513007153,73568.197048205475,42570.974535198322,{"$f":"B46*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},42570.974535198322,{"$f":"F46+Calculatrice!$B$12","v":35997.222513007153}]
[45,0,22297.099443782099,{"$f":"Calculatrice!$B$6/12*C46","v":118.62549037878773},1546.6241223542331,30456.87638275381,73719.735488792299,43262.859106038493,{"$f":"B47*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},43262.859106038493,{"$f":"F47+Calculatrice!$B$12","v":35456.876382753806}]
[46,0,20861.960818646774,{"$f":"Calculatrice!$B$6/12*C47","v":111.4854972189105},1546.6241223542331,29925.949610649644,73871.58607375533,43945.636463105686,{"$f":"B48*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},43945.636463105686,{"$f":"F48+Calculatrice!$B$12","v":34925.949610649644}]
[47,0,19419.646500385774,{"$f":"Calculatrice!$B$6/12*C48","v":104.30980409323388},1546.6241223542331,29404.277997669302,74023.749446060858,44619.47144839156,{"$f":"B49*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},44619.47144839156,{"$f":"F49+Calculatrice!$B$12","v":34404.277997669298}]
[48,0,17970.120610533468,{"$f":"Calculatrice!$B$6/12*C49","v":97.098232501928877},1546.6241223542331,28891.700207118327,74176.2262499996,45284.526042881276,{"$f":"B50*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},45284.526042881276,{"$f":"F50+Calculatrice!$B$12","v":33891.700207118323}]
[49,0,16513.347091231899,{"$f":"Calculatrice!$B$6/12*C50","v":89.850603052667338},1546.6241223542331,28388.057714736788,74329.017131189408,45940.959416452621,{"$f":"B51*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},45940.959416452621,{"$f":"F51+Calculatrice!$B$12","v":33388.057714736788}]
[50,0,15049.289704333825,{"$f":"Calculatrice!$B$6/12*C51","v":82.566735456159492},1546.6241223542331,27893.194759672675,74482.122736577992,46588.927976905317,{"$f":"B52*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},46588.927976905317,{"$f":"F52+Calculatrice!$B$12","v":32893.194759672675}]
[51,0,13577.912030501262,{"$f":"Calculatrice!$B$6/12*C52","v":75.246448521669123},1546.6241223542331,27406.958296309953,74635.543714445681,47228.585418135728,{"$f":"B53*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},47228.585418135728,{"$f":"F53+Calculatrice!$B$12","v":32406.958296309953}]
[52,0,12099.177468299535,{"$f":"Calculatrice!$B$6/12*C53","v":67.889560152506306},1546.6241223542331,26929.197946936343,74789.280714408131,47860.082767471788,{"$f":"B54*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},47860.082767471788,{"$f":"F54+Calculatrice!$B$12","v":31929.197946936343}]
[53,0,10613.0492332868,{"$f":"Calculatrice!$B$6/12*C54","v":60.495887341497678},1546.6241223542331,26459.765955236206,74943.33438741912,48483.568432182918,{"$f":"B55*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},48483.568432182918,{"$f":"F55+Calculatrice!$B$12","v":31459.765955236206}]
[54,0,9119.4903570990009,{"$f":"Calculatrice!$B$6/12*C55","v":53.065246166434001},1546.6241223542331,25998.517140594136,75097.705385773283,49099.188245179146,{"$f":"B56*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},49099.188245179146,{"$f":"F56+Calculatrice!$B$12","v":30998.517140594136}]
[55,0,7618.4636865302637,{"$f":"Calculatrice!$B$6/12*C56","v":45.597451785495004},1546.6241223542331,25545.308853195151,75252.394363108862,49707.085509913712,{"$f":"B57*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},49707.085509913712,{"$f":"F57+Calculatrice!$B$12","v":30545.308853195151}]
[56,0,6109.9318826086819,{"$f":"Calculatrice!$B$6/12*C57","v":38.092318432651318},1546.6241223542331,25100.000929907565,75407.401974410503,50307.401044502942,{"$f":"B58*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},50307.401044502942,{"$f":"F58+Calculatrice!$B$12","v":30100.000929907565}]
[57,0,4593.8574196674926,{"$f":"Calculatrice!$B$6/12*C58","v":30.549659413043411},1546.6241223542331,24662.45565093492,75562.728876011999,50900.273225077079,{"$f":"B59*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},50900.273225077079,{"$f":"F59+Calculatrice!$B$12","v":29662.45565093492}]
[58,0,3070.2025844115969,{"$f":"Calculatrice!$B$6/12*C59","v":22.969287098337464},1546.6241223542331,24232.537697223572,75718.375725599108,51485.83802837554,{"$f":"B60*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},51485.83802837554,{"$f":"F60+Calculatrice!$B$12","v":29232.537697223572}]
[59,0,1538.9294749794219,{"$f":"Calculatrice!$B$6/12*C60","v":15.351012922057985},1546.6241223542331,23810.114108612739,75874.34318221228,52064.229073599541,{"$f":"B61*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},52064.229073599541,{"$f":"F61+Calculatrice!$B$12","v":28810.114108612739}]
[60,0,8.5947249317541718E-11,{"$f":"Calculatrice!$B$6/12*C61","v":7.6946473748971096},1546.6241223542331,23395.054242714086,76030.631906249502,52635.577663535412,{"$f":"B62*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},52635.577663535412,{"$f":"F62+Calculatrice!$B$12","v":28395.054242714086}]
[61,0,0,{"$f":"Calculatrice!$B$6/12*C62","v":4.2973624658770862E-13},1546.6241223542331,22987.229734508135,76187.242559469058,53200.012824960926,{"$f":"B63*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},53200.012824960926,{"$f":"F63+Calculatrice!$B$12","v":27987.229734508135}]
[62,0,0,{"$f":"Calculatrice!$B$6/12*C63","v":0},1546.6241223542331,22586.514456644967,76344.175804992352,53757.661348347385,{"$f":"B64*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},53757.661348347385,{"$f":"F64+Calculatrice!$B$12","v":27586.514456644967}]
[63,0,0,{"$f":"Calculatrice!$B$6/12*C64","v":0},1546.6241223542331,22192.784480437003,76501.432307306721,54308.647826869717,{"$f":"B65*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},54308.647826869717,{"$f":"F65+Calculatrice!$B$12","v":27192.784480437003}]
[64,{"$f":"MAX(C66-F66,0)","v":0},0,{"$f":"Calculatrice!$B$6/12*C65","v":0},1546.6241223542331,21805.918037531723,76659.012732268224,54853.094694736501,{"$f":"B66*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},54853.094694736501,{"$f":"F66+Calculatrice!$B$12","v":26805.918037531723}]
[{"$f":"A66+1","v":65},0,0,{"$f":"Calculatrice!$B$6/12*C66","v":0},1546.6241223542331,21425.795482252535,76816.917747104482,{"$f":"G67-F67+B67","v":55391.122264851947},{"$f":"B67*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},{"$f":"MAX(0,H67-I67)","v":55391.122264851947},{"$f":"F67+Calculatrice!$B$12","v":26425.795482252535}]
[66,0,{"$f":"MAX(C67+D68-E68,0)","v":0},{"$f":"Calculatrice!$B$6/12*C67","v":0},{"$f":"$P$6","v":1546.6241223542331},{"$f":"F67*((1-$S$3)*(1+$S$4))^(1/12)","v":21052.299254596117},{"$f":"G67*((1+$S$4)^(1/12))","v":76975.148020417488},55922.848765821371,{"$f":"B68*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},55922.848765821371,{"$f":"F68+Calculatrice!$B$12","v":26052.299254596117}]
[67,0,0,{"$f":"Calculatrice!$B$6/12*C68","v":0},1546.6241223542331,20685.313843874788,77133.704222186454,56448.390378311669,{"$f":"B69*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},56448.390378311669,{"$f":"F69+Calculatrice!$B$12","v":25685.313843874788}]
[68,0,0,{"$f":"Calculatrice!$B$6/12*C69","v":0},1546.6241223542331,20324.725752992665,77292.58702377064,56967.861270777976,{"$f":"B70*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},56967.861270777976,{"$f":"F70+Calculatrice!$B$12","v":25324.725752992665}]
[69,0,0,{"$f":"Calculatrice!$B$6/12*C70","v":0},1546.6241223542331,19970.423463344567,77451.797097912175,57481.373634567608,{"$f":"B71*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},57481.373634567608,{"$f":"F71+Calculatrice!$B$12","v":24970.423463344567}]
[70,0,0,{"$f":"Calculatrice!$B$6/12*C71","v":0},1546.6241223542331,19622.297400326803,77611.335118738949,57989.037718412146,{"$f":"B72*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},57989.037718412146,{"$f":"F72+Calculatrice!$B$12","v":24622.297400326803}]
[71,0,0,{"$f":"Calculatrice!$B$6/12*C72","v":0},1546.6241223542331,19280.239899449178,77771.201761767443,58490.961862318261,{"$f":"B73*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},58490.961862318261,{"$f":"F73+Calculatrice!$B$12","v":24280.239899449178}]
[72,0,0,{"$f":"Calculatrice!$B$6/12*C73","v":0},1546.6241223542331,18944.145173037745,77931.39770390559,58987.252530867845,{"$f":"B74*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},58987.252530867845,{"$f":"F74+Calculatrice!$B$12","v":23944.145173037745}]
[73,0,0,{"$f":"Calculatrice!$B$6/12*C74","v":0},1546.6241223542331,18613.909277517974,78091.92362345563,59478.014345937656,{"$f":"B75*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},59478.014345937656,{"$f":"F75+Calculatrice!$B$12","v":23613.909277517974}]
[74,0,0,{"$f":"Calculatrice!$B$6/12*C75","v":0},1546.6241223542331,18289.430081268274,78252.78020011702,59963.350118848743,{"$f":"B76*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},59963.350118848743,{"$f":"F76+Calculatrice!$B$12","v":23289.430081268274}]
[75,0,0,{"$f":"Calculatrice!$B$6/12*C76","v":0},1546.6241223542331,17970.607233033876,78413.968114989257,60443.360881955377,{"$f":"B77*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},60443.360881955377,{"$f":"F77+Calculatrice!$B$12","v":22970.607233033876}]
[76,0,0,{"$f":"Calculatrice!$B$6/12*C77","v":0},1546.6241223542331,17657.342130891324,78575.488050574801,60918.145919683477,{"$f":"B78*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},60918.145919683477,{"$f":"F78+Calculatrice!$B$12","v":22657.342130891324}]
[77,0,0,{"$f":"Calculatrice!$B$6/12*C78","v":0},1546.6241223542331,17349.537891754,78737.340690781974,61387.802799027973,{"$f":"B79*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},61387.802799027973,{"$f":"F79+Calculatrice!$B$12","v":22349.537891754}]
[78,0,0,{"$f":"Calculatrice!$B$6/12*C79","v":0},1546.6241223542331,17047.099321409216,78899.52672092781,61852.427399518594,{"$f":"B80*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},61852.427399518594,{"$f":"F80+Calculatrice!$B$12","v":22047.099321409216}]
[79,0,0,{"$f":"Calculatrice!$B$6/12*C80","v":0},1546.6241223542331,16749.932885077618,79062.046827740996,62312.113942663374,{"$f":"B81*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},62312.113942663374,{"$f":"F81+Calculatrice!$B$12","v":21749.932885077618}]
[80,0,0,{"$f":"Calculatrice!$B$6/12*C81","v":0},1546.6241223542331,16457.94667848582,79224.901699364782,62766.955020878959,{"$f":"B82*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},62766.955020878959,{"$f":"F82+Calculatrice!$B$12","v":21457.94667848582}]
[81,0,0,{"$f":"Calculatrice!$B$6/12*C82","v":0},1546.6241223542331,16171.050399443271,79388.09202535986,63217.041625916587,{"$f":"B83*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},63217.041625916587,{"$f":"F83+Calculatrice!$B$12","v":21171.050399443273}]
[82,0,0,{"$f":"Calculatrice!$B$6/12*C83","v":0},1546.6241223542331,15889.155319914636,79551.618496707306,63662.463176792669,{"$f":"B84*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},63662.463176792669,{"$f":"F84+Calculatrice!$B$12","v":20889.155319914636}]
[83,0,0,{"$f":"Calculatrice!$B$6/12*C84","v":0},1546.6241223542331,15612.174258578982,79715.48180581152,64103.307547232536,{"$f":"B85*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},64103.307547232536,{"$f":"F85+Calculatrice!$B$12","v":20612.174258578983}]
[84,0,0,{"$f":"Calculatrice!$B$6/12*C85","v":0},1546.6241223542331,15340.021553867324,79879.682646503119,64539.661092635797,{"$f":"B86*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},64539.661092635797,{"$f":"F86+Calculatrice!$B$12","v":20340.021553867322}]
[85,0,0,{"$f":"Calculatrice!$B$6/12*C86","v":0},1546.6241223542331,15072.61303747019,80044.221714041909,64971.608676571719,{"$f":"B87*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},64971.608676571719,{"$f":"F87+Calculatrice!$B$12","v":20072.61303747019}]
[86,0,0,{"$f":"Calculatrice!$B$6/12*C87","v":0},1546.6241223542331,14809.866008306995,80209.099705119821,65399.233696812822,{"$f":"B88*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},65399.233696812822,{"$f":"F88+Calculatrice!$B$12","v":19809.866008306995}]
[87,0,0,{"$f":"Calculatrice!$B$6/12*C88","v":0},1546.6241223542331,14551.69920694919,80374.317317863854,65822.618110914656,{"$f":"B89*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},65822.618110914656,{"$f":"F89+Calculatrice!$B$12","v":19551.69920694919}]
[88,0,0,{"$f":"Calculatrice!$B$6/12*C89","v":0},1546.6241223542331,14298.032790489258,80539.875251839039,66241.842461349777,{"$f":"B90*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},66241.842461349777,{"$f":"F90+Calculatrice!$B$12","v":19298.032790489258}]
[89,0,0,{"$f":"Calculatrice!$B$6/12*C90","v":0},1546.6241223542331,14048.788307847812,80705.774208051385,66656.985900203581,{"$f":"B91*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},66656.985900203581,{"$f":"F91+Calculatrice!$B$12","v":19048.788307847812}]
[90,0,0,{"$f":"Calculatrice!$B$6/12*C91","v":0},1546.6241223542331,13803.888675511123,80872.014888950871,67068.12621343974,{"$f":"B92*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},67068.12621343974,{"$f":"F92+Calculatrice!$B$12","v":18803.888675511123}]
[91,0,0,{"$f":"Calculatrice!$B$6/12*C92","v":0},1546.6241223542331,13563.258153691613,81038.597998434401,67475.33984474279,{"$f":"B93*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},67475.33984474279,{"$f":"F93+Calculatrice!$B$12","v":18563.258153691611}]
[92,0,0,{"$f":"Calculatrice!$B$6/12*C93","v":0},1546.6241223542331,13326.822322903903,81205.524241848776,67878.701918944877,{"$f":"B94*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},67878.701918944877,{"$f":"F94+Calculatrice!$B$12","v":18326.822322903903}]
[93,0,0,{"$f":"Calculatrice!$B$6/12*C94","v":0},1546.6241223542331,13094.5080609492,81372.794325993731,68278.286265044531,{"$f":"B95*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},68278.286265044531,{"$f":"F95+Calculatrice!$B$12","v":18094.5080609492}]
[94,0,0,{"$f":"Calculatrice!$B$6/12*C95","v":0},1546.6241223542331,12866.243520300886,81540.408959124863,68674.165438823984,{"$f":"B96*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},68674.165438823984,{"$f":"F96+Calculatrice!$B$12","v":17866.243520300886}]
[95,0,0,{"$f":"Calculatrice!$B$6/12*C96","v":0},1546.6241223542331,12641.95810588434,81708.368850956685,69066.410745072353,{"$f":"B97*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},69066.410745072353,{"$f":"F97+Calculatrice!$B$12","v":17641.95810588434}]
[96,{"$f":"MAX(C98-F98,0)","v":0},0,{"$f":"Calculatrice!$B$6/12*C97","v":0},1546.6241223542331,12421.582453244075,81876.674712665568,69455.092259421494,{"$f":"B98*$L$2+Calculatrice!$B$12*Calculations!$M$2","v":0},69455.092259421494,{"$f":"F98+Calculatrice!$B$12","v":17421.582453244075}]

{"sheet":"Renonciation","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,3,3]]}
[]
[]
[]
["Si votre véhicule était volé ou déclaré une perte partielle ou totale, le Programme privilège perte de véhicule vous aiderait à acheter un véhicule neuf faisant partie de l'inventaire de votre concessionnaire-vendeur à l'aide d'un crédit de fidélité en concession. La valeur en dollars du crédit de fidélité en concession est soit un montant fixe ou un montant variable, qui est calculé en fonction du solde résiduel de votre prêt moins le remboursement versé par votre police d'assurance automobile .\n\nSuite à la présentation de tous les détails concernant le Programme privilège perte de véhicule, et après avoir mûrement réfléchi et dûment pris en considération la question, je renonce à mon droit d'inscrire mon véhicule au Programme privilège perte de véhicule. Ainsi, j'assume l’entière responsabilité de tous les coûts connexes découlant de mon refus de participer au Programme."]
[]
["Les frais liés à l'achat d'un nouveau véhicule peuvent inclure :"]
[]
["Premier paiement :"]
["Dépôt de garantie :"]
["Nouvelles plaques d'immatriculation :"]
["Pneus/jantes d'hiver :"]
["Tapis de plancher :"]
["Dispositif antivol :"]
["Démarreur à distance :"]
["Frais divers :"]
[]
["Total :"]
[]
[]
["________________________________          _________________________________________           ___________________________"]
["Nom du client                                                        Signature du client                                                                     Date"]
[]
[]
["________________________________          _________________________________________           ___________________________"]
["Nom du témoin                                                    Signature du témoin                                                                 Date"]