{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["試算"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"試算","index":0,"n_rows":163,"n_cols":25,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"世帯人数",2,"人"]
[]
[null,"■企業年金(800万円)を65～79歳の20年間で年金として受け取った場合（年金の運用は考慮していない）"]
[]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044]
[null,null,null,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79]
[]
[null,"収入","事業(営業等)"]
[null,null,"事業(農業)"]
[null,null,"不動産"]
[null,null,"配当"]
[null,null,"給与",6500000,4500000,4500000,4500000,4500000,4500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"雑収入(国民年金)",null,null,null,null,null,null,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000]
[null,null,"雑収入(厚生年金)"]
[null,null,"雑収入(企業年金)",null,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000]
[null,null,"雑収入(業務)"]
[null,null,"雑収入(その他)"]
[null,null,"総合譲渡(短期)"]
[null,null,"総合譲渡(長期)"]
[null,null,"一時"]
[null,null,"年収合計",{"$f":"SUM(D10:D22)","v":6500000},4900000,4900000,4900000,4900000,4900000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000,2300000]
[]
[null,"控除","給与所得控除",{"$f":"KYUYO_SHOTOKU_KOUJO(D14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(E14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(F14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(G14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(H14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(I14)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(J14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(K14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(L14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(M14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(N14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(O14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(P14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(Q14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(R14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(S14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(T14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(U14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(V14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(W14)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(X14)","v":0}]
[null,null,"公的年金控除",{"$f":"SUM(D15:D17)-D35","v":0},400000,400000,400000,400000,400000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000]
[null,null,"雑収入(業務)経費"]
[null,null,"その他控除"]
[]
[null,"所得","事業(営業等)"]
[null,null,"事業(農業)"]
[null,null,"不動産"]
[null,null,"配当"]
[null,null,"給与",{"$f":"D14-D25","v":6060000},4060000,4060000,4060000,4060000,4060000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"雑所得(公的年金等)",{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(D15:D17),D30+D37,D8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(E15:E17),E30+E37,E8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(F15:F17),F30+F37,F8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(G15:G17),G30+G37,G8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(H15:H17),H30+H37,H8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(I15:I17),I30+I37,I8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(J15:J17),J30+J37,J8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(K15:K17),K30+K37,K8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(L15:L17),L30+L37,L8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(M15:M17),M30+M37,M8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(N15:N17),N30+N37,N8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(O15:O17),O30+O37,O8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(P15:P17),P30+P37,P8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(Q15:Q17),Q30+Q37,Q8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(R15:R17),R30+R37,R8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(S15:S17),S30+S37,S8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(T15:T17),T30+T37,T8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(U15:U17),U30+U37,U8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(V15:V17),V30+V37,V8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(W15:W17),W30+W37,W8)","v":1450000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(X15:X17),X30+X37,X8)","v":1450000}]
[null,null,"雑所得(業務)"]
[null,null,"雑所得(その他)",{"$f":"MAX(0,D18-D27-D28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"総合譲渡・一時",{"$f":"D20+(D21+D22)/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"所得合計",{"$f":"SUM(D30:D38)","v":6060000},4060000,4060000,4060000,4060000,4060000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000,1450000]
[]
[null,"配偶者","配偶者収入(給与)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者収入(年金)",0,0,0,0,0,0,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000]
[null,null,"配偶者社会保険料",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者所得(給与)",{"$f":"D41-KYUYO_SHOTOKU_KOUJO(D41)","v":0},{"$f":"E41-KYUYO_SHOTOKU_KOUJO(E41)","v":0},{"$f":"F41-KYUYO_SHOTOKU_KOUJO(F41)","v":0},{"$f":"G41-KYUYO_SHOTOKU_KOUJO(G41)","v":0},{"$f":"H41-KYUYO_SHOTOKU_KOUJO(H41)","v":0},{"$f":"I41-KYUYO_SHOTOKU_KOUJO(I41)","v":0},{"$f":"J41-KYUYO_SHOTOKU_KOUJO(J41)","v":0},{"$f":"K41-KYUYO_SHOTOKU_KOUJO(K41)","v":0},{"$f":"L41-KYUYO_SHOTOKU_KOUJO(L41)","v":0},{"$f":"M41-KYUYO_SHOTOKU_KOUJO(M41)","v":0},{"$f":"N41-KYUYO_SHOTOKU_KOUJO(N41)","v":0},{"$f":"O41-KYUYO_SHOTOKU_KOUJO(O41)","v":0},{"$f":"P41-KYUYO_SHOTOKU_KOUJO(P41)","v":0},{"$f":"Q41-KYUYO_SHOTOKU_KOUJO(Q41)","v":0},{"$f":"R41-KYUYO_SHOTOKU_KOUJO(R41)","v":0},{"$f":"S41-KYUYO_SHOTOKU_KOUJO(S41)","v":0},{"$f":"T41-KYUYO_SHOTOKU_KOUJO(T41)","v":0},{"$f":"U41-KYUYO_SHOTOKU_KOUJO(U41)","v":0},{"$f":"V41-KYUYO_SHOTOKU_KOUJO(V41)","v":0},{"$f":"W41-KYUYO_SHOTOKU_KOUJO(W41)","v":0},{"$f":"X41-KYUYO_SHOTOKU_KOUJO(X41)","v":0}]
[null,null,"配偶者所得(年金)",{"$f":"KOUTEKI_NENKIN_SHOTOKU(D42,D42,D8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(E42,E42,E8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(F42,F42,F8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(G42,G42,G8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(H42,H42,H8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(I42,I42,I8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(J42,J42,J8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(K42,K42,K8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(L42,L42,L8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(M42,M42,M8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(N42,N42,N8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(O42,O42,O8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(P42,P42,P8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(Q42,Q42,Q8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(R42,R42,R8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(S42,S42,S8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(T42,T42,T8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(U42,U42,U8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(V42,V42,V8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(W42,W42,W8)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(X42,X42,X8)","v":0}]
[null,null,"配偶者所得(合計)",{"$f":"SUM(D44:D45)","v":0},{"$f":"SUM(E44:E45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者前年住民税",{"$f":"D46*0.1","v":0},{"$f":"E46*0.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"その他","医療費"]
[null,null,"ふるさと納税"]
[]
[null,"所得","社会保険料控除(企業健康保険)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E52:X52)","v":0}]
[null,"控除","社会保険料控除(国民健康保険)",null,{"$f":"KOKUMIN_KENKOU_HOKEN(D39,$D$2,E8)","v":843703},{"$f":"KOKUMIN_KENKOU_HOKEN(E39,$D$2,F8)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(F39,$D$2,G8)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(G39,$D$2,H8)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(H39,$D$2,I8)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(I39,$D$2,J8)","v":501576},{"$f":"KOKUMIN_KENKOU_HOKEN(J39,$D$2,K8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(K39,$D$2,L8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(L39,$D$2,M8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(M39,$D$2,N8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(N39,$D$2,O8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(O39,$D$2,P8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(P39,$D$2,Q8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(Q39,$D$2,R8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(R39,$D$2,S8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(S39,$D$2,T8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(T39,$D$2,U8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(U39,$D$2,V8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(V39,$D$2,W8)","v":223611},{"$f":"KOKUMIN_KENKOU_HOKEN(W39,$D$2,X8)","v":223611},{"$f":"SUM(E53:X53)","v":6846645}]
[null,null,"社会保険料控除(介護保険)",null,{"$f":"KAIGO_HOKEN(E39,E8,D75,D47)","v":0},{"$f":"KAIGO_HOKEN(F39,F8,E75,E47)","v":0},{"$f":"KAIGO_HOKEN(G39,G8,F75,F47)","v":0},{"$f":"KAIGO_HOKEN(H39,H8,G75,G47)","v":0},{"$f":"KAIGO_HOKEN(I39,I8,H75,H47)","v":0},{"$f":"KAIGO_HOKEN(J39,J8,I75,I47)","v":96000},{"$f":"KAIGO_HOKEN(K39,K8,J75,J47)","v":52608},{"$f":"KAIGO_HOKEN(L39,L8,K75,K47)","v":96000},{"$f":"KAIGO_HOKEN(M39,M8,L75,L47)","v":96000},{"$f":"KAIGO_HOKEN(N39,N8,M75,M47)","v":96000},{"$f":"KAIGO_HOKEN(O39,O8,N75,N47)","v":96000},{"$f":"KAIGO_HOKEN(P39,P8,O75,O47)","v":96000},{"$f":"KAIGO_HOKEN(Q39,Q8,P75,P47)","v":96000},{"$f":"KAIGO_HOKEN(R39,R8,Q75,Q47)","v":96000},{"$f":"KAIGO_HOKEN(S39,S8,R75,R47)","v":96000},{"$f":"KAIGO_HOKEN(T39,T8,S75,S47)","v":96000},{"$f":"KAIGO_HOKEN(U39,U8,T75,T47)","v":96000},{"$f":"KAIGO_HOKEN(V39,V8,U75,U47)","v":96000},{"$f":"KAIGO_HOKEN(W39,W8,V75,V47)","v":96000},{"$f":"KAIGO_HOKEN(X39,X8,W75,W47)","v":96000},1396608]
[null,null,"その他社会保険料控除"]
[null,null,"小規模企業共済等掛金控除"]
[null,null,"生命保険料控除"]
[null,null,"地震保険料控除"]
[null,null,"寡婦､ ひとり親控除"]
[null,null,"勤労学生、障害者控除"]
[null,null,"配偶者控除",{"$f":"HAIGUSHA_KOUJO(D39,D8)","v":380000},{"$f":"HAIGUSHA_KOUJO(E39,E8)","v":380000},{"$f":"HAIGUSHA_KOUJO(F39,F8)","v":380000},{"$f":"HAIGUSHA_KOUJO(G39,G8)","v":380000},{"$f":"HAIGUSHA_KOUJO(H39,H8)","v":380000},{"$f":"HAIGUSHA_KOUJO(I39,I8)","v":380000},{"$f":"HAIGUSHA_KOUJO(J39,J8)","v":380000},{"$f":"HAIGUSHA_KOUJO(K39,K8)","v":380000},{"$f":"HAIGUSHA_KOUJO(L39,L8)","v":380000},{"$f":"HAIGUSHA_KOUJO(M39,M8)","v":380000},{"$f":"HAIGUSHA_KOUJO(N39,N8)","v":380000},{"$f":"HAIGUSHA_KOUJO(O39,O8)","v":480000},{"$f":"HAIGUSHA_KOUJO(P39,P8)","v":480000},{"$f":"HAIGUSHA_KOUJO(Q39,Q8)","v":480000},{"$f":"HAIGUSHA_KOUJO(R39,R8)","v":480000},{"$f":"HAIGUSHA_KOUJO(S39,S8)","v":480000},{"$f":"HAIGUSHA_KOUJO(T39,T8)","v":480000},{"$f":"HAIGUSHA_KOUJO(U39,U8)","v":480000},{"$f":"HAIGUSHA_KOUJO(V39,V8)","v":480000},{"$f":"HAIGUSHA_KOUJO(W39,W8)","v":480000},{"$f":"HAIGUSHA_KOUJO(X39,X8)","v":480000}]
[null,null,"配偶者特別控除",{"$f":"HAIGUSHA_TOKUBETU_KOUJO(D39,D46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(E39,E46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(F39,F46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(G39,G46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(H39,H46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(I39,I46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(J39,J46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(K39,K46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(L39,L46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(M39,M46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(N39,N46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(O39,O46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(P39,P46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(Q39,Q46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(R39,R46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(S39,S46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(T39,T46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(U39,U46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(V39,V46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(W39,W46)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(X39,X46)","v":0}]
[null,null,"扶養控除"]
[null,null,"基礎控除",{"$f":"KISO_KOUJO(D39)","v":480000},{"$f":"KISO_KOUJO(E39)","v":480000},{"$f":"KISO_KOUJO(F39)","v":480000},{"$f":"KISO_KOUJO(G39)","v":480000},{"$f":"KISO_KOUJO(H39)","v":480000},{"$f":"KISO_KOUJO(I39)","v":480000},{"$f":"KISO_KOUJO(J39)","v":480000},{"$f":"KISO_KOUJO(K39)","v":480000},{"$f":"KISO_KOUJO(L39)","v":480000},{"$f":"KISO_KOUJO(M39)","v":480000},{"$f":"KISO_KOUJO(N39)","v":480000},{"$f":"KISO_KOUJO(O39)","v":480000},{"$f":"KISO_KOUJO(P39)","v":480000},{"$f":"KISO_KOUJO(Q39)","v":480000},{"$f":"KISO_KOUJO(R39)","v":480000},{"$f":"KISO_KOUJO(S39)","v":480000},{"$f":"KISO_KOUJO(T39)","v":480000},{"$f":"KISO_KOUJO(U39)","v":480000},{"$f":"KISO_KOUJO(V39)","v":480000},{"$f":"KISO_KOUJO(W39)","v":480000},{"$f":"KISO_KOUJO(X39)","v":480000}]
[null,null,"雑損控除"]
[null,null,"医療費控除",{"$f":"IRYOUHI_KOUJO(D49,D39)","v":0},{"$f":"IRYOUHI_KOUJO(E49,E39)","v":0},{"$f":"IRYOUHI_KOUJO(F49,F39)","v":0},{"$f":"IRYOUHI_KOUJO(G49,G39)","v":0},{"$f":"IRYOUHI_KOUJO(H49,H39)","v":0},{"$f":"IRYOUHI_KOUJO(I49,I39)","v":0},{"$f":"IRYOUHI_KOUJO(J49,J39)","v":0},{"$f":"IRYOUHI_KOUJO(K49,K39)","v":0},{"$f":"IRYOUHI_KOUJO(L49,L39)","v":0},{"$f":"IRYOUHI_KOUJO(M49,M39)","v":0},{"$f":"IRYOUHI_KOUJO(N49,N39)","v":0},{"$f":"IRYOUHI_KOUJO(O49,O39)","v":0},{"$f":"IRYOUHI_KOUJO(P49,P39)","v":0},{"$f":"IRYOUHI_KOUJO(Q49,Q39)","v":0},{"$f":"IRYOUHI_KOUJO(R49,R39)","v":0},{"$f":"IRYOUHI_KOUJO(S49,S39)","v":0},{"$f":"IRYOUHI_KOUJO(T49,T39)","v":0},{"$f":"IRYOUHI_KOUJO(U49,U39)","v":0},{"$f":"IRYOUHI_KOUJO(V49,V39)","v":0},{"$f":"IRYOUHI_KOUJO(W49,W39)","v":0},{"$f":"IRYOUHI_KOUJO(X49,X39)","v":0}]
[null,null,"寄付金控除",{"$f":"MAX(D50-2000,0)","v":0},{"$f":"MAX(E50-2000,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"控除合計",{"$f":"SUM(D52:D67)","v":860000},1703703,1452703,1452703,1452703,1452703,1457576,1136219,1179611,1179611,1179611,1279611,1279611,1279611,1279611,1279611,1279611,1279611,1279611,1279611,1279611]
[]
[null,"課税対象","課税対象",{"$f":"ROUNDDOWN(MAX(D39-D68,0),-3)","v":5200000},2356000,2607000,2607000,2607000,2607000,0,313000,270000,270000,270000,170000,170000,170000,170000,170000,170000,170000,170000,170000,170000]
[]
[null,null,"定額減税",60000]
[]
[null,"税金","所得税",{"$f":"SHOTOKU_ZEI(D70,D7,D72)","v":564102},{"$f":"SHOTOKU_ZEI(E70,E7,E72)","v":141000},{"$f":"SHOTOKU_ZEI(F70,F7,F72)","v":166627},{"$f":"SHOTOKU_ZEI(G70,G7,G72)","v":166627},{"$f":"SHOTOKU_ZEI(H70,H7,H72)","v":166627},{"$f":"SHOTOKU_ZEI(I70,I7,I72)","v":166627},{"$f":"SHOTOKU_ZEI(J70,J7,J72)","v":0},{"$f":"SHOTOKU_ZEI(K70,K7,K72)","v":15978},{"$f":"SHOTOKU_ZEI(L70,L7,L72)","v":13783},{"$f":"SHOTOKU_ZEI(M70,M7,M72)","v":13783},{"$f":"SHOTOKU_ZEI(N70,N7,N72)","v":13783},{"$f":"SHOTOKU_ZEI(O70,O7,O72)","v":8678},{"$f":"SHOTOKU_ZEI(P70,P7,P72)","v":8678},{"$f":"SHOTOKU_ZEI(Q70,Q7,Q72)","v":8678},{"$f":"SHOTOKU_ZEI(R70,R7,R72)","v":8500},{"$f":"SHOTOKU_ZEI(S70,S7,S72)","v":8500},{"$f":"SHOTOKU_ZEI(T70,T7,T72)","v":8500},{"$f":"SHOTOKU_ZEI(U70,U7,U72)","v":8500},{"$f":"SHOTOKU_ZEI(V70,V7,V72)","v":8500},{"$f":"SHOTOKU_ZEI(W70,W7,W72)","v":8500},{"$f":"SHOTOKU_ZEI(X70,X7,X72)","v":8500},{"$f":"SUM(D74:X74)","v":1514471}]
[null,null,"住民税",{"$f":"D70*0.1","v":520000},235600,260700,260700,260700,260700,0,31300,27000,27000,27000,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,2080700]
[]
[]
[null,"■企業年金を一時金で受け取った場合（年金の運用は考慮していない）"]
[]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044]
[null,null,null,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79]
[]
[null,"収入","事業(営業等)"]
[null,null,"事業(農業)"]
[null,null,"不動産"]
[null,null,"配当"]
[null,null,"給与",6500000,4500000,4500000,4500000,4500000,4500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"雑収入(国民年金)",null,null,null,null,null,null,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000,1900000]
[null,null,"雑収入(厚生年金)"]
[null,null,"雑収入(企業年金)"]
[null,null,"雑収入(業務)"]
[null,null,"雑収入(その他)"]
[null,null,"総合譲渡(短期)"]
[null,null,"総合譲渡(長期)"]
[null,null,"一時"]
[null,null,"年収合計",{"$f":"SUM(D84:D96)","v":6500000},{"$f":"SUM(E84:E96)","v":4500000},{"$f":"SUM(F84:F96)","v":4500000},{"$f":"SUM(G84:G96)","v":4500000},{"$f":"SUM(H84:H96)","v":4500000},{"$f":"SUM(I84:I96)","v":4500000},{"$f":"SUM(J84:J96)","v":1900000},{"$f":"SUM(K84:K96)","v":1900000},{"$f":"SUM(L84:L96)","v":1900000},{"$f":"SUM(M84:M96)","v":1900000},{"$f":"SUM(N84:N96)","v":1900000},{"$f":"SUM(O84:O96)","v":1900000},{"$f":"SUM(P84:P96)","v":1900000},{"$f":"SUM(Q84:Q96)","v":1900000},{"$f":"SUM(R84:R96)","v":1900000},{"$f":"SUM(S84:S96)","v":1900000},{"$f":"SUM(T84:T96)","v":1900000},{"$f":"SUM(U84:U96)","v":1900000},{"$f":"SUM(V84:V96)","v":1900000},{"$f":"SUM(W84:W96)","v":1900000},{"$f":"SUM(X84:X96)","v":1900000}]
[]
[null,"控除","給与所得控除",{"$f":"KYUYO_SHOTOKU_KOUJO(D88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(E88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(F88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(G88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(H88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(I88)","v":440000},{"$f":"KYUYO_SHOTOKU_KOUJO(J88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(K88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(L88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(M88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(N88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(O88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(P88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(Q88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(R88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(S88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(T88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(U88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(V88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(W88)","v":0},{"$f":"KYUYO_SHOTOKU_KOUJO(X88)","v":0}]
[null,null,"公的年金控除",{"$f":"SUM(D89:D91)-D109","v":0},0,0,0,0,0,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000,750000]
[null,null,"雑収入(業務)経費"]
[null,null,"その他控除"]
[]
[null,"所得","事業(営業等)"]
[null,null,"事業(農業)"]
[null,null,"不動産"]
[null,null,"配当"]
[null,null,"給与",{"$f":"D88-D99","v":6060000},4060000,4060000,4060000,4060000,4060000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"雑所得(公的年金等)",{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(D89:D91),D104+D111,D82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(E89:E91),E104+E111,E82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(F89:F91),F104+F111,F82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(G89:G91),G104+G111,G82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(H89:H91),H104+H111,H82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(I89:I91),I104+I111,I82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(J89:J91),J104+J111,J82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(K89:K91),K104+K111,K82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(L89:L91),L104+L111,L82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(M89:M91),M104+M111,M82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(N89:N91),N104+N111,N82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(O89:O91),O104+O111,O82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(P89:P91),P104+P111,P82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(Q89:Q91),Q104+Q111,Q82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(R89:R91),R104+R111,R82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(S89:S91),S104+S111,S82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(T89:T91),T104+T111,T82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(U89:U91),U104+U111,U82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(V89:V91),V104+V111,V82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(W89:W91),W104+W111,W82)","v":1150000},{"$f":"KOUTEKI_NENKIN_SHOTOKU(SUM(X89:X91),X104+X111,X82)","v":1150000}]
[null,null,"雑所得(業務)"]
[null,null,"雑所得(その他)",{"$f":"MAX(0,D92-D101-D102)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"総合譲渡・一時",{"$f":"D94+(D95+D96)/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"所得合計",{"$f":"SUM(D104:D112)","v":6060000},{"$f":"SUM(E104:E112)","v":4060000},{"$f":"SUM(F104:F112)","v":4060000},{"$f":"SUM(G104:G112)","v":4060000},{"$f":"SUM(H104:H112)","v":4060000},{"$f":"SUM(I104:I112)","v":4060000},{"$f":"SUM(J104:J112)","v":1150000},{"$f":"SUM(K104:K112)","v":1150000},{"$f":"SUM(L104:L112)","v":1150000},{"$f":"SUM(M104:M112)","v":1150000},{"$f":"SUM(N104:N112)","v":1150000},{"$f":"SUM(O104:O112)","v":1150000},{"$f":"SUM(P104:P112)","v":1150000},{"$f":"SUM(Q104:Q112)","v":1150000},{"$f":"SUM(R104:R112)","v":1150000},{"$f":"SUM(S104:S112)","v":1150000},{"$f":"SUM(T104:T112)","v":1150000},{"$f":"SUM(U104:U112)","v":1150000},{"$f":"SUM(V104:V112)","v":1150000},{"$f":"SUM(W104:W112)","v":1150000},{"$f":"SUM(X104:X112)","v":1150000}]
[]
[null,"配偶者","配偶者収入(給与)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者収入(年金)",0,0,0,0,0,0,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000,800000]
[null,null,"配偶者社会保険料",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者所得(給与)",{"$f":"D115-KYUYO_SHOTOKU_KOUJO(D115)","v":0},{"$f":"E115-KYUYO_SHOTOKU_KOUJO(E115)","v":0},{"$f":"F115-KYUYO_SHOTOKU_KOUJO(F115)","v":0},{"$f":"G115-KYUYO_SHOTOKU_KOUJO(G115)","v":0},{"$f":"H115-KYUYO_SHOTOKU_KOUJO(H115)","v":0},{"$f":"I115-KYUYO_SHOTOKU_KOUJO(I115)","v":0},{"$f":"J115-KYUYO_SHOTOKU_KOUJO(J115)","v":0},{"$f":"K115-KYUYO_SHOTOKU_KOUJO(K115)","v":0},{"$f":"L115-KYUYO_SHOTOKU_KOUJO(L115)","v":0},{"$f":"M115-KYUYO_SHOTOKU_KOUJO(M115)","v":0},{"$f":"N115-KYUYO_SHOTOKU_KOUJO(N115)","v":0},{"$f":"O115-KYUYO_SHOTOKU_KOUJO(O115)","v":0},{"$f":"P115-KYUYO_SHOTOKU_KOUJO(P115)","v":0},{"$f":"Q115-KYUYO_SHOTOKU_KOUJO(Q115)","v":0},{"$f":"R115-KYUYO_SHOTOKU_KOUJO(R115)","v":0},{"$f":"S115-KYUYO_SHOTOKU_KOUJO(S115)","v":0},{"$f":"T115-KYUYO_SHOTOKU_KOUJO(T115)","v":0},{"$f":"U115-KYUYO_SHOTOKU_KOUJO(U115)","v":0},{"$f":"V115-KYUYO_SHOTOKU_KOUJO(V115)","v":0},{"$f":"W115-KYUYO_SHOTOKU_KOUJO(W115)","v":0},{"$f":"X115-KYUYO_SHOTOKU_KOUJO(X115)","v":0}]
[null,null,"配偶者所得(年金)",{"$f":"KOUTEKI_NENKIN_SHOTOKU(D116,D116,D82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(E116,E116,E82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(F116,F116,F82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(G116,G116,G82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(H116,H116,H82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(I116,I116,I82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(J116,J116,J82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(K116,K116,K82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(L116,L116,L82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(M116,M116,M82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(N116,N116,N82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(O116,O116,O82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(P116,P116,P82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(Q116,Q116,Q82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(R116,R116,R82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(S116,S116,S82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(T116,T116,T82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(U116,U116,U82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(V116,V116,V82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(W116,W116,W82)","v":0},{"$f":"KOUTEKI_NENKIN_SHOTOKU(X116,X116,X82)","v":0}]
[null,null,"配偶者所得(合計)",{"$f":"SUM(D118:D119)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"配偶者前年住民税",{"$f":"D120*0.1","v":0},{"$f":"E120*0.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"その他","医療費"]
[null,null,"ふるさと納税"]
[]
[null,"所得","社会保険料控除(企業健康保険)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E126:X126)","v":0}]
[null,"控除","社会保険料控除(国民健康保険)",null,{"$f":"KOKUMIN_KENKOU_HOKEN(D113,$D$2,E82)","v":843703},{"$f":"KOKUMIN_KENKOU_HOKEN(E113,$D$2,F82)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(F113,$D$2,G82)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(G113,$D$2,H82)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(H113,$D$2,I82)","v":592703},{"$f":"KOKUMIN_KENKOU_HOKEN(I113,$D$2,J82)","v":501576},{"$f":"KOKUMIN_KENKOU_HOKEN(J113,$D$2,K82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(K113,$D$2,L82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(L113,$D$2,M82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(M113,$D$2,N82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(N113,$D$2,O82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(O113,$D$2,P82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(P113,$D$2,Q82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(Q113,$D$2,R82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(R113,$D$2,S82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(S113,$D$2,T82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(T113,$D$2,U82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(U113,$D$2,V82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(V113,$D$2,W82)","v":191661},{"$f":"KOKUMIN_KENKOU_HOKEN(W113,$D$2,X82)","v":191661},{"$f":"SUM(E127:X127)","v":6399345}]
[null,null,"社会保険料控除(介護保険)",null,{"$f":"KAIGO_HOKEN(E113,E82,D149,D121)","v":0},{"$f":"KAIGO_HOKEN(F113,F82,E149,E121)","v":0},{"$f":"KAIGO_HOKEN(G113,G82,F149,F121)","v":0},{"$f":"KAIGO_HOKEN(H113,H82,G149,G121)","v":0},{"$f":"KAIGO_HOKEN(I113,I82,H149,H121)","v":0},{"$f":"KAIGO_HOKEN(J113,J82,I149,I121)","v":84480},{"$f":"KAIGO_HOKEN(K113,K82,J149,J121)","v":37248},{"$f":"KAIGO_HOKEN(L113,L82,K149,K121)","v":84480},{"$f":"KAIGO_HOKEN(M113,M82,L149,L121)","v":84480},{"$f":"KAIGO_HOKEN(N113,N82,M149,M121)","v":84480},{"$f":"KAIGO_HOKEN(O113,O82,N149,N121)","v":84480},{"$f":"KAIGO_HOKEN(P113,P82,O149,O121)","v":37248},{"$f":"KAIGO_HOKEN(Q113,Q82,P149,P121)","v":37248},{"$f":"KAIGO_HOKEN(R113,R82,Q149,Q121)","v":37248},{"$f":"KAIGO_HOKEN(S113,S82,R149,R121)","v":37248},{"$f":"KAIGO_HOKEN(T113,T82,S149,S121)","v":37248},{"$f":"KAIGO_HOKEN(U113,U82,T149,T121)","v":37248},{"$f":"KAIGO_HOKEN(V113,V82,U149,U121)","v":37248},{"$f":"KAIGO_HOKEN(W113,W82,V149,V121)","v":37248},{"$f":"KAIGO_HOKEN(X113,X82,W149,W121)","v":37248},794880]
[null,null,"その他社会保険料控除"]
[null,null,"小規模企業共済等掛金控除"]
[null,null,"生命保険料控除"]
[null,null,"地震保険料控除"]
[null,null,"寡婦､ ひとり親控除"]
[null,null,"勤労学生、障害者控除"]
[null,null,"配偶者控除",{"$f":"HAIGUSHA_KOUJO(D113,D82)","v":380000},{"$f":"HAIGUSHA_KOUJO(E113,E82)","v":380000},{"$f":"HAIGUSHA_KOUJO(F113,F82)","v":380000},{"$f":"HAIGUSHA_KOUJO(G113,G82)","v":380000},{"$f":"HAIGUSHA_KOUJO(H113,H82)","v":380000},{"$f":"HAIGUSHA_KOUJO(I113,I82)","v":380000},{"$f":"HAIGUSHA_KOUJO(J113,J82)","v":380000},{"$f":"HAIGUSHA_KOUJO(K113,K82)","v":380000},{"$f":"HAIGUSHA_KOUJO(L113,L82)","v":380000},{"$f":"HAIGUSHA_KOUJO(M113,M82)","v":380000},{"$f":"HAIGUSHA_KOUJO(N113,N82)","v":380000},{"$f":"HAIGUSHA_KOUJO(O113,O82)","v":480000},{"$f":"HAIGUSHA_KOUJO(P113,P82)","v":480000},{"$f":"HAIGUSHA_KOUJO(Q113,Q82)","v":480000},{"$f":"HAIGUSHA_KOUJO(R113,R82)","v":480000},{"$f":"HAIGUSHA_KOUJO(S113,S82)","v":480000},{"$f":"HAIGUSHA_KOUJO(T113,T82)","v":480000},{"$f":"HAIGUSHA_KOUJO(U113,U82)","v":480000},{"$f":"HAIGUSHA_KOUJO(V113,V82)","v":480000},{"$f":"HAIGUSHA_KOUJO(W113,W82)","v":480000},{"$f":"HAIGUSHA_KOUJO(X113,X82)","v":480000}]
[null,null,"配偶者特別控除",{"$f":"HAIGUSHA_TOKUBETU_KOUJO(D113,D120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(E113,E120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(F113,F120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(G113,G120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(H113,H120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(I113,I120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(J113,J120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(K113,K120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(L113,L120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(M113,M120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(N113,N120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(O113,O120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(P113,P120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(Q113,Q120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(R113,R120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(S113,S120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(T113,T120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(U113,U120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(V113,V120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(W113,W120)","v":0},{"$f":"HAIGUSHA_TOKUBETU_KOUJO(X113,X120)","v":0}]
[null,null,"扶養控除"]
[null,null,"基礎控除",{"$f":"KISO_KOUJO(D113)","v":480000},{"$f":"KISO_KOUJO(E113)","v":480000},{"$f":"KISO_KOUJO(F113)","v":480000},{"$f":"KISO_KOUJO(G113)","v":480000},{"$f":"KISO_KOUJO(H113)","v":480000},{"$f":"KISO_KOUJO(I113)","v":480000},{"$f":"KISO_KOUJO(J113)","v":480000},{"$f":"KISO_KOUJO(K113)","v":480000},{"$f":"KISO_KOUJO(L113)","v":480000},{"$f":"KISO_KOUJO(M113)","v":480000},{"$f":"KISO_KOUJO(N113)","v":480000},{"$f":"KISO_KOUJO(O113)","v":480000},{"$f":"KISO_KOUJO(P113)","v":480000},{"$f":"KISO_KOUJO(Q113)","v":480000},{"$f":"KISO_KOUJO(R113)","v":480000},{"$f":"KISO_KOUJO(S113)","v":480000},{"$f":"KISO_KOUJO(T113)","v":480000},{"$f":"KISO_KOUJO(U113)","v":480000},{"$f":"KISO_KOUJO(V113)","v":480000},{"$f":"KISO_KOUJO(W113)","v":480000},{"$f":"KISO_KOUJO(X113)","v":480000}]
[null,null,"雑損控除"]
[null,null,"医療費控除",{"$f":"IRYOUHI_KOUJO(D123,D113)","v":0},{"$f":"IRYOUHI_KOUJO(E123,E113)","v":0},{"$f":"IRYOUHI_KOUJO(F123,F113)","v":0},{"$f":"IRYOUHI_KOUJO(G123,G113)","v":0},{"$f":"IRYOUHI_KOUJO(H123,H113)","v":0},{"$f":"IRYOUHI_KOUJO(I123,I113)","v":0},{"$f":"IRYOUHI_KOUJO(J123,J113)","v":0},{"$f":"IRYOUHI_KOUJO(K123,K113)","v":0},{"$f":"IRYOUHI_KOUJO(L123,L113)","v":0},{"$f":"IRYOUHI_KOUJO(M123,M113)","v":0},{"$f":"IRYOUHI_KOUJO(N123,N113)","v":0},{"$f":"IRYOUHI_KOUJO(O123,O113)","v":0},{"$f":"IRYOUHI_KOUJO(P123,P113)","v":0},{"$f":"IRYOUHI_KOUJO(Q123,Q113)","v":0},{"$f":"IRYOUHI_KOUJO(R123,R113)","v":0},{"$f":"IRYOUHI_KOUJO(S123,S113)","v":0},{"$f":"IRYOUHI_KOUJO(T123,T113)","v":0},{"$f":"IRYOUHI_KOUJO(U123,U113)","v":0},{"$f":"IRYOUHI_KOUJO(V123,V113)","v":0},{"$f":"IRYOUHI_KOUJO(W123,W113)","v":0},{"$f":"IRYOUHI_KOUJO(X123,X113)","v":0}]
[null,null,"寄付金控除",{"$f":"MAX(D124-2000,0)","v":0},{"$f":"MAX(E124-2000,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"控除合計",{"$f":"SUM(D126:D141)","v":860000},{"$f":"SUM(E126:E141)","v":1703703},{"$f":"SUM(F126:F141)","v":1452703},{"$f":"SUM(G126:G141)","v":1452703},{"$f":"SUM(H126:H141)","v":1452703},{"$f":"SUM(I126:I141)","v":1452703},{"$f":"SUM(J126:J141)","v":1446056},{"$f":"SUM(K126:K141)","v":1088909},{"$f":"SUM(L126:L141)","v":1136141},{"$f":"SUM(M126:M141)","v":1136141},{"$f":"SUM(N126:N141)","v":1136141},{"$f":"SUM(O126:O141)","v":1236141},{"$f":"SUM(P126:P141)","v":1188909},{"$f":"SUM(Q126:Q141)","v":1188909},{"$f":"SUM(R126:R141)","v":1188909},{"$f":"SUM(S126:S141)","v":1188909},{"$f":"SUM(T126:T141)","v":1188909},{"$f":"SUM(U126:U141)","v":1188909},{"$f":"SUM(V126:V141)","v":1188909},{"$f":"SUM(W126:W141)","v":1188909},{"$f":"SUM(X126:X141)","v":1188909}]
[]
[null,"課税対象","課税対象",{"$f":"ROUNDDOWN(MAX(D113-D142,0),-3)","v":5200000},2356000,2607000,2607000,2607000,2607000,0,61000,13000,13000,13000,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"定額減税",60000]
[]
[null,"税金","所得税",{"$f":"SHOTOKU_ZEI(D144,D81,D146)","v":564102},{"$f":"SHOTOKU_ZEI(E144,E81,E146)","v":141000},{"$f":"SHOTOKU_ZEI(F144,F81,F146)","v":166627},{"$f":"SHOTOKU_ZEI(G144,G81,G146)","v":166627},{"$f":"SHOTOKU_ZEI(H144,H81,H146)","v":166627},{"$f":"SHOTOKU_ZEI(I144,I81,I146)","v":166627},{"$f":"SHOTOKU_ZEI(J144,J81,J146)","v":0},{"$f":"SHOTOKU_ZEI(K144,K81,K146)","v":3114},{"$f":"SHOTOKU_ZEI(L144,L81,L146)","v":663},{"$f":"SHOTOKU_ZEI(M144,M81,M146)","v":663},{"$f":"SHOTOKU_ZEI(N144,N81,N146)","v":663},{"$f":"SHOTOKU_ZEI(O144,O81,O146)","v":0},{"$f":"SHOTOKU_ZEI(P144,P81,P146)","v":0},{"$f":"SHOTOKU_ZEI(Q144,Q81,Q146)","v":0},{"$f":"SHOTOKU_ZEI(R144,R81,R146)","v":0},{"$f":"SHOTOKU_ZEI(S144,S81,S146)","v":0},{"$f":"SHOTOKU_ZEI(T144,T81,T146)","v":0},{"$f":"SHOTOKU_ZEI(U144,U81,U146)","v":0},{"$f":"SHOTOKU_ZEI(V144,V81,V146)","v":0},{"$f":"SHOTOKU_ZEI(W144,W81,W146)","v":0},{"$f":"SHOTOKU_ZEI(X144,X81,X146)","v":0},{"$f":"SUM(D148:X148)","v":1376713}]
[null,null,"住民税",{"$f":"D144*0.1","v":520000},235600,260700,260700,260700,260700,0,6100,1300,1300,1300,0,0,0,0,0,0,0,0,0,0,1808400]
[]
[]
[null,"■差額"]
[]
[null,null,"社会保険料控除(企業健康保険)",null,{"$f":"E52-E126","v":0},{"$f":"F52-F126","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E154:X154)","v":0}]
[null,null,"社会保険料控除(国民健康保険)",null,{"$f":"E53-E127","v":0},0,0,0,0,0,31950,31950,31950,31950,31950,31950,31950,31950,31950,31950,31950,31950,31950,31950,{"$f":"SUM(E155:X155)","v":447300}]
[null,null,"社会保険料控除(介護保険)",null,{"$f":"E54-E128","v":0},0,0,0,0,11520,15360,11520,11520,11520,11520,58752,58752,58752,58752,58752,58752,58752,58752,58752,601728]
[null,null,"所得税",null,{"$f":"E74-E148","v":0},{"$f":"F74-F148","v":0},0,0,0,0,12864,13120,13120,13120,8678,8678,8678,8500,8500,8500,8500,8500,8500,8500,137758]
[null,null,"住民税",null,{"$f":"E75-E149","v":0},0,0,0,0,0,25200,25700,25700,25700,17000,17000,17000,17000,17000,17000,17000,17000,17000,17000,272300]
[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":"SUM(Y154:Y158)","v":1459086}]
[]
[null,"※ 健康保険料、介護保険料は、2024年(令和6年)の広島県の数値を参考にしています。"]
[null,"※ 住民税は単純に、所得税の課税対象額に 10% をかけていますが、実際は多少異なります。"]
[null,"※ 計算式は誤入力などで誤っている可能性があります。あくまで参考程度に自己の責任の範囲で参照ください。"]