TENNESSEE DEPARTMENT OF REVENUE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          
            SUMMARY OF COLLECTIONS       
June 2007      PAGE # 3  
CLASS OF TAX 2006 2007 GAIN OR LOSS PER CENT    
FRANCHISE          
11401-11403 Tax 91,512,056.70 104,728,682.26      
TOTAL 91,512,056.70 104,728,682.26 13,216,625.56 14.44%  
EXCISE          
11501-11503 Tax 164,347,112.83 194,822,421.50      
TOTAL 164,347,112.83 194,822,421.50 30,475,308.67 18.54%  
INCOME          
10601  Pre-Income Tax  (2,514,866.31) (216,958.00)      
10602  6% Tax 4,321,337.23 1,881,445.20      
10603  Penalties & Interest 177,653.47 220,646.04      
TOTAL 1,984,124.39 1,885,133.24 (98,991.15) -4.99%  
INHERITANCE,GIFT,ESTATE          
11601  Inheritance 3,897,865.07 12,889,885.80      
11602 Gift Tax Class A 799,223.64 646,786.25      
11603  Estate Tax (36,569.75) 54,920.74      
11604 Generation Skip 221.44 0.00      
11605 Gift Tax Class B 40,537.78 80,381.92      
11606 Pre-Gift Tax (44,489.00) (181,628.00)      
11607 Prepaid Inheritance 54,443.79 (408,479.96)      
TOTAL 4,711,232.97 13,081,866.75 8,370,633.78 177.67%  
GASOLINE          
10201 Tax 50,964,414.24 51,901,572.28      
10202 Gasoline Highway Users 0.00 0.00      
10203 Hwy. Users Fuel Permits 13,500.00 13,500.00      
10204 Crude Oil & Natural Gas 0.00 0.00      
10205 Penalty & Interest-Reg 4,808.06 4,224.57      
10206 Penalty & Interest-Hwy. Users 0.00 0.00      
10207 Alcohol Fees 0.00 0.00      
TOTAL 50,982,722.30 51,919,296.85 936,574.55 1.84%  
PETROLEUM SPECIAL TAX          
10401 Tax 3,988,196.88 4,010,738.67      
10402 Penalties & Interest 656.32 989.89      
10403 Environment Assurance Fee 1,551,426.11 1,555,199.96      
TOTAL 5,540,279.31 5,566,928.52 26,649.21 0.48%  
TOBACCO          
11801 Cigarette Stamps 9,577,988.68 14,201,143.99      
11802 Cigar & Other Tobacco Products 865,539.01 (1,001,066.60)      
11803 Fair Trade Info 24,895.48 36,405.53      
11804 Licenses-Retail Dealer 240.00 300.00      
11805 Licenses-Other 30.00 20.00      
11806 Contraband (All Types) 0.00 0.00      
11807 Confiscated Tobacco Products 0.00 0.00      
11808 Penalty (6,251.58) 36,422.61      
TOTAL 10,462,441.59 13,273,225.53 2,810,783.94 26.87%  
BEER          
10901 Beer Barrellage 1,702,053.20 1,651,252.00      
10902 Certificate of Registration 40.00 0.00      
10903 Transportation Permits 0.00 0.00      
10904 Contraband 0.00 0.00      
10905 Penalty & Interest 1,922.68 908.00      
10906 Wholesale Beer 56,639.29 47,938.55      
10907 Wholesale License 0.00 0.00      
10908 Common Carrier Beer Tax 65.30 189.63      
TOTAL 1,760,720.47 1,700,288.18 (60,432.29) -3.43%  
  TENNESSEE DEPARTMENT OF REVENUE      
           SUMMARY OF COLLECTIONS      
