{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["簡易試算表"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"簡易試算表","index":0,"n_rows":97,"n_cols":26,"rows_kept":97,"cut":false,"hidden":false,"merged":[[87,16,87,24],[80,7,80,9],[81,3,81,4],[81,7,81,9],[81,16,81,18],[81,21,81,24],[86,16,86,19],[86,21,86,24],[84,7,84,9],[84,16,84,18],[84,21,84,24],[84,3,85,5],[83,7,83,9],[83,14,83,19],[80,16,80,19],[76,7,76,10],[76,12,76,14],[76,16,76,19],[76,21,76,24],[77,5,77,6],[77,7,77,10],[77,12,77,14],[77,16,77,19],[78,5,78,6],[78,7,78,10],[78,12,78,14],[78,16,78,19],[1,2,1,26],[2,4,2,26],[4,2,4,6],[5,7,5,8],[5,9,5,13],[5,15,5,17],[5,20,5,23],[4,7,4,27],[0,1,0,27],[6,5,6,6],[6,7,6,8],[6,9,6,13],[6,15,6,17],[6,20,6,23],[7,5,7,6],[7,7,7,8],[7,9,7,13],[7,15,7,17],[7,20,7,23],[8,5,8,6],[8,7,8,8],[8,9,8,13],[8,15,8,17],[8,20,8,23],[9,5,9,6],[9,7,9,8],[9,9,9,13],[9,15,9,17],[9,20,9,23],[19,21,19,24],[20,5,20,6],[20,7,20,10],[20,12,20,14],[20,16,20,19],[20,21,20,24],[12,2,13,26],[15,2,15,26],[17,7,17,10],[17,12,17,14],[17,16,17,19],[18,5,18,6],[18,7,18,10],[18,12,18,14],[18,16,18,19],[21,5,21,6],[21,7,21,10],[21,12,21,14],[21,16,21,19],[24,6,24,11],[24,12,24,14],[22,16,22,19],[19,5,19,6],[19,7,19,10],[19,12,19,14],[19,16,19,19],[30,7,30,9],[30,16,30,19],[31,3,31,4],[31,7,31,9],[31,16,31,18],[31,21,31,24],[36,7,36,10],[27,16,28,19],[26,21,27,24],[91,25,93,25],[93,3,93,19],[66,3,66,4],[66,7,66,9],[66,16,66,18],[66,21,66,24],[68,21,68,24],[69,16,69,19],[69,21,69,24],[71,2,71,26],[73,7,73,10],[73,12,73,14],[73,16,73,19],[74,3,77,4],[74,5,74,6],[74,7,74,10],[74,12,74,14],[74,16,74,19],[75,5,75,6],[75,7,75,10],[75,12,75,14],[75,16,75,19],[75,21,75,24],[76,5,76,6],[10,5,10,6],[10,7,10,8],[10,9,10,13],[10,20,10,23],[10,15,10,17],[22,12,22,14],[70,16,70,24],[89,2,89,26],[62,5,62,6],[62,7,62,10],[62,12,62,14],[62,16,62,19],[52,21,52,24],[53,16,53,19],[53,21,53,24],[46,5,46,6],[46,7,46,10],[46,12,46,14],[46,16,46,19],[49,16,49,19],[47,5,47,6],[47,7,47,10],[47,12,47,14],[47,16,47,19],[96,21,96,24],[22,5,22,6],[22,7,22,10],[65,16,65,19],[63,5,63,6],[63,7,63,10],[63,12,63,14],[63,16,63,19],[60,5,60,6],[60,7,60,10],[60,12,60,14],[60,16,60,19],[60,21,60,24],[61,5,61,6],[61,7,61,10],[61,12,61,14],[61,16,61,19],[61,21,61,24],[91,3,92,19],[91,20,93,20],[91,21,93,24],[44,5,44,6],[44,7,44,10],[44,12,44,14],[96,10,96,20],[65,7,65,9],[25,5,26,6],[27,5,28,6],[25,3,28,4],[18,3,22,4],[43,3,47,4],[49,7,49,9],[25,16,26,19],[50,16,50,18],[25,7,26,10],[27,7,28,10],[25,12,26,14],[27,12,28,14],[44,16,44,19],[45,5,45,6],[45,7,45,10],[45,12,45,14],[45,16,45,19],[38,15,38,24],[40,2,40,26],[42,7,42,10],[42,12,42,14],[42,16,42,19],[24,21,25,24],[54,16,54,24],[56,2,56,26],[58,7,58,10],[58,12,58,14],[58,16,58,19],[59,3,62,4],[59,5,59,6],[59,7,59,10],[59,12,59,14],[59,16,59,19],[50,3,50,4],[50,7,50,9],[50,21,50,24],[26,25,27,25],[44,21,44,24],[45,21,45,24],[43,5,43,6],[43,7,43,10],[43,12,43,14],[43,16,43,19],[36,21,36,24],[37,16,37,19],[37,21,37,24]]}
[null,"令和８年度 北本市国民健康保険税簡易試算表"]
[null,null,"　令和８年度（令和８年４月から翌年3月まで）の国民健康保険税の試算ができます。目安としてご利用ください。\n　※この試算表は、あくまで概算です。 実際の税額と異なる場合があります。\n　なお、この試算表は、月割計算、軽減制度には対応していません。\n　詳しくお知りになりたい方は、保険年金課 国民健康保険担当までお問合せください。"]
[null,null,null,null,"の部分を入力してください。"]
[]
[null,null,"◆ 課税所得額",null,null,null,null,"　あなたの世帯の国保加入者全員のそれぞれの令和７年中の所得を入力してください。"]
[null,null,null,null,null,null,null,"年齢",null,"令和7年中の所得金額",null,null,null,null,null,"基礎控除額",null,null,null,null,"課税所得額"]
[null,null,null,null,null,"１人目",null,null,null,null,null,null,null,null,"－",430000,null,null,"円","＝",{"$f":"IF(J7=\"\",\"\",IF(J7-P7<0,0,J7-P7))","v":""}]
[null,null,null,null,null,"２人目",null,null,null,null,null,null,null,null,"－",430000,null,null,"円","＝",{"$f":"IF(J8=\"\",\"\",IF(J8-P8<0,0,J8-P8))","v":""}]
[null,null,null,null,null,"３人目",null,null,null,null,null,null,null,null,"－",430000,null,null,"円","＝",{"$f":"IF(J9=\"\",\"\",IF(J9-P9<0,0,J9-P9))","v":""}]
[null,null,null,null,null,"４人目",null,null,null,null,null,null,null,null,"－",430000,null,null,"円","＝",{"$f":"IF(J10=\"\",\"\",IF(J10-P10<0,0,J10-P10))","v":""}]
[null,null,null,null,null,"５人目",null,null,null,null,null,null,null,null,"－",430000,null,null,"円","＝",{"$f":"IF(J11=\"\",\"\",IF(J11-P11<0,0,J11-P11))","v":""}]
[]
[null,null,"　所得金額とは、給与所得の場合は給与所得控除後の金額、公的年金等の場合は公的年金等控除後の金額であり、扶養控除・配偶者控除・生命保険料控除等の所得控除をする前の金額になります。また、分離譲渡所得の特別控除と事業専従者控除が適用され、専従者給与については、支払いを受けた方の所得として計算します。"]
[]
[]
[null,null,"【医療給付分】"]
[]
[null,null,null,null,null,null,null,"課税所得額",null,null,null,null,"税　率",null,null,null,"所得割額"]
[null,null,null,"所得割",null,"１人目",null,{"$f":"U7","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H19=\"\",\"\",ROUNDDOWN(H19*M19,0))","v":""}]
[null,null,null,null,null,"２人目",null,{"$f":"U8","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H20=\"\",\"\",ROUNDDOWN(H20*M20,0))","v":""},null,null,null,null,"合計所得割額"]
[null,null,null,null,null,"３人目",null,{"$f":"U9","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H21=\"\",\"\",ROUNDDOWN(H21*M21,0))","v":""},null,null,null,null,{"$f":"IF(AND(Q19=\"\",Q20=\"\",Q21=\"\",Q22=\"\",Q23=\"\"),\"\",SUM(Q19:T23))","v":""},null,null,null,"①"]
[null,null,null,null,null,"４人目",null,{"$f":"U10","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H22=\"\",\"\",ROUNDDOWN(H22*M22,0))","v":""}]
[null,null,null,null,null,"５人目",null,{"$f":"U11","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H23=\"\",\"\",ROUNDDOWN(H23*M23,0))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"加入者数",null,null,null,null,null,null,null,null,"１人当たりの均等割額"]
[null,null,null,"均等割",null,null,null,{"$f":"IF(AND(H7=\"\",H8=\"\",H9=\"\",H10=\"\",H11=\"\"),\"\",COUNT(H7:I11))","v":""},null,null,"人","×",null,null,null,null,38900,null,null,"円","＝",{"$f":"IF(AND(H32=\"\"),\"\",H32*Q32)","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,"＝",{"$f":"IF(AND(V21=\"\",V32=\"\"),\"\",ROUNDDOWN(MIN(V21+V32,660000),-2))","v":""},null,null,null,"Ａ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は66万円です）"]
[]
[null,null,"【後期高齢者支援金分】"]
[]
[null,null,null,null,null,null,null,"課税所得額",null,null,null,null,"税　率",null,null,null,"所得割額"]
[null,null,null,"所得割",null,"１人目",null,{"$f":"U7","v":""},null,null,null,"×",2.8000000000000001E-2,null,null,"＝",{"$f":"IF(H44=\"\",\"\",ROUNDDOWN(H44*M44,0))","v":""}]
[null,null,null,null,null,"２人目",null,{"$f":"U8","v":""},null,null,null,"×",2.8000000000000001E-2,null,null,"＝",{"$f":"IF(H45=\"\",\"\",ROUNDDOWN(H45*M45,0))","v":""},null,null,null,null,"合計所得割額"]
[null,null,null,null,null,"３人目",null,{"$f":"U9","v":""},null,null,null,"×",2.8000000000000001E-2,null,null,"＝",{"$f":"IF(H46=\"\",\"\",ROUNDDOWN(H46*M46,0))","v":""},null,null,null,null,{"$f":"IF(AND(Q44=\"\",Q45=\"\",Q46=\"\",Q47=\"\",Q48=\"\"),\"\",SUM(Q44:T48))","v":""},null,null,null,"③"]
[null,null,null,null,null,"４人目",null,{"$f":"U10","v":""},null,null,null,"×",2.8000000000000001E-2,null,null,"＝",{"$f":"IF(H47=\"\",\"\",ROUNDDOWN(H47*M47,0))","v":""}]
[null,null,null,null,null,"５人目",null,{"$f":"U11","v":""},null,null,null,"×",2.8000000000000001E-2,null,null,"＝",{"$f":"IF(H48=\"\",\"\",ROUNDDOWN(H48*M48,0))","v":""}]
[]
[null,null,null,null,null,null,null,"加入者数",null,null,null,null,null,null,null,null,"１人当たりの均等割額"]
[null,null,null,"均等割",null,null,null,{"$f":"H32","v":""},null,null,"人","×",null,null,null,null,13500,null,null,"円","＝",{"$f":"IF(AND(H51=\"\"),\"\",H51*Q51)","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,"＝",{"$f":"IF(AND(V46=\"\",V51=\"\"),\"\",ROUNDDOWN(MIN(V46+V51,260000),-2))","v":""},null,null,null,"Ｂ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は26万円です）"]
[]
[null,null,"【介護納付金分】　40歳～64歳の方に課税されます。"]
[]
[null,null,null,null,null,null,null,"課税所得額",null,null,null,null,"税　率",null,null,null,"所得割額"]
[null,null,null,"所得割",null,"１人目",null,{"$f":"IF(H7=\"\",\"\",IF(OR(H7<40,H7>=65),0,IF(AND(H7>=40,H7<=64),U7)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝",{"$f":"IF(H60=\"\",\"\",ROUNDDOWN(H60*M60,0))","v":""}]
[null,null,null,null,null,"２人目",null,{"$f":"IF(H8=\"\",\"\",IF(OR(H8<40,H8>=65),0,IF(AND(H8>=40,H8<=64),U8)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝",{"$f":"IF(H61=\"\",\"\",ROUNDDOWN(H61*M61,0))","v":""},null,null,null,null,"合計所得割額"]
[null,null,null,null,null,"３人目",null,{"$f":"IF(H9=\"\",\"\",IF(OR(H9<40,H9>=65),0,IF(AND(H9>=40,H9<=64),U9)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝","",null,null,null,null,{"$f":"IF(AND(Q60=\"\",Q61=\"\",Q62=\"\",Q63=\"\",Q64=\"\"),\"\",SUM(Q60:T64))","v":""},null,null,null,"⑤"]
[null,null,null,null,null,"４人目",null,{"$f":"IF(H10=\"\",\"\",IF(OR(H10<40,H10>=65),0,IF(AND(H10>=40,H10<=64),U10)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝",""]
[null,null,null,null,null,"５人目",null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11<40,H11>=65),0,IF(AND(H11>=40,H11<=64),U11)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝",{"$f":"IF(H64=\"\",\"\",ROUNDDOWN(H64*M64,0))","v":""}]
[]
[null,null,null,null,null,null,null,"加入者数",null,null,null,null,null,null,null,null,"１人当たりの均等割額"]
[null,null,null,"均等割",null,null,null,{"$f":"IF(AND(H7=\"\",H8=\"\",H9=\"\",H10=\"\",H11=\"\"),\"\",COUNTIFS(H7:H11,\">39\",H7:H11,\"<65\"))","v":""},null,null,"人","×",null,null,null,null,16100,null,null,"円","＝",{"$f":"IF(AND(H67=\"\"),\"\",H67*Q67)","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,"＝",{"$f":"IF(AND(V62=\"\",V67=\"\"),\"\",ROUNDDOWN(MIN(V62+V67,170000),-2))","v":""},null,null,null,"Ｃ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は17万円です）"]
[null,null,"【子ども・子育て支援納付金分】　"]
[]
[null,null,null,null,null,null,null,"課税所得額",null,null,null,null,"税　率",null,null,null,"所得割額"]
[null,null,null,"所得割",null,"１人目",null,{"$f":"U7","v":""},null,null,null,"×",2.5999999999999999E-3,null,null,"＝",{"$f":"IF(H75=\"\",\"\",ROUNDDOWN(H75*M75,0))","v":""}]
[null,null,null,null,null,"２人目",null,{"$f":"U8","v":""},null,null,null,"×",2.5999999999999999E-3,null,null,"＝",{"$f":"IF(H76=\"\",\"\",ROUNDDOWN(H76*M76,0))","v":""},null,null,null,null,"合計所得割額"]
[null,null,null,null,null,"３人目",null,"",null,null,null,"×",2.5999999999999999E-3,null,null,"＝","",null,null,null,null,{"$f":"IF(AND(Q75=\"\",Q76=\"\",Q77=\"\",Q78=\"\",Q79=\"\"),\"\",SUM(Q75:T79))","v":""},null,null,null,"⑦"]
[null,null,null,null,null,"４人目",null,"",null,null,null,"×",2.5999999999999999E-3,null,null,"＝",""]
[null,null,null,null,null,"５人目",null,{"$f":"U11","v":""},null,null,null,"×",2.5999999999999999E-3,null,null,"＝",{"$f":"IF(H79=\"\",\"\",ROUNDDOWN(H79*M79,0))","v":""}]
[]
[null,null,null,null,null,null,null,"18歳以上加入者数",null,null,null,null,null,null,null,null,"１人当たりの均等割額"]
[null,null,null,"均等割",null,null,null,{"$f":"IF(AND(H7=\"\",H8=\"\",H9=\"\",H10=\"\",H11=\"\"),\"\",COUNTIFS(H7:I11,\">=18\"))","v":""},null,null,"人","×",null,null,null,null,1500,null,null,"円","＝",{"$f":"IF(AND(H82=\"\"),\"\",H82*Q82)","v":""},null,null,null,"⑧"]
[]
[null,null,null,null,null,null,null,"１８歳以上加入者数",null,null,null,null,null,null,"１人当たりの１８歳以上均等割額"]
[null,null,null,"18歳以上\n均等割",null,null,null,{"$f":"H82","v":""},null,null,"人","×",null,null,null,null,100,null,null,"円","＝",{"$f":"IF(AND(H85=\"\"),\"\",H85*Q85)","v":""},null,null,null,"⑨"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑦＋⑧＋⑨",null,null,null,"＝",{"$f":"IF(AND(V77=\"\",V82=\"\",V85=\"\"),\"\",ROUNDDOWN(MIN(V77+V82+V85,30000),-2))","v":""},null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は3万円です）"]
[]
[null,null,"※１００円未満の端数がある場合は切捨てとなります。"]
[]
[null,null,null,"令和８年度国民健康保険税の年税額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＝",{"$f":"IF(AND(V38=\"\",V54=\"\",V70=\"\",V87=\"\"),\"\",SUM(V38,V54,V70,V87))","v":""},null,null,null,"円"]
[]
[null,null,null,"Ａ（医療分合計）＋Ｂ（後期支援分合計）＋Ｃ（介護分合計）＋D（子ども・子育て支援分）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"１ヶ月あたりの税額（年税額÷12ヶ月）＝",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V92=\"\"),\"\",ROUNDDOWN(V92/12,0))","v":""},null,null,null,"円"]