{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,6]]}
[]
[]
[null,"File tax return showing tax of $10,000",null,null,"Filed on April 15"]
[]
[null,null,"April","May","June","July","August","September","October","November","December","January","February"]
[null,"Penalties & Interest",null,{"$f":"C9*0.0111666666666667","v":111.666666666667},{"$f":"D9*0.0111666666666667","v":112.91361111111146},114.17447976851886,115.44942812593401,116.73861340667359,118.04219458971478,{"$f":"I9*0.0111666666666667","v":119.36030117291884},{"$f":"J9*0.0111666666666667","v":120.69315786934978},122.04089813222417,123.40368816136736]
[null,"Accrued",null,{"$f":"SUM(D6:D6)","v":111.666666666667},{"$f":"SUM(D7,E6)","v":224.58027777777846},{"$f":"SUM(E7,F6)","v":338.75475754629736},454.20418567223135,570.94279907890495,{"$f":"I6","v":118.04219458971478},237.40249576263363,{"$f":"SUM(J7,K6)","v":358.0956536319834},{"$f":"SUM(K7,L6)","v":480.13655176420758},{"$f":"SUM(L7,M6)","v":603.54023992557495}]
[null,"Assessed",10000,10000,10000,10000,10000,10000,10570.94,10570.94,10570.94,10570.94,10570.94]
[null,"Balance Due",10000,{"$f":"SUM(D7:D8)","v":10111.666666666668},{"$f":"SUM(E7:E8)","v":10224.580277777779},10338.754757546298,10454.204185672232,10570.942799078904,10688.982194589715,{"$f":"SUM(J7:J8)","v":10808.342495762634},{"$f":"SUM(K7:K8)","v":10929.035653631983},{"$f":"SUM(L7:L8)","v":11051.076551764208},{"$f":"SUM(M7:M8)","v":11174.480239925575}]
[]
[]
[]
[]
[]
[]
[null,"Tax assessed changes every 6 months."]
[null,"Tax accrued changes monthly"]
[null,"Balance is due total of assessed + accrued"]
[]
[null,"Tax is not assessed or totaled constantly.  It is periodical."]
[null,"Tax accrued is the total increase since the last assessment."]
[null,"Balance due is the total of accrued & assessed."]
[null,"For example, if the IRS assessed the total every 6 months, at the end of the 1st 6 mos., you would owe the tax plus the total accruals to date.  In 3 more months you would owe the assessed plus an additional 3 months of penalties & interest.  The accrued total will only show 3 months of penalties & interest, assessed will be the total from 3 monthws ago, and your balance due would be the total of them both. "]