Loading...
CC SR 20160606 04 - Draft 2017 5-Year Financial ModelRANCHO PALOS VERDES CITY COUNCIL MEETING DATE: 06/06/2016 AGENDA REPORT AGENDA HEADING: Regular Business AGENDA DESCRIPTION: Consideration and possible action to receive and file the draft 2017 Five -Year Financial Model. RECOMMENDED COUNCIL ACTION: (1) Receive and file the draft 2017 Five -Year Financial Model (2017 Model); and (2) Provide direction to Staff regarding any assumptions included within the 2017 Model. FISCAL IMPACT: None Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Allan Kaufman, Senior Administrative Analyst REVIEWED BY: Deborah Cullen, Director of Finance lo— APPROVED — APPROVED BY: Doug Willmore, City Manager"A/�'J ATTACHED SUPPORTING DOCUMENTS: A. One Page Summary — 2017 Five -Year Financial Model (page A-1) B. Draft 2017 Five -Year Financial Model by Fund (page B-1) C. Draft 2017 Capital Improvement Project Expenditures (page C-1) D. Draft 2017 Water Quality Flood Protection (WQFP) Expenses (page D-1) BACKGROUND AND DISCUSSION Introdim-tinn The draft 2017 Five -Year Financial Model (Model) is based on the current version of the FY16-17 draft budget, which includes decisions made by the City Council during its Budget Workshop held on April 11t". If any changes are identified during the May 31St Budget Workshop staff will update the model accordingly. The draft 2017 Model indicates that General Fund activity is balanced. The General Fund unrestricted surplus, after factoring the policy reserve of 50% of operating expenditures, is estimated to range from $1.7 million to $2.0 million each year over the next five years. There are two noteworthy shortfalls to consider for future years: 1 Highway Users Tax has decreased by approximately $350,000 annually. As a result, estimated expenditures will outpace estimated revenues annually by an estimated $800,000 to $1,000,000. The Storm Drain User Fee ends in FY15-16. Without an alternate revenue stream, storm drain improvements are expected to compete with other infrastructure projects for General Fund money beginning FY17-18. The draft 2017 Model indicates that the Capital Improvement Project (CIP) fund balance (which includes the $3 million policy reserve) will be reduced to approximately $10 million by year 5, based on the current 5 -year capital projects list. A policy change should be noted in that the City is re -budgeting capital projects that have not been encumbered, rather than automatically continuing appropriations year -over -year. This enables the City Council to review and assess projects annually and determine if priorities or funding has changed. Staff began presenting all budgeted capital appropriations, including the amounts requested to be committed in the FY15-16 column of the 2017 Model. Therefore, in years 1 through 5 of the 2017 model, estimated beginning fund balances were already reduced by the proposed project funds to be expended and committed. It is important to note that while the City has enough funds to cover capital projects outlined in the model, there are still a number of infrastructure needs identified that were not included in the model since related funding has not been secured. Staff made an important change to how the General Fund budget program expenditures are presented in the model. In the past, the model combined personnel and non - personnel costs. To enhance transparency and give the user a more detailed look at General Fund expenditures by program, Staff delineated salary, benefits and non - personnel expenditures beginning in FY16-17. The City's infrastructure resources in FY16-17 total about $7.3 million, and include the following: • Restricted funding sources (grants, apportionments, and developer fees) averaging about $2.1 million; and, • General Fund revenue of about $5.2 million (Transient Occupancy Tax). The City's infrastructure needs can be summarized as follows: • Abalone Cove sewer rehabilitation totaling $2 million over the next five years; • Landslide mitigation totaling approximately $4.1 million over the next five years. Of this amount, an estimated $1.1 million appropriation is being proposed for FY16-17; • Residential street rehabilitation totaling $17.7 million over the next five years; • Arterial street rehabilitation totaling $9.1 million over the next five years; • Water quality compliance projects totaling approximately $6.7 million over the next five years; 2 • Park and trail improvement projects totaling over $2.2 million over the next five years; • Storm drain improvements (approximately $14.4 million over the next five years); • City -owned facility rehabilitation (minimum estimates totaling approximately $1.5 million for Citywide ADA Program, RPVty Building Improvements, Civic Center Master Plan, and PVIC Exhibit project). Overview The 2017 Model is a financial schedule prepared by the Finance Department (Attachments A through D) as required by City Council Policy. The 2017 Model includes all funds and its component unit, the Rancho Palos Verdes Improvement Authority. The 2017 Model includes the presentation of: ► FY13-14 and FY14-15 actuals and ending fund balances for all funds; ► FY14-15 final adjusted budget and the calculated budget variance for revenue, expenditures and ending fund balances for all funds; P. FY15-16 Adopted Budget; and, ► FY16-17 preliminary budget (Economic Assumptions described below). The 2017 Model includes the segregation of funds as follows: ► General Fund — The General Fund balance is separated by the 50% reserve policy and the unrestricted balance. ► Funds restricted by action of the City Council — The balances of these funds are restricted by City Council action for specific purpose. The funds were initiated with transfers from the General Fund. These funds may be transferred back to General Fund or use for other purposes (e.g., infrastructure projects) upon the action of the City Council. ► Funds restricted by law or external agencies — The balances of these funds are restricted by law or external agencies, such as the Federal Government, State of California, or Los Angeles County. These monies can only be used for the purpose outlined by the terms and conditions set by legislation and voter ballot measures. It should be noted that future economic activity, legislation and policy decisions, as well as any other unforeseen circumstances, could affect the City's revenue stream and expenditures during any of the years presented in the 2017 Model. Economic Assumptions The following assumptions have been made during preparation of the 2017 Model. 1. The 2017 Model is based upon the preliminary budget and the draft 2017 Capital Improvement Plan. The increase of the Consumer Price Index (CPI) for urban 3 consumers, as projected by the Congressional Budget Office, was applied and one-time expenditures were removed in each subsequent year. Approximately 33% of General Fund uses (expenditures and transfers to other funds) represent the cost of employee compensation, salaries and benefits. Wages in FY16-17 included 1.7% COLA and 2% averaged salary merit adjustments based upon each employee's annual performance evaluation. Any changes to employee compensation beyond FY16-17, are subject to negotiation between the employee association and the City. Therefore, the 2017 Model assumes that employee compensation for years 2 through 5 of the model will increase by CPI (the same assumption for all other expenditures of the City); and the actual compensation level will not be determined until the negotiation process is complete. 2. Sales tax revenue is generally expected to remain flat or slightly reduced over the five year period outlined in the model. This information is based upon the most conservative estimate provided by MuniServices LLC. 3. The City's property assessments are expected to see a modest 2% increase in FY 2016-17. Staff has assumed that property tax will grow at a rate of 3.9% annually for the remaining 4 years of the 2017 Model. Staff based its estimates on information provided by HdL LLC. 4. The Los Angeles County Sheriff's Department (Sheriff) has advised Staff to expect a 6.2% increase in contract costs for FY16-17. The primary reason for this increase is tied to an increase in general liability insurance. The Sheriff's contract is the single largest expenditure in the General Fund, and has grown by an average of 3.0% over the last five years. Staff has assumed a continued 3.0% average growth rate over the next five years. 5. Permit fees are based on the fully burdened hourly rate of Staff multiplied by the estimated time to provide the service, as the law requires that permit fees cannot exceed the City's cost. Although Staff expects that another cost based fee study will be completed during the next five years, Staff cannot predict the impact of that study or the resulting City Council action to set fee rates. Therefore, Staff has not included any assumed increases in permit fee rates for the 2017 Model. Permit revenue is also based on the volume of development activity in the City. Based upon the fact that the City is mostly built out and permit activity levels are unpredictable, Staff has not included any assumed increases or decreases in permit activity for the 2017 Model. 6. About 80% of the City's cash is invested with the state's Local Agency Investment Fund (LAIF), which is an actively managed portfolio. The LAIF investment earnings rate has averaged 34 basis points (0.34%) during FY15-16. Therefore, Staff is expecting a modest interest rate increase of 35 basis points (0.35%), which appears more in line with projected returns. El Based on Staff's recommendation, the City Council approved a custodian agreement with Vining -Sparks IBG in March 2016 as a way to diversify the City's portfolio and leverage the idle cash the City has to enhance investment returns while adhering to the City's investment policy. If investment returns are forecasted to change by a material amount in the future, Finance will update the model accordingly. 7. Utility User Tax (UUT) and Franchise Fees are dependent on outside factors such as weather conditions and rate increases, which cannot be predicted over the long-term with any accuracy. In general, Staff has assumed that UUT and franchise tax will increase by the CPI for urban consumers, as projected by the Congressional Budget Office. Over the past 10 years, Franchise Fees have increased an average of 4.6% per year; and UUT has increased an average of 3.3% per year. Some of this increase is attributable to the opening of the Terranea Resort. Using the CPI is a conservative method of estimating these future revenues. 8. Transient Occupancy Tax (TOT) accounted for about 17.1 % of the City's FY14- 15 General Fund revenue. Per the City Council's Reserve Policy, TOT amount is transferred to the CIP Fund each year as a funding source for infrastructure improvements and to maintain a minimum $3 million reserve. The City receives most of its TOT revenue from the Terranea Resort, which opened in 2009. Staff has observed that the growth rate of TOT has not been slowing. Based on industry information, Staff is assuming a 9% growth rate for TOT revenue in FY16-17. For the remaining 4 years of the 2017 Model, Staff has conservatively assumed that TOT will continue to grow by about 3%, which is slightly higher than CPI. Other Assumptions Specific to the 2017 Model 9. Pursuant to state redevelopment dissolution law, on January 31, 2012 the Rancho Palos Verdes Redevelopment Agency (RDA) was dissolved. The City elected to serve as the Successor Agency to the former RDA. The City's General Fund loaned money to the former RDA for landslide mitigation projects and administration. As of June 30, 2015, the outstanding loan balance (including accrued interest) was $10.5 million. The Successor Agency has completed the steps necessary for the City's loan to become a recognized obligation with small repayments beginning in FY14-15. Based upon the repayment formula outlined in state law, a maximum of $221,500 may be repaid during FY16-17. Of this amount, 80% can be deposited into the General Fund, and 20% must be deposited into the Low -Moderate Housing Fund. Staff has included this amount as repayment revenue for all five years of the 2017 Model; however actual repayments will be based upon the availability of redevelopment property tax revenue. �� Separately, as part of administering the Successor Agency and supporting the activities of the Oversight Board representing various taxing entities, the City receives reimbursement of administrative costs (staff time, a share of general liability insurance, etc.). The annual reimbursement is currently estimated to be $60,000. Beginning in FY17-18, individual oversight boards will be consolidated into a single county -wide oversight board. Staff has assumed that the administrative reimbursement will no longer be available beginning in FY17-18. 10. The General Fund provides subsidies to a number of funds, as the restricted funding sources for those activities are insufficient to provide for the current level of maintenance. A. The Improvement Authority's Portuguese Bend Fund will call for an annual General Fund subsidy of about $72,000 beginning in year 3 (FY18-19) with the subsidy increasing to $126,000 in year 5. There is no other source of revenue for maintenance activities in the Portuguese Bend portion of the landslide area. B. The Improvement Authority's Abalone Cove Fund will continue to require an annual General Fund subsidy of about $68,000. The interest earnings on the $1 million non -spendable fund balance required by the Horan Agreement is not sufficient to pay for maintenance of dewatering wells in the Abalone Cove portion of the landslide area. The Horan Agreement is the 1987 settlement of a lawsuit related to the City's active landslide. C. The Abalone Cove Sewer District will require an annual General Fund subsidy of $218,000, due to the maintenance demands of the system. Property assessments are not sufficient to maintain the unique system that provides for 110 developed parcels in an active landslide area. In addition to addressing the maintenance demands, Public Works has identified capital replacement needs that average $400,000 annually. This rehabilitation program will be introduced in the five-year Capital Improvement Plan (CIP). D. As part of its development agreement with the City, the developer of the Subregion 1 tract (now Oceanfront Estates) was required to dedicate open space to the City and provide a $750,000 endowment for future maintenance of that open space. The estimated fund balance and interest earnings from the non -spendable endowment are expected to be sufficient in FY16-17 to provide for the current level of maintenance. However, in years 2 through 4, there will not be adequate funding, which might necessitate an annual General Fund subsidy of about $105,000. 12. The City uses an Equipment Replacement Fund to centralize accounting for purchases of the City's equipment, furniture and vehicles and to accumulate money for the replacement of these items. Various programs are charged with an allocation annually based on the Equipment Replacement Schedule to on accumulate funding for replacement of these items. The City Council's Reserve Policy requires the fund balance be maintained at a level equivalent to the estimated replacement cost of the capitalized equipment. 13. The City's employee pension plan includes 3 tiers of benefits based upon local pension reform and state pension reform. CalPERS has set the employer normal cost contribution rates for FY16-17. Based upon additional information from CalPERS, the estimated employer contribution rates for years 2 through 5 of the 2017 Model follow. Over the last 10 years, employee turnover has averaged 8% annually (or 5 full- time positions). For purposes of the 2017 Model, Staff has assumed that employee turnover will continue at the same rate. With that, Staff assumed that 3 positions will begin earning Tier 2 benefits, and 2 position will begin earning Tier 3 benefits. Based on those assumptions, estimated full-time employee participation in each Tier has been calculated as follows. 1st Tier 2nd Tier 3rd Tier FY16-17 10.069% 7.159% 6.555% FY17-18 10.100% 7.200% 6.600% FY18-19 10.100% 7.200% 6.600% FY19-20 10.100% 7.200% 6.600% FY20-21 10.100% 7.200% 6.600% Over the last 10 years, employee turnover has averaged 8% annually (or 5 full- time positions). For purposes of the 2017 Model, Staff has assumed that employee turnover will continue at the same rate. With that, Staff assumed that 3 positions will begin earning Tier 2 benefits, and 2 position will begin earning Tier 3 benefits. Based on those assumptions, estimated full-time employee participation in each Tier has been calculated as follows. Blending the employer contribution rates for each Tier with estimated employee participation results in the following composite rates used for the 2017 Model. Composite Rate FY16-17 8.344% Total 8.140% 1st Tier 2nd Tier 3rd Tier Full -Time FY16-17 30 18 17 65 FY17-18 25 21 19 65 FY18-19 20 24 21 65 FY19-20 15 27 23 65 FY20-21 10 30 25 65 Blending the employer contribution rates for each Tier with estimated employee participation results in the following composite rates used for the 2017 Model. Composite In addition to the normal cost contributions, the City is required to make a payment towards the unfunded liability for the Tier 1 plan; which was estimated 7 Rate FY16-17 8.344% FY17-18 8.140% FY18-19 7.898% FY19-20 7.657% FY20-21 7.415% In addition to the normal cost contributions, the City is required to make a payment towards the unfunded liability for the Tier 1 plan; which was estimated 7 by CalPERS to be $6.69 million at June 30, 2014. The actual FY16-17 payment is set, and payments for the following years are estimated. Unfunded Liability Contribution FY16-17 $413,658 FY17-18 $496,029 FY18-19 $582,988 FY19-20 $674,718 FY20-21 $714,503 14. The 2017 Model indicates that Proposition A money will accumulate over the next 5 years (transit expenditures are less than the restricted revenue received). Even with this assumption, Staff feels the City should explore the possibility of exchanging General Fund money for unused Proposition A money that other Cities have identified for exchange. The City could then use the additional Proposition A funds to cover eligible transit and street projects. The current market exchange rate appears to be about 75 cents on the dollar. Capital Spending Assumptions 15. Staff has included projects recommended in the draft 2017 Five -Year Capital Improvement Plan to repair and improve the City's infrastructure over the course of the 2017 Model. City Council approves projects one year at a time with the annual budget process. 16. There is an estimated cost of at least $4.0 million to line about 18,000 linear feet of pipe in "urgent" condition. In addition, the Master Plan of Drainage completed in June 2015 has identified at least $14 million of projects over the next five years to correct hydrologic and capacity deficiencies. Storm Drain projects will need to compete with other infrastructure projects for General Fund money beginning in year 2 (FY17-18) of the model. ALTERNATIVES: In addition to Staff's recommendations, the following alternative actions are available for the City Council's consideration: 1. Provide direction to Staff on any assumptions included within the draft 2017 Model. 2. Take other action as deemed appropriate related to the draft 2017 Model. CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL Revised 6/2/2016 FY16-17 Estimated Appropriations Fund Balance FY16-17 Estimated Resources Fund 6/30/2016 Revenues Transfers In General Fund Balance 12,938,225 Restricted Amount (Policy Reserve) (10,468,374) 13, 989, 057 GENERAL FUND Unrestricted Balance 2,469,851 28,614,000 190,000 Restricted by Council Action (11,443,950) (11,763,150) BEAUTIFICATION FUND 1,255 900 - CIP 20,397,307 1,054,400 5,200,000 EQUIPMENT REPLACEMENT 2,865,804 132,030 - BUILDING REPLACEMENT - - EMPLOYEE BENEFITS - - Subtotal 23,264,366 1,187,330 5,200,000 Restricted by Law or External Agencies 19,569,407 15,460,207 STREET MAINTENANCE 952,336 842,600 - 1972 ACT 27,898 260,200 EL PRADO LIGHTING 24,010 2,300 CDBG - 192,400 1911 ACT 1,784,350 555,600 WASTE REDUCTION 436,067 208,100 AIR QUALITY MANAGEMENT 103,382 50,300 PROPOSITION C 304,998 649,100 PROPOSITION A 381,666 781,300 PUBLIC SAFETY GRANTS 27,202 100,200 MEASURE R 1,631,622 489,600 HABITAT RESTORATION 1,444,712 4,900 SUBREGION 1 MAINTENANCE 798,296 2,700 MEASURE A - 90,000 - ABALONE COVE SEWER DISTRICT 98,024 55,400 208,000 GINSBURG CULTURAL ARTS BUILDING 102,329 300 - DONOR RESTRICTED CONTRIBUTIONS 873,200 2,800 QU IMBY 2,431,981 5,900 LOW -MOD INCOME HOUSING 55,519 44,300 AFFORDABLE HOUSING IN LIEU 589,132 1,900 ENVIRONMENTAL EXCISE TAX 139,348 23,200 BIKEWAYS 97 82,500 WATER QUALITY/FLOOD PROTECTION 2,526,248 8,000 IMPROV AUTH - PORTUGUESE BEND 279,509 1,100 - IMPROV AUTH - ABALONE COVE 1,034,006 3,400 38,000 Subtotal of Restricted Funds in Deficit 3,478,584 850,600 - Subtotal of Other Restricted Funds 12,567,348 3,607,500 246,000 GRAND TOTAL 52,248,523 34,259,430 5,636,000 Revised 6/2/2016 FY16-17 Estimated Appropriations Fund Balance 6/30/2017 Fund Balance 6/30/2018 Fund Balance 6/30/2019 Fund Balance 6/30/2020 Fund Balance 6/30/2021 Expenditures Transfers Out 13, 408, 325 13, 655, 954 13, 989, 057 14, 023, 292 14, 354, 347 (11,443,950) (11,763,150) (11,962,150) (12,366,200) (12,580,600) (22,887,900) (5,446,000) 1,964,375 1,892,804 2,026,907 1,657,092 1,773,747 2,155 2,155 2,155 2,155 2,155 (7,082,300) 19,569,407 15,460,207 11,110,007 10,271,307 10,049,607 (687,000) 2,310,834 2,456,734 2,561,734 2,443,434 2,191,834 0 0 0 0 0 0 0 0 0 0 (7,769,300) 21,882,396 17,919,096 13,673,896 12,716,896 12,243,596 (1,635,500) 159,436 (676,504) (1,552,804) (2,469,904) (3,428,804) (241,500) 46,598 64,698 82,198 99,098 115,298 (800) 25,510 27,010 28,510 30,010 31,510 (192,400) 0 0 0 0 0 (487,000) 1,852,950 1,921,750 1,989,950 2,057,550 2,124,450 (278,600) 365,567 292,467 216,567 137,967 56,467 (50,000) 103,682 104,082 104,482 104,882 105,282 (550,000) 404,098 464,898 460,098 461,198 483,298 (638,300) 524,666 607,566 655,966 695,666 744,366 (100,000) 27,402 27,502 27,602 27,702 27,802 2,121,222 2,585,622 3,039,722 3,499,922 3,977,422 (166,500) 1,283,112 1,117,112 946,412 770,912 590,512 (44,800) 756,196 712,896 668,396 622,596 575,496 (90,000) 0 0 0 0 0 (223,100) 138,324 179,524 221,424 264,024 307,124 102,629 103,029 103,429 103,829 104,229 (460,000) 416,000 417,500 419,000 420,500 422,000 (575,000) 1,862,881 1,519,381 1,524,681 1,529,981 1,535,381 99,919 144,519 189,319 234,319 279,419 591,032 593,132 595,232 597,332 599,432 162,548 13,148 13,148 13,148 13,148 (82,500) 97 97 97 82,597 82,897 (2,343,800) 190,448 (4,191,947) (6,428,024) (9,567,870) (11,880,577) (114,900) 165,709 48,609 309 909 509 (74,600) 1,000,806 1,000,906 1,000,206 1,000,606 1,000,106 (3,979,300) 349,884 (4,868,451) (7,980,828) (12,037,774) (15,309,381) (4,180,000) (190,000) 12,050,948 11,945,448 12,286,748 12,754,748 13,176,148 (38,816,500) (5,636,000) 47,691,553 38,652,047 31,968,873 27,457,162 24,464,710 A-1 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 1 o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FYI 3-14 FY14-15 FY14-15 FY14-15 FYI 5-16 FYI 6-17 FY17-18 FY18-19 FYI 9-20 FY20-21 / Increase % Increase / Increase % Increase % Increase % Increase % Increase % Increase % Increase % Increase ECONOMIC MODEL INPUT FACTORS (a -ph Maximum Property Assessment Increase (a) N/A N/A N/A N/A N/A 2.0% 2.0% 2.0% 2.0% 2.0% Increase Factor (%) Non -Personnel Expenditures (b) N/A N/A N/A N/A N/A 2.2% 2.4% 2.4% 2.4% 2.4% Increase Factor (%) Personnel Expenditures (c) N/A N/A N/A N/A N/A 2.2% 2.4% 2.4% 2.4% 2.41/6 Consumer Price Index (%) (d) N/A N/A N/A N/A N/A 2.2% 2.4% 2.4% 2.49/6 2.4% Sales Tax (%) (e) N/A N/A N/A N/A N/A 2.4% -5.8% -2.6% 1.0% 3.5% Property Taxes (%) (f) N/A N/A N/A N/A N/A 0.001% 0.0% 0.0% 0.0% 0.0% Sheriff Contract (%) (g) N/A N/A N/A N/A N/A 3.0% 3.0% 3.0% 3.00/6 3.00/. Permit Revenues (%) (h) N/A N/A N/A N/A N/A 0.0% 0.0% 0.01/6 0.0% 0.0% Investment Interest (%) (i) N/A N/A N/A N/A N/A 0.4% 0.41/6 0.4% 0.4% 0.4% Franchise Tax (%) (1) N/A N/A N/A N/A N/A 2.2% 2.49/6 2.49/6 2.49/6 2.49/6 Utility Users Tax (%) (k) N/A N/A N/A N/A N/A 2.2% 2.4% 2.49/6 2.4% 2.49/6 95 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 2 o LL ACTUAL FY13-14 BUDGET FY14-15 ACTUAL FY14-15 VARIANCE FY14-15 BUDGET FY15-16 PROPOSED FY16-17 MODEL FY17-18 MODEL FY18-19 MODEL FY19-20 MODEL FY20-21 SUMMARY OF ENDING UNRESERVED FUND BALANCES UNRESTRICTED FUND (101) General Fund a 3 13,839,22611 12,883,772 1 15,133,238 2,249,466 12,938,225 13,408,325 13,655,954 13,989,057 14,023,292 14,354,347 RESTRICTED BY COUNCIL ACTION (212) Beautification Fund _LO_A 793,921 96,921 571,856 474,935 1,255 2,155 2,155 2,155 2,155 2,155 (330) CIP Fund 11 22,124,281 28,164,520 24,560,456 (3,604,064) 20,397,307 19,569,407 15,460,207 11,110,007 10,271,307 10,049,607 (681) Equipment Replacement Fund 12 1 2,915,898 2,837,612 2,994,104 156,492 2,865,804 2,310,834 2,456,734 2,561,734 2,443,434 2,191,834 (686) Building Replacement Fund13 942,609 4,709 0 (4,709) 0 0 0 0 0 0 (685) Employee Benefits Fund 14 149,347 149,587 131,428 (18,159) 0 0 0 0 0 0 SUBTOTAL 26,926,056 31,253,349 28,257,844 (2,995,505) 23,264,366 21,882,396 17,919,096 13,673,896 12,716,896 12,243,596 RESTRICTED BY LAW OR EXTERNAL AGENCIES City Funds (202) Street Maintenance Fund 15 1,271,895 1,068,378 1,312,717 244,339 952,336 159,436 (676,504) (1,552,804) (2,469,904) (3,428,804) (203) 1972 Act Landscape & Lighting Fund 16 62,663 42,503 47,203 4,700 27,898 46,598 64,698 82,198 99,098 115,298 (209) EI Prado Lighting Fund 17 21,180 22,120 22,810 690 24,010 25,510 27,010 28,510 30,010 31,510 (310) CDBG Fund 18 (68,671) 171,036 (11,624) (182,660) 0 0 0 0 0 0 (211)1911 Act Street Lighting Fund19 1,756,659 1,722,059 1,794,850 72,791 1,784,350 1,852,950 1,921,750 1,989,950 2,057,550 2,124,450 (213) Waste Reduction Fund 20 397,797 370,436 492,920 122,484 436,067 365,567 292,467 216,567 137,967 56,467 (214) Air Quality Management Fund21 86,277 86,487 102,602 16,115 103,382 103,682 104,082 104,482 104,882 105,282 (215) Proposition C (Streets/Transit) Fund22 1,317,793 (59,447) 192,990 252,437 304,998 404,098 464,898 460,098 461,198 483,298 (216) Proposition A (Transit) Fund 23 1 441,525 31,429 236,073 204,644 381,666 524,666 607,566 655,966 695,666 744,366 (217) Public Safety Grants24 20,570 20,610 27,012 6,402 27,202 27,402 27,502 27,602 27,702 27,802 (220) Measure R 25 11250,257 146,530 1,153,223 1,006,693 1,631,622 2,121,222 2,585,622 3,039,722 3,499,922 3,977,422 (222) Habitat Restoration Fund - NCCP 26 1,443,461 1,445,462 1,469,702 24,240 1,444,712 1,283,112 1,117,112 946,412 770,912 590,512 (223) Subregion 1 Maintenance Fund 27 821,968 802,168 818,596 16,428 798,296 756,196 712,896 668,396 622,596 575,496 (224) Measure A Cap. & Maint. Funds 28 (47,633) (47,533) (47,302) 231 0 0 0 0 0 0 (225) Abalone Cove Sewer District Fund29 71,318 83,695 87,164 3,469 98,024 138,324 179,524 221,424 264,024 307,124 (227) Ginsburg Cultural Arts Building Fund 30 119,161 101,421 101,419 (2) 102,329 102,629 103,029 103,429 103,829 104,229 (228) Donor Restricted Contributions Fund 31 865,681 835,031 870,740 35,709 873,200 416,000 417,500 419,000 420,500 422,000 (334) Quimby Fund 32 57,861 835,785 1,337,510 501,725 2,431,981 1,862,881 1,519,381 1,524,681 1,529,981 1,535,381 (336) Low -Moderate Income Housing Fund 33 23,520 23,520 45,941 22,421 55,519 99,919 144,519 189,319 234,319 279,419 (337) Affordable Housing In -Lieu Fund 34 499,928 501,018 584,622 83,604 589,132 591,032 593,132 595,232 597,332 599,432 (338) Environmental Excise Tax (EET) Fund 35 413,184 260,763 336,998 76,235 139,348 162,548 13,148 13,148 13,148 13,148 (340) Bikeways (TDA Article 3) Fund36 72 72 97 25 97 97 97 97 82,597 82,897 (501) Water Quality & Flood Protection Fund 37 5,317,323 863,848 5,333,829 4,469,981 2,526,248 190,448 (4,191,947) (6,428,024) (9,567,870) (11,880,577) Improvement Authority Funds (285) Improvement Authority- Portuguese Bend 38 362,456 300,496 333,189 32,693 279,509 165,709 48,609 309 909 509 (795) Improvement Authority- Abalone Cove 39 1,081,548 1,048,548 1,059,506 0 1,034,006 1,000,806 1,000,906 1,000,206 1,000,606 1,000,106 SUBTOTAL 17,587,793 10,676,435 17,702,787 7,015,394 16,045,932 12,400,832 i 7,076,997 4,305,920 716,974 (2,133,233) GRAND TOTAL - ALL FUNDS INCLUDED 58,353,075 54,813,556 61,093,869 6,269,355 52,248,523 47,691,553 38,652,047 31,968,873 27,457,16224,464,710 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) 9w o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 3 GENERAL FUND REVENUE DETAIL Property taxes (e) 6,751,036 7,033,100 7,007,129 (25,971) 7,281,261 7,278,000 7,614,628 7,897,192 8,193,842 8,504,314 Property taxes In -Lieu of VLF Revenues (e) 3,890,110 4,024,200 4,061,473 37,273 4,195,096 4,430,600 4,592,751 4,763,601 4,942,713 5,130,041 Property taxes In -Lieu of Sales Tax (d) 536,579 544,300 540,611 (3,689) 279,198 0 0 0 0 0 Sales and use tax (d) 11642,381 1,671,500 1,757,889 86,389 2,068,936 2,122,800 1,999,700 1,947,700 1,967,200 2,036,100 Property transfer tax (e) 385,600 416,900 344,357 (72,543) 395,000 406,900 408,300 409,700 411,100 412,500 Business license tax (c) 764,494 728,700 808,668 79,968 777,490 794,500 813,600 833,100 853,100 873,600 Transient occupancy tax (c) 4,250,086 4,669,500 4,812,130 142,630 5,026,400 5,495,000 5,855,000 5,995,500 6,139,400 6,286,700 Franchise taxes (1) 1,998,213 2,063,200 2,044,398 (18,802) 2,101,000 2,127,100 2,178,200 2,230,500 2,284,000 2,338,800 Utility user tax (1) 2,509,524 2,009,667 1,972,671 (36,996) 1,862,000 1,981,900 2,029,500 2,078,200 2,128,100 2,179,200 Golf tax (c) 439,166 411,800 411,362 (438) 447,900 350,500 358,900 367,500 376,300 385,300 SUBTOTAL TAXES 23,167,189 23,572,867 23,760,688 187,821 24,434,281 24,987,300 25,850,579 26,522,993 27,295,755 28,146,555 Animal control fees (g) 41,647 30,000 42,898 12,898 40,000 40,000 40,000 40,000 40,000 40,000 Right of way & parking permits (g) 77,725 72,400 99,508 27,108 79,500 103,300 103,300 103,300 103,300 103,300 Building and safety permits & geology fees (g) 1,380,431 1,517,500 1,830,594 313,094 1,552,000 1,572,400 1,572,400 1,572,400 1,572,400 1,572,400 Planning permits (g) 392,068 397,500 464,799 67,299 428,600 440,100 440,100 440,100 440,100 440,100 Film permits (g) 58,865 45,000 76,658 31,658 60,000 60,000 60,000 60,000 60,000 60,000 Massage Permits (g) 0 0 115 115 0 0 0 0 0 0 SUBTOTAL LICENSES & PERMITS 1,950,736 2,062,400 2,514,572 452,172 2,160,100 2,215,800 2,215,800 2,215,800 2,215,800 2,215,800 Miscellaneous court fines (c) 118,185 107,000 121,626 14,626 107,000 107,000 109,600 112,200 114,900 117,700 False alarm fines 4,700 5,500 4,200 (1,300) 51000 5,000 5,000 5,000 5,000 5,000 Tow fees (c) 5,862 5,100 9,230 4,130 8,000 9,500 9,700 9,900 10,100 10,300 SUBTOTAL FINES & FORFEITURES 128,747 117,600 135,056 17,456 120,000 121,500 124,300 127,100 130,000 133,000 Property & Monopole Leases (c) 197,127 154,400 74,823 (79,577) 157,500 181,900 186,300 190,800 195,400 200,100 Facility rentals - PVIC (c) 223,502 227,300 236,359 9,059 225,000 200,000 204,800 209,700 214,700 219,900 Facility rentals - Other (c) 109,140 105,000 111,576 6,576 90,000 80,300 82,200 84,200 86,200 88,300 Parking lot fees 117,734 98,000 121,713 23,713 142,000 200,000 200,000 200,000 200,000 200,000 PVIC gift shop (c) 111,986 136,600 119,314 (17,286) 120,000 120,000 122,900 125,800 128,800 131,900 Interest earnings (h) 38,168 26,940 43,053 16,113 121,220 53,800 47,550 48,410 49,580 49,700 SUBTOTAL USE OF MONEY & PROPERTY 797,657 748,240 706,838 (41,402) 855,720 836,000 843,750 858,910 874,680 889,900 Engineering fees (g) 29,412 35,000 36,477 1,477 21,000 9,000 9,000 9,000 9,000 9,000 Recreation fees (c) 17,650 18,700 22,663 3,963 18,000 11,500 11,800 12,100 12,400 12,700 Sale of Signs/Services (g) 3,535 8,000 1,645 (6,355) 4,000 1,900 1,900 1,900 1,900 1,900 Administration of Successor Agency 60,750 100,000 31,311 (68,689) 38,000 60,000 0 0 0 0 Interfund charges for services (a) 152,700 155,800 155,800 0 155,800 155,800 158,900 162,100 165,300 168,600 SUBTOTAL CHARGES FOR SERVICES 264,047 317,500 247,896 (69,604) 236,800 238,200 181,600 185,100 188,600 192,200 32,083 18,212 0 0 0 Grant income 18,000 36,212 0 0 0 SUBTOTAL REVENUES FROM OTHER AGENCIES 32,083 18,000 36,212 18,212 0 0 0 0 0 0 Donations (c) 31,382 25,000 22,794 (2,206) 27,000 27,500 28,200 28,900 29,600 30,300 Repayment of City Loan to former RDA 0 72,915 58,332 (14,583) 38,307 177,200 177,200 177,200 177,200 177,200 Other miscellaneous (c) 1,457,948 552,606 602,466 49,860 10,000 10,500 10,800 11,100 11,400 11,700 SUBTOTAL OTHER REVENUES 1,489,330 650,521 683,592 33,071 75,307 215,200 216,200 217,200 218,200 219,200 TOTAL GENERAL FUND REVENUES 27,829,789 27,487,128 28,084,854 597,726 27,882,208 28,614,000 29,432,229 30,127,103 30,923,035F_31_,7_9_6_,6575 9w CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) FWIWAJ Alwo o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 4 GENERAL FUND EXPENDITURE DETAIL City Council Salary 24,000 24,600 25,200 25,800 26,400 Benefits 69,000 70,700 72,400 74,100 75,900 Non -Personnel 33,500 34,300 35,100 35,900 36,800 Total (d) 137,169 129,800 120,557 9,243 129,590 126,500 129,600 132,700 135,800 139,100 SUBTOTAL CITY COUNCIL 137,169 129,800 120,557 9,243 129,590 126,500 129,600 132,700 135,800 139,100 City Manager Salary 556,500 569,900 583,600 597,600 611,900 Benefits 150,600 154,200 157,900 161,700 165,600 Non -Personnel 88,600 90,700 92,900 95,100 97,400 Total (d) 973,378 762,123 731,613 30,510 894,417 795,700 814,800 834,400 854,400 874,900 Legal Services Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 940,000 962,600 985,700 1,009,400 1,033,600 Total (d) 1,186,947 990,000 856,190 133,810 1,030,000 940,000 962,600 985,700 1,009,400 1,033,600 City Clerk Salary 331,700 339,700 347,900 356,200 364,700 Benefits 149,400 153,000 156,700 160,500 164,400 Non -Personnel 94,800 297,100 104,200 306,700 114,100 Total (d) 643,145 486,750 486,496 254 734,176 575,900 789,800 608,800 823,400 643,200 Community Outreach Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 81,500 83,500 85,500 87,600 89,700 Total (d) 80,017 131,849 121,021 10,828 79,640 81,500 83,500 85,500 87,600 89,700 RPVty Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 228,400 233,900 239,500 245,200 251,100 Total (d) 153,443 180,600 175,200 5,400 144,320 228,400 233,900 239,500 245,200 251,100 Risk Management Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 0 0 0 0 0 Total (d) 467,248 400,000 396,292 3,708 475,000 0 0 0 0 0 Personnel Salary 245,800 251,700 257,700 263,900 270,200 Benefits 72,000 73,700 75,500 77,300 79,200 Non -Personnel 99,600 102,000 104,400 106,900 109,500 Total (d) 314,837 494,167 399,980 94,187 434,579 417,400 427,400 437,600 448,100 458,900 Finance Salary 840,500 860,700 881,400 902,600 924,300 Benefits 244,800 250,700 256,700 262,900 269,200 Non -Personnel 211,600 216,700 221,900 227,200 232,700 Total (d) 1,407,151 1,209,150 1,208,680 4701 1,271,4261 1,296,900 1,328,100 1,360,000 1,392,700 1,426,200 FWIWAJ Alwo CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 5 Information Technology - Data Salary 216,100 221,300 226,600 232,000 237,600 Benefits 66,000 67,600 69,200 70,900 72,600 Non -Personnel 851,400 773,500 792,100 811,100 830,600 Total (d) 356,593 577,800 551,771 26,029 962,413 1,133,500 1,062,400 1,087,900 1,114,000 1,140,800 Information Technology - Voice Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 105,000 107,500 110,100 112,700 115,400 Total (d) 72,238 86,000 87,672 (1,672) 80,000 105,000 107,500 110,100 112,700 115,400 SUBTOTAL ADMINISTRATION 5,654,997 5,318,439 5,014,915 303,524 6,105,971 5,574,300 5,810,000 5,749,500 6,087,500 6,033,800 Public Safety - Sheriff Services Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 5,369,200 5,530,300 5,696,200 5,867,100 6,043,100 Total (f) 4,177,601 4,345;900 4,345,828 72 5,046,200 5,369,200 5,530,300 5,696,200 5,867,100 6,043,100 Special Safety Programs Salary 71,700 73,400 75,200 77,000 78,800 Benefits 18,000 18,400 18,800 19,300 19,800 Non -Personnel 584,500 598,500 612,900 627,600 642,700 Total (d) 61,839 106,700 98,528 8,172 145,300 674,200 690,300 706,900 723,900 741,300 Animal Control Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 117,000 119,800 122,700 125,600 128,600 Total (d) 81,346 81,180 81,180 0 88,000 117,000 119,800 122,700 125,600 128,600 Emergency Preparedness Salary 77,500 79,400 81,300 83,300 85,300 Benefits 36,600 37,500 38,400 39,300 40,200 Non -Personnel 91,000 93,200 95,400 97,700 100,000 Total (d) 171,526 293,383 235,705 57,678 186,814 205,100 210,100 215,100 220,300 225,500 SUBTOTAL PUBLIC SAFETY 4,492,312 4,827,163 4,761,241 65,922 5,466,314 6,365,500 6,550,500 6,740,900 6,936,900 7,138,500 Public Works Administration (Staffing, Project Management and Engineering) Salary 1,507,900 1,544,100 1,581,200 1,619,100 1,658,000 Benefits 479,100 490,600 502,400 514,500 526,800 Non -Personnel 295,200 302,300 309,600 317,000 324,600 Total (d) 1,966,202 2,097,900 2,097,473 427 2,236,463 2,282,200 2,337,000 2,393,200 2,450,600 2,509,400 Traffic Management Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 298,000 305,200 312,500 320,000 327,700 Total (d) 76,611 397,000 91,847 305,153 311,000 298,000 305,200 312,500 320,000 327,700 Storm Water Quality (NPDES Compliance) Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 579,600 593,500 607,700 622,300 637,200 Total (d) 212,053 606,495 278,332 328,1631 487,0001 579,600 593,500 607,700 622,300 637,200 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) Wo o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 6 Public Building Maintenance Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 578,700 592,600 606,800 621,400 636,300 Total (d) 402,120 632,300 576,139 56,161 511,200 578,700 592,600 606,800 621,400 636,300 Parks, Trails & Open Space Maintenance Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 869,600 890,500 911,900 933,800 956,200 Total (d) 904,917 1,801,248 988,184 813,064 995,300 869,600 890,500 911,900 933,800 956,200 Sewer Maintenance Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 69,000 70,700 72,400 74,100 75,900 Total (d) 51,126 33,000 31,780 1,220 13,100 69,000 70,700 72,400 74,100 75,900 SUBTOTAL PUBLIC WORKS 3,613,029 5,567,943 4,063,755 1,504,188 4,554,063 4,677,100 4,789,500 4,904,500 5,022,200 5,142,700 Planning Salary 959,300 982,300 1,005,900 1,030,000 1,054,700 Benefits 321,100 328,800 336,700 344,800 353,100 Non -Personnel 295,200 302,300 309,600 317,000 324,600 Total (d) 1,311,995 1,503,311 1,375,122 128,189 1,256,515 1,575,600 1,613,400 1,652,200 1,691,800 1,732,400 Building & Safety Services Salary 455,400 466,300 477,500 489,000 500,700 Benefits 185,300 189,700 194,300 199,000 203,800 Non -Personnel 218,700 223,900 229,300 234,800 240,400 Total (d) 626,386 779,877 744,830 35,047 773,471 859,400 879,900 901,100 922,800 944,900 Code Enforcement Salary 87,900 90,000 92,200 94,400 96,700 Benefits 34,600 35,400 36,200 37,100 38,000 Non -Personnel 13,800 14,100 14,400 14,700 15,100 Total (d) 212,381 218,700 207,064 11,636 211,151 136,300 139,500 142,800 146,200 149,800 View Restoration/Preservation Salary 208,200 213,200 218,300 223,500 228,900 Benefits 90,200 92,400 94,600 96,900 99,200 Non -Personnel 48,800 50,000 51,200 52,400 53,700 Total (d) 335,870 394,700 394,210 490 294,642 347,200 355,600 364,100 372,800 381,800 Natural Community Conservation Planning (NCCP) Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 75,000 76,800 78,600 80,500 82,400 Total (d) 15,260 0 0 0 0 75,000 76,800 78,600 80,500 82,400 Geology (Privately Initiated Projects) Salary 0 0 0 0 0 Benefits 0 0 0 0 0 Non -Personnel 150,000 153,600 157,300 161,100 165,000 Total (d) 131,672 150,000 149,201 799 150,000 150,000 153,600 157,300 161,100 165,000 SUBTOTAL COMMUNITY DEVELOPMENT 2,633,564 3,046,588 2,870,427 176,161 2,685,779 3,143,500 3,218,800 3,296,100 3,375,200 3,456,300 Wo CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 7 Recreation Administration (Staffing, Park Rangers) Salary 573,400 587,200 601,300 615,700 630,500 Benefits 159,600 163,400 167,300 171,300 175,400 Non -Personnel 105,000 107,500 110,100 112,700 115,400 Total (d) 653,202 830,550 780,059 50,491 938,322 838,000 858,100 878,700 899,700 921,300 Recreation Facilities Salary 165,500 169,500 173,600 177,800 182,100 Benefits 28,100 28,800 29,500 30,200 30,900 Non -Personnel 20,400 20,900 21,400 21,900 22,400 Total (d) 463,195 524,500 437,375 87,125 53,934 214,000 219,200 224,500 229,900 235,400 Special Events Salary 62,700 64,200 65,700 67,300 68,900 Benefits 20,700 21,200 21,700 22,200 22,700 Non -Personnel 133,300 91,500 93,700 95,900 98,200 Total (d) 91,629 93,250 89,722 3,528 136,193 216,700 176,900 181,100 185,400 189,800 Pt. Vicente Interpretive Center (PVIC) Salary 234,400 240,000 245,800 251,700 257,700 Benefits 51,000 52,200 53,500 54,800 56,100 Non -Personnel 90,300 92,500 94,700 97,000 99,300 Total (d) 330,967 434,750 434,064 686 370,805 375,700 384,700 394,000 403,500 413,100 Abalone Cove Shoreline Park Salary 83,200 85,200 87,200 89,300 91,400 Benefits 16,700 17,100 17,500 17,900 18,300 Non -Personnel 5,900 6,000 6,100 6,200 6,300 Total (d) 0 0 0 0 64,087 105,800 108,300 110,800 113,400 116,000 Fred Hesse Jr. Park Salary 147,700 151,200 154,800 158,500 162,300 Benefits 30,800 31,500 32,300 33,100 33,900 Non -Personnel 8,400 8,600 8,800 9,000 9,200 Total (d) 0 0 0 0 165,893 186,900 191,300 195,900 200,600 205,400 Ladera Linda Community Center Salary 68,600 70,200 71,900 73,600 75,400 Benefits 17,500 17,900 18,300 18,700 19,100 Non -Personnel 4,500 4,600 4,700 4,800 4,900 Total (d) 0 0 0 0 64,153 90,600 92,700 94,900 97,100 99,400 Robert E. Ryan Park Salary 88,400 90,500 92,700 94,900 97,200 Benefits 19,600 20,100 20,600 21,100 21,600 Non -Personnel 2,600 2,700 2,800 2,900 3,000 Total (d) 0 0 0 0 92,609 110,600 113,300 116,100 118,900 121,800 REACH Salary 25,900 26,500 27,100 27,800 28,500 Benefits 5,100 5,200 5,300 5,400 5,500 Non -Personnel 10,300 10,500 10,800 11,100 11,400 Total (d) 34,121 42,200 38,154 4,046 40,190 41,300 42,200 43,200 44,300 45,400 Recreation Support Services (Reception & Other) Salary 69,400 71,100 72,800 74,500 76,300 Benefits 14,900 15,300 15,700 16,100 16,500 Non -Personnel 0 0 0 0 0 Total (d) 0 49,500 39,472 10,028 68,845 84,300 86,400 88,500 90,600 92,800 SUBTOTAL RECREATION & PARKS 1,573,114 1,974,750 1,818,846 155,904 1,995,031 2,263,900 2,273,100 2,327,700 2,383,400 2,440,400 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o LL ACTUAL FY13-14 BUDGET FY14-15 ACTUAL FY14-15 VARIANCE FY14-15 BUDGET FY15-16 PROPOSED MODEL MODEL MODEL FY16-17 FY17-18 FY18-19 FY19-20 MODEL FY20-21 PAGE 8 NON -DEPARTMENTAL 35,000 190,467 190,467 0 01 737,100 754,800 772,900 791,400 810,400 TOTAL GENERAL FUND EXPENDITURES 18,139,185 21,055,150 18,840,208 2,214,9421 20,936,748 22,887,900 23,526,300 23,924,300 24,732,40025,161,200 GENERAL FUND NET BEFORE TRANSFERS 9,690,604 6,431,978 9,244,646 2,812,6681 6,945,460 5,726,100 5,905,929 6,202,803 6,190,635E 6,635,455 GENERAL FUND TRANSFER DETAIL GENERAL FUND TRANSFERS IN: From Measure A Maint 67,441 289,855 261,049 (28,806) 57,698 90,000 90,000 90,000 0 0 From Public Safety Grants Fund 100,000 100,000 100,000 0 100,000 100,000 100,000 100,000 100,000 100,000 From Waste Reduction 0 3,000 3,000 0 3,000 0 0 0 0 0 From Employee Benefits 0 0 0 0 0 0 0 0 0 0 Total General Fund Transfers In 167,441 392,855 364,049 (28,806)1 160,698 190,000 190,000 190,000 100,000 100,000 GENERAL FUND TRANSFERS OUT: To CIP fund 6,522,697 6,013,884 6,016,514 (2,630) 8,430,545 5,200,000 5,562,300 5,695,700 5,832,400 5,972,400 To CIP fund for Residential Street Rehab 1,873,414 2,229,400 2,229,400 0 1,862,000 0 0 0 0 0 To Street Maintenance Fund (b) 0 0 0 0 0 0 0 0 0 0 To CDBG 0 0 0 0 11,624 0 0 0 0 0 To Improvement Authority Portuguese Bend (b) 70,000 40,000 40,000 0 57,000 0 0 72,000 124,000 126,000 To Improvement Authority Abalone Cove (b) 20,000 35,000 35,000 0 37,000 38,000 73,000 74,000 77,000 78,000 To Abalone Cove Sewer District (b) 50,700 50,700 50,700 0 80,700 208,000 213,000 218,000 223,000 228,000 To Habitat Restoration (b) 150,000 157,000 157,000 0 125,000 0 0 0 0 0 To Subregion 1 Maintenance Fund (b) 61,000 46,000 46,000 0 40,000 0 0 0 0 0 Total General Fund Transfers Out 8,747,811 8,571,984 8,574,6141 (2,630)1 10,643,869 5,446,000 5,848,300 6,059,700 6,256,400E 6,404,400 Net Activity 1,110,234 (1,747,151) 1,034,0811 2,781,232 1 (3,537,711) 470,100 247,629 333,103 34,235 331,055 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL LL FY13-14 BUDGET FY14-15 ACTUAL FY14-15 VARIANCE FY14-15 BUDGET FY15-16 PROPOSED MODEL MODEL MODEL FY16-17 FY17-18 FY18-19 FY19-20 MODEL FY20-21 PAGE 9 GENERAL FUND SUMMARY Beginning Fund Balance 14,508,251 15,618,485 15,618,485 0 16,652,565 13,114,854 13,584,954 13,832,583 14,165,686 14,199,921 Plus: Revenues 27,829,789 27,487,128 28,084,853 597,726 27,882,208 28,614,000 29,432,229 30,127,103 30,923,035 31,796,655 Less: Expenditures (18,139,185) (21,055,150) (18,840,208) 2,214,942 (20,936,748) (22,887,900) (23,526,300) (23,924,300) (24,732,400) (25,161,200) Plus: Transfers In 167,441 392,855 364,049 (28,806) 160,698 190,000 190,000 190,000 100,000 100,000 Less: Transfers Out (8,747,811) (8,571,984) (8,574,614) (2,630) (10,643,869) (5,446,000) (5,848,300) (6,059,700) (6,256,400) (6,404,400) Extraordinary Item 0 0 0 0 Ending Fund Balance 15,618,485 13,871,334 16,652,565 2,781,231 13,114,854 13,584,954 13,832,583 14,165,686 14,199,921 14,530,976 Less Non -Spendable, Restricted, Committed & Assigned: Long -Term Advance to RDA (Principal Only) 0 0 0 0 0 0 0 0 0 0 Continuing Appropriations 1,042,056 0 531,765 (531,765)1 0 0 0 0 0 0 Inventory & Other 737,203 987,562 987,562 01 176,629 176,629 176,629 176,629 176,629 176,629 Unassigned Fund Balance (Available for Spending) 13,839,226 12,883,77233,238 2,249,466 12,938,225 13,408,325 13,655,954 13,989,057 14,023,292 14,354,347 Policy Reserve Threshold (50% of Expenditures) 9,069,593 �=�J==Z5�713,134 10,527,57520,104 (1,107,471) 10,468,374 11,443,950 11,763,150 11,962,150 12,366,200 12,580,600 Excess/(Deficient) General Fund Reserves 3,356,937 2,469,851 1,964,375 1,892,804 2,026,907 1,657,092E 1,773,747 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 10 Beautification revenue Interest earnings (h) Total Revenue Expenditures Personnel services Operations & maintenance Total Expenditures BEAUTIFICATION FUND NET BEFORE TRANSFERS Transfers Out To CIP fund - Street Improvements (median projects) To Street Maintenance fund (median maintenance) (b) Total Transfers Out BEAUTIFICATION FUND SUMMARY Beginning Fund Balance Plus: Revenues Less: Expenditures Less: Transfers Out Ending Fund Balance ---- - ----- ---- - ----- 0 II Oil Oil 01 473,680 0 473,690 0 473,690 0 211,404 224,000 224,000 0 97,791 211,404) (697,690) (224,000) 473,690 (97,791)1 0 0 0 0 0 793,921 96,921 571,8561 474,9351 1,255 1 2,155 2,155 2,155 2,155 2,155 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 11 Capital Grants & Contributions Interest earnings Total CIP Fund Revenue Expenditures Total CIP Fund Expenditures (see Exhibit C) CIP FUND NET BEFORE TRANSFERS Transfers In From General fund From General fund for Residential Street Rehab From Water Quality Flood Protection From Waste Reduction fund From Measure R fund for Arterial Street Rehab From Measure A Capital/Maintenance fund From Proposition C fund for Arterial Street Rehab From Proposition A fund for Arterial Street Rehab From Bikeways fund for Residential Street Rehab From Quimby fund From EET fund for ADA Projects From Donor Restricted Contributions fund From Beautification fund From Building Replacement Fund Total Transfers In Transfers Out to WQFP for subsidy Transfers Out to ERF for parking equipment Total Transfers Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 6,522,697 6,013,884 6,016,514 2,630 8,430,545 5,200,000 5,562,300 5,695,700 5,832,400 5,972;400 1,873,414 2,229,400 2,229,400 0 1,862,000 0 0 0 0 0 0 362,360 362,360 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,564,000 564,000 (1,000,000) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 350,184 1,463,719 1,228,719 (235,000) 0 0 0 0 0 0 0 460,000 310,886 (149,114) 0 0 0 0 0 0 95,257 0 0 0 0 0 0 0 0 0 0 50,000 0 (50,000) 50,000 0 0 0 0 0 0 450,000 97,199 (352,801) 200,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 473,690 0 (473,690) 0 0 0 0 0 0 0 940,000 944,841 4,841 0 0 0 0 0 0 Oil 820.000 11 969.422 11 01 01 Oil Oil Oil Oil 01 Beginning Fund Balance 11,565,617 22,124,281 22,124,281 0 24,560,456 20,397,307 19,569,407 15,460,207 0 820,000 820,000 01 01 0 0 0 0 0 0 0 149,422 01 01 0 Plus: Revenues 1,717,112 3,255,485 Oil 820.000 11 969.422 11 01 01 Oil Oil Oil Oil 01 Beginning Fund Balance 11,565,617 22,124,281 22,124,281 0 24,560,456 20,397,307 19,569,407 15,460,207 11,110;007 10,271,307 Plus: Revenues 1,717,112 3,255,485 348,286 (2,907,199) 552,570 1,054,400 68,500 54,100 38,900 35,900 Less: Expenditures 0 (10,402,299) (8,696,608) 1,705,691 (15,258,264) (7,082,300) (9,740,000) (10,100,000) (6,710;000) (6,230,000) Plus: Transfers In 8,841,552 14,007,053 11,753,919 (2,253,134) 10,542,545 5,200,000 5,562,300 5,695,700 5,832,400 5,972,400 Less: Transfers Out 0 (820,000) (969,422) (149,422)1 0 0 0 0 0 0 Fund Balance 22,124,281 28,164,520 24,560,4561 (3,604,064)1 20,397,307 1 10,049,607 Minimum Emergency Projects Reserve 3,000,000 3,000,0003,000,000 1 3,000,000 3,000,000 3,000,00FT 3,000,000 3,000,000 Excess Reserve for Future Projects 19,124,281 21,560,4561 1 17,397,307 16,569,407 12,460,207 8,110,007 7,271,307 7,049,607 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 12 EQUIPMENT REPLACEMENT FUND DETAIL (Fund- 2,838 1 Revenues Interfund charges Other revenue 132,030 1 248,200 1 235,200 (b) 36,900 Interest earnings (h) Total Revenue Expenses Vehicles and vehicle maintenance (b) Computer equipment and maintenance (b) Furniture and equipment maintenance (b) Total Expenses 910,500 913,338 2,838 349,400 132,030 EQUIPMENT REPLACEMENT FUND NET BEFORE TRANSFERS 235,200 Transfers In - AQMD / fund 214 Transfers In - CIP / fund 330 Total Transfers In Transfers Out 751,667 11 910,500 1 913,338 1 2,838 1 349,4001 132,030 1 248,200 1 235,200 1 92,900 1 36,900 2,561,734 2,443,434 Plus: Revenues 751,667 910,500 913,338 2,838 349,400 132,030 248,200 235,200 39,571 77,200 55,844 21,356 22,200 0 0 0 0 0 365,367 791,835 553,349 238,486 370,000 687,000 102,300 130,200 211,200 288,500 111,077 119,751 100,343 19,408 85,500 0 0 0 0 0 516,015 988,786 709,5361 279,250 1 477,700 1 687,000 102,300 130,200 211,200 288,500 0 0 0 0 235,652 (78,286) 203,802 282,088 1 (128,300) (554,970) 145,900 105,000 1[7(118,300) 0 (251,600) ---- 2,587,848 - ----- 2,915,898 0 2,994,1041 2,865,804 2,310,834 2,456,734 2,561,734 2,443,434 Plus: Revenues 751,667 910,500 54,910 01 01 0 Beginning Unrestricted Net Assets 2,587,848 2,915,898 2,915,898 0 2,994,1041 2,865,804 2,310,834 2,456,734 2,561,734 2,443,434 Plus: Revenues 751,667 910,500 913,338 2,838 349,400 132,030 248,200 235,200 92,900 36,900 Less:Expenses (516,015) (988,786) (709,536) 279,250 (477,700) (687,000) (102,300) (130,200) (211,200) (288,500) Plus: Transfers In 54,910 0 149,422 149,422 0 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Net (Increase)/Decrease in Capital Assets 37,488 0 (275,018) (275,018)1 0 Unrestricted Net Assets (Spendable) 2,915,898 2,837;612 2,994,104 156;492 2;865;804 2,310,834 2,456,734 2,561,734 2,443,434 2,191,834 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 13 o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 BUILDING REPLACEMENT FUND DETAIL (Fund- Revenues Interest earnings Total Revenue (h) 2,004 2,100 2,232 132 0 0 0 0 0 0 1 2,004 2,100 2,2321 1321 01 000 0 Expenses Building Improvements 0 0 0 0 0 0 0 0 0 Total Expenses 0�0 �01 01 01 0 0 BUILDING TRANSFERS PLACEMENT FUND NET BEFORE 2004 2,100 2,232 132 0 0 0 Transfers Out- CIP 0 940,000 944,841 (4,841)1 01 0 0 0 0 0 Total Transfers Out 0 940,000 944,8411 (4,841)1 0 1 0 000 0 BUILDING REPLACEMENT NET ASSET SUMMARY: Beginning Net Assets 940,605 942,609 942,609 0 0 0 0 0 0 0 Plus: Revenues 2,004 2,100 2,232 132 0 0 0 0 0 0 Less:Expenses 0 0 0 0 0 0 0 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 (940,000) (944,841) (4,841)1 0 0 0 0 0 0 Ending Net Position 942,609 4,709 0 (4,709) 0 10 000 0 0 B-13 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 14 EMPLOYEE BENEFITS FUND DETAIL (Fund -6851 Revenues I nterfund Charge for Services 1,993,425 2,151,450 2,030,969 (120,481)1 2,139,894 0 0 0 0 0 Interest earnings (h) 0 240 580 3401 1,350 0 0 0 0 0 Total Revenue1,993,425 2,151,690 2,031,549 (120,141) 2,141,244 0 000 0 Expenses Retirement (PERS)-Employer Contribution 847,847 815,100 725,028 90,072 867,852 0 0 0 0 0 Defined Cont. Ret. Health Care Accounts (b) 68,768 88,300 74,348 13,952 89,692 0 0 0 0 0 Insurance - Employee Health (b) 818,655 995,100 1,012,052 (16,952) 1,034,915 0 0 0 0 0 FICA/Medicare (b) 81,476 99,650 85,664 13,986 109,432 0 0 0 0 0 Performance Incentive Program 0 0 0 0 0 0 0 0 0 0 Education Reimbursement (b) 1,000 800 0 800 0 0 0 0 0 0 Deferred Comp Match 15,000 0 0 0 0 0 0 0 0 0 Worker Compensation Insurance (b) 122,703 152,500 152,376 124 170,781 0 0 0 0 0 Total Expenses 1,955,449 2,151,450 2,049,468 101,982 2,272,672 0 0 EMPLYEE TRANSFERS BENEFITS FUND NET BEFORE 37,976 240 (17,919) (18,159) (131.428) 0 0 1 0 0 0 Transfer to General Fund 0 0 00 0 0 0 Total Transfer Out 01 01 0 EMPLOYEE BENEFITS NET ASSET SUMMARY: Beginning Net Assets 111,371 149,347 149,347 0 131,428 0 0 0 0 0 Plus: Revenues 1,993,425 2,151,690 2,031,549 (120,141) 2,141,244 0 0 0 0 0 Less:Expenses (1,955,449) (2,151,450) (2,049,468) 101,982 (2,272,672) 0 0 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Net Position 149,347 149,5871 131,428 (18,159) 01 0 �0 �0 �0 0 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 15 Highway Users Tax Sidewalk repair Miscellaneous revenues Interest earnings Total Street Maintenance Fund Revenue Expenditures Street Maintenance - Pavement Street Maintenance - Landscape Traffic Signal maintenance Portuguese Bend Rd maintenance Total Street Maintenance Fund Expenditures STREET MAINTENANCE FUND NET BEFORE TRANSFERS Street Maintenance Fund Transfers In From Prop C Fund (PB Road Maint) From General fund From 1972 Act From 1911 Act From Beautification fund From Waste Reduction Total Transfers In Street Maintenance Fund Transfers Out To CIP Fund Total Transfers Out STREET MAINTENANCE FUND SUMMARY Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance Reserve (1 year of Pavement Management Exp) Excess/(Deficient) Reserve for Street Maintenance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 524,977 599,500 518,749 80,751 1 245,0001 245,000 250,900 256,900 263,100 269,400 1,464,285 1,851,279 1,521,067 330,2121 1,411,2791 1,332,000 1,364,000 1,396,700 1,430,200 1,464,500 100,273 126,000 116,693 9,3071 127,0001 10,000 10,200 10,400 10,600 10,900 574,500 1 48,500 49,700 50,900 52,100 53,400 2,089,535 2,576,779 2,156,5091 420,2701 2,357,779 1 1,635,500 1,674,800 1,714,900 1,756,000 1,798,200 (706,274) (1,306,517) (1,037,927) 268,590 (1,396,172) (792,900) (835,940) (876,300) (917,100)(958,900) 1,383,261 1,270,262 1,118,582 (151,680) 961,607 842,600 838,860 838,600 838,900 839,300 522,000 526,000 518,749 (7,251) 526,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 190,000 200,000 200,000 0 200,000 0 0 0 0 0 99,000 99,000 99,000 0 117,000 0 0 0 0 0 211,404 224,000 224,000 0 97,791 0 0 0 0 0 41,292 54,000 37,000 (17,000) 95,000 0 0 0 0 0 1,063,696 1,103,000 1,078,749 11 (24,251) 1,035,791 1 0 F______011 6 IF--- o 11 0 0 0 0 0 0 0 0 0 0 0 011 OIL Oil 01 01 Oil Oil 0 1 0 0 914,473 1,271,895 1,271,895 0 1,312,717 952,336 159,436 (676,504) (1,552,804) (2,469,904) 1,383,261 1,270,262 1,118,582 (151,680) 961,607 842,600 838,860 838,600 838,900 839,300 2,089,535) (2,576,779) (2,156,509) 420,270 (2,357,779) (1,635,500) (1,674,800) (1,714,900) (1,756,000) (1,798,200) 1,063,696 1,103,000 1,078,749 (24,251) 1,035,791 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,271,895 1,068,378 1,312,7171 244,3391 952,336 159,436 (676,504) (1,552,804) (2,469,904) (3,428,804) 524,977 518,749 1 526,000 1 550,000 550,000 600,000 600,000 650,000 746,918 793,96811 1 426,336 (390,564) (1,226,504) (2,152,804) (3,069,904) (4,078,804) B-15 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 16 1972 ACT LANDSCAPE & LIGHTING FUND DETAIL Property assessments Interest earnings Total Revenue Expenditures Operations & maintenance Total Expenditures 1972 ACT FUND NET BEFORE TRANSFERS Transfers Out To Street Maintenance fund Total Transfers Out ning Fund Balance Revenues Transfers In Transfers Out iq Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 260,452 258,000259,520 1,520 258,515 330 140 357 217 380 260,782 258,140 259,877 1,737 258,895 78,181 78,300 75,337 2,9631 78,200 78,181 78,300 75,337 2,963 78,200 182,601 179,840 184,540 4,700 180,695 26�265,400 270,700 276,200 281,700 241,500 247,300 253,200 259,300 265,500 241,500 247,300 253,200 259,300 265,500 18,700 18,100 17,500 16,900 16,200 190,000 200,000 200,000 0 200,0001 0 0 0 0 0 11 190, 000 11 200, 000 11 200, 000 11 01 200,0001 011 011 011 011 01 11 62,66311 42,50311 47, 203 11 4,7001 27,8981 46,59811 64,69811 82,198 11 99,09811 115,2981 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 17 Property assessments Interest earnings Total Revenue Expenditures Light and Power Operations & Maintenance Services Total Expenditures EL PRADO LIGHTING FUND NET BEFORE EL PRADO LIGHTING FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FYI 3-14 FY14-15 FY14-15 FY14-15 FY15-16 FYI 6-17 FY17-18 FY18-19 FY19-20 FY20-21 (b) 3011 1,000 �� 689]1 311 1 1,0001 80011 800 1 800 1 80011 800 2,180 940 1,6301 690 1 1,200 1,500 1,500 1,500 1,500 1,500 0 300 659 (359) 300 300 300 300 300 300 30 700 30 670 700 500 500 500 500 500 3011 1,000 �� 689]1 311 1 1,0001 80011 800 1 800 1 80011 800 2,180 940 1,6301 690 1 1,200 1,500 1,500 1,500 1,500 1,500 19,000 21,180 21,180 0 22,810 24,010 25,510 27,010 28,510 30,010 2,210 1,940 2,319 379 2,200 2,300 2,300 2,300 2,300 2,300 (30) (1,000) (689) 311 (1,000) (800) (800) (800) (800) (800) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 B-17 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 18 Grant income Total Revenue Expenditures Operations & maintenance Capital outlay (ADA Projects) Total Expenditures CDBG FUND NET BEFORE TRANSFERS Transfers In From General fund Total Transfers In Transfers Out To General fund (REACH) Total Transfers Out CDBG FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Endina Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 7 128,970 26,170 1 26,170 II 01 404,000 1 192,400 II Oil 0 0I1 0 (68,671) 239,707 57,0471 (182,660) 01 �F-0 0 0 0 0 0 0 11,6241 0 0 0 0 0 0001 01 11,624 0 �0 �0 �0 0 0 0 0 01 01 0 0 0 0 0 000 01 01 01 000 0 51,000 0 0 0 0 0 [E404,000 0 0 0 0 0 0 77,970 26,170 26,170 0 192,400 0 0 128,970 26,170 1 26,170 II 01 404,000 1 192,400 II Oil 0 0I1 0 (68,671) 239,707 57,0471 (182,660) 01 �F-0 0 0 0 0 0 0 11,6241 0 0 0 0 0 0001 01 11,624 0 �0 �0 �0 0 0 0 0 01 01 0 0 0 0 0 000 01 01 01 000 0 0 (68,671) (68,671) 0 (11,624) 0 0 0 0 0 60,299 265,877 83,217 (182,660) 404,000 192,400 0 0 0 0 (128,970) (26,170) (26,170) 0 (404,000) (192,400) 0 0 0 0 0 0 0 0 11,624 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 19 1911 ACT STREET LIGHTING FUND DETAIL (Fund - Property assessments Interest earnings (a) (h) Total Revenue Expenditures Operations & maintenance (b) Total Expenditures 1911 ACT FUND NET BEFORE TRANSFERS Transfers Out To Street Maintenance Fund (b) Total Transfers Out ning Fund Balance Revenues Transfers In Transfers Out iq Fund Balance :AZiNlkll�YiYKrII�YL�:3�lI�Y:1K3�1 �Y:LiNYK�I �1•�xYrIrIICY:YrIHI�fLB�IrIHI��Ir�YrIHItYrYYrIH 408,540 464,100 447,688 16,4121 459,0001 487,000 498,700 510,700 523,000 535,600 408,54011 464,100 1 447,688 1 16,4121 459,0001 487,000 i 498,700 1 510,700 1 523,000 1 535,600 146,053F___6_4_,4_001j 137,19111 72,791 1 106,5001 68,600 IF 68,800 68,200 67,600 66,900 99,000 99,000 99,000 tO 117,000 0 0 0 0 0 11 99,00011 99,00011 99,00011 01 117,000 1 011 011 011 011 01 II 1,756,65911 1,722,059 II 1,794,85011 72,791 1 1,784,3501 1,852,95011 1,921,75011 1,989,95011 2,057,55011 2,124,4501 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 20 WASTE REDUCTION FUND DETAIL (Fund -213) 201,600 Revenues Collection Fees (AB939) (c) 230,313 210,000 236,486 26,486 182,500 180,500 184,800 189,200 193,700 198,300 State grant 23,347 19,000 11,879 (7,121)1 23,000 26,000 26,000 26,000 26,000 26,000 Miscellaneous revenue 0 0 0 0 1 0 0 0 0 0 0 Interest earnings (h) 869 800 1,077 771 3,330 1 1,600 1,300 1,000 800 500 Total Revenue 254,529 229,800 249,4421 19,6421 208,830 208,100 212,100 216,200 220,500224,800 Expenditures Personnel services (b) 71,690 74,700 75,640 (940) 57,283 77,000 78,800 80700 82,600 84,600 Operations & maintenance (b) 109,908 125,462 38,680 86,782 110,400 206,400 211,,400 216,500 221,700 Total Expenditures 181,598 200,162 114,3201 85,8421 167,683 1 3 06,300 WASTE REDUCTION FUND NET BEFORE 72,931 29,638 135,1221 105,4841 41,147 (70,500) (73,100) (75,900) (78,600) (81,500) Transfers Out To General fund - Park Maintenance 0 3,000 3,000 0 3,000 0 0 0 0 0 To CIP fund - Street Improv. 0 0 0 0 0 0 0 0 0 0 To Street fund - Street Maintenance (b) 41,292 54,000 37,000 17,000 95,0001 0 0 0 0 0 Total Transfers Out 41,292 57,000 40,000 17,000 98,000 0 000 0 WASTE REDUCTION FUND SUMMARY Beginning Fund Balance 366,159 397,798 397,798 0 492,920 436,067 365,567 292,467 216,567 137,967 Plus: Revenues 254,529 229,800 249,442 19,642 208,830 208,100 212,100 216,200 220,500 224,800 Less: Expenditures (181,598) (200,162) (114,320) 85,842 (167,683) (278,600) (285,200) (292,100) (299,100) (306,300) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (41,292) (57,000) (40,000) 17,000 (98,000) 0 0 0 0 0 Ending Fund Balance 397,797 370,436 492,9201 122,4841 436,067 365,567 292,467 216,567 137,967 56,467 201,600 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 21 AIR QUALITY MANAGEMENT FUND DETAIL (Fund - 2141 Revenues AB 2766 fees Interest earnings Total Revenue Expenditures Operations & maintenance Total Expenditures AQMD FUND NET BEFORE TRANSFERS To Equipment Replacement Fund (clean air vehicle purchases) Total Transfers Out Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 II 38,88911 50,21011 66,32511 16,1151 50,7801 50,30011 50,40011 50,40011 50,40011 50,4001 50,000 50,000 50,000 0 1 50,000 50,000 50,000 50,000 50,000 50,000 50,00011 50,000 1 50,000 1 0 1 50,000 1 50,000 1 50,000 1 50,000 1 50,000 1 50,000 11,111) 210 16,3251 16,1151 780 300 400 400 400 400 54,910 0 0 0 0 0 0 0 0 0 152,298 86,277 86,277 0 102,602 103,382 103,682 104,082 104,482 104,882 38,889 50,210 66,325 16,115 50,780 50,300 50,400 50,400 50,400 50,400 (50,000) (50,000) (50,000) 0 (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) 0 0 0 0 0 0 0 0 0 0 (54.910) 0 0 0 0 0 0 0 0 0 B-21 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 22 PROPOSITION C (STREET/TRANSIT) FUND DETAIL Proposition C - 1/2 cent sales tax revenue Interest earnings Total Revenue Expenditures (PB Road Maintenance) Total Expenditures PROPOSITION C FUND NET BEFORE TRANSFERS Transfers Out To CIP fund - Arterial Street Rehab To Street Maintenance fund - PB Road Maintenance Total Transfers Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 597,614 11 612,479 1 622,665 1 10,186 1 638,008 1 649,100 1 610,800 1 595,200 1 601,100 1 622,100 460,098 461,198 350,184 1,463,719 1,228,719 235,000 0 0 1 0 0 0 0 522,000 526,000 518,749 7,251 526,000 0 0 0 0 0 0 550,000 550,000 600,000 600,000 600,000 --- 010 0 1 0 1 550,000 550,000 600,000 600,000600,000 0 0 (550,000) (550,000) (600,000) (600,000) (600,000) 597,614 612,479 622,66511 10,1861 638,008 1 99,100 -66-86-6-IF---o 8o -o-) 1,100 22,100 18411 1.989.719 11 1 011 011 011 011 01 Beginning Fund Balance 1,592,363 1,317,793 1,317,793 0 192,990 304,998 404,098 464,898 460,098 461,198 350,184 1,463,719 1,228,719 235,000 0 0 1 0 0 0 0 522,000 526,000 518,749 7,251 526,000 0 1 0 0 0 0 18411 1.989.719 11 1 011 011 011 011 01 Beginning Fund Balance 1,592,363 1,317,793 1,317,793 0 192,990 304,998 404,098 464,898 460,098 461,198 Plus: Revenues 597,614 612,479 622,665 10,186 638,008 649,100 610,800 595,200 601,100 622,100 Less: Expenditures 0 0 0 0 0 (550,000) (550,000) (600,000) (600,000) (600,000) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (872,184) (1,989,719) (1,747,468) 242,251 (526,000)1 0 0 0 0 0 Ending Fund Balance 1,317,793 (59,447) 192,990 252,4371 304,9981 404,098 464,898 460,098 461,198 483,298 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 23 PROPOSITION A (TRANSIT) FUND DETAIL (Fund_ Proposition A - 1/2 cent sales tax revenue (d) 714,750 737,443744,798 7,355 766,869 779,900 734,700 715,600 722,800 748,100 Other revenues 0 0 0 0 0 0 0 0 0 0 Interest earnings (h) 737 0 1,203 1,203 280 1,400 1,800 2,100 2,300 2,400 Total Revenue 715,487 737,443 -74-6-,0-0-1-11 8,5581 767,149 781,300 736,500 717,700 725,100 750,500 Capital Outlay (Bus Shelter Improvements) (b) Total Expenditures 584,953 687,539 640,567 46,972 621,556 638,300 653,600 669,300 584,953 576,823 571,567 5,256 601,556 618,300 633,100 648,300 663,900 679,800 0 110,716 69,000 41,716 20,000 20,000 20,500 21,000 21,500 22,000 Capital Outlay (Bus Shelter Improvements) (b) Total Expenditures 584,953 687,539 640,567 46,972 621,556 638,300 653,600 669,300 685,400 701,800 PROPOSITION A FUND NET BEFORE TRANSFERS 130,534 49,904 105,4341 55,530 1 145,5931 143,000 82,900 48,4001 39,700 48,700 Transfers Out - To CIP fund 0 460,000 310,886 149,114 0 0 0 0 0 0 Total Transfers Out 11 Oil 460,00011 310,88611 149,1141 01 0 Beginning Fund Balance 310,991 441,525 441,525 01 236,0731 381,666 524,666 607,566 655,966 695,666 Plus: Revenues 715,487 737,443 746,001 8,558 767,149 781,300 736,500 717,700 725,100 750,500 Transfers In Transfers Out iq Fund Balance 11 441,52511 31,42911 236,07311 204,6441 381,6661 524,66611 607,56611 655,96611 695,666II 744,3661 B-23 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 24 Grant Income - State Other revenues Interest earnings Total Revenue Expenditures Equipment purchases Total Expenditures PUBLIC SAFETY GRANTS FUND NET BEFORE TRANSFERS Transfers Out To General fund Total Transfers Out ning Fund Balance Revenues Transfers In Transfers Out io Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 0I 0 0 of of Oil 0 0 of1 0 100,170 100,040 F 106,442 6,402 100,190 100,200 100,100 100,100 IF 100,100 100,100 100,000 100,000 100,000 0 100,0001 100,000 100,000 100,000 100,000 100,000 II 100,00011 100,00011 100,00011 01 100,0001 100,00011 100,00011 100,00011 100,00011 100,0001 20,57011 20,61011 27,01211 6,4021 27,202 1 27,40211 27,50211 27,60211 27,70211 27,8021 AMA CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 25 Measure R - 1/2 cent sales tax revenue (Fund -220) Revenues Measure R Revenue Interest earnings Total Revenue Expenditures Total Expenditures MEASURE R FUND NET BEFORE TRANSFERS Transfers Out To CIP fund Total Transfers Out MEASURE R FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Endinq Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FYI 3-14 FY14-15 FY14-15 FY14-15 FY15-16 FYI 6-17 FY17-18 FY18-19 FY19-20 FY20-21 ---- - ----- I 0II 0II 0 01 of Oil 0 0 0I1 0 444,608 460,273 466,966 6,693 478,399 489,600 464,400 454,100 460,200477,500 ��o 1,564,000 564,000 1,000,000 0 0 0 0 0 0 F---O�1,564,000 564,000 1,000,000 0 _01 F ___0_ 1 F ___0_ 1 F ___0_ 1 0 B-25 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) 166,500 150,000 157,000 157,000 0 125,000 0 0 0 0 0 o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 26 HABITAT RESTORATION FUND DETAIL fNCCP1 (Fund -2221 Revenues Otherrevenues 1,211,620 0 1,666 1,6661 0 0 0 0 0 0 Interest earnings (h) 820 4,690 3,634 (1,056)1 13,010 4,900 4,500 3,900 3,300 2,700 Total Revenue 1 1,212,440 4,690 5,3001 6101 13,010 4,900 4,500 3,900 3,300 2,700 Expenditures Open Space Management, Maintenance & Monitoring (b) 133,620 159,689 136,059 23,630 163,000 170,500 174,600 178,800 183,100 Total Expenditures 133,620 159,689 136,059 23,630 163,000 166,500 170,500 174,600 178,800 183,100 HABITAT RESTORATION FUND NET BEFORE TRANSFERS 1,078,820 (154,999) (130,759) 24,240 (149,990) (161,600) (166,000) (170,700) (175,500) (180,400) Transfers In From General fund Total Transfers In 150,000 157,000 157,000 0 125,000 0 000 0 Transfers Out 0 0 0 0 0 0 0 0 0 0 Total Transfers Out �0 �0 �0 0 0 HABITAT RESTORATION FUND SUMMARY: Beginning Fund Balance 214,641 1,443,461 1,443,461 0 1,469,702 1,444,712 1,283,112 1,117,112 946,412 770,912 Plus: Revenues 1,212,440 4,690 5,300 610 13,010 4,900 4,500 3,900 3,300 2,700 Less: Expenditures (133,620) (159,689) (136,059) 23,630 (163,000) (166,500) (170,500) (174,600) (178,800) (183,100) Plus: Transfers In 150,000 157,000 157,000 0 125,000 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance 1,443,461 1,445,462 1,469,702 24,240 1,444,712 1,283,112 1,117,112 946,412 770,912 590,512 Reserve for Future Maintenance 84,957 95,194 105,476 115,880 126,321 136,798 147,312 157,862 Emergency Projects Reserve 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Excess Reserve for Habitat (Spendable) 1,308,504 1,324,508 1,289,236 1,117,232 940,791 759,614 573,600 382,650 166,500 150,000 157,000 157,000 0 125,000 0 0 0 0 0 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 27 SIMPFr;ION 1 - M Interest earnings Total Revenue Expenditures Operations & maintenance Total Expenditures SUBREGION 1 - MAINTENANCE FUND NET BEFORE TRANSFERS Transfers In - from General Fund Total Transfers In o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FYI 3-14 FY14-15 FY14-15 FY14-15 FY15-16 FYI 6-17 FY17-18 FY18-19 FY19-20 FY20-21 11 1,69511 1,70011 1,94711 247 1 7, 200 1 2,70011 2,60011 2,50011 2,30011 2, 200 1 (b) 32,428 67,500 51,319 16,181 67,5001 44,800 45,900 47,000 48,100 49,300 32,428 67,500 51,319 16,181 67,500 (30,733) (65,800) (49,372) 16,428 (60,300 61,000 1 46,000 1 46,000 1 01 40,000 90011 47,00011 48,100 100)JI (43,300)�1 (44,500)�1 (45,800) (47,100) 0 1 0 1 0 10 0 Beginning Fund Balance 791,701 821,968 821,968 0 818,596 798,296 756,196 712,896 668,396 622,596 Plus: Revenues 1,695 1,700 1,947 247 7,200 2,700 2,600 2,500 2,300 2,200 Less: Expenditures (32,428) (67,500) (51,319) 16,181 (67,500) (44,800) (45,900) (47,000) (48,100) (49,300) Plus: Transfers In 61,000 46,000 46,000 0 40,000 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance 821,968 802,168 818,596 16,428 798,296 756,196 712,896 668,396 622,596575,496 Non -Spendable Endowment 750,000 1 750,000 750,000 750,000 750,000 750,000 750,000 750,000 Spendable Fund Balance I 71,968 1 48,296 6,196 (37,104) (81,604) (127,404) (174,504) B-27 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 28 MEASURE A - CAPITAL (Fund -339) & MAINTENANCE (Fund -224) FUNDS DETAIL Revenues Grant income Interest earnings Total Revenue Total Expenditures MEASURE A - CAPITAL & MAINTENANCE FUND NET BEFORE TRANSFERS Transfers Out To General fund To CIP fund Total Transfers Out MEASURE A (PARKS) - CAPITAL & MAINTENANI FUNDS SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 217,441 289,855261,049 5 100 331 217,4461F --2-8-9,-95-5]F-261,380 `4rx,Ll fI�i1:XIFII�ZI-I119Z111 105,0001 90,00011 90,00011 90,00011 011 01 105,0001 90.000 11 90.000 11 90.000 11 Oil 01 67 261 217,446 289,955 261,380 0 0 0 0 0 0 (67,441) (289,855) (261,049 57 0 (47,302) 0 0 0 0 0 28,575) 105,000 90,000 90,000 90,000 0 0 67,441 289,855 261,049 28,806 57,698 90,000 90,000 90,000 0 0 0 0 0 0 01 0 0 0 0 0 67 261 217,446 289,955 261,380 0 0 0 0 0 0 (67,441) (289,855) (261,049 57 0 (47,302) 0 0 0 0 0 28,575) 105,000 90,000 90,000 90,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28,806 (57,698) (90,000) (90,000) (90,000) 0 0 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 29 ABALONE COVE SEWER DISTRICT FUND DETAIL (Fund -225) Revenues Property Assessments Sewer Use Fee Interest earnings Total Revenue Expenditures Personnel & Professional services Maintenance Services Total Expenditures ABALONE COVE SEWER DISTRICT FUND NET BEFORE TRANSFERS Fund Transfer In From General Fund Total Transfer In o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 (b) �71,0�88 -,-A-, �E-92,617 II 15 9.11ISR , 9�111 !'id R.l;S 55,708 55,080 56,373 1,293 55,080 55,100 56,200 57,300 58,400 59,600 0 1,270 1,270 0 0 0 0 0 0 92 80 119 39 1 801 300 500 600 800 900 55,800 5_5_,1_601F_57,76211 2,6021 55,1601 55,400 IF 56,700 57,900 59,200 60,500 (329)1 125,000 1 223,100 JI 228,500 1 234,000 1 239,600 245,400 9 973 !R9 Mffi r1R7 7nn1 -ti 71 /1� (1 Rd Qnn) 50,700 50,700 50,700 0 80,700 208,000 213,000 218,000 223,000 228,000 70011 50,70011 50,70011 0 Beginning Fund Balance 35,906 71,318 71,318 0 87,164 98,024 138,324 179,524 221,424 264,024 13,083 19,200 19,529 92,617 866 (329) 9,483 125,000 26,300 223,100 26,900 228,500 27,500 28,200 239,600 28,900 245,400 71,088 93,483 234,000 (329)1 125,000 1 223,100 JI 228,500 1 234,000 1 239,600 245,400 9 973 !R9 Mffi r1R7 7nn1 -ti 71 /1� (1 Rd Qnn) 50,700 50,700 50,700 0 80,700 208,000 213,000 218,000 223,000 228,000 70011 50,70011 50,70011 0 Beginning Fund Balance 35,906 71,318 71,318 0 87,164 98,024 138,324 179,524 221,424 264,024 Plus: Revenues 55,800 55,160 57,762 2,602 55,160 55,400 56,700 57,900 59,200 60,500 Less: Expenditures (71,088) (93,483) (92,617) 866 (125,000) (223,100) (228,500) (234,000) (239,600) (245,400) Plus: Transfer In 50,700 50,700 50,700 0 80,700 208,000 213,000 218,000 223,000 228,000 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 30 DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND DETAIL (Fund - 227 Revenues Interest earnings Capital Outlay - Park & Recreation Total Expenditures DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND NET BEFORE Fund Transfer Out Total Transfer Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 ---- — ----- ---- — ----- � 2222JI 18,000 1 18,000 II 01 01 Oil 0 II 0 II 0 I1 0 9,729) (17,740) (17,742) (2) 910 300 400 400 400 400 Beginning Fund Balance 138,890 119,161 119,161 0 101,419 102,329 102,629 103,029 103,429 103,829 Plus: Revenues 271 260 258 (2) 910 300 400 400 400 400 Less: Expenditures (20,000) (18,000) (18,000) 0 0 0 0 0 0 0 Plus: Transfer In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 —1-9-1 Endina Fund Balance B-1-1 F­701� (211 102.329 1 102.629 1103 1-03� 103.829104229 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 31 DONOR RESTRICTED CONTRIBUTIONS FUND DETAIL - (Fund 2281 Revenues Restricted Donations Interest earnings Total Revenue Expenditures Public Works Improvements (PVIC Exhibits) Total Expenditures DONOR RESTRICTED CONTRIBUTIONS FUND NET BEFORE TRANSFERS Transfer To CIP Total Transfer Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 II 27,27411 1,85011 27,579 11 25,7291 7,4601 2,80011 1,50011 1,50011 1,50011 1,5001 5,041JI 32,500 22,233(30,650 0 0 LL2JI 35,709 1 2,460 0 1 01 0 01) 1,500 1,500 1,500 1,500 01 01 0 01 0 Beginning Fund Balance 843,448 865,681 865,681 0 870,740 873,200 416,000 417,500 419,000 420,500 5,041 32,500 22,520 9,9805,000 5,000 0 0 0 0 Plus: Revenues 0 455,000 0 0 0 0 5,041JI 32,500 22,233(30,650 0 0 LL2JI 35,709 1 2,460 0 1 01 0 01) 1,500 1,500 1,500 1,500 01 01 0 01 0 Beginning Fund Balance 843,448 865,681 865,681 0 870,740 873,200 416,000 417,500 419,000 420,500 Plus: Revenues 27,274 1,850 27,579 25,729 7,460 2,800 1,500 1,500 1,500 1,500 Less: Expenditures (5,041) (32,500) (22,520) 9,980 (5,000) (460,000) 0 0 0 0 Plus: Transfer In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance F 8 55,681 835,031 -870-,740-11 35,7091 873,200 416,000 417,500 419,000 420,500 422,000 B-31 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 32 Developer fees Interest earnings Total Revenue Expenditures Improvements Total Expenditures OUIMBY FUND NET BEFORE TRANSFERS Transfers Out - to CIP fund Total Transfers Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL I LL FYI 3-14 FY14-15 FY14-15 FY14-15 FY15-16 FYI 6-17 FY17-18 FY18-19 FY19-20 FY20-21 29,000 0 L0JL 0 28,356 827,924 1,279,649L 451,725 0 50,000 0 50,000 01 575,000 1 350,000 1 0 1 0 0 1 (569,100) (343,500) 5,300 5,300 5,400 01 0 1 0 1 0 1 0 0 Beginning Fund Balance 29,505 57,861 57,861 01 1,337,5101 2,431,981 1,862,881 1,519,381 1,524,681 1,529,981 Plus: Revenues 57,356 827,924 1,279,649 451,7251 1,144,471 1 5,900 6,500 5,300 5,300 5,400 Plus: Transfers In Less: Transfers Out Endinq Fund Balance CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 33 Misc revenue Interest earnings Total Revenue Expenditures Improvements Total Expenditures LOW -MOD HOUSING FUND NET BEFORE Transfers In Total Transfers In Transfers Out Total Transfers Out LOW -MOD HOUSING FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 11.109 11 Oil 22.421 11 22.421 1 9.5781 44.400 11 44.600 11 44.800 11 45.000 11 45.1001 OJI 0J1 0 1 01 01 Oil 0 1 0 1 0 0 11,109 0 22,4211 22,421 1 9,5781 44,400 44,600 44,8001 45,00045,100 0 0 0 0 0 0 0 0 0 0 0 0 0�0�0�0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0�0�0�0 0 12,411 23,520 23,520 0 45,941 55,519 99,919 144,519 189,319 234,319 11,109 0 22,421 22,421 9,578 44,400 44,600 44,800 45,000 45,100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 B-33 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 34 AFFORDABLE HOUSING IN - LIEU FUND DETAIL Developer fees 0 0 0 0 0 0 0 0 0 0 Misc revenue 2,774 0 83,355 83,355 0 0 0 0 0 0 Interest earnings (h) 1,064 1,090 1,339 249 1 4,510 1,900 2,100 2,100 2,100 2,100 Total Revenue 1 3,838 1,090 84,694 83,604 1 4,510 1 1,900 2,100 2,100 2,100 F 2,100 6,098 0 0 0 01 0 0 0 0 0 Total Expenditures 6,098 0 j 0 1 0 1 0 Oil 0 1 0 L OJI 0 AFFORDA LE BEFORETBRANSFERSGSET-ASIDE FUND NET (2260) 1,090 84,694 83,604 4,510 1,900 2,100 2,100 2,100 2,100 0 0 0 01 01 0 0 0 0 0 Total Transfers In 01 0 Fund Balance a CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 35 Developer fees Interest earnings Total Revenue Expenditures Improvements Total Expenditures EET FUND NET BEFORE TRANSFERS Transfers Out To CIP fund Total Transfers Out o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 15,333 297,579 1 21,013 1 (276,566)1 2,350 1 23,200 1 600 1 0 1 0 1 0 51,000 0 0 01 0 1 0 150,000 0 0 0 51,000 �0 �01 01 0 0 150,000 �0 �0 0 (35,667) 297,579 21,0131 (276,566) 2,350 23,200 (149,400)0 �0 0 0 450,000 97,199 352,801 200,000 0 0 0 0 0 �0_1F__45_0,0_001F___9_7,19_911 352,801 1 200,0001 0 Beginning Fund Balance 448,851 413,184 413,184 0 336,998 139,348 162,548 13,148 13,148 13,148 Plus: Revenues 15,333 297,579 21,013 (276,566) 2,350 23,200 600 0 0 0 Less: Expenditures (51,000) 0 0 0 0 0 (150,000) 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 (450,000) (97,199) 352,801 (200,000)1 0 0 0 0 0 B-35 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) i e o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FYI 3-14 FY14-15 FY14-15 FY14-15 FY15-16 FYI 6-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 36 BIKEWAYS FUND DETAIL (Fund -3401 Revenues Grant Income 34,133 0 0 0 0 82,500 0 0 82,500 0 Other revenues 0 0 0 0 0 0 0 0 0 0 Interest earnings (h) 142 0 25 25 0 0 0 0 0 300 Total Revenue7;iE 0 25 25 0 82,500 00 82,500 300 Total Expenditures 0 0 82,500 0 0 BIKEWAYS FUND NET BEFORE TRANSFERS 25 25 0 0 00 82,500 300 0 0 0 0 Transfers Out To CIP fund 95,257 0 0 0 0 0 Total Transfers Out 95,257 00 0 0 0 000 0 BIKEWAYS FUND SUMMARY: Beginning Fund Balance 61,054 72 72 0 97 97 97 97 97 82,597 Plus: Revenues 34,275 0 25 25 0 82,500 0 0 82,500 300 Less: Expenditures 0 0 0 0 0 (82,500) 0 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (95,257) 0 0 0 0 0 0 0 0 0 Ending Fund Balance 72 72 971 251 97 97 97 97 82,59782,897 i e CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 37 WATER QUALITY & FLOOD PROTECTION (Fund - §9 -11 Revenues State Grants Storm Drain User Fee Interest earnings Total Revenue Total Expenses WQFP FUND NET BEFORE TRANSFERS Fund Transfer In From CIP Fund Total Transfer In Fund Transfer Out - to CIP Fund Total Transfer Out WQFP NET ASSET SUMMARY: Beginning Unrestricted Net Position Plus: Revenues Less:Expenses Plus: Transfer In Less: Transfers Out Net (Increase)/Decrease in Capital Assets Unrestricted Net Position o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 II 7,486,84511 2,744,16711 2,591,82511 (152,342)1 1,391,8961 8,00011 011 011 011 01 6.828.41411 (4.911.115)11 1.169.39711 4.796.9141 (2.807.581 (3.139.847)11 (2.312.707)1 ---- — ----- ---- — ----- �jj 820,000 1 820,000 1 01 01 Oil 0 1 0 1 0 1 0 0 362,360 362,360 01 01 0 0 0 0 0 362,360 362,3601 01 01 0 0 9,727,246 5,317,323 5,317,323 0 5,333,829 2,526,248 190,448 (4,191,947) (6,428,024) (9,567,870) 7,486,845 2,744,167 2,591,825 (152,342) 1,391,896 8,000 0 0 0 0 (658,431) (7,655,282) (1,422,428) 6,232,854 (4,199,477) (2,343,800) (4,382,395) (2,236,077) (3,139,847) (2,312,707) 0 820,000 820,000 0 0 0 0 0 0 0 0 (362,360) (362,360) 0 0 0 0 0 0 0 1,238,337) 0 (1,610,531) 0 0 0 0 0 0 0 B-37 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 38 Interest earnings (h) Total Revenue Expenditures Maintenance & Operations (b) Total Expenditures IMPROVEMENT AUTHORITY - PORTUGUESE BEND FUND NET BEFORE TRANSFERS Transfers In From General fund Total Transfers In Oil 640 1 8411 (556)1 2,520 1 1,1001 600 1 200 1 0 1 0 73,556 102,600 69,351 33,2491 113,2001 114,900 117,700 120,500 123,400 126,400 73,556 102,600 69,3511 33,2491 113,200 114,900 117,700 120,500 123,400126,400 11 171 !�� 49 RAI 1 111n ARO] /113 Annl P1� 11� 11� M-- 70,000 70,000 40,000 40,000 01 57,0001 0 0 72,000 124,000 126,000 01 57,0001 Oil Oil 72,00011 1 Beginning Fund Balance 366,012 362,456 362,456 0 333,189 279,509 165,709 48,609 309 909 Plus: Revenues 0 640 84 (556) 2,520 1,100 600 200 0 0 Less: Expenditures (73,556) (102,600) (69,351) 33,249 (113,200) (114,900) (117,700) (120,500) (123,400) (126,400) Plus: Transfers In 70,000 40,000 40,000 0 57,000 0 0 72,000 124,000 126,000 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Endina Fund Balance3�2�F__300�F___333� 32.6931 279.509 1 165.709 F __48�F __�1 gog IF-- 509 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 39 IMPROVEMENT AUTHORITY -ABALONE COVE FUND DETAIL (Fund -795) Revenues Interest earnings Total Revenue Expenditures Storm Drain User Fee Operations Total Expenditures IMPROVEMENT AUTHORITY -ABALONE COVE FUND NET BEFORE TRANSFERS Transfers In From General fund Total Transfers In o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL LL FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 (b) II 411 2,30011 26411 (2,036)1 9,4001 3,40011 3,50011 3,50011 3,50011 3,5001 46,99911 70,300 1 57,306 1 12,9941 71,9001 74,600 1 76,400 1 78,200 1 80,100 82,000 /d�F 1.-;7 nAqJ I 1n AFiR I /R9 6nnl 171 gnn1 !�!� !� !7R 5nnl 20,000 35,000 35,000 01 37,0001 38,000 73,000 74,000 77,000 78,000 00011 35,00011 35,00011 01 37 77 Beginning Fund Balance 108,543 81,548 81,548 0 59,506 34,006 806 906 206 606 Plus: Revenues 4 2,300 264 (2,036) 9,400 3,400 3,500 3,500 3,500 3,500 2,987 3,000 3,002 (2) 0 0 0 0 0 0 44,012 67,300 54,304 12,996 71,900 74,600 76,400 78,200 80,100 82,000 46,99911 70,300 1 57,306 1 12,9941 71,9001 74,600 1 76,400 1 78,200 1 80,100 82,000 /d�F 1.-;7 nAqJ I 1n AFiR I /R9 6nnl 171 gnn1 !�!� !� !7R 5nnl 20,000 35,000 35,000 01 37,0001 38,000 73,000 74,000 77,000 78,000 00011 35,00011 35,00011 01 37 77 Beginning Fund Balance 108,543 81,548 81,548 0 59,506 34,006 806 906 206 606 Plus: Revenues 4 2,300 264 (2,036) 9,400 3,400 3,500 3,500 3,500 3,500 Less: Expenditures (46,999) (70,300) (57,306) 12,994 (71,900) (74,600) (76,400) (78,200) (80,100) (82,000) Plus: Transfers In 20,000 35,000 35,000 0 37,000 38,000 73,000 74,000 77,000 78,000 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Spendable Fund Balance 81,548 48,548 59,5061 10,9581 34,006 806 906 206 606 106 Non -Spendable Endowment 1,000,000 1,000,000 1 1,000,0001 1,000,0001 1,000,000 1,000,000 1,00o,006 -T 1,000,000 1,000,000 Ending Fund Balance Per Financial Statements 1,081,548 1,048,548 1,059,506 1,034,006 1,000,806 1,000,906 1,000,206 1,000,606E 1,000,106 C-1 CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES ACTUAL ACTUAL BUDGET PROPOSED MODEL MODEL MODEL MODEL CIP FUND PROJECTS TYPE FY13-14 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 FUNDING SOURCE Engineering Review/Labor Compliance Admin 22,808 25,277 60,000 175,000 60,000 60,000 60,000 60,000 CIP Reserve Grant Administration -- Admin -------------- --------- 72,500 ------ 70,000 70,000 70,000 ---- ----- 70,000 , -_ 70,000 CIP Reserve Infrastructure Management Plan & Misc Studies Admin 54,500 25,000 25,000 50,000 CIP Reserve ACLAD Sewer System Capital Needs Study Abalone Cove Sewer 25,000 CIP Reserve Abalone Cove Sewer Dimrict Rehabilitation Program Abalone Cove Sewer 93,000 200,000 450,000 450,000 450,000 450,000 CIP Reserve ---- --- Landslide Dewatering Well Program - _... - IPVDS Landslide - 965,000 - 450,000 -- 180,000 - 180,000 180,000 -- 180,000 CIP Reserve PVDS - Landslide Roadway Realignment and Drainage (East End) JPvDS Landslide 27,388 8,063 458,672 CIP Reserve Portugese Bend Strategic Plan - 'PVDS Landslide - - 75,000: - - - CIP Reserve Portuguest Bend Landslide Area Resurfacing Program PVDS Landslide 550,000 550,000: 550,000 600,000 600,000 600,000 Prop C -------- --------------------------- - Recognition Wall (Wall of Honor) ---------- Parks 40,000 - 100,000 CIP Reserve - _.. Lower Hesse Park Improvements Parks 487,575 200,000 ------ _..----- CIP Reserve /Quimby Eastview Dog Park Parks 50,000 100,000 CIP Reserve Coastal Bluff Fence Replacement Program Parks 200,000 2.00,000 200,000 200,0001 2.00,000 CIP Reserve __ Upper Point Vicente/Hesse Park Marquee Signage Parks 119,000 CIP Reserve Malaga Canyon Open Space Purchase Parks 1,115,880 'Federal Grant Abalone Cove Shoreline Park Improvements Parks 215,665 916,414 'Grant/CIP Reserve Hesse Park Parking Lot Parks CIP Reserve Lower Hesse/Grandview MND's Parks 12,425 CIP Reserve Abalone Cove Beach Access Rd and - - - - - -. Parking Rehab Parks 50,000 150,000 Quimby Ladera Linda Community Center Parking Lot Parks 25,000 Quimby PVIC Improvements Parks Quimby Fees/CIP Reserve Ryan Park Parks - 77,381 780,793 ----------------------- ---- CIP Reserve Eastview Park Site and Recreation Improvements Parks 250,000 ! Quimby Civic Center Tennis Court Repairs Parks CIP Reserve Storage & Supply Depots Parks CIP Reserve John C. McTaggart Memorial Hall Improvements Buildings 94,242 CIP Reserve Public Facility Connectivity (Hesse/ Park/Ryan Park Fiber Optic Cabling) Buildings 320,000 CIP Reserve RPV TV Building Improvements Buildings 6,584 44,825 149,800 CIP Reserve ADA Transition Plan Projects Buildings 17,664-97,199 810,137 150,000 1 150,000 150,000 150,000 CIP Reserve Corporation Yard Utilization Study Buildings 30,000 CIP Reserve Ladera Linda Site Master Plan Buildings 6,278 93,722 CIP Reserve Civic Center Master Plan Buildings 250,000 CIP Reserve C-1 M CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES ACTUAL ACTUAL BUDGET PROPOSED MODEL MODEL MODEL MODEL CIP FUND PROJECTS TYPE FY13-14 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 FUNDING SOURCE Hesse Park Improvements Buildings 1,444 131,314 CIP Reserve Civic Center Air Conditioning Buildings CIP Reserve Hesse Park - Solar System Buildings Grant PVIC Exhibit Replacement Buildings455,000 � Grant Ladera Linda Community Center -------------- ------------------------ ----------------------- Replacement Buildings :CIP Reserve Residential Street Rehabilitation Program Cycle 1Near 5 (Prior Years) Streets 790,957 CIP Reserve ADA Access Improv at PVDW/Hawthorne Blvd. Streets 174,900 CDBG ADA Access Improv at Mira Catalana Streets 64,700 CDBG Citywide Traffic Signal Battery Back -Up Streets 90,000 Hawthorne Blvd - Right -of -Way Beautification (Median Trees) Streets 150,000 CIP Reserve Hawthorne Blvd. Traffic Signal Synchronization Streets 683,628 HSIP/CIP Reserve Residential Street Rehabilitation Program Cycle 1/Year 6 (FY 14-15) Streets 2,229,400 CIP Reserve Sidewalk Repair &Replacement _ - --------------- - Program Streets 325,000 250,090i 250,000 250,000 250,000 250,000 Gas Tax PVDE Safety Improvements - Guardrails Streets 268,794 HSIP/CIP Reserve Hawthorne Blvd. Pedestrian Linkage Metro ran Improvements Streets 1,240,351 Reserve Metro ran PVDS - Bikeway Safety Project Streets 3,160 779,975 Reserve PVDE at Bronco - Traffic Safety Improvements Streets_ 7,798 12,039 527,095 Grant/CIP Reserve Pavement Management Program Biennial Update Streets 6,320 189,600 120,000 120,000 CIP Reserve ----------------- - Measure R/Prop Miraleste Arterial Street Rehabilitation Streets 2,534,500 C&A/STPL/CIP Reserve Residential Street Rehabilitation- - - Program Cycle 1/Year 7 Streets 4,100,000 CIP Reserve/TDA Article 3 Residential Street Rehabilitation Program Cycle 2 Streets 400,000 3,300,000 3,300,000 3,300,000 3,300,000 CIP Reserve _._ Arterial Rehabilitation - Crenshaw Blvd. Streets 200,000 800,000 2,000,000 CIP Reserve Outside Agency Contrib/CIP Western Ave - Traffic Improvements Streets 200,000 3,000,000 Reserve Arterial Rehabilitation - Indian Peak Rd. Streets 200,000 1,600,000 CIP Reserve ADA Improvements at City Hall Bus Stop Streets 192,400 CDBG Arterial Walls and Fence Replacement Program Streets 500,000 100,000 100,000 100,000_ 100,000 CIP Reserve -- - - - - Measure R/Prop Arterial Street Rehab Streets 350,184 3,347,893 C&A/STPL/CIP Reserve Arterial Median Improvements (PVDW) Streets 473,680 Beautification Fund M C-3 CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES ACTUAL ACTUAL BUDGET PROPOSED MODEL MODEL MODEL MODEL CIP FUND PROJECTS TYPE FY13-14 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 FUNDING SOURCE Residential Street Rehab Streets 1,669,337 2,743,075 CIP Reserve/TDA Article 3 Hawthorne Blvd Traffic & Pedestrian Improvements Streets 66,213 30,523 Grant/CIP Reserve Sewer Capacity Projects Sewer 7,332 25,738 CIP Reserve Torrance Airport SWQ Project Sewer 460,000 4,630,000 1,620,000CIP Reserve Drainage Area Monitoring System Water Quality ---------------- ------------------- - - CIP Reserve ----------------------_ Storm Water Quality Regional Project Water Quality CIP Reserve Trail Projects --------------------------- - Parks/Open Space 466,529 276,503Grants/CIP Reserve -' Sunnyside Ridge Trail Parks/Open Space 396,436 Grants/CIP Reserve Accessibilitylmprovements at Del Cerro Park/Burma Rd Parks/Open Space ---- -------- - -------- 164,400 ---------- ------------- - -------------- CDBG --------- --------------------- ................................ Conestogo Trail Connection Parks/Open Space 50,000 200,000 Quimby Reconciliation to CAFR Miscellaneous 235,089 CIP Reserve Total CIP Fund Expenditures 4,113,027 18,696,608 15,258,264 9,187,200 10,890,000 1 10,950,000 1 7,560,000 1 7,080,000 C-3 D-1 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL WATER QUALITY FLOOD PROTECTION (STORM DRAIN) EXPENSES ACTUAL ACTUAL BUDGET PROPOSED MODEL MODEL MODEL MODEL WQFP FUND PROJECTS TYPE FY13-14 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 FUNDING SOURCE Contract/Staff Engineers Admin 152,207 147,529 67,736 149,800 153,395 157,077 160,847 164,707 CIP Reserve Storm Drain Lining Program Lining 284,567 1,140,306 350,000. 350,000 350,000 3.5.0,000____ 350,000 User Fees/CIP Reserve Storm Drain Line Point Repair Projects Other Projects 1,050,000 500,000 User Fees Altamira Canyon Drainage Project Study Report Backbone 500,000 CIP Reserve Sacred Cove/PVDS Drainage Improvement Capacity/Secondary 450,000 User Fees/CIP Reserve Marguerite/Lower Barkentine- Seacove Drainage Improvements Capacity/Secondary 760,340 650,000 CIP Reserve Storm Drain Deficiency Improvement Program (Master Plan of Drainage Projects) Repairs/Maint 204,173 274,422 1,769,000 2,229,000 1,729,000 2,629,000 1,798,000 User Fees/CIP Reserve Outlet Improvements PVDS at Altamira Canyon Capacity/Secondary 75,000 500 ,00.0 User Fees Land Acquisition Admin 19,750 User Fees Lower San Ramon Canyon --------- ----------------- - Stabilization Backbone 11,116,002 2,234,596 User Fees/CIP Reserve PVDE San Pedro Canyon Backbone System Backbone User Paintbrush Canyon Drainage -Fees; Project Study Report Capacity/Secondary User Fees/CIP Reserve PVDE Lower Switchbacks Capacity/Secondary 19,575 User Fees South Hawthorne/Via Frascati Capacity/Secondary User Fees Roan System (Via Colinita Vickery Canyon) Capacity/Secondary 6,101 231,095 User Fees Installation of Filtration Devices Filtration User Fees Marguerite Open Channel Other Projects 64,040 16,345 User Fees Maintenance & Repair Repairs/Maint 30,356 359,076 User Fees/CIP Reserve Total WQFP Fund Expenses 1 11,896,771 1 3,031,968 4,199,477 2,343,800 1 4,382,395 1 2,236,077 1 3,139,847 2,312,707 NOTE: The total "Actual" above (for FY13-14 & FY14-15) will not agree to Total WQFP fund expenses on Page 37 of the Model, as certain expenses were captialized as assets. D-1