Loading...
CC SR 20160621 I - 2017 Five-Year Financial ModelRANCHO PALOS VERDES CITY COUNCIL AGENDA REPORT AGENDA DESCRIPTION: MEETING DATE: 06/21/2016 AGENDA HEADING: Consent Calendar Consideration and possible action regarding the 2017 Five -Year Financial Model. RECOMMENDED COUNCIL ACTION: (1) Approve 2017 Five -Year Financial 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 1�11 — APPROVED BY: Doug Willmore, City Manager' -',"•1— i ATTACHED SUPPORTING DOCUMENTS: A. June 6, 2016 Staff Report (page A-1) B. One -Page Summary — 2017 Five -Year Financial Model (page B-1) C. 2017 Five -Year Financial Model by Fund (page C-1) D. 2017 Capital Improvement Project Expenditures (page D-1) E. 2017 Water Quality Flood Protection (WQFP) Expenses (page E-1) BACKGROUND AND DISCUSSION On May 26, 2016, Staff presented the 2017 Five -Year Model (2017 Model) to the Finance Advisory Committee (FAC). Upon review, the FAC requested that Staff create subtotals for restricted funds with a projected deficit fund balance (namely the Gas Tax and Water Quality funds), and subtotals for restricted funds with a projected positive fund balance. Staff incorporated said changes (Attachment B) before the 2017 model was presented to the City Council on June 6, 2016. At this meeting, the City Council did not recommend any changes to the draft 2017 Model. With no changes requested, Staff has attached the June 6, 2016, Staff report for reference, which outlines projected revenues, expenditures, and fund balances along with economic assumptions used to build the 2017 Model. The 2017 Model indicates that General Fund activity is balanced. The General Fund unrestricted surplus, after accounting for the policy reserve of 50% of operating expenditures, is estimated to range from $1.2 million to $1.8 million each year over the next five years. It is important to mention that future economic activity, legislation and 1 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. FY16-17 General Fund Budget Assumptions General Fund Revenues Staff is projecting an increase of $732,000 or 2.6% in General Fund operating revenues, net of transfers in, for FY16-17 as compared to FY15-16 Adopted Budget. Revenues are projected to end FY15-16 slightly higher than the Adopted Budget of $27.9M by $475,000 or 1.7%, and Staff is expecting this growth to continue into FY16-17. General Fund Expenditures Staff is projecting an increase of about $2M or 9.4% in General Fund operating expenditures, net of transfers out, for FY16-17. 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. Infrastructure Budget Assumptions In prior years, Staff has presented capital appropriations by using the adopted budget figures. Starting with the 2017 Model, Staff felt it prudent to present all revised budgeted capital appropriations, including the amounts requested to be committed, in the current year's (FY15-16) budget column. Staff believes this change will more accurately represent the true impact budgeted capital appropriations will have on the fund balance. 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. Capital Improvement Protects (CIP) Fund The draft 2017 Model indicates that the Capital Improvement Project (CIP) fund balance (which includes the $3M policy reserve) will be reduced to approximately $10.1 M 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. Water Quality/Flood Protection Fund The Water Quality/Flood Protection Fund will begin the FY16-17 with an estimated $2.5M fund balance. There will be no additional revenue added to this fund balance due to the sun -setting of the Storm Drain User Fee. Public Works is proposing three (3) 2 new projects in FY16-17 for a total of $2.2M. This fund is currently operating from fund balance only, and is expected to exhaust the remaining fund balance by FY17-18. 9 RANCHO 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: A-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; A-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 A-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. MA 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. &W 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 M 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 A-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 A-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 EXHIBIT B 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, 680, 697 GENERAL FUND Unrestricted Balance 2,469,851 28,614,000 190,000 Restricted by Council Action (11,493,950) (11,814,350) BEAUTIFICATION FUND 1,255 900 - CIP 20,302,507 1,054,400 5,200,000 EQUIPMENT REPLACEMENT 2,865,804 132,030 - BUILDING REPLACEMENT - - EMPLOYEE BENEFITS - - - Subtotal 23,169,566 1,187,330 5,200,000 Restricted by Law or External Agencies 19,654,407 15,545,507 GAS TAX 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 55,929 55,400 208,000 GINSBURG CULTURAL ARTS BUILDING 102,329 300 - DONOR RESTRICTED CONTRIBUTIONS 873,200 2,800 QUIMBY 2,431,981 5,900 LOW -MOD INCOME HOUSING 55,519 44,400 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,525,253 3,607,600 246,000 GRAND TOTAL 52,111,628 34,259,530 5,636,000 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, 308, 325 13, 453, 204 13, 680, 697 13, 606, 352 13, 825, 847 (11,493,950) (11,814,350) (12,014,600) (12,419,950) (12,635,650) (22,987,900) (5,446,000) 1,814,375 1,638,854 1,666,097 1,186,402 1,190,197 2,155 2,155 2,155 2,155 2,155 (6,902,500) 19,654,407 15,545,507 11,195,607 10,357,207 10,135,907 (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,589,500) 21,967,396 18,004,396 13,759,496 12,802,796 12,329,896 (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 (538,000) 416,098 476,998 472,298 473,498 495,698 (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 (249,400) 69,929 83,929 98,029 111,929 125,629 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,194,300) (190,000) 11,994,553 11,861,953 12,175,553 12,614,953 13,007,053 (38,751,000) (5,636,000) 47,620,158 38,451,102 31,634,918 26,986,327 23,853,415 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C C-1 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 PAGE1 % Increase % Increase % Increase % Increase % Increase % Increase % Increase % Increase % Increase % Increase ECONOMIC MODEL INPUT FACTORS (a- L 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.41/o 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.40/6 2.41/6 2.40/6 Consumer Price Index (%) (d) N/A N/A N/A N/A N/A 2.2% 2.41/6 2.4% 2.40/6 2.41/6 Sales Tax (%) (e) N/A N/A N/A N/A N/A 2.4% -5.80/. -2.6% 1.0% 3.50/6 Property Taxes (%) (f) N/A N/A N/A N/A N/A 0.00% 0.0% 0.0% 0.0% 0.0% Sheriff Contract (%) (g) N/A N/A N/A N/A N/A 3.0% 3.00/6 3.00/6 3.0% 3.0% Permit Revenues (%) (h) N/A N/A N/A N/A N/A 0.0% 0.0% 0.0% 0.0% 0.0% Investment Interest (%) (i) N/A N/A N/A N/A N/A 0.40/6 0.4% 0.40/6 0.40/6 0.41/6 Franchise Tax (%) (1) N/A N/A N/A N/A N/A 2.21/6 2.40/6 2.4% 2.40/6 2.40/6 Utility Users Tax (%) (k) N/A N/A N/A N/A N/A 2.2% 2.4% 2.40/6 2.4% 2.4% C-1 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 2 o a 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 u 6 13,839,226 12,883,772 15,133,238 2,249,466 12,938,225 13,308,325 13,453,204 13,680,697 13,606,352 13,825,847 RESTRICTED BY COUNCIL ACTION (212) Beautification Fund 793,921 96,921 571,856 474,935 1,255 2,155 2,155 2,155 2,155 2,155 (330) CIP Fund 8 22,124,281 28,164,520 24,560,456 (3,604,064) 20,302,507 19,654,407 15,545,507 11,195,607 10,357,207 10,135,907 (681) Equipment Replacement Fund g 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 Fund 10 942,609 4,709 0 (4,709) 0 0 0 0 0 0 (685) Employee Benefits Fund SUBTOTAL 11 149,347 26,926,056 149,587 31,253,349 131,428 28,257,844 1 (18,159) (2,995,505) 0 23,169,566 0 21,967,396 IL18,004,396 0 0 13,759,496 0 12,802,796 1 0 12,329,896 RESTRICTED BY LAW OR EXTERNAL AGENCIES City Funds (202) Street Maintenance Fund 12 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 jaj 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 UL 21,180 22,120 22,810 690 24,010 25,510 27,010 28,510 30,010 31,510 (310) CDBG Fund 15 (68,671) 171,036 (11,624) (182,660) 0 0 0 0 0 0 (211)1911 Act Street Lighting Fund 16 1 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 _ILI 397,797 370,436 492,920 122,484 436,067 365,567 292,467 216,567 137,967 56,467 (214) Air Quality Management Fund 18 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) Fund 19 1,317,793 (59,447) 192,990 252,437 304,998 416,098 476,998 472,298 473,498 495,698 (216) Proposition A (Transit) Fund 20 441,525 31,429 236,073 204,644 381,666 524,666 607,566 655,966 695,666 744,366 (217) Public Safety Grants 21 20,570 20,610 27,012 6,402 27,202 27,402 27,502 27,602 27,702 27,802 (220) Measure R 22 1,250,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 _23J 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 -24J 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 25 (47,633) (47,533) (47,302) 231 0 0 0 0 0 0 (225) Abalone Cove Sewer District Fund 26 L 58,235 51,412 54,552 3,140 55,929 69,929 83,929 98,029 111,929 125,629 (227) Ginsburg Cultural Arts Building Fund27 119,161 101,421 101,419 (2) 102,329 102,629 103,029 103,429 103,829 104,229 (228) Donor Restricted Contributions Fund 28 865,681 835,031 870,740 35,709 873,200 416,000 417,500 419,000 420,500 422,000 (334) Quimby Fund 29 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 30 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 _31J 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 32 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) Fund 33 72 72 97 25 97 97 97 97 82,597 82,897 (501) Water Quality & Flood Protection Fund 34 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 _L5_j 362,456 300,496 333,189 32,693 279,509 165,709 48,609 309 909 509 (795) Improvement Authority - AbaloneCove 36 1 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,574,710 10,644,152 17,670,175 7,015,065 16,003,837 12,344,437 1 6,993,502 4,194,725 577,179 (2,302,328) GRAND TOTAL- ALL FUNDS INCLUDED58,339,992 54,781,273 61,061,257j 6,269,026 1 52,111,628 147,620,158 38,451,102 31,634,918 26,986,327 23,853,415 W CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 0 ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a 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) 1,642,381 11671,500 11757,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 (i) 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 0) 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 SUBTOTALTAXES 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) 5,000 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,200 47,700 48,500 48,240 SUBTOTAL USE OF MONEY & PROPERTY 797,657 748,240 706,838 (41,402) 855,720 836,000 843,400 858,200 873,600 888,440 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 I (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 18,212 0 0 0 Grant income 32,083 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 11489,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 2$614,000 29,431,87930,126,39330,921,955 31,795,195 C-3 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a 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 470 1,271,426 1,296,900 1,328,100 1,360,000 1,392,700 1,426,200 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,0291 962,4131 1,133,500 1,062,400 1,087,900 1,114,000 1,140,800 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 - 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,163 487,000 579,600593,500 607,700 622,300 637,200 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 1 621,400 636,300 C-5 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 6 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 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 Me CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 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 NON -DEPARTMENTAL 35,000 190,467 190,467 0 0 837,100 857,200 877,800 898,900 920,500 TOTAL GENERAL FUND EXPENDITURES 18,139,185 21,055,150 18,840,208 2,214,9421 20,936,748 22,987,900 23,628,700 24,029,200 24,839,90025,271,300 GENERAL FUND NET BEFORE TRANSFERS 9,690,604 6,431,978 9,244,646 2,812,668 6,945,460 5,626,100 IF -78 -0 -3 -,17 -9]F -TO -9 -7 -,19 -3]F -TO -8-2-,05-516,523,895 C-7 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 8 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 167,441 0 0 0 0 0 0 0 0 0 Total General Fund Transfers In 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 1 5,446,000 5,848,300 6,059,700 6,256,400 E 6,404,400 Net Activity 1,110,234 (1,747,151) 1,034,0811 2,781,232 (3,537,711) 370,100 144,879 227,493 (74,345)219,495 • L • CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 9 GENERAL FUND SUMMARY Beginning Fund Balance 14,508,251 15,618,485 15,618,485 0 16,652,565 13,114,854 13,484,954 13,629,833 13,857,326 13,782,981 Plus: Revenues 27,829,789 27,487,128 28,084,853 597,726 27,882,208 28,614,000 29,431,879 30,126,393 30,921,955 31,795,195 Less: Expenditures (18,139,185) (21,055,150) (18,840,208) 2,214,942 (20,936,748) (22,987,900) (23,628,700) (24,029,200) (24,839,900) (25,271,300) 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,484,954 13,629,833 13,857,326 13,782,981 14,002,476 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 737,203 0 987,562 531,765 987,562 (531,765)1 0 01 176,629 176,629 0 0 0 0 176,629 Inventory & Other 176,629 176,629 176,629 Unassigned Fund Balance (Available for Spending) 13,839,226 12,883,772 15,133,2381 2,249,466 1 12,938,225 13,308,325 13,453,204 13,680,697 13,606,35213,825,847 Policy Reserve Threshold (50% of Expenditures) 9,069,593 10,527,575 1 9,420,104 (1,107,471) 10,468,374 1 11,493,950 11,814,350 12,014,600 12,419,950 12,635,650 Excess/(Deficient) General Fund Reserves 4,769,634 2,356,197 5,713,134 3,356,937 2,469,851 1,814,375 1,638,854 1,666,097 1,186,402 1,190,197 C-9 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 10 BEAUTIFICATION FUND DETAIL (Fund -2121 Revenues Beautification revenue 0 0 0 0 0 0 0 0 0 0 Interest earnings (h) 2,194 690 1,935 1,245 870 900 0 0 0 0 Total Revenue 2,1941 690 1,9351 1,2451 870 900 000 0 Expenditures Personnel services 0 0 0 0 0 0 0 0 0 0 Operations & maintenance 0 0 0 0 473,680 0 0 0 0 0 Total Expenditures 0 0 1 473,680 1 0 BEAUTIFICATION FUND NET BEFORE TRANSFERS2,194 690 1,935 1,245 (472,810)1 10 0 473,690 0 0 0 97,791 0 0 Transfers Out To CIP fund - Street Improvements (median projects) 0 473,690 0 0 0 0 To Street Maintenance fund (median maintenance) (b) 211,404 224;000 224,000 0 0 0 0 Total Transfers Out 211,404 697,690 224,000 473,690 97,791 BEAUTIFICATION FUND SUMMARY Beginning Fund Balance 1,003,131 793,921 793,921 0 571,856 1,255 2,155 2,155 2,155 2,155 Plus: Revenues 2,194 690 1,935 1,245 870 900 0 0 0 0 Less: Expenditures 0 0 0 0 (473,680) 0 0 0 0 0 Less: Transfers Out (211,404) (697,690) (224,000) 473,690 (97,791) 0 0 0 0 0 Ending Fund Balance 793,921 96,921 571,8561 474,9351 1,255 2,155 2,155 2,155 2,155 2,155 C-10 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 PAGEILIW CIP FUND DETAIL (Fund -3301 Revenues Capital Grants & Contributions 1,691,697 3,238,785 312,272 (2,926,513) 450,270 987,500 0 0 0 0 Interest earnings (h) 25,415 16,700 36,014 19,314 t 102,300 66,900 68,800 54,400 39,200 36,300 Total CIP Fund Revenue F 1,717,112 3,255,485 348,2861 (2,907,199)1 552,570 1,054,400 68,800 54,400 39,20036,300 Expenditures Total CIP Fund Expenditures (see Exhibit C) �0 10,402,299 8,696,6081 1,705,691 1 15,353,064 1E 6,230,000 CIP FUND NET BEFORE TRANSFERS 1,717,112 (7,146,814) (8,348,322)1 (1,201,508) (14,800,494) (5,848,100) (9,671,200) (10,045,600) (6,670,800) (6,193,700) Transfers In From General 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 From General fund for Residential Street Rehab 1,873,414 2,229,400 2,229,400 0 1,862,000 0 0 0 0 0 From Water Quality Flood Protection 0 362,360 362,360 0 0 0 0 0 0 0 From Waste Reduction fund 0 0 0 0 0 0 0 0 0 0 From Measure Rfund for Arterial Street Rehab 0 1,564,000 564,000 (1,000,000) 0 0 0 0 0 0 From Measure A Capital/Maintenance fund 0 0 0 0 0 0 0 0 0 0 From Proposition C fund for Arterial Street Rehab 350,184 1,463,719 1,228,719 (235,000) 0 0 0 0 0 0 From Proposition A fund for Arterial Street Rehab 0 460,000 310,886 (149,114) 0 0 0 0 0 0 From Bikeways fund for Residential Street Rehab 95,257 0 0 0 0 0 0 0 0 0 From Quimby fund 0 50,000 0 (50,000) 50,000 0 0 0 0 0 From EET fund for ADA Projects 0 450,000 97,199 (352,801) 200,000 0 0 0 0 0 From Donor Restricted Contributions fund 0 0 0 0 0 0 0 0 0 0 From Beautification fund 0 473,690 0 (473,690) 0 0 0 0 0 0 From Building Replacement Fund 0 940,000 944,841 4,841 1 0 0 0 0 0 0 Total Transfers In 8,841,552 14,007,053 11,753,9191 (2,253,134)1 10,542,545 1 5,200,000 5,562,300 5,695,700 5,832,400 5,972,400 0 0 820,000 0 820,000 149,422 00 0 0 0 0 0 0 0 0 Transfers Out to WQFP for subsidy (b) Transfers Out to ERF for parking equipment Total Transfers Out �0 820,000 969,422 0 0 0 �0 �0 �0 0 CIP FUND SUMMARY Beginning Fund Balance 11,565,617 22,124,281 22,124,281 0 24,560,456 20,302,507 19,654,407 15,545,507 11,195,607 10,357,207 Plus: Revenues 1,717,112 3,255,485 348,286 (2,907,199) 552,570 1,054,400 68,800 54,400 39,200 36,300 Less: Expenditures 0 (10,402,299) (8,696,608) 1,705,691 (15,353,064) (6,902,500) (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) 0 0 0 0 0 0 Fund Balance 22,124,281 28,164,520 24,560,4561 (3,604,064)1 20,302,507 19,654,407 15,545,507 11,195,607 10,357,20710,135,907 Minimum Emergency Projects Reserve 3,000,000 3,000,000 3,000,000 1 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 Excess Reserve for Future Projects 19,124,281 21,560,456 17,302,507 16,654,407 12,545,507 8,195,607 7,357,207 7,135,907 C-11 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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- Revenues Interfund charges (b) 731,300 906,300 906,301 1 332,700 117,700 248,200 235,200 92,900 36,900 Other revenue 14,655 0 0 0 0 0 0 0 0 0 Interest earnings (h) 5,712 4,200 7,037 2,837 16,700 14,330 0 0 0 0 Total Revenue 751,667 910,500 913,3381 2,8381 349,400 1 132,030 248,200 235,200 92,90036,900 Expenses Vehicles and vehicle maintenance (b) 39,571 77,200 55,844 21,356 22,200 0 0 0 0 0 Computer equipment and maintenance (b) 365,367 791,835 553,349 238,486 370,000 687,000 102,300 130,200 211,200 288,500 Furniture and equipment maintenance (b) 111,077 119,751 100,343 19,408 85,500 0 0 0 0 0 Total Expenses 516,015 988,786 709,5361 279,2501 477,700 687,000 102,300 130,200 211,200 288,500 EQUIPMENT REPLACEMENT FUND NET BEFORE TRANSFERS 235,652 (78,286) 203,802 282,088 (128,300) (554,970) 145,900 105,000 (118,300)(251,600) 54,910 0 0 0 149,422 0 0 0 0 Transfers In - AQMD / fund 214 0 0 0 Transfers In - CIP /fund 330 Total Transfers In �0 149,422 0 0 0 �0 �0 �0 0 Transfers Out 0 0 0 0 0 0 0 0 0 Total Transfers Out 00 0 0 000 0 JF_-� EQUIPMENTREPLACEMENT NET ASSET Beginning Unrestricted Net Assets 2,915,898 2,915,898 0 2,994,104 2,865,804 2,310,834 2,456,734 2,561,734 2,443,434 Plus: Revenues 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 1 2,310,834 2,456,734 2,561,734 2,443,4342,191,834 C-12 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) PAGE 13 BUILDING REPLACEMENT FUND DETAIL (Fund -686) Revenues Interest earnings Total Revenue Expenses Building Improvements Total Expenses BUILDING REPLACEMENT FUND NET BEFORE TRANSFERS Transfers Out - CIP Total Transfers Out BUILDING REPLACEMENT NET ASSET SUMMARY: Beginninq Net Assets Less: Transfers Out Ending Net Position EXHIBIT C 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 2,004 ii 2,10011 2,23211 132 01 011 011 011 011 01 2,004JI 2,100 1 2,232 1 1321 01 Oil 0 1 0 1 0 1 0 0 940,000 944,841 (4,841) 0 0 0 0 0 0 940,000 944,841 (4,841) 0 1 0 0 940,605 942,609 942,609 0 0 0 0 0 0 0 2,004 2,100 2,232 132 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 (940,000) (944,841) (4,841)1 0 0 0 0 0 0 C-13 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 1FUR -6851 Revenues Interfund 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 Revenue 1,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 �0 �0 0 EMPLTRANOFERS YEE BENEFITS FUND NET BEFORE 37,976 240 (17,919) (18,159) (131,428) 0 � 0 Transfer to General Fund 0 0 0 0 0 0 0 0 0 0 Total Transfer Out 000 01 0 1 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,587 131,4281 (18,159)1 01 0 0 C-14 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 15 GAS TAX FUND DETAIL (Fund -2021 Revenues Highway Users Tax 1,352,927 1,239,552 1,090,211 (149,341) 924,797 823,000 823,000 823,000 823,000 823,000 Sidewalk repair (a) 3,000 4,100 250 (3,850)1 3,000 3,000 3,100 3,200 3,300 3,400 Miscellaneous revenues (a) 25,945 25,000 25,649 6491 25,000 12,000 12,200 12,400 12,600 12,900 Interest earnings (h) 1,389 1,610 2,472 862 8,810 4,600 560 0 0 0 Total Street Maintenance Fund Revenue 1,383,261 1,270,262 1,118,582 (151,680) 961,607 842,600 838,860 838,600 838,900 839,300 Expenditures Street Maintenance - Pavement (b) 524,977 599,500 518,749 80,751 245,000 245,000 250,900 256,900 263,100 269,400 Street Maintenance - Landscape (b) 1,464,285 1,851,279 1,521,067 330,212 1,411,279 1,332,000 1,364,000 1,396,700 1,430,200 1,464,500 Traffic Signal Maintenance (b) 100,273 126,000 116,693 9,307 127,000 10,000 10,200 10,400 10,600 10,900 Portuguese Bend Rd Maintenance 574,500 48,500 49,700 50,900 52,100 53,400 Total Street Maintenance Fund Expenditures 76,779 2,156,509 420,270 2,357,779 1,635,500 1,674,800 1,714,900 1,756,000 1,798,200 STREET MAINTENANCE FUND NET BEFORE TRANSFERS 06,517) (1,037,927) 268,590 (1,396,172) (792,900) (835,940) (876,300) (917,100) (958,900)Street Maintenance Fund Transfers In T211,40,4 From Prop C Fund (PB Road Maint) 26,000 518,749 (7,251) 526,000 0 0 0 0 0 From General fund 0 0 0 0 0 0 0 0 0 From 1972 Act 00,000 200,000 0 200,000 0 0 0 0 0 From 1911 Act 99,000 99,000 0 117,000 0 0 0 0 0 From Beautification fund ,24,000 224,000 0 97,791 0 0 0 0 0 From Waste Reduction 41,292 54,000 37,000 (17,000)1 95,000 0 0 0 0 0 Total Transfers In 1,063,696 1,103,000 1,078,7491 (24,251)1 1,035,791 1 0 Street Maintenance Fund Transfers Out To CIP Fund 0 0 0 01 0 1 0 0 0 0 0 Total Transfers Out E �0 �0 0 0 0 �0 �0 �0 0 STREET MAINTENANCE FUND SUMMARY Beginning Fund Balance 914,473 1,271,895 1,271,895 0 1,312,717 952,336 159,436 (676,504) (1,552,804) (2,469,904) Plus: Revenues 1,383,261 1,270,262 1,118,582 (151,680) 961,607 842,600 838,860 838,600 838,900 839,300 Less: Expenditures (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) Plus: Transfers In 1,063,696 1,103,000 1,078,749 (24,251) 1,035,791 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance 1,271,895 1,068,378 1,312,717 244,339 952,336159,436 (676,504) (1,552,804) (2,469,904) (3,428,804) Reserve (1 year of Pavement Management Exp) 524,977 I 518,749 526,000 550,000 550,000 600,000 600,000 I 650,000 Excess/(Deficient) Reserve for Street Maintenance 746,918 793,968 426,336 (390,564) (1,226,504) (2,152,804) (3,069,904) (4,078,804) C-15 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 16 1972 ACT LANDSCAPE & LIGHTING FUND DETAIL (Fund 203) Revenues Property assessments (e) 260,452 258,000 259,520 1,520 258,515 260,000 265,200 270,500 275,900 281,400 Interest earnings (h) 330 140 357 217 380 200 200 200 300 300 Total Revenue 260,782 258,140 259,877 1,737 258,895 260,200 265,400 270,700 276,200 281,700 Expenditures Operations & maintenance (b) 78,181 78,300 75,337 2,963 78,200 241,500 247,300 253,200 259,300 265,500 Total Expenditures 78,181 78,300 75,337 2,963 78,200 241,500 247,300 253,200 259,300 265,500 1972 ACT FUND NET BEFORE TRANSFERS 182,601 179,840 184,540 4,700 180,695 18,700 18,100 17,500 16,900 16,200 190,000 200,000 200,000 0 200,000 0 Transfers Out To Street Maintenance fund 0 0 0 0 Total Transfers Out 190,000 200,000 200,000 0 200,000 0 �0 �0 0 0 1972 ACT LANDSCAPE & LIGHTING FUND Beginning Fund Balance 70,062 62,663 62,663 0 47,203 27,898 46,598 64,698 82,198 99,098 Plus: Revenues 260,782 258,140 259,877 1,737 258,895 260,200 265,400 270,700 276,200 281,700 Less: Expenditures (78,181) (78,300) (75,337) 2,963 (78,200) (241,500) (247,300) (253,200) (259,300) (265,500) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (190,000) (200,000) (200,000) 0 (200,000) 0 0 0 0 0 Ending Fund Balance 62,663 42,503 47,203j 4,7001 27,898 46,598 64,698 82,198 99,098115,298 C-16 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 17 EL PRADO LIGHTING FUND DETAIL 1FUR -2091 Revenues Property assessments (e) 2,167 1,900 2,270 370 2,000 2,200 2,200 2,200 2,200 2,200 Interest earnings (h) 43 40 49 9 200 100 100 100 100 100 Total Revenue 2,210 1,940 2,319 379 2,200 2,300 2,300 2,300 2,300 2,300 Expenditures Light and Power (b) 0 300 659 (359) 300 300 300300 300 300 Operations & Maintenance Services (b) 30 700 30 670 700 500 500 500 500 500 Total Expenditures 1 301 311 1,000 800 800 800 800 800 EL PRADO LIGHTING FUND NET BEFORE 2,180 940 1,630 6901 1,2001 500 EL PRADO LIGHTING FUND SUMMARY: Beginning Fund Balance 19,000 21,180 21,180 0 22,810 24,010 25,510 27,010 28,510 30,010 Plus: Revenues 2,210 1,940 2,319 379 2,200 2,300 2,300 2,300 2,300 2,300 Less: Expenditures (30) (1,000) (689) 311 (1,000) (800) (800) (800) (800) (800) 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 Fund Balance 21,180 22,120 22,810 6901 24,010 1 31,510 C-17 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 18 CDBG FUND DETAIL (Fund -3101 Revenues Grant income 60,299 265,877 83,217 (182,660) 404,000 192,400 0 0 0 0 Total Revenue 60,299 265,877 83,2171 (182,660)1 404,000 192,400 000 0 Expenditures Operations & maintenance 51,000 0 0 01 0 1 0 0 0 0 0 Capital outlay (ADA Projects) 77,970 26,170 26,170 01 404,000 1 192,400 0 0 0 0 Total Expenditures 128,970 26,170 26,1701 01 404,000192,400 �0 �0 �= 0 CDBG FUND NET BEFORE TRANSFERS (68,671) 239,707 57,0471 (182,660) 01 0 Transfers In From General fund 0 1 0 0 01 11,624 0 0 0 0 0 Total Transfers In 000 01 11,624 0 000 0 Transfers Out To General fund (REACH) 0 0 0 01 01 0 0 0 0 0 Total Transfers Out 0 0 1 0 CDBG FUND SUMMARY: Beginning Fund Balance 0 (68,671) (68,671) 0 (11,624) 0 0 0 0 0 Plus: Revenues 60,299 265,877 83,217 (182,660) 404,000 192,400 0 0 0 0 Less: Expenditures (128,970) (26,170) (26,170) 0 (404,000) (192,400) 0 0 0 0 Plus: Transfers In 0 0 0 0 11,624 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance (68,671) 171,036 (11,624)1 (182,660) 0 0 000 0 C-18 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 19 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 1911 ACT STREET LIGHTING FUND DETAIL (Fund - 2 Revenues Property assessments Interest earnings Total Revenue (a) 550,798 525,000 580,631 55,631 550,000 550,000 561,000 572,200 583,600 595,300 (h) 3,795 3,500 4,248 748 15,500 5,600 6,500 6,700 7,000 7,200 554,593 528,500 584,879 56,379 565,500 555,600 567,500 578,900 590,600 602,500 Expenditures Operations & maintenance (b) 408,540 464,100 447,688 16,412 459,000 487,000 498,700 510,700 523,000 535,600 Total Expenditures 408,540 464,100 447,688 16,412 459,000 487,000 498,700 510,700 523,000 535,600 1911 ACT FUND NET BEFORE TRANSFERS 146,053 64,400 137,191 72,791 106,500 68,600 68,800 68,200 67,600 66,900 Transfers Out To Street Maintenance Fund (b) 99,000 99,000 99,000 0 117,000 0 0 0 0 0 Total Transfers Out 99,000 99,000 99,000 0 117,000 0 �0 �0 0 0 1911 ACT STREET LIGHTING FUND SUMMARY Beginning Fund Balance 1,709,606 1,756,659 1,756,659 0 1,794,850 1,784,350 1,852,950 1,921,750 1,989,950 2,057,550 Plus: Revenues 554,593 528,500 584,879 56,379 565;500 555,600 567,500 578,900 590,600 602,500 Less: Expenditures (408,540) (464,100) (447,688) 16,412 (459,000) (487,000) (498,700) (510,700) (523,000) (535,600) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (99,000) (99,000) (99,000) 0 (117,000) 0 0 0 0 0 Ending Fund Balance 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 C-1 9 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 -2131 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) 23,000 26,000 26,000 26,000 26,000 26,000 Miscellaneous revenue 0 0 0 0 0 0 0 0 0 0 Interest earnings (h) 869 800 1,077 277 3,330 1,600 1,300 1,000 800 500 Total Revenue 254,529 229,800 249,4421 19,6421 208,830 1 208,100 212,100 216,200 220,500224,800 Expenditures Personnel services (b) 71,690 74,700 75,640 (940)1 57,283 1 77,000 78,800 80,700 82,600 84,600 Operations & maintenance (b) 109,908 125,462 38,680 86,7821 110,400 1 201,600 206,400 211,400 216,500 221,700 Total Expenditures 181,598 200,162 114,3201 85,8421 167,683 1 306,300 WASTE REDUCTION FUND NET BEFORE 72,931 29,638 135,1221 105,4841 41,147 1E (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,000 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,967E 56,467 C-20 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 21 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 AIR QUALITY MANAGEMENT FUND DETAIL (Fund - 214 Revenues AB 2766 fees Interest earnings Total Revenue 38,612 50,000 66,122 16,122 50,000 50,000 50,000 50,000 50,000 50,000 (h) 277 210 203 (7)1 780 300 400 400 400 400 38,889 50,210 66,3251 16,1151 50,780 50,300 50,400 50,400 50,400 50,400 Expenditures Operations & maintenance 50,000 50,000 50,000 0 50,000 1 50,000 50,000 50,000 50,000 50,000 Total Expenditures 50,000 50,000 50,000 0 50,000 50,000 50,000 50,000 50,000 50,000 AQMD FUND NET BEFORE TRANSFERS (11,111) 210 16,3251 16,1151 780 300 400 400 400 400 54,910 0 0 0 0 0 To Equipment Replacement Fund (clean air vehicle purchases) 0 0 0 0 Total Transfers Out 54,910 �0 �0 0 01 0 AIR QUALITY MANAGEMENT FUND DETAIL Beginning Fund Balance 152,298 86,277 86,277 0 102,602 103,382 103,682 104,082 104,482 104,882 Plus: Revenues 38,889 50,210 66,325 16,115 50,780 50,300 50,400 50,400 50,400 50,400 Less: Expenditures (50,000) (50,000) (50,000) 0 (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (54,910) 0 0 0 0 0 0 0 0 0 Ending Fund Balance 86,277 86,487 102;6021 16,1151 103,382 103,682 104,082 104,482 104,882105,282 C-21 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 22 PROPOSITION C (STREET/TRANSIT) FUND DETAIL (Fund -2151 Revenues Proposition C - 1/2 cent sales tax revenue (d) 593,536 611,689 618,572 6,883 636,098 646,900 609,400 593,600 599,500 620,500 Interest earnings (h) 4,078 790 4,093 3,303 1,910 2,200 1,500 1,700 1,700 1,700 Total Revenue 597,614 612,479 622,665 10,186 638,008 649,100 610,900 595,300 601,200 622,200 Expenditures (PB Road Maintenance) 0 0 0 0 0 538,000 550,000 600,000 600,000 600,000 Total Expenditures 0�0 �0 0 0 538,000 550,000 600,000 600,000 600,000 PROPOSITION C FUND NET BEFORE TRANSFERS 597,614 612,479 622,6651 10,1861 638,008 111,100 60,900 (4,700) 1,20022,200 Transfers Out To CIP fund - Arterial Street Rehab 350,184 1,463,719 1,228,719 235,000 0 0 0 0 0 0 To Street Maintenance fund - PB Road Maintenance (b) 522,000 526,000 518,749 7,251 526,000 0 0 0 0 1 0 Total Transfers Out 872,184 1,989,719 1,747,468 242,251 526,000 0 �0 �0 �0 0 PROPOSITION C (STREET/TRANSIT) FUND SUMMARY: Beginning Fund Balance 1,592,363 1,317,793 1,317,793 0 192,990 304,998 416,098 476,998 472,298 473,498 Plus: Revenues 597,614 612,479 622,665 10,186 638,008 649,100 610,900 595,300 601,200 622,200 Less: Expenditures 0 0 0 0 0 (538,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,9901 252,4371 304,9981 416,098 476,998 472,298 473,498 495,698 C-22 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 - 2 Revenues Proposition A - 1/2 cent sales tax revenue (d) 714,750 737,443 744,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 746,0011 8,5581 767,149 781,300 736,500 717,700 725,100 750,500 Expenditures Operations (PV Transit) (b) 584,953 576,823 571,567 5,256 601,556 618,300 633,100 648,300 663,900 679,800 Capital Outlay (Bus Shelter Improvements) (b) 0 110,716 69,000 41,7161 20,000 1 20,000 20,500 21,000 21,500 22,000 Total Expenditures 584,953 687,539 640,567j 46,9721 621,556 638,300 653,600 669,300 685,400701,800 PROPOSITION A FUND NET BEFORE TRANSFERS 130,534 49,904 105,4341 55,5301 145,593 143,000 82,900 48,400 39,70048,700 Transfers Out - To CIP fund 0 460,000 310,886 149,1141 0 1 0 0 0 0 0 Total Transfers Out �0 460,000 310,8861 149,114 01 0 PROPOSITION A (TRANSIT) FUND SUMMARY: Beginning Fund Balance 310,991 441,525 441,525 0 236,073 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 Less: Expenditures (584,953) (687,539) (640,567) 46,972 (621,556) (638,300) (653,600) (669,300) (685,400) (701,800) Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 (460,000) (310,886) 149,114 0 0 0 0 0 0 Ending Fund Balance 441,525 31,429 236,0731 204,6441 381,666 524,666 607,566 655,966 695,666744,366 C-23 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 24 PUBLIC SAFETY GRANTS 1Fund-2171 Revenues Grant Income - State 100,000 100,000 106,230 6,230 100,000 100,000 100,000 100,000 100,000 100,000 Other revenues 0 0 0 0 0 0 0 0 0 0 Interest earnings (h) 170 40 212 172 190 200 100 100 100 100 Total Revenue 100;170 100,040 106,4421 6,4021 100,190 1 100,200 100,100 100,100 100,100100,100 Expenditures Equipment purchases 0 0 0 0 0 0 0 0 0 0 Total Expenditures �0 �0 �0 0 01 0 �0 �0 �0 0 PUBLIC SAFETY GRANTS FUND NET BEFORE TRANSFERS 100,170 100,040 106,442 6,402 100,190100,200 100,100 100,100 100,100 100,100 Transfers Out To General fund 100,000 100,000 100,000 01 100,000 1 100,000 100,000 100,000 100,000 100,000 Total Transfers Out 100,000 100,000 100,000 0 100,000 100,000 100,000 100,000 100,000 100,000 PUBLIC SAFETY GRANTS FUND SUMMARY: Beginning Fund Balance 20,400 20,570 20,570 0 27,012 27,202 27,402 27,502 27,602 27,702 Plus: Revenues 100,170 100,040 106,442 6,402 100,190 100,200 100,100 100,100 100,100 100,100 Less: Expenditures 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 (100,000) (100,000) (100,000) 0 (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) Ending Fund Balance 20,570 20,610 27,0121 6,4021 27,202 1 27,802 C-24 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-17 FY17-18 FY18-19 FY19-20 FY20-21 PAGE 25 Measure R - 112 cent sales tax revenue (Fund -2201 Revenues Measure R Revenue (d) 442,452 458,773 463,448 4,675 477,079 485,100 457,000 445,100 449,600 465,300 Interest earnings (h) 2,156 1,500 3,518 2,018 1,320 4,500 7,400 9,000 10,600 12,200 Total Revenue 444,608 460,273 466,9661 6,6931 478,3991 489,600 464,400 454,100 460,200477,500 Expenditures 01 0 0 0 0 0 0 0 0 0 Total Expenditures 0 �0 �0 0 0 0 �0 �0 �0 0 MEASURE R FUND NET BEFORE TRANSFERS 444,608 460,273 466,966 6,693 478,399 489,600 464,400 454,100 460,200477,500 1 0 Transfers Out 0 0 0 To CIP fund 0 1,564,000 564,000 1,000,000 0 0 Total Transfers Out 0 1,564,000 564,000 1,000,00010 0 000 0 MEASURE R FUND SUMMARY: Beginning Fund Balance 805,649 1,250,257 1,250,257 0 1,153,223 1,631,622 2,121,222 2,585,622 3,039,722 3,499,922 Plus: Revenues 444,608 460,273 466,966 6,693 478,399 489,600 464,400 454,100 460,200 477,500 Less: Expenditures 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 (1,564,000) (564,000) 1,000,000 0 0 0 0 0 0 Ending Fund Balance 1,250,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 C-25 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE § 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 HABITAT RESTORATION FUND DETAIL (NCCPI (Fund -2221 Revenues Other revenues 1,211,620 0 1,666 1,666 0 0 0 0 0 0 Interest earnings (h) 820 4,690 3,634 (1,056) 13,010 4,900 4,500 1 3,900 3,300 2,700 Total Revenue F 1,21-2,44011 4,690 5,3001 6101 13,010T-4,900 4,500 3,900 3,300 2,700 Expenditures Open Space Management, Maintenance & Monitoring (b) 133,620 159,689 136,059 23,6301 163,000 1 166,500 170,500 174,600 178,800 183,100 Total Expenditures 133,620 159,689 136,0591 23,630 1 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 ) 0 125,000 0 Transfers In From General fund 150,000 1 157,000 157,000 0 0 0 0 Total Transfers In 150,000 157,000 157,0001 0 125,000 0 000 0 Transfers Out 0 0 0 0 0 0 0 0 0 0 Total Transfers Out 01 01 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,7021 24,2401 1,444,712 1 1,283,112 1,117,112 946,412 770,912590,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,600382,650 C-26 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 27 SUBREGION 1 - MAINTENANCE FUND DETAIL 1FUnd-2231 Revenues Interest earnings Total Revenue LL (h) ACTUAL BUDGET ACTUAL FY13-14 FY14-15 FY14-15 1,695 1,700 1,947 1,695 1,700 1,9471 VARIANCE FY14-15 247 2471 BUDGET FY15-16 7,200 7,200 PROPOSED MODEL MODEL MODEL FY16-17 FY17-18 FY18-19 FY19-20 2,700 2,600 2,500 2,300 2,700 2,600 2,500 2,300 MODEL FY20-21 2,200 2,200 Expenditures Operations & maintenance (b) 32,428 67,500 51,319 16,181 67,500 44,800 45,900 47,000 48,100 49,300 Total Expenditures 32,428 67,500 51,319j 16,177F-67,500 44,800 45,900 47,000 48,10049,300 SUBREGION 1 -MAINTENANCE FUND NET BEFORE TRANSFERS (30,733) (65,800) (49,372) 16,428 (60,300) (42,100) (43,300) (44,500) (45,800) (47,100) 61,000 46,000 46,000 0 40,000 1 0 0 Transfers In - from General Fund 0 0 0 Total Transfers In 61,000 46,000 46,0001 01 40,000 0 SUBREGION 1 - MAINTENANCE FUND SUMMARY: 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 750,000 750,0001 750,000 750,000 750,000 750,000 750,000 Spendable Fund Balance 71,968 68,596 48,296 6,196 (37,104) (81,604) (127,404) (174,504) C-27 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 28 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 MEASURE A - CAPITAL (Fund -339) & MAINTENANCE (Fund -224) FUNDS DETAIL Revenues Grant income Interest earnings Total Revenue 217,441 5 289,855 100 261,049 331 (28,806) 105,000 90,000 231 0 0 0 0 90,000 90,000 0 (h) 0 0 0 I 217,446 289,955 261,3801 (28,575)1 105,000 90,000 90,000 90,000 �0 0 Total Expenditures 10 01 0 1 0 MEASURE A - CAPITAL &MAINTENANCE FUND NET BEFORE TRANSFERS 217,446 289,955 261,380 (28,575) 105,000 90,000 90,000 90,000 0 0 Transfers Out To General fund 67,441 289,855 261,049 28,8061 57,6981 90,000 90,000 90,000 0 0 To CIP fund 0 0 0 01 01 0 0 0 0 0 Total Transfers Out 67,441 289,855 261,049 28,806 57,698 90,000 90,000 90,000 0 0 MEASURE A (PARKS) - CAPITAL & MAINTENANCE FUNDS SUMMARY: Beginning Fund Balance (197,638) (47,633) (47,633) 0 (47,302) 0 0 0 0 0 Plus: Revenues 217,446 289,955 261,380 (28,575) 105,000 90,000 90,000 90,000 0 0 Less: Expenditures 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 (67,441) (289,855) (261,049) 28,806 (57,698) (90,000) (90,000) (90,000) 0 0 Ending Fund Balance (47,633) (47,533) (47,302) 231 0 0 000 0 C-2 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 29 ABALONE COVE SEWER DISTRICT FUND DETAIL 1FUnd-2251 Revenues Property Assessments (a) 55,708 55,080 56,373 1,293 55,080 55,100 56,200 57,300 58,400 59,600 Sewer Use Fee 0 1,270 1,270 0 0 0 0 0 0 Interest earnings (h) 92 80 119 39 80 300 200 300 300 400 Total Revenue 55,800 55,160 57,7621 2,6021 55,160 55,400 56,400 57,600 58,70060,000 Expenditures Personnel & Professional services (b) 13,083 19,200 19,529 866 9,483 26,300 26,900 27,500 28,200 28,900 Maintenance Services (b) 71,088 93,483 92,617 (329)1 125,0001 223,100 228,500 234,000 239,600 245,400 Total Expenditures 84,171 112,683 112,1461 5371 134,483 249,400 255,400 261,500 267,800L_.274,300 ABALONE COVE SEWER DISTRICT FUND NET BEFORE TRANSFERS (28,371) (57,523) (54,384) 3,139 (79,323) (194,000) (199,000) (203,900) (209,100) (214,300) ��� Fund Transfer In From General Fund 50,700 50,700 50,700 0 80,700 208,000 213,000 218,000 223,000 228,000 Total Transfer In 50,700 50,700 50,7001 01 80,700 1 208,000 213,000 218,000 223,000 228,000 ABALONE COVE SEWER DISTRICT FUND Beginning Fund Balance 35,906 58,235 58,235 0 54,552 55,929 69,929 83,929 98,029 111,929 Plus: Revenues 55,800 55,160 57,762 2,602 55,160 55,400 56,400 57,600 58,700 60,000 Less: Expenditures (84,171) (112,683) (112,146) 537 (134,483) (249,400) (255,400) (261,500) (267,800) (274,300) 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 Ending Fund Balance 58,235 51,412 54,552 3,1391 55,929 69,929 83,929 98,029111,929 125,629 C-29 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 30 DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND DETAIL (Fund - 2 Revenues Interest earnings (h) 271 260 258 (2)1 910 300 400 400 400 400 Total Revenue 271 260 2581 (2)1 910 1 400 Expenditures Capital Outlay - Park & Recreation 20,000 18,000 18,000 0 0 0 0 0 0 0 Total Expenditures 20,000 18,000 18,000 0 0 0 000 0 DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND NET BEFORE (19,729) (17,740) (17,742) (2) 91,0 300 400 400 400 400 � Fund Transfer Out 0 0 0 0 0 0 0 0 0 0 Total Transfer Out �0 �0 �0 0 0 0 000 0 DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND SUMMARY: 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 Ending Fund Balance 119,161 101,421 101,419 (2)1 102,329 1 103,829 104,229 C-30 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 31 DONOR RESTRICTED CONTRIBUTIONS FUND DETAIL - (Fund 228) Revenues Restricted Donations 25,500 0 25,500 25,500 0 0 0 0 0 0 Interest earnings (h) 1,774 1,850 2,079 229 7,460 2,800 1,500 1,500 1,500 1,500 Total Revenue 27,274 1,850 27,579 25,729 7,460 2,800 1,500 1,500 1,500 1,500 ll Expenditures 1 Public Works 5,041 32,50022,520 9,980 5,000 5,000 0 0 0 0 Improvements (PVIC Exhibits) 1 01 455,000 0 0 0 0 Total Expenditures 5,041 32,500 22,520 9,980 5,000 0 RESTRICTEDDONOR CONTRIBUTIONS FUND NET BEFORE TRANSFERS 22,233 (30,650) 5,059 35,709 2,460 (457,200) 1,500 1,500 1,500 1,500 0 0 0 0 0 0 Transfer To CIP 0 0 0 0 Total Transfer Out �0 �0 0 0 0 �0 �0 �0 0 DONOR RESTRICTED CONTRIBUTIONS FUND 717,17,4 SUMMARY: Beginning Fund Balance 865,681 865,681 0 870,740 873,200 416,000 417,500 419,000 420,500 Plus: Revenues 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 865,681 835,031 870,7401 35,7091 873,200 1 422,000 C-31 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 32EL QUIMBY FUND DETAIL (Fund -3341 Revenues Developer fees 57,275 827,904 1,278,322 450,418 1,125,441 0 0 0 0 0 Interest earnings (h) 81 20 1,327 1,307 19,030 5,900 6,500 5,300 5,300 5,400 Total Revenue 57,356 827,924 1,279,6491 451,7251 1,144,471 5,900 6,500 5,300 5,300 5,400 29,000 0 0 0 0 575,000 0 0 Expenditures Improvements 350,000 0 Total Expenditures 29,000 �0 �0 0 0 575,000 350,000 �0 �0 0 QUIMBY FUND NET BEFORE TRANSFERS 28,356 827,924 1,279,649 451,725 1,144,471 (569,100) (343,500) 5,300 5,300 5,400 Transfers Out - to CIP fund 0 50,000 0 50,000 50,000 0 0 0 0 0 Total Transfers Out 0 50,000 �0 50,000 50,000 0 �0 0�0 0 QUIMBY FUND SUMMARY: Beginning Fund Balance 29,505 57,861 57,861 0 1,337,510 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,725 1,144,471 5,900 6,500 5,300 5,300 5,400 Less: Expenditures (29,000) 0 0 0 0 (575,000) (350,000) 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out 0 (50,000) 0 50,000 (50,000)1 0 0 0 0 0 Ending Fund Balance 57,861 835,785 1,337,510 501,725 2,431,981 1,862,881 1,519,381 1,524,681 1,529,981E 1,535,381 C-32 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 33 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 LOW -MODERATE INCOME HOUSING FUND DETAIL 1FUnd-3361 Revenues Misc revenue Interest earnings(h) Total Revenue 11,095 0 22,350 22,350 9,578 44,300 44,300 44,300 44,300 44,300 14 0 71 71 0 100 300 500 700 800 11,109 �0 22,4211 22,421 1 9,578 44,400 44,600 44,800 45,000 45,100 Expenditures Improvements 0 0 0 01 0 1 0 0 0 0 0 Total Expenditures 0001 01 0 1 000 0 LOW -MOD HOUSING FUND NET BEFORE 11,109 0 22;4211 22,421 1 9,578 44,400 44,600 44,800 45,000 45,100 0 0 0 0 0 1 0 Transfers In 0 0 0 0 Total Transfers In 0 0 �0 0 Transfers Out 0 0 0 0 0 1 0 0 0 0 0 Total Transfers Out 0001 01 0 0 000 0 LOW -MOD HOUSING FUND SUMMARY: Beginning Fund Balance 12,411 23,520 23,520 0 45,941 55,519 99,919 144,519 189,319 234,319 Plus: Revenues 11,109 0 22,421 22,421 9,578 44,400 44,600 44,800 45,000 45,100 Less: Expenditures 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 0 0 0 0 0 0 0 0 0 Ending Fund Balance 23,520 23,520 45,9411 22,421 1 55,519 99,919 144,519 189,319 234,319279,419 C-33 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 34 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 AFFORDABLE HOUSING IN - LIEU FUND DETAIL fEund-337) Revenues Developer fees Misc revenue Interest earnings Total Revenue 0 0 0 0 0 0 0 0 0 0 2,774 0 83,355 83,355 0 0 0 0 0 0 (h) 1,064 1,090 1,339 249 4,510 1,900 2,100 2,100 2,100 2,100 3,838 1,090 84,6941 83,6041 4,510 1;900 2,100 2,100 2,100 2,100 Expenditures 6,098 0 0 0 1 0 1 0 0 0 0 0 Total Expenditures 6,098 �0 �0 �01 0 0 00--TIE-_o LE AFFORDA BEFORE TBRANSFERS HOUSING SET-ASIDE FUND NET L_(2,260]) 1,090 84,694 83,604 4,510 1,900==d== 0 0 0 0 0 0 0 0 0 0 Total Transfers In 01 01 0 0 0 0 0 0 0 0 0 0 0 Total Transfers Out 0001 01 0 10 000 0 AFFORDABLE HOUSING IN - LIEU FUND SUMMARY (NON -RDA) Beginning Fund Balance 502,188 499,928 499,928 0 584,622 589,132 591,032 593,132 595,232 597,332 Plus: Revenues 3,838 1,090 84,694 83,604 4,510 1,900 2,100 2,100 2,100 2,100 Less: Expenditures (6,098) 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 0 0 0 0 0 0 0 0 0 Spendable Fund Balance 499,928 501,018 584,622 83,604 589,132 591,032 593,132 595,232 597,332 599,432 C-34 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 35 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 ENVIRONMENTAL EXCISE TAX (EET) FUND DETAIL (Fund -338) Revenues Developer fees Interest earnings Total Revenue 14,404 297,439 20,012 (277,427)1 0 22,000 0 0 0 0 (h) 929 140 1,001 861 1 2,350 1,200 600 0 0 0 15,333 297,579 21,0131 (276,566)1 2,350 23,200 600 �0 �0 0 Expenditures Improvements 51,000 1 0 0 0 0 0 150,000 0 0 0 Total Expenditures 51,000 �0 �01 01 0 0 150,000 00 0 EET FUND NET BEFORE TRANSFERS (35,667) 297,579 21,0131 (276,566)1 2,350 23,200 (149,400) �� 0 Transfers Out To CIP fund 0 450,000 97,199 352,801 200,000 0 0 0 0 0 Total Transfers Out �0 450,000 97,199 352,801 200,000 0 ENVIRONMENTAL EXCISE TAX (EET) FUND SUMMARY 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 Ending Fund Balance 413,184 260,763 336,9981 76,2351 139,348 162,548 13,148 13,148 13,14813,148 C-35 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C o ACTUAL BUDGET ACTUAL VARIANCE BUDGET PROPOSED MODEL MODEL MODEL MODEL a FY13-14 FY14-15 FY14-15 FY14-15 FY15-16 FY16-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 0 0 0 300 Interest earnings (h) 142 0 25 25 0 0 Total Revenue 34,275 25 25 0 82,500 0� 82,500 300 Total Expenditures 0001 0 1 0 82,500 000 0 BIKEWAYS FUND NET BEFORE TRANSFERS 34,275 25 25 0 0 �� 82,500E 300 95,257 0 0 0 0 1 0 Transfers Out To CIP fund 0 0 0 0 Total Transfers Out 95,257 1 01 0 1 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 97 25 97 97 97 97 82,597 82,897 C-36 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 37 WATER QUALITY & FLOOD PROTECTION (Fund- y Revenues State Grants 6,114,956 1,387,967 1,212,995 (174,972) 0 0 0 0 0 0 Storm Drain User Fee (a) 1,360,907 1,355,600 1,368,570 12,970 1,384,096 0 0 0 0 0 Interest earnings (h) 10,982 600 10,260 9,6601 7,800 8,000 0 0 0 0 Total Revenue 7,486,845 2,744,167 2,591,8251 (152,342)1 1,391,896 1 0 Total Expenses 658,431 7,655,282 1,422,4281 4,949,2561 4,199,477 2,343,800 4,382,395 2,236,077 3,139,847 2,312,707 WQFP FUND NET BEFORE TRANSFERS 6,828,414 (4,911,115) 1,169,3971 4,796,914 (2,807,581) (2,335,800) (4,382,395) (2,236,077) (3,139,847) (2,312,707) Fund Transfer In From CIP Fund 0 820,000 820,000 01 01 0 0 0 0 0 Total Transfer In 0 820,000 820,0001 01 01 0 0 Fund Transfer Out - to CIP Fund 0 362,360 362,360 01 0 1 0 0 0 0 0 Total Transfer Out �0 362,360 362,360 0 0 0 �0 0 �0 0 WQFP NET ASSET SUMMARY: Beginning Unrestricted Net Position 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) Plus: Revenues 7,486,845 2,744,167 2,591,825 (152,342) 1,391,896 8,000 0 0 0 0 Less: Expenses (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) Plus: Transfer In 0 820,000 820,000 0 0 0 0 0 0 0 Less: Transfers Out 0 (362,360) (362,360) 0 0 0 0 0 0 0 Net (Increase)/Decrease in Capital Assets (11,238,337) 0 (1,610,531) 0 0 0 0 0 0 0 Unrestricted Net Position 5,317,323 863,848 5,333,829 6,080,512 2,526,248 190,448 (4,191,947) (6,428,024) (9,567,870) (11,880,577) C-37 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C 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 IMPROVEMENT AUTHORITY - PORTUGUESE BEND FUND DETAIL (Fund -285) Revenues Interest earnings (h) 0 640 84 (556) 2,520 1,100 600 200 0 0 Total Revenue © 640 841 (556)1 2,520 1 0 Expenditures Maintenance & Operations (bj 73,556 102,600 69,351 33,249 113,200 114,900 117,700 120,500 123,400 126,400 Total Expenditures 73,556 102,600 69,3511 33,249 1 113,200 114,900 117,700 120,500 123,400126,400 IMPROVEMENT AUTHORITY - PORTUGUESE BEND FUND NET BEFORE TRANSFERS (73,556) (101,960) (69,267) 32,693 (110,680) (113,800) (117,100) =�� (120,300) (123,400)(126,400) Transfers In From General fund 70,000 40,000 40,000 0 57,000 0 126,000 0 72,000 124,000 Total Transfers In 70,000 40,000 40,000 0 57,000 0 �0 72,000 124,000 126,000 IMPROVEMENT AUTHORITY - PORTUGUESE BEND FUND SUMMARY 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 Ending Fund Balance 362,456 300,496 333,1891 32,693 1 279,50911 909 509 C-38 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL - (BY FUND) EXHIBIT C PAGE 39 IMPROVEMENT AUTHORITY - ABALONE COVE FUND DETAIL (Fund -795) Revenues Interest earnings Total Revenue o a (h) ACTUAL BUDGET ACTUAL FY13-14 FY14-15 FY14-15 4 2,300 264 ® 2,300 264 VARIANCE FY14-15 (2,036) (2,036) BUDGET FY15-16 9,400 9,400 PROPOSED MODEL MODEL MODEL FY16-17 FY17-18 FY18-19 FY19-20 3,400 3,500 3,500 3,500 3,400 3,500 3,500 3,500 MODEL FY20-21 3,500 3,500 Expenditures Storm Drain User Fee (a) 2,987 3,000 3,002 (2) 0 0 0 0 0 0 Operations (b) 44,012 67,300 54,304 12,996 71,900 74,600 76,400 78,200 80,100 82,000 Total Expenditures 46,999 70,300 57,3061 12,9941 71,900 74,600 76,400 78,200 80,10082,000 COVE IMPROVEMENT RE TRANSFERS FUND NET BEFORE TRANSFERS (46,995) (68,000) (57,042) 10,958 (62,500) (71,200) (72,900) (74,700) (76,600) (78,500) Transfers In From General fund 20,000 35,000 35,000 01 37,000 1 38,000 73,000 74,000 77,000 78,000 Total Transfers In 20,000 35,000 35,000 0 37,000 38,000 73,000 74,000 77,000 78,000 IMPROVEMENT AUTHORITY - ABALONE COVE FUND SUMMARY 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,000 1,000,000 1,000,000 1,000,000 1,000,000 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,606 1,000,106 C-39 D-1 CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL_ CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES EXHIBIT D 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 j 70,000 70,000 70,000 CIP Reserve Infrastructure Management Plan & Misc _70,000 Studies Admin 54,500 25,000 25,000 50,000 ;CIP Reserve ACLAD Sewer System Capital Needs Study Abalone Cove Sewer 25,000 iCIP Reserve Abalone Cove Sewer District Rehabilitation Program Abalone Cove Sewer 93,000 200,000 450,000 ! 450,000 450,000 450,000 CIP Reserve ------ Landslide Dewatering Well Program PVDS Landslide - - - -- 965,000 450,000 180,000 -- 180,000_ - 180,000 180,000 CIP Reserve PVDS - Landslide Roadway Realignment and Drainage (East End) PVDS 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 538,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 200,000 200,000 200,000 200,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 - ------- Quimby/CIP Reserve Parking Lot Parks50,000 '(50/50% split) 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 ParksCIP Reserve Storage & Supply Depots ----------------------------- ParksCIP _ --------------- ------------------------ 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 94,800 55,000 ----- ------ CIP Reserve -- - ADA Transition Plan Projects Buildings 17,664 97,199 810,137 150,000 150,000 150,000 150,000 CIP Reserve Corporation Yard Utilization Study Buildings 30,000CIP --- - -------------------- ------------------------ Reserve --------------------- -- Ladera Linda Site Master Plan Buildings 6,278 93,722 CIP Reserve Civic Center Master Plan Buildings 250,000 -. CIP Reserve Hesse Park Improvements Buildings 1,444 131,314 CIP Reserve Civic Center Air Conditioning Buildings CIP Reserve D-1 RM CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL_ CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES EXHIBIT D 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 - Solar System Buildings!Grant ' - PVIC Exhibit Replacement Buildings - -' 455,000 - _-------------- - Grant Ladera Linda Community Center Replacement Buildings ;CIP Reserve Residential Street Rehabilitation Program Cycle 1/Year 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 - - - iCDBG ------------------------------ Citywide Traffic Signal Battery Back -Up --------- Streets 90,000 Hawthorne Blvd - Right -of -W ay Beautification (Median Trees) Streets 150,000 !CIP Reserve Hawthorne Blvd. Traffic Signal ---- ------- Synchronization Synchronization Streets 683,628 iHSIP/CIP Reserve Residential Street Rehabilitation Program Cycle 1/Year 6 (FY 14-15) Streets 2,229,400 lCIP Reserve _pair___ir &Replacement - Sidewalk Repa -------....- - Program Streets 325,000 250,000 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 TIP Grant/CIP Improvements Streets 1,240,351 Reserve Metro TIP Grant/CIP PVDS - Bikeway Safety Project Streets 3,160 779,975 ;Reserve PVDE at Bronco -Traffic Safety - - - Improvements Streets 7,798 1 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 iC&A/STPL/CIP Reserve Residential Street Rehabilitation Program Cycle 1/Year 7 Streets 4,100,000 iCIP 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,40.0 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 iC&A/STPL/CIP Reserve Arterial Median Improvements (PVDW) Streets 473,680 ;Beautification Fund Residential Street Rehab Streets 1,669,337 2,743,075 iCIP Reserve/TDA Article 3 Hawthorne Blvd Traffic & Pedestrian Improvements ;Streets 66,213 30,523 iGrant/CIP Reserve RM D-3 CITY OF RANCHO PALOS VERDES - 2017 FIVE-YEAR FINANCIAL MODEL_ EXHIBIT D 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 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 QualityCIP Reserve -------------------- Trail Projects Parks/Open Space 466,529 276,503 Grants/CIP Reserve Sunnyside Ridge Trail Parks/Open Space 396,436 iGrants/CIP Reserve Accessibility Improvements at Del Cerro Park/Burma Rd Parks/Open Space 164,400 iCDBG - ------- -- 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 8,696,608 15,353,064 8,995,400 10,890,000 10,950,000 7,560,000 1 7,080,000 D-3 E-1 CITY OF RANCHO PALOS VERDES 2017 FIVE-YEAR FINANCIAL MODEL -----------------------------------------------------------------------------------_ _............... WATER QUALITY FLOOD PROTECTION (STORM DRAIN) EXPENSES ---------------------------------------------------------------------------------- EXHIBIT E 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 User Fees/CIP Reserve Storm Drain Lining Program Lining 284,567 1,140,306 350,000 350,000 350,000 350,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 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,000 User Fees - Laond Acquisition - Admin - 19,750: - ------ ---- User Fees -- Lwer San Ramon Canyon -- - - - - - - - - Stabilization Backbone 11,116,002 2,234,596 User Fees/CIP Reserve PVDE San Pedro Canyon Backbone System Backbone User Fees Paintbrush Canyon Drainage ----- -- -- -- - -- - - Project Study Report Capacity/Secondary User Fees/CIP Reserve PVDE Lower Switchbacks Capacity/Secondary 19,575 User Fees South Hawthorne/Via 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 11,896,7711 3,031,968 4,199,4771 2,343,800 1 4,382,395 2,236,077 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, ascertain expenses were captialized as assets. E-1