ARTICLE 25 Authorize Expenditure from PEG Access CableRelated

ARTICLE 25 Authorize Expenditure from PEG Access & Cable-Related Fund To determine whether the Town will vote to raise and appropriate, or transfer from the PEG Access and Cable-Related Fund the sum of $500, 646 $431, 108, or any other sum, to be expended during the fiscal year ending June 30, 2022 under the direction of the Town Manager for necessary and expedient cable-related purposes consistent with the Town’s license agreement with Comcast, or take any other action relative thereto. 1

ARTICLE 25: PEG & Cable Fund PUBLIC Ѽ EDUCATION Ѽ GOVERNMENT • Concord receives 4. 8% of all Comcast’s revenue generated through it’s Concord customers. • Money may only be used for cable-related purposes. The total amount requested is $505, 646 of which $102, 800 shall be reserved for Capital Improvements. The Fund Balance as of July 1, 2020 = $1, 403, 037 2

ARTICLE 25: PEG & Cable Fund Town Manager Deputy Town Manager (1 FTE) Public Information and Communications Manager (1 FTE) Studio Manager (1 FTE) Media Technician (1 FTE) Lead Producer (1 FTE) Educational Coordinator (1 FTE) Videographers (1. 5 FTEs) 3

ARTICLE 25: PEG & Cable Fund FY 22 Goals • Increase community involvement with MMN: – Expand public programming – Train interested community members on how to use available loaned equipment and public media offerings – Propose Continuing Education Classes and/or Workshops for interested parties • • • Offer a robust school-aged educational program relative to media and cable-related mediums in partnership with the Concord Public Schools and MMN’s new Education Coordinator proposed for recruitment in summer 2021. Cultivate and promote community access to MMN studio and equipment for all interested parties. Organize and coordinate community and public events with special focus on community involvement and education relative to MMN offerings and various types of media and cablerelated productions. 4

ARTICLE 25: PEG & Cable Fund OPERATING REVENUES FY 19 FY 20 FY 21 FY 22 Actual Revised Proposed Comcast / Franchise Fee 371, 626 345, 012 332, 074 315, 470 Carlisle Fee 7, 710 12, 763 74, 199 74, 662 Program / Community Ed. Fee - - Grants & Donations - - Payment In Lieu of Franchise (PILOF)* - - 18, 915 Miscellaneous Revenue - - 657 Operating Revenues Total 379, 335 357, 775 425, 845 21, 391 411, 522 5

OPERATING EXPENSES Personnel Services Personnel Expenses Retirement Adjustment Audit Adjustment Subtotal Non-Personnel Services Facilities and Maintenance Purchased Services Supplies & Materials Other Charges & Expenses Audit Adjustment Subtotal Other General Fund Services Audit Adjustment Subtotal Total Operating Expense FY 19 Actual $ 129, 418 FY 20 Actual $ 146, 348 FY 21 Revised $ 309, 352 FY 22 Proposed $ 299, 332 $ 129, 418 146, 348 $ 309, 352 299, 332 $ 106, 658 15, 512 122, 170 $ 1, 985 15, 834 7, 350 525 25, 694 $ $ $ - $ 251, 587 9, 301 36, 246 805 46, 352 $ $ 1, 424 $ 194, 124 $ $ 2, 084 16, 625 110, 518 551 129, 778 $ $ 1, 802 $ 1, 998 $ 336, 848 $ 431, 108 6

PEG Capital ITEMS & SOFTWARE Capital is separate from the operating and is taken from the fund balance. FUND AMOUNT Fund Balance $1, 581, 777 Less Capital (102, 800) NET Position $1, 478, 977 COST Studio Improvements & Repairs $7, 000 Editing Equipment Replacements $1, 200 Computer Equipment Replacements $9, 000 External Equipment Systems $6, 200 Portable Mics & Speakers $1, 200 Sound System Improvements $500 Building Systems $1, 000 Security System $500 Vehicle Acquisition & Maintenance $2, 000 Software $3, 200 Misc. Equipment Acquisition & Repairs $14, 000 Satellite Facilities: HWCC, Traveling Studio & Other $57, 000 TOTAL $ 102, 800 7

Cash Position at Years’ End NET INCOME FY 19 FY 20 Actual FY 21 Revised FY 22 Proposed Statement of Net Income: Operating Revenues Less Operating Expenses (Includes $102, 800 in Capital) Less Operating Expenses (NOT including Capital) Operating Income w/Capital Operating Income w/o Capital 379, 335 357, 775 425, 845 411, 522 (251, 58 (194, 12 (336, 84 (431, 10 7) 4) 8) 8) (328, 308) 127, 748 163, 652 88, 997 (19, 586) 83, 214 8

CASH POSITION AND FUND BALANCE FORECAST Cash at Year Opening FY 21 FY 22 Cash on July 1 st $ 1, 409, 565 $ 1, 498, 562 Fund Balance Details (projected) Fund Balance on July 1 st $ Credit 1, 403, 037 $ Net Income 88, 997 Balance Projected at June 30 th 1, 492, 034 Fund Balance on June 30 th $ Debit Credit - $ Debit 1, 492, 034 $ - (19, 586) - 1, 492, 034 1, 472, 448 $ - 1, 472, 448 Cash at Year End (projected) Fund Balance on June 30 th $ 1, 492, 034 Add Cash Held for Liabilities $ $ 1, 472, 448 6, 528 Add Cash Held for Deferred Inflows Projected Cash at June 30 th $ 1, 498, 562 $ 6, 528 - $ 1, 478, 977 9

ARTICLE 25 Authorize Expenditure from PEG Access & Cable-Related Fund To determine whether the Town will vote to raise and appropriate, or transfer from the PEG Access and Cable-Related Fund the sum of $500, 646 $431, 108, or any other sum, to be expended during the fiscal year ending June 30, 2022 under the direction of the Town Manager for necessary and expedient cable-related purposes consistent with the Town’s license agreement with Comcast, or take any other action relative thereto. 10