Loading...
HomeMy WebLinkAboutEx 25 Spreadsheet accompanying T Crisp 3.18.21 letter.xlsPeriod of Adjustments: Firm Name: Business Address: Classes UTILITY TAX Rounding Corrected Tax Reported Tax DEBIT/(CREDIT) Date: REMARKS: \Q 2007 6968.5 6968.5 6968.5 2008 10813.23 10813.23 10813.23 2009 14793.84 14793.84 14793.84 January 01, 2007 through May 31, 2013 Tracfone Wireless Tax Department 9700 NW 112th Avenue Miami, FL 33178 Nicholas Ford, Sr. Tax Manager 2010 25547.25 25547.25 25547.25 Audit submitted by: Michael J. Crisp YEAR 2007 2008 2009 2010 2011 2012 2013 Total Interest Dr(Cr): Total Tax (Shown Above) DR/(CR) Total Penalty (Per Calc Sheet) Dr./(Cr.) Total Due Extensions Reviewer Code Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 Nov.1/14 City of Renton, Washington Department of Finance Field Auditor's Report SUMMARY SHEET 2011 27113.65 27113.65 27113.65 \N 2012 29165.3 29165.3 29165.3 Dr. Noted Cr. Noted Classif. 2013 12299.47 12299.47 12299.47 Date Date Hours Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 Oct.15/31 2014 YEARLY INTEREST DR/(CR) 7024.25 10633.41 12869.73 19073.02 17122.82 14842.39 5244.4 2015 Registration T O T A L 126701.24 -0.03 126701.24 0 126701.21 TOTALS 86810.02 126701.21 31675.46 245186.69 -6888.91 474328.44 \M VERY IMPORTANT: = 147259.04 0.14 Now 86810.02 126701.21 31675.46 245186.69 326145.06 0.330190721201057 last1 \o PRINT5 PRINT4 PRINTL4 PRINT3 PRINTL3 PRINT2 PRINTL2 PRINT1 PRINTL1 ===== Code - ALL5 FIRST4 FIRST3 FIRST2 FIRST1 LAST4 LAST3 LAST2 LAST1 Previously 142259.04 147108.72 36777.3 326145.06 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 Sept.15/Oct.14 {goto}panel1~ {getlabel "Enter the appropriate printing code, and press Enter:->",YRS}~ {if YRS="ALL5"}{branch PRINT5}~ {if YRS="FIRST4"}{branch PRINT4}~ {if YRS="LAST4"}{branch PRINTL4}~ {if YRS="FIRST3"}{branch PRINT3}~ {if YRS="LAST3"}{branch PRINTL3}~ {if YRS="FIRST2"}{branch PRINT2}~ {if YRS="LAST2"}{branch PRINTL2}~ {if YRS="FIRST1"}{branch PRINT1}~ {if YRS="LAST1"}{branch PRINTL1}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN1~ag rTRN2~ag rTRN3~ag rTRN4~ag oml0~{esc}rTRN5~ag oml5~bcBSCH2~{esc}rSCH21~ag rSCH22~ag rSCH23~ag rSCH24~ag oml0~{esc}rSCH25~ag oml5~bcBSCH1~{esc}rSCH11~ag rSCH12~ag rSCH13~ag rSCH14~ag oml0~{esc}rSCH15~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let l56,Page 1 of 4}{let v56,Page 2 of 4}{let af56,Page 3 of 4}{let bb56,Page 4 of 4}~ {let bq115,Page 1 of 4}{let ca115,Page 2 of 4}{let ck115,Page 3 of 4}{let dg115,Page 4 of 4}~ {let dv177,Page 1 of 4}{let ef177,Page 2 of 4}{let ep177,Page 3 of 4}{let fl177,Page 4 of 4}~ /reEZ175..EZ177~/reAP54..AP56~/reCU113..CU115~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN1~ag rTRN2~ag rTRN3~ag oml0~{esc}rTRNS4~ag oml5~bcBSCH2~{esc}rSCH21~ag rSCH22~ag rSCH23~ag oml0~{esc}rSCHE24~ag oml5~bcBSCH1~{esc}rSCH11~ag rSCH12~ag rSCH13~ag oml0~{esc}rSCHE14~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let V56,Page 1 of 4}{let AF56,Page 2 of 4}{let AP56,Page 3 of 4}{let BB56,Page 4 of 4}~ {let CA115,Page 1 of 4}{let CK115,Page 2 of 4}{let CU115,Page 3 of 4}{let DG115,Page 4 of 4}~ {let EF177,Page 1 of 4}{let EP177,Page 2 of 4}{let EZ177,Page 3 of 4}{let FL177,Page 4 of 4}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN2~ag rTRN3~ag rTRN4~ag oml0~{esc}rTRN5~ag oml5~bcBSCH2~{esc}rSCH22~ag rSCH23~ag rSCH24~ag oml0~{esc}rSCH25~ag oml5~bcBSCH1~{esc}rSCH12~ag rSCH13~ag rSCH14~ag oml0~{esc}rSCH15~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let V56,Page 1 of 3}{let AF56,Page 2 of 3}{let BB56,Page 3 of 3}~ {let CA115,Page 1 of 3}{let CK115,Page 2 of 3}{let DG115,Page 3 of 3}~ {let EF177,Page 1 of 3}{let EP177,Page 2 of 3}{let FL177,Page 3 of 3}~/reAP54..AP56~/reCU113..CU115~/reEZ175..EZ177~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN2~ag rTRN3~ag oml0~{esc}rTRNS4~ag oml5~bcBSCH2~{esc}rSCH22~ag rSCH23~ag oml0~{esc}rSCHE24~ag oml5~bcBSCH1~{esc}rSCH12~ag rSCH13~ag oml0~{esc}rSCHE14~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let AF56,Page 1 of 3}{let AP56,Page 2 of 3}{let BB56,Page 3 of 3}~ {let CK115,Page 1 of 3}{let CU115,Page 2 of 3}{let DG115,Page 3 of 3}~ {let EP177,Page 1 of 3}{let EZ177,Page 2 of 3}{let FL177,Page 3 of 3}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN3~ag rTRN4~ag oml0~{esc}rTRN5~ag oml5~bcBSCH2~{esc}rSCH23~ag rSCH24~ag oml0~{esc}rSCH25~ag oml5~bcBSCH1~{esc}rSCH13~ag rSCH14~ag oml0~{esc}rSCH15~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let AF56,Page 1 of 2}{let BB56,Page 2 of 2}~ {let CK115,Page 1 of 2}{let DG115,Page 2 of 2}~ {let EP177,Page 1 of 2}{let FL177,Page 2 of 2}~/reAP54..AP56~/reCU113..CU115~/reEZ175..EZ177~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN3~ag oml0~{esc}rTRNS3~ag oml5~bcBSCH2~{esc}rSCH23~ag oml0~{esc}rSCHE23~ag oml5~bcBSCH1~{esc}rSCH13~ag oml0~{esc}rSCHE13~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let AP56,Page 1 of 2}{let BB56,Page 2 of 2}~ {let CU115,Page 1 of 2}{let DG115,Page 2 of 2}~ {let EZ177,Page 1 of 2}{let FL177,Page 2 of 2}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN4~ag oml0~{esc}rTRN5~ag oml5~bcBSCH2~{esc}rSCH24~ag oml0~{esc}rSCH25~ag oml5~bcBSCH1~{esc}rSCH14~ag oml0~{esc}rSCH15~ag os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let Ap56,Page 1 of 1}~ {let Cu115,Page 1 of 1}~ {let Ez177,Page 1 of 1}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN4~ag oml5~bcBSCH2~{esc}rSCH24~ag oml5~bcBSCH1~{esc}rSCH14~ag oml0~{esc}os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag {let AZ56,Page 1 of 1}~ {let DE115,Page 1 of 1}~ {let FJ177,Page 1 of 1}~ /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRNl5~ag oml5~bcBSCH2~{esc}rSCHL25~ag oml5~bcBSCH1~{esc}rSCHL15~ag oml0~{esc}os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag BE SURE TO ENTER THE CORRECT PRINTING CODE PRINTING CODE: = Year 5 = most recent year Difference 55449.02 20407.51 5101.84 80958.37 \L ==== - Printing all five pages Printing 4 yrs.(Yrs. 1, 2, 3 & 4) Printing 3 yrs.(yrs.2, 3 & 4) Printing 2 yrs.(yrs.3 & 4) Printing yr.4 Printing 4 yrs.(Yrs.2,3,4, & 5) Printing 3 yrs.(yrs.3,4, & 5) Printing 2 yrs.(yrs.4 & 5) Printing yr.5 {LET DN203,.6941} {LET DP203,.6443} {LET DR203,.5959} {LET DT203,.5490} {LET DX203,.5035} {LET DZ203,.4593} {LET EB203,.4164} {LET ED203,.3748} {LET EH203,.3344} {LET EJ203,.2951} {LET EL203,.2570} {LET EN203,.2201} {LET ER203,.1842} {LET ET203,.1494} {LET EV203,.1155} {LET EX203,.0828} {LET FB203,.0510} {LET FD203,.0201} {GOTO}FT248~ Explanations - - Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 Aug.15/Sept.14 \S {LET DN203,.6280} {LET DP203,.5801} {LET DR203,.5337} {LET DT203,.4886} {LET DX203,.4449} {LET DZ203,.4024} {LET EB203,.3612} {LET ED203,.3212} {LET EH203,.2823} {LET EJ203,.2446} {LET EL203,.2080} {LET EN203,.1725} {LET ER203,.1380} {LET ET203,.1045} {LET EV203,.0721} {LET EX203,.0406} {LET FB203,.01} {GOTO}FT248~ May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 May 1/14 \T {LET DN203,.5801} {LET DP203,.5337} {LET DR203,.4886} {LET DT203,.4449} {LET DX203,.4024} {LET DZ203,.3612} {LET EB203,.3212} {LET ED203,.2823} {LET EH203,.2446} {LET EJ203,.2080} {LET EL203,.1725} {LET EN203,.1380} {LET ER203,.1045} {LET ET203,.0721} {LET EV203,.0406} {LET EX203,.01} {GOTO}FT248~ Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 Feb.1/14 \K {LET DN203,.6773} {LET DP203,.6280} {LET DR203,.5801} {LET DT203,.5337} {LET DX203,.4886} {LET DZ203,.4449} {LET EB203,.4024} {LET ED203,.3612} {LET EH203,.3212} {LET EJ203,.2823} {LET EL203,.2446} {LET EN203,.2080} {LET ER203,.1725} {LET ET203,.1380} {LET EV203,.1045} {LET EX203,.0721} {LET FB203,.0406} {LET FD203,.01} {GOTO}FT248~ \C {GOTO}GG282~ /FCCNQ27..AG87~ DATA1.WK1~ {BRANCH \P}~ Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Aug.1/14 Copy Recap. from Database.wk1 to this Combined.wk1 \I {LET DN203,.6773} {LET DP203,.6280} {LET DR203,.5801} {LET DT203,.5337} {LET DX203,.4886} {LET DZ203,.4449} {LET EB203,.4024} {LET ED203,.3612} {LET EH203,.3212} {LET EJ203,.2823} {LET EL203,.2446} {LET EN203,.2080} {LET ER203,.1725} {LET ET203,.1380} {LET EV203,.1045} {LET EX203,.0721} {LET FB203,.0406} {GOTO}FT248~ July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 July 15/31 \P \A {GETNUMBER "Enter Code fr.1 to 17 for Int.computed to last day shown on Table:-> ",CODE} {IF CODE=1}{BRANCH \A} {IF CODE=2}{BRANCH \B} {IF CODE=3}{BRANCH \T} {IF CODE=4}{BRANCH \D} {IF CODE=5}{BRANCH \E} {IF CODE=6}{BRANCH \F} {IF CODE=7}{BRANCH \S} {IF CODE=8}{BRANCH \G} {IF CODE=9}{BRANCH \H} {IF CODE=10}{BRANCH \I} {IF CODE=11}{BRANCH \K} {IF CODE=12}{BRANCH \L} {IF CODE=13}{BRANCH \M} {IF CODE=14}{BRANCH \N} {IF CODE=15}{BRANCH \Q} {IF CODE=16}{BRANCH \R} {IF CODE=17}{BRANCH \U} {LET DN203,.5645} {LET DP203,.5185} {LET DR203,.4739} {LET DT203,.4306} {LET DX203,.3885} {LET DZ203,.3477} {LET EB203,.3081} {LET ED203,.2696} {LET EH203,.2323} {LET EJ203,.1960} {LET EL203,.1609} {LET EN203,.1267} {LET ER203,.0936} {LET ET203,.0615} {LET EV203,.0303} {GOTO}FT248~ Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 Jan. 1/14 \B {LET DN203,.5801} {LET DP203,.5337} {LET DR203,.4886} {LET DT203,.4449} {LET DX203,.4024} {LET DZ203,.3612} {LET EB203,.3212} {LET ED203,.2823} {LET EH203,.2446} {LET EJ203,.2080} {LET EL203,.1725} {LET EN203,.1380} {LET ER203,.1045} {LET ET203,.0721} {LET EV203,.0406} {GOTO}FT248~ Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 Jan.15/31 \D {LET DN203,.5959} {LET DP203,.5490} {LET DR203,.5035} {LET DT203,.4593} {LET DX203,.4164} {LET DZ203,.3748} {LET EB203,.3344} {LET ED203,.2951} {LET EH203,.2570} {LET EJ203,.2201} {LET EL203,.1842} {LET EN203,.1494} {LET ER203,.1155} {LET ET203,.0828} {LET EV203,.0510} {LET EX203,.0201} {GOTO}FT248~ Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 Feb.15/Mar.14 \E {LET DN203,.6119} {LET DP203,.5645} {LET DR203,.5185} {LET DT203,.4739} {LET DX203,.4306} {LET DZ203,.3885} {LET EB203,.3477} {LET ED203,.3081} {LET EH203,.2696} {LET EJ203,.2323} {LET EL203,.1960} {LET EN203,.1609} {LET ER203,.1267} {LET ET203,.0936} {LET EV203,.0615} {LET EX203,.0303} {GOTO}FT248~ Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 Mar.15/Apr.14 \F {LET DN203,.6280} {LET DP203,.5801} {LET DR203,.5337} {LET DT203,.4886} {LET DX203,.4449} {LET DZ203,.4024} {LET EB203,.3612} {LET ED203,.3212} {LET EH203,.2823} {LET EJ203,.2446} {LET EL203,.2080} {LET EN203,.1725} {LET ER203,.1380} {LET ET203,.1045} {LET EV203,.0721} {LET EX203,.0406} {GOTO}FT248~ Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 Apr.15/30 \G {LET DN203,.6443} {LET DP203,.5959} {LET DR203,.5490} {LET DT203,.5035} {LET DX203,.4593} {LET DZ203,.4164} {LET EB203,.3748} {LET ED203,.3344} {LET EH203,.2951} {LET EJ203,.2570} {LET EL203,.2201} {LET EN203,.1842} {LET ER203,.1494} {LET ET203,.1155} {LET EV203,.0828} {LET EX203,.0510} {LET FB203,.0201} {GOTO}FT248~ May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 May 15/June 14 \H {LET DN203,.6607} {LET DP203,.6119} {LET DR203,.5645} {LET DT203,.5185} {LET DX203,.4739} {LET DZ203,.4306} {LET EB203,.3885} {LET ED203,.3477} {LET EH203,.3081} {LET EJ203,.2696} {LET EL203,.2323} {LET EN203,.1960} {LET ER203,.1609} {LET ET203,.1267} {LET EV203,.0936} {LET EX203,.0615} {LET FB203,.0303} {GOTO}FT248~ \V June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 June 15/July 14 {LET L54,D1} {LET V54,D1} {LET AF54,D1} {LET AP54,D1} {LET BB54,D1} {LET DV175,D1} {LET EF175,D1} {LET EP175,D1} {LET EZ175,D1} {LET FL175,D1} {LET BQ113,D1} {LET CA113,D1} {LET CK113,D1} {LET CU113,D1} {LET DG113,D1} {LET GC220,D1} {LET B54,F1} {LET D54,F2} {LET BG113,F1} {LET BI113,F2} {LET DL175,F1} {LET DN175,F2} {LET FU225,F1} {LET N54,F2} {LET X54,F2} {LET AH54,F2} {LET AR54,F2} {LET BS113,F2} {LET CC113,F2} {LET CM113,F2} {LET CW113,F2} {LET DX175,F2} {LET EH175,F2} {LET ER175,F2} {LET FB175,F2}~ Tracfone Wireless REPORTED UTILITY: Gross revenue reported: Reported deductions: Reported revenues: TAX PAID January 0 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2007 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 1 of 7 Total 0 January 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2008 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 2 of 7 Total 0 January 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2009 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 3 of 7 Total 0 January 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2010 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 4 of 7 Total 0 January 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2011 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 5 of 7 Total 0 January February March April May ORIGINAL REVENUE AND TAX REPORTED 2012 June July August September October November December Page 6 of 7 Total January 0 February 0 March 0 April 0 May 0 ORIGINAL REVENUE AND TAX REPORTED 2013 June 0 July 0 August 0 September 0 October 0 November 0 December 0 Page 7 of 7 Total 0 Grand Total February March April May ORIGINAL REVENUE AND TAX REPORTED 2014 June July August September October November December Page 8 of 10 Total 0 0 January February March April May ORIGINAL REVENUE AND TAX REPORTED 2015 June July August September October November December Page 9 of 10 Total 0 0 January February March April May ORIGINAL REVENUE AND TAX REPORTED 0 0 June July August September October November December Page 10 of 10 Total 0 0 Grand Total 0 0 0 Tracfone Wireless, Inc Data Sheet MO/YR 1/1/2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 8/1/2007 9/1/2007 10/1/2007 11/1/2007 12/1/2007 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008 9/1/2008 10/1/2008 11/1/2008 12/1/2008 1/1/2009 2/1/2009 3/1/2009 4/1/2009 5/1/2009 6/1/2009 7/1/2009 8/1/2009 9/1/2009 10/1/2009 11/1/2009 12/1/2009 1/1/2010 2/1/2010 3/1/2010 4/1/2010 5/1/2010 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010 1/1/2011 2/1/2011 3/1/2011 4/1/2011 5/1/2011 6/1/2011 7/1/2011 8/1/2011 9/1/2011 10/1/2011 11/1/2011 12/1/2011 1/1/2012 2/1/2012 3/1/2012 4/1/2012 5/1/2012 6/1/2012 7/1/2012 8/1/2012 9/1/2012 10/1/2012 11/1/2012 12/1/2012 1/1/2013 2/1/2013 3/1/2013 4/1/2013 5/1/2013 CATEGORY Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax Utility Tax TAXABLE REVENUE PER AUDIT: (Horizontal Tabulation) January 9362.33 Revenue Reported None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None February 8583.72 Non-Direct Sales Intra-state Without Data 7677.11 7038.65 8055.73 6979.11 5947.1 7617.53 7394.85 7038.33 8864.97 7773.42 10676.35 10172.87 9774.52 12878.67 13194.41 11896.39 12804.9 11796.45 12070.93 11762.91 12688.89 12776.43 13019.72 14918.71 14633.81 11485.28 15925.81 15827.41 18661.51 17763.75 18075.67 17568.82 18617.42 16906.26 16805.54 19911.19 22367.91 21578.68 25474.26 24933.88 25297.72 26213.94 33144.39 32082.19 31798.03 33589.71 35203.52 41719.71 28264.02 26194.18 28552.1 28493.49 31237.01 28444.55 29438.79 32352.98 32347.38 29465.95 30960.78 31245.29 25442.14 26312.94 27670.81 28167.37 27181.97 29855.02 32434.01 31795.71 32947.81 35301.56 35038.85 37278.57 26962.66 27009.08 29038.75 28269.74 38363.37 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 March 9824.06 Billing Platform Sales Intra-state Without Data 0 0 0 0 0 8.13 8.13 13 47.24 53.75 50.46 60.55 80.46 66.39 118.31 100.87 156.12 119.61 214.17 208.64 200.12 186.04 223.13 279.75 370.98 400.11 427.06 515.86 435.42 514.56 640.47 553.47 496.45 602.49 699.71 826.94 1230.32 1197.99 1688.5 1663.38 1837.29 2110.44 2441.37 2595.93 2912.14 3311.5 3353.11 3994.3 3490.05 3564.12 3867.06 3997.79 4268.19 4199.9 3959.14 4109.45 3833.46 3295.55 3059.42 3021.61 2703.32 2943.55 3084.42 3173.8 3267.52 3418.04 3620.38 3703.34 3682.23 4503.63 4691.81 4887.35 4349.39 4208.6 5141.29 5277.63 5677.29 April 8511.11 Page Plus Air Intra-state Without Data May 7252.56 Page Plus Intra-state Without Data 2007 June 9289.67 APP Direct Sales Intra-state Without Data 1685.22 1545.07 1768.33 1532 1305.46 1664.01 1615.13 1532 1898.73 1652.61 2293.13 2172.52 1921.55 2571.41 2584.16 2335.74 2466.57 2296.53 2258.19 2200.63 2398.81 2430.82 2443.56 2775.89 2841.32 2121.05 3068.85 2958.45 3661.01 3384.8 3327.36 3303.1 3590.3 3108.64 2989.31 3543.81 3351.06 3221.74 3529.12 3443.56 3344.17 3258.68 4347.24 3975.12 3600.71 3568.32 3857.25 4550.7 4023.17 3398.89 3722.74 3576.43 4035.32 3361.31 3866.36 4490.71 4765.21 4537.17 5170.66 5284.1 5331.04 5365.8 5653.73 5721.16 5316.26 6009.86 6621.94 6337.41 6722.34 6644.23 6373.09 6884.83 5623.1 5781.06 5599.07 5178.3 8511.9 July 9018.11 Total Taxable Revenue 9362.33 8583.72 9824.06 8511.11 7252.56 9289.67 9018.11 8583.33 10810.94 9479.78 13019.94 12405.94 11776.53 15516.47 15896.88 14333 15427.59 14212.59 14543.29 14172.18 15287.82 15393.29 15686.41 17974.35 17846.11 14006.44 19421.72 19301.72 22757.94 21663.11 22043.5 21425.39 22704.17 20617.39 20494.56 24281.94 26949.29 25998.41 30691.88 30040.82 30479.18 31583.06 39933 38653.24 38310.88 40469.53 42413.88 50264.71 35777.24 33157.19 36141.9 36067.71 39540.52 36005.76 37264.29 40953.14 40946.05 37298.67 39190.86 39551 33476.5 34622.29 36408.96 37062.33 35765.75 39282.92 42676.33 41836.46 43352.38 46449.42 46103.75 49050.75 36935.15 36998.74 39779.11 38725.67 52552.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 August 8583.33 Note: Sales amounts are reduced by three factors. 1)Data is removed. 2)Interstate and international is removed. 3)A factor to proportion sum of zip population down to city population. DATA: Year Data Percentage INTRA-STATE: POPULATION RATIO: September 10810.94 2007 Year Intrastate Percentage Interstate Percentage International Percentage Total: Zip populations PER: Renton Populations per: Total Column D: Column E: Column F: Column G: Column H: Column I: October 9479.78 2008 2007 0.8407 0.1539 0.0054 1 https://www.unitedstateszipcodes.org/98178/ https://edocs.rentonwa.gov/Documents/0/edoc/956723/2016%20CAFR%20-%20City%20of%20Renton,%20WA.pdf 1676472.24 150013.99 0 0 285200.93 2111687.16 November 13019.94 2009 2008 0.8407 0.1539 0.0054 1 98178 98055 98056 98057 98058 98059 Sum: Renton Populations: Population Ratios: 100588.33 9000.84 0 0 17112.06 126701.23 Due check: Sum check: Horizontal Check: December 12405.94 2010 0.0396 2009 0.8407 0.1539 0.0054 1 2007 21974 20151 30295 9813 41080 32156 155469 2007 60290 2007 0.387794351285465 126701.21 126701.23 2111687.16 Total 116141.49 116141.49 2011 0.1865 2010 0.8573 0.1411 0.0016 1 2008 21695 19888 30562 9768 40762 32741 155416 2008 78780 2008 0.506897616718999 January 11776.53 2012 0.2508 2011 0.8397 0.1558 0.0045 1 2009 21717 20228 31751 10621 41061 33745 159123 2009 83650 2009 0.525693960018351 February 15516.47 2013 0.3842 2012 0.8338 0.1568 0.0094 1 2010 22174 20603 31912 11305 41326 34618 161938 2010 90927 2010 0.561492670034211 March 15896.88 2014 0.4177 2013 0.8109 0.1717 0.0174 1 2011 22343 19865 32733 11631 40371 35108 162051 2011 92590 2011 0.571363336233655 April 14333 2014 0.7933 0.1933 0.0134 1 2012 23090 19890 33200 11680 40450 35770 164080 (Page 7-7) 2012 93910 2012 0.572342759629449 May 15427.59 2013 23140 20190 32960 11760 40800 36470 165320 2013 95540 2013 0.577909508831357 2008 June 14212.59 Internet/Direct Sales 5169.09 4739.22 5424.01 4699.11 4004.25 5104.02 4954.09 4699.11 5823.99 5069.07 7033.74 6663.8 4509.11 6034.06 6063.98 5481.05 5788.06 5389.04 5299.07 5164 5629.05 5704.15 5734.06 6513.89 6429.04 4799.29 6943.86 6694.07 8283.75 7658.78 7528.79 7473.9 8123.75 7033.91 6763.9 8018.56 7248.58 6968.85 7633.73 7448.66 7233.68 7048.75 9403.39 8598.46 7788.6 7718.54 8343.51 9843.49 10308 8708.49 9538.26 9163.37 10339.13 8612.2 9906.22 11505.9 12209.21 11624.94 13248.05 13538.7 14910.64 15007.85 15813.18 16001.78 14869.3 16809.25 18521.2 17725.4 18802.02 18583.55 17825.19 19256.51 19485.4 20032.77 19402.13 17944.04 29495.77 July 14543.29 Billing Platform Sales 24.94 24.94 39.89 144.9 164.87 154.79 185.73 188.8 155.79 277.63 236.69 366.34 280.67 502.56 489.59 469.61 436.56 523.59 656.47 839.41 905.33 966.3 1167.23 985.23 1164.29 1449.19 1252.34 1123.31 1363.26 1583.22 1871.12 2661.26 2591.33 3652.34 3598 3974.2 4565.03 5280.86 5615.18 6299.16 7163.02 7253.02 8639.95 8942.07 9131.85 9908.03 10242.96 10935.78 10760.8 10143.95 10529.05 9821.94 8443.71 7838.72 7741.85 7561.03 8232.95 8626.95 8876.95 9139.07 9560.07 10126.02 10358.05 10299 12596.42 13122.74 13669.65 15071.66 14583.81 17815.79 18288.25 19673.17 August 14172.18 1/7/2007 2/7/2007 3/7/2007 4/7/2007 5/7/2007 6/7/2007 7/7/2007 8/7/2007 9/7/2007 10/7/2007 11/7/2007 12/7/2007 1/7/2008 2/7/2008 3/7/2008 4/7/2008 5/7/2008 6/7/2008 7/7/2008 8/7/2008 9/7/2008 10/7/2008 11/7/2008 12/7/2008 1/7/2009 2/7/2009 3/7/2009 4/7/2009 5/7/2009 6/7/2009 7/7/2009 8/7/2009 9/7/2009 10/7/2009 11/7/2009 12/7/2009 1/7/2010 2/7/2010 3/7/2010 4/7/2010 5/7/2010 6/7/2010 7/7/2010 8/7/2010 9/7/2010 10/7/2010 11/7/2010 12/7/2010 1/7/2011 2/7/2011 3/7/2011 4/7/2011 5/7/2011 6/7/2011 7/7/2011 8/7/2011 9/7/2011 10/7/2011 11/7/2011 12/7/2011 1/7/2012 2/7/2012 3/7/2012 4/7/2012 5/7/2012 6/7/2012 7/7/2012 8/7/2012 9/7/2012 10/7/2012 11/7/2012 12/7/2012 1/7/2013 2/7/2013 3/7/2013 4/7/2013 5/7/2013 September 15287.82 October 15393.29 0 November 15686.41 December 17974.35 Total 180220.4 180220.4 January 17846.11 February 14006.44 March 19421.72 April 19301.72 May 22757.94 2009 June 21663.11 July 22043.5 August 21425.39 September 22704.17 October 20617.39 November 20494.56 December 24281.94 Total 246563.99 246563.99 January 26949.29 February 25998.41 March 30691.88 April 30040.82 May 30479.18 2010 June 31583.06 July 39933 August 38653.24 September 38310.88 October 40469.53 November 42413.88 December 50264.71 Total 425787.88 425787.88 January 35777.24 February 33157.19 March 36141.9 April 36067.71 May 39540.52 2011 June 36005.76 July 37264.29 August 40953.14 September 40946.05 October 37298.67 November 39190.86 December 39551 Total 451894.33 451894.33 January 33476.5 February 34622.29 March 36408.96 April 37062.33 May 35765.75 2012 June 39282.92 July 42676.33 August 41836.46 September 43352.38 October 46449.42 November 46103.75 December 49050.75 Total 486087.84 486087.84 January 36935.15 February 36998.74 March 39779.11 April 38725.67 May 52552.56 2013 June 0 July 0 August 0 September 0 October 0 0 November 0 December 0 Total 204991.23 204991.23 January 0 February 0 March 0 April 0 May 0 2014 June 0 0 July 0 0 August 0 0 September 0 0 October 0 0 November 0 0 December 0 0 Total 0 0 0 January 0 0 February 0 0 March 0 0 April 0 0 May 0 0 2015 June 0 0 July 0 0 August 0 0 September 0 0 October 0 0 November 0 December 0 Total 0 0 January 0 February 0 March 0 April 0 May 0 0 June 0 July 0 August 0 September 0 October 0 November 1676472.24 December 0 Total 1676472.24 1676472.24 Grand Total 2111687.16 3788159.4 0 Tracfone Wireless UTILITY: Revenue Per Data Sheet: Deductions: Total Taxable Revenue: Tax Due: Tax Paid: DIFFERENCE: Rounding: TOTAL TAX DUE/(CR) INTEREST: Interest Rate (Old Code): Interest Rate (New Code): Interest Due : PENALTY: Penalty Rate: Penalty Due : Penalty Paid: DIFFERENCE: TOTAL TAX, INTEREST AND PENALTY DUE/(CREDIT): Penalty Tax Int January 9362.33 9362.33 561.74 0 561.74 561.74 Note: Renton does not charge interest previous to May 2008. 0.9 505.57 0.25 140.44 140.44 1207.75 14982.3 Tax Rate: 1742.15 6968.5 6271.65 0 0 14982.3 February 8583.72 8583.72 515.02 0 515.02 515.02 0.9 463.52 0.25 128.76 128.76 1107.3 0.06 March 9824.06 9824.06 589.44 0 589.44 589.44 0.9 530.5 0.25 147.36 147.36 1267.3 April 8511.11 8511.11 510.67 0 510.67 510.67 0.9 459.6 0.25 127.67 127.67 1097.94 May 7252.56 7252.56 435.15 0 435.15 435.15 0.9 391.64 0.25 108.79 108.79 935.58 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2007 June 9289.67 9289.67 557.38 0 557.38 557.38 0.9 501.64 0.25 139.35 139.35 1198.37 July 9018.11 9018.11 541.09 0 541.09 541.09 0.9 486.98 0.25 135.27 135.27 1163.34 August 8583.33 8583.33 515 0 515 515 0.9 463.5 0.25 128.75 128.75 1107.25 September 10810.94 10810.94 648.66 0 648.66 648.66 0.9 583.79 0.25 162.17 162.17 1394.62 October 9479.78 9479.78 568.79 0 568.79 568.79 0.9 511.91 0.25 142.2 142.2 1222.9 November 13019.94 13019.94 781.2 0 781.2 781.2 0.9 703.08 0.25 195.3 195.3 1679.58 December 12405.94 12405.94 744.36 0 744.36 744.36 0.9 669.92 0.25 186.09 186.09 1600.37 Page 1 of 7 Total 116141.49 116141.49 6968.5 0 6968.5 6968.5 0.108 7024.25 1742.15 1742.15 14982.3 January 11776.53 11776.53 706.59 0 706.59 706.59 Note: Renton does not charge interest previous to May 2008. 0.9 635.93 0.25 176.65 176.65 1519.17 22982.14 Tax Rate: 2703.33 10813.23 9465.58 22982.14 February 15516.47 15516.47 930.99 0 930.99 930.99 0.9 837.89 0.25 232.75 232.75 2001.63 0.06 March 15896.88 15896.88 953.81 0 953.81 953.81 0.9 858.43 0.25 238.45 238.45 2050.69 April 14333 14333 859.98 0 859.98 859.98 0.9 773.98 0.25 215 215 1848.96 May 15427.59 15427.59 925.66 0 925.66 925.66 0.9 833.09 0.25 231.42 231.42 1990.17 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2008 June 14212.59 14212.59 852.76 0 852.76 852.76 0.89 758.96 0.25 213.19 213.19 1824.91 July 14543.29 14543.29 872.6 0 872.6 872.6 0.88 767.89 0.25 218.15 218.15 1858.64 August 14172.18 14172.18 850.33 0 850.33 850.33 0.87 739.79 0.25 212.58 212.58 1802.7 September 15287.82 15287.82 917.27 0 917.27 917.27 0.86 788.85 0.25 229.32 229.32 1935.44 October 15393.29 15393.29 923.6 0 923.6 923.6 0.85 785.06 0.25 230.9 230.9 1939.56 November 15686.41 15686.41 941.18 0 941.18 941.18 0.84 790.59 0.25 235.3 235.3 1967.07 December 17974.35 17974.35 1078.46 0 1078.46 1078.46 0.83 895.12 0.25 269.62 269.62 2243.2 Page 2 of 7 Total 180220.4 180220.4 10813.23 0 10813.23 10813.23 0.108 10633.41 2703.33 2703.33 22982.14 January 17846.11 17846.11 1070.77 0 1070.77 1070.77 0.82 878.03 0.25 267.69 267.69 2216.49 29764.31 Tax Rate: 3698.47 14793.84 11272 29764.31 February 14006.44 14006.44 840.39 0 840.39 840.39 0.81 680.72 0.25 210.1 210.1 1731.21 0.06 March 19421.72 19421.72 1165.3 0 1165.3 1165.3 0.8 932.24 0.25 291.33 291.33 2388.87 April 19301.72 19301.72 1158.1 0 1158.1 1158.1 0.79 914.9 0.25 289.53 289.53 2362.53 May 22757.94 22757.94 1365.48 0 1365.48 1365.48 0.78 1065.07 0.25 341.37 341.37 2771.92 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2009 June 21663.11 21663.11 1299.79 0 1299.79 1299.79 0.77 1000.84 0.25 324.95 324.95 2625.58 July 22043.5 22043.5 1322.61 0 1322.61 1322.61 0.76 1005.18 0.25 330.65 330.65 2658.44 August 21425.39 21425.39 1285.52 0 1285.52 1285.52 0.75 964.14 0.25 321.38 321.38 2571.04 September 22704.17 22704.17 1362.25 0 1362.25 1362.25 0.74 1008.07 0.25 340.56 340.56 2710.88 October 20617.39 20617.39 1237.04 0 1237.04 1237.04 0.73 903.04 0.25 309.26 309.26 2449.34 November 20494.56 20494.56 1229.67 0 1229.67 1229.67 0.72 885.36 0.25 307.42 307.42 2422.45 December 24281.94 24281.94 1456.92 0 1456.92 1456.92 0.71 1034.41 0.25 364.23 364.23 2855.56 Page 3 of 7 Total 246563.99 246563.99 14793.84 0 14793.84 14793.84 0.108 12869.73 3698.47 3698.47 29764.31 January 26949.29 26949.29 1616.96 0 1616.96 1616.96 0.7 1131.87 0.25 404.24 404.24 3153.07 48248 Tax Rate: 6386.83 25547.25 16313.92 48248 February 25998.41 25998.41 1559.9 0 1559.9 1559.9 0.69 1076.33 0.25 389.98 389.98 3026.21 0.06 March 30691.88 30691.88 1841.51 0 1841.51 1841.51 0.68 1252.23 0.25 460.38 460.38 3554.12 April 30040.82 30040.82 1802.45 0 1802.45 1802.45 0.67 1207.64 0.25 450.61 450.61 3460.7 May 30479.18 30479.18 1828.75 0 1828.75 1828.75 0.66 1206.98 0.25 457.19 457.19 3492.92 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2010 June 31583.06 31583.06 1894.98 0 1894.98 1894.98 0.65 1231.74 0.25 473.75 473.75 3600.47 July 39933 39933 2395.98 0 2395.98 2395.98 0.64 1533.43 0.25 599 599 4528.41 August 38653.24 38653.24 2319.19 0 2319.19 2319.19 0.63 1461.09 0.25 579.8 579.8 4360.08 September 38310.88 38310.88 2298.65 0 2298.65 2298.65 0.62 1425.16 0.25 574.66 574.66 4298.47 October 40469.53 40469.53 2428.17 0 2428.17 2428.17 0.61 1481.18 0.25 607.04 607.04 4516.39 November 42413.88 42413.88 2544.83 0 2544.83 2544.83 0.6 1526.9 0.25 636.21 636.21 4707.94 December 50264.71 50264.71 3015.88 0 3015.88 3015.88 0.59 1779.37 0.25 753.97 753.97 5549.22 Page 4 of 7 Total 425787.88 425787.88 25547.25 0 25547.25 25547.25 0.108 19073.02 6386.83 6386.83 48248 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 January 35777.24 35777.24 2146.63 0 2146.63 2146.63 0.58 1245.05 0.25 536.66 536.66 3928.34 Tax Rate: February 33157.19 33157.19 1989.43 0 1989.43 1989.43 0.57 1133.98 0.25 497.36 497.36 3620.77 0.06 March 36141.9 36141.9 2168.51 0 2168.51 2168.51 0.56 1214.37 0.25 542.13 542.13 3925.01 April 36067.71 36067.71 2164.06 0 2164.06 2164.06 0.55 1190.23 0.25 541.02 541.02 3895.31 May 39540.52 39540.52 2372.43 0 2372.43 2372.43 0.54 1281.11 0.25 593.11 593.11 4246.65 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2011 June 36005.76 36005.76 2160.35 0 2160.35 2160.35 0.53 1144.99 0.25 540.09 540.09 3845.43 0.02 0.03 0.03 0.04 July 37264.29 37264.29 2235.86 0 2235.86 2235.86 0.52 1162.65 0.25 558.97 558.97 3957.48 2016 2017 2018 2019 August 40953.14 40953.14 2457.19 0 2457.19 2457.19 0.51 1253.17 0.25 614.3 614.3 4324.66 September 40946.05 40946.05 2456.76 0 2456.76 2456.76 0.5 1228.38 0.25 614.19 614.19 4299.33 Due Date: Date Last Mo Due: October 37298.67 37298.67 2237.92 0 2237.92 2237.92 0.49 1096.58 0.25 559.48 559.48 3893.98 10/17/2019 1/31/2019 259 November 39190.86 39190.86 2351.45 0 2351.45 2351.45 0.48 1128.7 0.25 587.86 587.86 4068.01 December 39551 39551 2373.06 0 2373.06 2373.06 0.47 1115.34 0.25 593.27 593.27 4081.67 bl Page 5 of 7 Total 451894.33 451894.33 27113.65 0 27113.65 27113.65 0.108 17122.82 6778.44 6778.44 48086.64 January 33476.5 33476.5 2008.59 0 2008.59 2008.59 0.46 923.95 0.25 502.15 502.15 3434.69 Tax Rate: February 34622.29 34622.29 2077.34 0 2077.34 2077.34 0.45 934.8 0.25 519.34 519.34 3531.48 0.06 March 36408.96 36408.96 2184.54 0 2184.54 2184.54 0.44 961.2 0.25 546.14 546.14 3691.88 April 37062.33 37062.33 2223.74 0 2223.74 2223.74 0.43 956.21 0.25 555.94 555.94 3735.89 May 35765.75 35765.75 2145.95 0 2145.95 2145.95 0.42 901.3 0.25 536.49 536.49 3583.74 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2012 June 39282.92 39282.92 2356.98 0 2356.98 2356.98 0.41 966.36 0.25 589.25 589.25 3912.59 July 42676.33 42676.33 2560.58 0 2560.58 2560.58 0.4 1024.23 0.25 640.15 640.15 4224.96 August 41836.46 41836.46 2510.19 0 2510.19 2510.19 0.39 978.97 0.25 627.55 627.55 4116.71 September 43352.38 43352.38 2601.14 0 2601.14 2601.14 0.38 988.43 0.25 650.29 650.29 4239.86 October 46449.42 46449.42 2786.97 0 2786.97 2786.97 0.37 1031.18 0.25 696.74 696.74 4514.89 November 46103.75 46103.75 2766.23 0 2766.23 2766.23 0.36 995.84 0.25 691.56 691.56 4453.63 December 49050.75 49050.75 2943.05 0 2943.05 2943.05 0.35 1030.07 0.25 735.76 735.76 4708.88 by Page 6 of 7 Total 486087.84 486087.84 29165.3 0 29165.3 29165.3 0.108 14842.39 7291.36 7291.36 48149.2 January 36935.15 36935.15 2216.11 0 2216.11 2216.11 0.34 753.48 0.25 554.03 554.03 3523.62 Tax Rate: February 36998.74 36998.74 2219.92 0 2219.92 2219.92 0.33 732.57 0.25 554.98 554.98 3507.47 0.06 March 39779.11 39779.11 2386.75 0 2386.75 2386.75 0.32 763.76 0.25 596.69 596.69 3747.2 April 38725.67 38725.67 2323.54 0 2323.54 2323.54 0.31 720.3 0.25 580.89 580.89 3624.73 May 52552.56 52552.56 3153.15 0 3153.15 3153.15 0.3 945.95 0.25 788.29 788.29 4887.39 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2013 June 0 0 0 0 0 0 0 0 0 0 July 0 0 0 0 0 0 0 0 0 0 August 0 0 0 0 0 0 0 0 0 0 Interest Starting: Interest Ending: Difference: September 0 0 0 0 0 0 0 0 0 0 6/30/2013 12/31/2015 0.3005 October 0 0 0 0 0 0 0 0 0 0 November 0 0 0 0 0 0 0 0 0 0 25340.242 December 0 0 0 0 0 0 0 0 0 0 Total 204991.23 204991.23 12299.47 0 12299.47 12299.47 0.108 5244.4 3074.88 3074.88 19290.41 Page 7 of 7 Grand Total 2111687.16 2111687.16 126701.24 0 126701.24 -0.03 126701.21 86810.02 31675.46 31675.46 245186.69 16546.8 60139.82 45341.18 122027.8 115976.72 February 0 0 0 0 0 0 0 0 0 0 March 0 0 0 0 0 0 0 0 0 0 April 0 0 0 0 0 0 0 0 0 0 May 0 0 0 0 0 0 0 0 0 0 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2014 June 0 0 0 0 0 0 0 0 0 0 July 0 0 0 August 0 0 0 0 0 0 0 0 0 0 September 0 0 0 0 0 0 0 0 0 0 October 0 0 0 0 0 0 0 0 0 0 November 0 0 0 0 0 0 0 0 0 0 December 0 0 0 0 0 0 0 0 0 0 0 Page 8 of 10 Total 0 2111687.16 126701.24 0 January 0 0 0 0 0 0 0 0 0 0 February 0 0 0 0 0 0 0 0 0 0 March 0 0 0 0 0 0 0 0 0 0 April 0 0 0 0 0 0 0 0 0 0 May 0 0 0 0 0 0 0 0 0 0 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2015 June 0 0 0 0 0 0 0 0 0 0 July 0 0 0 0 0 0 0 0 0 0 August 0 0 0 0 0 0 0 0 0 0 September 0 0 0 0 0 0 0 0 0 0 October 0 0 0 0 0 0 0 0 0 0 November 0 0 0 0 0 0 0 0 0 0 December 0 0 0 0 0 0 0 0 0 0 0 Page 9 of 10 Total 0 0 0 0 0 0 0 0 0 0 January 0 0 0 0 0 0 0 0 0 0 February 0 0 0 0 0 0 0 0 0 0 March 0 0 0 0 0 0 0 0 0 0 April 0 0 0 0 0 0 0 0 0 0 May 0 0 0 0 0 0 0 0 0 0 Jun 0 0 0 0 0 0 0 0 0 0 Jul 0 0 0 TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 0 0 August 0 0 0 0 0 0 0 0 0 0 September 0 0 0 0 0 0 0 0 0 0 October 0 November December Total 0