The URL can be used to link to this page

RPVCCA_CC_SR_2013_06_18_06_2013_Five-Year_Financial_Model' CITY OF RANCHO PALOS VERDES MEMORANDUM TO: FROM: DATE: SUBJECT: REVIEWED: HONORABLE MAYOR & CITY COUNCIL MEM~ DENNIS McLEAN, DIRECTOR OF FINANCE & ~ INFORMATION TECHNOLOGY JUNE 18, 2013 2013 FIVE-YEAR FINANCIAL MODE:n CAROLYN LEHR, CITY MANAGER U)(__. Project Manager: Kathryn Down~ •• Reputy Director of Finance & Information Technology llJ_) RECOMMENDATION 1. Approve the 2013 Five-Year Financial Model (2013 Model). 2. Determine that the utility users' tax (UUT) rate of 3% continues to be a necessary General Fund revenue source, and that the current rate of 3% should be maintained. 3. Determine that the golf tax rate of 10% continues to be a necessary General Fund revenue source, and that the current rate of 10% should be maintained. EXECUTIVE SUMMARY The 2013 Model is based on the proposed FY13-14 budget and the2013 Five-Year Capital Improvement Plan. Results indicate that the General Fund Reserve stays within 3% of policy level for the duration of the 2013 Model. Based upon the assumptions in the 2013 Model, it appears that only minor corrections will be needed over the next five years to continue delivering balanced General Fund budgets. The Finance Advisory Committee (FAG) reviewed the 2013 Model on April 17, 2013 and May 8, 2013 and prepared recommendations for the City Council's budget deliberations on June 1, 2013. The FAG also provided a number of suggestions for the 2013 Model, which have been incorporated into the current version. The City's Capital Improvement Projects (GIP) Reserve established by the City Council to provide for infrastructure replacement and rehabilitation is primarily funded with annual transfers from the General Fund equivalent to transient occupancy tax (TOT) revenue (about $3.7 million annually). Staff currently recommends funding $21.7 million of infrastructure projects over the next five years from the GIP Reserve. Although it is a good start, the GIP Reserve is not sufficient to finance all of the City's infrastructure needs as 6-1 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 2of11 demonstrated by the following. • On the City's books, infrastructure is carried at its historical cost of $157.5 million, less $73.2 million of depreciation. About one-quarter of the infrastructure cost was estimated at 1973 value, when the City was incorporated and assets were transferred from the county. Most of the infrastructure has estimated useful life ranging from 30 to 50 years. We can roughly estimate the hypothetical replacement cost of this infrastructure with a simple calculation. If the increase of the Consumer Price Index (CPI) is applied to the historical cost of the assets (average of 3.35% annually since 1973), then today's estimated replacement cost is about $331 million. If this estimated replacement cost in nominal dollars is evenly distributed over a 50 year period, the rate of infrastructure replacement spending would be about $6.6 million per year (or about 180% of the City's annual transit occupancy tax revenue). The actual replacement cost of the City's infrastructure assets may be greater or less than this hypothetical estimate. This hypothetical estimate does not provide for any enhancements of infrastructure, only the replacement of existing infrastructure. • The draft 2013 Five-Year Capital Improvement Plan includes a list of projects that have been identified and quantified by the City's engineering staff, yet funding has not been identified. Some of these projects address both safety issues and City Council goals, which have a total estimated cost starting at $31.9 million. The list does not include new construction or refurbishment of City Hall. • The storm drain fee that provides about $1.3 million annually towards on-going repairs, maintenance and improvements of storm drains sunsets in 2016. Another funding source will be needed to backfill ongoing repairs and maintenance beginning in FY17-18. Unfunded GIP Projects includes more than $14 million of known, unfunded storm drain projects. None of the unfunded storm drain projects are expected to be performed prior to the sunset of the Fee in 2016. Public Works and Finance Staff are working together to develop an Infrastructure Management Plan (IMP) to address the long-term capital needs of the City. As noted in previous reports to both the Finance Advisory Committee (FAG) and the City Council, the City's infrastructure is aged; and due to budgetary constraints, the City has been cautious when budgeting for capital spending over the years. Staff expects that the IMP will provide a roadmap for future systematic replacement, refurbishment, and financing of City infrastructure. INTRODUCTION Overview The 2013 Model is a financial schedule prepared by the Finance and Information Technology Department (see Exhibits A through D). City Council Policy No. 18 requires preparation of the Model. The 2013 Model includes all funds of the City and its component unit, the Rancho Palos Verdes Improvement Authority. 6-2 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 3of11 Compliance with Legislative Review Requirements Utility Users Tax Legislative Review Municipal Code Section 3.30.190 requires that the City Manager submit to the City Council an analysis of the revenues derived from the Utility User Tax (UUT) annually. Based on the needs of the City, the City Council shall determine if any modification to the tax rate is appropriate or if the UUT is unnecessary. The tax rate cannot be increased without a majority vote of the residents of the City during a Municipal Election. The review required by this section shall be completed by the City Council prior to the adoption of each year's annual budget. The current estimate of FY13-14 UUT revenue is $2.4 million (or approximately 10% of total General Fund revenue). Based upon the operating and capital needs of the City, including unfunded storm drain and street rehabilitation projects, Staff recommends that the current UUT rate of 3% continues to be a necessary General Fund revenue source to provide current program service levels and CIP funding. Golf Tax Legislative Review Municipal Code Section 3.40.140 requires a legislative review of Golf Tax every four years and shall be completed prior to the adoption of the budget prepared for the next fiscal year. The Golf Tax ordinance directs the City Council to determine, based on the needs of the City, if any modification to the tax rate is necessary or if the tax should be repealed. The City Council performed the required legislative review in 2009 and determined that the Golf Tax is necessary and that the current rate of 10% be maintained. The next legislative review is required during 2013. The current estimate of FY13-14 golf tax revenue is $0.4 million. Based upon the operating needs of the City, Staff recommends that the current Golf Tax rate of 10% continues to be a necessary General Fund revenue source to provide current program service levels and CIP funding. Format of the 2013 Model The 2013 Model includes the presentation of: ~ Actual FY10-11 and FY11-12 revenue, expenditures and ending fund balances for all funds; ~ The final adjusted budget and the calculated budget variance for FY11-12 revenue, expenditures and ending fund balances for all funds; ~ The revised FY12-13 budget; and ~ The working draft of the FY13-14 budget as the first year of the 2013 Model. The 2013 Model includes the segregation of funds as follows: ~ General Fund -The General Fund balance represents the City's unrestricted reserve monies. These monies may be used for any City expenditure, including general operations of the City. ~ Funds restricted by action of the City Council -The fund balances of these funds 6-3 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 4of11 represent monies restricted by City Council action for a particular purpose. The funds were initiated with transfers from the General Fund. These monies may be returned to the General Fund or used for other purposes (e.g. infrastructure projects) upon the action of the City Council. ~ Funds restricted by law or external agencies -The fund balances of these funds represent monies 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 restricting agency in accordance with the terms and conditions set by legislation and voter ballot measures. The 2013 Model includes several schedules organized as follows: Exhibit A Exhibit B · Exhibit C Exhibit D One Page Summary-2013 Five-Year Financial Model 2013 Five-Year Financial Model by Fund Working Draft Capital Improvement Project Expenditures Water Quality Flood Protection (WQFP) Storm Drain Program Expenses 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 2013 Model. DISCUSSION The following assumptions have been made during preparation of the 2013 Model. Economic Assumptions 1. For years 2 through 5 of the 2013 Model, expenditures are generally expected to increase by the Consumer Price Index (CPI) for urban consumers, as projected by the Congressional Budget Office. About 40% of General Fund expenditures represent the cost of employee compensation. Any changes to employee compensation are subject to negotiation between the employee association and the City. Staff cannot predict the outcome of those negotiations. Therefore, although the 2013 Model assumes that employee compensation will continue to increase by CPI in years 2 through 5 (the same assumption for all other expenditures of the City), the actual compensation level is uncertain and will not be determined until the entire negotiation process is complete. 2. Sales tax is generally expected to increase by the CPI for urban consumers, as projected by the Congressional Budget Office. 3. Based upon an analysis of property transfers between July 2012 and February 2013, it appears that the City's assessed values will grow by 3.67% (1.67% for the properties transferred and 2.00% for all other properties). The City's property tax has grown at an average rate of 3.21 % over the last five years, which included the recession that began in 2008. Based on this continued growth and the low ratio of assessment value to market value in the City, Staff has assumed that property tax 6-4 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June1,2013 Page 5of11 will continue to grow at a rate of 3.5% annually for the remaining 4 years of the 2013 Model. 4. The Los Angeles County Sheriff's Department has advised Staff to expect a 2.4% increase in contract rates for FY13-14. The Sheriff's Contract is the single largest expenditure in the General Fund, and has grown by an average of 3.2% over the last five years due to both rate increases and service level increases. Staff has assumed a continued 2.5% average growth rate over the next five years. 5. Permit revenues comprise about 7.5% of General Fund revenue. 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 duri'ng the next five years, Staf.f 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 2013 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 have remained fairly constant over the last couple of years, Staff has not included any assumed increases or decreases in permit activity for the 2013 Model. 6. The City's excess cash is primarily invested with the state's Local Agency Investment Fund (LAIF), which is an actively managed portfolio. The LAIF investment earnings rate has hovered around one-third of one percent over the last year. For the first two years of the 2013 Model, Staff has assumed an investment earnings rate that is an average of the 3-month U.S. Treasury Rate as projected by the Livingston Report and the one-year U.S. Treasury Rate as projected by the Congressional Budget Office. For the final three years of the 2013 Model, Staff has assumed an investment earnings rate equal to the 3-month U.S. Treasury Rate as projected by the Congressional Budget Office. Staff solicited the assistance of the City's Financial Advisor when developing these assumptions. 7. UUT and franchise tax are dependent on outside forces such as weather conditions and rate increases, which cannot be predicted over the long-term with any accuracy. Therefore, 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 12 years, franchise tax has increased an average of 5.8% per year; and UUT has increased an average of 3.6% 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) accounts for about 15% of the City's General Fund revenue. Per the City Council's Reserve Policy, amounts equivalent to TOT are transferred to the Capital Improvement Projects (CIP) Reserve each year as a funding source for infrastructure improvements. The City receives most of its TOT revenue from the Terranea Resort, which opened in 2009. Now that the Resort has been open almost 4 years, Staff expects that the growth rate of TOT will slow. For example, growth from FY11-12 to FY12-13 is tracking to be about 8%; yet prior year growth was about 27%. Staff has conservatively assumed that TOT will continue to 6-5 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 6 of 11 grow by CPI for urban consumers, as projected by the Congressional Budget Office for the 2013 Model. Other Assumptions Specific to the 2013 Model 9. Other revenue sources have been estimated based upon information obtained by outside agencies or Staff's own expectations based on historical data. 10. As part of the state's solutions to its budget problems in 2004, it developed a mechanism referred to as the "triple-flip" whereby the City began receiving an additional share of property tax in lieu of 25% of the City's sales tax revenue. The triple-flip mechanism ends in FY16-17. Staff has assumed that the revenue source will revert back to sales tax for FY17-18. 11. Pursuant to state redevelopment dissolution law, on January 31, 2012 the Rancho Palos Verdes Redevelopment Agency (RDA) was dissolved. The City elected to act as the Successor Agency to the former RDA. The City is reimbursed from the Redevelopment Property Tax Trust Fund (former RDA tax increment) for its costs to administer the Successor Agency and support the Oversight Board for dissolution activities. Beginning in FY16-17 all Oversight Boards for individual successor agencies will be consolidated into one county-wide Oversight Board. Staff has assumed that beginning in FY16-17, the City will no longer receive an allowance for administration of the Successor Agency. 12.Since the inception of the former RDA in 1984, the City loaned General Fund money to it for landslide mitigation projects and administration. As of June 30, 2012, the outstanding loan balance (including accrued interest) was $19,289,059. As part of the redevelopment dissolution law, the loan to the former RDA must be restructured before repayment can begin. Based on the terms of restructuring, Staff expects the City's loan receivable may be reduced to about $12 million during 2013, and that small repayments could begin as early as FY14-15. Until more information is available, Staff has not included any estimates of loan receivable repayments in the 2013 Model. 13. The redevelopment dissolution law requires the Successor Agency to develop a long range property management plan that must be approved by the Oversight Board by October 26, 2013. This plan will outline the disposition of land parcels owned by the former RDA. Although there is not enough information to provide estimates, it is possible that a settlement will need to be negotiated with the other taxing entities in the jurisdiction if the City is to retain the parcels (e.g. Abalone Cove Shoreline Park and adjacent open space). Staff expects to propose a plan to the Successor Agency Board in late summer 2013. 14. To provide more meaningful information to the public when reviewing summaries of General Fund expenditures, Staff has created a new Risk Management program that includes the City's general liability insurance and other insurance coverage. This expenditure was formerly reported in the City Manager's program. The City is a member of the California Joint Powers Insurance Authority (CalJPIA). In past 6-6 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 7 of 11 years, the CalJPIA calculated a retroactive adjustment to the City's general liability insurance deposit to account for actual claims history. Recently, CalJPIA has transitioned to a prospective funding model, whereby retroactive adjustments are no longer calculated. At June 30, 2013, CalJPIA will close out all retroactive adjustments and either provide refunds to member agencies or invoice them for amounts due. The City will receive a refund of $563,554 for retroactive adjustments related to general liability coverage. The City's deposit due on July 1, 2013 for FY13-14 general liability coverage is $393,690. Instead of including the windfall in the draft FY13-14 General Fund operating budget, the City Council directed Staff to budget for the $393,690 expenditure and set-aside the $563,554 refund in the General Fund Reserve to be used for future spikes in deposits required for coverage. 15.Based on City Council action in· November 2012, the Beautification Fund will no longer have a dedicated revenue source. This fund previously provided for about $200,000 of annual median maintenance. The accumulated fund balance is sufficient to provide for median maintenance during FY13-14, FY14-15, and a portion of FY15-16. At that time, the fund will be closed. Based on the accumulated fund balance in the Street Maintenance fund where median maintenance expenditures are accounted for (due to prior years' expenditure savings), no additional funding source will be necessary to provide for median maintenance in the near term. However, once the accumulated Street Maintenance fund balance is depleted (estimated to occur in year 5 of the Model) a new funding source will need to be identified for median maintenance; which may be about $240,000 annually. 16. 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 continue to require an annual General Fund subsidy of about $70,000. This level of funding is consistent with prior years. b. The Improvement Authority's Abalone Cove Fund will require an annual General Fund subsidy of about $20,000. This is a new subsidy. The accumulated and ongoing interest earnings on the $1 million nonspendable fund balance required by the Horan Agreement is no longer 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. Based on City Council direction, the annual General Fund subsidy to the Abalone Cove Sewer District has been increased to $50, 700. Public Works Staff believes that the maintenance level afforded by property assessments and the City's previous subsidy of $10,700 is not sufficient to maintain the unique system that provides for 110 developed parcels in an active landslide area; and that spending must be increased by about $40,000 to maintain the system properly. d. The Habitat Restoration Fund accounts for the management, maintenance, 6-7 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 8of11 and monitoring of the City's open space. The fund receives occasional habitat mitigation revenue from outside sources, but does not have a consistent annual funding source. Therefore, a General Fund subsidy is necessary. The City's Natural Communities Conservation Plan (NCCP) requires the fund balance to grow by $10,000 each year (plus accrued interest) for 50 years to provide a future endowment for maintenance of habitat. FY13-14 is the gth year of this 50-year period. The growth of the endowment is also provided for by the General Fund. Annual subsidies are expected to range from $150,000 to $206,000 during the course of the 2013 Model, which is an increase from prior years' contributions. e. 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 interest earnings from the nonspendable endowment are not sufficient to provide the current level of maintenance. The expected annual subsidy of $61,000 from the General Fund is consistent with prior years. f. The state is expected to make a retroactive adjustment to highway users excise tax revenue for all cities during FY12-13. The adjustment for the City is expected to reduce FY12-13 Street Maintenance revenue by about $100,000. In general, Street Maintenance expenditures exceed the dedicated restricted funding sources, but the accumulated Street Maintenance fund balance resulting from prior years' savings has been sufficient to avoid the necessity of a General Fund subsidy. However, with the decrease in FY12-13 revenue, the 2013 Model indicates that the General Fund will need to provide a $100,000 subsidy to the Street Maintenance fund in FY17-18 (year 5 of the Model). 17. The City uses an Equipment Replacement Fund to centralize accounting for purchase and maintenance of the City's capitalized equipment (items with costs of $5,000 or more), and to accumulate money for the replacement of capitalized equipment. Various programs within the General Fund are charged with an allocation of Equipment Replacement Fund expenses. The City Council's Reserve Policy requires the fund balance to be maintained at a level equivalent to the estimated replacement cost of the capitalized equipment. Charges to the General Fund grow from $568,600 to $731,300 in FY13-14 to partially restore the Policy level fund balance. The growth is primarily due to the replacement of the entire Information Technology (IT) system, including replacement of all servers and most all desktop computers throughout the organization, referred to as the 2012 IT Upgrade. The City has also appropriated replacement of its processing systems for accounting, purchasing, business licensing, permitting, code enforcement, work- order management, and project management. 18. The City's employer contribution to Cal PERS to fund its employee pension plan during FY13-14 has been set at 14.660% of covered payroll for first-tier employees (those employed prior to September 23, 2011), 8.049% for second-tier employees (new hires who previously participated in a reciprocating California public employee pension system prior to January 1, 2013), and 6.25% for third-tier employees (new 6-8 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June1,2013 Page 9 of 11 hires who do not meet second-tier requirements). On April 17, 2013, the CalPERS Board of Administration approved changes to amortization and smoothing policies. On April 26, 2013, CalPERS issued a Circular Letter with a method to estimate future employer contribution rates. Based on the information in that Circular Letter, Staff has calculated the following employer contribution rates, and made assumptions about the number of full-time employees in each tier to arrive at the ·blended rate used in the 2013 Model. 1st Tier 2.5%@55 2nd Tier 2%@60 3rd Tier 2%@62 Employees Employees Employees FY13-14 48 8 0 FY14-15 est 46 10 0 FY15-16est 44 12 0 FY16-17 est 42 14 0 FY17-18est 40 16 0 , 1st Tier 2nd Tier 3rd Tier Employer Employer Employer Blended Rate Rate Rate Rate FY13-14 14.66% 8.05% 6.25% 13.72% FY14-15 est 15.70% 8.65% 6.25% 14.44% FY15-16est 17.32% 9.85% No Cale 15.72% FY16-17 est 18.94% 11.04% No Cale 16.97% FY17-18 est 20.56% 12.24% No Cale 18.18% Capital Spending Assumptions 19. Staff has included recommended projects to repair and improve the City's infrastructure that will require funding from the City's General Fund (either directly or through the CIP Reserve) over the course of the 2013 Model. City Council approves projects one year at a time with the annual budget process, and has not yet approved the projects proposed for years 2 through 5 of the 2013 Model. a. Residential Street Rehabilitation -Staff recommends annual programs ranging from $1.8 million to $2.1 million to be funded with General Fund money. The approach is consistent with prior years' practice; however, the amount has grown by about $0.3 million annually to include right-of-way rehabilitation (e.g. sidewalks, access ramps, etc.) in the same neighborhood at the same time. b. Staff recommends project expenditures totaling $21.7 million over five-years to be funded from the CIP Reserve. As noted previously, per the City Council's Reserve Policy, amounts equivalent to the City's TOT revenue are transferred to the CIP Reserve each year to provide for infrastructure improvements. Staff has prepared a new schedule for the 2013 Model 6-9 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June1,2013 Page 10of11 (Exhibit C-2) that reconciles the GIP Reserve balance since its inception in FY08-09 through FY17-18, the last year of the 2013 Model. The new schedule identifies specific projects and the amounts that are recommended for GIP Reserve funding. Each of these projects addresses a mandate by law, a safety concern, or a City Council priority. Notable projects follow. i. Arterial Street Rehabilitation totaling $7 million funded with a mix of $340,000 of Proposition C transportation sales tax, $48,000 of Proposition A transit sales tax, $2.5 million of Measure R transportation sales tax, $500,000 of federal transportation money, and a recommend use of $3.6 million of the GIP Reserve. ii. Realignment of Palos Verdes Drive South (PVDS) in the landslide area, short-term and long-term projects totaling $4,255,000 over the first two years of the 2013 Model. iii. Palos Verdes Drive East Multi-Modal roadway safety improvements are expected to cost about $3.2 million in FY15-16, and Staff expects that the project can be funded with a highway safety grant that requires a 20% matching contribution. iv. Western Avenue traffic safety improvements are expected to cost about $3.2 million in FY17-18. Western Avenue affects multiple jurisdictions, and Staff has assumed a 50% matching contribution from other agencies. A Western Avenue Vision Plan is currently being developed, which will identify opportunities for improvements in the public right-of-way. Staff expects that the Plan document will be used to obtain outside funding. A working group of stakeholders has guided the Vision Plan effort and have placed a high priority on improving the Western Avenue corridor. v. Projects totaling $2.9 million over the first 4 years of the 2013 Model to replace sewer lines that are undersized. The County maintains the City's sewer system, and makes repairs as they become necessary; but does not replace undersized pipeline. vi. Staff recommends construction of Phase I for the replacement of the Ladera Linda Community Center. The total project is expected to cost as much as $10 million, and Phase 1 is expected to cost $4 million in FY17-18. As part of this project, fiber-optic cabling would be laid to connect Ladera Linda to the City's voice and information network, as well as other City infrastructure facilities (i.e. sewer lift stations) between Ladera Linda and City Hall, for a total cost of about $2 million. vii. Projects totaling $1 million to improve storm water quality, as required by the City's municipal separate storm sewer systems (MS4) permit from the Environmental Protection Agency. viii. A subsidy of $610,000 for the storm drain program in FY17-18; subsequent to the sunset of the User Fee. c. The working draft of the 2013 Five-Year Capital Improvement Plan contains quantified projects that have not been included for recommended funding from the GIP Reserve. The estimated total costs of these projects start at $31.9 million, and include projects that address safety issues and City 6-10 DRAFT 2013 FIVE-YEAR FINANCIAL MODEL June 1, 2013 Page 11 of 11 Council priorities. 20. The City's storm drain user fee sunsets in FY15-16. Until then, Staff has assumed that the fee will increase by 2% annually. Each year, the City Council may reduce or eliminate the fee, maintain the current fee, or increase the fee by a maximum of the lesser of CPI or 2%. Once the fee sunsets, the accumulated fund balance is expected to provide for an additional year of storm drain lining and maintenance in FY16-17. However, beginning in FY17-18, this program will require an annual subsidy. Unfunded CIP Projects include more than $14 million of known, unfunded storm drain projects. None of the unfunded storm drain projects are expected to be performed prior to the sunset of the Fee in 2016 .. One of the projects is Altamira Canyon, originally estimated at $1.75 million. Based on ongoing evaluation of this drainage system, Public Works Staff is confident that the actual cost of this project will far exceed the original estimate. Staff expects that with an update of the Storm Drain Master Plan (appropriated in FY12-13), more projects will be identified and added to the list of unfunded projects in the City's Five-Year Capital Improvement Plan. 21.As required by law, to improve the City's compliance with the Americans with Disabilities Act (ADA), Staff and the City's consultants have developed a self- evaluation and transition plan that will be presented to the City Council during 2013. The transition plan has identified about $12 million of costs to improve the City's ADA compliance in the City's right-of-way and at all City facilities. The 2013 Model includes assumptions that a total of $1.3 million of projects will be constructed over the next five years which address the highest priorities. About $692,000 of these projects will be accounted for in the Community Development Block Grant (CDBG) Fund, as required by law; and the remainder will be accounted for in the CIP Fund with funding that includes $600,000 of Environmental Excise Tax (EET) and $25,000 of the CIP Reserve. 22.Staff expects to receive a total of $2.7 million of Quimby park development fees over the next two years from the Highridge and Crestridge condominium projects. Staff has proposed a total use of about $1.3 million of these fees for various park projects identified on Exhibit C-1 of the 2013 Model. Attachments: Exhibit A Exhibit B Exhibit C Exhibit D One Page Summary-2013 Five-Year Financial Model 2013 Five-Year Financial Model by Fund Working Draft Capital Improvement Project Expenditures Water Quality Flood Protection (WQFP) Storm Drain Program Expenses 6-11 Restricted by Council Action BEAUTIFICATION FUND CIP EQUIPMENT REPLACEMENT BUILDING REPLACEMENT Restricted by Law or External Agencies STREET MAINTENANCE 1972ACT EL PRADO LIGHTING CDBG 1911 ACT WASTE REDUCTION AIR QUALITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLIC SAFETY GRANTS MEASURER HABITAT RESTORATION SUBREGION 1 MAINTENANCE MEASURE A ABALONE COVE SEWER DISTRICT GINSBURG CULTURAL ARTS BUILDING DONOR RESTRICTED CONTRIBUTIONS QUIMBY AFFORDABLE HOUSING IN LIEU ENVIRONMENTAL EXCISE TAX BIKEWAYS WATER QUALITY/FLOOD PROTECTION IMPROV AUTH -PORTUGUESE BEND IMPROV AUTH -ABALONE COVE 512,751 6,822,269 1,770,290 941,627 913,553 63,467 17,755 (42,446) 1,468,784 241,652 91,674 33,893 197,112 586 192,536 181,172 772,359 (65,516) 26,772 159,272 408,849 420 505,350 304,493 (0) 493,788 273,422 98,813 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL EXHIBIT A ··~~=~~~~~fir~:==~t::, !llifAil~:?•srJioi:&,~~~r~till!\il·l;:1J111~~1·•·~~&~'~111 ~.ewi41iW. +:•;:m;t~riitiniMil ji1&11t~&~~tfoo•.••1 ::. a:62s,j}20·· di~t!~iM«!iM@H~~ifi*iaumrnH.~W#!h~*ii 1,530 1,220,400 736,600 2,800 1,993,515 6,942,700 (8,029,975) (693,900) (214,000) rnrii!i5'4i~~?@~1u~:~:$Jtrno•l Jt. ,,7·······---x .... ·.·.·.·.·.·.· ..... Ji .. ".--JI 1,294,425 258,190 1,950 189,364 529,400 191,125 50,270 591,617 713,713 100,000 444,217 540 2,300 170,516 54,080 480 1,220 1,400,000 1,510 241,670 26,586 1,330,500 1,082,000 150,000 61,000 50,700 (2,296,679) (72,800) (1,000) (146,918) (532,500) (169, 100) (50,000) (578,340) (158,620) (71,000) (105,600) (3,800) (1,596,908) (190,000) (99,000) (62,000) (592,000) (100,000) (105,000) (993,000) (300,000) (26,586) 820 I .. -' "'' ,, ~~;;J I ,1,;tts;iiswWR!@"''- 300,281 83,211 0 0 0 6,955,394 4,563,494 6,916,494 9,282,694 4,989,894 1,812,990 1,859,790 1,917,090 2,012,690 2,132,990 944,427 948,927 958,227 986,027 1,024,927 30,172 30,312 30,612 31,502 32,742 ~rn:~~K~li~Mtst;•·1~l~a5;7&~· •:•:::.:;·~l~2~l4~4w1rn121s;1~;~i¥Jfrnn~1ii:S§'• 993,299 1,046,429 936,440 722,740 571,190 58,857 58,037 61,207 69,287 82,027 18,705 19,695 20,785 22,285 24,065 0 0 0 0 0 -1,366,684 1,350,684 1,340,484 1,354,184 1,380,184 201,677 160,537 118,717 77,267 33,917 91,944 92,384 93,294 96,004 99,794 33,510 104,570 108,000 185,140 68,150 332,485 423,665 568,325 728,435 904,105 586 586 596 616 636 636,753 92,783 556, 193 45,053 30,433 173,092 174,912 188,232 215,702 257,322 764,659 756,759 751, 159 758,359 772,059 0 0 0 0 0 25,952 24,052 21,172 17,392 12,232 159,752 160,512 162,092 166,802 173,392 410,069 412,019 416,069 428,159 445,069 407,420 1,409,360 1,423,210 1,464,550 1,522,400 503,060 727,278 734,428 755,768 785,618 246,163 112,751 88,861 116,441 146,041 (0) (0) (0) (0) (0) 227,380 379,492 982,866 211,713 25, 113 225,142 174,612 122,132 68,782 11,702 68,813 39,413 13,913 6,413 7,913 ~~~~t=l[l[~j;~~ll~;1~~:~~·::·:!~~;;~;;~;::::;:;i;;~;~·:i~·!:~;;;;;1;.1 6 - 1 2 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) BUOGl:'t . ACTUAL F\'11~#< . i=Y11-12 a: ACTUAL ~ ~ FY10"11 v~~~~ --, I I PAGE1 I % Increase % Increase I % Increase I % Increase I 1 ECONOMIC MODEL INPUT FACTORS {a-el: u Maximum Property Assessment Increase NIA Increase Factor(%) Expenditures I (bl I NIA NIA NIA NIA NIA NIA NIA Consumer Price Index(%) (c) NIA NIA NIA NIA Sales Tax(%) (d) NIA NIA NIA NIA Property Taxes(%) (e) NIA NIA NIA NIA Sheriff Contract(%) (f) NIA NIA NIA NIA Permit Revenues(%) (g) NIA NIA NIA NIA Investment Interest(%) (h) NIA NIA NIA NIA Utility Users Tax/Franchise Tax(%) (I) NIA NIA NIA NIA REVISED BUDGET FY12-13 % Increase NIA NIA NIA NIA NIA NIA NIA NIA NIA I ··:·:·:·-:::>·:··-.-··:. . P:aoP<:>sED ·•···•• i=Yis"14 % Increase 2.0% I 3.0% 1.9% 1.9% 3.7% 2.4% 0.0% 0.30% 1.9% MODEL FY14-15 ~·~~· t,:~t~~> EXHIBIT B MODEL FY17-18 % Increase i % Increase I % Increase I % Increase ~ I 2.0% i 2.0% 2.0% 2.0% 2.1% I 2.1% 2.2% 2.3% 2.1% I 2.1% 2.2% 2.3% 2.1% I 2.1% 2.2% 2.3% 3.5% I 3.5% 3.5% 3.5% 2.5% I 2.5% 2.5% 2.5% I 0.0% I 0.0% 0.0% 0.0% 0.48% I 0.98% 2.91% 3.95% 2.1% + 2.1% 2.2% 2.3% i 6 - 1 3 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) EXHIBIT B "' . ACTUAGf •.. VARIANCE REVISED :. _:;_.· ....... ; M()D~I. ~ ACTUAL £1U!)GEl'· BUDGET p~~~~!() \ ti~~~; . MODEL MODEL ~ F¥10-11 F¥11~i2 fY'11-iF· F£11~12 FY12-13 FY15-16 F¥16-17 FY17•1tr''' ... ··.·. . PAGE2 I SUMMARY OF ENDING UNRESERVED FUND w ---,-· " I BALANCES :i: ; I UNRESTRICTED FUND l (101) General Fund 6 11,385,759 10,686,841 12,464,439 1,777,598 10,513,723 9,859,180 9,628,920 9,756,540 10,413,330 10,848,920 RESTRICTED BY COUNCIL ACTION I (212) Beautification Fund 7 916,780 411,580 1,065,481 653,901 512,751 300,281 83,211 0 0 0 (330) CIP Fund 8 11,649,780 19,223,735 15,406,940 (3,816,795) 6,822,269 6,955,394 4,563,494 6,916,494 I 9,282,694 4,989,894 (681) Equipment Replacement Fund 9"; 2,601,030 2,564,719 2,584,090 19,371 1,770,290 1,812,990 1,859,790 1,917,090 2,012,690 2,132,990 (686) Building Replacement Fund 10 991,322 828,314 943,006 114,692 941,627 944,427 948,927 958,227 986,027 1,024,927 (685) Employee Benefrts Fund 11 450,350 63,586 90,742 27,156 30,082 30,172 30,312 30,612 31,502 32,742 SUBTOTAL 16,609,263 23,091,935 20,090,260 (3,001,675) 10,077,020 10,043,265 7,485,735 9,822,424 12,312,914 8,180,554 RESTRICTED BY LAW OR EXTERNAL AGENCIES City Funds (202) Street Maintenance Fund 12 915,143 743,993 1,056,893 312,900 913,553 993,299 1,046,429 936,440 722,740 571,190 (203) 1972 Act Landscape & Lighting Fund 13'.· 94,036 78,416 78,077 (339) 63,467 58,857 58,037 61,207 69,287 82,027 (209) El Prado Lighting Fund 14; 14,782 15,752 16,775 1,023 17,755 18,705 19,695 20,785 22,285 24,065 (310) CDBG Fund 15 0 70,000 (42,446) (112,446) (42,446) 0 0 0 0 0 (211) 1911 Act Street Lighting Fund 16 1,652,646 1,453,846 1,670,384 216,538 1,468,784 1,366,684 1,350,684 1,340,484 1,354,184 1,380,184 (213) Waste Reduction Fund 17' 308,434 208,459 268,962 60,503 241,652 . 201,677 160,537 118,717 77,267 33,917 (214) Air Quality Management Fund 18 ; .. 48,606 98,866 101,184 2,318 91,674 91,944 92,384 93,294 96,004 99,794 (215) Proposition C (StreetsfTransit) Fund .19'· 1,570,674 2,577 1,341,810 1,339,233 33,893 33,510 104,570 108,000 185,140 68,150 (216) Proposition A (Transit) Fund :2(F' 125,603 114,391 170,422 56,031 197,112 332,485 423,665 568,325 728,435 904,105 (217) Public Safety Grants 2-f'' 19,930 20,100 20,186 86 586 586 586 596 616 636 (220) Measure R 22 630,132 2,520 391,926 389,406 192,536 636,753 92,783 556,193 45,053 30,433 (222) Habitat Restoration Fund -NCCP 23< 263,058 221,358 221,042 (316) 181,172 173,092 174,912 188,232 215,702 257,322 (223) Subregion 1 Maintenance Fund 24 776,007 759,807 773,559 13,752 772,359 764,659 756,759 751,159 758,359 772,059 (224) Measure A Cap. & Maint. Funds 25 (126,397) (126,227) (65,686) 60,541 (65,516) 0 0 0 0 0 (225) Abalone Cove Sewer District Fund 2$; 96,678 20,438 39,272 18,834 26,772 25,952 24,052 21,172 17,392 12,232 (227) Ginsburg Cultural Arts Building Fund 27 182,948 158,868 158,482 (386) 159,272 159,752 160,512 162,092 166,802 173,392 (228) Donor Restricted Contributions Fund 28: 405,519 407,539 406,809 (730) 408,849 410,069 412,019 416,069 428,159 445,069 (334) Quimby Fund ?Q. 29,328 29,478 29,420 (58) 420 407,420 1,409,360 1,423,210 1,464,550 1,522,400 (337) Affordable Housing In-Lieu Fund 30 4,152 2,096,530 501,190 (1,595,340) 505,350 503,060 727,278 734,428 755,768 785,618 (338) Environmental Excise Tax (EET) Fund 31 415,397 377,562 414,523 36,961 304,493 246,163 112,751 88,861 116,441 146,041 (340) Bikeways (TOA Article 3) Fund 32 51 51 61 10 (0) (0) (0) (0) (0) (0) (501) Water Quality & Flood Protection Fund 33 3,365,616 3,504,050 3,531,615 27,565 493,788 227,380 379,492 982,866 211,713 25,113 Improvement Authority Funds I I (285) Improvement Authority -Portuguese Bend 34 302,328 220,198 309,722 89,524 273,422 225,142 174,612 122,132 68,782 11,702 (795) Improvement Authority -Abalone Cove 35 292,777 249,227 202,813 (46,414) 98,813 68,813 39,413 13,913 6,413 7,913 SUBTOTAL 11,387,449 10,727,800 11,596,996 869,196 6,337,761 6,946,003 7,720,531 8,708,176 7,511,093 7,353,363 I GRAND TOTAL -ALL FUNDS INCLUDED I I 39,382,411 11 44,506,57611 44,151,69511 (354,881)1 26,928,504 I 26,848,44811 24,835,186 II 28,281,14011 30,237,337 1 26,382,837 I : I I I 6 - 1 4 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) a: ~ PAGE3 GENERAL FUND REVENUE DETAIL A(;IUAL ·· . ·.BUDGET Fi'to~H 'f.Y11~12 ACTUAL FY11-12 VA~IA~~~ ~11~12> REVISED BUDGET FY12-13 PROPOSED FY13-14 MODEL.·· ... •MQP~L FY14.'J5 .· c f't'jlii-1$ MODEL FY1v-17 EXHIBIT B MODEL FY17-18 ----~ ----- ------ Property taxes I (el I 5,979,684 I 6,112,100 I 6,075,623 I (97,01111 6,254,800 I 6.450,ooo I 6,675,800 I 6,909,500 I 1,151,300 1,401.600 Property taxes In-Lieu of VLF Revenues (e) 3,511,629 3,599,400 3,605,510 I 6,110 3,694,230 3,830,000 3,964,100 4,102,800 4,246,400 4,395,000 Property taxes In-Lieu of Sales Tax (d) 431,487 542,000 541,717 ' (283) 453,908 471,000 480,900 491,000 501,800 O Sales and use tax (d) 1,518,291 1,625,300 1,448,508 (176,792) 1,552,200 1,640,000 1,674,400 1,709,600 1,747,200 • ·-2,300,70o Property transfer tax (e) 229,816 209,100 272,802 63,702 285,000 416,000 430,600 445,700 461,300 ' 477,400 Business license tax (c) 581,141 593,300 700,156 106,856 718,000 715,000 730,000 745,300 761,700 779,200 Transient occupancy tax (c) 2,640,368 3,226,000 3,349,015 123,015 3,611,074 3,679,700 i 3,757,000 3,835,900 3,920,300 4,010,500 Franchisetaxes (i) 1,824,891 1,811,700 1,881,163 69,463 1,917,000 1,779,000 1,816,400 1,854,500 1,895,300, 1,938,900 Utility user tax (i) 2,406,833 2,432,700 2,333,440 (99,260) 2,385,000 2,420,000 I 2,470,800 2,522,700 2,578,200 ' 2,637,500 Golf tax I (cl I 363.402 I 338,600 I 398,226 I 59,626 I 409,ooo I 404,ooo I 412,500 I 421,200 I 430,500 1 440.400 SUBTOTAL TAXES I 19,487,540 I 20,550,800 I 20,606,160 I 55,360 I 21,280,212 I 21,804,700 I 22,412,500 I 23,038,200 I 23,694,000 24,381,200 Animalcontrolfees I (g) I 50,364 I 51,200 I 33,752 Right of way & parking permits I (g) I 78,204 I 87 ,500 I 63,650 Building and safety permits & geology fees (g) 1,383,908 1,446,800 ' 1,307,445 Planning permits (g) 347,458 378,400 354,785 Film permits I (91 I 70,820 I 76,900 I 45,575 Massage Permits I (g) I 2,090 I 2,800 I 941 SUBTOTAL LICENSES & PERMITS 1,932,844 I 2,043,600 I 1,806,148 (17,448) (23,850) (139,355) (23,615) (31,325) (1,859) (237,452) 52,200 66,700 1,363,600 297,000 45,000 2,900 1,827,400 35,000 72,400 1,317,500 317,000 45,000 0 1,786,900 35,000 72,400 1,317,500 317,000 45,000 0 1,786,900 35,000 72,400 1,317,500 317,000 45,000 0 1,786,900 35,000 ! 72,400 ' 1,317,500 3i7.000' 45,000 o' 1,786,900 35,000 72,400 1,317,500 317,000 45,000 0 1,786,900 (c :) I 201,878 I 211,900 I 147,684 J (70,216)1 77.ooo I · 105.ooo I 101,200 I 109,500 I 111,900: 114,500 False alarm fines 7,900 6,000 7,300 1,300 8,200 5,500 5,500 5,500 5,500 i 5,500 Towfees (c) 0 0 4,504 1 4,504 0 5,000 5,100 5,200 ~ 5,400 SUBTOTAL FINES & FORFEITURES I 209,778 I 223,900 I 159,488 I (64.412)1 85,200 I 115,500 I 117,800 I 120,200 I 122,700 I 125,400 Property & Monopole Leases (c) 235,556 142,500 151,837 ! 9,337 Facility rentals -PVIC (c) 159,702 122,800 209,049 86,249 Facility rentals -Other (c) 135,313 115,600 121,581 5,981 Parking lot fees 46,062 48,900 59,451 10,551 PVIC gift shop (c) 100,557 110,000 98,449 (11,551) Interest earnings (h) 61,504 50,800 46,421 (4,379) SUBTOTAL USE OF MONEY & PROPERTY 738,692] 590,600 686,788 96,188 Engineering fees (g) 0 0 60,239 60,239 Recreation fees (c) 9,782 9,400 11,909 2,509 Sale of Signs/Services (g) 6,921 7,500 5,901 ! (1,599) Administration of Successor Agency 0 0 01 0 lnterfund charges for services (a) 151,200 154,300 192,300 38,000 SUBTOTAL CHARGES FOR SERVICES 167,903 l 171,200 270,349 99,149 Motor vehicle license fees 220,790 0 0 0 Grant income 6,013 15,000 6,365 (8,635) SUBTOTAL REVENUES FROM OTHER AGENCIES 226,803 15,000 6,365: (8,635) Donations (cJ I 28,609 21,000 32,369: 11,369 Other miscellaneous (c) I 129,650 6,200 103,190: 96,990 SUBTOTAL OTHER REVENUES 158,258 27,200 135,559 I 108,359 TOTAL GENERAL FUND REVENUES 11 22,921.818 23,622,300 23,670,857 : 48;557 137,000 170,000 113,000 58,000 100,000 60,000 638,000 40,000 9,600 7,700 80,000 157,400 294,700 22,312 0 22,312 21,300 15,000 36,300 24,184;124 151,500 200,000 86,500 59,000 120,000 53,790 670,790 35,000 18,700 8,000 80,000' 156,000 297,700 0 27,000 27,000 17,100 15,000 l I 32,100 i 154,700 204,200 88,300 59,000 122,500 82,640 711,340 35,000 19,100 8,000 80,000 159,100 301,200 0 0 0 17,500 15,300 32,800 24,734,69011 25,362,540 l 157,900 161,400 ! 165, 100 208,500 213,100 ' 218,000 90,200 92,200' 94,300 59,000 59,000 59,000 125,100 127,900 : 130,800 168,220 501,090 i 707,290 808,920 1,154,690 i 1,374,490 35,000 35,000 35,000 19,500 19,900 ' 20,400 8,000 8,000 8,000 80,000 o, 0 162,300 165,500 : 168,800 304,800 228,400 232,200 0 --0~ 0 0 0 0 0 0 0 17,900 18,300 ~ 18,700 15.900'. .. 16,300 15,600 33,500 34,200 ; 35,000 26,092,520 lf27,02C(ll90 II 27,935, 190 6 - 1 5 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) PAGE4 GENERAL FUND EXPENDITURE DETAIL E! ~ ACTUAL·· FY10•11 ~Od~~i / •: ACTUAL iW#Wi·t··. FY11~12 VARIANCE FY11•12 REVISED BUDGET FY12-13 PROPOSED /F\'13-14 MODEL FY14-15 ------ Mo6¢~;j ;i\~g~~l-· FY15~16:} :<::::•FY16•17 ::: ~:::: > :-..• · .•. EXHIBIT B MODEL FY17-18 City Council (b) 100,548 136,500 133,698 2,802 143,500 149,100 ---152,200 155,400 158,800 162,500 City Manager , (b) 931,552 1,046,095 995,275 50,820 1,151,605 940,800 960,600 980,800 1,002,400 1,025,500 Legal Services ! (b) 948,605 1,065,000 1,057,102 7,898 1,045,000 1,045,000. 1,066,900 1,089,300 1,113,300 1,138,900- City Clerk i (bl I 468,323 I 524,750 I 503,877 I 20,873 I 404,750 I 011,250 ' 470,900 I 633,900 I 494,500 I 659,300 Community Outreach (b) I 82,429 107,800 102,702 5,098 105,400 80,574 82,300 84,000 85,800 87,800 RPVTV 1 (b) 97,929 109,500 109,454 46 102,100 103,400' 105,600 107,800 110,200 112,700 Risk Management i (b) I 515,034 I 721,100 I 660,899 I 60,201 I 602,000 I 475,000 • 485,000 I 495,200 I 506,100 I 517,700 Personnel i (bl I 210,852 I 293,450 I 294,298 I (848)1 211,005 I 259,050 : 264,500 I 210,100 I 276,ooo I 282,300 SUBTOTAL ADMINISTRATION i 3,415,272 r 4,004,1951 3,857,305 I 146,8961 3,831,3601 3,664,174' 3,588,000 I 3,816,500 I 3,747,100 I 3,986,700 ! Finance I (b) 1,245,015 1,351,388 1,341,972 9,416 1,290,000 1,442,700 ! 1,451,000 1,481,500 1,514,100 1,548,900 Information Technology -Data (b) 488,258 411,500 356,281 55,219 468,000 533,800 ; 545,000 556,400 568,600 581, 700 Information Technology-Voice I {b) I 72,007 I 93,800 I 69,218 I 24,582 I 88,400 I 99,300 i 101,400 I 103,500 I 105,800 I 108,200 SUBTOTAL FINANCE & IT I 1,805,280 I 1,856,688 I 1,767,471 I 89,217 I 1,846,400 I 2,075,800 I 2,097,400 I 2,141,400 I 2,188,500 I 2,238,800 Public Safety -Sheriff Services Special Safety Programs Animal Control Emergency Preparedness SUBTOTAL PUBLIC SAFETY Public Works Administration {Staffing, Project Management and Engineering) Traffic Management Storm Water Quality (NPDES Compliance) Public Building Maintenance Parks Maintenance Sewer Maintenance SUBTOTAL PUBLIC WORKS (f) (b) (b) (b) (b) (b) (b) (b) (b) (b) 3,989,703 4,015,000 139,867 89,500 64,753 130,250 115,133 141,948 4,309,456 4,376,698 1,865,666 2,095,408 167,316 169,700 115,661 180,300 453,168 608,800 1,066,587 1,167,270 37,180 63,375 3,705,579 4,284,853 3,957,051 57,949 24,513 64,987 55,862 74,388 140,500 1,448 4,177,926 198,772 1,974,634 120,774 139,712 29,988 92,945 87,355 491,226 117,574 1,012,060 155,210 13,307 50,068 3,723,884 560,969 4,174,000 104,500 88,250 201,902 4,568,652 1,975,425 260,300 180,800 600,200 1,304,000 88,000 4,408,725 4,254,200 104,500 I 88,ooo i 236,100 ! 4,682,800 1 i 2,161,000 ! 296,ooo I 405,500 I 596,600 I 1,351,130 ! 68,000 I 4,878,230 I I Planning I (bl I 1,409,575 I 1,303,010 I 1,302.440 I 630 I 1,385,287 I 1,315,840 1 Building & Safety Services I (b) I 569,318 I 586,806 I 574,613 I 12,193 I 649,694 I 670,700 I Code Enforcement I (b) I 178,005 I 207,000 I 187,237 I 19,763 I 213,300 I 214,900 I View Restoration/Preservation (b} 329,553 337,400 324,520 12,880 368,300 381,300 ; Natural Community Conservation Planning (NCCP) 1,476 2,380 2,380 0 99,593 O I Geology (Privately Initiated Projects) (g) I 120,360 I 150,000 I 88,708 I 61,292 I 150,000 I 150,000 i SUBTOTAL COMMUNITY DEVELOPMENT I 2,608,288 I 2,586,656 I 2,479,898 j 106,758 I 2,866,174 I 2,732,740 ! Recreation Administration (Staffing, Park Rangers) (b) 400,376 593,700 555,664 38,036 618,175 663,650 I Recreation Facilities ! (b) 449,066 454,490 448,980 5,510 445,550 464,700 i Special Events (b) 27,776 52,539 45,025 7,514 97,061 88,350 ! Pt Vicente Interpretive Center (PVIC) (b) 322,890 382,275 356,709 25,566 393,375 404,875: REACH I !bl 37,289 53,700 48,036 5,664 48,000 39,100 I SUBTOTAL RECREATION & PARKS _____ __,_ 1,237,396 1,536,704 1,454,414 i 82,290 1,602,161 1,660,675 NON-DEPARTMENTAL 0 0 0 0 500,000 o' I 4,360,600 106,700 89,800 241,100 4,798,200 2,301,200 200,100 209,800 609,100 1,307,600 69,400 4,697,200 1,317,900 661,300 219,400 389,300 0 150,000 2,737,900 671,100 474,500 90,200 413,400 39,900 1,689,100 0 4,469,600 108,900 91,700 246,200 4,916,400 2,349,500 204,300 214,200 621,900 1,335,100 70,900 4,795,900 1,345,600 675,200 224,000 397,500 0 150,000 2,792,300 685,200 484,500 92,100 422,100 40,700 1,724,600 0 4,581,300 111,300 93,700 251,600 5,037,900 2,401,200 208,800 218,900 635,600 1,364,500 72,500 4,901,500 1,375,200 690,100 228,900 406,200 0 150,000 2,850,400 700,300 495,200 94,100 431,400 41,600 1,762,600 0 4,695,800 113,900 95,900 257,400 5,163,000 2,456,400 213,600 223,900 650,200 1,395,900 74,200 5,014,200 1,406,800 706,000 234,200 415,500 0 150,000 2,912,500 716,400 506,600 96,300 441,300 42,600 1,803,200 0 TOTAL GENERAL FUND EXPENDITURES I 11,081210 1 18,645~79~:460,898 I 1.184,896 I 19,623,472 I 19,694,419 II 19,601,80011 20,181,10011 20,488,ooo u-21.118,400 I I ! GENERAL FUND NET BEFORE TRANSFERS : 5,840,547 l-4,976,506 6,209,959 1,233,4531 4,560,6521 5,040,211 11 5,754,74011 5,905,420116.532,89011 6,816,790 6 - 1 6 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) 2 ACTUAL VARIANCE ~ FY10~11 FY11-12 PAGES I GENERAL FUND TRANSFER DETAIL GENERAL FUND TRANSFERS IN: From Measure A Maint 160,641 100,000 100,000 ! 0 From Public Safety Grants fund 100,000 100,000 100,000 0 From Waste Reduction 12,000 12,000 0 (12,000) From Employee Benefits 0 340,000 340,000 0 From Utility Undergrounding -fund eliminated 275,988 0 0 0 From Roadway Beautification -fund eliminated 102,390 0 01 0 Total General Fund Transfers In I 651,019 1 552,000 I 540,000 I c12.oooi1 GENERAL FUND TRANSFERS OUT: To CIPfund 6,613,778 5,351,541 5,472,272 (120,731) To Street Maintenance Fund 0 0 0 0 ToCDBG 36,970 0 0 0 To Improvement Authority Portuguese Bend 101,000 60,000 60,000 0 To Improvement Authority Abalone Cove 0 0 0 0 To Abalone Cove Sewer District 32,700 10,700 10,700 0 To Habitat Restoration 109,900 90,000 90,000: 0 To Subregion 1 Maintenance Fund 70,000 60,000 60,000 0 Total General Fund Transfers Out II 6,964,34~ 11 5,572,241 II 5,692,97211 (120,731)1 Net Activity I (472,782)11 (43,7~5>11 1,05~,98711 1,100,722 I REVISED BUDGET FY12-13 !~J~il~j:; :v~~i .".?." :-::~::·::'.:'.·~·:···· 100,000 105,000 105,000 ! 100,000 100,000 100,000 • 12,000 5,000 5,100 i 0 0 0 0 0 0 i 0 0 O• 212.000 I - 210,00QI[ 210.10011 6,451,668 5,553,114 5,830,400 I 0 0 0 0 0 O! 106,000 70,000 70,000 0 20,000 20,000 10,700 50,700 50,700 90,000 150,000 163,000 65,000 61,000 61,000 6,723,3681 5;904,81411 6.195,100 II (1,950, 716)1 (654,543)11 (230,260)11 EXHIBIT B MODEL MODEi. 'i.66~[ FY1EM:t rl17h18. ··:·'.'."' . ······.· ··.·.···· FY15-16 105,000 105,000 105,000 100,000 100,000 100,000 5,200 5,300 5,400 0 0 0 0 0 0 0 0 0 210.20011 210,30011 210,400 5,609,300 5,693,700 6,083,900 0 0 100,000 0 0 0 70,000 70,000 70,000 20,000 20,000 20,000 50,700 50,700 50,700 177,000 191,000 206,000 61,000 61,000 61,000 5,988,ooo 11 6,086,40011 6,591,600 121.62011 656,790 II 435,590 6 - 1 7 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) PA.GE.6 GENERAL FUND SUMMARY Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance Less Non-Spendable, Restricted, Committed & Assigned: Long-Term Advance to RDA (Principal Only) Continuing Appropriations Inventory & Other Unassigned Fund Balance (Available for Spending) Policy Reserve Threshold (50% of Expenditures) Excess/(Deficient) General Fund Reserves ACTUAL FY10-11 19,373,042 22,921,818 (17,081,270) 651,019 (6,964,348) 18,900,260 18,900,260 18,900,260 I 23,622,300 23,610,851 T I (18,645,794) (17.460,898) I 552,000 540,000 I I (5,572,241) (5,692,912> I 18,856,525 19,957 ,2471 I 0 48,557 1,184,896 (12,000) (120,731) 1,100,722 i!2 0 REVISED BUDGET FY12-13 19,957,247 24,184,124 (19,623,472) 212,000 (6, 723,368) 18,006,531 PRO~~~· f M&~~~ .•• rl1?~1'1J ? ~W1s 18,006,531 17,351,988 24,7S4,690 25,362,540 (19,694,419) (19,607,800) 210,000 210,100 (5,904,814) (6,195,100) EXHIBITS MODEL FY15-16 ~~!~" \[c~rJi~~> 17,121,728 I 17,249,348 17,906,138 26,092,520 27,020,890 27,935,190 (20,187,100) (20,488,000) (21, 118,400) 210,200 210,300 210,400 (5,988,000) (6,086,400) (6,591,600) 17,351,988 11,121,128 I 17,249,348 17,906,138 18,341,728 6,742,778 6,742,778 6,742,778 688,502 688,502 688,502 61,528 61,528 61,528 9,756,54011 10,413,33011 10,848,920 ,559,200 289,720 6 - 1 8 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS PAGE? BEAUTIFICATION FUND DETAIL (Fund-212) Revenues Beautification revenue Interest earnings Total Revenue Expenditures Personnel services Beautification Grants Operations & maintenance Total Expenditures BEAUTIFICATION FUND NET BEFORE TRANSFERS Transfers Out To GIP fund -Street Improvements (median projects) i tliJ~~~; ~~;; ACTUAL FY1M2 .J~R~~~~ ·:FY11~12"''.' ·.·.·::·::::::<:::: REVISED BUDGET FY12-13 PROPOSED FY13C14 ~~~~t} ~~~; . ··.·.·.;;.· .MODEL FY16-17 296,ooo I o i o I o I 132,ooo I o I o I o I o ; (hi I 4,254 I 281,600, 311,134 I 30,1341 2.060 I -1.530 I 1.430 I 820 I o 1 300.25411 281,60011 311.134lr-=30.1341 134,0001 1,53011 1,4301i---a2011 01r MODEL FY17-18 0 0 0 15,800 i ·+·-------15,276 15,723 77 15,500 0 0 0 0 0 0 150,000 0 150,000 0 0 0 0 oi ___ o 61,100 4,500 ! 4,500 0 0 0 0 0 0 I 76,37611 110.300 II 20,22311· 011 011 011 o II 0 i I 223,878 II 111.300 II 291,51111 1,53011 1,43011 82011 0 1r 0 I __j I 01 500,500 i 26,810 473,690 473,690 0 0 0 o• 0 To Street Maintenance fund (median maintenance) I (b) 165,200 116,000 i 116,000 o I 193,000 214,000 218,500 84,031 O: 0 Total Transfers Out 11 165,200 II 616.500 II 142,810 II 473,690 I 666,690 I 214,00011 218,500 II 84,031 11 o II 0 I ! BEAUTIFICATION FUND SUMMARY I ! ! i Beginning Fund Balance 858,102 I 916,780 I 916,780 0 1,065,481 512,751 300,281 83,211 OJ 0 I Plus: Revenues 300,254 281,600 I 311,734 30,134 134,060 1,530 1,430 820 O; 0 I 1 Less: Expenditures (76,376) (170,300)1 (20,223) 150,077 (20,100) 0 0 0 0 I 0 i I Less: Transfers Out (165,200) (616,500)1 (142,810) 473,690 (666,690) (214,000) (218,500) (84,031) 01 0 I i Ending Fund Balance II 916,18011 411,58011 1.065,481 11 653,901 I 512.151 I 300,28111 83,211 II on 01r--0 I I I I I 6 - 1 9 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITB I g ACT~A!. . < ~Q~ET ACTUAL VARIANCE REVISED .. PROPOSED MODEL ·Pv~~~,~~.; .. ~~~i· MODEL I ~ FY104f •·. f:Y1f"12 FY11-12 F¥11ifa? BUDGET FY13-14 FY14-15 fY17-18 ' ~ FY12-13 : :· ·.:.~~;::: .. ;,:. ·.-'.;.;~· I PAGEB -. I . · ... -. ·-··-- ~- CIP FUND DETAIL (Fund-330} I --- Revenues i Capital Grants & Contributions 5,675 4,047,567 139,339 (3,908,228) 4,085,167 1,200,000 0 3,047,600 500,000 1,600,000 Interest earnings I (hi 32,485 28,600 36,780 8,180 42,300 •20,400 i 33,100 44,800 200,900 366,700 Total GIP Fund Revenue I 38,159 H 4,076,167 0 176,119 0 (3,900,048)1 4,127,467 I 1.no,400 11 33.10011 3,092,400 II 100,900 I 1,966,700 --- I Expenditures I ; Total CIP Fund Expenditures (see Exhibit C) I 2,385,30611 5,336,05311 2,939,43111 2,396,622 I 13,476,429 I 8,029,975 II 9,880,000 II 6,495,300 II 5,o55.ooo 1 12,460,000 I I GIP FUND NET BEFORE TRANSFERS I I (2,347, 147)11 - (1,259,886)11 (2,763,312)11 (1,503,426)1 (9,348,962)1 (6,809,575)11 (9,846,900)11 (3,402,900)11 (4,354,100)1 (10,493,300) Transfers In From General fund 6,613,778 5,351,541 5,472,272 120,731 6,451,668 5,553,114 l 5,830,400 5,609,300 5,693,700 6,083,900 From Street Maintenance fund 4,419 52,661 52,661 0 0 QI 0 0 0 0 From Waste Reduction fund 41,000 70,000 70,000 0 0 o, 0 0 0 0 From Measure R fund 9,868 992,212 628,212 (364,000) 564,000 0 1,000,000 0 1,000,000 500,000 From Measure A Capital/Maintenance fund 0 150,000 0 (150,000) 150,000 0 0 0 0 0 From Proposition C fund 132,993 1,546,927 240,000 (1,306,927) 1,306,927 70,QQQ I 0 70,000 0 200,000 From Proposition A fund 0 0 0 0 0 0 48,000 0 0 0 From Building Replacement 0 145,000 30,517 (114,483) 0 0 0 0 0 0 From Bikeways fund 26,973 25,000 0 (25,000) 61,015 26,586 26,600 26,600 26,600 26,600 From Quimby Fund 0 0 0 0 0 993,QQQ I 300,000 0 0 0 From EET fund 86,300 0 0 0 50,000 300,000 I 250,000 50,000 0 0 From Beautification fund 0 500,500 26,810 (473,690) 473,690 0' 0 0 0 0 Total Transfers In I 6,915,331 11 8,833,84111 6,520,47211 (2,313,369)1 9.051,300 I 6,942.100 II 7,455.ooo 11 5,755,900 II 6,120.300 I 6,810,500 I I ~ Transfers Out 0 0 0 o I 8,293,0091 o: 0 0 0 610,000 Total Transfers Out I 011 o II 011 o I 8,293,009 I o II o II 011 01 610,000 i GIP FUND SUMMARY I I ' I Beginning Fund Balance 7,081,596 11,649,780 11,649,780 0 15,406,940 6,822,269 : 6,955,394 4,563,494 6,916,494 9,282,694 I Plus: Revenues 38,159 4,076,167 176,119 (3,900,048) 4,127,467 1,220,400 33,100 3,092,400 700,900 1,966,700 Less: Expenditures (2,385,306) (5,336,053) (2,939,431) 2,396,622 (13,476,429) (8,029,975) (9,880,000) (6,495,300) (5,055,000) (12,460,000) --- I --- Plus: Transfers In 6,915,331 8,833,841 6,520,472 (2,313,369) 9,057,300 6,942,700 i 7,455,000 5,755,900 6,720,300 6,810,500 ! Less: Transfers Out 0 0 0 0 (8,293,009) 0 0 0 0 (610,000) --~ Fund Balance I 11,649.180 II 19,223,73511 15,406,940 II (3.816,795>1 6,822,269 I 6,955,39411 4,563,49411 6,916,49411 9,282,694 I 4,989,894 Minimum Emergency Projects Reserve 3,000,000 3,ooo.ooo i I 3,000,000 3,000,000: 3,000,000 3,000,000 3,000,000 3,000,000 Excess Reserve for Future Projects : I 8,649,180 II II 12,406,940 II I 3,822,269 I 3,955,39411 1,563.494 II 3,916,49411 6,282,694 I 1,989,894 ! I 6 - 2 0 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS ii~: /;;~~~¥[> REVISED ·.·.·\'.·;_;::-::::::~:>.:·:<<<·>:-:·:-:··· :-.. ·: ... .-:.·, .... ·.-- a: ACTUAL VARIANCE i~~~f:~\ /~~~~ MODEL MODEL/ :<MODEL E BUDGET " t=Y10~11 FY11-12 FY15-16 f'v16.11> !'Yjfos :0 FY12-13 ·.::.::::::::: >':<:':'.'/::·:·:··: .... PAGE9 l I I i ---- EQUIPMENT REPLACEMENT FUND DETAIL {Fund· .! §fill I ~--- Revenues lnterfund charges (b) 59,100 480,000 480,000 0 568,600 7S1,300 746,700. 762,400 779,200 797,100 Miscellaneous revenues 10,100 0 0 0 0 0 0 0 0 0 Interest earnings (h) 11,404 8,600 8,244 (356) 8,700 5,300 8,600 18,300 55,700 79,500 Total Revenue I 80,60411 488,600 II 488,24411 (356JI 577,300 I 736,60011 155.300 II 180,100 II 834,900 I 876,600 I Expenses ! Vehicles and vehicle maintenance (b) 68,091 39,500 67,120 (27,620) 97,000 27,000 27,600 28,200 28,800 29,500 Computer equipment and maintenance (b) 113,068 400,211 317,485 82,726 1,226,100 556,900 568,600 580,500 593,300 606,900 Furniture and equipment maintenance (b) 126,511 85,200 119,427 (34,227) 128,000 110,000 112,300 114,700 117,200 119,900 Total Expenses I 301.61011 524,911 II 504,03211 20,8791 1,451.100 I 693,900 II 108,50011 123,400 II 139,300 I 756,300 I EQUIPMENT REPLACEMENT FUND NET BEFORE I (227,066)11 (36,311)11 (15,788)11 20,5231 (873,800)1 42.70011 46,80011 57.30011 95.600 I TRANSFERS 120,300 I I Transfers In • AQMD I fund 214 0 0 0 o I 60,000 0 0 0 0 0 Total Transfers In I o II o II 011 o I 60,000 I 011 o II o II 01 0 I Transfers Out 0 0 0 o I o I 0 0 0 0 0 Total Transfers Out I o II 011 011 o I o I on o II on 01 0 I l EQUIPMENT REPLACEMENT NET ASSET I i Beginning Net Assets 2,818,448 2,601,030 2,601,030 I 0 2,584,090 1,770,290 1,812,990 1,859,790 1,917,090 2,012,690 Plus: Revenues 80,604 488,600 488,244 (356) 577,300 736,600 755,300 780,700 834,900 876,600 Less: Expenses (307,670) (524,911) (504,032) 20,879 (1,451,100) (693,900) (708,500) (723,400) (739,300) (756,300) Plus: Transfers In 0 0 0 0 60,000 0 0 0 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 (lncrease)/Decrease in Capital Assets 9,648 0 (1,152) (1,152) 0 Unrestricted Net Assets (Spendable) I 2.601.030 II 2,564,71911 2,584,090 II 19,311 I 1.110.290 I 1,812.990 II 1,859,790 II 1.911.090 II 2.012.690 I 2,132,990 Invested In Capital Assets 253,698 254,850 Total Net Assets Per Financial Statements I 2,854,7281 I 2.838,940 I i 6 - 2 1 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS i PAGE10 ACTUAL FY10-11 ~~r:·, E-~II~~) ;;t;rii~~;i: . . -,_·.··:·>::.'·::::: . .:::::::·:::>:·:-.···· REVISED BUDGET FY12-13 p~~f~~~'~':f~~~1;•.· MODEL FY15-16 MODEL Mbti~t\ FY16-17 .·.•. f¥ifm~) BUILDING REPLACEMENT FUND DETAIL (Fund-686) Revenues ---:---========:!============J:::====---t------J-------f-------t------;__-----i----_J Grant Revenue -156,094 : o J o J o I o I o J o J o I o Interest earnings Total Revenue Expenses Professional Services Building Improvements Total Expenses BUILDING REPLACEMENT FUND NET BEFORE TRANSFERS Transfers In From General fund Total Transfers In Transfers Out -CIP Total Transfers Out BUILDING REPLACEMENT NET ASSET SUMMARY: Beginning Net Assets Plus: Revenues Less: Expenses Plus: Transfers In Less: Transfers Out Ending Net Assets 0 !hl I 4,226 i 3.200 I 2,956 I (24411 4.100 I -2,800 I 4,500 I 9,300 i 21.800 38,900 I 160,3~CUI 3,20011 2,956 II .. .. c244>1 4,1001 2.80011 4,50011 9,30011 21,800 I 38,900 63,313 i o I o I o I o I o I o I o ! o 0 148.001 I 21,208 I 20,755 I 453 I 5.479 I o I o I o I o 0 ~;3!~1 21.20811 20,155 JC 453 I 5.47~ I o 11 o 11 o 11 o I 0 (17, (1,379) ? 0 ,300 38,900 I OI OI OI OI OI OI OI OI 0 0 011 011 01~ 01 01 011 on on 01 0 01 145,ooo I 30,517 I 114.483 I o I 01 01 01 0 0 I o 11 145,ooo 11 30,517 II 114,483 I o I 011 011 o 11 01 0 I I I 1,042,318 991,322 991,322 0 943,006 941,627 944,427 948,927 958,227 986,027 160,320 3,200 2,956 (244) 4,100 2,800 4,500 9,300 I 27,800 38,900 (211,315) (21,208) (20,755) 453 (5.479jJ OI OI 01 0 0 I 0 0 0 0 01 OJ OJ of 0 0 ! 01 (145,000) (30,517) 114.483 I o I OI OI 01 0 0 ~991,322 lf-----828,314 JI 943,0CJ6 n 114,6921-941,627.----944,427 II 948,927 II 958,227 lf--986,02711 1,024,927 I I I I 6 - 2 2 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) EXHIBIT B ACTUAi-•• / ~~~i~~~ REVISED ·• ·. --.~·.··-'~-<">·-.. ·-:_,.: ·:····:·· ·.·--:-··. g ~~1Ii1~·· au.o~ET BUDGET PROPOSED \w1~'~';;: ·~1~~i MODEL MODEL ~ ..•. FY1M2 FY11-12. \ t@~hiif FY12-13 FY13-14 FY16-17 FY17-18 ~ . :::{<i\ . PAGEFt1 I -+--- ------ EMPLOYEE BENEFITS FUND DETAIL __ ., (Fund-6851 -- ---- Revenues ' lnterfund Charge for Services 1,795,347 1,821,500 : 1,821,500 0 1,896,300 1,993,425 2,077,622 2,198,345 2,323,793 2,453,643 Interest earnings & misc revenue (h) 812 1,720 i 28,837 27,117 240 90 140 300 890 1,240 Total Revenue I 1,796,15911 1.823,220 II 1,850,33711 27,1171 -----~ 1,896,540 I 1,993,51511 2,077,76211 2,198,64511 2,324,683 I 2,454,883 I --- Expenses Retirement (PERS)-Employer Contribution (b)+ 770,540 768,400 735,366 33,034 774,800 797,400 856,822 952,345 1,050,693 1,151,543 Defined Cont. Ret. Health Care Accounts (b) 73,465 74,300 i 75,567 (1,267) 78,100 80,600 82,300 84;000 85,800 ' 87,800 Insurance -Employee Health (b) 702,478 718,600 ' 749,899 (31,299) 840,500 888,100 906,800 925,800 946,200 968,000 FICA/Medicare (b) 90,917 77,100 87,733 (10,633) 92,100 90,625 92,500 94,400 96,500 98,700 Performance Incentive Program 48,678 117,784 121,707 (3,923) 60,900 0 0 0 0 0 Education Reimbursement (b) 685 800 500 300 800 800 800 800 800 800 Deferred Comp Match 0 15,000 15,000 0 15,000 15,000 15,000 15,000 15,000 15,000 Worker Compensation Insurance (b) 17,991 98,000 84,173 13,827 95,000 120,900 123,400 126,000 128,800 131,800 Total Expenses I 1,704,75511 1,869,98411 1,869,945 II 39 I 1,951.200 I 1,993,42511 2,077,62211 2,198,34511 2,323,793 I 2,453,643 I I EMPLOYEE BENEFITS FUND NET BEFORE I 91,40311 (46,764)11 (19,608)11 27,1561 (60,660)1 9011 14011 30011 890 I TRANSFERS 1,240 I I 0 0 0 o I O I 0 0 0 0 0 Total Transfer In 01 01 o I 01 01 on 011 011 01 0 I I Fund Transfer Out -GF 0 340,000 340,000 o I o I 0 0 0 0 0 - Total Transfer Out I 011 340.000 II 340.00011 o I o I o II 011 o II o I 0 EMPLOYEE BENEFITS NET ASSET SUMMARY: Beginning Net Assets 358,947 450,350 450,350 0 90,742 30,082 30,172 30,312 30,612 31,502 Plus: Revenues 1,796,159 1,823,220 1,850,337 27,117 1,896,540 1,993,515 2,077,762 2,198,645 2,324,683 2,454,883 Less: Expenses (1,704,755) (1,869,984) (1,869,945) 39 (1,957,200) (1,993,425) (2,077,622) (2,198,345) (2,323,793) (2,453,643) - -------- Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 ------ -- Less: Transfers Out 0 (340,000) (340,000) 0 0 0 0 0 0 0 -·-- Ending Net Assets I --45o.3so 11 63,58611 90,74211 27,156 I 30,082 I 30,17211 30,31211 30,61211 31,502 I 32,742 ------I 6 - 2 3 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B a: Acty4 > ~gp§~i> · ACTUAL VARIANCE/ REVISED PROPOSED MODEL Maoel. Md[)f;L MODEL ~ BUDGET : FY11pj1•••••••·. ·••••• ;fX1J~i~······· FY11-12 FY11".fi) FY12-13 ····•>F¥13-14 FY14-15 FY15~1!f D&"i~•17 FY11~18 ' .. . PAGE 12 . /§; ! ' I I i I ·- STREET MAINT. FUND DETAIL (Fund-202! ' i .. ·-· ' --r-Revenues Highway Users Tax : 729,801 694,200 621,337 I (72,863) 620,542 651,640 652,000 ! 652,000 652,000 652,000 Highway Users Excise Tax (formerly Proposition 42 I I .. ! I revenue) i 412,088 435,600 585,288: 149,688 415,277 616,055 : 616,000 616,000 616,000 616,000 Sidewalk repair (a) 0 14,000 2,500 i (11,500) 14,000 4,000: 4,100 4,200 4,300 4,400 Miscellaneous revenues (a) 18,109 14,000 13,860 (140) 14,000 20,000 20,400 20,800 21,200 21,600 Interest earnings !hl I 1,347 3,010 2,402 (608) 3,160 2,730 4,730 10,280 27,200 28,550 Total Street Maintenance Fund Revenue : I 1,161,34511 1,160,81011 1,225,38711 64,577 I 1,066,979 I 1,294,425 II 1.291.230 II 1.303,28011 1.320.100 I 1,322,550 : Expenditures ! Street Maintenance -Pavement Management (b) 518,614 566,400 525,725 40,675 526,400 552,400 ' 564,000 575,800 588,500 602,000 Street Maintenance -Non-Pavement (b) 1,370,723 1,675,299 1,376,572 298,727 1,606,919 1,635,279 1,669,600 1,704,700 1,742,200 1,782,300 Traffic signal maintenance I (b) 65,596 112,000 73,767 38,233 203,000 109,000 111,300 113,600 116,100 118,800 Total Street Maintenance Fund Expenditures ; I 1,954,93411 2,353,69911 1,976,06411 377,635 I 2,336,319 I 2,296,67911 2,344,900 II 2.394,10011 2,446,800 I 2,503,100 I STREET MAINTENANCE FUND NET BEFORE I I (793,589)11 (1,192,889)11 (750,677)11 442,2121 (1,269,340)1 (1,002,254)11 (1,047,670)11 (1,090,820)11 (1, 126, 100)1 TRANSFERS i (1, 180,550) Street Maintenance Fund Transfers In i From Prop C Fund (PB Road Maint) 500,300 516,400 516,400 0 490,000 522,000 533,000 544,200 556,200 569,000 From General fund I 0 0 0 0 0 0 0 0 0 100,000 From 1972 Act ' 204,000 200,000 200,000 0 200,000 190,000 190,000 190,000 190,000 190,000 From 1911 Act 67,633 202,000 72,688 (129,312) 203,000 99,000 101,100 103,200 105,500 107,900 From Beautification fund 165,200 116,000 116,000 ' 0 193,000 214,000 218,500 84,031 0 0 From Waste Reduction ' 0 40,000 40,000 \ 0 40,000 57,000 58,200 59,400 60,700 62,100 Total Transfers In I 937,13311 1,014,400 II 945,08811 (129,312)1 1.126,000 I 1.082,000 II 1.100.80011 980,831 II 912,400 I 1,029,000 Street Maintenance Fund Transfers Out To CIP Fund 4,419 52,661 52,661 0 0 0 0 0 0 0 Total Transfers Out : I 4,41911 52,661 11 52.661 II o I o I o II o II o II 01 0 STREET MAINTENANCE FUND SUMMARY I i ~inning Fund Balance ' 776,018 915,143 915,143 ! 0 1,056,893 913,553 i 993,299 1,046,429 936,440 722,740 Plus: Revenues I 1,161,345 1,160,810 1,225,387 64,577 1,066,979 1,294,425 1,297,230 1,303,280 1,320,700 1,322,550 i Less: Expenditures (1,954,934) (2,353,699) (1,976,064)' 377,635 (2,336,319) (2,296,679) (2,344,900) (2,394, 100) (2,446,800) (2,503,100) l Plus: Transfers In 937,133 1,074,400 945,088 ' (129,312) 1,126,000 1,082,000 1,100,800 980,831 I 912,400 1,029,000 --· ' ! Less: Transfers Out I (4,419) (52,661) (52,661) 0 0 Oi 01 0 0 0 -- i Ending Fund Balance i I 915,14311 743,99311 1,056,89311 312,900 I 913,553 I 993,29911 1,046,42911 936,440 II 122.1401 571,190 Reserve (1 year of Pavement Management Exp) 518,614 I 525,725 I 490,000 I 522,000 533,000 544,200 556,200 569,000 I Exeess/(Deficient) Reserve for Street Maintenance - ' I 396,52911 II 531,16811 I 423,553 I 471,29911 513,42911 392.240 II 166,540 I 2,190 I I I l I 6 - 2 4 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B PAGE 13 1972 ACT LANDSCAPE & LIGHTING FUND DETAIL (Fund 203) Revenues Property assessments Interest earnings Total Revenue Expendttures Operations & maintenance Total Expenditures "' i: ACTUAL . • ij;j~t[;;@ ) ~¢ti.JAL FY1Mt · ¢(#~~'.mff ffff.H•12 VARIANCE FY11-12 REVISED BUDGET FY12-13 lfJil0· MODl;I. FY14-15 MODEL . •Mdil~t'. } ~dbet. ~ FY15•16 ·. er1~~1v < FY#~1s I I l tel I 260,454 I 258,ooo I 258,813 I 813 I 258,ooo I 258,ooo I 263,200 I 268,500 I 273,900 279,400 (hi i 698 I 180 I 570 I 390 I 390 I 190 I 280 I 570 I 1,780 2,740 I 261,151u-----258,1801~9.38311 1.~--258,390 I 2se.rno 11 263.48011269,01011 215,68cfl 282,140 (b) 13,860 J 73,800 I 15,342 \ (1,542>1 73,ooo I 12,800 \ 74,300 75,900 I 11,600 79,400 ~I 13,80011 15.342 U <1.542>1 13,000 I 12.800 I[ 74,30011 75,90011 77,600 I 79,400 1972 ACTFUND NET BEFORE TRANSFERS I 247,291 II 184,380 II 184,041 II (339}j 185,390 I 185,390 II 189,180 II 193,170 II 198,080 I 202,740 Transfers In 01 01 01 OI OI OI OI OI 0 0 Total Transfers In I o 11 o 11--o 11 o I or o Ir---o 11 o 11 o I 0 Transfers Out To Street Maintenance fund 204,ooo I 200,000 I 200,000 I o I 200,000 I 190,ooo I 190,000 I 190,000 I 190,000 190,000 Total Transfers Out 1---· 204,00011200.0001~0;000 II ---or 200.oooi---rno.ooo II 190,000 II 190,000 II 190,0001 190,000 1972 ACT LANDSCAPE & LIGHTING FUND Beginning Fund Balance 50,745 I 94,036 I 94,036 I 0 78,077 63,467 58,857 58,031 T 61,201 I 69,287 I I Plus: Revenues 261.151 I 258,180 l 259,383 1,203 258,390 258,190 263,480 269,010 \ 215,680 \ 282,140 I Less: Expendttures (13,860) (73,800) (75,342)1 (1,542) (73,000) (72,800) (74,300) (75,900>1 (77,600)\ (79,400) I I Plus: Transfers In 0 0 0 0 0 0 0 01 01 0 Less: Transfers Out (204,000) (200,000) (200,000) 0 (200,000) (190,000) (190,000) (190,000)1 (190,000)1 (190,000) I I I Ending Fund Balance I 94,03611 78,41611 78,077 II (339)1 63,467 I 58,857 II 58,03711 61,20711 69,28711 82,027 I I I I 6 - 2 5 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS c: · ~f~t~l.;~~ Y~!~[. REVISED : >-,::-:.:::::.:·:·:· .. ::":::~) :: :::~~:~<::::-:-:-:.·.·.·.··~ ·Moo~i:· g ACTUAL BUDGET BUDGET p~~~~~ rx~i~r MODEL MODEL CJ FY10-11 FY11-12 FY15-16 FY16-17 FYitas ~ FY12-13 <:: PAGE·14 . { EL PRADO LIGHTING FUND DETAIL +- {Fund-209} Revenues Property assessments 1,906 i 1,900 1,973 73 1,900 • 1,900 1,900 1,900 i 1,900 1,900 Interest earnings (h) 56 i 70 49 (21) 80 50 90 190 i 600 880 Total Revenue I 1,962 II 1,97011 2,02211 52 I 1,980 I 1,950 II 1,990 II 2.090 II 2,5001 2,780 I Expenditures Light and Power (b) 0 300 0 300 300 300 300 300 300 300 Maintenance Services (b) 30 700 29 671 700 700 700 700 700 700 Total Expenditures I 30 II 1.00011 2911 9711 1.000 I 1.000 II 1.000 II 1.000 II 1.000 I 1,000 l I EL PRADO LIGHTING FUND NET BEFORE I 1,93211 97011 1,99311 1,023 I 980 I 95011 990 II 1.090 II 1,500 I 1,780 I I Transfers In 0 0 0 o I 0 I 0 0 0 0 0 Total Transfers In I 011 o II o II o I 01 on o II o II 01 0 I I Transfers Out 0 0 0 o I 0 I 0 0 0 0 0 Total Transfers Out I 011 o II o II o I o I 011 o II 0 II 01 0 EL PRADO LIGHTING FUND SUMMARY: Beginning Fund Balance 12,850 14,782 14,782 0 16,775 17,755 18,705 19,695' 20,785 22,285 Plus: Revenues 1,962 1,970 2,022 52 1,980 1,950 1,990 2,090 2,500 2,780 Less: Expenditures (30) (1,000) (29) 971 (1,000) (1,000) (1,000) (1,000) (1,000) (1,000) Plus: Transfers In 0 0 0 0 0 0 0 01 0 0 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 I Ending Fund Balance I 14,78211 15,752 II 16,77511 1,023 I 17,755 I 18,70511 19,695 II 20,78511 22,285 I 24,065 I I I I 6 - 2 6 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS PA<?615 CDBG FUND DETAIL !Fund-310) Revenues Grant income Total Revenue Expenditures I ~~~f· ~~~: l --------~-"~--------~-·-~-~ ~~i< ~~i~~;i REVISED BUDGET FY12·13 PROPOSED FY13-14 -·.~~~i~1;::~[······~~~;- ···.·.·.·.·:-:•:,:::-:::::::::::::·'., MODEL FY16-17 134,513 I 324,364 1 173,094 I (151,270)1 302,883 I 189,364 I 150,000 I 150,000 I 150,000 I 134.513 II 324,364 II 113,o94 lf--(1s1.210JI 302,883 I-f89,364 II 150,00011-150,00011 150,000 I MooeL FY17~18 150,000 150,000 Operations & maintenance 118,828 177,708 139,355 38,353 154,098 55,000 O O O O Capital outlay (ADA Projects) 52,655 76,656 76,184 472 148,785 91,918 150,000 150,000 150,000 150,000 Total Expendttures --------I 171,483 II 254,364 II 215,539 II 38,825 I 302,883 I 146,918 II 150,000 II 1.50,00011 150,000 I 150,000 I I CDBG FUND NET BEFORE TRANSFERS 11 (36.970)1,1 70.000 1,1 (42.445)1,1 (112.445)1 o 1 42,446 II o 1,1 o r== -o 11 o 1 Transfers In From General fund 36,970 I o I o I o I o I o I o I o I o 0 Total Transfers In I 36,970 11 o I olf---o I or o II o ii---o ll o I 0 Transfers Out To General fund (REACH) OI ol OI 01 OI OI OI OI O 0 Total Transfers Out I 0 II 0 II 01r---0 I 0 I -OJI 0 I an·-0 I 0 CDBG FUND SUMMARY: Beginning Fund Balance OI OI O[ 0 (42,446) (42,446) 0 0 0 0 Plus: Revenues 134,513 I 324,364 I 173,093 (151,271) 302,883 189,364 150,000 150,000 150,000 150,000 Less: Expenditures (171,483) (254,364) (215,539) 38,825 (302,883) (146,918) (150,000) (150,000) (150,000) (150,000) Plus: Transfers In 36,970 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 I on 10.000 II (42,446)11 (112,446)1 (42,446)1 o II 011 on 01i:=:= 0 l 6 - 2 7 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B I ~ ~it~~!; j~;;i~;f ACTUAL VARJA~~g REVISED '.~~QPOSED MODEL .• ;i~~~~··> ~~~i MOOEL I ~ FY11-12. FY11~µ) BUDGET fY1~~14 FY14-15 FY17-18 :;:·· :···· ·.·.··:···:·:,:.:;:::::.;"::;.~:::::::~:.: FY12-13 · .. PAGE16< I I I ;- 1911 ACT STREET LIGHTING FUND DETAIL (Fund-I .ill1 I Revenues -t Property assessments (a) 497,743 440,000 504,991 64,991 440,000 525,000 i 535,500 546,200 557,100 568,200 Interest earnings (h} 7,114 7,600 5,419 ' (2,181) 7,300 4,400 i 6,500 13,300 38,900 53,500 Total Revenue I 504,85711 441,600 II 510.41011 62,810 I 447,300 I 529,400 II 542.00011 559,500 II 596,ooo I 621,700 I I Expenditures Operations & maintenance (b) 423,696 444,400 419,984 24,416 445,900 532,500 456,900 466,500 476,800 487,800 Total Expenditures I 423,69611 444,400 II 419,98411 24,416 I 445,900 I 532,500 II 456,90011 466,50011 476.800 I 487,800 I 1911 ACT FUND NET BEFORE TRANSFERS I 81,16111 3,20011 90,42611 87,226 I 1,400 I (3,100)11 85,100 II 93,ooo 11 119,200 I 133,900 T I ! Transfers In 0 0 0 o I o I 0 0 0 0 0 Total Transfers In I 011 o II o II o I o I 011 o II o II o I 0 Transfers Out To Street Maintenance Fund (b) 67,633 202,000 72,688 129,312 203,000 99,000 101,100 103,200 105,500 107,900 Total Transfers Out I 67,63311 202.000 II 72,68811 129,312 I 203,000 I • 99,ooo II 101.10011 103.200 II 105.500 I 107,900 1911 ACT STREET LIGHTING FUND SUMMARY Beginning Fund Balance 1,639,118 1,652,646 1,652:646 I 0 1,670,384 1,468,784 1,366,684 1,350,684 1,340,484 1,354,184 Plus: Revenues 504,857 447,600 510,410 ! 62,810 447,300 529,400 542,000 559,500 596,000 621,700 Less: Expenditures (423,696) (444,400) (419,984)t 24,416 (445,900) (532,500) (456,900) (466,500) (476,800) (487,800) _ __j_ Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (67,633) (202,000) (72,688) 129,312 (203,000) (99,000) (101,100) (103,200) (105,500) (107,900) Ending Fund Balance I 1,652,64611 1,453,84611 1,670,38411 216,538 I 1,468,784 I 1,366,68411 1,350,68411 1,340,48411 1,354,184 I 1,380,184 I i I 6 - 2 8 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL· (BY FUND) EXHIBIT B ~Th!~;t ('If It~ > '. ~~~; VARIANce FY11-12 REVISED BUDGET FY12-13 f~Q~4'.)SED >)FY13~14 MODEL .FY14'15 MQO!;I±" ~mitSbk~ A'1$,j~( IDt1~~17 MODEL FY17·18 !PAGE 17 -.---I r·--'------1---+--------!---+-----t--I WASTE REDUCTION FUND DETAIL (Fund-213) Revenues Collection Fees (AB939) State income Misc revenue Interest earnings Total Revenue Expenditures Personnel services Operations & maintenance Total Expenditures WASTE REDUCTION FUND NET BEFORE Transfers In Total Transfers In WASTE REDUCTION FUND SUMMARY Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance -l tel I 210,870 155,705 201,034i 51,329 158,800 166,405 i 169,900 173,500 177,300 69,605 47,500 23,533 (23,967) 47,500 24.ooo I 24,000 24,000 24,000 9,072 0 01 0 0 01 0 0 0 thl I 990 970 1,042 ! 72 1,040 720 l 960 1,580 3,450 290,538 II 204,17511 231,609 II 27.4341 201,340 I 191,12511 194,86011 199,08011 204,75011 (b) 61,826 68,300 68,310 I (10) 68,600 70,300 71,800 73,300 74,900 . (b) r- j 92,771 l 21,079 98,800 105,300 97,773 113,850 114,050 100,900 103,000 I 159,59911 182,15011 161,0811J--21:069 I 182,650 I 169,1ocru 112.10011 116,300 u----iso.2001 1 -----.--------I I -i l ~ I 130,93911 22,02511 10,5281! · 48,503 I 24,690 I -22.02511 22.16011 22.180 lf-----24,550 I 1 I I o I o I ol o I o I o I o I o I o o 11 o I -o II o I --or-o 11 o I 011 o I I + l L _j_ (b) lo) I o I 40,000 I 40,ooo l o I 40,ooo I 57,ooo I 58,200 I 59,400 I 60,100 11 53,00011 122,00011 110.00011 12,000 t 52,0001---62.00011 63,3001~soo11 66,ooo I i-- I •• __L 230,495 308,434 308,434-+ 0 268,962 I 241,652 I 201,611 I 160,537 I 118,717 290,538 204,175 231,6~ 27,434 201,340 I 191.125 I 194,860 I 199,080 I 204,750 I I (159,599) (182,150) (161,0~ 21,069 I (182,650)1 (169,100)1 (172,700)1 (176,300)1 (180,200) I 0 0 0 o I o I OI OI 01 0 -t I (53,000)I (122,000)1 (110,0001+~-12.ooo I t52,oooi1 (62,000)1 (63,300)1 (64,600)1 (66,000) I 308,43411 208,45911 268.96211 60,5031 241,652 f 201,67111 160,53111 118,1111~r;2e11 181,400 24,000 0 3,050 208,450 76,600 107,700 184,300 24,150 0 0 5,400 0 62,100 67,500 77,267 208,450 (184,300) 0 (67,500) 33,917 + i -t I -----+-----+----+----i I I I 6 - 2 9 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS 0: . ACTUAL BUDGer <~mt~ :)~Y~!~ME REVISED PRd~6$[ij.{ '.J ij~~EL MODEL MODEL MODEl.i·• ~ BUDGET ~ FY10-11 FY11c12. FY12-13 ' Fi.#•14 p;ey1~15 FY15•16 FY16-17 FY1f21a. RAGE 18 ··:::-_:::'.·:·.:::_ :··:: I I ···········•·>><·<····· I I ! -~~-.-.- AIR QUALITY MANAGEMENT FUND DETAIL (Fund-I i .ill} I Revenues ) AB 2766 fees 47,067' 50,000 52,388 2,388 50,000 ·50,000 50,000 50.000 r 50,000 50,000 Interest earnings (h) 131 ; 260 190 (70) 490 270 440 910: 2,710 3,790 Total Revenue I 47,19811 50,260 II 52,57811 2,318 I 50,490 I 50,21011 50,440 II 50,91011 52,110 I 53,790 ! Expenditures ! Operations & maintenance 50,000 I 0 0 0 0 50,000 50,000 50,000 I 50,000 50,000 Total Expenditures I 50.000 II o II 011 o I o I 50,00011 50.000 I 50,00011 50.000 I 50,000 I I I ! AQMD FUND NET BEFORE TRANSFERS I (2,802)11 50.260 II 52,57811 2,318 I 50,490 I 210 II 440 II 91011 2,110 I 3,790 i To Equipment Replacement Fund (clean air vehicle I I purchases) o! 0 0 0 60,000 0 0 ol 0 0 Total Transfers Out I o II o II 011 01 60,000 I 011 o II o II 01 0 I I AIR QUALITY MANAGEMENT FUND DETAIL I : Beginning Fund Balance 51,408 ' 48,606 48,606 0 101,184 91,674 91,944 92,384 ! 93,294 96,004 Plus: Revenues 47,198 50,260 52,578 2,318 50,490 50,270 50,440 50,910 : 52,710 53,790 Less: Expenditures (50,000) 0 0 0 0 (50,000) (50,000) (50,000)1 (50,000) (50,000) Plus: Transfers In 0• 0 0 0 0 0 0 o~ 0 0 ! Less: Transfers Out 0 0 0 0 (60,000) 0 0 O! 0 0 Ending Fund Balance I 48,60611 98,86611 101,18411 2,3181 91,674 I 91.944 II 92,38411 93,29411 96,004 I 99,794 I I 6 - 3 0 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS "' . ACTIJAL BUDGET •· ACTO~t ] ;tifu~~;;~ REVISED PROPOSED . <~~~~~\ ~~~~ MODEL >.M.ODEL !:! BUDGET u f:j:1Q-11 FY11~12 F'di~i~? :: l#lf1~# . FY13-14 FY16~17 FY17-18 ~ FY12-13 RAG819 i PROPOSITION C {STREET/TRANSIT} FUND DETAIL I {Fund-2151 Revenues Proposition C -1 /2 cent-sales t~x revenue (d) 481,539 488,400 521,486 33,086 489,000 591,517 603,900 616,600 630,200 644,700 Other revenues 18,000 6,830 0 (6,830) 0 0 0 0 0 0 Interest earnings (h) 8,871 0 6,050 6,050 10 100 160 1,030 3,140 7,310 Total Revenue I 508,410 II 495,230 II 527,53611 32,306 I 489.010 I 591,61711 604,060 II 617,630 II 633,340 I 652,010 Expenditures 0 0 0 0 0 0 0 0 0 0 Total Expenditures I o II o II o II o I o I 011 o II 011 01 0 I I I PROPOSITION C FUND NET BEFORE TRANSFERS I 508,410 II 495,230 II 527,53611 32,306 I 489,010 I 591,61711 604,060 II 617,63011 633,3401 652,010 I I Transfers In 0 0 0 o I 0 0 0 0 0 0 Total Transfers In I 011 011 o II o I o I o II o II 011 01 0 Transfers Out To CIPfund 132,993 1,546,927 240,000 1,306,927 1,306,927 70,000 0 70,000 0 200,000 To Street Maintenance fund -PB Road Maintenance (b) 500,300 516,400 516,400 0 490,000 -522,000 533,000 544,200 556,200 569,000 Total Transfers Out I 633,293 II 2,063,32711 156,400 II 1,306,927 I 1,796,927 I 592.000 II 533,ooo II 614.20011 556,200 I 769,000 PROPOSITION C !STREET/TRANSIT) FUND SUMMARY: Beginning Fund Balance 1,695,557 1,570,674 1,570,674 0 1,341,810 33,893 33,510 104,570 108,000 185,140 Plus: Revenues 508,410 495,230 527,536 32,306 489,010 591,617 604,060 617,630 633,340 652,010 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 (633,293) (2,063,327) (756,400) 1,306,927 (1,796,927) (592,000) (533,000) (614,200) (556,200) (769,000) Ending Fund Balance I 1,570,67411 2,57711 1,341.810 II 1,339,233 I 33,893 I 33.510 II 104.51011 108,00011 185,140 I 68,150 I I I I 6 - 3 1 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) I ;;;~Ii~! ~~;: ACTUAL FY11-12 v~~~~· REVISED BUDGET FY12-13 PROPOSED FY13"14 MODEL FY14-15 MOd~t( · •.. MODEL . FY1S~1( ' FY16-17 EXHIBIT 8 MODE!- FY17~18 IPAGE2Q 2 I I I I u J --l PROPOSITION A !TRANSIT! FUND DETAIL (Fund- !lfil Revenues 578,859 I 586.200 I 626,794 ' 40,594 586,200 0 0 60,000 7~3.123 728,100 743,400 759,800 : 777,300 0 0 0 01 0 Proposition A-1/2 cent sales tax revenue I (d) I -· -·n-I -n.-n I ---·· -. I ·-·n. I n-·---I . ·-· ·--I . --· •n I . ·-· •n I . n·-n I .•• ·n-I Other revenues t:it>,UUU u1 Interest earnings (h) 340 180 242 62 490 590 1,580 4,160 16,510 I 28,770 Total Revenue 644,199 II 586,380 II 627,03611 40,656 I 646,690 713,7'i311 729,68011 747,56011 116.31011 806,070 i Expenditures Operations (PV Transit) (bl I 540,104 I 597,592 I 582,211 i 15,375 I 595,200 I 558,340 I 510,100 I 582,100 I 594,900, 608,600 Operations (MAX) 78,756 I o I o I o I o I o I o I o I o 0 Capital Outlay (Bus Shelter Improvements) (bl I o I o I o I o I 24,800 I 20,000 I 20,400 I 20,800 I 21,300 21,800 Total Expendttures I 618,860 II 597,592 II 582,21711 15,375 I 620,000 I 578,340 II 590,500 IJ602.9oon 616,200 I 630,400 I PROPOSITION A FUND NET BEFORE TRANSFERS I 25,339 JI 111,212>11 44,819 II 56,031 I 26,69Q I 135,373 II 139.18011 144,66611 160,110 I 175,670 Transfers In 0 0 0 ' 0 0 0 0 O 0 O Total Transfers In I 0 II 0 II O II 0 I 0 I 0 II 0 II 0 II 0 I 0 ------+ ' ' Transfers Out o I o I o I o I o I o I 48,000 l o I o 0 Total Transfers Out I on OJI 011-H 01 bl OJI 48,000f--ou-------01 0 PROPOSITION A (TRANSID FUND SUMMARY: l ---t--I 1cB~e-g~in-nc-in-g-=F,-un_d_B_a~la_n_ce-----------+--+--1-=o-=o-=.2-=54-:-+-----,-12""5"",6""0""3+--1~2=5~.603f O 170,422 197, 112 332,485 423,665 568,325 i I ~ 728,435 Plus: Revenues 644,199 586,380 627,036 i 40,656 646,690 713,713 729,680 747,560 776,310 806,070 ! Less: Expenditures (618,860) (597,592) (582,217)/ 15,375 (620,000) (578,340) (590,500) (602,900) (616,200) (630,400) l 1 Plus: Transfers In 0 0 Ol 0 0 0 0 0 0 i 0 -ot I 0 0 0 0 0 (48,000) 0 01 Less: Transfers Out 0 I I I I Ending Fund Balance 1 125,603 II 114.39111 110.4221r 56~--191.112~332,485 Jl'!23.s65 II 568,325 U-H 128,435 lr-so4.105 6 - 3 2 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) g ~ ACTUAt> •• ~U~~ti ( ;ACT!JAL i:Y10~1J'· 'Yf:Y.#£t~f &11-12 VARIANCE F'i'11-12 REVISED BUDGET FY12-13 \f'ROPQSED . F'(13-14 MODEL FY14-15 MooeL . ~ti~b FY1s•1ij ; ¢(1~•17 EXHIBIT B MODEL f:Y17-18 IPAGF2tft > I_ +----+--+---r-------i PUBLIC SAFETY GRANTS !Fund-2171 Revenues Grant Income-State . 100,0001 100,000 I 100,000 ! O l 100,000 T 100,000 I 100,000 I 100,000 I 100,000 100,000 Other revenues · ---+ 10,202 I 0 I 0 ! 0 I 0 I 0 ! 0 I 0 I 0 0 Interest earnings (hf 316 I 170 I 256 I 86 I 0 I 0 I 0 I 10 I 20 20 ITotalRevenue ·-" U 110,51711 100,17011 100,25611 86~ 100,000I 100,000ll 100,000ll 100,01011 100,0201 100,0201 Expenditures Equipment purchases Total Expenditures PUBLIC SAFETY GRANTS FUND NET BEFORE TRANSFERS Transfers In Total Transfers In Transfers Out To General fund Total Transfers Out PUBLIC SAFETY GRANTS FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance I ! 1 I i : ! ! 25,505 I o I o I o I 19,600 I o 0 0 0 0 r-25,505Jr--· 0 II 0 II 0 I ·n1,6Clb I 0 I 0 0 0 0 85,012 86 80,400 100,000 ,Q10 100,020 100,020 01 OI OI OI OI OI OI ol O 0 011 o 11 o 11 o I o I o 11 o 11 o 11 o I 0 100.000 I 100.000 I 100.000 I o I 100,000 I 1-00.000 I 100.000 I 100,000 I 100.000 100,000 I 100,00011 100.00011 100,00011 o I 100.ooQ I 100,00011 100.00011 100.00011 100.000 I 100,000 i 34,918 19,930 .j__ 19,930 ' 0 20,186 I 586 I 586 I 586 I 596 616 110,517 100,170 100,256 86 100,000 100.000 I 100.000 I 100.010 I 100,020 100,020 I I I (25,505) 0 0 0 (19,600) 01 01 01 0 0 0 0 0 0 0 OI 01 01 0 0 ! I I I (100,000) (100,000) (100,000) 0 (100,000) (100,000)1 1100,000>1 (100,000)1 (100,000) (100,000) I 19.9301r--20.10011 20.18611 861-586 I 586 II 586 II 59611 616 I 636 I I I I 6 - 3 3 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS 0: ~~rI i/~~ili~i, v~~~~~e REVISED '.:::~::::;{{::r~:;:~{:~:'.~~::::::::::::::::::~: MQDJ;:I.; ~ ACTUAL BUDGET \-it~s: < ~i~l MODEL MODEL ;t FY10-11 FY12-13 FY15-16 Fv16~17 .FY1.Ml'I PAGE 22 ·'· ·.·. t> ·.c :: ! f----~·~- Measure R -1/2 cent sales tax revenue ! (Fund-220} Revenues I Grant Income·-State (d) 358,897 i 364,600 387,409 22,809 364,600 443,637 453,000 462,500 472,700 483,600 Other revenues 6,000 0 0 0 0 0 0 0 0 0 Interest earnings (h) 1,886 0 2,597 2,597 10 580 3,030 910 16,160 1,780 Total Revenue I 366,78411 364,600 II 390,00611 25,4061 364.610 I 444,21711 456.o3o II 463,410 II 488,860 I 485,380 Expenditures 0 0 0 0 0 0 0 0 0 0 Total Expenditures I o II 011 o II o I o I o II o II 011 01 0 I I MEASURE R FUND NET BEFORE TRANSFERS I 366,78411 364,60011 390,006 II 25,4061 364,610 I 444,21711 456,o3o II 463,410 II 488,860 I 485,380 I I Transfers In 0 0 0 o I o I 0 0 0 0 0 Total Transfers In I 011 o II 011 01 o I on 011 o II 01 0 Transfers Out To CIPfund 9,868 992,212 628,212 364,000 564,000 0 1,000,000 0 1,000,000 500,000 Total Transfers Out I 9,86811 992,21211 628,21211 364,ooo I 564,ooo I 011 1.000.00011 o II 1.000.000 I 500,000 MEASURE R FUND SUMMARY: Beginning Fund Balance 273,216 630,132 630,132 0 391,926 192,536 636,753 92,783 556,193 45,053 Plus: Revenues 366,784 364,600 390,006 i 25,406 364,610 444,217 456,030 463,410 488,860 485,380 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 (9,868)1 (992,212) (628,212) 364,000 (564,000) 0 (1,000,000) 0 (1,000,000) (500,000) Ending Fund Balance I 630,13211 2.52011 391,926 II 389,406 I 192,536 I 636,75311 92,78311 556,19311 45,053 I 30,433 I I I I 6 - 3 4 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B "' ~itf'~l)~?\iltt~ REVISED ·~®~L ...... MODEL ·.· .·. .· ~ ... a6e:i.;.· g •·•·ACTIJAL BUDGET BUDGET PRO~.ED M()l;>i:.L " f:Y10-11 FY11-12 FY13,14· FY:~Af!!i FY15~16 FY16~17 :-::-···· .. ,.·.·.·.:-:·.·.· ::: FY12-13 .FY1l?HI ·.· ·-:···:··::.:::::::::::::~:-:::>:-:··-·.·.·, PAC9E·23 <r I HABITAT RESTORATION FUND DETAIL (NCCP} (Fund-2221 Revenues Other revenues 2,984. 0 23,683 23,683 0 0 0 0 0 0 Interest earnings (h) 1,007 i 1,300 753 (547) 1,130 540 820 1,720 5,470 8,520 Total Revenue I 3,99111 1.30011 24,43611 23,136 I 1.130 I 54011 820 II 1.120 II 5,4101 8,520 ! Expenditures Open Space Management, Maintenance & Monitoring 126,026 l (b) 133,000 156,452 (23,452) 131,000 158,620 162,000 165,400 169,000 172,900 Total Expenditures I 126,02611 133,ooo II 156,452 II (23,452)1 131,000 I 158.620 II 162.000 II 165,400 II 169,ooo 1 172,900 I HABITAT RESTORATION FUND NET BEFORE I (122,035)11 (131,700)11 (132,016)11 (316)1 (129,870)1 (158,080)11 (161, 180)11 (163,680)11 (163,530)1 TRANSFERS (164,380) Transfers In From General fund 109,900 90,000 90,000 0 90,000 150,000 163,000 177,000 191,000 206,000 Total Transfers In I 109,900 II 90.00011 90,000 II o I 90.000 I 150,000 II 163.ooo 11 m.ooo II 191.000 I 206,000 I Transfers Out 0 0 0 o I o I 0 0 0 0 0 Total Transfers Out I o II o II o II o I o I o II o II o II o I 0 HABITAT RESTORATION FUND SUMMARY: Beginning Fund Balance 275,193 I 263,058 263,058 0 221,042 181,172 173,092 174,912 188,232 215,702 Plus: Revenues 3,991 1,300 24,436 23,136 1,130 540 820 1,720 5,470 8,520 Less: Expenditures (126,026) (133,000) (156,452) (23,452) (131,000) (158,620) (162,000) (165,400) (169,000) (172,900) Plus: Transfers In 109,900 90,000 90,000 0 90,000 150,000 163,000 177,000 191,000 206,000 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 263,05811 221,35811 221,04211 (316)1 181,172 I 173,09211 174,91211 188,23211 215,702 I 257,322 Reserve for Future Maintenance 64,411 ' 74,696 84,969 95,253 105,754 116,891 130,577 146,130 Emergency Projects Reserve 50,000 ! 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Excess Reserve for Habitat (Spendable) I 148,647 II II 96,346 II I 46,203 I 27,83911 19,158 II 21,34111 35,125 I 61,192 6 - 3 5 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) PAGE24 SUBREGION 1 -MAINTENANCE FUND DETAIL i ·:11~xr•···~~~-ACTUAL·_ V~ii~&g FY11~12 fi11h~f REVISED BUDGET FY12-13 PRQPC)SED FY13-14 :,,~~) >~is~; MODEL FY16-17 EXHIBIT B MODEL F'\'17"18 1<Fund-223! ---+-----+-----+-----11------+----+-----l------+-----l Revenues Interest earnings Total Revenue Expenditures Operations & maintenance Total Expenditures SUBREGION 1 -MAINTENANCE FUND NET BEFORE TRANSFERS (hi I 3, 197 I 3,800 i 2,438 I (1,362)1 3,800 I 2,300 I 3,600 I 7,400 I 21,800 I 3,197 II 3,80011 2,438Jr-(1,36211 3,800 I 2,30011 3,60011 1,40011 21,800 I I I (bl I 11.110 I 80,000 I 64,886 I 15,114 I 10,000 I 11,000 I 12,500 I 74,ooo I 75,600 I 11,11011 80,0001i----s4,88611 15,1141 10,0001 tr,00011 12,50011 74,00011 75,6001 II II ~~.2 (66,200) l 1-h-ra-n-sf~e-rs~ln---fc-ro_m_G~e_n_e_ra~I =Fu-n-cd-------+1--+I --=70=-,o=oo"'o,.,l--760=-.o""o=o I 60,000 I o I 65,000 I 61,000 I 61,000 I 61,000 I 61,000 TotalTransfersln II 70,000ll 60,000ll 60,00011--01 65,000I 61,000U 61,000ll 61,000ll 61,000I T I Transfers Out 01 OI OI OI OI OI 01 OI 0 Total Transfers Out I o Ir---o 11 o 11 --01 o I o 11-·-o 11 o 11 o I SUBREGION 1 -MAINTENANCE FUND SUMMARY: T Beginning Fund Balance 773,920 776,007 776,007 0 773,559 772,359 764,659 756,759 151,159 I Plus: Revenues 3,197 3,800 2,438 (1,362) 3,800 2,300 3,600 7,400 21,800 I Less: Expenditures (71,110) (80,000) (64,88sf-15,114 (70,000) (71,000) (72,500) (74,000) (75,600) Plus: Transfers In 70,000 60,000 60,000 0 65,000 61,000 61,000 61,000 61,000 Less: Transfers Out 0 0 OI 0 0 0 0 0 0 30,000 30,000 77,300 77,300 0) 61,000 61,000 0 0 758,359 30,000 (77,300) 61,000 0 Ending Fund Balance I 776,007 U 759,807 II 773,559 II 13,752 I 772,359 I 764,659 II 756,759 II 751,159 II 758,359 II 772,059 Non-Spendable Endowment 750,000 750,000 1 750,000 750,000 750,000 750,000 750,000 750,000 Spendable Fund Balance I _II-26,007 II If 23,559 II =-r-----22,359 I 14,65!3_Jl ___ 6,759 II 1,159 II 8,359 II 22,059 I I I 6 - 3 6 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B -... :::.::< : :,.:.::~: :'.:::<:::::::::::~<:/>:-::::·· .. -_ --~ . -:"> REVISED Mop§t.C 3~8tj~ .. VARl,&,N(:$. P~QPOSED MODEL ~ ~Whl' \ ;0~ji~> ACTUAL BUDGET MODEL ;'t FY1M2 FY11•1Z\ FY12-13 fY1~·14 FY14-15 FY1s;;1~'. • f'Y16:4.7 FY17~18 PAGEZ5 ·>······· I ! I i I MEASURE A· CAPITAL (Fund-339} & I MAINTENANCE IFund-2241 FUNDS DETAIL Revenues I Grant income 0 250,000 160,641 (89,359) 250,000 170,516 i 105,000 I 105,000 105,000 105,000 Interest earnings (h) 83 170 70 (100) 170 0 01 0 0 0 Total Revenue I 8311 250,110 II 160,71111 (89,459)1 ----------250,110 I 170,51611 105.ooo 11 105.ooo II 105,ooo I 105,000 I I I Total Expenditures I 011 011 011 o I o I o II o II o II o I 0 I I l I I MEASURE A -CAPITAL & MAINTENANCE FUND NET I I 8311 250,17011 160,71111 (89,459)1 250.170 I 170,51611 105,00011 105,00011 105,000 I BEFORE TRANSFERS 1 105,000 I ! Transfers Out To General fund 160,641 100,000 100,000 0 100,000 105,000 105,ooo I 105,000 105,000 105,000 To CIP fund 0 150,000 0 150,000 150,000 0 01 0 0 0 Total Transfers Out I 160,64111 250,00011 100.000 II 150.000 I 250.000 I 105,ooo II 105.ooo II 105.ooo 11 105,ooo I 105,000 I MEASURE A (PARKS}· CAPITAL & MAINTENANCE l FUNDS SUMMARY: i Beginning Fund Balance 34,161 (126,397) (126,397) 0 (65,686) (65,516) 01 0 0 0 Plus: Revenues 83 250,170 160,711 (89,459) 250,170 170,516 105,000 ; 105,000 105,000 105,000 Less: Expenditures 0 0 0 0 0 0 0 i I 0 0 0 Plus: Transfers In 0 0 0 0 0 0 O; 0 0 0 Less: Transfers Out (160,641) (250,000) (100,000) 150,000 (250,000) (105,000) (105,000)i (105,000) (105,000) (105,000) Ending Fund Balance I (126,397)11 (126,227)11 (65,686)11 60,541 I (65,516)1 011 o II 011 01 0 I I I I I 6 - 3 7 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B :-:·>'-:···:-:.>: :-:-:-:· ~.::~·:·:-:· .·:· · .. REVISED · ~~~!~~~ll~ >I!;~ · .. "· ·· .. ·''" ·. 0: ACTUAL ~~r~~ i~i~ti>< ·y~~~~;e MODEL Mooei:.· .. MOOEL g BUDGET u Fv10-11 FY15-16 F'(1sc17 . f:Yfr;;111· :t FY12-13 PAGE 26 ····· '? ABALONE COVE SEWER DISTRICT FUND DETAIL (Fund-225) Revenues Property Assessments (a) 49,432 46,600 52,948 6,348 46,600 54,000 55,080 56,180 57,300 58,450 Sewer use fee 0 0 1,217 1,217 0 0 0 0 0 0 Interest earnings (h) 1,443 260 289 29 100 80 120 240 620 690 Total Revenue I 50,87511 46,860 II 54,454 II 7,5941 46,100 I 54,080 II 55,20011 56,420 II 57,920 I 59,140 Expenditures Maintenance Services (b) 15,549 114,500 102,478 12,022 57,800 86,000 87,800 89,600 91,600 93,700 Personnel & Professional services (b) 29,691 19,300 20,082 (782) 12,100 19,600 20,000 20,400 20,800 21,300 Total Expenditures I 45,240 II 133,800 II 122.560 II 11.240 I 69.900 I 105,600 II 101.800 II 110.00011 112,400 I 115,000 I I ABALONE COVE SEWER DISTRICT FUND NET I 5,63611 (86,940)11 (68,106)11 18,8341 (23,200)1 (51,520)11 (52,600)11 (53,580)11 (54,480)1 BEFORE TRANSFERS (55,860) Fund Tran~fer In From General Fund 32,700 10,700 10,700 0 10,700 50,700 50,700 50,700 50,700 50,700 Total Transfer In I 32.100 II 10,10011 10.10011 o I 10.100 I 50,100 II 50.100 II 50,10011 50,100 I 50,700 I Fund Transfer Out 0 0 0 o I 0 0 0 0 0 0 Total Transfer Out I 011 011 o II o I o I 011 011 o II o I 0 ABALONE COVE SEWER DISTRICT FUND Beginning Fund Balance 58,342 96,678 96,678 0 39,272 26,772 25,952 24,052 21,172 17,392 Plus: Revenues 50,875 46,860 54,454 7,594 46,700 54,080 55,200 56,420 57,920 59,140 Less: Expenditures (45,240) (133,800) (122,560) 11,240 (69,900) (105,600) (107,800) (110,000) (112,400) (115,000) Plus: Transfer In 32,700 10,700 10,700 0 10,700 50,700 50,700 50,700 50,700 50,700 Less: Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 96,67811 20,438 II 39,27211 18,834 I 26,772 I 25,952 II 24,05211 21,11211 17,3921 12,232 I I I I 6 - 3 8 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) EXHIBIT B PAGE27 DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND DETAIL (Fund- ml Revenues ACTUAL FY10-11 BUDGET FY11-12 . --.-' .·.-.-.-.-.-.-... ~.·..-.-.. ·.·,·.-.~.-.· .. ·' -. ····~~~tl~~;1 ;!1~~~~ REVISED BUDGET FY12-13 PRoi>Ose'oi lP..ooEL FY#{( .J#,4-15 I MODEL FY15·16 I MODEL: }~ci%~U rn6'1f ·1#1i~i~ Interest earnings (h) 792 : 920 534 (386) 790 480 760 1,580 4,710 6,590 Total Revenue I 792 II 92011 534 II (386JI 790 I 480 II 760 II 1,580 II 4,710 I 6,590 Expenditures Capital Outlay -Park & Recreation Total Expendttures DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND NET BEFORE i 20.000 ( 25,ooo I 25,000 I o I o I o I o I o I o 0 I 20.000 11 25.ooo 1i---2s.ooo 11 o I o I o I Ho II o 11 o I 0 lr 790 ___ II II Fund Transfer In I 0 i 0 0 · 0 0 0 0 0 0 0 Total Transfer In I 0 II O II 0 II 0 I 0 I 0 II 0 II O II 0 I O Fund Transfer Out Total Transfer Out DR. ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfer In Less: Transfers Out Ending Fund Balance oj al al al al 01 al al o 0 I on 01r _____ o_11__ 01 mot on 01r---011 01 0 i 202,156 i 182,948 182,948 0 158,482 159,272 159,752 160,512 162,092 166,802 I 792 I 920 534 (386) 790 480 760 1,580 4,710 6,590 I -·-··-- (20,000)1 (25,000) (25,000) 0 0 0 0 0 0 0 I 01 0 0 0 0 0 0 0 0 0 L- 01 0 0 0 0 0 0 0 0 0 I 182,948 II 158,868 II 158,482 n (386ll 159.2121 159,752-11 160.512 n 162.092 n--rns;eo21 173,392 T 6 - 3 9 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT 8 PAGB28 DONOR RESTRICTED CONTRIBUTIONS FUND DETAIL· (Fund 228) Revenues Restricted Donations Interest earnings Total Revenue Expenditures Capital Outlay Total Expenditures DONOR RESTRICTED CONTRIBUTIONS FUND NET BEFORE TRANSFERS Fund Transfer In Total Transfer In Transfer To CIP Total Tran sf er Out DONOR RESTRICTED CONTRIBUTIONS FUND SUMMARY: Beginning Fund Balance Plus: Revenues Less: Expenditures Plus: Transfer In Less: Transfers Out Ending Fund Balance 13J.)J:)(;ET t=Y11~12 i ACTUAL • ~A~ttij¢g FY11~12···· ········>;~~Ht.~····· REVISED BUDGET FY12-13 p~~~~;D···••·.·····}~~~w; .. ·····~~i MODEL FY16-17 .. OI OI OI OI OI OI OI OI 0 (hl I 1,682 I 2.020 I 1,290 I (730ll 2,040 I 1,220 I 1,950 I 4,050 I 12.090 I 1,6821~0201~1.290J1 <130>1 2,040 I 1,22011 1,95011 4,o5o 11 12,090 I OI OI OI OI 01 OI 01 OI O 1---01r--Olin 011 01!-01 OIL on on 01 M@EL f'Y17~18 0 16,910 16,910 0 0 1,683...JI 2.020 II 1,29011 (730) 2,040 1.22011 1,95011 4,050 12,0901~910 ol I ol ol ol ol 01 0 0 0 0 ~I 011 011 0 0 011 011 0 o 11 0 ol ol ol 0 0 ol ol 0 ol 0 OJI on o 11 0 0 o 11 olL 0 o 11 0 403,837 405,519 405,519 0 406,809 408,849 410,059 I 412,019 I 416,069 I 428,159 1,682 2,020 1,290 (730) 2,040 1,220 1,950 I 4,o5o I 12,090 I 16,910 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I 11 405,519 II 407,539 II 406,809 II (730)1 408,849 I 410,069 II 412,019 fl 416,069 II 428,159 If 445,069 I I I I I 6 - 4 0 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) EXHIBITS PAGE29 f U) .. QUIMBY FUND DETAIL (Fund-334) Revenues Developer fees Interest earnings Total Revenue Expenditures Improvements Total Expenditures QUIMBY FUND NET BEFORE TRANSFERS Transfers In Total Transfers In , I ij~~~;-~~ ~~-v~{m~~ ~~~~J <~~~~;o ~~!~~ ~~~~>i ,~~~~; ~~···· i I i I o I o I o i o I o I 1.400.000 I 1.300.000 I o I o I o I (h) 123 I 150 I 92 I (58)1 o I o I 1,940 I 13,850 I 41,340 I 57,850 I 12311 15011 92 r---(58)f -o I 1.400.00011 1,301,94011 13,85011 41,34011 57,850 0 0 o I o I 29,ooo I o i o I o I o 0 I 0 0 0 oir 01 -29,ooo I o 11 o I~---o 11 o I I I 12311 15011 92 U (58>1 (29,ooo>I 1.400.00011 1,301,94011 13,85011 41,340 I 57,850 ' ' OI 01 OI OI OI OI OI 01 O 0 o 1r-----o II o u--o I -o I o II o II o II o I 0 I I Transfers Out I 0 0 0 0 0 993,000 300,000 O o O Total Transfers Out I 0 II 0 II 0 II 0 I 0 I 993,000 II 300,000 II 0 II 0 I 0 QUIMBY FUND SUMMARY: Beginning Fund Balance 29,205 I 29,328 I 29.328 I 0 29.420 I 420 I 401,420 I 1.409,360 I 1.423,210 1.464,550 I Plus: Revenues 123 150 _ 92 I (58) o I 1,400.000 I 1,301,940 I 13,850 I 41,340 57,850 Less: Expenditures 0 0 0 0 (29,000) 0 0 oT 0 0 I Plus: Transfers In 0 0 0 0 0 0 0 OI 0 0 Less: Transfers Out 0 0 0' I 0 0 (993,000) (300,000) ol 0 0 Ending Fund Balance ,____ _____ _ I r==f9~32811 29.478!1 29.420 11 ]58}1---4201 401;42011 1.409.36011-1.423.21011 1.464.55011 1.522.400 I 6 - 4 1 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~~i; :11~1~~; ·~~~; REVISED ~ti~cisEo · .. · ~~~~>>~~~~ ' a: VARIANCE MODEL MooEL ~ BUDGET : FY11•12 FY12-13 p;;1a;.14 f'Y.14-15 fy17•18 ":\_~:::~:>:-·,·.· PAGE 30 .····) ?· +-· AFFORDABLE HOUSING IN -LIEU FUND DETAIL ' {Fund-337} --t-: ~· ··---+-Revenues I f---· +-- Developer fees 0 0 Oi 0 0 0 221,818 0 0 0 Misc revenue 0 330,000 0 (330,000) 0 0 0 0 0 0 Equity transfer in t--0 0 500,000 500,000 0 0 0 0 0 0 Interest earnings (h) 16 10 697 687 4,160 1,510 2,400 7,150 21,340 29,850 Total Revenue I 16 II 330.01011 500,697 II 170,687 I 4,160 I 1.51011 224,218 II 1.15011 21,340 I 29,850 ~· ' i Expenditures l 2,889 4,000 3,659 341 0 3,800 0 0 0 0 Total Expenditures I 2,88911 4,00011 3,659 II 34111 01 3,800 II o II 011 01 0 I I AFFORDABLE HOUSING SET-ASIDE FUND NET I I (2,873)11 326.01011 497,03811 171,0281 4.160 I (2,290)11 224,21811 7.15011 21.340 I BEFORE TRANSFERS 29,850 I I 0 0 0 o I o I 0 0 0 0 0 Total Transfers In I 011 011 011 o I o I 011 011 o II 01 0 I o\ I 0 0 o I 0 0 0 0 0 0 Total Transfers Out I 011 o II 011 o I o I o II on 011 01 0 AFFORDABLE HOUSING IN -LIEU FUND SUMMARY , (NON-RDA) i Beginning Fund Balance 7,025 1,770,520 4,152 (1, 766,368) 501,190 505,350 503,060 727,278 734,428 755,768 Plus: Revenues 16 330,010 500,697 I 170,687 4,160 1,510 224,218 7,150 21,340 29,850 I Less: Expenditures (2,889) (4,000) (3,659) 341 0 (3,800) 0 0 0 0 Plus: Transfers In 0 0 01 0 0 0 0 0 0 0 I Less: Transfers Out I 0 0 0 0 0 0 0 0 0 0 i Spendable Fund Balance I I 4,152 II 2,096,53011 501.190 II (1,595,340>1 5o5,35o I 5o3.o6o 11 727,27811 734,42811 755,768 I 785,618 AMCAL Long-Term Note Receivable 1,766,368 2,990,000 Ending Fund Balance per Financial Statements I 1.110,520 I I 3,491.190 I I 6 - 4 2 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS a: ACTUAL BUDGET ~f~#~'ii; ~~I1~<J:~ REVISED p~9;~~~ T~RPj:L> .. MQDE.L MODEL M()D~L/ ~ BUDGET ;f FY10-11 FY11-12 FY12-13 F'(::13"14 : f'(14"15 FY15-16 FY16~17 FY17~1li PAGE 31 < >+ ? l ENVIRONMENTAL EXCISE TAX (EET} FUND DETAIL I IFund-3381 Revenues ---t- Developer fees 27,384 I 0 35,954 35,954 0 240,760 115,418 25,000 25,000 25,000 Interest earnings (h) 2,744 410 1,417 1,007 1,770 910 1,170 1,110 2,580 4,600 Total Revenue I 30,128 II 410 II 37,311 11 36,961 I 1.110 I 241,610 II 116,58811 26,11011 21,5801 29,600 Expenditures Improvements 212,682 38,245 38,245 0 61,800 0 0 0 0 0 Total Expenditures I 212,68211 38,24511 38,245 II o I 61,800 I 011 011 0 II o I 0 I I EET FUND NET BEFORE TRANSFERS I (182,554)11 (37,835)11 (874)11 36,961 I (60,030)1 241,610 II 116,588 II 26.110 II 21,580 I 29,600 Transfers Out To CIPfund 86,300 0 0 0 50,000 300,000 250,000 50,000 0 0 Total Transfers Out I 86,300 II o II o II 01 50,000 I 300.00011 250,000 II 50.000 II o I 0 ENVIRONMENTAL EXCISE TAX IEET) FUND I SUMMARY I Beginning Fund Balance 684,251 415,397 415,397 0 414,523 304,493 246,163 112,751 88,861 116,441 Plus: Revenues 30,128 410 37,371 36,961 1,770 241,670 116,588 26,110 27,580 29,600 Less: Expenditures (212,682) (38,245) (38,245) 0 (61,800) 0 0 0 0 0 Plus: Transfers In 0 0 0 0 0 0 0 0 0 0 Less: Transfers Out (86,300) 0 0 0 (50,000) (300,000) (250,000) (50,000) 0 0 Ending Fund Balance I 415,39711 377,56211 414,52311 36,961 I 304,4931 246,16311 112.151 II 88,86111 116,441 I 146,041 6 - 4 3 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) PA.~Ef32 BIKEWAYS FUND DETAIL !Fund-340) Revenues Grant Income Other revenues lhl I Interest earnings , .. , , Total Revenue --------· 1 --• Total Expenditures BIKEWAYS FUND NET BEFORE TRANSFERS ~~~~-t-~-l.!========= Transfers Out BUDGET FY11-12 25,DDD D D I ! I 25.DDD 11 Dll 25.DDD 11 ACTU~ ~;~fiij~~ FY1Pi2 F'('i1;,1~'{ D (25,DDD) D D 1D 10 II D II 1011 I REVISED BUDGET FY12-13 51,204 9,75D D 6D,954 j PROPOSED FY13-14 26,586 D D 26,58611 D II I 26,58611 ~~~l; ;!~~~; 26,600 D M.ODEI. FY16'17 26,6DD ! D D 26,6DD II EXHIBITS MODEL FY17~18 26,6DD D D 26,6DD Dll-D To CIP fund 26,973 I 25,DDD I D I 25,ooo I 61,D15 I 26,586 I 26,600 I 26,600 I 26,6DD 26,6DD Total Transfers Out I 26,973 11 25,Doo 11 D 11 25,DDD I 61,D15 I 26,586 11 26,6DD 11 26,6DD l~J>oD I 26,600 BIKEWAYS FUND SUMMARY: Beginning Fund Balance DI 51 I 51 I D 61 (D) (D) (D) (Dll (D) Plus: Revenues 21,D24 I 25,DDD I 1D l (24,99D) 6D,954 26,586 26,6DD 26,6DD 26,6DD I 26,6DD Less: Expenditures DT D D D D D D D D D I Plus: Transfers In DI D D D D D D D D D I Less: Transfers Out c26.973>T (25,000) D 25,DDD (61,D15) (26,586) (26,6DD) (26,6DD) (26,6DD) (26,6DD) I Ending Fund Balance I 51 II 51 II 6111 1D I (Dll (D)ll (D)ll (D)ll (D)lr---(0) I I I 6 - 4 4 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B I ~ l~I~~; i~W VARIA~Cg REVISED !• ·:--·· MODEL · > fJ(qggj., MOllEL ACTUAL BUDGET PROPOSED MODEL I :: FY11-12 FY11~#d FY12-13 'fV13~14 FY14-15 · FY15~16> FY16~17 FY17~18 •·· PAGB~3 ' I I i - ----- WATER QUALITY & FLOOD PROTECTION (Fund-! 2Q1l I -+-I Revenues I i ! State Grants 93 0 ·a I 0 9,464,727 0 0 0 0 0 Storm Drain User Fee (a) 1,312,230 1,277,000 1.319.109 I 42,109 1,303,000 1,329,000 1,355,600 1,382,700 0 0 Interest earnings (h) 12,561 2,800 10,965 8,165 2,500 1,500 1,100 3,700 28,600 8,400 Total Revenue I 1,324,88311 1.219.80011 1,330,07411 50,274 I 10,770,227 I 1.330,500 II 1.356.10011 1,386,400 II 28,600 I 8,400 ! Expenses Administration 145,533 130,200 141,320 (11,120) 148,618 151,300 161,792 166,646 171,645 175,000 Maintenance 41,468 42,750 86,359 (43,609) 326,599 229,727 237,518 245,544 250,455 250,000 Improvements & Engineering 596,887 968,416 -936,396 32,020 21,625,846 1,215,881 805,278 370,836 377,653 380,000 Total Expenses I 783,88811 1,141,36611 1,164,07511 (22,709)1 22,101,063 I 1,596,90811 1,204,58811 783,02611 799,753 I 805,000 I I WQFP FUND NET BEFORE TRANSFERS I 540,99511 138,43411 165,99911 27,565 I (11,330,836)1 (266,408)11 152,11211 603,37411 (771,153)1 (796,600) ---- Fund Transfer In i From CIP Fund 0 0 0 0 8,293,009 0 0 0 0 610,000 Total Transfer In I 011 o II o II o I 8,293,0091 011 011 o II 01 610,000 I I Fund Transfer Out 0 0 01 o I o I 0 0 0 0 0 Total Transfer Out I 011 o II 0 II o I o I on o II o II o I 0 I --·-~-- WQFP NET ASSET SUMMARY: I ------- I Beginning Unrestricted Net Assets 2,824,621 3,365,616 3,365,616 I 0 3,531,615 493,788 227,380 379,492 982,866 211,713 i Plus: Revenues 1,324,883 1,279,800 1,330,074. 50,274 10,770,227 1,330,500 1,356,700 1,386,400 28,600 8,400 I I Less: Expenses (783,888) (1,141,366) (1,164,CIT5ll (22,709) (22, 101,063) (1,596,908) (1,204,588) (783,026) (799,753) (805,000) ! Plus: Transfer In 0 0 o; 0 8,293,009 01 0 0 0 610,000 I Less: Transfers Out 0 0 Qi 0 0 0 0 0 0 0 i Unrestricted Net Assets I 3,365,61611 3,5o4.o5o II 3,531,615 II 27,565 I 493,788 I 221.380 II 379,49211 982,86611 211,7131 25,113 Invested in Capital Assets 12,752,669 13,356,259 i I i Total Net Assets I 16,118,2851 I 16,887,874 I i I I I 6 - 4 5 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL-(BY FUND) EXHIBITS UAL/ FY10-11 . ' VARIANCE FY11C12 REVISED BUDGET FY12-13 <il~~~:Q MODEL F\'14-15 MODEL: M{)O~i. .·.<MODEL FY15~1~/ Fr1~~1i FY17~18 PAGE34 1,.AA~M~uITTHOR:~.<Uou~e mo I __ ~ -I I I I I ! I I I I I FUND DETAIL (Fund-2851 ~. ! --·~~~~~+-~~~~~t--~~~~~-t--~~~~--J~~~~~~+.-~~~~~~+-~~~~-+~~~~~+-~~~~-+~~~~~4 Revenues Interest earnings i (ii~ 472 I 1,220 01 c1.220)1 1,1001 • 820 I 1.0101 1,1201 3,550 2.120 Total Revenue --,----ll 47211 1,220 I ~I (1,220)1 1,100 I 820 II 1,070 II 1,720 II 3,550 I 2,720 I I I I I I I expenditures -; I I i Maintenance & Operations (b) • 82,464 I 143,350 I 52,606 90,744 143,400 119,100' 121,600 124,200 126,900 Total Expenditures =~~-U 82,464 II 143,350 II 52,606 II 90,744 I 143,400 f 119,10011 121,600 II 124,20011 126,900 I I : : I I I ! I 129,800 129,800 IMPROVEMENT AUTHORITY -PORTUGUESE BEND! II II II II I I II I FUND NET BEFORE TRANSFERS I --(81,992) (142,130) (52,606) 89,524 (142,300) (118,280) (120,530) I (122,480)11 (123,350)11 (127,080)1 Transfers In From General fund Total Transfers In Transfers Out I Total Transfers Out I IMPROVEMENT AUTHORITY -PORTUGUESE BEND 1 FUND SUMM/'.RY I , I I I I I I I I 101.000 I 60,000 I so,ooo I o I 106,ooo I 10,000 i 10,000 I 10,000 I 10,000 I 101,00011 60,00011 60.00011 o I 1os.ooo I 10.00011 10,00011 10.00011 10.000 I, o I o I o I o I oT-o I o I o I o I air----oir-----011 01 o 011 01 OJI 01 ! I Beginning Fund Balance --+---283,320 I 302,328 I 302,328~ o I 309,7221 273,422 225,1421 174,612 I 122,132 Plus: Revenues Less: Expenditures Plus: Transfers In Less: Transfers Out Ending Fund Balance I ! 472 I 1.220 I oi 1,100 820 1.010 I 1,120 I 3,550 (82,464) (143,350) (52,606) 90,744 (143,400) (119,100)1 (121,600) (124,200)1 (126,900) I ! 101,000 60,000 60,000 0 106,000 70,000 ! 70,000 10,000 I 70,000 0 0 0 0 0 01 0 01 0 1 i ' l I 302,32s11 220.198 II 309,12211 89,524 I 273,4221 225.14211 114,61211 122,13211 68,182 I -! -··· T I I I i I I I I I 70,000 70,000 0 0 68,782 2,720 (129,800) 70,000 0 11,702 6 - 4 6 CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBITS ACTUAL FY10-11 ~~~~I ':" ii4~:, \r~!~;E REVISED BUDGET FY12-13 ~iii~~.[ 0 ~~~~~ MODEL FY15·16 MOQEL .·.·. MQPEL i=Y1ti•11 FXtl~1s PAGE 35 I IMPROVEMENT AUTHORITY • ABALONE COVE 1 1 FUND DETAIL !Fund-7951 , Revenues I 1 1 r 1 Interest earnings (h) 2;578T 6,200 I 5 I (6,195)1 5,900 I 3,300 I 5,100 I 10,200 I 29,500 I 39,800 I !Total Re~ue -· I 2,578 II 6,200 II 5 II (6,195)1 5,900 I 3,300 II 5,100 II 10,200 II 29,500 n 39,800 I Expenditures RDA Storm Drain User Fee Operations Contribution to ACLAD Maintenance Total Expenditures IMPROVEMENT AUTHORITY· ABALONE COVE FUND NET BEFORE TRANSFERS Transfers In From General fund Total Transfers In Transfers Out Total Transfers Out IMPROVEMENT AUTHORITY· ABALONE COVE FUND SUMMARY I • I (a) I 2,847 I 2,900 I 2,890 I 10 I o I 3,000 I 3,100 I 3,200 I 3,300 !bl I 40,111 i 46,850 I 87,079 I (40,229)1 109,900 I 5o,3oo I 51.400 I 52,500 I 53,100 I 01 Oj Oj 01 01 Oj 01 01 Oj I 43.02411 49,75011 89,969 II (40.219>1 109,900 I 53,30011 54,50011 55,10011 51.000 I I I (40,446) (43,550] (89,964)11 (46,~-(104,000~-(50,000)1 (49, ,500) (27,5001 o I o I o I o I o I 20.000 I 20,000 I 20,000 I 20.000 I OJI 2.11 211--0 I 0 I 20,00011 20,00011·20.000 II 20,000 I I I DI DI DI DI DI DI DI ol O i---· 01i---· ·ou----·011 -01 01 011 011 on u Beginning F~nd Balance ---·------· ... ~~~ ??~ I ?a? 777 I 292,7771 0 202,813 98,813 68,813 39,413 13,913 I Plus: Revenues 2,578 6,200 Less: Expenditures (43,024) (49,750) Plus: Transfers In 0 0 Less: Transfers Out -------------l---+------l-----"-1-01 01 5 (6,195) (89,969) (40,219) 0 0 01 o I 5,900 3,300 5,100 10,200 29,500 I I (109,900) (53,300) (54,500) (55,700) (57,000)i 0 20,000 20,000 20,000 20.000 I I 0 0 0 0 01 3,400 54,900 0 58,300 (18,500) 20,000 20,000 0 0 6,413 39,800 (58,300) 20,000 0 Spendable Funci B.alance I 11 292, 777 II 249,22711 202,813 II (46,414)1 98,813 I 68,813 JI 39,413 II 13,91311 6,413 lr---7;ll13 Non-Spendable Endowment 1,UUU,000 1,000,000 1,000,000 Ending Fund Balance Per Financial Statements I 1,292,7771 I 1,202,813 I I 1,098,813 I 6 - 4 7 CITY OF RANCHO PALOS VERDES -2013 FIVE-YEAR FINANCIAL MODEL EXHIBIT C-1 CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES •·ACTUAL ·ACTUAL BUDGET s~~~jttgRij;Ff14 MODEL MOD El MPHITur01I" CIP FUND PROJECTS . FY10-11 FY11-12 FY12-13 FY15-16 FY16-17 FUNDING SOURCE Street Infrastructure FY09-10 Arterial Street Rehab (PVDS/PVDW) 2,202,336 Measure R/Prop C&A/STPUCIP Reserve --~--------- No. City limit) 2,380,000 Measure R/Prop C&A/STPUCIP Reserve Future Arterial Street Rehab Projects 70,000 2,630,000 70,000 2,730,000 1,500,000 Measure R/Prop C&A/STPUCIP Reserve FY09-10 Residential Street Rehab (PVDS Area) 1,445,693 General Fund/TOA Article 3 Area) 193,611 7,309 1,512,691 General Fund!TDA Article 3 FY11-12 Residential Street Rehab (Hawthorne/Silver Spur Area) 1,677,697 General Fund/TOA Article 3 ------- FY12-13 Residential Street Rehab (Hawthorne Area, Crest to Grayslake) 1,611,015 General Fund/TOA Article 3 (Eastview/Peninsula Verde Area) 1,900,000 General Fund/TOA Article 3 Future Residential Street Rehab Projects 2,100,000 1,800,000 1,800,000 2,100,000 General Fund/TOA Article 3 Pavement Management Plan Update 120,000 120,000 GIP Reserve Arterial Median Improvements (PVDW) 26,810 473,690 Beautification Fund Traffic Signal • Crenshaw/Crestridge 11,918 149, 160 Grant/GIP Reserve Traffic Signal Synchronization -Hawthorne Blvd 6,007 779,525 GranVCIP Reserve PVDE -Early Action Safety Improvements 6,886 273,114 GranVCIP Reserve PVDE -Headland Safety Improvements 41,700 500,300 GranVCIP Reserve Hawthorne Blvd • Pedestrian Improvements 4,419 139,818 1,282,763 GranVCIP Reserve PVDS -Bikeway Safety Project 6,755 360 793,885 GranVCIP Reserve PVDS -Realign East End of Landslide 500,000 GIP Reserve I PVDS -Landslide Roaaway 1-<ealignment ana Drainage 245,000 3,510,000 GIP Reserve PVDE • Multi Modal Improvements 3,200,000 GranVCIP Reserve Western Ave -Traffic Improvements 3,200,000 Outside Agency Contrib/CIP Reserve Parks & Open Space Infrastructure Hesse Park Field Upgrade Phase I & II 220,296 General Fund/EET Hesse Park Parking Lot 190,000 Quimby Lower Hesse/Grandview Park Improvements 55,759 103,216 36,000 General Fund/GIP Reserve Ryan Park Field Upgrade 270,463 5,145 General Fund/EET Ryan Park Southern Entrance Road -Design 10,353 229,647 GIP Reserve Ryan Park Parking Lot Repair (CalWater Damage) 29, 114 GIP Reserve Ryan Park Parking Lot Expansion 400,000 Quimby Ryan Park Restroom Improvements 267,512 GIP Reserve PVIC -Building Sign & Screening Wall 110,000 Quimby Ladera Linda Site Master Plan 100,000 General Fund Abalone Cove Shoreline Park Improvements 665,176 GranVCIP Reserve Shoreline Park Erosion Control 35,000 GIP Reserve Abalone Cove Shoreline Park -Parking Lot 332,000 Quimby Abalone cove Shoreline Park -:;taff Building, Restrooms & Driveway 108,000 Quimby -- Eastview Park Playground Improvements 59,355 185,565 Knabe Measure A GranVCIP Reserve -------- California Coastal Trail 41,077 587,964 GranVCIP Reserve ---------- Salvation Army Trail 103,000 Quimby Bronco, Martingale & Grayslake Traffs -Design 50,000 Quimby Gateway Park Development 200,000 GranVCIP Reserve ---- Dog/Skate Park Analysis 5,217 General Fund Pt. Vicente Blufftop Drainage Control 3,970 76,030 GIP Reserve Oceanfront Estates Blufftop Drainage Control 22,000 GIP Reserve Trump Beach Life Guard Station Telephone Service 6,410 1,215 GIP Reserve Misc Project Design 15,000 10,000 10,000 10,000 10,000 10,000 GIP Interest Earnings ---------- ----------·------------------· ------------------------ 6 - 4 8 CITY OF RANCHO PALOS VERDES-2013 FIVE-YEAR FINANCIAL MODEL CIP FUND PROJECTS Buildings/Facilities ---~---- ADA Transition Plan Projects Hesse Park Drop Ceiling Retrofit/Replacement City Hall community Koom Drop ce1 mg Retrofrt/Replacement City Hall Cabling Condutt Hesse Park/Ryan Park Fiber Optic Cabling Upgrade ---- Pk/Ladera Linda Ladera Linda Community Center Replacement RPvrv Studio Restroom Sewer Infrastructure Palos Verdes Drive East Sewer Relocation Basswood Avenue West General Street Abalone Cove Ironwood Street PVDS at Schooner Drive PVDS at Sea Cove Drive Ginger Root Lane Malaga Canyon Miscellaneous Projects Other Projects and Administration Infrastructure Report Card FEMA Reimbursement Crenshaw Utiltty Undergrounding Drainage Area Monitoring System Storm Water Quality Regional Project New Landslide Dewatering Wells (2) Engineering and Grant Administration Total CIP Fund Expenditures NOTE: The Total Expenditures above agree to Total CIP fund expenditures on Page 8 of the Model. CAPITAL IMPROVEMENT PROJECTS FUND EXPENDITURES ··~r~it~•·•··.2''0-~I~t;· BUDGET PROPOSED.MOQE~:F!'14i M.OOEL .MODEL MODEL\FY17- FY12-13 FY13-14 .· ..• · 1if/>:: ·•. FY15-16 w1~~11 18 . 50,000 325,000 250,000 50,000 30,517 8,031 4,008 60,000 260,000 175,000 1,600,000 4,000,000 -~ ~. 38,000 96,550 113,982 114,000 122,000 567,000 -24!,275 603,000 199,000 203,000 407,000 465,000 49,500 ------ 59,221 3,541 1,200,000 200,000 300,000 200:000 300,000 170,000 170,000 85,000 7,325 21,548 20,000 50,000 50,000 50,000 50,000 50,000 2,385,306 I 2,939,431 13,476,429 8,029,975 I 9,880,000 16.495,300 15,055,ooo I 12,460,000 EXHIBITC-1 FUNDING SOURCE EET/CIP Reserve Building Replacement Fund General Fund CIP Reserve CIP Reserve CIP Reserve CIP Reserve -- CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve CIP Reserve General Fund FEMA Reserve Rule 20A Funds CIP Reserve CIP Reserve CIP Reserve CIP Interest Earnings 6 - 4 9 CITY OF RANCHO PALOS VERDES -2013 FIVE-YEAR FINANCIAL MODEL CAPITAL IMPROVEMENT PROJECTS (CIP) RESERVE RECONCILIATION ACTUAL, :i9I~A~Ht CAGWP.l-ACTUAL BUDGET PRO.POSED MODEL MODEL, .. / MODEi;: FYOS-09 ·. · ·. ·. FY09~10//:. · / FY10;e11 FY11-12 FY12-13 ~;FY'ii"14 FY14-15 FY15:16 f¥1'6~fr Beginning Balance 0 7,207,180 7,081,596 11,649,780 15,406,940 6,822,269 6,955,394 4,563,494 6,916,494 Transfer from General Fund (Establish GIP Reserve) 3,000,000 Transfer from General Fund (Equal to TOT) 85,245 1,954,507 2,640,368 3,349,015 3,611,074 3,679,700 3,757,000 3,835,900 3,920,300 Transfer from General Fund (Other Projects) Timing Diff/Saving 4,077,574 (1,735,682) 2,017,636 554,061 (3,479,381) Interest Earnings 44,361 30,220 32,485 36,780 42,300 20,400 33,100 44,800 200,900 Engineering and Grant Administration (7,325) (21,548) (20,000) (50,000) (50,000) (50,000) (50,000) Misc Park Project Design (15,000) (10,000) (10,000) (10,000) (10,000) FEMA Reimbursement (59,221) (3,541) Upper Filiorum Purchase (374,629) Lower Hesse/Grandview (55,759) (60,716) (36,000) Eastview Playground (59,355) (35,565) California Coastal Trail (41,077) (18,923) Gateway Park Development (40,000) Ryan Park Restrooms (267,512) Ryan Park Parking Lot Damage (29, 114) San Ramon Canyon Stabilization (8,293,009) Future Arterial Street Rehab Projects (1,582,000) (1,230,000) Pavement Management Plan Update (120,000) PVDE -Headland Safety Improvements (4f,700) (12,700) PVDS -Realign East End of Landslide (500,000) PVDS -Landslide Roadway Realignment and Drainage (245,000) (3,510,000) PVDE -Multi-Modal Improvements (640,000) Western Ave -Traffic Improvements ADA Transition Plan Projects (25,000) Basswood Avenue Sewer (114,000) West General Street Sewer (122,000) Abalone Cove (567,000) Ironwood Street (247,275) PVDS at Schooner Drive (603,000) PVDS at Sea Cove Drive (199,000) Ginger Root Lane (203,000) Malaga Canyon (407,000) Miscellaneous Projects (465,000) Hesse Park/Ryan Park Fiber Optic Cabling (60,000) (260,000) --- Hesse Park Multi-Purpose Room AudioNisual Upgrade (175,000) RPVTV Studio Restroom (38,000) Fiber Optic -Ab Cove Sewer Lift Sins/Shoreline Pk/Ladera Linda Ladera Linda Community Center Replacement ----- Drainage Area Monitoring System (200,000) (300,000) -- Storm Water Quality Regional Project (200,000) (300,000) Storm Drain Program Subsidy New Landslide Dewatering Wells (2) (170,000) (170,000) (85,000) Ending Balance 1.201.180 I 1,081,596111.649,180I15,406,940 6,822,269 6,955,394 I 4,563,49416,916,494 I 9,282,694 I EXHIBITC-2 NIODEL FY17-18 9,282,694 4,010,500 366,700 (50,000) (10,000) (800,000) (1,600,000) (1,600,000) (4,000,000) (610,000) 4,989,894 6 - 5 0 WQFP FUND PROJECTS Backbone Projects Lower San Ramon Canyon Stabilization PVDE San Pedro Canyon Backbone System Miraleste Catch Basin Project Pipe Lining Other Capacity & Secondary System Projects Via Colinita Vickery Canyon PVDE Lower Switchbacks PVDS (East of Barkentine) South HawthorneNia Frascati Paintbrush Canyon Drainage Study Filtration Systems Catch Basin Filtration Devices Installation of Filtration Devices Other Projects Via Canada Storm Drain Rehab Marguerite Open Channel Miscellanous Repairs & Maintenance Drainage Master Plan Program Storm Drain & Filtration Maintenance & Repair Administration (contract/staff engineer) Grand Total -WQFP Fund Expenditures CITY OF RANCHO PALOS VERDES 2013 FIVE-YEAR FINANCIAL MODEL WATER QUALITY FLOOD PROTECTION (STORM DRAIN) EXPENSES EXHIBIT D (\C'[QAL ACTl,JAJ.:; BUDGET PROPOSED NIOQl;J,,) ;f:ffl!lQQJ;;L. F\':10-11 FY11;.12> FY12-13 FY13-14 F:Y14>1S? ' #¥15;.16 517,425 675,708 17,949,603 14,560 555,440 63,521 12,474 147,675 1,323,665 329,881 335,278 340,836 242,500 485,000 446,000 440,000 60,000 - 27,244 218,849 73,000 17,533 71,801 50,000 350,000 22,211 727,789 30,000 30,000 30,000 41,468 42,750 326,599 229,727 237,518 245,544 145,533 148,059 148,618 151,300 161,792 166,646 783,888 I 1,164,074 22,101,063 1,596,908 I 1,204,588 I 783,026 I MODEL MC)!:)~ FY16-17 FY17;;18 FUNDING SOURCE User Fees User Fees User Fees 347,653 350,000 User Fees User Fees User Fees User Fees User Fees User Fees User Fees User Fees User Fees 30,000 30,000 User Fees 250,455 250,000 User Fees 171,645 175,000 User Fees 799,753 I 805,000 6 - 5 1