Page 81 - FY 2021--22 Revenue Outlook

REVENUE MONTHLY STATUS REPORT
Franchise Income - Natural Gas
(Thousand Dollars)

2017-18 2018-19 2019-20 2020-21 2021-22
MONTHLY ACTUAL ACTUAL ACTUAL BUDGET ACTUAL VARIANCE REVISED PROPOSED
JULY $ - - - - - - - -
AUGUST 3,868 - 2,937 3,733 3,551 (182) 3,551 3,551
SEPTEMBER - 3,618 - - - - - -
OCTOBER - - - - - - - -
NOVEMBER 3,500 - 6,787 3,578 3,662 84 3,662 3,662
DECEMBER - - - - - - - -
JANUARY - 3,876 - - - - - -
FEBRUARY - 4,400 1,181 4,193 4,963 770 4,963 4,963
MARCH 3,814 - - - - - - -
APRIL - - - - - -
MAY - - - 5,696 6,124 6,124
JUNE 5,185 7,437 6,653 - - -
TOTAL $ 16,367 $ 19,332 $ 17,558 $ 17,200 $ 18,300 $ 18,300
% Change -6.6% 18.1% -9.2% -2.0% 4.2% 0.0%
2017-18 2018-19 2019-20 2020-21 2021-22
CUMULATIVE ACTUAL ACTUAL ACTUAL BUDGET ACTUAL VARIANCE REVISED PROPOSED
JULY $ - - - - - - - -
AUGUST 3,868 - 2,937 3,733 3,551 (182) 3,551 3,551
SEPTEMBER 3,868 3,618 2,937 3,733 3,551 (182) 3,551 3,551
OCTOBER 3,868 3,618 2,937 3,733 3,551 (182) 3,551 3,551
NOVEMBER 7,368 3,618 9,724 7,311 7,213 (98) 7,213 7,213
DECEMBER 7,368 3,618 9,724 7,311 7,213 (98) 7,213 7,213
JANUARY 7,368 7,495 9,724 7,311 7,213 (98) 7,213 7,213
FEBRUARY 7,368 11,895 10,905 11,504 12,176 672 12,176 12,176
MARCH 11,182 11,895 10,905 11,504 12,176 672 12,176 12,176
APRIL 11,182 11,895 10,905 11,504 12,176 12,176
MAY 11,182 11,895 10,905 17,200 18,300 18,300
JUNE 16,367 19,332 17,558 17,200 18,300 18,300

The franchise payment received from natural gas suppliers is two percent of the gross sales of gas plus the value
of gas not sold, but rather transported within the City. The 2020-21 revised estimate is based on receipts-to-date.
The 2021-22 estimate, based on historical receipts since 2009-10 and natural gas price futures, is expected to
remain flat.

72