Page 66 - CityofMansfieldFY23Budget
P. 66

Projected Sales Tax


                        $30,000,000
                        $25,000,000
                        $20,000,000
                        $15,000,000
                        $10,000,000
                         $5,000,000
                               $0
                                  2023  2024  2025  2026  2027  2028  2029  2030  2031  2032


                   Franchise Fee Assumptions

                   Table 5

                   Table 5 estimates the franchise tax collected on electricity, gas, phone and cable services.


                           Tax          Franchise      Estimated       Percent       Estimated
                           Year            Tax          Increase      Increase         Total
                           2023                       7,617,430                  392,676  5%                    8,010,106
                           2024                       8,010,106                  160,202  2%                    8,170,308

                           2025                     8,170,308                  163,406  2%                    8,333,714
                           2026                       8,333,714                  166,674  2%                    8,500,389
                           2027                       8,500,389                  170,008  2%                    8,670,396
                           2028                     8,670,396                  260,112  3%                    8,930,508


                           2029                     8,930,508                  267,915  3%                    9,198,423
                           2030                       9,198,423                  275,953  3%                    9,474,376
                           2031                       9,474,376                  284,231  3%                    9,758,607
                           2032                       9,758,607                  292,758  3%                  10,051,366


                                                    Projected Franchise Tax

                             12,000,000
                             10,000,000
                              8,000,000

                              6,000,000
                              4,000,000

                              2,000,000
                                    0
                                       2023  2024  2025  2026  2027  2028  2029  2030  2031  2032




                                                                                                       65
   61   62   63   64   65   66   67   68   69   70   71