Page 69 - Mansfieldr FY20 Approved Budget
P. 69

Projected Sales Tax


                         $25,000,000
                         $20,000,000
                         $15,000,000
                         $10,000,000

                          $5,000,000
                                 $0
                                     2020   2021   2022  2023   2024   2025  2026   2027   2028  2029

                   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
                          2020                       6,414,079                                       6,414,079

                          2021                         6,414,079                  192,422  3%                    6,606,501
                          2022                       6,606,501                  198,195  3%                    6,804,696

                          2023                         6,804,696                  204,141  3%                    7,008,837
                          2024                         7,008,837                  210,265  3%                    7,219,102
                          2025                         7,219,102                  216,573  3%                    7,435,675
                          2026                         7,435,675                  223,070  3%                    7,658,746

                          2027                       7,658,746                  229,762  3%                    7,888,508
                          2028                         7,888,508                  236,655  3%                    8,125,163
                          2029                       8,125,163                  243,755  3%                    8,368,918



                                                   Projected Franchise Tax

                        9,000,000
                        8,000,000
                        7,000,000
                        6,000,000
                        5,000,000
                        4,000,000
                        3,000,000
                        2,000,000
                        1,000,000
                              0
                                  2020  2021   2022   2023   2024  2025   2026   2027   2028  2029



                                                                                                       69
   64   65   66   67   68   69   70   71   72   73   74