{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["簡易試算ツール_202104"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"簡易試算ツール_202104","index":0,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,2,2,3],[45,2,46,2],[45,3,46,3],[27,2,28,3],[30,2,31,2],[30,3,31,3],[33,2,34,2],[33,3,34,3],[36,2,37,2],[36,3,37,3],[39,2,40,2],[39,3,40,3],[42,2,43,2],[42,3,43,3]]}
[]
[]
[null,null,"簡易試算ツール"]
[]
[null,null,"融資額"]
[]
[]
[null,null,"融資実行日","返済予定日"]
[]
[]
[null,null,"金利","手数料（税込）"]
[]
[]
[null,null,"振込手数料（税込）","その他"]
[]
[]
[null,null,"融資期間（日数）","保険料率"]
[null,null,{"$f":"IF(AND(TRIM(C9)<>\"\",TRIM(D9)<>\"\"),SUM(D9,-C9,1),\"\")","v":""},{"$f":"IF(AND(TRIM(C9)<>\"\",TRIM(D9)<>\"\"),IF(DATEDIF(C9,D9,\"M\")>=18,IF(C9<DATE(2022,4,1),1.26,1.16),IF(DATEDIF(C9,D9,\"M\")>=12,IF(C9<DATE(2022,4,1),0.945,0.87),IF(DATEDIF(C9,D9,\"M\")>=6,IF(C9<DATE(2022,4,1),0.63,0.58),IF(C9<DATE(2022,4,1),0.315,0.29)))),\"\")","v":""}]
[]
[null,null,"利息","保険料（税込）"]
[null,null,{"$f":"IF(AND(TRIM(C6)<>\"\",TRIM(C18)<>\"\",TRIM(C12)<>\"\"),ROUNDDOWN((C6*10000)*(C12/100)*C18/365,0),\"\")","v":""},{"$f":"IF(AND(TRIM(C6)<>\"\",TRIM(D18)<>\"\"),ROUNDDOWN((C6*10000)*(D18/100)*(IF(C9<DATE(2019,10,1),1.08,1.1)),0),\"\")","v":""}]
[]
[null,null,"控除合計","振込金額"]
[null,null,{"$f":"IF(OR(TRIM(C21)<>\"\",TRIM(D21)<>\"\",TRIM(D12)<>\"\"),SUM(C21,D21,D12,C15,D15),\"\")","v":""},{"$f":"IF(TRIM(C24)<>\"\",(C6*10000)-C24,\"\")","v":""}]
[]
[]
[]
[null,null,"金銭消費貸借契約証書貼付印紙税額"]
[]
[]
[null,null,"10万円超　50万円以下","400円"]
[]
[]
[null,null,"50万円超　100万円以下","1000円"]
[]
[]
[null,null,"100万円超　500万円以下","2000円"]
[]
[]
[null,null,"500万円超　1000万円以下","10000円"]
[]
[]
[null,null,"1000万円超　5000万円以下","20000円"]
[]
[]
[null,null,"5000万円超　1億円以下","60000円"]