{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Calculadora de préstamos"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Calculadora de préstamos","index":0,"n_rows":375,"n_cols":8,"rows_kept":375,"merged":[[0,2,0,7]]}
[null,null,"Calculadora simple de préstamos"]
[]
[{"$nulls":4},"Escriba los valores"]
[null,null,"Importe del préstamo"]
[null,null,"Interés anual"]
[null,null,"Período del préstamo en años"]
[null,null,"Fecha inicial del préstamo"]
[]
[null,null,"Pago mensual",null,{"$f":"IF(Values_Entered,Monthly_Payment,\"\")","v":""}]
[null,null,"Número de pagos",null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
[null,null,"Interés total",null,{"$f":"IF(Values_Entered,Total_Cost-Loan_Amount,\"\")","v":""}]
[null,null,"Costo total del préstamo",null,{"$f":"IF(Values_Entered,Monthly_Payment*Number_of_Payments,\"\")","v":""}]
[]
[]
[null,"Nº","Fecha de pago","Saldo inicial","Pago","Capital","Interés","Saldo final"]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Date,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Beginning_Balance,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Monthly_Payment,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Principal,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Interest,\"\")","v":""},{"$f":"IF(Loan_Not_Paid*Values_Entered,Ending_Balance,\"\")","v":""}]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]
[null,"","","","","","",""]