Page 63 - City of Mansfield FY22 Operarting Budget
P. 63

Projected Sales Tax


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


                   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
                          2022                         7,138,603                  214,158  3%                    7,617,430
                          2023                         7,617,430                 (117,614)  -2%                    7,499,816
                          2024                         7,499,816                  149,997  2%                    7,649,813
                          2025                       7,649,813                  152,995  2%                    7,802,809

                          2026                         7,802,809                  156,056  2%                    7,958,865
                          2027                         7,958,865                  159,177  2%                    8,118,042
                          2028                       8,118,042                  243,542  3%                    8,361,584


                          2029                       8,361,584                  250,847  3%                    8,612,431
                          2030                         8,612,431                  258,373  3%                    8,870,804

                          2030                       8,870,804                  266,124  3%                    9,136,928

                                                 Projected Franchise Tax


                       10,000,000

                        8,000,000

                        6,000,000

                        4,000,000
                        2,000,000

                               0
                                  2022  2023  2024   2025  2026  2027  2028   2029  2030  2031



                                                                                                       63
   58   59   60   61   62   63   64   65   66   67   68