{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Prêt de paiement forfaitaire"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Prêt de paiement forfaitaire","index":0,"n_rows":12,"n_cols":3,"rows_kept":12}
["                                                                                                                                                                                                                                                                                                                                                            ","PRÊT DE PAIEMENT FORFAITAIRE","10/1/XX"]
[null,"HYPOTHÈSES"]
[null,"MONTANT PRINCIPAL DE L’EMPRUNT",{"v":10000,"d":"10,000.00 €"}]
[null,"TAUX D’INTÉRÊT ANNUEL",{"v":0.0585,"d":"5.85%"}]
[null,"PÉRIODE D’AMORTISSEMENT (EN ANNÉES)",15]
[null,"ANNÉES RESTANTES JUSQU’AU PAIEMENT LIBÉRATOIRE",5]
[null,"DONNÉES FINANCIÈRES CLÉS"]
[null,"PAIEMENT MENSUEL",{"$f":"IFERROR(IF(SUM(Hypothèses)>0,ROUND(PMT(Taux/12,Période*12,-Principal),2),\"\"),\"\")","v":{"v":83.58,"d":"83.58 €"}}]
[null,"TOTAL DES MENSUALITÉS",{"$f":"IFERROR(IF(AND(PaiementMensuel>0,YearsUntilPayment>0),YearsUntilPayment*12*PaiementMensuel,\"\"),\"\")","v":{"v":5014.8,"d":"5,014.80 €"}}]
[null,"MONTANT TOTAL PAYÉ",{"$f":"IFERROR(IF(AND(PaiementMensuel>0,YearsUntilPayment>0),TotalPaiementsMensuels+PaiementLibératoire,\"\"),\"\")","v":{"v":12594.464455242689,"d":"12,594.46 €"}}]
[null,"TOTAL DES INTÉRÊTS",{"$f":"IFERROR(IF(OR(MontantTotalPayé>0,YearsUntilPayment>0),MontantTotalPayé-Principal,\"\"),\"\")","v":{"v":2594.464455242689,"d":"2,594.46 €"}}]
[null,"PAIEMENT DE BALLON",{"$f":"IFERROR(IF(AND(SUM(Hypothèses2)>0,SUM(PaiementMensuel)>0),PV(Taux/12,(Période-YearsUntilPayment)*12,-PaiementMensuel),\"\"),\"\")","v":{"v":7579.664455242689,"d":"7,579.66 €"}}]