{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Paystub Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Paystub Worksheet","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,3,1],[0,7,0,8],[0,10,0,11],[0,4,0,5]]}
["PAYSTUB COMPARISON",null,null,"Scenarios ->","In the Military",null,null,"Outside the Military, \nWith Pension",null,null,"Outside the Military, \nWithout Pension"]
["DIRECTIONS: 1) Enter assumptions, 2) Assess % income differences",null,null,null,"Monthly","Yearly",null,"Monthly","Yearly",null,"Monthly","Yearly"]
[null,null,null,"Income"]
["Assumptions",null,null,"Salary",{"$f":"B5","v":8333},{"$f":"E4*12","v":99996},null,{"$f":"I4/12","v":8333.3333333333339},{"$f":"B6","v":100000},null,{"$f":"L4/12","v":8333.3333333333339},{"$f":"B6","v":100000}]
["Monthly Salary in Military",8333,null,"BAS",{"$f":"B7","v":250},{"$f":"E5*12","v":3000}]
["Annual Salary outside Military",100000,null,"BAH",{"$f":"B8","v":1400},{"$f":"E6*12","v":16800}]
["Monthly BAS rate",250,null,"Pension",null,null,null,{"$f":"I7/12","v":4166.666666666667},{"$f":"B9","v":50000}]
["Monthly BAH rate",1400,null,"Total Income",{"$f":"SUM(E4:E6)","v":9983},{"$f":"SUM(F4:F6)","v":119796},null,{"$f":"SUM(H4:H7)","v":12500},{"$f":"SUM(I4:I7)","v":150000},null,{"$f":"SUM(K4:K7)","v":8333.3333333333339},{"$f":"SUM(L4:L7)","v":100000}]
["Annual Military Pension",50000]
["Federal Tax rate in the Military (%)",0.25,null,"Deductions"]
["Federal Tax rate Outside the Military (%)",0.25,null,"Federal Taxes",{"$f":"B10*E4","v":2083.25},{"$f":"E11*12","v":24999},null,{"$f":"H8*B11","v":3125},{"$f":"H11*12","v":37500},null,{"$f":"K8*B11","v":2083.3333333333335},{"$f":"K11*12","v":25000}]
["Social Security tax rate (%)",6.2E-2,null,"Social Security",{"$f":"B12*E4","v":516.64599999999996},{"$f":"E12*12","v":6199.7519999999995},null,{"$f":"B12*H8","v":775},{"$f":"H12*12","v":9300},null,{"$f":"B12*K8","v":516.66666666666674},{"$f":"K12*12","v":6200.0000000000009}]
["Medicare Tax rate (%)",1.4500000000000001E-2,null,"Medicare",{"$f":"B13*E4","v":120.82850000000001},{"$f":"E13*12","v":1449.942},null,{"$f":"B13*H8","v":181.25},{"$f":"H13*12","v":2175},null,{"$f":"B13*K8","v":120.83333333333334},{"$f":"K13*12","v":1450}]
["State Tax rate in the Military (%)",0.06,null,"State Taxes",{"$f":"IF(B18=\"Yes\",E4*B14,0)","v":499.97999999999996},{"$f":"E14*12","v":5999.7599999999993},null,{"$f":"I14/12","v":750},{"$f":"IF(B20=\"Yes\",B15*I8,B15*I4)","v":9000},null,{"$f":"L14/12","v":500},{"$f":"B15*L8","v":6000}]
["State Tax rate Outside the Military (%)",0.06,null,"Local Taxes",{"$f":"IF(B19=\"Yes\",B16*E4,0)","v":0},{"$f":"E15*12","v":0},null,{"$f":"I15/12","v":250},{"$f":"IF(B21=\"Yes\",B17*I8,B17*I4)","v":3000},null,{"$f":"L15/12","v":166.66666666666666},{"$f":"B17*L8","v":2000}]
["Local Tax rate in the Military (%)",0.02,null,"Total Deductions",{"$f":"SUM(E11:E15)","v":3220.7044999999998},{"$f":"SUM(F11:F15)","v":38648.453999999998},null,{"$f":"SUM(H11:H15)","v":5081.25},{"$f":"SUM(I11:I15)","v":60975},null,{"$f":"SUM(K11:K15)","v":3387.5},{"$f":"SUM(L11:L15)","v":40650}]
["Local Tax rate Outside the Military (%)",0.02]
["Military Salary Taxed by State?","Yes",null,"After-Tax Income",{"$f":"E8-E16","v":6762.2955000000002},{"$f":"F8-F16","v":81147.546000000002},null,{"$f":"H8-H16","v":7418.75},{"$f":"I8-I16","v":89025},null,{"$f":"K8-K16","v":4945.8333333333339},{"$f":"L8-L16","v":59350}]
["Military Salary Taxed by Local?","No"]
["Military Pension Taxed by State?","Yes",null,null,null,null,null,"% decrease in after-tax income from being 'In the Military'",{"$f":"(F18-I18)/F18","v":-9.7075689756533093E-2},null,null,{"$f":"(F18-L18)/F18","v":0.26861620682897797}]
["Military Pension Taxed by Local?","Yes",null,null,null,null,null,"Increase required to sustain 'In the Military' after-tax income",{"$f":"(F18-I18)/I18","v":-8.8485863521482702E-2},null,null,{"$f":"(F18-L18)/L18","v":0.36727120471777597}]