{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PRÉSTAMO DE PAGO GLOBAL"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"PRÉSTAMO DE PAGO GLOBAL","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[1,1,1,2],[6,1,6,2]]}
["                                                                                                                                                                                                                                                                                                                                                            ","PRÉSTAMO DE PAGO GLOBAL","FECHA"]
[null,"SUPUESTOS"]
[null,"IMPORTE DEL PRÉSTAMO PRINCIPAL",{"v":10000,"d":"10,000.00 €"}]
[null,"TASA DE INTERÉS ANUAL",{"v":0.0585,"d":"5.85%"}]
[null,"PERÍODO DE AMORTIZACIÓN (EN AÑOS)",15]
[null,"AÑOS HASTA EL PAGO GLOBAL",5]
[null,"DATOS FINANCIEROS PRINCIPALES"]
[null,"PAGO MENSUAL",{"$f":"IFERROR(IF(SUM(Supuestos)>0,ROUND(PMT(Tasa/12,Período*12,-Principal),2),\"\"),\"\")","v":{"v":83.58,"d":"83.58 €"}}]
[null,"TOTAL DE PAGOS MENSUAL",{"$f":"IFERROR(IF(AND(PagoMensual>0,AñosHastaPago>0),AñosHastaPago*12*PagoMensual,\"\"),\"\")","v":{"v":5014.8,"d":"5,014.80 €"}}]
[null,"CANTIDAD TOTAL PAGADA",{"$f":"IFERROR(IF(AND(PagoMensual>0,AñosHastaPago>0),PagosMensualesTotales+PagoGlobal,\"\"),\"\")","v":{"v":12594.464455242689,"d":"12,594.46 €"}}]
[null,"INTERÉS TOTAL",{"$f":"IFERROR(IF(OR(CantidadTotalPagada>0,AñosHastaPago>0),CantidadTotalPagada-Principal,\"\"),\"\")","v":{"v":2594.464455242689,"d":"2,594.46 €"}}]
[null,"PAGO GLOBAL",{"$f":"IFERROR(IF(AND(SUM(Supuestos2)>0,SUM(PagoMensual)>0),PV(Tasa/12,(Período-AñosHastaPago)*12,-PagoMensual),\"\"),\"\")","v":{"v":7579.664455242689,"d":"7,579.66 €"}}]