{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["簡易試算表"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":82,"n_cols":26,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,2,1,26],[3,4,3,26],[5,2,5,6],[6,7,6,8],[6,9,6,13],[6,15,6,17],[6,20,6,23],[5,7,5,27],[0,1,0,27],[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],[10,5,10,6],[10,7,10,8],[10,9,10,13],[10,15,10,17],[10,20,10,23],[20,21,20,24],[21,5,21,6],[21,7,21,10],[21,12,21,14],[21,16,21,19],[21,21,21,24],[13,2,14,26],[16,2,16,26],[18,7,18,10],[18,12,18,14],[18,16,18,19],[19,5,19,6],[19,7,19,10],[19,12,19,14],[19,16,19,19],[28,16,29,19],[22,5,22,6],[22,7,22,10],[22,12,22,14],[22,16,22,19],[25,6,25,11],[25,12,25,14],[23,16,23,19],[20,5,20,6],[20,7,20,10],[20,12,20,14],[20,16,20,19],[39,7,39,12],[39,13,39,15],[39,21,39,24],[40,16,40,19],[40,21,40,24],[31,7,31,9],[31,16,31,19],[32,3,32,4],[32,7,32,9],[32,16,32,18],[32,21,32,24],[34,3,37,4],[35,21,36,24],[35,20,36,20],[34,6,37,19],[41,15,41,24],[43,2,43,26],[45,7,45,10],[45,12,45,14],[45,16,45,19],[46,5,46,6],[46,7,46,10],[46,12,46,14],[46,16,46,19],[50,16,50,19],[47,5,47,6],[47,7,47,10],[47,12,47,14],[47,16,47,19],[47,21,47,24],[48,5,48,6],[48,7,48,10],[48,12,48,14],[48,16,48,19],[48,21,48,24],[76,3,77,19],[76,20,78,20],[76,21,78,24],[76,25,78,25],[78,3,78,19],[69,3,69,4],[69,7,69,9],[69,16,69,18],[69,21,69,24],[71,21,71,24],[72,16,72,19],[72,21,72,24],[64,21,64,24],[11,5,11,6],[11,7,11,8],[11,9,11,13],[11,20,11,23],[11,15,11,17],[23,12,23,14],[73,16,73,24],[74,2,74,26],[65,5,65,6],[65,7,65,10],[65,12,65,14],[65,16,65,19],[55,21,55,24],[56,16,56,19],[56,21,56,24],[49,5,49,6],[49,7,49,10],[49,12,49,14],[49,16,49,19],[52,16,52,19],[50,5,50,6],[50,7,50,10],[50,12,50,14],[53,16,53,18],[53,21,53,24],[27,25,28,25],[26,7,27,10],[28,7,29,10],[26,12,27,14],[28,12,29,14],[81,21,81,24],[23,5,23,6],[23,7,23,10],[68,16,68,19],[66,5,66,6],[66,7,66,10],[66,12,66,14],[66,16,66,19],[63,5,63,6],[63,7,63,10],[63,12,63,14],[63,16,63,19],[63,21,63,24],[64,5,64,6],[64,7,64,10],[64,12,64,14],[64,16,64,19],[35,25,36,25],[81,10,81,20],[68,7,68,9],[26,5,27,6],[28,5,29,6],[26,3,29,4],[19,3,23,4],[46,3,50,4],[52,7,52,9],[26,16,27,19],[27,21,28,24],[25,21,26,24],[57,16,57,24],[59,2,59,26],[61,7,61,10],[61,12,61,14],[61,16,61,19],[62,3,65,4],[62,5,62,6],[62,7,62,10],[62,12,62,14],[62,16,62,19],[53,3,53,4],[53,7,53,9]]}
[null,"令和５年度 北本市国民健康保険税簡易試算表"]
[null,null,"　年間（4月から翌年3月まで）の国民健康保険税の試算ができます。目安としてご利用ください。\n　この試算表は、あくまで概算です。 実際の税額と異なる場合があります。\n　なお、この試算表は、月割計算、軽減制度には対応していません。\n　詳しくお知りになりたい方は、保険年金課 国民健康保険担当までお問い合わせください。"]
[]
[null,null,null,null,"の部分を入力してください。"]
[]
[null,null,"◆ 課税所得額",null,null,null,null,"　あなたの世帯の国保加入者全員のそれぞれの令和４年中の所得を入力してください。"]
[null,null,null,null,null,null,null,"年齢",null,"令和４年中の所得金額",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(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,"－",430000,null,null,"円","＝",{"$f":"IF(J12=\"\",\"\",IF(J12-P12<0,0,J12-P12))","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":"U8","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H20=\"\",\"\",ROUNDDOWN(H20*M20,0))","v":""}]
[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,"合計所得割額"]
[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,{"$f":"IF(AND(Q20=\"\",Q21=\"\",Q22=\"\",Q23=\"\",Q24=\"\"),\"\",SUM(Q20:T24))","v":""},null,null,null,"①"]
[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,{"$f":"U12","v":""},null,null,null,"×",7.2999999999999995E-2,null,null,"＝",{"$f":"IF(H24=\"\",\"\",ROUNDDOWN(H24*M24,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(H8=\"\",H9=\"\",H10=\"\",H11=\"\",H12=\"\"),\"\",COUNT(H8:I12))","v":""},null,null,"人","×",null,null,null,null,29900,null,null,"円","＝",{"$f":"IF(AND(H33=\"\"),\"\",H33*Q33)","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(V22=\"\",V33=\"\"),\"\",ROUNDDOWN(MIN(V22+V33,650000),-2))","v":""},null,null,null,"Ａ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は65万円です）"]
[]
[null,null,"【後期高齢者支援金分】"]
[]
[null,null,null,null,null,null,null,"課税所得額",null,null,null,null,"税　率",null,null,null,"所得割額"]
[null,null,null,"所得割",null,"１人目",null,{"$f":"U8","v":""},null,null,null,"×",2.9000000000000001E-2,null,null,"＝",{"$f":"IF(H47=\"\",\"\",ROUNDDOWN(H47*M47,0))","v":""}]
[null,null,null,null,null,"２人目",null,{"$f":"U9","v":""},null,null,null,"×",2.9000000000000001E-2,null,null,"＝",{"$f":"IF(H48=\"\",\"\",ROUNDDOWN(H48*M48,0))","v":""},null,null,null,null,"合計所得割額"]
[null,null,null,null,null,"３人目",null,{"$f":"U10","v":""},null,null,null,"×",2.9000000000000001E-2,null,null,"＝","",null,null,null,null,{"$f":"IF(AND(Q47=\"\",Q48=\"\",Q49=\"\",Q50=\"\",Q51=\"\"),\"\",SUM(Q47:T51))","v":""},null,null,null,"⑤"]
[null,null,null,null,null,"４人目",null,{"$f":"U11","v":""},null,null,null,"×",2.9000000000000001E-2,null,null,"＝",""]
[null,null,null,null,null,"５人目",null,{"$f":"U12","v":""},null,null,null,"×",2.9000000000000001E-2,null,null,"＝",{"$f":"IF(H51=\"\",\"\",ROUNDDOWN(H51*M51,0))","v":""}]
[]
[null,null,null,null,null,null,null,"加入者数",null,null,null,null,null,null,null,null,"１人当たりの均等割額"]
[null,null,null,"均等割",null,null,null,{"$f":"H33","v":""},null,null,"人","×",null,null,null,null,10200,null,null,"円","＝",{"$f":"IF(AND(H54=\"\"),\"\",H54*Q54)","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(V49=\"\",V54=\"\"),\"\",ROUNDDOWN(MIN(V49+V54,200000),-2))","v":""},null,null,null,"Ｂ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１年間の最高限度額は20万円です）"]
[]
[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(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(H63=\"\",\"\",ROUNDDOWN(H63*M63,0))","v":""}]
[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,"＝",{"$f":"IF(H64=\"\",\"\",ROUNDDOWN(H64*M64,0))","v":""},null,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,{"$f":"IF(AND(Q63=\"\",Q64=\"\",Q65=\"\",Q66=\"\",Q67=\"\"),\"\",SUM(Q63:T67))","v":""},null,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,"＝",""]
[null,null,null,null,null,"５人目",null,{"$f":"IF(H12=\"\",\"\",IF(OR(H12<40,H12>=65),0,IF(AND(H12>=40,H12<=64),U12)))","v":""},null,null,null,"×",2.1999999999999999E-2,null,null,"＝",{"$f":"IF(H67=\"\",\"\",ROUNDDOWN(H67*M67,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(H8=\"\",H9=\"\",H10=\"\",H11=\"\",H12=\"\"),\"\",COUNTIFS(H8:H12,\">39\",H8:H12,\"<65\"))","v":""},null,null,"人","×",null,null,null,null,14700,null,null,"円","＝",{"$f":"IF(AND(H70=\"\"),\"\",H70*Q70)","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(V65=\"\",V70=\"\"),\"\",ROUNDDOWN(MIN(V65+V70,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":"IF(AND(V41=\"\",V57=\"\",V73=\"\"),\"\",SUM(V41,V57,V73))","v":""},null,null,null,"円"]
[]
[null,null,null,"Ａ（医療分合計）＋Ｂ（支援分合計）＋Ｃ（介護分合計）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"１ヶ月あたりの税額（年税額÷12ヶ月）＝",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V77=\"\"),\"\",ROUNDDOWN(V77/12,0))","v":""},null,null,null,"円"]