Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
09.Interest Rate Calculations, Renton.xls
EXHIBIT C‐9 Tracfone Wireless UTILITY: January February March AWN TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2007 May June July August September October November December Page 1 of 7 Total Revenue Per Data Sheet: $936233 $8,58372 $9,824.06 $8511.11 $7.252.56 S9,289.67 $9,018.11 $8,583.33 $13810.94 59,479.78 $13,019.94 $12.405.94 $116.141.49 Deductions. iota! Taxable Revenue: $9.362.33 $8,583.72 $9,824.06 $8,511.11 $7,252.56 $9,289.67 $9,018.11 $8,583.33 $10,810.94 S9,479.78 $13,019.94 $12.405.94 $116,141.49 Tay Due: $561.74 5515.02 5589.44 5510.67 5435.15 3557.38 $541.09 $515.00 $648.66 $568.79 $78120 $74436 56.968.50 Tax Paid: DIFFERENCE: $561.74 $515.02 $589.44 $510.67 $435.15 5557.38 5541.09 $515.00 5648.66 5568.79 5781.20 $744.36 $6,968.50 Rounding: TOTAL TAX DUEIICR) 9561.74 5515.02 5580.44 $510.67 5435.15 $557.38 $541.09 0515.00 $648.66 5568 79 5781.20 $744.36 $6,968.50 INTEREST: Note: Renton does not charge interest previous to May 2008. Interest Rate (Old Code): 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% Interest Rate (New Code): 103% Interest Due : $505.57 5463.52 5530.50 $459.60 $391.64 $501.64 $486.98 S463.50 5583.79 $511.91 5703.08 $669.92 $7,024.25 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due : $140.44 5128.76 5147.36 $127.67 518879 5139.35 5135.27 5128.75 $162.17 $142.20 $195.30 9186.09 51,742.15 Penalty Paid: DIFFERENCE: $140.44 $128.76 5147.36 5127.67 510879 5139.35 $135.27 $128.75 $162.17 $142.20 $195.30 $186.09 $1,742.15 TOTAL TAX, INTEREST AND PENALTY DUE/(CREDIT): $1,207.75 $1,107.30 $1,267.30 $1,097.94 $935.58 $1,198.37 $1,163.34 51,10725 $1,394.62 51,222.90 $1,679.58 $1,600.37 $14,982.30 Tracfone Wireless UTILITY: January February March April TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2008 May June July August September October November December Page 2 of 7 Total Revenue Per Data Sheet $11.776.53 515,516.47 $15.896.88 $14,333.00 515,427.59 $14,212.59 $14,543.29 $14,172.18 $15,287.82 $15393.29 $15,686.41 $17,974.35 $180,220.40 Deductions: Total Taxable Revenue: 511 776 53 515516.47 $15,896.88 $14,333.00 515,427.59 $14,212.59 $14,543.29 $14.172.18 515,287.82 $15,393.29 $15,686.41 $17974.35 $180,220.40 Tax Due: $706.59 $930.99 5953.81 5859.98 $925.66 985276 9872.60 6850.33 5917.27 $923.60 $941.18 $1,078.46 $10,813.23 -Fax Paid: DIFFERENCE: $706.59 $930.99 $953.81 $859.98 $925.66 5852.76 $872.60 $850.33 $917.27 $923.60 $941.18 51,078.46 $10,813.23 Rounding: TOTAL TAX DUE/(CR) $706.59 $930.99 $953.81 $859.98 5925.66 $852.76 $872.60 $850.33 5917.27 $923.60 5941.18 $1,078.46 $10,813.23 INTEREST: Note: Renton does not charge interest previous to May 2008. Interest Rate (Old Code): 90.0% 90.0% 90.0% 90.0% 90.0% 89.0% 88.0% 87.0% 86.0% 85.0% 84.0% 83.0% Interest Rate (Nevi Code): 10.8% Interest Due : 5635.93 $837.89 5858.43 $773.98 $833.09 $758.96 $767.89 $739.79 $788.85 $785.06 $790.59 5895.12 $10,633.41 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due : $176.65 $232.75 $238.45 $215.00 $231.42 $213.19 5218.15 521258 522932 6230.90 8235.30 $269.62 92,703.33 Penalty Paid: DIFFERENCE: 5176.65 $232.75 $238.45 5215.00 $231.42 $213.19 $218.15 5212.58 5229.32 5230.90 5235.30 $269.62 $2,703.33 TOTAL TAX, INTEREST AND PENALTY DUEJ(CREDIT): $1,519.17 $2,001.63 $2,050.69 $1,848.96 51.990.17 51,824.91 $1,858.64 51,80270 51,935.44 $1,939.56 $1,967.07 $2,243.20 522,982.14 Tracfone Wireless UTILITY: January February March April TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2009 May June July August September October November December Page 3 of 7 Total Revenue Per Data Sheet: $17,846.11 $14,006.44 $19,421.72 919.301.72 $22,757.94 521.663.11 022,043.50 521.425.39 $22,704.17 520.617.39 $20.494.56 924.28194 5246,563.99 Deductions: Total Taxable Revenue-$17,846.11 $14,006.44 519,421.72 $19,30172 $22,75794 $21,663.11 $22,043.50 $21.425.39 $22704.17 520,61739 520,494.56 524.28194 $246,563.99 Tax Due: 51,070.77 5840.39 $1,165.30 $1,158.10 51.365.48 51,299.79 $1,322.91 $1,285.52 51,362.25 51,237.04 51,229.67 $1,456.92 $14,793.84 Tax Paid: DIFFERENCE: $1,070.77 $840.39 $1,165.30 51.158 10 51,365.48 $1,299.79 51.322.61 $1,285.52 51.362.25 51,237.04 $1,229.67 51,456.92 514,793.84 Rounding: TOTAL TAX DUE/(CR) 51.070.77 5840.39 51,165.30 51,158.10 51,365.48 $1.29979 51,322.61 51.285.52 91,362.25 51.237.04 $1,229.67 51.456.92 $14,793.84 INTEREST: Interest Rate (Old Code): 82.0% 81.0% 80.0% 790% 78.0% 77.0% 76.0% 75.0% 74.0% 73.0% 72.0% 71.0% Interest Rate (New Code): 10.8% Interest Due $878.03 $680.72 $932.24 $91490 $1,065.07 $1,000.84 $1,005.18 $964.14 $1.008.07 $903.04 $885.36 51,034 41 512.869.73 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due : $267.69 5210.10 5291.33 $289.53 334137 5324.95 $930.65 $32138 $340.56 $309.26 $307.42 $364.23 53,698.47 Penalty Paid: DIFFERENCE: 5267.69 $210.10 $291.33 $289.53 $341.37 $324.95 $330.65 $321.38 5340.56 $309.26 $307.42 $364.23 $3,698.47 TOTAL TAX, INTEREST AND PENALTY DUEJ(CREDIT): 62,216.49 51.731.21 52,388.87 52,362.53 $2,77192 $2,625.58 $2,658.44 52,571.04 52,710.88 $2,449.34 52,422.45 52,855.56 $29,764.31 Tracfone Wireless UTILITY: January February March April TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2010 May June July August September October November December Page 4 of 7 Total Revenue Per Data Sheet: $26,949.29 $25,998.41 530.691.88 $30040.82 $30,479.18 531,583.06 939,933.00 $38,653.24 $38.310.88 $40,469.53 $42,413.88 $50,264.71 5425.787.88 Deductions: Total Taxable Revenue: 526,94929 525,998.41 530.691.88 $30,040.82 530.479 18 931,583.06 539,933.00 $38,653.24 538,310 88 540,469.53 542,413.88 550,26471 $425.787.88 Tax Due: 51,616.96 51,559 90 51,841.51 51,802.45 51,828.75 $1.894.98 $2.395.98 $2,319.19 52,298 65 52,428.17 52,544.83 $3,015.88 $25,547.25 Tax Paid: DIFFERENCE: $1.616.96 $1,559.90 $1,841.51 $1,802.45 51,828.75 $1,894.98 82,395.98 52,319.19 52.298.65 $2,428.17 52,544.83 $3,015.88 $25.547.25 Rounding: TOTAL TAX DUE/(CR) 91.616.96 $1,559.90 51.841.51 51,802.45 $1,828.75 51,894.98 52,395.98 52,319.19 $2.298.65 52,428.17 $2,544.83 53.015.88 $25.547.25 INTEREST: Interest Rate (Old Code): 70.0% 69.0% 68.0% 67.0% 66.0% 65.0% 64.0% 63.0% 62.0% 61.0% 60.0% 59.0% Interest Rate (New Code): 10.8% Interest Due : 51.131.87 51.076 33 51,252.23 $1,207.64 51.206.98 51.231.74 $1,533.43 51,461.09 51,425.16 $1,481.18 $1,526.90 $1,779.37 519,073.02 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due : $404.24 $389.98 $460.38 $450.61 $457.19 $473.75 $599.00 5579.80 5574.66 5607.04 5636.21 $753.97 56.386.83 Penalty Paid: DIFFERENCE: $404.24 5389.98 $460.38 5450.61 5457.19 $473.75 5599.00 5579.80 5574.66 $607.04 5636.21 9753.97 56,386.83 TOTAL TAX, INTEREST AND PENALTY DUE/(CREDIT): 53,153.07 53,026.21 53.554.12 53,460.70 $3,492.92 53.600.47 54,528.41 $4,360.08 $4.298.47 54,516.39 54,707.94 55,549.22 548,248.00 Tracfone Wireless UTILITY: January February March April TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2011 May June July August September October November December Page 5 of 7 Total Revenue Per Data Sheet: 535.77724 533,157.19 $36,141.90 $3E067.71 039,540.52 536.005 76 037,264.29 040,953.14 $40.946.05 $37.298.67 539,190.86 $39,551.00 $451.89433 Deductions: Total Taxable Revenue: $35,777.24 $33,157.19 $36,141.90 536,067.71 $39,540.52 S36,005 76 537.264.29 540,953.14 S40,946.05 $37298.67 $39,190.86 $39,551.00 $451.894.33 Tax Due: $2.146.63 51.989.43 52,168.51 $2,164.06 52.37243 $2.160.35 $2.235.86 $2,457.19 $2,456.76 $2.237.92 92,351.4$ $2,373.06 527,113.65 Tax Paid: DIFFERENCE: 52.146.63 51,989.43 $2,168.51 52,164.06 52.372.43 $2,160.35 52,235.86 52,457.19 52.456.76 52,237.92 52,351.45 52,373.06 $27.113.65 Rounding: TOTAL TAX DUE/(CR) 52,146.63 $1,989.43 S2.168.51 $2,184.06 52,372.43 $2.160.35 $2,235.86 52.457.19 52.456.76 52.237.92 $2,351.45 $2,373.06 527,113.65 INTEREST: Interest Rate (Old Code): 58.0% 57.0% 56.0% 55.0% 54.0% 53.0% 52.0% 51.0% 50.0% 49.0% 48.0% 47.0% Interest Rate (New Code): 10.8% Interest Due: $1,245.05 51.133.98 51,214,37 $1,190.23 $1,281.11 51,144.99 S1,162.65 51.253.17 $1,228.38 $1,096.58 $1,128.70 $1,115.34 $17,122.82 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due 9536.66 $49736 $542.13 $541.02 $593.11 9540.09 $558.97 $614.30 $614.19 5559.48 $587.86 $593.27 56,778 44 Penalty Paid: DIFFERENCE: 5536.66 $497.36 5542.13 $541.02 $593.11 5540.00 5558.97 $614.30 5614.19 $559.48 5587.86 $593.27 56.778.44 TOTAL TAX, INTEREST AND PENALTY DUEf(CREDIT): 53,928.34 53,620.77 53.925.01 53,895.31 54,246E5 53,845.43 $3,957.48 54,324.66 54,299.33 $3.893.98 54,068.01 54,081.67 548,086.64 Tracfone Wireless UTILITY: January February March April TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2012 May June July August September October November December Page 6 of 7 Total Revenue Per Data Sheet: $33,476.50 $34.622.29 $36A08.96 $37,062.33 535,76575 539.282.92 542,676.33 $41.836.46 $43,352.38 $46,449.42 546,103.75 $49,050.75 $486,087.84 Deductions: Total Taxable Revenue: 533,476.50 $34,622.29 536,408.96 $37,062.33 535,765.75 539.282.92 542,676.33 $41E36.46 543,352.38 546,449.42 $46,103.75 549,050.75 5486,087E4 Tax Due: $2,008.59 52.077.34 52.184,54 $2,223.74 $2.145.95 $2.356.98 $2,560.58 $2510.19 $2,601.14 $2,786.97 52,766.23 $2.943.05 $29,165.30 Tax Paid: DIFFERENCE: $2,008.59 62.07734 52.154E4 52.223.74 52.145.95 52.356.98 52,560.58 52,510.19 02,601.14 52,766.97 52.766.23 52,943.05 529,165.30 Rounding: TOTAL TAX DUEJ(CR) 52,008.59 52,077.34 S2,184.54 52,223.74 52,145.95 52.356.98 52,560 58 52,510.19 52.601,14 52.786.97 52.766.23 $2,943.05 $29,165.30 INTEREST: Interest Rate Mid Code): 46.0% 45.0% 44.0% 43.0% 42.0% 41.0% 40.0% 39.0% 38.0% 37.0% 36.0% 35.0% Interest Rate (New Code): 10.8% Interest Due : 5923.95 5934.80 5961.20 5956.21 5901.30 5966.36 $1 .024 23 $978.97 5988.43 $1.031.18 5995E4 $1,030.07 514.842.39 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Penalty Due : $502.15 $519.34 5546.14 $555.94 5536.49 5589.25 5640.15 $627.55 5650.29 $69674 5691.56 5735.76 67291.36 Penalty Paid: DIFFERENCE: $502.15 5519.34 5546.14 0555.94 S536.49 S589.25 5640.15 5627.55 6650.29 5696.74 5691.56 5735.76 57,291.36 TOTAL TAX, INTEREST AND PENALTY DUE/(CREDIT): $3.434.69 $3,531.48 53,691.88 53,735.89 53,583.74 53,912.59 54,224.96 $4,116.71 $4,239.86 54,514.89 54.453.63 $4,708.88 $48,149.20 Tracfone Wireless UTILITY: January February March And TAX, PENALTY & INTEREST SCHEDULE COMPUTATIONS 2013 May June July August September October November December Total Page 7 of 7 Grand Total Revenue Per Data Sheet: 536,935.15 $36,998.74 $39,779.11 538,725,67 552,552.56 $204,991.23 $2,111,687.16 Deductions: Total Taxable Revenue: $36,935.15 $36,998.74 $39,779.11 538,725.67 $52,552.56 $204.991.23 $2,111,687.16 Tax Due: 52216.11 52219.92 $2,386.75 $2,323.54 $3,153.15 512,299.47 5126,701.24 Tax Paid: DIFFERENCE: $2,216.11 $2219.92 $2,386.75 $2323.54 $3,153.15 $12,299.47 $126,701.24 Rounding: -$0.03 TOTAL TAX DUE/(CR) $2.216.11 $2,219.92 $2,386.75 $2.323.54 53.153.15 512299.47 5126,701.21 INTEREST: Interest Rate (Old Code): 34.0% 33.0% 32.0% 31.0% 30% Interest Rate (New Code): 10.8% Interest Due : 5753.48 5732.57 5763.76 $720,30 5945.95 55,244.40 586,810.02 PENALTY: Penalty Rate: 0.25 0.25 0.25 0.25 0.25 Penalty Due : 5554.03 $554.98 5596.69 $580.89 5788.29 $3 074 88 331$75.46 Penalty Paid: DIFFERENCE: $554.03 $554.98 5596.69 5580.89 $788.29 $3,074.88 $31$75.46 TOTAL TAX, INTEREST AND PENALTY DUEJ(CREDIT): $3,523.62 $3,507.47 $3.747.20 $3,624.73 $4,887.39 519,290.41 5245,186.69