June 2007      PAGE # 4  
CLASS OF TAX 2006 2007 GAIN OR LOSS PER CENT  
MOTOR VEHICLE REGISTRATION          
10501 Registration Fees 15,627,885.17 15,935,126.68      
10502 Drive-Out Tags 516,329.00 431,612.50      
10503 Temp. Operators Permits 4,167.50 3,486.00      
10504 Fines 30,322.01 10,530.28      
10505 Miscellaneous 30,014.44 341.34      
10506 International Registration 8,340,656.57 8,626,115.66      
10507 Personalized Registration 70,180.00 25,224.00      
10508 Handicapped Registration 19,290.00 11,475.00      
10509 Over Weight Truck Fines 79,974.08 89,061.95      
10510 Inquiry Information Fees 2,897.00 2,263.50      
10511 Fleet Registration (6,286.69) 92,828.10      
10512 Trip Permits 27,000.00 0.00      
10513 International Reg.(IFTA) 0.00 0.00      
10514 International Reg. (Safety) 209,653.61 216,829.00      
10515 International Reg. (Revenue) 0.00 0.00      
10521 International Reg. (Safety Fees) 0.00 0.00      
TOTAL 24,952,082.69 25,444,894.01 492,811.32 1.98%  
MOTOR VEHICLE TITLE  993,116.75 962,379.80      
TOTAL 993,116.75 962,379.80 (30,736.95) -3.09%  
MIXED DRINK          
11101 Tax 4,362,647.67 4,638,365.83      
11102 Licenses 0.00 0.00      
TOTAL 4,362,647.67 4,638,365.83 275,718.16 6.32%  
BUSINESS          
12001 Counties Tax 9,329,966.09 8,861,642.26      
12002 Cities Tax 10,768,460.36 12,271,881.19      
12003 State Tax 83,651,740.50 94,829,015.00      
12004 County Delinquent 177,997.26 432,668.05      
12005 City Delinquent 130,698.79 362,259.99      
TOTAL 104,058,863.00 116,757,466.49 12,698,603.49 12.20%  
PRIVILEGE          
10701 Realty Transfer 14,127,788.79 14,613,525.38      
10702 Co. Officials Retirement Fees 90,976.50 88,598.00      
10703 Civil or City Court (588.17) 3,566.06      
10704 Criminal Cases 444.79 0.00      
10705 Education 55.85 0.00      
10706 Criminal Injuries Comp 326,870.35 205,444.66      
10707 Penalties (46,214.34) 24,233.97      
10708 Attorneys Reimbursement 76.78 0.00      
10709 Marriage License 101,378.41 84,264.28      
10710 Tire Tax 31,432.38 12,916.06      
10711 General Sessions Tax 9.22 0.00      
10712 Gen. Sess. Judges Retirement 0.00 0.00      
10713 Professional Tax 23,393,916.23 30,933,265.20      
10714 Used Oil 1,090.97 238.53      
10715 Auto Rental Surcharge 17,931.71 38,296.90      
10716 Realty Mortgage 6,490,793.49 7,073,250.18      
10717 UCC 600,943.05 635,238.03      
10718 Attorneys Administrative Fee 114,698.13 103,281.04      
10719 Forfeiture of Bonds 41,129.33 47,582.23      
10720 Sex Offenders 10,947.39 3,555.03      
10721 Domestic Violence 637.27 287.74      
10722 Civil/Legal Rep. Indigents  70.78 0.00      
10723 Fingerprinting 10,949.83 0.00      
10724 Public Defender (656.51) 0.00      
10725 1992 Increase (273.56) 0.00      
10726 Bail Bond Fee 26,110.56 13,253.71      
10727 Aggravated Assault 4,568.98 3,425.73      
10728 Marriage License Increase 2002 208,808.06 208,783.99      
10729 Drug Violation Cases 11,076.13 13,978.76      
10730 Sexual Assault 4,039.67 6,754.74      
10731 Drug Violation -No Treatment 134,023.86 125,098.94      
10732 Driving While Impaired 8,538.88 9,594.52      
10733 Municipal Training Education 24,662.93 29,815.36      
10734 Blood Alcohol  70,443.20 90,353.66      
10735 Litigation 2,013,125.34 1,755,937.26      
TOTAL 47,819,806.28 56,124,539.96 8,304,733.68 17.37%  
  TENNESSEE DEPARTMENT OF REVENUE      
            SUMMARY OF COLLECTIONS      
