Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
27. Renton Tracfone Corr 10-2009 Revenue Calculations
EXHIBIT C‐27 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182AB C D E F G RevenueNon-Direct Sales Billing Platform SalesPage Plus AirPage PlusMO/YRCATEGORYReportedIntra-state Without Data Intra-state Without Data Intra-state Without Data Intra-state Without Data39083Utility TaxNone =(E6+F6+G6+H6)*(0.82/0.18)=V6*(1-K$15)*(L$21)*(N$47)39114Utility TaxNone =(E7+F7+G7+H7)*(0.82/0.18)=V7*(1-K$15)*(L$21)*(N$47)39142Utility TaxNone =(E8+F8+G8+H8)*(0.82/0.18)=V8*(1-K$15)*(L$21)*(N$47)39173Utility TaxNone =(E9+F9+G9+H9)*(0.82/0.18)=V9*(1-K$15)*(L$21)*(N$47)39203Utility TaxNone =(E10+F10+G10+H10)*(0.82/0.18)=V10*(1-K$15)*(L$21)*(N$47)39234Utility TaxNone =(E11+F11+G11+H11)*(0.82/0.18)=V11*(1-K$15)*(L$21)*(N$47)39264Utility TaxNone =(E12+F12+G12+H12)*(0.82/0.18)=V12*(1-K$15)*(L$21)*(N$47)39295Utility TaxNone =(E13+F13+G13+H13)*(0.82/0.18)=V13*(1-K$15)*(L$21)*(N$47)39326Utility TaxNone =(E14+F14+G14+H14)*(0.82/0.18)=V14*(1-K$15)*(L$21)*(N$47)39356Utility TaxNone =(E15+F15+G15+H15)*(0.82/0.18)=V15*(1-K$15)*(L$21)*(N$47)39387Utility TaxNone =(E16+F16+G16+H16)*(0.82/0.18)=V16*(1-K$15)*(L$21)*(N$47)39417Utility TaxNone =(E17+F17+G17+H17)*(0.82/0.18)=V17*(1-K$15)*(L$21)*(N$47)39448Utility TaxNone =(E18+F18+G18+H18)*(0.83/0.17)=V18*(1-L$15)*(M$21)*(O$47)39479Utility TaxNone =(E19+F19+G19+H19)*(0.83/0.17)=V19*(1-L$15)*(M$21)*(O$47)39508Utility TaxNone =(E20+F20+G20+H20)*(0.83/0.17)=V20*(1-L$15)*(M$21)*(O$47)39539Utility TaxNone =(E21+F21+G21+H21)*(0.83/0.17)=V21*(1-L$15)*(M$21)*(O$47)39569Utility TaxNone =(E22+F22+G22+H22)*(0.83/0.17)=V22*(1-L$15)*(M$21)*(O$47)39600Utility TaxNone =(E23+F23+G23+H23)*(0.83/0.17)=V23*(1-L$15)*(M$21)*(O$47)39630Utility TaxNone =(E24+F24+G24+H24)*(0.83/0.17)=V24*(1-L$15)*(M$21)*(O$47)39661Utility TaxNone =(E25+F25+G25+H25)*(0.83/0.17)=V25*(1-L$15)*(M$21)*(O$47)39692Utility TaxNone =(E26+F26+G26+H26)*(0.83/0.17)=V26*(1-L$15)*(M$21)*(O$47)39722Utility TaxNone =(E27+F27+G27+H27)*(0.83/0.17)=V27*(1-L$15)*(M$21)*(O$47)39753Utility TaxNone =(E28+F28+G28+H28)*(0.83/0.17)=V28*(1-L$15)*(M$21)*(O$47)39783Utility TaxNone =(E29+F29+G29+H29)*(0.83/0.17)=V29*(1-L$15)*(M$21)*(O$47)39814Utility TaxNone =(E30+F30+G30+H30)*(0.82/0.18)=V30*(1-M$15)*(N$21)*(P$47)39845Utility TaxNone =(E31+F31+G31+H31)*(0.82/0.18)=V31*(1-M$15)*(N$21)*(P$47)39873Utility TaxNone =(E32+F32+G32+H32)*(0.82/0.18)=V32*(1-M$15)*(N$21)*(P$47)39904Utility TaxNone =(E33+F33+G33+H33)*(0.82/0.18)=V33*(1-M$15)*(N$21)*(P$47)39934Utility TaxNone =(E34+F34+G34+H34)*(0.82/0.18)=V34*(1-M$15)*(N$21)*(P$47)39965Utility TaxNone =(E35+F35+G35+H35)*(0.82/0.18)=V35*(1-M$15)*(N$21)*(P$47)39995Utility TaxNone =(E36+F36+G36+H36)*(0.82/0.18)=V36*(1-M$15)*(N$21)*(P$47)40026Utility TaxNone =(E37+F37+G37+H37)*(0.82/0.18)=V37*(1-M$15)*(N$21)*(P$47)40057Utility TaxNone =(E38+F38+G38+H38)*(0.82/0.18)=V38*(1-M$15)*(N$21)*(P$47)40087Utility TaxNone =(E39+F39+G39+H39)*(0.82/0.18)=V39*(1-M$15)*(N$21)*(P$47)40118Utility TaxNone =(E40+F40+G40+H40)*(0.82/0.18)=V40*(1-M$15)*(N$21)*(P$47)40148Utility TaxNone =(E41+F41+G41+H41)*(0.82/0.18)=V41*(1-M$15)*(N$21)*(P$47)40179Utility TaxNone =(E42+F42+G42+H42)*(0.83/0.17)=V42*(1-N$15)*(O$21)*(Q$47)40210Utility TaxNone =(E43+F43+G43+H43)*(0.83/0.17)=V43*(1-N$15)*(O$21)*(Q$47)40238Utility TaxNone =(E44+F44+G44+H44)*(0.83/0.17)=V44*(1-N$15)*(O$21)*(Q$47)40269Utility TaxNone =(E45+F45+G45+H45)*(0.83/0.17)=V45*(1-N$15)*(O$21)*(Q$47)40299Utility TaxNone =(E46+F46+G46+H46)*(0.83/0.17)=V46*(1-N$15)*(O$21)*(Q$47)40330Utility TaxNone =(E47+F47+G47+H47)*(0.83/0.17)=V47*(1-N$15)*(O$21)*(Q$47)40360Utility TaxNone =(E48+F48+G48+H48)*(0.83/0.17)=V48*(1-N$15)*(O$21)*(Q$47)40391Utility TaxNone =(E49+F49+G49+H49)*(0.83/0.17)=V49*(1-N$15)*(O$21)*(Q$47)40422Utility TaxNone =(E50+F50+G50+H50)*(0.83/0.17)=V50*(1-N$15)*(O$21)*(Q$47)40452Utility TaxNone =(E51+F51+G51+H51)*(0.83/0.17)=V51*(1-N$15)*(O$21)*(Q$47)40483Utility TaxNone =(E52+F52+G52+H52)*(0.83/0.17)=V52*(1-N$15)*(O$21)*(Q$47)40513Utility TaxNone =(E53+F53+G53+H53)*(0.83/0.17)=V53*(1-N$15)*(O$21)*(Q$47)40544Utility TaxNone =(E54+F54+G54+H54)*(0.79/0.21)=V54*(1-O$15)*(P$21)*(R$47)40575Utility TaxNone =(E55+F55+G55+H55)*(0.79/0.21)=V55*(1-O$15)*(P$21)*(R$47)40603Utility TaxNone =(E56+F56+G56+H56)*(0.79/0.21)=V56*(1-O$15)*(P$21)*(R$47)40634Utility TaxNone =(E57+F57+G57+H57)*(0.79/0.21)=V57*(1-O$15)*(P$21)*(R$47)40664Utility TaxNone =(E58+F58+G58+H58)*(0.79/0.21)=V58*(1-O$15)*(P$21)*(R$47)40695Utility TaxNone =(E59+F59+G59+H59)*(0.79/0.21)=V59*(1-O$15)*(P$21)*(R$47)40725Utility TaxNone =(E60+F60+G60+H60)*(0.79/0.21)=V60*(1-O$15)*(P$21)*(R$47)40756Utility TaxNone =(E61+F61+G61+H61)*(0.79/0.21)=V61*(1-O$15)*(P$21)*(R$47)40787Utility TaxNone =(E62+F62+G62+H62)*(0.79/0.21)=V62*(1-O$15)*(P$21)*(R$47)40817Utility TaxNone =(E63+F63+G63+H63)*(0.79/0.21)=V63*(1-O$15)*(P$21)*(R$47)40848Utility TaxNone =(E64+F64+G64+H64)*(0.79/0.21)=V64*(1-O$15)*(P$21)*(R$47)40878Utility TaxNone =(E65+F65+G65+H65)*(0.79/0.21)=V65*(1-O$15)*(P$21)*(R$47)40909Utility TaxNone =(E66+F66+G66+H66)*(0.76/0.24)=V66*(1-P$15)*(Q$21)*(S$47)40940Utility TaxNone =(E67+F67+G67+H67)*(0.76/0.24)=V67*(1-P$15)*(Q$21)*(S$47)40969Utility TaxNone =(E68+F68+G68+H68)*(0.76/0.24)=V68*(1-P$15)*(Q$21)*(S$47)41000Utility TaxNone =(E69+F69+G69+H69)*(0.76/0.24)=V69*(1-P$15)*(Q$21)*(S$47)41030Utility TaxNone =(E70+F70+G70+H70)*(0.76/0.24)=V70*(1-P$15)*(Q$21)*(S$47)41061Utility TaxNone =(E71+F71+G71+H71)*(0.76/0.24)=V71*(1-P$15)*(Q$21)*(S$47)41091Utility TaxNone =(E72+F72+G72+H72)*(0.76/0.24)=V72*(1-P$15)*(Q$21)*(S$47)41122Utility TaxNone =(E73+F73+G73+H73)*(0.76/0.24)=V73*(1-P$15)*(Q$21)*(S$47)41153Utility TaxNone =(E74+F74+G74+H74)*(0.76/0.24)=V74*(1-P$15)*(Q$21)*(S$47)41183Utility TaxNone =(E75+F75+G75+H75)*(0.76/0.24)=V75*(1-P$15)*(Q$21)*(S$47)41214Utility TaxNone =(E76+F76+G76+H76)*(0.76/0.24)=V76*(1-P$15)*(Q$21)*(S$47)41244Utility TaxNone =(E77+F77+G77+H77)*(0.76/0.24)=V77*(1-P$15)*(Q$21)*(S$47)41275Utility TaxNone =(E78+F78+G78+H78)*(0.73/0.27)=V78*(1-Q$15)*(R$21)*(T$47)41306Utility TaxNone =(E79+F79+G79+H79)*(0.73/0.27)=V79*(1-Q$15)*(R$21)*(T$47)41334Utility TaxNone =(E80+F80+G80+H80)*(0.73/0.27)=V80*(1-Q$15)*(R$21)*(T$47)41365Utility TaxNone =(E81+F81+G81+H81)*(0.73/0.27)=V81*(1-Q$15)*(R$21)*(T$47)41395Utility TaxNone =(E82+F82+G82+H82)*(0.73/0.27)=V82*(1-Q$15)*(R$21)*(T$47)Tracfone Wireless, IncData Sheet 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182HI J K L MAPP Direct Sales Total TaxableIntra-state Without DataRevenue=U6*(1-K$15)*($L$21)*($N$47)=SUM(D6:H6)=U7*(1-K$15)*($L$21)*($N$47)=SUM(D7:H7)=U8*(1-K$15)*($L$21)*($N$47)=SUM(D8:H8) Note: Sales amounts are reduced by three f=U9*(1-K$15)*($L$21)*($N$47)=SUM(D9:H9) 1)Data is removed.=U10*(1-K$15)*($L$21)*($N$47)=SUM(D10:H10) 2)Interstate and international is removed=U11*(1-K$15)*($L$21)*($N$47)=SUM(D11:H11) 3)A factor to proportion sum of zip popula=U12*(1-K$15)*($L$21)*($N$47)=SUM(D12:H12)=U13*(1-K$15)*($L$21)*($N$47)=SUM(D13:H13)DATA:=U14*(1-K$15)*($L$21)*($N$47)=SUM(D14:H14)Year200720082009=U15*(1-K$15)*($L$21)*($N$47)=SUM(D15:H15)Data Percentage=U16*(1-K$15)*($L$21)*($N$47)=SUM(D16:H16)=U17*(1-K$15)*($L$21)*($N$47)=SUM(D17:H17)=U18*(1-L$15)*($M$21)*($O$47)=SUM(D18:H18)INTRA-STATE:=U19*(1-L$15)*($M$21)*($O$47)=SUM(D19:H19)=U20*(1-L$15)*($M$21)*($O$47)=SUM(D20:H20)Year20072008=U21*(1-L$15)*($M$21)*($O$47)=SUM(D21:H21)Intrastate Percentage0.8407 0.8407=U22*(1-L$15)*($M$21)*($O$47)=SUM(D22:H22)Interstate Percentage0.15390.1539=U23*(1-L$15)*($M$21)*($O$47)=SUM(D23:H23)International Percentage0.0054 0.0054=U24*(1-L$15)*($M$21)*($O$47)=SUM(D24:H24)Total:11=U25*(1-L$15)*($M$21)*($O$47)=SUM(D25:H25)=U26*(1-L$15)*($M$21)*($O$47)=SUM(D26:H26)=U27*(1-L$15)*($M$21)*($O$47)=SUM(D27:H27)=U28*(1-L$15)*($M$21)*($O$47)=SUM(D28:H28)POPULATION RATIO:=U29*(1-L$15)*($M$21)*($O$47)=SUM(D29:H29)=U30*(1-M$15)*($N$21)*($P$47)=SUM(D30:H30)Zip populations PER:https://www.unitedstateszipcodes.org/9817=U31*(1-M$15)*($N$21)*($P$47)=SUM(D31:H31)=U32*(1-M$15)*($N$21)*($P$47)=SUM(D32:H32)98178=U33*(1-M$15)*($N$21)*($P$47)=SUM(D33:H33)98055=U34*(1-M$15)*($N$21)*($P$47)=SUM(D34:H34)98056=U35*(1-M$15)*($N$21)*($P$47)=SUM(D35:H35)98057=U36*(1-M$15)*($N$21)*($P$47)=SUM(D36:H36)98058=U37*(1-M$15)*($N$21)*($P$47)=SUM(D37:H37)98059=U38*(1-M$15)*($N$21)*($P$47)=SUM(D38:H38)Sum:=U39*(1-M$15)*($N$21)*($P$47)=SUM(D39:H39)=U40*(1-M$15)*($N$21)*($P$47)=SUM(D40:H40)Renton Populations per:https://edocs.rentonwa.gov/Documents/0/ed=U41*(1-M$15)*($N$21)*($P$47)=SUM(D41:H41)=U42*(1-N$15)*($O$21)*($Q$47)=SUM(D42:H42)=U43*(1-N$15)*($O$21)*($Q$47)=SUM(D43:H43)Renton Populations:=U44*(1-N$15)*($O$21)*($Q$47)=SUM(D44:H44)=U45*(1-N$15)*($O$21)*($Q$47)=SUM(D45:H45)=U46*(1-N$15)*($O$21)*($Q$47)=SUM(D46:H46)=U47*(1-N$15)*($O$21)*($Q$47)=SUM(D47:H47)Population Ratios:=U48*(1-N$15)*($O$21)*($Q$47)=SUM(D48:H48)=U49*(1-N$15)*($O$21)*($Q$47)=SUM(D49:H49)=U50*(1-N$15)*($O$21)*($Q$47)=SUM(D50:H50)=U51*(1-N$15)*($O$21)*($Q$47)=SUM(D51:H51)=U52*(1-N$15)*($O$21)*($Q$47)=SUM(D52:H52)=U53*(1-N$15)*($O$21)*($Q$47)=SUM(D53:H53)=U54*(1-O$15)*($P$21)*($R$47)=SUM(D54:H54)=U55*(1-O$15)*($P$21)*($R$47)=SUM(D55:H55)=U56*(1-O$15)*($P$21)*($R$47)=SUM(D56:H56)=U57*(1-O$15)*($P$21)*($R$47)=SUM(D57:H57)=U58*(1-O$15)*($P$21)*($R$47)=SUM(D58:H58)=U59*(1-O$15)*($P$21)*($R$47)=SUM(D59:H59)=U60*(1-O$15)*($P$21)*($R$47)=SUM(D60:H60)=U61*(1-O$15)*($P$21)*($R$47)=SUM(D61:H61)=U62*(1-O$15)*($P$21)*($R$47)=SUM(D62:H62)=U63*(1-O$15)*($P$21)*($R$47)=SUM(D63:H63)=U64*(1-O$15)*($P$21)*($R$47)=SUM(D64:H64)=U65*(1-O$15)*($P$21)*($R$47)=SUM(D65:H65)=U66*(1-P$15)*($Q$21)*($S$47)=SUM(D66:H66)=U67*(1-P$15)*($Q$21)*($S$47)=SUM(D67:H67)=U68*(1-P$15)*($Q$21)*($S$47)=SUM(D68:H68)=U69*(1-P$15)*($Q$21)*($S$47)=SUM(D69:H69)=U70*(1-P$15)*($Q$21)*($S$47)=SUM(D70:H70)=U71*(1-P$15)*($Q$21)*($S$47)=SUM(D71:H71)=U72*(1-P$15)*($Q$21)*($S$47)=SUM(D72:H72)=U73*(1-P$15)*($Q$21)*($S$47)=SUM(D73:H73)=U74*(1-P$15)*($Q$21)*($S$47)=SUM(D74:H74)=U75*(1-P$15)*($Q$21)*($S$47)=SUM(D75:H75)=U76*(1-P$15)*($Q$21)*($S$47)=SUM(D76:H76)=U77*(1-P$15)*($Q$21)*($S$47)=SUM(D77:H77)=U78*(1-Q$15)*($R$21)*($T$47)=SUM(D78:H78)=U79*(1-Q$15)*($R$21)*($T$47)=SUM(D79:H79)=U80*(1-Q$15)*($R$21)*($T$47)=SUM(D80:H80)=U81*(1-Q$15)*($R$21)*($T$47)=SUM(D81:H81)=U82*(1-Q$15)*($R$21)*($T$47)=SUM(D82:H82) 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182N OPQRST201020112012201320140.03960.18650.25080.38420.41772009201020112012201320140.84070.85730.83970.83380.81090.79330.15390.14110.15580.15680.17170.19330.00540.00160.00450.00940.01740.01341111112007 2008 2009 2010 2011 2012 201321974 21695 21717 22174 22343 23090 2314020151 19888 20228 20603 19865 19890 2019030295 30562 31751 31912 32733 33200 329609813 9768 10621 11305 11631 11680 1176041080 40762 41061 41326 40371 40450 4080032156 32741 33745 34618 35108 35770 36470=SUM(N32:N37) =SUM(O32:O37) =SUM(P32:P37) =SUM(Q32:Q37) =SUM(R32:R37) =SUM(S32:S37) =SUM(T32:T37)(Page 7-7)2007 2008 2009 2010 2011 2012 201360290 78780 83650 90927 92590 93910 955402007 2008 2009 2010 2011 2012 2013=N43/N38=O43/O38=P43/P38=Q43/Q38=R43/R38=S43/S38=T43/T38 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182UVWBillingInternet/DirectPlatformSales Sales5169.09390894739.22391205424.01391484699.11391794004.25392095104.02 24.94 392404954.0924.94 392704699.1139.89 393015823.99144.9 393325069.07 164.87 393627033.74 154.79393936663.8 185.73394234509.11188.8 394546034.06155.79394856063.98277.63395145481.05236.69395455788.06366.34 395755389.04 280.67 396065299.07 502.56396365164 489.59396675629.05469.61 396985704.15436.56397285734.06523.59397596513.89656.47 397896429.04 839.41 398204799.29905.33398516943.86966.3 398796694.07 1167.23399108283.75985.23399407658.781164.29399717528.791449.19400017473.91252.34 400328123.751123.31400637033.911363.26400936763.91583.22 401248018.561871.12 401547248.582661.26401856968.852591.33402167633.733652.34 402447448.663598 402757233.683974.2 403057048.754565.03403369403.395280.86403668598.465615.18403977788.66299.16404287718.54 7163.02 404588343.517253.02 404899843.498639.954051910308 8942.07 405508708.499131.85405819538.269908.03406099163.37 10242.964064010339.1310935.78406708612.2 10760.8407019906.22 10143.954073111505.910529.054076212209.219821.94 4079311624.948443.714082313248.057838.72 4085413538.7 7741.854088414910.647561.034091515007.858232.954094615813.188626.954097516001.788876.954100614869.39139.07 4103616809.259560.07 4106718521.2 10126.024109717725.4 10358.054112818802.0210299 4115918583.5512596.424118917825.1913122.744122019256.5113669.654125019485.4 15071.664128120032.7714583.814131219402.1317815.794134017944.0418288.254137129495.7719673.1741401 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:Year20072008200920102011201220132014Data Percentage0.03960.18650.25080.38420.4177INTRA-STATE:Year20072008200920102011201220132014Intrastate Percentage84.07% 84.07%84.07%85.73%83.97%83.38%81.09%79.33%Interstate Percentage15.39% 15.39%15.39%14.11%15.58%15.68%17.17%19.33%International Percentage0.54% 0.54%0.54%0.16%0.45%0.94%1.74%1.34%Total:100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%POPULATION RATIO:Zip populations PERhttps://www.unitedstateszipcodes.org/98178/2007 2008 2009 2010 2011 2012 20139817821974 21695 21717 22174 22343 23090 231409805520151 19888 20228 20603 19865 19890 201909805630295 30562 31751 31912 32733 33200 32960980579813 9768 10621 11305 11631 11680 117609805841080 40762 41061 41326 40371 40450 408009805932156 32741 33745 34618 35108 35770 36470Sum:155469 155416 159123 161938 162051 164080 165320Renton Populations phttps://edocs.rentonwa.gov/Documents/0/edoc/956723/2016%20CAFR%20-%20City%20of%20Renton,%20WA.pdf(Page 7-7)2007 2008 2009 2010 2011 2012 2013Renton Populations60290 78780 83650 90927 92590 93910 955402007 2008 2009 2010 2011 2012 2013Population Ratios0.387794351 0.506897617 0.52569396 0.56149267 0.571363336 0.57234276 0.577909509 Billing Internet/Direct Platform Sales Sales $5,169.09 01/07/07 $4,739.22 02/07/07 $5,424.01 03/07/07 $4,699.11 04/07/07 $4,004.25 05/07/07 $5,104.02 24.94 06/07/07 $4,954.09 24.94 07/07/07 $4,699.11 39.89 08/07/07 $5,823.99 $144.90 09/07/07 $5,069.07 $164.87 10/07/07 $7,033.74 $154.79 11/07/07 $6,663.80 $185.73 12/07/07 $4,509.11 $188.80 01/07/08 $6,034.06 $155.79 02/07/08 $6,063.98 $277.63 03/07/08 $5,481.05 $236.69 04/07/08 $5,788.06 $366.34 05/07/08 $5,389.04 $280.67 06/07/08 $5,299.07 $502.56 07/07/08 $5,164.00 $489.59 08/07/08 $5,629.05 $469.61 09/07/08 $5,704.15 $436.56 10/07/08 $5,734.06 $523.59 11/07/08 $6,513.89 $656.47 12/07/08 $6,429.04 $839.41 01/07/09 $4,799.29 $905.33 02/07/09 $6,943.86 $966.30 03/07/09 $6,694.07 $1,167.23 04/07/09 $8,283.75 $985.23 05/07/09 $7,658.78 $1,164.29 06/07/09 $7,528.79 $1,449.19 07/07/09 $7,473.90 $1,252.34 08/07/09 $8,123.75 $1,123.31 09/07/09 $7,033.91 $1,363.26 10/07/09 $6,763.90 $1,583.22 11/07/09 $8,018.56 $1,871.12 12/07/09 $7,248.58 $2,661.26 01/07/10 $6,968.85 $2,591.33 02/07/10 $7,633.73 $3,652.34 03/07/10 $7,448.66 $3,598.00 04/07/10 $7,233.68 $3,974.20 05/07/10 $7,048.75 $4,565.03 06/07/10 $9,403.39 $5,280.86 07/07/10 $8,598.46 $5,615.18 08/07/10 $7,788.60 $6,299.16 09/07/10 $7,718.54 $7,163.02 10/07/10 $8,343.51 $7,253.02 11/07/10 $9,843.49 $8,639.95 12/07/10 $10,308.00 $8,942.07 01/07/11 $8,708.49 $9,131.85 02/07/11 $9,538.26 $9,908.03 03/07/11 $9,163.37 $10,242.96 04/07/11 $10,339.13 $10,935.78 05/07/11 $8,612.20 $10,760.80 06/07/11 $9,906.22 $10,143.95 07/07/11 $11,505.90 $10,529.05 08/07/11 $12,209.21 $9,821.94 09/07/11 $11,624.94 $8,443.71 10/07/11 $13,248.05 $7,838.72 11/07/11 $13,538.70 $7,741.85 12/07/11 $14,910.64 $7,561.03 01/07/12 $15,007.85 $8,232.95 02/07/12 $15,813.18 $8,626.95 03/07/12 $16,001.78 $8,876.95 04/07/12 $14,869.30 $9,139.07 05/07/12 $16,809.25 $9,560.07 06/07/12 $18,521.20 $10,126.02 07/07/12 $17,725.40 $10,358.05 08/07/12 $18,802.02 $10,299.00 09/07/12 $18,583.55 $12,596.42 10/07/12 $17,825.19 $13,122.74 11/07/12 $19,256.51 $13,669.65 12/07/12 $19,485.40 $15,071.66 01/07/13 $20,032.77 $14,583.81 02/07/13 $19,402.13 $17,815.79 03/07/13 $17,944.04 $18,288.25 04/07/13 $29,495.77 $19,673.17 05/07/13 RevenueNon-Direct Sales Billing Platform SalesPage Plus AirPage PlusAPP Direct Sales Total TaxableMO/YRCATEGORYReportedIntra-state Without Data Intra-state Without Data Intra-state Without Data Intra-state Without Data Intra-state Without DataRevenueJan-07 Utility TaxNone $7,677.11$1,685.22 $9,362.33Feb-07 Utility TaxNone $7,038.65$1,545.07 $8,583.72Mar-07 Utility TaxNone $8,055.73$1,768.33 $9,824.06Apr-07 Utility TaxNone $6,979.11$1,532.00 $8,511.11May-07 Utility TaxNone $5,947.10$1,305.46$7,252.56Jun-07 Utility TaxNone $7,617.53 $8.13 $1,664.01 $9,289.67Jul-07 Utility TaxNone $7,394.85 $8.13 $1,615.13 $9,018.11Aug-07 Utility TaxNone $7,038.33 $13.00 $1,532.00 $8,583.33Sep-07 Utility TaxNone $8,864.97 $47.24 $1,898.73 $10,810.94Oct-07 Utility TaxNone $7,773.42 $53.75 $1,652.61 $9,479.78Nov-07 Utility TaxNone $10,676.35$50.46 $2,293.13 $13,019.94Dec-07 Utility TaxNone $10,172.87 $60.55 $2,172.52 $12,405.94Jan-08 Utility TaxNone $9,774.52 $80.46 $1,921.55 $11,776.53Feb-08 Utility TaxNone $12,878.67 $66.39 $2,571.41 $15,516.47Mar-08 Utility TaxNone $13,194.41 $118.31 $2,584.16$15,896.88Apr-08 Utility TaxNone $11,896.39$100.87 $2,335.74 $14,333.00May-08 Utility TaxNone $12,804.90 $156.12 $2,466.57 $15,427.59Jun-08 Utility TaxNone $11,796.45$119.61 $2,296.53 $14,212.59Jul-08 Utility TaxNone $12,070.93$214.17 $2,258.19$14,543.29Aug-08 Utility TaxNone $11,762.91 $208.64 $2,200.63 $14,172.18Sep-08 Utility TaxNone $12,688.89$200.12 $2,398.81 $15,287.82Oct-08 Utility TaxNone $12,776.43$186.04 $2,430.82 $15,393.29Nov-08 Utility TaxNone $13,019.72 $223.13 $2,443.56$15,686.41Dec-08 Utility TaxNone $14,918.71 $279.75 $2,775.89$17,974.35Jan-09 Utility TaxNone $14,633.81 $370.98 $2,841.32 $17,846.11Feb-09 Utility TaxNone $11,485.28 $400.11 $2,121.05 $14,006.44Mar-09 Utility TaxNone $15,925.81 $427.06 $3,068.85 $19,421.72Apr-09 Utility TaxNone $15,827.41 $515.86 $2,958.45 $19,301.72May-09 Utility TaxNone $18,661.51 $435.42 $3,661.01 $22,757.94Jun-09 Utility TaxNone $17,763.75$514.56 $3,384.80 $21,663.11Jul-09 Utility TaxNone $18,075.67 $640.47 $3,327.36$22,043.50Aug-09 Utility TaxNone $17,568.82 $553.47 $3,303.10 $21,425.39Sep-09 Utility TaxNone $18,617.42 $496.45 $3,590.30 $22,704.17Oct-09 Utility TaxNone $16,906.26$602.49 $3,108.64 $20,617.39Nov-09 Utility TaxNone $16,805.54 $699.71 $2,989.31 $20,494.56Dec-09 Utility TaxNone $19,911.19$826.94 $3,543.81 $24,281.94Jan-10 Utility TaxNone $22,367.91 $1,230.32 $3,351.06$26,949.29Feb-10 Utility TaxNone $21,578.68 $1,197.99$3,221.74 $25,998.41Mar-10 Utility TaxNone $25,474.26$1,688.50 $3,529.12 $30,691.88Apr-10 Utility TaxNone $24,933.88 $1,663.38 $3,443.56$30,040.82May-10 Utility TaxNone $25,297.72 $1,837.29$3,344.17 $30,479.18Jun-10 Utility TaxNone $26,213.94 $2,110.44 $3,258.68 $31,583.06Jul-10 Utility TaxNone $33,144.39$2,441.37 $4,347.24 $39,933.00Aug-10 Utility TaxNone $32,082.19$2,595.93 $3,975.12 $38,653.24Sep-10 Utility TaxNone $31,798.03$2,912.14 $3,600.71 $38,310.88Oct-10 Utility TaxNone $33,589.71 $3,311.50 $3,568.32 $40,469.53Nov-10 Utility TaxNone $35,203.52 $3,353.11 $3,857.25 $42,413.88Dec-10 Utility TaxNone $41,719.71 $3,994.30 $4,550.70 $50,264.71Jan-11 Utility TaxNone $28,264.02 $3,490.05 $4,023.17 $35,777.24Feb-11 Utility TaxNone $26,194.18 $3,564.12 $3,398.89$33,157.19Mar-11 Utility TaxNone $28,552.10 $3,867.06$3,722.74 $36,141.90Apr-11 Utility TaxNone $28,493.49$3,997.79$3,576.43 $36,067.71May-11 Utility TaxNone $31,237.01 $4,268.19$4,035.32 $39,540.52Tracfone Wireless, IncData Sheet RevenueNon-Direct Sales Billing Platform SalesPage Plus AirPage PlusAPP Direct Sales Total TaxableMO/YRCATEGORYReportedIntra-state Without Data Intra-state Without Data Intra-state Without Data Intra-state Without Data Intra-state Without DataRevenueTracfone Wireless, IncData SheetJun-11 Utility TaxNone $28,444.55$4,199.90 $3,361.31 $36,005.76Jul-11 Utility TaxNone $29,438.79$3,959.14 $3,866.36$37,264.29Aug-11 Utility TaxNone $32,352.98 $4,109.45 $4,490.71 $40,953.14Sep-11 Utility TaxNone $32,347.38 $3,833.46$4,765.21 $40,946.05Oct-11 Utility TaxNone $29,465.95$3,295.55 $4,537.17 $37,298.67Nov-11 Utility TaxNone $30,960.78 $3,059.42 $5,170.66$39,190.86Dec-11 Utility TaxNone $31,245.29$3,021.61 $5,284.10 $39,551.00Jan-12 Utility TaxNone $25,442.14 $2,703.32 $5,331.04 $33,476.50Feb-12 Utility TaxNone $26,312.94 $2,943.55 $5,365.80 $34,622.29Mar-12 Utility TaxNone $27,670.81 $3,084.42 $5,653.73 $36,408.96Apr-12 Utility TaxNone $28,167.37 $3,173.80 $5,721.16$37,062.33May-12 Utility TaxNone $27,181.97 $3,267.52 $5,316.26$35,765.75Jun-12 Utility TaxNone $29,855.02 $3,418.04 $6,009.86$39,282.92Jul-12 Utility TaxNone $32,434.01 $3,620.38 $6,621.94 $42,676.33Aug-12 Utility TaxNone $31,795.71 $3,703.34 $6,337.41 $41,836.46Sep-12 Utility TaxNone $32,947.81 $3,682.23 $6,722.34 $43,352.38Oct-12 Utility TaxNone $35,301.56$4,503.63 $6,644.23 $46,449.42Nov-12 Utility TaxNone $35,038.85$4,691.81 $6,373.09$46,103.75Dec-12 Utility TaxNone $37,278.57 $4,887.35 $6,884.83 $49,050.75Jan-13 Utility TaxNone $26,962.66$4,349.39$5,623.10 $36,935.15Feb-13 Utility TaxNone $27,009.08 $4,208.60 $5,781.06$36,998.74Mar-13 Utility TaxNone $29,038.75$5,141.29$5,599.07 $39,779.11Apr-13 Utility TaxNone $28,269.74 $5,277.63 $5,178.30 $38,725.67May-13 Utility TaxNone $38,363.37 $5,677.29$8,511.90 $52,552.56