{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Programación del préstamo"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":24,"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":"Programación del préstamo","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,1,8,2],[10,1,10,3],[8,6,8,7],[8,8,8,10],[9,8,9,10],[10,6,10,7],[10,8,10,10],[6,1,6,3],[6,6,6,7],[6,8,6,10],[7,6,7,7],[7,8,7,10],[7,1,7,3],[4,6,4,7],[4,8,4,10],[5,6,5,7],[5,8,5,10],[1,2,1,10],[4,1,4,3],[5,1,5,3]]}
[]
[null,null,"Programación de la amortización del préstamo"]
[]
[null,"Indicar valores",null,null,null,null,"Resumen del préstamo"]
[null,"Importe del préstamo",null,null,5000,null,"Pago programado",null,{"$f":"IF(LoanIsGood,-PMT(InterestRate/PaymentsPerYear,NúmeroDePagosProgramados,ImporteDelPréstamo),\"\")","v":4.257495209777896E2}]
[null,"Tasa de interés anual",null,null,0.04,null,"Número de pagos programados",null,{"$f":"IF(LoanIsGood,LoanPeriod*PaymentsPerYear,\"\")","v":12}]
[null,"Periodo del préstamo en años",null,null,1,null,"Número real de pagos",null,{"$f":"NúmeroRealDePagos","v":10}]
[null,"Número de pagos por año",null,null,12,null,"Importe total de pagos anticipados",null,{"$f":"ImporteTotalDePagosAnticipados","v":900}]
[null,"Fecha de inicio del préstamo",null,null,{"$f":"TODAY()","v":"2021-05-28"},null,"Importe total de intereses",null,{"$f":"ImporteTotalDeIntereses","v":8.962148596539345E1}]
[]
[null,"Pagos adicionales opcionales",null,null,100,null,"Nombre del prestamista",null,"Banco Woodgrove"]
[]
[null,"Número de pago","Pago\nFecha","Inicio\nSaldo","Pago programado","Adicional\nPago","Total\nPago","Director","Interés","Fin\nSaldo","Acumulado\nInterés"]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":1},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-05-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":5000},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.0908285431112296E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":1.6666666666666668E1},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":4.490917145688877E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":1.6666666666666668E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-06-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":4.490917145688877E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.1077979715882674E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":1.4969723818962924E1},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":3.9801373485300505E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":3.163639048562959E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-07-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":3.9801373485300505E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.124823964826895E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":1.326712449510017E1},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":3.467654952047361E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":4.490351498072976E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":4},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-08-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":3.467654952047361E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.141906711376317E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":1.155884984015787E1},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":2.953464280909729E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":5.646236482088763E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":5},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-09-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":2.953464280909729E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.159046400414239E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":9.844880936365763},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":2.437559640868305E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":6.63072457572534E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":6},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-10-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":2.437559640868305E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.176243221748953E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":8.125198802894351},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":1.9199353186934097E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":7.443244456014774E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":7},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-11-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":1.9199353186934097E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.193497365821449E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":6.3997843956447},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":1.4005855821112648E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":8.083222895579244E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":8},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2021-12-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":1.4005855821112648E3},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.210809023707521E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":4.6686186070375495},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":8.795046797405126E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":8.550084756282999E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":9},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2022-01-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":8.795046797405126E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":100},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":5.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":5.22817838711988E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":2.931682265801709},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":3.5668684102852467E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":8.84325298286317E1}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])>NúmeroDePagosProgramados,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Número de pago]])),\"\")","v":10},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Número de pago]])-ROW(PaymentSchedule3[[#Headers],[Número de pago]])-2)+DAY(LoanStartDate),\"\")","v":"2022-02-28"},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])=1,ImporteDelPréstamo,INDEX(PaymentSchedule3[Fin\nSaldo],ROW()-ROW(PaymentSchedule3[[#Headers],[Inicio\nSaldo]])-1)),\"\")","v":3.5668684102852467E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PagoProgramado,\"\")","v":4.257495209777896E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+ExtraPayments<PaymentSchedule3[[#This Row],[Inicio\nSaldo]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]]>0,PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Pago programado]],0)),\"\")","v":0},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]),\"\")","v":3.5668684102852467E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Total\nPago]]-PaymentSchedule3[[#This Row],[Interés]],\"\")","v":3.554978848917629E2},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",PaymentSchedule3[[#This Row],[Inicio\nSaldo]]*(InterestRate/PaymentsPerYear),\"\")","v":1.188956136761749},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",IF(PaymentSchedule3[[#This Row],[Pago programado]]+PaymentSchedule3[[#This Row],[Adicional\nPago]]<=PaymentSchedule3[[#This Row],[Inicio\nSaldo]],PaymentSchedule3[[#This Row],[Inicio\nSaldo]]-PaymentSchedule3[[#This Row],[Director]],0),\"\")","v":0},{"$f":"IF(PaymentSchedule3[[#This Row],[Número de pago]]<>\"\",SUM(INDEX(PaymentSchedule3[Interés],1,1):PaymentSchedule3[[#This Row],[Interés]]),\"\")","v":8.962148596539345E1}]