Page 13 - Trophy Club ORD 2023-15 Adoption FY23-24
P. 13

All Funds Summary - Fiscal Year 2024


       FY24 Tax Rate                                                                            GOVERNMENTAL FUNDS                                                                                  PROPRIETARY FUNDS     COMPONENT
                                                                                                                                                                                                                             UNITS
                                                                       Capital   Information   Hotel      Street      Court                                        Parkland                                    Stormwater
           0.415469              General Fund  Debt Service  Capital Projects   Replacement   Replacement   Occupancy   Maintenance   Technology   Court Security   CCPD Fund  Program Fund  Dedication   TIRZ #1  Grants Fund  Trophy Club   Drainage   EDC 4B Fund  Total
                                                                                                                                                      Recreation
                                                                                  Services
                                                                     Equipment
                                                                                                                                                                                                     Park Fund
                                                           Fund
                                               Fund
                                                                                                                                  Fund
                                                                       Fund        Fund        Fund    Sales Tax Fund  Fund                                         Fund                                       Utility Fund
      Beginning Fund Balance - FY22   $       6,954,899  $         165,869  $          (912,745) $          659,711  $          218,873  $      2,638,723  $         259,253  $             8,514  $           50,015  $         196,044  $           21,550  $         177,650  $          (98,737) $             9,886  $         355,332  $         872,424  $       1,719,735  $   13,471,805
      ACFR less FY23 Exp
      Revenue
      Property Tax                          8,953,445              2,625,982                                                                                                                  79,744                                         11,659,172
      Licenses and Permits                     255,000                                                                                                                                                                                              255,000


      Franchise Fees                           917,500                                                                                                                                                                                              917,500
      Sales/Occupancy Tax                   1,595,000                                                     600,000                350,000                350,000                             81,339                                        752,625           3,728,964

      Fines and Fees                             318,476                                                                               1,000                      5,000                      6,000                200,000                430,000               960,476

      Intergovernmental (MUD)               1,195,440                                                                                                                                                                                          1,195,440
      Grants                              -                                                                                                                                                                                                    -

      Charges for Service                      909,154                                                                                                                                                                                              909,154



      Investment Income                          160,000      20,000                                          5,000                    1,500                    1,000                     1,750                      1,200                    5,000                195,450


      Miscellaneous Income                       161,000                      2,500                             7,500                                                                                                               500               171,500
      Contributions                                                                                                                                                                                                                            -





      Total Revenue             $    14,465,015  $     2,628,482  $             20,000  $  -    $  -    $         612,500  $        351,500  $             1,000  $             5,000  $         351,000  $             6,000  $             1,750  $        161,083  $    -  $        201,200  $          435,000  $           753,125  $  19,992,656

      Expenditures
      General Government                  -                                                                                                                                                   59,379                                       634,018               693,397
      Manager's Office                           549,873                        2,250,000                                                                                                                                                      2,799,873

      Town Secretary's Office                  262,275                                                                                                                                                                                              262,275

      Legal                                    225,430                                                                                                                                                                                              225,430

      Police                                3,870,180                           -                                                                       449,436                                                                                4,319,616

      Emergency Medical Services              1,625,885                            121,000                                                                                                                                                     1,746,885


      Fire                                  1,761,163                        6,500                                                                                                                                                             1,767,663

      Streets                                    305,490                                                              345,318                                                                                                271,465                922,273
      Parks                                 1,644,559                              167,500                                                                                                                       270,302                       2,082,361




      Recreation                                 927,947                           147,217                                                                                6,000                                                                1,081,164
      Community Events                           56,300                                                   378,309                                                                                                                                   434,609

      Community Development                      459,071                               52,000                                                                                                                                                       511,071
      Finance                                    591,264                                                                                                                                                                                            591,264
      Municipal Court                            109,240                                                                               2,755                      2,500                                                                             114,495
      Human Resources                            487,281                                                                                                                                                                                            487,281
      Communications                             217,577                                                                                                                                                                                            217,577
      Information Services                     941,297                                           50,000                                                                                                                                             991,297


      Facility Maintenance                       308,724                        -                                                                                                                                                                   308,724
      Debt Service                        -                2,892,720                                                                                                                                                                408           2,893,128
      Capital - Projects                    -                        6,725,000                            100,000                                                                97,000                                                        6,922,000




      Total Expenditures        $    14,343,557  $     2,892,720  $       6,725,000  $      2,744,217  $            50,000  $          478,309  $        345,318  $             2,755  $             2,500  $          449,436  $             6,000  $           97,000  $           59,379  $  -    $        270,302  $         271,465  $          634,426  $  29,372,384






      Current Revenues to        $          121,458  $       (264,238) $       (6,705,000) $      (2,744,217) $           (50,000) $         134,191  $             6,182  $           (1,755) $             2,500  $           (98,436) $  -    $         (95,250) $         101,704  $    -  $           (69,102) $         163,535  $          118,699  $   (9,379,729)




      Expenditures
      Other Sources (Uses):
      Debt Issuance                                             -                                                                                                                                                                             -
      Transfers In                              151,500               201,518              2,744,217    50,000                                                                                                                                  3,147,235
      Excess Current Revenue                    121,458
      Available for Transfer to Capital                  272,958
      Transfers Out                         2,744,217                                                      (95,000)                  20,000  1,500                                                                   15,000                  20,000            (2,705,717)

      Total Other Sources (Uses)  $       (2,471,259) $         201,518  $  -    $       2,744,217  $            50,000  $           95,000  $          (20,000) $  -    $            (1,500) $  -    $  -    $  -    $  -    $  -    $          (15,000) $          (20,000) $    -  $        562,976
      Net Increase (Decrease)   $       (2,471,259) $          (62,720) $       (6,705,000) $  -    $  -    $         229,191  $          (13,818) $            (1,755) $             1,000  $          (98,436) $  -    $          (95,250) $         101,704  $  -    $          (84,102) $         143,535  $          118,699  $   (8,938,211)


      Ending Fund balance       $       4,483,640  $         103,149  $      (7,617,745) $          659,711  $          218,873  $      2,867,914  $         245,435  $             6,759  $           51,015  $           97,608  $           21,550  $           82,400  $             2,967  $             9,886  $         271,230  $      1,015,959  $       1,838,434  $     4,955,000
                                                                                                                FY24 Adopted Budget                                                                                                   6
   8   9   10   11   12   13   14   15   16   17   18