Loading...
HomeMy Public PortalAboutCPA funds 6-30-21and 9-14-21TOWN OF WATERTOWN CPA FUND ACTIVTY AS OF SEPTEMBER 14, 2021 YID FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 BEGINNING CASH BALANCE $ 1,899,397.28 $ 4,362,055.08 $ 7,000,176.82 $ 10,114,856.71 ACTUAL REVENUE: CPA SURCHARGE $ 1,899,397.28 $ 2,080,870.63 $ 2,163,099.54 $ 2,511,802.87 $ 499,146.40 STATE REVENUE $ 367,395.00 $ 498,767.00 $ 625,041.00 INTEREST REVENUE $ 14,392.17 $ 23,474.26 $ 34,927.16 TOTAL ACTUAL REVENUE $ 1,899,397.28 $ 2,462,657.80 $ 2,685,340.80 $ 3,171,771.03 $ 499,146.40 ACTUAL EXPENDITURES: PERSONNEL PURCHASED SERVICES SUPPLIES OTHER 20,019.06 $ 27,200.00 $ 40,877.62 $ 16,213.52 8,376.30 TOTAL ACTUAL EXPENDITURES $ - $ - $ 47,219.06 $ 57,091.14 $ 8,376.30 ENDING CASH BALANCE $ 1,899,397.28 $ 4,362,055.08 $ 7,000,176.82 $ 10,114,856.71 $ 10,605,626.81 CARRYOVER PURCHASE ORDER $ 37,150.00 1) CPA SURCHARGE INCLUDES LIEN ACTIVITY 2) AMOUNTS ARE SUBJECT TO CHANGE VIA EXTERNAL AUDIT ESTIMATED REVENUE: FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 CPA SURCHARGE $ 1,500,000 $ 2,000,000 $ 2,250,000 $ 2,350,000 $ 2,500,000 STATE REVENUE $ 367,395 $ 231,400 $ 250,000 $ 551,210 TOTAL ESTIMATED REVENUE $ 1,500,000 $ 2,367,395 $ 2,481,400 $ 2,600,000 $ 3,051,210 SPECIFIC RESERVES FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 TOTAL 10% OPEN SPACE/RECREATION RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 10% HISTORIC PRESERVATION RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 10% AFFORDABLE HOUSING RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 5% ADMINISTRATIVE BUDGET $ 124,070 $ 130,000 $ 152,561 $ 406,631 ESTIMATED RESERVE 70%/65% $ 1,050,000 $ 1,657,178 $ 1,612,910 $ 1,690,000 $ 1,983,287 $ 7,993,375 $ 1,500,000 $ 2,367,395 $ 2,481,400 $ 2,600,000 $ 3,051,210 TOWN OF WATERTOWN CPA FUND ACTIVTY AS OF JUNE 30, 2021 FY 2018 FY 2019 FY 2020 FY 2021 BEGINNING CASH BALANCE $ 1,899,397.28 $ 4,362,055.08 $ 7,000,176.82 ACTUAL REVENUE: CPA SURCHARGE $ 1,899,397.28 $ 2,080,870.63 $ 2,163,099.54 $ 2,511,802.87 STATE REVENUE $ 367,395.00 $ 498,767.00 $ 625,041.00 INTEREST REVENUE $ 14,392.17 $ 23,474.26 $ 34,927.16 TOTAL ACTUAL REVENUE $ 1,899,397.28 $ 2,462,657.80 $ 2,685,340.80 $ 3,171,771.03 ACTUAL EXPENDITURES: PERSONNEL $ 20,019.06 $ 40,877.62 PURCHASED SERVICES $ 27,200.00 $ 16,213.52 SUPPLIES OTHER TOTAL ACTUAL EXPENDITURES ENDING CASH BALANCE CARRYOVER PURCHASE ORDER $ $ 47,219.06 $ 57,091.14 1,899,397.28 $ 4,362,055.08 $ 7,000,176.82 $ 10,114,856.71 $ 37,150.00 1) CPA SURCHARGE INCLUDES LIEN ACTIVITY 2) AMOUNTS ARE SUBJECT TO CHANGE VIA EXTERNAL AUDIT ESTIMATED REVENUE: FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 CPA SURCHARGE $ 1,500,000 $ 2,000,000 $ 2,250,000 $ 2,350,000 $ 2,500,000 STATE REVENUE $ 367,395 $ 231,400 $ 250,000 $ 551,210 TOTAL ESTIMATED REVENUE $ 1,500,000 $ 2,367,395 $ 2,481,400 $ 2,600,000 $ 3,051,210 SPECIFIC RESERVES FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 TOTAL 10% OPEN SPACE/RECREATION RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 10% HISTORIC PRESERVATION RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 10% AFFORDABLE HOUSING RESERVE $ 150,000 $ 236,739 $ 248,140 $ 260,000 $ 305,121 $ 1,200,000 5% ADMINISTRATIVE BUDGET $ 124,070 $ 130,000 $ 152,561 $ 406,631 ESTIMATED RESERVE 70%/65% $ 1,050,000 $ 1,657,178 $ 1,612,910 $ 1,690,000 $ 1,983,287 $ 7,993,375 $ 1,500,000 $ 2,367,395 $ 2,481,400 $ 2,600,000 $ 3,051,210