|
City of Louisville, Colorado
<br />2021 Revenue Projection Dashboard - All Funds
<br />Projections As Of September 17, 2021
<br />Revenue
<br />Category
<br />2021
<br />Budget
<br />2021
<br />Projection
<br />Variance
<br />Amount Percent
<br />2020
<br />Actual
<br />2021
<br />Projection
<br />Variance
<br />Amount Percent
<br />Property Tax
<br />5,530,050
<br />5,519,890
<br />(10,160)
<br />-0.2%
<br />5,441,278
<br />5,519,890
<br />78,612
<br />1.4%
<br />Sales Tax
<br />16,007,490
<br />17,328,890
<br />1,321,400
<br />8.3%
<br />15,753,538
<br />17,328,890
<br />1,575,352
<br />10.0%
<br />Consumer Use Tax
<br />1,709,960
<br />1,707,780
<br />(2,180)
<br />-0.1%
<br />1,658,024
<br />1,707,780
<br />49,756
<br />3.0%
<br />Auto Use Tax
<br />1,497,390
<br />1,785,500
<br />288,110
<br />19.2%
<br />1,519,565
<br />1,785,500
<br />265,935
<br />17.5%
<br />Building Use Tax
<br />1,896,860
<br />1,797,570
<br />(99,290)
<br />-5.2%
<br />1,703,698
<br />1,797,570
<br />93,872
<br />5.5%
<br />Lodging Tax
<br />227,360
<br />228,200
<br />840
<br />0.4%
<br />182,557
<br />228,200
<br />45,643
<br />25.0%
<br />Specific Ownership Tax
<br />247,320
<br />283,750
<br />36,430
<br />14.7%
<br />275,487
<br />283,750
<br />8,263
<br />3.0%
<br />Franchise & Telephone Tax
<br />1,014,470
<br />1,094,980
<br />80,510
<br />7.9%
<br />1,011,685
<br />1,094,980
<br />83,295
<br />8.2%
<br />Marijuana Tax
<br />170,850
<br />220,610
<br />49,760
<br />29.1%
<br />180,091
<br />220,610
<br />40,519
<br />22.5%
<br />Construction Permits
<br />1,047,000
<br />925,000
<br />(122,000)
<br />-11.7%
<br />786,420
<br />925,000
<br />138,580
<br />17.6%
<br />Court Fines
<br />115,510
<br />63,960
<br />(51,550)
<br />-44.6%
<br />85,275
<br />63,960
<br />(21,315)
<br />-25.0%
<br />Highway Users Tax
<br />554,480
<br />554,480
<br />-
<br />0.0%
<br />558,725
<br />554,480
<br />(4,245)
<br />-0.8%
<br />Rec Ctr Membership Fees
<br />570,990
<br />901,120
<br />330,130
<br />57.8%
<br />600,148
<br />901,120
<br />300,972
<br />50.1%
<br />Rec Ctr Daily User Fees
<br />47,730
<br />109,400
<br />61,670
<br />129.2%
<br />54,125
<br />109,400
<br />55,275
<br />102.1%
<br />Rec Ctr Swim Lessons
<br />15,660
<br />47,090
<br />31,430
<br />200.7%
<br />20,794
<br />47,090
<br />26,296
<br />126.5%
<br />Rec Ctr Youth Activity Fees
<br />72,000
<br />247,960
<br />175,960
<br />244.4%
<br />100,972
<br />247,960
<br />146,988
<br />145.6%
<br />Rec Ctr Youth Sports Fees
<br />36,370
<br />111,380
<br />75,010
<br />206.2%
<br />33,097
<br />111,380
<br />78,283
<br />236.5%
<br />State Lottery Proceeds
<br />227,200
<br />251,560
<br />24,360
<br />10.7%
<br />218,749
<br />251,560
<br />32,811
<br />15.0%
<br />Impact Fees
<br />661,550
<br />251,000
<br />(410,550)
<br />-62.1%
<br />610,561
<br />251,000
<br />(359,561)
<br />-58.9%
<br />Water User Fees
<br />5,890,000
<br />5,890,120
<br />120
<br />0.0%
<br />6,757,536
<br />5,890,120
<br />(867,416)
<br />12.8%
<br />Water Tap Fees
<br />2,994,530
<br />1,550,300
<br />(1,444,230)
<br />-48.2%
<br />2,148,976
<br />1,550,300
<br />L (598,676)
<br />-27.9%
<br />Wastewater User Fees
<br />3,800,000
<br />3,819,850
<br />19,850
<br />0.5%
<br />4,018,515
<br />3,819,850
<br />1 (198,665)
<br />-4.9%
<br />Wastewater Tap Fees
<br />319,500
<br />150,000
<br />(169,500)
<br />-53.1%
<br />245,560
<br />150,000
<br />(95,560)
<br />-38.9%
<br />Storm Water User Fees
<br />984,000
<br />991,000
<br />7,000
<br />0.7%
<br />979,964
<br />991,000
<br />11,036
<br />1.1%
<br />Golf Course Operating Revenue
<br />1,856,860
<br />2,167,910
<br />311,050
<br />16.8%
<br />1,932,209
<br />2,167,910
<br />235,701
<br />12.2%
<br />Solid Waste & Recycling Fees
<br />1,418,970
<br />1,418,970
<br />-
<br />0.0%
<br />1,413,012
<br />1,418,970
<br />5,958
<br />0.4%
<br />Orange = Department Projection
<br />Green = Positive Variance exceeding $100,000 and/or 5%
<br />White = Neutral Variance within $100,000 and/or 5%
<br />Red I = Negative Variance exceeding $100,000 and/or 5%
<br />City of Louisville, Colorado
<br />2021 Revenue Projection Dashboard - General Fund
<br />Projections As Of September 17, 2021
<br />Revenue
<br />Category
<br />2021
<br />Budget
<br />2021 Variance
<br />Projection Amount Percent
<br />2020
<br />Actual
<br />2021
<br />Projection
<br />Variance
<br />Amount Percent
<br />Property Tax
<br />3,613,280
<br />3,606,640 (6,640) -0.2%
<br />3,554,671
<br />3,606,640
<br />51,969
<br />1.5%
<br />Sales Tax
<br />8,775,540
<br />9,495,370 719,830 8.2%
<br />8,632,156
<br />9,495,370
<br />863,214
<br />10.0%
<br />Consumer Use Tax
<br />940,090
<br />940,570 480 0.1%
<br />913,170
<br />940,570
<br />27,400
<br />3.0%
<br />Auto Use Tax
<br />1,230,730
<br />1,467,530 236,800 19.2%
<br />1,248,957
<br />1,467,530
<br />218,573
<br />17.5%
<br />Lodging Tax
<br />227,360
<br />228,200 840 0.4%
<br />182,557
<br />228,200
<br />45,643
<br />25.0%
<br />Specific Ownership Tax
<br />247,320
<br />283,750 36,430 14.7%
<br />275,487
<br />283,750
<br />8,263
<br />3.0%
<br />Franchise & Telephone Tax
<br />1,014,470
<br />1,094,980 80,510 7.9%
<br />1,011,685
<br />1,094,980
<br />83,295
<br />8.2%
<br />Marijuana Tax
<br />170,850
<br />220,610 49,760 29.1%
<br />180,091
<br />220,610
<br />40,519
<br />22.5%
<br />Construction Permits
<br />1,047,000
<br />925,000 (122,000) -11.7%
<br />786,420
<br />925,000
<br />138,580
<br />17.6%
<br />Court Fines
<br />115,510
<br />63,960 (51,550) -44.6%
<br />85,275
<br />63,960
<br />(21,315)
<br />-25.0%
<br />Highway Users Tax
<br />554,480
<br />554,480 - 0.0%
<br />558,725
<br />554,480
<br />(4,245)
<br />-0.8%
<br />r General Fund Revenue
<br />19,822,020
<br />20,739,420 917,400 4.6%
<br />20,384,695
<br />20,739,420
<br />354,725
<br />1.7%
<br />(not a total of above)
<br />Orange = Department Other Than Finance Making the Projection
<br />Green = Positive Variance exceeding $100,000 and/or 5%
<br />White = Neutral Variance within $100,000 and/or 5%
<br />- = Negative Variance exceeding $100,000 and/or 5%
<br />LV
<br />
|