{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ローン計算"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"ローン計算","index":0,"n_rows":375,"n_cols":8,"rows_kept":375,"merged":[[0,2,0,7]]}
[null,null,"簡単なローン計算"]
[]
[{"$nulls":4},"値の入力"]
[null,null,"借入金額"]
[null,null,"年間利子率"]
[null,null,"貸付期間 (年)"]
[null,null,"借入日"]
[]
[null,null,"毎月返済額",null,{"$f":"IF(Values_Entered,Monthly_Payment,\"\")","v":""}]
[null,null,"返済回数",null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
[null,null,"総利息",null,{"$f":"IF(Values_Entered,Total_Cost-Loan_Amount,\"\")","v":""}]
[null,null,"総返済金額",null,{"$f":"IF(Values_Entered,Monthly_Payment*Number_of_Payments,\"\")","v":""}]
[]
[]
[null,"No.","支払日","期首残高","返済","元金","金利","期末残高"]
[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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"",{"$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,{"$f":"IF(Loan_Not_Paid*Values_Entered,Payment_Number,\"\")","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,"","","","","","",""]