Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Resolution Number 19-06-04-05
CITY OF SAN JUAN CAPISTRANO 2019-2026 CIP PROJECT SUMMARY BY TYPE PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDPROJECT 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL TRANSPORTATIONxx101‐Annual Traffic Signal Cabinet Upgrades 255,000$ 260,000$ 265,000$ 270,000$ 110,000$ ‐$ ‐$ 1,160,000$ 07117‐I‐5/San Juan Creek Road Underpass Improvements 181,040 270,920 383,780 6,617,000 ‐ ‐ ‐ 7,452,740 08102‐Pavement Management Program (PMP) ‐ 95,000 ‐ 50,000 ‐ 50,000 ‐ 195,000 11101‐Citywide Sign Replacement Program ‐ ‐ 50,000 40,000 40,000 40,000 ‐ 170,000 19101‐Meredith Canyon Streets Pavement Rehabilitation 1,702,000 1,458,000 ‐ ‐ ‐ ‐ ‐ 3,160,000 19102‐Camino Capistrano Pavement Rehabilitation 450,000 550,000 990,000 ‐ ‐ ‐ ‐ 1,990,000 (Aeropuerto to Costco)20102‐Public Right‐of‐Way ADA Implementation Plan 25,000 72,500 10,000 ‐ ‐ ‐ ‐ 107,500 xxxxx‐Mission Spring Streets Pavement Rehabilitation ‐ ‐ 1,445,000 445,000 ‐ ‐ ‐ 1,890,000 xxxxx‐Sun Ranch Streets Pavement Rehabilitation ‐ ‐ 130,000 1,094,000 956,000 ‐ ‐ 2,180,000 xxxxx‐Village San Juan and Casitas Streets Pavement Rehab. ‐ ‐ ‐ ‐ 865,000 1,603,000 ‐ 2,468,000 Pavement Rehabilitationxxxxx‐Mission Creek Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ ‐ 200,000 2,010,000 2,210,000 SUBTOTAL2,613,040$ 2,706,420$ 3,273,780$ 8,516,000$ 1,971,000$ 1,893,000$ 2,010,000$ 22,983,240$ PARKS AND OPEN SPACE 07204‐Citywide Trail Improvements‐$ 75,000$ ‐$ 75,000$ ‐$ 75,000$ ‐$ 225,000$ 09203‐Citywide Playground Upgrades‐ 120,000 120,000 125,000 130,000 130,000 130,000 755,000 18204‐Los Rios Phase II Improvements‐ ‐ 1,630,000 ‐ ‐ ‐ ‐ 1,630,000 20201‐2.4 Acre Site (adjacent to Reata Park)‐ 200,000 ‐ ‐ ‐ ‐ ‐ 200,000 20202‐Arizona Crossing Removal129,000 365,000 ‐ ‐ ‐ ‐ ‐ 494,000 20203‐Stream Bank Restoration 195,000 1,600,000 ‐ ‐ ‐ ‐ ‐ 1,795,000 xxxxx‐Sports Park Improvements‐ ‐ 995,000 ‐ ‐ ‐ ‐ 995,000 SUBTOTAL324,000$ 2,360,000$ 2,745,000$ 200,000$ 130,000$ 205,000$ 130,000$ 6,094,000$ BUILDINGS AND FACILITIES15306‐ADA Self Evaluation and Transition Plan152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 1,064,000$ xxxxx‐Historic Town Center Park Storage Facility‐ ‐ 180,000 ‐ ‐ ‐ ‐ 180,000 SUBTOTAL152,000$ 152,000$ 332,000$ 152,000$ 152,000$ 152,000$ 152,000$ 1,244,000$ DRAINAGE20501‐Confined Animal Feeding Operations (CAFO)565,000$ 5,125,000$ 450,000$ ‐$ ‐$ ‐$ ‐$ 6,140,000$ Stormwater Treatment SystemSUBTOTAL565,000$ 5,125,000$ 450,000$ ‐$ ‐$ ‐$ ‐$ 6,140,000$ DOMESTIC WATER08801‐Joint Regional Water Supply System (JRWSS) ‐$ ‐$ ‐$ ‐$ 505,000$ 100,000$ 100,000$ 705,000$ Capital Replacements17801‐San Juan Hills Greens Cathodic Protection System275,000 ‐ ‐ ‐ ‐ ‐ ‐ 275,000 17802‐760S Zone Pump Station Discharge Line Replacement‐ 800,000 800,000 ‐ ‐ ‐ ‐ 1,600,000 17803‐Valve Insertion Program200,000 200,000 200,000 200,000 200,000 200,000 200,000 1,400,000 17806‐Water Facility Control Systems200,000 200,000 200,000 200,000 200,000 1,000,000 17807‐Well Facility Equipment Replacement Program135,000 135,000 90,000 135,000 90,000 90,000 135,000 810,000 19803‐GWRP Clear Well Replacement ‐ ‐ 250,000 ‐ ‐ ‐ ‐ 250,000 19804‐Pump Station Component Replacements 440,000 460,000 480,000 500,000 540,000 580,000 ‐ 3,000,000 19805‐Eastern Transmission System Repairs 100,000 200,000 220,000 220,000 ‐ ‐ ‐ 740,000 EXHIBIT A Page 1 of 22 CITY OF SAN JUAN CAPISTRANO 2019-2026 CIP PROJECT SUMMARY BY TYPE PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDPROJECT 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26 TOTAL 20801‐System Repairs and Upgrade of Appurtenances100,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 6,100,000 20802‐Safety Access Stair and Platform System120,000 ‐ ‐ ‐ ‐ ‐ ‐ 120,000 xxxxx‐Groundwater Recharge with Storm Water ‐ ‐ ‐ 585,000 585,000 585,000 585,000 2,340,000 xxxxx‐San Juan Hills Greens and Estates Pipeline Replacement‐ ‐ ‐ ‐ ‐ 2,300,000 2,300,000 4,600,000 SUBTOTAL1,570,000$ 2,995,000$ 3,240,000$ 2,840,000$ 3,120,000$ 4,855,000$ 4,320,000$ 22,940,000$ RECYCLED WATERxx601‐Annual Recycled Water Service Conversions Project170,000$ 170,000$ 170,000$ 170,000$ ‐$ ‐$ ‐$ 680,000$ 17601‐Trampas Canyon Recycled Water Reservoir‐ 10,000 101,000 101,000 101,000 101,000 101,000 515,000 18601‐Calle Arroyo Recycled Pipeline ‐ 475,000 1,820,000 337,000 ‐ ‐ ‐ 2,632,000 xxxxx‐Recycled Water Master Plan‐ 165,000 100,000 ‐ ‐ ‐ ‐ 265,000 SUBTOTAL170,000$ 820,000$ 2,191,000$ 608,000$ 101,000$ 101,000$ 101,000$ 4,092,000$ SEWERxx701‐Annual Sewer Replacement Program400,000$ 550,000$ 550,000$ 600,000$ 600,000$ 600,000$ 600,000$ 3,900,000$ 07701‐South Orange County Wastewater Authority 4,400,000 3,600,000 2,256,000 1,117,000 1,318,000 1,318,000 1,000,000 15,009,000 PC#2 & #5 Rehab08701‐Food, Oils & Grease (FOG) Interceptor Program‐ ‐ ‐ 25,000 20,000 ‐ ‐ 45,000 SUBTOTAL4,800,000$ 4,150,000$ 2,806,000$ 1,742,000$ 1,938,000$ 1,918,000$ 1,600,000$ 18,954,000$ GRAND TOTAL10,194,040$ 18,308,420$ 15,037,780$ 14,058,000$ 7,412,000$ 9,124,000$ 8,313,000$ 82,447,240$ EXHIBIT A Page 2 of 22 CITY OF SAN JUAN CAPISTRANOCONSOLIDATED CIP FUNDS FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE25,194,956$ 14,666,004$ 20,583,464$ 30,345,044$ 28,755,264$ 25,263,264$ 26,001,264$ 24,607,264$ REVENUESRevenue/Fees In 4,435,000 8,492,000 16,187,000 7,611,000 4,882,000 2,876,000 2,491,000 2,365,000 Current Year Project Funding 455,345 1,041,000 7,242,000 602,000 152,000 152,000 152,000 152,000 Grants 822,825 176,400 189,500 190,500 207,500 ‐ ‐ ‐ Interest 173,500 195,000 196,000 185,000 171,000 172,000 137,000 138,000 Developer Contribution 350,000 2,000,000 ‐ ‐ 411,000 ‐ ‐ ‐ Loan Repayment from Water Operations Fund 737,500 320,000 ‐ ‐ ‐ ‐ ‐ ‐ Loan Repayment from Measure M Fund 436,277 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Loan Repayment from Successor Agency 120,000 240,000 ‐ ‐ ‐ ‐ ‐ ‐ Loan Repayment from State Gas Tax 41,000 41,000 ‐ ‐ ‐ ‐ ‐ ‐ Loan Interest 12,500 2,500 ‐ ‐ ‐ ‐ ‐ ‐ Transfers In 2,832,728 4,130,000 4,795,000 5,400,000 5,300,000 5,300,000 5,300,000 5,955,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 10,416,675$ 16,637,900$ 28,609,500$ 13,988,500$ 11,123,500$ 8,500,000$ 8,080,000$ 8,610,000$ TOTAL FUNDS AVAILABLE 35,611,631$ 31,303,904$ 49,192,964$ 44,333,544$ 39,878,764$ 33,763,264$ 34,081,264$ 33,217,264$ EXPENDITURESTransportation Projects 7,121,385 2,613,040 2,706,420 3,273,780 8,516,000 1,971,000 1,893,000 2,010,000 Parks and Open Space Projects 3,638,385 324,000 2,360,000 2,745,000 200,000 130,000 205,000 130,000 Buildings and Facilities Projects 655,345 152,000 152,000 332,000 152,000 152,000 152,000 152,000 Drainage Projects 400,715 565,000 5,125,000 450,000 ‐ ‐ ‐ ‐ Non‐Potable Water Projects 317,465 170,000 820,000 2,191,000 608,000 101,000 101,000 101,000 Sewer Projects 4,026,780 4,800,000 4,150,000 2,806,000 1,742,000 1,938,000 1,918,000 1,600,000 Water Projects 3,733,215 1,570,000 2,995,000 3,240,000 2,840,000 3,120,000 4,855,000 4,320,000 Operating Expenditures/Transfers Out 1,052,337 526,400 539,500 540,500 557,500 350,000 350,000 350,000 TOTAL EXPENDITURES 20,945,627$ 10,720,440$ 18,847,920$ 15,578,280$ 14,615,500$ 7,762,000$ 9,474,000$ 8,663,000$ ENDING FUND BALANCE14,666,004$ 20,583,464$ 30,345,044$ 28,755,264$ 25,263,264$ 26,001,264$ 24,607,264$ 24,554,264$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 3 of 22 CITY OF SAN JUAN CAPISTRANO FUND 1 - GENERAL FUND FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ REVENUESCurrent Year Project Funding‐ 889,000 7,090,000 450,000 ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES ‐$ 889,000$ 7,090,000$ 450,000$ ‐$ ‐$ ‐$ ‐$ TOTAL REVENUE AVAILABLE ‐$ 889,000$ 7,090,000$ 450,000$ ‐$ ‐$ ‐$ ‐$ EXPENDITURES20202‐Arizona Crossing Removal‐ 129,000 365,000 ‐ ‐ ‐ ‐ ‐ 20203‐Stream Bank Restoration ‐ 195,000 1,600,000 ‐ ‐ ‐ ‐ ‐ 20501‐Confined Animal Feeding Operations (CAFO)‐ 565,000 5,125,000 450,000 ‐ ‐ ‐ ‐ Stormwater Treatment System TOTAL EXPENDITURES ‐$ 889,000$ 7,090,000$ 450,000$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 4 of 22 CITY OF SAN JUAN CAPISTRANO FUND 6 - ROAD MAINTENANCE AND REHABILITATION ACCOUNT (RMRA) FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE45,324$ 504$ 504.000$ 504.000$ 504.000$ 504.000$ 504.000$ 504.000$ REVENUES Gas Tax 2030 (SB‐1)583,000 608,000 614,000 620,000 626,000 632,000 633,000 639,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 583,000$ 608,000$ 614,000$ 620,000$ 626,000$ 632,000$ 633,000$ 639,000$ TOTAL REVENUE AVAILABLE 628,324$ 608,504$ 614,504$ 620,504$ 626,504$ 632,504$ 633,504$ 639,504$ EXPENDITURES18101‐Capistrano Villas I, II, and III Pavement Rehabilitation25,820 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 19101‐Meredith Canyon Streets Pavement Rehabilitation 602,000 608,000 ‐ ‐ ‐ ‐ ‐ ‐ xxxxx‐Mission Spring Streets Pavement Rehabilitation ‐ ‐ 614,000 620,000 ‐ ‐ ‐ ‐ xxxxx‐Sun Ranch Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ 626,000 632,000 ‐ ‐ xxxxx‐Village San Juan and Casitas Streets Pavement ‐ ‐ ‐ ‐ ‐ ‐ 633,000 ‐ Rehabilitation‐ xxxxx‐Mission Creek Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ ‐ ‐ ‐ 639,000 TOTAL EXPENDITURES 627,820$ 608,000$ 614,000$ 620,000$ 626,000$ 632,000$ 633,000$ 639,000$ ENDING FUND BALANCE 504$ 504$ 504$ 504$ 504$ 504$ 504$ 504$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 5 of 22 CITY OF SAN JUAN CAPISTRANOFUND 10 - SYSTEMS DEVELOPMENT FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,235,786$ 454,161$ 695,161$ 1,387,161$ 976,161$ 1,325,161$ 1,412,161$ 1,466,161$ REVENUES Systems Development Tax 395,000 600,000 1,196,000 561,000 334,000 80,000 47,000 47,000 Development Fees ‐ Ord 211 7,000 85,000 40,000 12,000 9,000 1,000 1,000 1,000 Interest 3,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 405,000$ 691,000$ 1,242,000$ 579,000$ 349,000$ 87,000$ 54,000$ 54,000$ TOTAL FUNDS AVAILABLE 1,640,786$ 1,145,161$ 1,937,161$ 1,966,161$ 1,325,161$ 1,412,161$ 1,466,161$ 1,520,161$ EXPENDITURES 11101‐City‐wide Sign Replacement Program 302,400 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 12502‐Camino Capistrano Off‐Ramp Catch Basins 170,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 14106‐Verdugo Street Beautification Project 165,555 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 15306‐ADA Self Evaluation and Transition Plan 75,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16502‐Interstate I‐5/Ortega Hwy Storm Water Treatment 73,670 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 19102‐Camino Capistrano Pavement Rehabilitation 200,000 450,000 550,000 990,000 ‐ ‐ ‐ ‐ (Aeropuerto to Costco)19301‐Del Obispo/Ortega Highway Public Parking Lot 200,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,186,625$ 450,000$ 550,000$ 990,000$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE 454,161$ 695,161$ 1,387,161$ 976,161$ 1,325,161$ 1,412,161$ 1,466,161$ 1,520,161$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019EXHIBIT A Page 6 of 22 CITY OF SAN JUAN CAPISTRANOFUND 11 - PARK AND RECREATION FEES FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,351,942$ 51,197$ 2,959,197$ 6,381,197$ 5,155,197$ 5,662,197$ 5,543,197$ 5,338,197$ REVENUESPark/Recreation Fees‐ 897,000 3,806,000 1,688,000 696,000 ‐ ‐ ‐ Developer Contribution ‐ 2,000,000 ‐ ‐ ‐ ‐ ‐ ‐ Interest7,000 11,000 11,000 11,000 11,000 11,000 ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 7,000$ 2,908,000$ 3,817,000$ 1,699,000$ 707,000$ 11,000$ ‐$ ‐$ TOTAL REVENUE AVAILABLE 1,358,942$ 2,959,197$ 6,776,197$ 8,080,197$ 5,862,197$ 5,673,197$ 5,543,197$ 5,338,197$ EXPENDITURES 07204‐City‐wide Trail Improvements47,000 ‐ 75,000 ‐ 75,000 ‐ 75,000 ‐ 09203‐City‐wide Playground Upgrades29,482 ‐ 120,000 120,000 125,000 130,000 130,000 130,000 09209‐Northwest Open Space Community Park163,130 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 14201‐Cook Park Softball Fields #2 & #3 & Soccer Field #288,750 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16202‐Cook Cordova Park Playground Equipment196,883 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16203‐Malaspina Trail 333,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 17202‐Eastern Open Space Trails A and A‐1206,565 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 18201‐Cook La Novia Park Picnic Area Enhancements172,405 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 18202‐Arce Park Renovation70,530 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 18204‐Los Rios Phase II Improvements‐ ‐ ‐ 1,630,000 ‐ ‐ ‐ ‐ 20201‐2.4 Acre Site (adjacent to Reata Park)‐ ‐ 200,000 ‐ ‐ ‐ ‐ ‐ xxxxx‐Sports Park Improvements ‐ ‐ ‐ 995,000 ‐ ‐ ‐ ‐ xxxxx‐Historic Town Center Park Storage Facility‐ ‐ ‐ 180,000 ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,307,745$ ‐$ 395,000$ 2,925,000$ 200,000$ 130,000$ 205,000$ 130,000$ ENDING FUND BALANCE51,197$ 2,959,197$ 6,381,197$ 5,155,197$ 5,662,197$ 5,543,197$ 5,338,197$ 5,208,197$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 7 of 22 CTIY OF SAN JUAN CAPISTRANOFUND 12 - DRAINAGE FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE(314,751)$ (282,986)$ (262,986)$ (157,986)$ (69,986)$ (69,986)$ (69,986)$ (69,986)$ REVENUES Drainage Fees54,000 20,000 105,000 88,000 ‐ ‐ ‐ ‐ Grants ‐ State18,020 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 72,020$ 20,000$ 105,000$ 88,000$ ‐$ ‐$ ‐$ ‐$ TOTAL REVENUE AVAILABLE (242,731)$ (262,986)$ (157,986)$ (69,986)$ (69,986)$ (69,986)$ (69,986)$ (69,986)$ EXPENDITURES12502‐Camino Capistrano Off‐Ramp Catch Basins40,255 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 40,255$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE(282,986)$ (262,986)$ (157,986)$ (69,986)$ (69,986)$ (69,986)$ (69,986)$ (69,986)$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 8 of 22 CTIY OF SAN JUAN CAPISTRANO FUND 13 - AGRICULTURAL PRESERVATION FUND FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE82,236$ 124,236$ 223,236$ 485,236$ 584,236$ 650,236$ 714,236$ 719,236$ REVENUES Agricultural Preservation Fees 42,000 94,000 257,000 94,000 61,000 59,000 ‐ ‐ Interest‐ 5,000 5,000 5,000 5,000 5,000 5,000 5,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 42,000$ 99,000$ 262,000$ 99,000$ 66,000$ 64,000$ 5,000$ 5,000$ TOTAL REVENUE AVAILABLE 124,236$ 223,236$ 485,236$ 584,236$ 650,236$ 714,236$ 719,236$ 724,236$ EXPENDITURES None ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE 124,236$ 223,236$ 485,236$ 584,236$ 650,236$ 714,236$ 719,236$ 724,236$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 9 of 22 CITY OF SAN JUAN CAPISTRANOFUND 17 - GAS TAX FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE480,552$ 892$ 572$ 3,572$ 4,572$ 37,572$ 19,572$ 66,572$ REVENUES Gas Tax 2103 (HUTA)130,000 313,000 316,000 319,000 322,000 325,000 325,000 328,000 Gas Tax 2105206,000 204,000 206,000 208,000 210,000 212,000 212,000 214,000 Gas Tax 2106138,000 138,000 139,000 140,000 141,000 142,000 142,000 143,000 Gas Tax 2107270,000 269,000 272,000 275,000 278,000 281,000 281,000 284,000 Gas Tax 2107.56,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 Loan Repayment41,000 41,000 ‐ ‐ ‐ ‐ ‐ ‐ Interest3,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 794,000$ 977,000$ 945,000$ 954,000$ 963,000$ 972,000$ 972,000$ 981,000$ TOTAL REVENUE AVAILABLE 1,274,552 977,892$ 945,572$ 957,572$ 967,572$ 1,009,572$ 991,572$ 1,047,572$ EXPENDITURES xx101/104‐Annual Traffic Signal Cabinet Upgrades358,000 255,000 260,000 265,000 270,000 110,000 ‐ ‐ 16104‐Left Turn Lane at Del Taco34,735 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 18101‐Capistrano Villas I, II, and III Pavement Rehabilitation146,425 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 19101‐Meredith Canyon Streets Pavement Rehabilitation 313,000 347,320 259,500 ‐ ‐ ‐ ‐ ‐ 19103‐Audible Pedestrian Signals 71,500 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 20102‐Public Right‐of‐Way ADA Implementation Plan ‐ 25,000 72,500 10,000 ‐ ‐ ‐ ‐ xxxxx‐Mission Spring Streets Pavement Rehabilitation ‐ ‐ ‐ 198,000 ‐ ‐ ‐ ‐ xxxxx‐Sun Ranch Streets Pavement Rehabilitation ‐ ‐ ‐ 130,000 310,000 ‐ ‐ ‐ xxxxx‐Village San Juan and Casitas Streets Pavement ‐ ‐ ‐ ‐ ‐ 530,000 375,000 ‐ Rehabilitationxxxxx‐Mission Creek Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ ‐ ‐ 200,000 671,000 Transfer Out‐General Fund (Street Maintenance)350,000 350,000 350,000 350,000 350,000 350,000 350,000 350,000 TOTAL EXPENDITURES 1,273,660$ 977,320$ 942,000$ 953,000$ 930,000$ 990,000$ 925,000$ 1,021,000$ ENDING FUND BALANCE892$ 572$ 3,572$ 4,572$ 37,572$ 19,572$ 66,572$ 26,572$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 10 of 22 CTIY OF SAN JUAN CAPISTRANOFUND 18 - CCFP FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE8,149,448$ 7,206,610$ 9,562,570$ 13,915,650$ 14,678,870$ 9,008,870$ 9,271,870$ 9,332,870$ REVENUES Circulation Fees 635,000 2,481,000 4,567,000 1,089,000 477,000 203,000 ‐ ‐ Developer Contribution 350,000 ‐ ‐ ‐ 411,000 ‐ ‐ ‐ Loan Repayment from Measure M Fund 436,277 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Loan Interest 5,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Interest 56,000 56,000 57,000 58,000 59,000 60,000 61,000 62,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 1,482,277$ 2,537,000$ 4,624,000$ 1,147,000$ 947,000$ 263,000$ 61,000$ 62,000$ TOTAL AVAILABLE 9,631,725$ 9,743,610$ 14,186,570$ 15,062,650$ 15,625,870$ 9,271,870$ 9,332,870$ 9,394,870$ EXPENDITURES 07117‐I‐5/San Juan Creek Road Underpass Improvements 921,810 181,040 270,920 383,780 6,617,000 ‐ ‐ ‐ 14103‐Camino Las Ramblas and I‐5 Northbound 291,890 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Traffic Signal Modification 14104‐Alipaz Street Widening‐Camino del Avion 27,505 ‐ ‐ ‐ ‐ ‐ ‐ ‐ to Calle Rolando 14107‐Ortega Highway Widening Project (managed by 350,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Caltrans) 16102‐Del Obispo Widening ‐ Via De La Paz 833,910 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 2,425,115$ 181,040$ 270,920$ 383,780$ 6,617,000$ ‐$ ‐$ ‐$ ENDING FUND BALANCE7,206,610$ 9,562,570$ 13,915,650$ 14,678,870$ 9,008,870$ 9,271,870$ 9,332,870$ 9,394,870$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 11 of 22 CITY OF SAN JUAN CAPISTRANOFUND 32 - MEASURE M FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE105,025$ 81,203$ 5,523$ 4,023$ 12,023$ 11,023$ 11,023$ 25,023$ REVENUESMeasure M Local Turnback 626,000 668,000 675,000 682,000 689,000 696,000 696,000 703,000 Interest3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 Transfers In‐General Fund4,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 633,000$ 671,000$ 678,000$ 685,000$ 692,000$ 699,000$ 699,000$ 706,000$ TOTAL AVAILABLE 738,025$ 752,203$ 683,523$ 689,023$ 704,023$ 710,023$ 710,023$ 731,023$ EXPENDITURESxx101/104‐Annual Traffic Signal Cabinet Upgrades114,545 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 08102‐Pavement Management Program (PMP)40,000 ‐ 95,000 ‐ 50,000 ‐ 50,000 ‐ 11101‐City‐wide Sign Replacement Program‐ ‐ ‐ 50,000 40,000 40,000 40,000 17105‐Local Streets Pavement Rehabilitation FY 16/17‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 18101‐Capistrano Villas I, II, and III Pavement Rehabilitation‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 19101‐Meredith Canyon Streets Pavement Rehabilitation 66,000 746,680 584,500 ‐ ‐ ‐ ‐ ‐ xxxxx‐Mission Spring Streets Pavement Rehabilitation ‐ ‐ ‐ 627,000 445,000 ‐ ‐ ‐ xxxxx‐Sun Ranch Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ 158,000 324,000 ‐ ‐ xxxxx‐Village San Juan and Casitas Streets Pavement ‐ ‐ ‐ ‐ ‐ 335,000 595,000 ‐ Rehabilitationxxxxx‐Mission Creek Streets Pavement Rehabilitation ‐ ‐ ‐ ‐ ‐ ‐ ‐ 700,000 Loan Repayment to CCFP Fund 436,277 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 656,822$ 746,680$ 679,500$ 677,000$ 693,000$ 699,000$ 685,000$ 700,000$ ENDING FUND BALANCE81,203$ 5,523$ 4,023$ 12,023$ 11,023$ 11,023$ 25,023$ 31,023$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 12 of 22 CITY OF SAN JUAN CAPISTRANO FUND 37 - HIGHWAYS, STREETS, AND ROADS GRANTS FUND FISCAL YEAR 2019/20 UPDATE AMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE(23,728)$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ REVENUESMeasure M Specific Projects 746,320 176,400 189,500 190,500 207,500 ‐ ‐ ‐ Transfer In ‐ AQMD Fund23,728 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 770,048$ 176,400$ 189,500$ 190,500$ 207,500$ ‐$ ‐$ ‐$ TOTAL REVENUE AVAILABLE 746,320$ 176,400$ 189,500$ 190,500$ 207,500$ ‐$ ‐$ ‐$ EXPENDITURES 16102‐Del Obispo Widening ‐ Via De La Paz 480,260 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfer Out to General Fund for Summer Trolley Program 266,060 176,400 189,500 190,500 207,500 TOTAL EXPENDITURES 746,320$ 176,400$ 189,500$ 190,500$ 207,500$ ‐$ ‐$ ‐$ ENDING FUND BALANCE‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 13 of 22 CITY OF SAN JUAN CAPISTRANOFUND 51 - OPEN SPACE ACQUISTION AND CONSTRUCTION FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,094,795$ 15,340$ 25,340$ 35,340$ 40,340$ 40,340$ 40,340$ 40,340$ REVENUES Interest7,500 10,000 10,000 5,000 ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 7,500$ 10,000$ 10,000$ 5,000$ ‐$ ‐$ ‐$ ‐$ TOTAL REVENUE AVAILABLE 1,102,295$ 25,340$ 35,340$ 40,340$ 40,340$ 40,340$ 40,340$ 40,340$ EXPENDITURES 09209‐Northwest Open Space Community Park1,086,955 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,086,955$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE15,340$ 25,340$ 35,340$ 40,340$ 40,340$ 40,340$ 40,340$ 40,340$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 14 of 22 CITY OF SAN JUAN CAPISTRANO FUND 52 - COMMUNITY FACILITIES DISTRICT BONDS FISCAL YEAR 2019/20 UPDATE AMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,770,434$ 536,749$ 556,749$ 576,749$ 586,749$ 591,749$ 596,749$ 601,749$ REVENUES Interest 10,000 20,000 20,000 10,000 5,000 5,000 5,000 5,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 10,000$ 20,000$ 20,000$ 10,000$ 5,000$ 5,000$ 5,000$ 5,000$ TOTAL REVENUE AVAILABLE 1,780,434$ 556,749$ 576,749$ 586,749$ 591,749$ 596,749$ 601,749$ 606,749$ EXPENDITURES 09209‐Northwest Open Space Community Park 1,218,685 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 19201‐Sports Park Field Improvement Study 25,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,243,685$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE536,749$ 556,749$ 576,749$ 586,749$ 591,749$ 596,749$ 601,749$ 606,749$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019. EXHIBIT A Page 15 of 22 CITY OF SAN JUAN CAPISTRANO FUND 53 - SUCCESSOR AGENCY NON-HOUSING BONDS FISCAL YEAR 2019/20 UPDATE AMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,884,087$ 78,267$ 88,267$ 98,267$ 103,267$ 103,267$ 103,267$ 103,267$ REVENUES Interest 12,000 10,000 10,000 5,000 ‐ ‐ ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 12,000$ 10,000$ 10,000$ 5,000$ ‐$ ‐$ ‐$ ‐$ TOTAL REVENUE AVAILABLE 1,896,087$ 88,267$ 98,267$ 103,267$ 103,267$ 103,267$ 103,267$ 103,267$ EXPENDITURES12502‐Camino Capistrano Off‐Ramp Catch Basins62,520 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 14106‐Verdugo Street Beautification Project 1,701,030 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16502‐Interstate I‐5/Ortega Hwy Storm Water Treatment Project54,270 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,817,820$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ENDING FUND BALANCE78,267$ 88,267$ 98,267$ 103,267$ 103,267$ 103,267$ 103,267$ 103,267$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 16 of 22 CITY OF SAN JUAN CAPISTRANOFUND 63 - DOMESTIC WATER CAPITAL REPLACEMENT FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE 1,889,126$ 256,696$ 1,193,696$ 430,696$ 430,696$ 1,415,696$ 2,120,696$ 1,070,696$ REVENUESTransfer In ‐ Domestic Water Operations (2)1,405,000 2,000,000 2,000,000 3,000,000 3,000,000 3,000,000 3,000,000 3,655,000 Interest10,000 12,000 12,000 20,000 20,000 20,000 20,000 20,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 1,415,000$ 2,012,000$ 2,012,000$ 3,020,000$ 3,020,000$ 3,020,000$ 3,020,000$ 3,675,000$ TOTAL REVENUE AVAILABLE 3,304,126$ 2,268,696$ 3,205,696$ 3,450,696$ 3,450,696$ 4,435,696$ 5,140,696$ 4,745,696$ EXPENDITURES07811‐760S Reservoir50,420 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 08801‐Joint Regional Water Supply System (JRWSS) 867,145 ‐ ‐ ‐ ‐ 505,000 100,000 100,000 Capital Replacements14702‐Las Ramblas/Paseo Activo Slope Replacement54,860 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 17802‐760S Zone Pump Station Discharge Line Replacement165,000 ‐ 800,000 800,000 ‐ ‐ ‐ ‐ 17806‐Water Facility Control Systems530,090 180,000 180,000 180,000 180,000 180,000 ‐ ‐ 17807‐Well Facility Replacement Program114,915 135,000 135,000 90,000 135,000 90,000 90,000 135,000 19803‐ GWRP Clear Well Replacement350,000 ‐ ‐ 250,000 ‐ ‐ ‐ ‐ 19804‐Pump Station Component Replacements 540,000 440,000 460,000 480,000 500,000 540,000 580,000 ‐ 19805‐Eastern Transmission System Repairs 375,000 100,000 200,000 220,000 220,000 ‐ ‐ ‐ 20801‐System Repairs and Upgrade of Appurtenances‐ 100,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 20802‐Safety Access Stair and Platform System‐ 120,000 ‐ ‐ ‐ ‐ ‐ ‐ xxxxx‐SJ Hills Greens and Estates Pipeline Replacement‐ ‐ ‐ ‐ ‐ ‐ 2,300,000 2,300,000 TOTAL EXPENDITURES 3,047,430$ 1,075,000$ 2,775,000$ 3,020,000$ 2,035,000$ 2,315,000$ 4,070,000$ 3,535,000$ ENDING FUND BALANCE 256,696$ 1,193,696$ 430,696$ 430,696$ 1,415,696$ 2,120,696$ 1,070,696$ 1,210,696$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019(2) The Water Capital Replacement Program will require additional funding from water ratepayers in the City's future rate study to meet the capital needs of the City's water systemEXHIBIT A Page 17 of 22 CITY OF SAN JUAN CAPISTRANOFUND 64 - DOMESTIC WATER CAPITAL IMPROVEMENT FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE1,278,098$ 1,088,353$ 1,362,353$ 3,373,353$ 4,142,353$ 3,846,353$ 3,152,353$ 2,426,353$ REVENUES Water Capital Improvement Charge 138,000 206,000 621,000 272,000 133,000 20,000 12,000 ‐ Water Capacity Charge 179,000 268,000 807,000 354,000 173,000 27,000 15,000 ‐ Water Storage Fees 165,000 260,000 768,000 328,000 168,000 29,000 17,000 ‐ Interest 10,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 492,000$ 749,000$ 2,211,000$ 969,000$ 489,000$ 91,000$ 59,000$ 15,000$ TOTAL REVENUE AVAILABLE 1,770,098$ 1,837,353$ 3,573,353$ 4,342,353$ 4,631,353$ 3,937,353$ 3,211,353$ 2,441,353$ EXPENDITURES07803‐Terminal Reservoir No. 3 45,470 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 07811‐760S Reservoir 28,970 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16801‐La Pata Water Line Replacement 5,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 16804‐Water Master Plan Study 100,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 17801‐San Juan Hills Greens Cathodic Protection System253,325 275,000 ‐ ‐ ‐ ‐ ‐ ‐ 17803‐Valve Insertion Program166,465 200,000 200,000 200,000 200,000 200,000 200,000 200,000 17804‐Capistrano Royale Fire Flow Pump82,515 ‐ ‐ ‐ ‐ ‐ ‐ ‐ xxxxx‐Groundwater Recharge with Storm Water ‐ ‐ ‐ ‐ 585,000 585,000 585,000 585,000 TOTAL EXPENDITURES 681,745$ 475,000$ 200,000$ 200,000$ 785,000$ 785,000$ 785,000$ 785,000$ ENDING FUND BALANCE1,088,353$ 1,362,353$ 3,373,353$ 4,142,353$ 3,846,353$ 3,152,353$ 2,426,353$ 1,656,353$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019EXHIBIT A Page 18 of 22 CITY OF SAN JUAN CAPISTRANOFUND 65 - NON-POTABLE WATER CAPITAL IMPROVEMENTS FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE564,096$ 786,216$ 1,409,216$ 1,712,216$ 409,216$ 582,216$ 1,262,216$ 1,962,216$ REVENUES Water Capacity Charge151,000 182,000 342,000 7,000 ‐ ‐ ‐ ‐ Grants‐MWDOC42,485 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Interest 5,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Transfer In ‐ Non‐Potable Water Operations 400,000 630,000 800,000 900,000 800,000 800,000 800,000 800,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 598,485$ 813,000$ 1,143,000$ 908,000$ 801,000$ 801,000$ 801,000$ 801,000$ TOTAL REVENUE AVAILABLE 1,162,581$ 1,599,216$ 2,552,216$ 2,620,216$ 1,210,216$ 1,383,216$ 2,063,216$ 2,763,216$ EXPENDITURES xx601‐Annual Recycled Water Service Conversions Project241,765 170,000 170,000 170,000 170,000 ‐ ‐ ‐ 16602‐Non‐Potable Water Pipelines75,700 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 17601‐Trampas Canyon Recycled Water Reservoir‐ ‐ 10,000 101,000 101,000 101,000 101,000 101,000 17806‐Water Facility Control Systems58,900 20,000 20,000 20,000 20,000 20,000 ‐ ‐ 18601‐Calle Arroyo Recycled Pipeline ‐ ‐ 475,000 1,820,000 337,000 ‐ ‐ ‐ xxxxx‐Recycled Water Master Plan‐ ‐ 165,000 100,000 ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 376,365$ 190,000$ 840,000$ 2,211,000$ 628,000$ 121,000$ 101,000$ 101,000$ ENDING FUND BALANCE786,216$ 1,409,216$ 1,712,216$ 409,216$ 582,216$ 1,262,216$ 1,962,216$ 2,662,216$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019EXHIBIT A Page 19 of 22 CITY OF SAN JUAN CAPISTRANOFUND 71 - SEWER CAPITAL REPLACEMENT FUNDFISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE2,192,048$ 1,007,298$ 872,298$ 520,298$ 704,298$ 1,371,298$ 1,528,298$ 1,325,298$ REVENUES Transfer In ‐ Sewer Enterprise Operations 1,000,000 1,500,000 1,995,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 Interest12,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 1,012,000$ 1,515,000$ 2,010,000$ 1,515,000$ 1,515,000$ 1,515,000$ 1,515,000$ 1,515,000$ TOTAL REVENUE AVAILABLE 3,204,048$ 2,522,298$ 2,882,298$ 2,035,298$ 2,219,298$ 2,886,298$ 3,043,298$ 2,840,298$ EXPENDITURES XX701‐Annual Sewer Replacement Program1,611,415 400,000 550,000 550,000 600,000 600,000 600,000 600,000 07701‐South Orange County Wastewater Authority 46,650 1,250,000 1,812,000 781,000 223,000 738,000 1,118,000 905,000 PC#2 & #5 Rehabilitation 08701‐Food, Oils & Grease (FOG) Interceptor Program89,815 ‐ ‐ ‐ 25,000 20,000 ‐ ‐ 14702‐Las Ramblas/Paseo Activo Slope Replacement448,870 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 2,196,750$ 1,650,000$ 2,362,000$ 1,331,000$ 848,000$ 1,358,000$ 1,718,000$ 1,505,000$ ENDING FUND BALANCE1,007,298$ 872,298$ 520,298$ 704,298$ 1,371,298$ 1,528,298$ 1,325,298$ 1,335,298$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 20 of 22 CITY OF SAN JUAN CAPISTRANOFUND 72 - SEWER CAPITAL IMPROVEMENT FUND FISCAL YEAR 2019/20 UPDATEAMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE3,410,438$ 3,245,268$ 1,875,768$ 1,562,768$ 980,768$ 670,768$ 278,768$ 182,768$ REVENUES Sewer Connection Fees710,000 1,193,000 1,450,000 868,000 559,000 163,000 104,000 ‐ Loan Repayment from Water Operations Fund 737,500 320,000 ‐ ‐ ‐ ‐ ‐ ‐ Loan Repayment from Successor Agency120,000 240,000 ‐ ‐ ‐ ‐ ‐ ‐ Loan Interest7,500 2,500 ‐ ‐ ‐ ‐ ‐ ‐ Investment Interest35,000 25,000 25,000 25,000 25,000 25,000 ‐ ‐ TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 1,610,000$ 1,780,500$ 1,475,000$ 893,000$ 584,000$ 188,000$ 104,000$ ‐$ TOTAL REVENUE AVAILABLE 5,020,438$ 5,025,768$ 3,350,768$ 2,455,768$ 1,564,768$ 858,768$ 382,768$ 182,768$ EXPENDITURES 07701‐South Orange County Wastewater Authority 1,528,945 3,150,000 1,788,000 1,475,000 894,000 580,000 200,000 95,000 PC#2 & #5 Rehabilitation 07703‐New Hydraulic Capital Project #6 3,540 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 08701‐Food, Oils & Grease (FOG) Interceptor Program42,685 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 17702‐Sewer Flow Metering & SCADA Monitoring Project 200,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ TOTAL EXPENDITURES 1,775,170$ 3,150,000$ 1,788,000$ 1,475,000$ 894,000$ 580,000$ 200,000$ 95,000$ ENDING FUND BALANCE3,245,268$ 1,875,768$ 1,562,768$ 980,768$ 670,768$ 278,768$ 182,768$ 87,768$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 21 of 22 CITY OF SAN JUAN CAPISTRANO FUND 81 - FACILITIES OPERATIONS FUND FISCAL YEAR 2019/20 UPDATE AMENDED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSEDDescription 2018/19 (1) 2019/20 2020/21 2021/22 2022/23 2023/24 2024/25 2025/26BEGINNING FUND BALANCE‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ REVENUESCurrent Year Project Funding455,345 152,000 152,000 152,000 152,000 152,000 152,000 152,000 TOTAL ‐ PROJECTED REVENUES AND OTHER SOURCES 455,345$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ TOTAL REVENUE AVAILABLE 455,345$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ EXPENDITURES15306‐ADA Self Evaluation and Transition Plan455,345 152,000 152,000 152,000 152,000 152,000 152,000 152,000 TOTAL EXPENDITURES 455,345$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ 152,000$ ENDING FUND BALANCE‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ (1) Per the City's Fiscal Year 2018/19 Third Quarter Financial Report that was approved by the City Council on May 21, 2019.EXHIBIT A Page 22 of 22