June 2007      PAGE # 5  
CLASS OF TAX 2006 2007 GAIN OR LOSS PER CENT  
GROSS RECEIPTS          
10801 Bottlers (180,014.68) (1,583.81)      
10802 Gas, Water, Power & Light 1,045,054.64 0.00      
10803 Mixing Bars, Clubs, etc. 13,036.01 8,614.44      
10804 Public Utilities - Other 0.00 0.00      
10805 Telephone & Telegraph 0.00 0.00      
10806 Theatres 0.00 0.00      
10807 Fire Arms 0.00 0.00      
10809 Vending Machines 408.07 0.00      
10810 Bottlers (48,027.97) 1,202.66      
10811 Vending Registration 4.00 17.04      
10812 Vending Decals 200.00 46.13      
TOTAL 830,660.07 8,296.46 (822,363.61) -99.00%  
TVA IN LIEU 18,344,253.32 21,114,561.35      
TOTAL 18,344,253.32 21,114,561.35 2,770,308.03 15.10%  
ALCOHOLIC BEVERAGES          
11001 Alcohol Tax 2,505,831.10 2,585,513.52      
11002 Wine Tax 747,442.90 803,895.48      
11003 Licenses 4,000.00 4,000.00      
11004 Permits 0.00 0.00      
11005 Confiscated Equip. Rolling 0.00 0.00      
11006 Confiscated Prop. Other 0.00 0.00      
11007 Confiscated Alcoholic Bevg. Sale 0.00 0.00      
11008 Confisc. Alcoholic Bevg. Tax Pd 0.00 0.00      
11009 Conf. Alcohol Bev. City & Cty 90% 0.00 0.00      
11010 Conf. Vehicles City & Cnty 50% 0.00 0.00      
11011 Brand Registration 192,330.23 212,613.40      
11012 Tn. Wine 0.00 0.00      
11013 Wine Tax 20,021.41 22,499.67      
11014 Common Spirit Tax 748.64 602.36      
11015 Common Spirit Wine Tax 328.18 319.74      
11016 Distiller'sTax 852.00 1,527.00      
11017 Enforcement Tax 33,654.22 38,153.89      
11018 Wine Enforcement Tax 34,863.35 34,796.01      
TOTAL 3,540,072.03 3,703,921.07 163,849.04 4.63%  
COIN AMUSEMENT           
11901 Coin Tax 60,900.00 31,330.00      
11902 Penalty & Interest 0.00 0.00       
11903 Confiscated 0.00 0.00      
11904 License Fee 29,500.00 34,500.00      
11905 License Fee Penalty & Interest 0.00 0.00      
TOTAL 90,400.00 65,830.00 (24,570.00) -27.18%  
SALES -  10101 Sales  473,508,685.60 496,006,122.10      
10102 State Cable TV 2,126,138.99 2,341,075.77      
10103 State Interstate Telecomm Sales 2,531,177.27 1,926,425.38      
10104 State Sales 1% Increase 2002 71,361,705.76 74,935,189.31      
10105 State Sales Single Article 4,344,026.45 5,237,208.61      
TOTAL 553,871,734.07 580,446,021.17 26,574,287.10 4.80%  
MOTOR VEHICLE FUEL          
10301 Tax Regular Diesel 14,054,783.09 16,164,114.33      
10302 Regular L. P. 17,896.56 17,522.70      
10303 Hwy. Users Diesel 0.00 0.00      
10304 Hwy. L. P. 0.00 0.00       
10305 Prepaid Diesel 0.00 0.00      
10306 Penalty & Interest Hwy. Users 0.00 0.00      
10307 Penalty & Interest-Reg. 4,013.71 7,188.83      
10308 Dyed Fuel 101.82 2,990.05      
TOTAL 14,076,795.18 16,191,815.91 2,115,020.73 15.02%  
Coal Severance           
11201-11202 Tax 47,394.43 37,705.23      
TOTAL 47,394.43 37,705.23 (9,689.20) -20.44%  
Gas & Oil Severance           
11301-11302 Tax 106,710.08 140,212.27      
TOTAL 106,710.08 140,212.27 33,502.19 31.40%  
Unauthorized Substance          
14801 Marijuana 27,318.81 31,278.77      
14802 Cocaine 4,536.47 2,975.02      
14803 Other Drugs 26,163.96 21,174.07      
14804 Alcohol 155.62 884.64      
14805 Penalty & Interest 15,208.84 31,791.58      
14806 Stamps 286.50 0.00      
TOTAL 73,670.20 88,104.08 14,433.88 19.59%  
          GRAND TOTAL 1,104,468,896.33 1,212,701,956.46 108,233,060.13 9.80%  
 
 
 
 
 
 
MACRO: Z  
/REB6..B6~  
/REC6..C6~  
/REB9..B9~  
/REC9..C9~  
/REB12..B12~  
/REC12..C12~  
/REB15..B17~  
/REC15..C17~  
/REB20..B21~  
 
/REB24..B30~  
/REC24..C30~  
/REB33..B35~  
/REC33..C35~  
/REB38..B45~  
/REC38..C45~  
/REB54..B58~  
/REC54..C58~  
/REB61..B70~  
/REC61..C70~  
/REB71..B71~  
/REC71..B71~  
/REB73..B73~  
/REC73..C73~  
/REB76..B77~  
/REC76..C77~  
/REB80..B84~  
/REc80..c84~  
/REb87..b101~  
/REC87..C101~  
/REB110..B120~  
/REC110..C120~  
/REB123..B134~  
/REC123..C134~  
/REB134..B134~  
/REC136..C138~  
/REB136..B138~  
/REC136..C136~  
/REb140..b140~  
/REC140..C140~  
/REB142..B143~  
/REC142..C143~  
/REC146..C152~  
/REB146..B152~  
/REB154..B155~  
/REC154..C155~