The URL can be used to link to this page

RPVCCA_SR_2010_05_22_02_Draft_Five_Year_Financial_Model_2010CrrvOF MEMORANDUM RANCHO PALOS VERDES TO: FROM: DATE: SUBJECT: REVIEWED: HONORABLE CHAIR &MEMBERS OF THE FINANCE ADVISORY COMMITTEE ~ DENNIS McLEAN,DIRECTOR OF FINANCE &IT ~ KATHRYN DOWNS,DEPUTY DIRECTOR OF FINANCE &IT tP MAY 22,2010 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL CAROLYN LEHR,CITY MANAGER C!.9- RECOMMENDATION Review the Draft 2010 Five-Year Financial Model (2010 Model),and provide direction regarding the assumptions and content. EXECUTIVE SUMMARY Draft FY10-11 Budget The draft 2010 Model includes Staff's Proposed FY10-11 Budget,which is currently balanced with net activity of $8,156 and estimated ending General Fund Reserves of about $1.7 million at June 30,2011. Update -State Budget and Cash Crisis The Governor's January draft of the state budget for 2010-11 includes $8.5 billion in spending cuts,$6.9 billion in additional federal funding,and $3.9 billion of alternate funding (swaps,new fees,etc.)in an attempt to close a projected $20 billion deficit.The California Legislative Analyst's Office (LAO)has opined that the state is likely to fall "several billion dollars"short of the amount the governor is relying on to balance the budget.The Governor is scheduled to issue a revised proposal for 2010-11 in May.So far,items affecting cities include a Transportation Funding Swap and deferral of certain payments.At this time,there is little to no fiscal impact to the City. On March 22 nd ,the Governor signed two bills which contain the main provisions for the Transportation Funding Swap,which exchanges the state's share of sales tax on gas with an increased excise tax.There is no net effect on local revenue;however,the City's 2-1 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 2 of 11 Proposition 42 revenue would be replaced with an allocation from the increased excise tax that has less legal protections from future state grabs than Proposition 42.Interestingly,as a result of the Swap,transit agencies are expected to receive less revenue from the state; which has the potential to impact future transit contributions made by the City to the regional transit systems it supports.Nothing has been included in the 2010 Model for any possible future impacts. On March 4th ,the Governor signed a bill to establish a cash management plan to defer various appropriations.The state would defer FY10-11 Highway Users'Tax monthly payments,scheduled for July 2010 through March 2011,until May 2011.Proposition 42 payments (to be replaced with an excise tax allocation)normally received in October and January would also be deferred until May 2011.There is no budgetary impact to the City as a result of this bill,only timing of cash flows and an immaterial loss of interest earnings. The Governor's proposed budget also includes further delay of payments for state mandated costs incurred by local agencies prior to 2004-05.The City's share of these reimbursements is about $180,000;which,consistent with prior years,has not been included in either the draft FY10-11 budget or the 2010 Model. The California Redevelopment Association (CRA)lawsuit declaring a state raid of redevelopment funds as unconstitutional was decided on May 4,2010.Sacramento County Superior Court Judge Lloyd Connelly ruled that the state can take more than $2 billion from local redevelopment funds and transfer the money to school operations.The CRA is seeking injunctive relief in conjunction with filing an appeal.If the injunction is not granted,the Rancho Palos Verdes Redevelopment Agency will be required to transfer $330,125 for FY09-10 by May 10,2010.This transfer would likely be funded with a loan from the City's General Fund,thereby reducing General Fund Reserves.Staff will continue to monitor the State's actions throughout the 2010 budget process,and will report to City Council as necessary. Summary 2010 Model Information The current draft of the 2010 Model indicates that General Fund Reserves will continue to grow over the next five years.This is largely due to expected continued receipt of transient occupancy tax (TOT)revenue from the Terranea Resort,which has been included in the Model now that the Resort has opened.Staff continues to recommend that the City Council set-aside Terranea TOT for capital projects (including the San Ramon Canyon Stabilization and Civic Center projects),as opposed to the expansion of programs and services in the operating budget.In its Draft FY10-11 Budget staff report,dated May 22, 2010,Staff has provided an overview of a proposed revision of the City Council Policy No. 41:Reserve Policies to memorialize this continuing recommendation. Staff has included tlie following uses of TOT in the 2010 Model: ~FY1 0-11 improvements to Lower Hesse and Grandview Parks ($2 million); ~FY11-12 Civic Center planning and infrastructure improvements ($1 million);and ~FY11-12 matching contribution for various grant-funded park improvements 2-2 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 3 of 11 ($145,000). The uses of TOT revenue summarized above have been included as "funded"projects in the updated 2009 CIP as last approved by the City Council on March 16,2010. Finance Advisory Committee Review The Finance Advisory Committee (FAC)reviewed the draft 2010 Model on April 7,2010 and April 28,2010.The following two recommendations were offered with unanimous support of the FAC. In response to decreasing Proposition A revenue that funds the City's transit contributions: The FAC recommends that Staff prepare a detailed cost-benefit analysis of Municipal Area Express (MAX transit)services to the City,to be completed by the end ofthe 2010 calendar year. In response to Staff's suggestion that the Street Maintenance Fund reserve policy may be decreased to something less than 1 year of the budgeted cost of road maintenance in the landslide area of the City,due to the increased costs of such maintenance: The FAC recommends that the City Council continue its reserve policy to keep one year of budgeted expenditures for road maintenance in the landslide area on hand in the Street Maintenance Fund. BACKGROUND AND DISCUSSION Overview The 2010 Model is a financial schedule prepared by the Finance and Information Technology Department (see Exhibits A through E).City Council Policy No.18 requires preparation of the Model.The 2010 Model includes all funds of the City and its component units (Redevelopment Agency and Improvement Authority). 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 FY10-11 UUT revenue is $2.46 million (or approximately 12%of total General Fund revenue).Based upon the capital needs of the City,as evidenced by 2-3 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 4 of 11 the list of unfunded projects in the Capital Improvement Plan,Staff believes the current UUT rate of 3%continues to be a necessary General Fund revenue source. At the June 15,2010 public hearing,the City Council will be asked to determine that the UUT rate of 3%continues to be a necessary General Fund revenue source and that the current rate of 3%should be maintained. 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. Format of the 2010 Model The 2010 Model includes the presentation of: ~Actual FY07 -08 and FY08-09 revenue,expenditures and ending fund balances for all funds; ~The final adjusted budget and the calculated budget variance for FY08-09 revenue, expenditures and ending fund balances for all funds; ~Estimated FY09-10 activity,primarily based on the adjusted FY09-10 budget;and ~The draft FY10-11 budget as the first year of the 2010 Model. The 2010 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 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 2010 Model includes several schedules organized as follows: 2-4 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 5 of 11 Exhibit A Exhibit B Exhibit C Exhibit D Exhibit E One Page Summary -2010 Five-Year Financial Model 2010 Five-Year Financial Model by Fund Capital Improvement Project Expenditures WQFP Program Expenses Summary of Fund Transfers 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 2010 Model. Complete List of 2010 Model Assumptions The following General Assumptions are consistent with previous years'Models: 1)Most of the expenditures have been increased annually using an average factor of 2.6%(2.0%in FY1 0-11 increasing to 2.8%in FY14-15)throughout the five years of the 2010 Model.The increase is based on the forecasted increase of Consumer Price Index from the Congressional Budget Office,and annual merit increases for employee salaries. 2)Revenue categories (e.g.property taxes,projected changes in permit activity and retail sales)have been estimated based upon Staff's discussions with other agencies,reports provided by other agencies or Staff's own expectations.The factors (%rate of change)are presented on Page 1 of the 2010 Model using an alphabetical index (a through p)and are referenced throughout the 2010 Model. Assumptions Specific to the Funds and Program Revenues and Expenditures Included in the 2010 Model: 3)Property tax represents about half of General Fund revenue and any small variance in the percentage increase of property assessments has a large cumulative effect on the five years of the Model. Staff has acquired property transfer information from a land management database that indicates a property tax increase of about 0.5%for FY10-11.Staff has also received information that there is no expected inflationary increase of property assessments for FY10-11.Therefore,Staff has assumed an overall property tax increase of 0.5%. The Terranea property is in process of being re-assessed by the County.Due to Resort improvements,the assessed value of the property is expected to increase. Although this increase will be effective for FY09-10,the County has informed Staff that it is behind in its re-assessment process;and the City can look forward to a catch-up payment during FY1 0-11 for any FY09-10 increase of Terranea property tax.Staff has included an assumption that property tax revenue will increase by about $140,000 for this property,and has included both the FY09-10 catch-up payment as well as increased annual revenue beginning in FY10-11. 2-5 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 6 of 11 4)The Terranea Resort has generated about $1.6 million of tax revenue to date during FY09-10 (transient occupancy tax,golf tax,business license tax,and sales tax). Transient occupancy tax (TOT)revenue is expected to reach about $1.8 million for FY09-10.Staff has included $2.0 million of TOT revenue in the model for FY1 0-11 through FY14-15.To date,Terranea TOT revenue has not been included in the City's operating budget.Staff believes that TOT should not be added to the operating budget to provide additional services,as this revenue source may not be consistent in the future.In addition,the City's capital needs include improvements that do not have any other source of funding and protect the health and safety of its residents.In its Draft FY10-11 Budget staff report,dated May 22,2010,Staff has provided an overview of a proposed revision of the City Council Policy No.41: Reserve Policies to memorialize this continuing recommendation. 5)The Los Angeles County Sheriff's Department has provided a 2%cost increase estimate for FY1 0-11 services.The Draft FY1 0-11 budget,as presented in the two- year budget document,had included an increase of 3%.In addition,the City's contribution to the Sheriff's Liability Trust Fund is expected to be temporarily suspended for six months and reduced thereafter.Total annual savings is expected to be about $120,000,which has been reflected in the 2010 Model.Final FY10-11 numbers are expected prior to the Budget Hearing scheduled for June 15,2010. 6)Staff has been working with the City's grant consultant to secure federal funding for the Palos Verdes Drive East (PVDE)/Palos Verdes Drive South (PVDS)Roadway Stabilization Project (also known as the San Ramon Canyon Stabilization project). Statewide and regional support for the project continues to grow including support letters from:Senator Tony Strickland,Senator Roderick D.Wright,Senator Alan Lowenthal,Assemblymember Bonnie Lowenthal,AssemblymemberTed Lieu,L.A. County Supervisor Don Knabe,and L.A.City Councilwoman Janice Hahn. Congressman Rohrabacher was expected to include the project is his High Priority Project portfolio for the reauthorization of SAFETEA-LU,which is a federal transportation bill renewed every six years allowing for specific projects to be authorized and funded.However,such inclusion is subject to his political party's approval,which has not been granted at this time.The project is estimated to cost $19.5 million,and RPV's federal funding request is for $9.75 million.In December a three-way letter was signed between RPV,the City of Los Angeles and Los Angeles County agreeing to collaborate to raise funds to pay for the project.This project has been included in the CIP unfunded project list. In FY09-10 and FY10-11,the City Council allocated approximately $1.5 million (including carry over money from FY08-09)to complete a Project Study Report which will serve as the project initiation document that is submitted to State and Federal Agencies for project funding.The contract that is expected to lead to design concept alternatives for the project was awarded to Harris and Associates at the March 16,2010 City Council meeting.This study is expected to take 6 to 18 months to complete. 7)The Storm Drain User Fee,which generates revenue totaling about $1.2 million annually,will sunset in 2016 in accordance with the ballot measure approved by the 2-6 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 7 of 11 voters in 2007.In FY12-13,Staff expects to prepare an update to the Storm Drain Master Plan;which is expected to identify additional projects that will necessitate a future source of financing. The Fees are deposited into the Water Quality Flood Protection (WQFP)fund for the improvement and maintenance of the City's storm drain facilities.The City Council can elect to increase the Fee by the Consumer Price Index or CPI (but not more than the lesser of CPI or 2%annually),reduce the fee or eliminate the Fee at an annual public hearing conducted in June of each year.Staff expects to recommend a 1.4%increase to the Fee for FY10-11 (from $89.47 to $90.72 per equivalent residential unit),based upon the change in CPI for the 12 months ended February 2010.The Storm Drain Oversight Committee is expected to consider this proposed increase and develop a recommendation to the City Council on May 10,2010. Currently,only storm drain lining and maintenance costs are programmed for FY13- 14 and FY14-15.As noted above,Staff expects to propose establishment of a reserve from any Fee revenue that is not already programmed,as well as any project savings and interest earnings,for the partial funding of the San Ramon Canyon Stabilization project.The Storm Drain Oversight Committee will consider Staff's recommendation before it is presented to City Council. When the WQFP program was established in 2005,a list of 38 projects totaling about $20.1 million was identified and included in the original program.Of those projects,11 projects with an estimated total cost of $11.2 million remain unfunded through FY14-15.The original 2005 program also included about $4.6 million of pipe lining over 30 years.Through FY14-15,about $4.8 million of pipe lining will have been completed over a period of 10 years. 8)The Draft 201 0 Capital Improvement Plan (CIP)includes a list of unfunded projects with a total cost range of $71,155,000 to $108,230,000.The unfunded list includes a new civic center,including a new city hall building,various arterial roadway projects and traffic signal upgrades,and various storm drain projects,including the San Ramon Canyon Stabilization project.The 2010 Model does not include any projects from the unfunded list. 9)A placeholder of $1 ,000,000 has been included in the FY11-12 column of the 2010 Model for infrastructure and consulting costs related to planning for replacement of the Civic Center.Although it is premature to provide specific estimates,pre- construction professional services (Le.architect,engineers,bond counsel,etc.)may or may not be borne by the City,and may exceed the $1 million placeholder included in the 2010 Model. 10)On November 17,2009,the City Council approved a contract with Harris & Associates engineering firm to develop a City-wide sewer user fee.Staff expects to make a recommendation to the City Council by early 2011.Nothing has been included in the 2010 Model for potential future sewer fee revenue or the use of it for projects and/or maintenance. 2-7 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 8 of 11 11 )The residential pavement program is primarily funded with General Fund monies. Capital expenditures associated with the residential pavement management program total about $7.9 million for FY10-11 through FY14-15.The estimates included in the 2010 Model are based upon information provided by the City's pavement consulting engineer. The 2010 Model also includes a $2.7 million arterial roadway project that is primarily funded with a combination of Proposition C (transit),Measure R (transportation), and State Transportation Improvement Program (STIP)monies.After FY11-12,the Proposition C fund balance will continue to accumulate until enough is available to fund another arterial project in the future.More arterial projects could be added to the five-year plan,as other restricted funding is identified. 12)The City receives certain transportation revenues that are generated from cents-per- gallon taxes,including Highway Users Tax (HUTA or "gas tax"),Proposition C,and Proposition A taxes.Each of these taxes is restricted to either street maintenance or public transit activities.These revenue sources fluctuate with changes in consumption,not gas prices.In years past,these revenue sources have been consistently flat.Beginning in FY08-09,consumption began decreasing and affecting the City's revenue.Currently,these revenues are at about 85%of historic levels.Collectively,this is a loss of about $0.3 million of annual restricted revenue to the City. Without changes to the level of right-of-way maintenance,the Street Maintenance fund will require an average General Fund subsidy of more than $100,000 annually (reflected in this version of the 2010 Model).Due to the expected receipt of federal stimulus monies,it appears that Proposition C funded arterial pavement projects budget for FY09-1 0 will remain intact.However,the City's contributions to the Palos Verdes Transit Authority and Municipal Area Express (MAX Transit)will be underfunded by about $130,000 annually. Furthermore,MAX Transit is currently developing a proposal to purchase a number of gas-electric hybrid buses,which would require a capital infusion from each participating agency.The current estimate for the City's contribution to this purchase is about $330,000 to be paid over five years beginning in FY11-12.This purchase would require majority approval from participating agencies (Rancho Palos Verdes,Torrance,EI Segundo,Lawndale,Lomita,City of Los Angeles,and Los Angeles County).As no decisions have been made about this proposal,the additional capital contribution has not been included in the 2010 Model. Until a reasonable solution is developed,such as decreasing the City's contribution to transit,service adjustments or identification of another transit funding source, Staff has reflected an increasing negative Proposition A fund balance in this version of the 2010 Model.Staff's draft FY10-11 budget includes a one-time General Fund backfill of $60,000 to the City's transit contribution,to provide time to develop a permanent solution for FY11-12. 2-8 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 9 of 11 13)Staff has included an assumption in the 201 0 Model,that the Beautification Fund will provide annual funding of about $165,000 for median maintenance.The Beautification Fund receives an annual $280,000 allocation of collector fees from the City's waste hauler.Without this funding source,the General Fund would have to backfill this right-of-way maintenance in the Street Maintenance Fund. Beautification revenue also provides funding for periodic median improvement projects in the City's arterial roadways,as well as beautification grants to neighborhoods. 14)Currently,the City Council's reserve policy includes a requirementto keep one year of Portuguese Bend road maintenance costs (through the landslide area)on reserve in the Street Maintenance Fund.Due to increased landslide activity,the cost of maintenance to keep Palos Verdes Drive South in a drivable condition has increased from about $380,000 to about $450,000 annually.Staff's Proposed FY10- 11 Budget also includes a one-time allocation of $50,000 to study long-term solutions to this consistent road maintenance problem.Staff believes that keeping one year of maintenance costs on reserve at the higher level may be unnecessary. 15)In 1980,the Cities of Rancho Palos Verdes and Rolling Hills Estates entered into an agreement for Rolling Hills Estates to maintain certain right-of-way areas within the borders of Rancho Palos Verdes and to share sales tax revenue from the Peninsula Shopping Center.The agreement expired on March 25,2010.No sales tax revenue from Rolling Hills Estates has been included in the 2010 Model. Placeholders in the amounts of $33,000 for right of way maintenance and $13,000 for pavement striping have been included within the Street Maintenance budget (i.e. traffic signal and median maintenance)and General Fund Traffic Management budgets,respectively. 16)On May 4,2010,City Council approved a $1.5 million appropriation from General Fund Reserves to payoff the City's pension liability (referred to as the side-fund liability).The liability currently accrues interest at a rate of 7.75%,and is amortized through FY23-24.The City's expected FY1 0-11 interest earnings rate on idle cash is 0.5%.Liability payments are set at 2.939%of the City's covered payroll.As a result of this payment,pension costs are expected to decrease by about $150,000 annually.Staff has included expected future savings in the five years of the 2010 Model. 17)Due to losses in the CalPERS investment portfolio during 2007-2009,the actuary has estimated that the City's contribution rate will increase by 1.337%of covered payroll in FY11-12 (a 7%or roughly $71,000 increase in the City's pension cost). 18)Beginning in FY09-10,the City Council included an appropriation in the General Fund budget to provide park ranger service in the City's open space preserve.The original program concept included hiring 3 part-time park ranger employees,and providing training and equipment.On December 1,2009,the City Council approved an agreement with Mountains Recreation &Conservation Authority to provide contracted park ranger services in lieu of hiring part-time employees.The two-year 2-9 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 10 of 11 budget document included approximately $86,000 annually for this program; however,the estimated cost of the contracted services for FY10-11 is about $115,000.The additional cost has been added to the Public Safety Special Programs expenditure line-item in the General Fund. 19)On December 30,2009,the City acquired 191 acres of open space known as the Upper Filiorum property.The annual operating cost for the additional open space is currently estimated to be about $47,000,and includes brush removal for fire hazard mitigation and Abalone Cove Landslide Abatement District (ACLAD)dues.This estimated cost has been added to the Park Maintenance expenditure program in the General Fund. 20)On September 15,2009,the City Council approved a $419,087 use of the CIP emergency project reserve to make a contribution to the Upper Filiorum open space purchase.Staff expects that FY09-1 0 project savings will temporarily increase the CIP reserve above the policy threshold;but those savings are needed to provide funding for planned FY10-11 and FY11-12 projects. 21 )The 2010 Model indicates that the fund balance of the Improvement Authority's Abalone Cove fund will steadily decrease over the five years of the Model.The decrease is due to a commitment to fund a portion of the Abalone Cove Landslide Abatement District (ACLAD).Staff expects that after FY11-12,interest income on the non-expendable $1,000,000 portion of the fund balance will not be sufficient to pay for both estimated annual expenditures and a $60,000 annual contribution to ACLAD. 22)Staff has included a partial return of General Fund money originally deposited to the Utility Undergrounding Fund in FY01-02.The purpose of the fund was to provide for the cost of the initial engineering study when neighborhoods have a desire to assess themselves to pay for undergrounding of utility lines.To date,no neighborhoods have taken advantage of this program.Therefore,Staff recommends returning $90,000 to the General Fund in FY10-11 and another $90,000 in FY11-12.The Utility Undergrounding Fund will maintain a balance of more than $100,000 after FY11-12,an amount sufficient to advance engineering costs associated with a development of an undergrounding assessment district. 23)Marymount College is currently circulating a petition for a ballot measure.If enough signatures are gathered and the initiative qualifies for the ballot,the City's General Fund will bear the cost for a November 2010 Special Election.If the initiative qualifies,then the estimated cost of $78,000 for the Special Election will be added to the 2010 Model. In a related matter,on May 4,2010,the City Council directed Staff to prepare the appropriate resolutions that would include a provision to design a center median safety barrier along Palos Verdes Drive East,adjacent to the proposed athletic filed on the ocean-side of the campus.Even if the City Council proceeds to approve the construction of the barrier,the timing and cost has not yet been determined,but 2-10 DRAFT 2010 FIVE-YEAR FINANCIAL MODEL May 22,2010 Page 11 of 11 would likely require a one-time payment from the General Fund Reserve matched with a $200,000 contribution offered by Marymount. 24)In September 2008,the City Council authorized the Annenberg Foundation to begin the entitlement process for the proposed animal education center project at Lower Point Vicente Park,as identified in the City's Vision Plan.This approval provided the green light for the Foundation to begin the application process. This projeCt is expected to be submitted to the Planning Commission for potential approval in September 2010.No expenditures or revenues associated with this project have been included in the 2010 Model at this time;however,facility operations are expected to be cost neutral to the City. 25)On March 17,2009,the City Council/Redevelopment Agency (RDA)Board approved a Disposition and Development Agreement with AMCAL Mirandela Fund, L.P.(AM CAL)for an affordable housing project.The City's commitment to the project includes a transfer of the RDA-owned Crestridge property,a pre- development loan of $200,000,and construction financing of $3.6 million.The $3.6 million construction loan is to be financed with about $1.8 million transferred from the City's Affordable Housing In-Lieu Fund,and another $1.8 million from the RDA's Housing Set-Aside accumulated fund balance.Up to about $0.3 million of the $3.6 million construction financing commitment will be funded with the FY1 0-11 allocation of RDA Housing Set-Aside tax increment. 26)Currently,the RDA Debt Service Fund is repaying county bonds and deferred interest debt to the county.Staff expects the deferred interest debt will be paid off by the end of FY12-13.It is also expected that the RDA will begin repaying the long- term advance from the City at that time.The estimated June 30,2010 balance of that advance is $17.7 million dollars.The annual amount available for repayment of the advance is expected to be about $400,000,which would be repaid to the City's General Fund.This repayment is not currently reflected in the 2010 Model. 2-11 CITY OF RANCHO PALOS VERDES 2010 FIVE·YEAR FINANCIAL MODEL EXHIBIT A Fund Balance 0·11 Estimated Resource 0-11 Estimated ADDroDriation~Fund Bal Fund Bal Fund Bal Fund Bal Fund Bal Fund 6/30/2010 Revenues Transfers In EXDenditures Transfers Out 6/30/2011 6/30/2012 6/30/2013 6/30/2014 6/30/2015 Unrestricted GENERAL 10,594,554 21,713,200 353,000 (17,768,192)(4,289,852)10,602,710 11,238,710 13,100,210 15,537,010 18,229,710 Restricted by Council Action BEAUTIFICATION FUND 621,170 299,110 -(96,814)(415,200)408,266 445,776 237,296 274,586 63,706 RPV TV FUND 1,696 1,010 85,000 (86,432)-1,274 3,394 3,274 884 824 CIP 3,487,133 930,680 4,113,275 (5,499,200)-3,031,888 2,898,488 2,951,488 3,035,088 3,139,488 UTILITY UNDERGROUNDING 277,870 1,390 - --189,260 101,720 104,210 107,810 112,180 ROADWAY BEAUTIFICATION 103,053 520 - --103,573 104,923 107,493 111,203 115,703 EQUIPMENT REPLACEMENT 1,882,758 56,900 -(243,700)-1,695,958 1,657,958 1,636,858 1,630,058 1,631,058 BUILDING REPLACEMENT 830,851 4,200 -(34,500)-800,551 810,951 830,851 859,551 894,351 EMPLOYEE BENEFITS 4 1,826,363 -(1,804,560)-21,807 22,087 22,627 23,407 24,357 Subtotal 7,204,535 3,120,173 4,198,275 (7,765,206)(415,200)6,252,577 6,045,297 5,894,097 6,042,587 5,981,667 Restricted by Law or External Agencies STREET MAINTENANCE 403,055 1,138,970 973,600 (2,158,674)-356,951 313,291 319,871 326,411 331,931 1972 ACT 48,018 258,927 -(70,300)(204,000)32,645 17,686 3,848 990 964 EL PRADO LIGHTING 2,168 1,920 -(1,000)-3,088 4,078 5,168 6,378 7,708 CDBG 44,000 218,146 -(262,146)-0 0 0 0 0 1911 ACT 1,560,007 500,600 -(506,900)(104,100)1,449,607 1,342,507 1,243,307 1,147,807 1,048,007 WASTE REDUCTION 123,787 180,620 -(163,939)(12,000)128,468 131,338 133,158 133,848 132,768 AIR QUALITY MANAGEMENT 53,376 50,070 -(50,000)-53,446 53,936 55,056 56,756 58,856 PROPOSITION C 1,303,320 843,870 - - (500,300)1,646,890 2,400 364,560 726,940 1,067,580 PROPOSITION A 71,917 577,214 60,000 (706,000)-3,131 (136,812) (287,652) (449,547) (622,757) PUBLIC SAFETY GRANTS 905 100,000 - - (100,000)905 915 935 965 1,005 HABITAT RESTORATION 201,189 1,010 109,900 (126,411)-185,688 171,098 157,888 145,538 133,128 SUBREGION 1 MAINTENANCE 6,636 3,800 70,000 (79,000)-1,436 4,936 5,336 1,436 4,736 MEASURE A 33,928 151,170 --(151,000)34,098 34,538 35,388 36,608 13,088 ABALONE COVE SEWER DISTRICT 56,476 46,840 10,700 (63,206)-50,810 44,660 38,290 31,320 23,390 GINSBURG CULTURAL ARTS BUILDING 208,103 1,040 - - -209,143 211,863 217,053 224,543 233,633 RECREATION IMPROVEMENTS DONATION 2,082 10 - --2,092 2,122 2,172 2,242 2,332 QUIMBY 25,170 130 - --25,300 25,630 26,260 27,170 28,270 AFFORDABLE HOUSING IN LIEU 7,975 40 ---8,015 8,115 8,315 8,605 8,955 ENVIRONMENTAL EXCISE TAX 40,793 38,800 --(40,000)39,593 40,103 41,083 42,503 44,223 BIKEWAYS -17,223 --(17,223)0 0 0 0 0 WATER QUALITY &FLOOD PROTECTION 422,254 1,253,689 -(1,418,618)-257,325 322,924 258,323 736,726 1,333,050 RDA HOUSING SET ASIDE 710,376 215,000 -(278,957)-646,419 847,519 1,068,119 1,313,119 1,584,219 RDA DEBT SERVICE 613,276 1,730,700 -(1,798,835)-545,141 476,922 414,698 755,323 1,115,598 RDA -PORTUGUESE BEND 517,266 2,590 -(31,366)-488,490 462,540 440,670 421,770 403,750 RDA -ABALONE COVE 6,261 30 - --6,291 6,371 6,531 6,761 7,031 IMPROV AUTH -PORTUGUESE BEND 205,733 1,030 101,000 (141,700)-166,063 126,423 86,923 46,423 3,503 IMPROV AUTH -ABALONE COVE 293,555 6,500 -(109,490)-190,565 95,240 69,959 53,420 41,222 Subtotal 6,961,626 7,339,939 1,325,200 (7,966,542)11,128,623\6,531,600 4,610,344 4,715,260 5,804,055 7,006,190 GRAND TOTAL 24,760,715 32,173,312 5,876,475 (33,499,940)(5,833,675)23,386,887 21,894,350 23,709,566 27,383,651 31,217,566 2 - 1 2 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~FY09-10 ....... •••••••>~ •••••••••••••••••••••••%Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase ECONOMIC MODEL INPUT FACTORS la-m!: Increase Factor (%)RevenueslProperty Assessments (a)N/A N/A N/A N/A N/A 1.8%2.0% 2.0% 2.0% 2.0% Increase Factor (%)Expenditures (b)N/A N/A NlA N/A N/A 2.0%2.9% 2.6% 2.6% 2.8% Consumer Price Index (%)(c)N/A N/A N/A N/A N/A 1.9%1.3% 1.2% 1.2%1.5% Sales Tax (%)(d)N/A N/A NlA N/A N/A 0.0%1.3% 1.2%1.2% 1.5% Property Taxes (%)(e)N/A N/A N/A N/A N/A 0.5%3.0% 3.5%4.0% 4.5% Sheriff Contract (%)(f)N/A N/A NlA NlA N/A 2.0%3.0% 3.0% 3.0%3.0% Planning Permit Revenues (%)(g)N/A N/A N/A N/A N/A 0.0%4.8%4.7% 4.7%5.0% Building and Safety Revenues (%)(h)N/A N/A N/A N/A N/A 0.0%4.8% 4.7%4.7%5.0% Vehicle License Fee (VLF)(%)(i)N/A N/A N/A N/A N/A 0.0%0.0%0.0% 0.0%0.0% Street Main!.and Prop A &C Revenues (%)(j)N/A N/A N/A N/A N/A 0.0%0.0% 0.0% 0.0%0.0% Property Transfer Tax (%)(k)N/A N/A N/A N/A N/A -13.0%2.0% 2.0% 2.0%2.0% Transient Occupancy Tax(%)(I)N/A N/A N/A N/A N/A 0.0%0.0%0.0%0.0%0.0% Investment Interest (%)(m)N/A N/A N/A N/A N/A 0.5%1.3%2.5%3.5%4.1% Utility Users Tax (%)(n)N/A N/A N/A NlA N/A 0.4%1.3%1.2%1.2% 1.5% Franchise Tax (%)(0)N/A N/A N/A NlA N/A 0.5%1.3% 1.2%1.2%1.5% Facility Rentals (%)(p)N/A N/A N/A NlA N/A -3.0%1.3% 1.2%1.2% 1.5% 2 - 1 3 'UF ENDING UNRESERVED FUND BALANCES CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ ;1' ~ ESTIMATE FY09·10 UNRESTRICTED FUND I (101)General Fund ,..!.4 12,171,332 RESTRICTED BY COUNCIL ACTION o 10,440,256 10,440,256 10,594,554 10,602,710 11,238,710 13,100,210 15,537,010 18,229,710 (212)Beautification Fund,!,'.1,327,191 I 916,507 I 1,367,251 I 450,7441 621,1701 408,266 I 445,776 I 237,296 I 274,586 I 63,706 RESTRICTED BY LAW OR EXTERNAL AGENCIES City Funds (202)Street Maintenance Fund (203)1972 Act Landscape &Lighting Fund (209)EI Prado Lighting Fund (310)CDBG Fund (211)1911 Act Street Lighting Fund (213)Waste Reduction Fund (214)Air Quality Management Fund (215)Proposition C (StreetslTransit)Fund (216)Proposition A (Transit)Fund (217)Public Safety Grants (222)Habitat Restoration Fund (223)Subregion 1 Maintenance Fund (224)Measure A Cap.&Main!.Funds (225)Aibalone Cove Sewer District Fund (227)Ginsburg Cultural Arts Building Fund (228)Recreation Improvements Donations Fund (334)Quimby Fund (337)Affordable Housing In-Lieu Fund (338)Environmental Excise Tax (EET)Fund (340)Bikeways (TDA Article 3)Fund (501)Water Quality &Flood Protection Fund RDA &Improvement Authority Funds (218)RDA Housing Set -Aside (410)RDA Debt Service Fund (375)RDA·Portuguese Bend Fund (380)RDA -Aibalone Cove Fund (285)Improvement Authority -Portuguese Bend (795)Improvement Authority -Abalone Cove SUBTOTAL GRAND TOTAL·ALL FUNDS INCLUDED C4it' <·w 578,589 47,305 9,572 (17) 1,591,701 319,550 52,197 1,976,356 223,971 65,200 233,257 760 9,405 117,713 492,045 2,048 24,754 1,155,231 824,223 5,198 7,740,008 2,561,059 481,602 499,259 6,052 227,645 371,281 19,615,964 417,098 57,478 10,702 (17) 1,444,901 175,930 53,507 178,385 287,778 33,635 190,580 1,860 305 69,823 504,245 2,048 12,064 843,299 830,768 o 1,695,231 1,409,752 (417,257) 483,859 6,202 187,925 297,405 8,777,506 424,481 58,659 11,138 (6) 1,632,607 174,105 52,776 2,564,999 197,694 34,540 225,180 17,336 33,928 93,594 500,503 2,082 25,170 838,333 839,293 o 2,108,364 2,067,751 603,677 541,041 6,171 231,613 362,231 13,647,260 7,383 1,181 436 11 187,706 (1,825) (731) 2,386,614 (90,084) 905 34,600 15,476 33,623 23,771 (3,742) 34 13,106 (4,966) 8,525 o 413,133 657,999 1,020,934 57,182 (31) 43,688 64,826 4,869,754 403,055 48,018 2,168 44,000 1,560,007 123,787 53,376 1,303,320 71,917 905 201,189 6,636 33,928 56,476 208,103 2,082 25,170 7,975 40,793 o 422,254 710,376 613,276 517,266 6,261 205,733 293,555 6,961,626 356,951 32,645 3,088 o 1,449,607 128,468 53,446 1,646,890 3,131 905 185,688 1,436 34,098 50,810 209,143 2,092 25,300 8,015 39,593 o 257,325 646,419 545,141 488,490 6,291 166,063 190,565 6,531,600 313,291 17,686 4,078 o 1,342,507 131,338 53,936 2,400 (136,812) 915 171,098 4,936 34,538 44,660 211,863 2,122 25,630 8,115 40,103 o 322,924 847,519 476,922 462,540 6,371 126,423 95,240 4,610,344 319,871 3,848 5,168 o 1,243,307 133,158 55,056 364,560 (287,652) 935 157,888 5,336 35,388 38,290 217,053 2,172 26,260 8,315 41,083 o 258,323 1,068,119 414,698 440,670 6,531 86,923 69,959 4,715,260 326,411 990 6,378 o 1,147,807 133,848 56,756 726,940 (449,547) 965 145,538 1,436 36,608 31,320 224,543 2,242 27,170 8,605 42,503 o 736,726 1,313,119 755,323 421,770 6,761 46,423 53,420 5,804,055 331,931 964 7,708 o 1,048,007 132,768 58,856 1,067,580 (622,757) 1,005 133,128 4,736 13,088 23,390 233,633 2,332 28,270 8,955 44,223 o 1,333,050 1,584,219 1,115,598 403,750 7,031 3,503 41,222 1,006,190 2 - 1 4 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!ESTIMATE FYOgc10 GENERAL FUND REVENUE DETAIL TAXES: Property taxes (e)5,632,664 5,945,600 5,855,099 (90,501)5,924,893 6,239,417 6,426,600 6,651,500 6,917,600 7,228,900 Property laxes In-Lieu of VLF Revenues (e)3,210,504 3,405,000 3,388,494 (16,506)3,428,500 3,490,200 3,594,900 3,720,700 3,869,500 4,043,600 Property taxes In-Lieu of Sales Tax (e)320,839 288,400 301,454 13,054 301,500 310,500 319,800 331,000 344,200 359,700 Sales and use lax (d)1,076,534 1,127,400 1,060,220 (67,180)1,211,767 1,190,400 1,205,300 1,219,200 1,233,800 1,252,300 Property transfer lax (k)240,572 198,900 178,813 (20,087)207,100 180,000 183,600 187,300 191,000 194,800 Business license lax/Application processing (c)499,014 521,800 531,982 10,182 515,600 520,800 527,300 533,400 539,800 547,900 Transienl occupancy lax (I)26,076 32,100 85,245 53,145 1,826,100 2,026,100 2,026,100 2,026,100 2,026,100 2,026,100 Franchise laxes (0)1,598,644 1,603,200 1,709,009 105,809 1,719,715 1,726,000 1,747,600 1,767,700 1,788,900 1,815,700 UIilily user lax (n)2,329,282 2,354,700 2,267,431 (87,269)2,448,800 2,461,800 2,492,600 2,521,300 2,551,600 2,589,900 Golf lax (c)356,963 333,000 278,343 (54,657)333,000 336,300 340,500 344,400 348,500 353,700 TolalTaxes 15,291,092 15,810,100 15,656,090 (154,010)17,916,975 18,481,517 18,864,300 19,302,600 19,811,000 20,412,600 LICENSES AND PERMITS: Animal control fees (a)50,929 60,000 45,810 (14,190)55,000 58,600 59,800 61,000 117,200 63,400 Righi of way &parking permils (h)51,478 49,800 39,819 (9,981)63,800 59,026 61,800 64,700 67,700 71,100 Building and safety permils &geology fees (h)1,446,761 1,184,950 1,2711,568 93,618 691,080 978,416 1,024,900 1,072,600 1,123,000 1,179,200 Planning permits (g)325,396 362,763 367,545 4,782 1,116,120 643,141 883,200 924,300 967,700 1,016,100 Filmpermils (c)38,629 33,900 21,408 (12,492)66,100 50,000 50,600 51,200 51,800 52,600 Massage Permits 349 500 1,537 1,037 0 0 0 0 0 0 Tolal Licenses &Permits 1,913,542 1,691,913 1,754,687 62,774 1,992,100 1,989,183 2,080,300 2,173,800 2,327,400 2,382,400 FINES &FORFEITURES: Miscellaneous court fines (a)251,739 228,800 205,635 (23,165)205,400 203,600 207,700 211,900 216,100 220,400 False alarm fines (a)7,900 12,800 8,265 (4,535)13,100 13,400 13,700 14,000 14,300 14,600 Tolal Fines &Forfeilures 259,639 241,600 213,900 (27,700)218,500 217,000 221,400 225,900 230,400 235,000 USE OF MONEY &PROPERTY: Property &Monopole Leases (c)181,376 179,600 158,019 (21,581)180,500 127,300 99,700 100,800 102,000 103,500 Facility renlals -PVlC (p)166,072 177,350 181,534 4,184 176,800 180,000 182,300 184,400 186,600 189,400 Facility renlals -Other (p)150,456 119,100 130,699 11,599 111,900 105,000 106,300 107,500 108,800 110,400 Parking 101 fees 43,522 42,800 43,857 1,057 43,500 43,500 43,500 43,500 43,500 43,500 PVlC giflshop (c)99,989 72,000 80,272 8,272 97,400 98,100 99,300 100,400 101,600 103,100 Inleresl earnings (m)590,139 222,500 266,124 43,624 90,100 65,000 150,800 299,800 486,500 669,700 Tolal Use of Money &Property 1,231,554 813,350 860,505 47,155 700,200 618,900 681,900 836,400 1,029,000 1,219,600 CHARGES FOR SERVICES: Recreation fees-REACH (c)8,338 8,900 8,863 (37)8,900 0 0 0 0 0 Sale of Signs/Services (c)7,746 6,500 4,618 (1,882)6,500 6,600 6,700 6,800 6,900 7,000 Inlerfund charges for services (a)141,200 145,300 145,300 0 148,200 151,200 154,200 157,300 160,400 163,600 Tolal Charges For Services 157,284 160,700 158,781 (1,919)163,600 157,800 160,900 164,100 167,300 170,600 REVENUES FROM OTHER AGENCIES Molar vehicle license fees (I)195,987 172,500 147,904 (24,596)140,000 140,000 140,000 140,000 140,000 140,000 Granl income 361,104 50,000 4,797 (45,203)62,972 75,000 15,000 15,000 15,000 15,000 Tolal Revenues From Other Agencies 557,091 222,500 152,701 (69,799)202,972 215,000 155,000 155,000 155,000 155,000 OTHER REVENUES: Donations (a)14,429 14,500 37,182 22,682 14,800 14,900 15,200 15,500 15,800 16,100 Other miscellaneous (a)123,307 75,900 82,314 6,414 20,400 18,900 19,300 19,700 20,100 20,500 Tolal Other Revenues 137,736 90,400 119,496 29,096 35,200 33,800 34,500 35,200 35,900 36,600 TOTAL GENERAL FUND REVENUES 19,547,938 19,030,563 18,916,160 (114,403)21,229,547 21,713,200 22,198,300 22,893,000 23,756,000 24,611,800 2 - 1 5 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!_~-~~~FY09-10_............... GENERAL FUND EXPENDITURE DETAIL City Council (b)90,176 116,800 104,015 12,785 97,378 95,935 98,700 101,300 103,900 106,800 City Manager (b)1,418,444 1,268,530 1,266,989 1,541 1,533,856 1,585,377 1,574,500 1,615,300 1,657,000 1,703,100 City Attomey (b)636,261 1,065,200 1,000,542 64,658 1,165,000 1,065,000 1,095,800 1,124,200 1,153,200 1,185,300 City Clerk (b)367,060 282,530 276,389 6,141 387,463 278,449 384,800 300,100 407,600 418,900 Community Outreach (b)133,743 156,550 143,350 13,200 100,650 100,650 103,600 106,300 109,000 112,000 Personnel (b)101,621 249,273 179,084 70,189 211,583 206,669 215,800 221,400 227,100 233,400 Finance (b)901,287 1,063,042 1,053,750 9,292 1,242,180 1,284,770 1,346,400 1,381,300 1,416,900 1,456,300 Information Technology -Data (b)559,447 776,310 705,669 70,641 568,340 628,967 650,600 667,500 684,700 703,700 Information Technology -Voice (b)54,466 115,320 65,399 49,921 81,705 92,970 95,700 98,200 100,700 103,500 Total Administration 4,262,505 5,093,555 4,795,187 298,368 5,388,155 5,338,787 5,565,900 5,615,600 5,860,100 6,023,000 Public Safety -sheriff (f)3,809,634 4,000,150 3,941,881 58,269 3,981,750 3,994,087 4,113,900 4,237,300 4,364,400 4,495,300 Special Programs (b)51,Q43 86,365 71,934 14,431 70,000 172,545 177,500 182,100 186,800 192,000 Animal Control (b)103,239 154,677 117,926 36,751 125,250 115,250 118,600 201,700 124,800 128,300 Emergency Preparedness (b)64,909 81,178 69,229 11,949 114,177 99,845 107,300 110,100 112,900 116,000 Total Public Safety 4,028,825 4,322,370 4,200,970 121,400 4,291,177 4,381,727 4,517,300 4,731,200 4,788,900 4,931,600 Public Works Administration (b)645,576 1,107,096 1,087,341 19,755 1,636,021 1,887,585 1,994,300 2,046,000 2,098,800 2,157,100 Sewer Maintenance (b)35,785 102,480 102,344 136 115,300 61,300 63,100 64,700 66,400 68,200 Traffic Management (b)244,247 364,063 291,539 72,524 293,600 277,400 285,400 292,800 300,400 308,800 Storm Water Quality (NPDES Compliance)(b)133,112 147,700 146,800 900 173,900 149,600 153,900 157,900 162,000 166,500 Public Building Maintenance (b)592,620 648,703 576,573 72,130 484,194 597,075 622,200 638,300 654,800 673,000 Parks Maintenance (b)660,472 984,452 829,796 154,656 1,184,893 1,316,249 1,354,300 1,389,400 1,425,200 1,464,800 Total Public Works 2,311,812 3,354,494 3,034,393 320,101 3,887,908 4,289,209 4,473,200 4,589,100 4,707,600 4,838,400 Planning (b)1,209,395 1,315,870 1,315,607 263 1,394,944 1,265,019 1,335,500 1,370,100 1,405,400 1,444,500 Building &Safety Services (b)694,989 555,140 519,945 35,195 615,177 587,384 621,700 637,800 654,300 672,500 Code Enforcement (b)149,160 210,990 177,141 33,849 201,658 190,894 200,900 206,100 211,400 217,300 View RestorationlPreservation (b)198,433 255,980 193,154 62,826 326,288 321,076 335,600 344,300 353,200 363,000 NCCP (b)45,538 46,450 45,581 869 0 0 0 0 0 0 Geology (b)176,748 200,000 160,722 39,278 200,000 200,000 205,800 211,100 216,500 222,500 Total Planning 2,474,263 2,584,430 2,412,150 172,280 2,738,067 2,564,373 2,699,500 2,769,400 2,840,800 2,919,800 Recreation administration (b)466,639 496,030 491,510 4,520 629,756 374,647 398,300 408,600 419,100 430,800 Recreation Facilities (b)349,255 374,790 350,404 24,386 430,296 448,178 470,800 483,000 495,500 509,300 Special events (b)26,629 104,670 86,667 18,003 40,904 40,980 42,200 43,300 44,400 45,600 PVIC (b)346,861 355,070 334,067 21,003 330,331 330,291 353,100 362,200 371,500 381,800 REACH (b)92,145 103,700 91,283 12,417 74,672 0 6,300 6,500 6,700 6,900 Total Recreation 1,281,529 1,434,260 1,353,931 80,329 1,505,959 1,194,096 1,270,700 1,303,600 1,337,200 1,374,400 TOTAL GENERAL FUND EXPENDITURES 14,358,934 16,789,109 15,796,631 992,478 17,811,266 17,768,192 I 18,526,600 II 19,008,900 II 19,534,600 I 20,087,200 GENERAL FUND NET BEFORE TRANSFERS 5,189,004 2,241,454 3,119,529 878,075 3,418,281 3,945,008 I 3,671,700 II 3,884,100 II 4,221,400 I 4,524,600 I I 2 - 1 6 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!"'MA>E~~FY09·10 GENERAL FUND TRANSFER DETAIL GENERAL FUND TRANSFERS IN: From CDBG fund -Reach 28,574 20,646 20.646 0 26.848 0 0 0 0 0 From Measure A Maint 100.599 75,900 54.200 (21.700)151,000 151,000 151,000 151,000 151,000 151.000 From Public Safety Grants fund 100,000 100,000 100,000 0 100.000 100,000 100,000 100.000 100.000 100,000 From Waste Reduction 0 7,000 0 (7.000)12.000 12,000 12,000 12.000 12,000 12.000 From Utility Undergrounding 0 0 0 0 0 90,000 90,000 0 0 0 From Proposition A 2,600 2.700 2,700 0 2,800 0 0 0 0 0 Total General Fund Transfers In I 231,773 1 206.2461 177.5461 (28,700)1 292,8481 353.000 II 353.000 II 263,000 II 263,000 I 263,000 GENERAL FUND TRANSFERS OUT: To CIP fund 1,482.711 4,531.571 4,531.571 0 1,416,000 3,806.052 2,927.800 1,752,800 1,482,800 1,482,800 ToCDBG 0 0 0 0 44,006 0 0 0 0 0 To Improvement Authority PB (b)14,000 91,500 82.252 9.248 110,000 101,000 104.000 107,000 110.000 113.000 To Improvement Authority AC 6,000 0 0 0 0 0 0 0 0 0 To Abalone Cove Sewer District 80,700 10,700 10,700 0 10.700 10,700 10,700 10.700 10.700 10,700 To Habitat Restoration 115,000 115,000 115,000 0 169,000 109,900 113,100 116.000 119,000 122.300 To Subregion 1 Maintenance Fund 30,000 55,000 55,000 0 55.000 70.000 65,000 55.000 45,000 50,000 To Street Maintenance fund (PB Road Maint)206,000 212.180 212,180 0 0 0 0 0 0 0 To Street Maintenance fund 239,000 242.845 242,845 0 22,000 0 30.000 105,000 140,000 170,000 To Proposition A fund 0 0 0 0 0 60,000 0 0 0 0 To RPVlV 135.040 54.590 54,590 0 90,000 85.000 90.000 90,000 90,000 95,000 To Building Replacement fund 46.725 0 0 0 0 0 0 0 0 0 To Employee Benefits 0 0 0 0 1,594.125 0 0 0 0 0 To RDA Debt Service fund 0 67,902 0 67,902 45,800 47,200 48,100 49.100 50.100 51.100 To Water Quality and Flood Protection Fund 4,719,193 0 0 0 0 0 0 0 0 0 Total General Fund Transfers Out 7.074,369 I 5.381,28811 5,304,13811 77,150 I 3,556,631 I 4,289,8521 3.388,700 I 2,285.600 II 2,047,6001 2,094,900 I I Net Activity (1.653,592)I (2.933.588)11 (2,007,063)11 772,2251 154,2981 8.15611 636,000 II 1,861.500 II 2,436.8001 2,692.700 I I I I 2 - 1 7 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B =d1_~nMA~~~FY09-10_..... GENERAL FUND SUMMARY Beginning Fund Balance 21,747,929 20,094,337 20,094,337 0 18,087,274 18,241,572 18,249,728 18,885,728 20,747,228 23,184,028 Plus:Revenues 19,547,938 19,030,563 18,916,160 (114,403)21,229,547 21,713,200 22,198,300 22,893,000 23,756,000 24,611,800 Less:Expenditures (14,358,934)(16,789,109)(15,796,631)992,478 (17,811,266) (17,768,192) (18,526,600) (19,008,900) (19,534,600) (20,087,200) Plus:Transfers In 231,773 206,246 177,546 (28,700)292,648 353,000 353,000 263,000 263,000 263,000 Less:Transfers Out (7,074,369)(5,381,288)(5,304,138)77,150 (3,556,631) (4,289,852) (3,388,700) (2,285,600) (2,047,600) (2,094,900) Ending Fund Balance 20,094,337 17,160,749 18,087,274 926,525 18,241,572 18,249,728 18,885,728 20,747,228 23,184,028 25,876,728 Less Fund Balance Reservations: PB &AC RDA Loans,Bond Restructuring 6,175,060 6,219,543 6,219,543 6,219,543 6,219,543 6,219,543 6,219,543 6,219,543 Encumbrances 0 0 0 0 0 0 0 0 Continuing Appropriations 1,277,915 1,333,300 1,333,300 1,333,300 1,333,300 1,333,300 1,333,300 1,333,300 Prepaid Items &Other 470,030 94,175 94,175 94,175 94,175 94,175 94,175 94,175 Available Fund Balance I 12,171 ,332/1 II 10,440,256/1 1 10,594,5541 10,602,710/1 11,238,710/1 13,100,210 II 15,537,010 I 18,229,710 Policy Reserve Threshold 9,773,969 I I 7,898,316 I I 8,905,633 I 8,884,096 9,263,300 9,504,450 9,767,300 10,043,600 surplus/(Deficit)Reserve vs.Policy Threshold 2,397,363 I I 2,541,941 I I 1,688,921 I 1,718,614 1,975,410 3,595,760 5,769,710 8,186,110 I I I I I 2 - 1 8 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B -:--~----ct I ESTIMATE FY09·10 BEAUTIFICATION FUND DETAIL fFund·2121 Revenues Beautification revenue (c)289,190 195,000 198,398 3,398 150,000 296,000 299,700 303,100 306,700 311,300 Interest earnings (m)49,720 22,300 22,672 372 12,900 3,110 5,310 10,920 8,190 11,120 Total Revenue I 338,910 II 217,300 II 221,070 II 3,770 I 162,900 I 299,110 II 305,010 II 314,020 II 314,890 I 322,420 Expenditures Personnel services (b)16,955 20,740 20,151 589 15,230 15,414 15,900 16,300 16,700 17,200 Beautification Grants 153,364 440,844 143,875 296,969 86,000 75,000 75,000 75,000 75,000 75,000 Operations &maintenance (b)4,100 6,200 4,200 2,000 6,300 6,400 6,600 6,800 7,000 7,200 Total Expenditures I 174,41911 467,78411 168,22611 299,5581 107,530 I 96,81411 97,500 II 98,100 II 98,700 I 99,400 I I BEAUTIFICATION FUND NET BEFORE TRANSFERS I 164,49111 (250,484)11 52,84411 303,3281 55,370 I 202,29611 207,510 II 215,920 II 216,190 I 223,020 Transfers Out To CIP fund 0 160,200 12,784 147,416 544,591 250,000 0 250,000 0 250,000 To Street Maintenance fund (median maintenance)0 0 0 0 256,860 165,200 170,000 174,400 178,900 183,900 Total Transfers Out I 011 160,200 II 12,78411 147,4161 801,451 I 415,200 II 170,000 II 424,400 II 178,900 I 433,900 BEAUTIFICATION FUND SUMMARY Beginning Fund Balance 1,162,700 1,327,191 1,327,191 0 1,367,251 621,170 408,266 445,776 237,296 274,586 Plus:Revenues 338,910 217,300 221,070 3,770 162,900 299,110 305,010 314,020 314,890 322,420 Less:Expenditures (174,419)(467,784) (168,226)299,558 (107,530)(96,814)(97,500)(98,100)(98,700) (99,400) Less:Transfers Out 0 (160,200)(12,784)147,416 (801,451) (415,200)(170,000) (424,400) (178,900) (433,900) Ending Fund Balance I 1,327,19111 916,50711 1,367,25111 450,7441 621,170 I 408,26611 445,77611 237,29611 274,5861 63,706 I I I I 2 - 1 9 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~FY09·10 '"i-' RPV TV (Fund·2261 Revenues Donations 0 1,000 0 (1,000)1,000 1,000 1,000 1,000 1,000 1,000 Interest earnings (m)3,754 150 192 42 160 10 20 80 110 40 Total Revenue I 3,75411 1,150 II 19211 (958)1 1,160 I 1,010 II 1,020 II 1,080 II 1,110 I 1,040 Expenditures Personnel services (b)5,375 14,290 16,990 2,700 30,250 31,132 32,000 32,800 33,600 34,500 ProfessionalfTechnical Services/Equipment (b)126,151 86,800 84,099 2,701 54,500 55,300 56,900 58,400 59,900 61,600 Total Expenditures 131,526 101,090 101,089 5,401 84,750 86,432 1 88,900 II 91,200 II 93,500 I 96,100 RPV TV FUND NET BEFORE TRANSFERS I (127,772)11 (99,940)11 (100,897)11 4,4431 (83,590)1 (85,422)11 (87,880)11 (90,120)11 (92,390)1 (95,060) I I I I I I Fund Transfer In I I I I I I From General Fund 135,040 I 54,590 I 54,590 I 01 90,000 I 85,000 I 90,000 90,000 90,000 95,000 Total Transfer In 1 135,040 II 54,590 II 54,590 II 01 90,000 I 85,000 II 90,000 II 90,000 II 90,000 I 95,000 RPVTVFUND SUMMARY: Beginning Fund Balance 34,325 41,593 41,593 0 (4,714)1,696 1,274 3,394 3,274 884 Plus:Revenues 3,754 1,150 192 (958)1,160 1,010 1,020 1,080 1,110 1,040 Less:Expenditures (131,526)(101,090) (101,089)1 (84,750)(86,432)(88,900)(91,200) (93,500)(96,100) Plus:Transfer In 135,040 54,590 54,590 0 90,000 85,000 90,000 90,000 90,000 95,000 Ending Fund Balance I 41,59311 (3,757)11 (4,714)11 (957)1 1,6961 1,27411 3,39411 3,27411 8841 824 I I I I I I 2 - 2 0 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~I <STIM"'~~~S CIP FUND DETAIL IFund-3301 Revenues Grant-Federal 756,822 0 1,400 1,400 2,462,000 0 625,000 0 0 0 Grant-State 715,373 892,620 640,620 (252,000)1,583,720 913,280 580,000 680,000 0 0 Miscellaneous revenues 0 0 17,803 17,803 5,950,000 0 0 0 0 0 Interest earnings (m)120,262 21,200 44,361 23,161 64,600 17,400 39,400 71,000 101,800 122,900 Total CIP Fund Revenue I 1,592,45711 913,820 II 704,16411 (209,636)1 10,060,320 I 930,680 II 1,244,400 II 751,000 II 101,800 I 122,900 I I 1 I Expenditures I I 1 I Total CIP Fund Expenditures (see Exhibit C)I 2,803,67511 2,262,081 II 1,501,47711 760,6041 18,118,701 I 5,499,200 II 6,362,800 II 2,718,000 II 1,518,200 I 1,793,500 I I 1 1 CIP FUND NET BEFORE TRANSFERS 1 (1,211,218)11 (1,348,261)11 (797,293)11 550,9681 (8,058,381)1 (4,568,520)11 (5,118,400)11 (1,967,000)11 (1,416,400)1 (1,670,600) Transfers In From General fund 1,482,711 4,531,571 4,531,571 0 1,416,000 3,806,052 2,927,800 1,752,800 1,482,800 1,482,800 From Measure A CapitaVMaintenance fund 0 0 21,700 21,700 10,913 0 0 0 0 0 From Proposition C fund 237,527 2,408,671 0 (2,408,671)1,409,230 0 2,040,000 0 0 25,000 From Proposition A fund 15,000 15,500 12,450 (3,050)0 0 0 0 0 0 From Recreation Improvements Donations fund 0 0 0 0 600,000 0 0 0 0 0 From Bikeways fund 80,000 32,000 30,002 (1,998)25,000 17,223 17,200 17,200 17,200 17,200 From EET fund 0 29,000 0 (29,000)332,600 40,000 0 0 0 0 From Beautification fund 0 160,200 12,784 (147,416)544,591 250,000 0 250,000 0 250,000 Total Transfers In I 1,815,23811 7,176,94211 4,608,50711 (2,568,435)1 4,338,3341 4,113,27511 4,985,000 II 2,020,000 II 1,500,000 I 1,775,000 1 I I I Transfers Out 0 0 01 01 01 0 0 01 0 0 Total Transfers Out 1 011 011 011 01 01 011 011 011 01 0 CIP FUND SUMMARY Beginning Fund Balance 2,791,946 3,395,966 3,395,966 0 7,207,180 3,487,133 3,031,888 2,898,488 2,951,488 3,035,088 Plus:Revenues 1,592,457 913,820 704,184 (209,636)10,060,320 930,680 1,244,400 751,000 101,800 122,900 Less:Expenditures (2,803,675) (2,262,081) (1,501,477)760,604 (18,118,701)(5,499,200) (6,362,800)(2,718,000) (1,518,200)(1,793,500) Plus:Transfers In 1,815,238 7,176,942 4,608,507 (2,568,435)4,338,334 4,113,275 4,985,000 2,020,000 1,500,000 1,775,000 Plus:Transfers Out 0 0 0 0 0 0 0 0 0 0 Fund Balance I 3,395,96611 9,224,64711 7,207,180 II (2,017,467)1 3,487,1331 3,031,88811 2,898,48811 2,951,48811 3,035,088 1 3,139,488 Emergency Reserve +Reserve for FEMA revenue received for disaster projects not yet closed 3,274,430 3,274,430 3,274,430 3,274,430 3,274,430 3,274,430 Available Fund Balance 212,703 (242,542) (375,942)(322,942)(239,342)(134,942) 2 - 2 1 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~FY09·10 %$»_ UTILITY UNDERGROUNDING FUND DETAIL (Fund· 3411 Revenues Interest earnings (m)10,744 6,800 4,529 (2,271)4,100 1,390 2,460 2,490 3,600 4,370 Total Revenue I 10,74411 6,800 II 4,52911 (2,271)'4,100 ,1,390 II 2,460 II 2,490 II 3,600 I 4,370 1 1 1 Expenditures I 1 1 ProfessionaVfechnical Services 0 0 0 0 01 0 01 01 0 0 Total Expenditures I 011 011 011 0'0'011 011 011 01 0 I I 1 1 UTILITY UNDERGROUNDING FUND NET BEFORE I 10,74411 6,800 II 4,52911 (2,271)1 4,100 I 1,390 II 2,460 II 2,490 II 3,600 ITRANSFERS 4,370 1 1 1 Fund Transfer In I I 1 From General Fund 0 0 0 01 01 0 0 01 0 0 Total Transfer In I 011 011 011 0'0'011 011 011 01 0 1 1 1 Transfer Out to General Fund 01 0 0 01 01 90,000 90,000 0 0 0 Total Transfer Out I 011 011 011 0'0'90,000 II 90,000 II 011 01 0 UTILITY UNDERGROUNDING FUND SUMMARY: Beginning Fund Balance 258,497 269,241 269,241 0 273,770 277,870 189,260 101,720 104,210 107,810 Plus:Revenues 10,744 6,800 4,529 (2,271)4,100 1,390 2,460 2,490 3,600 4,370 Less:Expenditures 0 0 0 0 0 0 0 0 0 0 Plus:Transfer In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 (90,000) (90,000)0 0 0 Ending Fund Balance I 269,24111 276,04111 273,770 II (2,271>1 277,870 ,189,260 II 101,720 II 104,210 II 107,810 I 112,180 1 1 1 1 1 1 1 1 1 1 2 - 2 2 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~~~~FY09-10 ............> ROADWAY BEAUTIFICATION FUND DETAIL (Fund- 342) Revenues Interest earnings (m)3,986 2,500 1,678 (822)1,500 520 1,350 2,570 3,710 4,500 Total Revenue I 3,98611 2,500 II 1,67811 (822)1 1,5001 520 II 1,350 II 2,570 II 3,710 I 4,500 1 1 1 Expenditures 1 1 1 1 Improvement Other Than Buildings 0 0 01 01 01 0 0 01 0 0 Total Expenditures I 011 011 011 01 01 01 01 011 o(0 1 1 1 1 I ROADWAY BEAUTIFICATION FUND NET BEFORE I 3,98611 2,500 II 1,67811 (822)1 1,5001 520 II 1,350 II 2,570 II 3,710 ITRANSFERS 4,500 1 1 1 1 Fund Transfer In 0 0 0 oT 01 0 0 0 0 0 Total Transfer In 01 011 011 01 01 01 01 011 01 0 T T 1 Fund Transfer Out 0 0 0 01 01 0 0 01 0 0 Total Transfer Out 01 011 011 01 01 011 011 011 O(0 ROADWAY BEAUTIFICATION FUND SUMMARY: Beginning Fund Balance 95,889 99,875 99,875 0 101,553 103,053 103,573 104,923 107,493 111,203 Plus:Revenues 3,986 2,500 1,678 (822)1,500 520 1,350 2,570 3,710 4,500 Less:Expenditures 0 0 0 0 0 0 0 0 0 0 Plus:Transfer In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 99,87511 102,37511 101,55311 (822)1 103,0531 103,5731 104,923 I 107,49311 111,203(115,703 I T 1 1 I 1 1 1 1 1 I 2 - 2 3 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B d!_=MA~~~FY09-10 ~/ EQUIPMENT REPLACEMENT FUND DETAIL (Fund- 6811 Revenues Interfund charges 268,100 165,600 180,600 15,000 69,700 47,500 190,800 195,700 200,700 206,300 Interest earnings (m)122,218 64,900 52,772 (12,128)38,900 9,400 22,000 40,600 56,500 66,000 Total Revenue I 390,31811 230,500 II 233,37211 2,8721 108,6001 56,900 II 212,800 II 236,300 II 257,200 I 272,300 Expenses Vehicles and vehicle maintenance (b)52,464 101,500 64,294 37,206 45,000 33,400 34,400 35,300 36,200 37,200 Computer equipment and maintenance (b)150,667 169,720 121,765 47,955 989,500 95,800 98,600 101,200 103,800 106,700 Furniture and equipment maintenance (b)158,266 185,100 160,634 24,466 159,500 114,500 117,800 120,900 124,000 127,400 Total Expenses I 361,39711 456,320 II 346,69311 109,6271 1,194,0001 243,700 II 250,800 II 257,400 II 264,000 I 271,300 I I 1 1 EQUIPMENT REPLACEMENT FUND NET BEFORE 1 28,92111 (225,820)11 (113,321)11 112,4991 (1,085,400)1 (186,800)11 (38,000)11 (21,100)11 (6,800)1TRANSFERS 1,000 I I 1 1 Transfers In 0 0 0 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 I I 1 1 Transfers Out 0 0 0 01 01 0 01 01 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 EQUIPMENT REPLACEMENT NET ASSET Beginning Net Assets 3,006,440 3,023,617 3,023,617 0 2,968,158 1,882,758 1,695,958 1,657,958 1,636,858 1,630,058 Plus:Revenues 390,318 230,500 233,372 2,872 108,600 56,900 212,800 236,300 257,200 272,300 Less:Expenses (361,397)(456,320) (346,693)109,627 (1,194,000)(243,700)(250,800) (257,400) (264,000) (271,300) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 (Increase)/Decrease in Capital Assets (11,744)0 57,862 57,862 0 0 0 0 0 0 Available Net Assets I 3,023,61711 2,797,79711 2,968,158 11 170,361 1 1,882,7581 1,695,95811 1,657,958 11 1,636,85811 1,630,0581 1,631,058 Invested In Capital Assets 375,638 I N/A 317,776 I I 1 Ending Net Assets Per Financial Statements 3,399,255 I N/A 3,285,934 I I 1 1 I I 1 2 - 2 4 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B !_~.A"~~FY09·10 ~ BUILDING REPLACEMENT FUND DETAIL IFund-6861 Revenues Grant Revenue 0 0 0 0 162,900 0 0 0 0 0 Interest earnings (m)61,395 26,200 24,419 (1,781)15,800 4,200 10,400 19,900 28,700 34,800 Total Revenue I 61,39511 26,200 II 24,41911 (1,781)1 178,700 I 4,200 II 10,400 II 19,900 II 28,700 I 34,800 Expenses Professional Services 5,178 0 38,249 (38,249)97,500 7,500 0 0 0 0 Building Improvements 47,122 211,586 167,849 43,737 576,400 27,000 0 0 0 0 Total Expenses I 52,300 II 211,58611 206,09811 5,4881 673,900 I 34,500 II 011 011 01 0 I I 1 BUILDING REPLACEMENT FUND NET BEFORE I 9,09511 (185,386)11 (181,679)11 3,7071 (495,200)1 (30,300)11 10,400 II 19,900 II 28,7001TRANSFERS 34,800 1 1 1 1 1 Transfers In 1 1 1 1 1 From General fund 46,725 0 0 01 01 01 01 01 0 0 Total Transfers In I 46,725 11 011 011 01 01 011 011 011 01 0 I T T 1 1 1 Transfers Out 01 0 0 01 01 01 01 01 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 BUILDING REPLACEMENT NET ASSET SUMMARY: Beginning Net Assets 1,451,910 1,507,730 1,507,730 0 1,326,051 830,851 800,551 810,951 830,851 859,551 Plus:Revenues 61,395 26,200 24,419 (1,781)178,700 4,200 10,400 19,900 28,700 34,800 Less:Expenses (52,300)(211,586) (206,098)5,488 (673,900)(34,500)0 0 0 0 Plus:Transfers In 46,725 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Net Assets I 1,507,730 II 1,322,34411 1,326,05111 3,7071 830,851 I 800,551 II 810,95111 830,85111 859,5511 894,351 I 1 1 1 1 1 I 1 T T I 1 2 - 2 5 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B a:'''M'''~e ~FY09·10 <•...•.••.•.•.•.•...• EMPLOYEE BENEFITS FUND DETAIL (Fund-6S5) Revenues Interfund Charge for Services 1,630,930 1,689,930 1,615,134 (74,796)2,126,672 1,826,363 1,914,800 1,964,400 2,015,100 2,071,100 Interest earnings (m)19,612 960 8,927 7,967 70 0 280 540 780 950 Total Revenue I 1,650,64211 1,690,890 II 1,624,06111 {66,829)1 2,126,7421 1,826,36311 1,915,080 II 1,964,940 II 2,015,880 I 2,072,050 Expenses Retirement (PERS)(b)747,183 997,990 808,304 189,686 2,483,510 831,000 913,200 936,900 961,100 987,800 PERS Side-Fund Liability Pay Down 0 691,500 700,000 0 180,000 0 0 0 0 0 Defined Cont.Ret.Health Care Accounts (b)0 30,226 3,824 26,402 171,998 76,900 79,100 81,100 83,200 85,500 Insurance -Employee (b)523,459 609,420 673,281 (63,861)618,935 636,800 655,200 672,200 689,500 708,700 FICNMedicare (b)55,351 77,550 (3,701)81,251 93,094 95,260 98,000 100,500 103,100 106,000 Bonus Plan/Education Reimbursement (b)40,191 72,747 71,180 1,567 300,967 83,500 85,900 88,100 90,400 92,900 Worker Compensation Insurance (b)67,806 73,480 65,576 7,904 77,200 81,100 83,400 85,600 87,800 90,200 Total Expenses I 1,433,990 II 2,552,91311 2,318,46411 242,9491 3,925,7041 1,804,560 II 1,914,800 II 1,964,400 II 2,015,100 I 2,071,100 I 1 1 EMPLOYEE BENEFITS FUND NET BEFORE I 216,55211 {862,023)11 {694,403)11 176,120 I (l,798,962)1 21,80311 280 II 540 II 780 ITRANSFERS 950 1 1 1 1 1 Fund Transfer In -from general fund 01 01 01 01 1,594,1251 0 0 0 0 0 Total Transfer In I 011 011 011 01 1,594,1251 011 011 011 01 0 1 1 1 1 1 Fund Transfer Out 01 01 01 01 01 0 0 0 0 0 Total Transfer Out I 011 011 011 01 01 011 011 011 01 0 EMPLOYEE BENEFITS NET ASSET SUMMARY: Beginning Net Assets 682,692 899,244 899,244 0 204,841 4 21,807 22,087 22,627 23,407 Plus:Revenues 1,650,542 1,690,890 1,624,061 (66,829)2,126,742 1,826,363 1,915,080 1,964,940 2,015,880 2,072,050 Less:Expenses (1,433,990)(2,552,913)(2,318,464)234,449 (3,925,704)(1,804,560) (1,914,800)(1,964,400)(2,015,100) (2,071,100) Plus:Transfers In 0 0 0 0 1,594,125 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Net Assets I 899,24411 37,22111 204,84111 167,620 I 41 21,80711 22,08711 22,62711 23,4071 24,357 1 1 1 1 1 1 2 - 2 6 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B Revenues State gas tax Proposition 42 (aka Traffic Congestion Relief) Sidewalk repair Miscellaneous revenues Interest eamings Total Street Maintenance Fund Revenue Expenditures 501,200 1,729,700 115,800 2,346,700 I (1,019 I 239,000 242,845 242,845 0 22,000 0 30,000 105,000 140,000 170,000 206,000 212,180 212,180 0 0 0 0 0 0 0 0 0 0 0 556,000 500,300 463,300 475,300 487,600 501,200 180,000 180,000 180,000 0 200,000 204,000 205,000 205,000 195,000 194,000 66,931 76,800 76,800 0 84,000 104,100 107,100 109,900 112,700 115,800 0 0 0 0 256,860 165,200 170,000 174,400 178,900 183,900 0 1,164,900 6 ~I on 0 753,2641 578,5891 578,5891 0 424,481 403,055 356,951 313,291 319,871 326,411 I 813,5301 1,223,8291 1,199,0221 (24,807)1,091,388 1,138,970 1,150,540 1,162,780 1,175,540 1,187,320 (1,718,136)(2,097,145) (2,064,955)32,190 (2,271,674) (2,158,674) (2,169,600)(2,225,800)(2,283,200)(2,346,700) 729,931 711,825 711,825 0 1,158,860 973,600 975,400 1,069,600 1,114,200 1,164,900 0 0 0 0 0 0 0 0 0 0 From Waste Reduction From Beautification fund Street Maintenance -No""Pavement I (b) Traffic signal maintenance I (b) Total Street Maintenance Fund Expenditures STREET MAINTENANCE FUND NET BEFORE TRANSFERS Street Maintenance -Pavement Management I (b) From General Fund From 1972 Act To CIP Fund From 1911 Act From Prop C Fund (PB Road Maint) From General Fund (PB Road Maint) Street Maintenance Fund Transfers Out Beginning Fund Balance Total Transfers In Total Transfers Out STREET MAINTENANCE FUND SUMMARY Plus:Revenues Less:Expenditures Street Maintenance Fund Transfers In Less:Transfers Out Plus:Transfers In Available Fund Balance Reserve (1 year of Pavement Management Exp) Ending Fund Balance 2 - 2 7 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B !_"TIMA"~~FY09-10•• 1972 ACT LANDSCAPE &LIGHTING FUND DETAIL IIFund 2031 Revenues Property assessments 255,183 257,273 257,138 (135)257,559 258,687 261,921 264,933 268,112 272,134 Interest earnings (m)8,786 800 1,877 1,077 900 240 420 430 130 40 Total Revenue I 263,96911 258,07311 259,01511 9421 258,4591 258,92711 262,34111 265,36311 268,2421 272,174 1 Expenditures T Operations &maintenance (b)65,789 67,900 67,661 2391 69,100 70,300 72,300 74,200 76,100 78,200 Total Expenditures I 65,78911 67,900 II 67,66111 2391 69,100 I 70,300 II 72,300 II 74,200 II 76,100 I 78,200 1 1 1 1972 ACT FUND NET BEFORE TRANSFERS I 198,18011 190,17311 191,35411 1,1811 189,3591 188,62711 190,04111 191,16311 192,1421 193,974 T T 1 Transfers In 0 0 0 01 01 0 0 01 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 1 1 I Transfers Out 1 1 1 To Street Maintenance fund 180,000 180,000 180,000 01 200,000 I 204,000 205,000 205,0001 195,000 194,000 Total Transfers Out I 180,000 II 180,000 II 180,000 II 01 200,0001 204,000 II 205,000 II 205,000 II 195,000 I 194,000 1972 ACT LANDSCAPE &LIGHTING FUND Beginning Fund Balance 29,125 47,305 47,305 0 58,659 48,018 32,645 17,686 3,848 990 Plus:Revenues 263,969 258,073 259,015 942 258,459 258,927 262,341 265,363 268,242 272,174 Less:Expenditures (65,789)(67,900)(67,661)239 (69,100)(70,300)(72,300) (74,200) (76,100) (78,200) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (180,000)(180,000)(180,000)0 (200,000) (204,000)(205,000) (205.000) (195,000)(194,000) Ending Fund Balance 1 47,30511 57,47811 58,65911 1,1811 48,0181 32,64511 17,68611 3,84811 9901 964 1 r 1 I 1 1 1 I 2 - 2 8 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '_"'MA"~~FY09-10_i EL PRADO LIGHTING FUND DETAIL (Fund-2091 Revenues Property assessments (a)1,793 1,820 1,827 7 1,870 1,910 1,950 1,990 2,030 2,070 Interest earnings (m)342 210 173 (37)160 10 40 100 180 260 Total Revenue I 2,13511 2,030 II 2,000 II (30)1 2,030 I 1,920 II 1,990 II 2,090 II 2,210 I 2,330 Expenditures Light and Power (b)314 200 348 (148)300 300 300 300 300 300 Maintenance Services (b)0 700 86 614 10,700 700 700 700 700 700 Total Expenditures I 31411 900 II 43411 4661 11,000 I 1,000 II 1,000 II 1,000 II 1,000 I 1,000 I I EL PRADO LIGHTING FUND NET BEFORE I 1,82111 1,13011 1,56611 4361 (8,970)1 920 II 990 II 1,090 II 1,210 I 1,330 1 1 1 1 Transfers In 0 01 0 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 1 1 1 1 Transfers Out 0 0 0 01 01 0 0 0 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 EL PRADO LIGHTING FUND SUMMARY: Beginning Fund Balance 7,751 9,572 9,572 0 11,138 2,168 3,088 4,078 5,168 6,378 Plus:Revenues 2,135 2,030 2,000 (30)2,030 1,920 1,990 2,090 2,210 2,330 Less:Expenditures (314) (900)(434)466 (11,000)(1,000)(1,000) (1,000)(1,000)(1,000) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 9,57211 10,70211 11,13811 4361 2,1681 3,08811 4,07811 5,16811 6,3781 7,708 I I 1 1 1 I I 1 1 1 2 - 2 9 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~=zd'_"TI.A~~~FY09·10 ................ ............................. CDBG FUND DETAIL IFund-310) Revenues Grant income 244,904 188,908 113,021 (75,887)336,826 218,146 167,898 167,898 167,898 167,898 Total Revenue I 244,90411 188,90811 113,02111 (75,887)1 336,8261 218,14611 167,89811 167,89811 167,8981 167,898 Expenditures Operations &maintenance 146,542 168,262 92,364 75,898 167,899 167,898 167,898 167,898 167,898 167,898 Capital outlay 69,786 0 0 0 142,079 94,248 0 0 0 0 Total Expenditures I 216,32811 168,26211 92,36411 75,8981 309,9781 262,14611 167,89811 167,89811 167,8981 167,898 I I CDBG FUND NET BEFORE TRANSFERS I 28,57611 20,64611 20,65711 111 26,8481 (44,000)11 011 011 01 0 1 1 1 1 1 Transfers In 1 1 1 1 From General fund 0 0 0 01 44,0061 0 01 01 0 0 Total Transfers Out I 011 011 011 01 44,0061 011 011 011 01 0 1 1 1 1 Transfers Out I I I I To General fund (REACH)28,574 20,646 20,646 01 26,8481 0 01 01 0 0 Total Transfers Out I 28,57411 20,64611 20,64611 01 26,8481 011 011 011 01 0 CDBG FUND SUMMARY: Beginning Fund Balance (19)(17)(17)0 (6)44,000 0 0 0 0 Plus:Revenues 244,904 188,908 113,021 (75,887)336,826 218,146 167,898 167,898 167,898 167,898 Less:Expenditures (216,328) (168,262)(92,364)75,898 (309,978)(262,146)(167,898) (167,898)(167,898)(167,898) Plus:Transfers In 0 0 0 0 44,006 0 0 0 0 0 Less:Transfers Out (28,574)(20,646)(20,646)0 (26,848)0 0 0 0 0 Ending Fund Balance I (17)11 (17)11 (6)11 111 44,000 I 011 011 011 01 0 1 1 1 1 1 1 1 1 2 - 3 0 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ 1911 ACT STREET LIGHTING FUND DETAIL fFund- 211 0 0 -- 115,800 115,800 1,494,594 1,591,701 1,591,701 0 1,632,607 1,560,007 1,449,607 1,342,507 1,243,307 1,147,807 539,725 410,000 520,257 110,257 504,800 500,600 521,500 545,700 566,000 580,100 (375,687)(480,000)(402,551)77,449 (493,400) (506,900)(521,500) (535,000) (548,800)(564,100) 0 0 0 0 0 0 0 0 0 0 (66,931)(76,800)(76,800)0 (84,000)(104,100)(107,100) (109,900)(112,700)(115,800) (a) (b) (m) Beginning Fund Balance 1911 ACT STREET LIGHTING FUND SUMMARY Transfers In To Street Maintenance Fund 1911 ACT FUND NET BEFORE TRANSFERS Total Transfers In Revenues Property assessments Operations &maintenance Interest earnings Total Expenditures Total Revenue Transfers Out Expenditures Plus:Transfers In Total Transfers Out Less:Expenditures Plus:Revenues less:Transfers Out Ending Fund Balance 2 - 3 1 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!ESTIMATE FY09-10 IT WASTE REDUCTION FUND DETAIL IFund-2131 Revenues Collection Fees (AB939)51,042 25,000 68,454 43,454 25,000 0 0 0 0 0 Allocation of refuse hauler collection fees (c)0 45,000 0 0 36,150 155,000 156,900 158,700 160,600 163,000 State income 72,272 102,500 66,092 (36,408)65,000 25,000 25,000 25,000 25,000 25,000 Mise income 0 0 0 0 158,500 0 0 0 0 0 Interest earnings (m)14,204 5,540 4,582 (958)1,740 620 1,670 3,220 4,590 5,420 Total Revenue I 137,51811 178,040 II 139,12811 6,0881 286,390 I 180,620 II 183,570 II 186,920 II 190,190 I 193,420 Expenditures Personnel services (b)45,367 64,260 64,707 (447)54,958 55,889 57,500 59,000 60,500 62,200 Operations &maintenance (b)69,609 250,400 219,866 30,534 229,750 108,050 111,200 114,100 117,000 120,300 Total Expenditures I 114,97611 314,660 II 284,57311 30,0871 284,7081 163,93911 168,700 II 173,100 II 177,500 I 182,500 1 1 1 1 1 WASTE REDUCTION FUND NET BEFORE I 22,54211 (136,620)11 (145,44581 36,1751 1,6821 16,68111 14,870 II 13,820 II 12,690 I 10,920 1 1 1 1 1 Transfers In 01 01 01 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 Transfers Out To General fund 0 7,000 0 7,000 12,000 12,000 12,000 12,000 12,000 12,000 To Street Maintenance 38,000 0 0 0 40,000 0 0 0 0 0 Total Transfers Out I 38,000 II 7,00011 011 7,000 I 52,0001 12,000 II 12,000 II 12,000 II 12,000 I 12,000 WASTE REDUCTION FUND SUMMARY Beginning Fund Balance 335,008 319,550 319,550 0 174,105 123,787 128,468 131,338 133,158 133,848 Plus:Revenues 137,518 178,040 139,128 (38,912)286,390 180,620 183,570 186,920 190,190 193,420 Less:Expenditures (114,976)(314,660) (284,573)30,087 (284,708)(163,939)(168,700) (173,100)(177,500)(182,500) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (38,000)(7,000)0 7,000 (52,000)(12,000)(12,000) (12,000)(12,000) (12,000) Ending Fund Balance I 319,550 II 175,930 II 174,10511 (1,825)1 123,7871 128,46811 131,33811 133,15811 133,8481 132,768 1 1 I 1 1 I 2 - 3 2 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~-~~~FY09·10 AIR QUALITY MANAGEMENT FUND DETAIL (Fund· 2141 Revenues AB 2766 fees 51,468 50,000 50,124 124 99,800 49,800 49,800 49,800 49,800 49,800 Interest earnings (m)1,227 1,310 455 (855)800 270 690 1,320 1,900 2,300 Total Revenue I 52,695 11 51,310 II 50,57911 (731)1 100,6001 50,070 II 50,490 II 51,120 II 51,700 I 52,100 1 1 1 Expenditures I I I Operations &maintenance 57,818 1 50,000 50,000 01 100,0001 50,000 50,000 50,000 I 50,000 50,000 Total Expenditures I 57,81811 50,000 II 50,000 II 01 100,0001 50,000 II 50,000 II 50,000 II 50,000 I 50,000 I I AQMD FUND NET BEFORE TRANSFERS I (5,123)11 1,310 II 57911 (731)1 6001 70 II 490 II 1,120 II 1,700 I 2,100 I 1 1 1 Transfers Out 01 01 01 01 01 0 0 0 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 AIR QUALITY MANAGEMENT FUND DETAIL Beginning Fund Balance 57,320 52,197 52,197 0 52,776 53,376 53,446 53,936 55,056 56,756 Plus:Revenues 52,695 51,310 50,579 (731)100,600 50,070 50,490 51,120 51,700 52,100 Less:Expenditures (57,818)(50,000) (50,000)0 (100,000)(50,000)(50,000) (50,000)(50,000)(50,000) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 52,19711 53,50711 52,77611 (731)1 53,3761 53,44611 53,93611 55,05611 56,7561 58,856 1 1 1 1 1 1 I 1 1 1 2 - 3 3 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~FY09-10 ..~..,J_>•••••>.~ PROPOSITION C ISTREETITRANSITl FUND DETAIL Fund-215\ Revenues Proposition C -1/2 cent sales tax revenue (j)572,874 601,100 557,794 (43,306)457,384 478,485 478,500 478,500 478,500 478,500 Measure R -1/2 cent sales tax revenue (j)0 0 0 0 221,267 358,865 358,900 358,900 358,900 358,900 Interest earnings (m)81,611 15,300 36,944 21,644 24,900 6,520 21,410 60 12,580 29,440 Total Revenue I 654,48511 616,400 II 594,73811 (21,662)1 703,551 I 843,870 II 858,810 II 837,460 II 849,980 I 866,840 I I I I I Expenditures I I I I I Personnel services (b)4,626 I 5,700 I 6,095 1 (39511 01 0 0 0 0 0 Total Expenditures I 4,62611 5,700 II 6,09511 (395)1 01 011 011 011 01 0 I 1 1 I I PROPOSITION C FUND NET BEFORE TRANSFERS I 649,85911 610,700 II 588,64311 (22,057)1 703,551 I 843,870 II 858,810 II 837,460 II 849,980 I 866,840 I 1 1 I I Transfers In 01 01 01 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 Transfers Out To CIPfund 237,527 2,408,671 0 2,408,671 1,409,230 0 2,040,000 0 0 25,000 To Street Maintenance fund 0 0 0 0 556,000 500,300 463,300 475,300 487,600 501,200 Total Transfers Out I 237,52711 2,408,67111 011 2,408,671 I 1,965,230 I 500,300 II 2,503,300 II 475,300 II 487,600 I 526,200 PROPOSITION C ISTREETITRANSID FUND SUMMARY: Beginning Fund Balance 1,564,024 1,976,356 1,976,356 0 2,564,999 1,303,320 1,646,890 2,400 364,560 726,940 Plus:Revenues 654,485 616,400 594,738 (21,662)703,551 843,870 858,810 837,460 849,980 866,840 Less:Expenditures (4,626)(5,700)(6,095)(395)0 0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (237,527)(2,408,671)0 2,408,671 (1,965,230)(500,300)(2,503,300)(475,300)(487,600) (526,200) Ending Fund Balance I 1,976,35611 178,38511 2,564,99911 2,386,6141 1,303,320 I 1,646,890 II 2,400 II 364,560 II 726,940 I 1,067,580 1 I I I I 2 - 3 4 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~nMA~~~FY09-10 ' ~...................... PROPOSITION A (TRANSITl FUND DETAIL (Fund- 21~1 Revenues Proposition A -1/2 cent sales tax revenue (j)686,698 721,300 621,569 (99,731)546,923 576,854 576,900 576,900 576,900 576,900 Interest earnings (m)285 5,600 2,351 (3,249)1,000 360 0 0 0 0 Total Revenue I 686,98311 726,900 II 623,920 II (102,980)1 547,923 1 577,21411 576,900 II 576,900 II 576,900 I 576,900 Expenditures Personnel services 1,650 5,700 6,095 (395)0 0 0 0 0 0 Operations (including PV Transit)496,701 639,193 628,952 10,241 654,900 689,500 699,843 710,340 720,995 731,810 Capital Outlay (BUS Shetler Improvements)(b)0 0 0 0 16,000 16,500 17,000 17,400 17,800 18,300 Total Expenditures I 498,35111 644,89311 635,04711 9,846 1 670,900 1 706,000 II 716,84311 727,740 II 738,7951 750,110 I I PROPOSITION A FUND NET BEFORE TRANSFERS I 188,63211 82,00711 (11,127)11 (93,134)1 (122,977)1 (128,786111 (139,943)11 (150,840)11 (161,895)1 (173,210) 1 1 1 I I Transfers In from General Fund 01 01 01 01 01 60,000 0 0 0 0 Total Transfers In I 011 011 011 01 01 60,000 II 011 011 01 0 Transfers Out To General Fund (b)2,600 2,700 2,700 0 2,800 0 0 0 0 0 To CIP Fund 15,000 15,500 12,450 3,050 0 0 0 0 0 0 Total Transfers Out I 17,60011 18,200 II 15,15011 3,050 1 2,800 1 011 011 011 01 0 PROPOSITION A !TRANSIT)FUND SUMMARY: Beginning Fund Balance 52,939 223,971 223,971 0 197,694 71,917 3,131 (136,812) (287,652)(449,547) Plus:Revenues 686,983 726,900 623,920 (102,980)547,923 577,214 576,900 576,900 576,900 576,900 Less:Expenditures (498,351)(844,893) (635,047)9,846 (670,900)(706,000)(716,843) (727,740)(738,795)(750,110) Plus:Transfers In 0 0 0 0 0 60,000 0 0 0 0 Less:Transfers Out (17,600)(18,200)(15,150)3,050 (2,800)0 0 0 0 0 Ending Fund Balance I 223,97111 287,77811 197,69411 (90,084)1 71,917 1 3,13111 (136,812)11 (287,652)11 (449,547)1 (622,757) 1 1 I I I 1 1 I I I 2 - 3 5 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~=d!"'.A"~FY09·10 ••••••• PUBLIC SAFETY GRANTS IFund-2171 Revenues Grant Income -Slate 100,000 100,000 100,000 a 100,000 100,000 100,000 100,000 100,000 100,000 Interest earnings (m)7,347 720 1,625 905 a a 10 20 30 40 Total Revenue 1 107,34711 100,720 II 101,625 11 9051 100,000 1 100,000 II 100,010 II 100,020 II 100,030 I 100,040 1 1 I I Expenditures I I I I Equipment purchases 15,600 1 32,2851 32,285 I a I 33,635 a a a a a Total Expenditures I 15,600 II 32,285 11 32,285 11 aI 33,6351 all all all 01 a 1 1 I I I PUBLIC SAFETY GRANTS FUND NET BEFORE I 91,74711 68,43511 69,340 II 9051 66,3651 100,000 II 100,010 II 100,020 II 100,030 ITRANSFERS 100,040 I 1 1 I I 1 Transfers In 01 01 01 a I a I 01 a a a a Total Transfers In I a II a II all 01 aI all all all 01 a I 1 1 I I 1 Transfers Out I 1 1 I I I To General fund 100,000 I 100,000 1 100,000 1 a I 100,000 I 100,000 1 100,000 100,000 100,000 100,000 Total Transfers Out I 100,000 II 100,000 II 100,000 II 01 100,000 1 100,000 II 100,000 II 100,000 II 100,000 I 100,000 PUBLIC SAFETY GRANTS FUND SUMMARY: Beginning Fund Balance 73,453 65,200 65,200 a 34,540 905 905 915 935 965 Plus:Revenues 107,347 100,720 101,625 905 100,000 100,000 100,010 100,020 100,030 100,040 Less:Expenditures (15,600) (32,285)(32,285)a (33,635)a a a a a Plus:Transfers In a a a a a a a a a a Less:Transfers Out (100,000)(100,000)(100,000)a (100,000) (100,000) (100,000) (100,000)(100,000)(100,000) Ending Fund Balance I 65,200 II 33,63511 34,540 II 9051 9051 90511 91511 93511 9651 1,005 I I I I 1 I I I I 1 2 - 3 6 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""TIMAIT~g ~FY09·10 .......... ~~ HABITAT RESTORATION FUND DETAIL IFund·2221 Revenues Grants 0 0 6,528 6,528 0 0 0 0 0 0 Interest earnings (m)12,627 4,400 2,585 (1,815)1,800 1,010 2,410 4,190 5,450 5,890 Total Revenue I 12,62711 4,400 II 9,11311 4,7131 1,800 I 1,010 II 2,410 II 4,190 II 5,450 I 5,890 Expenditures Preserve Management (b)85,075 108,200 109,199 (999)108,800 109,900 113,100 116,000 119,000 122,300 Oceanfront Estates Habitat Maintenance and Monitoring (b)16,881 15,000 15,488 (488)15,991 16,511 17,000 17,400 17,800 18,300 Habitat Restoration 28,967 38,877 7,503 31,374 70,000 0 0 0 0 0 Total Expenditures I 130,92311 162,07711 132,19011 29,8871 194,791 I 126,41111 130,100 II 133,400 II 136,800 I 140,600 1 1 1 1 1 HABITAT RESTORATION FUND NET BEFORE 1 (118,296)11 (157,677)11 (123,077)11 34,600 I (192,991)1 (125,401)11 (127,690)11 (129,210)11 (131,350)1TRANSFERS (134,710) 1 1 1 1 I Transfers In 1 I 1 1 1 From General fund 115,000 115,0001 115,000 I 01 169,0001 109,9001 113,100 116,000 119,000 122,300 Total Transfers In I 115,000 II 115,000 II 115,000 II 01 169,000 I 109,900 II 113,100 II 116,000 II 119,000 I 122,300 1 1 1 1 1 Transfers Out 0 01 01 01 01 0 0 0 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 HABITAT RESTORATION FUND SUMMARY: Beginning Fund Balance 236,553 233,257 233,257 0 225,180 201,189 185,688 171,098 157,888 145,538 Plus:Revenues 12,627 4,400 9,113 4,713 1,800 1,010 2,410 4,190 5,450 5,890 Less:Expenditures (130,923) (162,077) (132,190)29,887 (194,791)(126,411)(130,100)(133,400) (136,800) (140,600) Plus:Transfers In 115,000 115,000 115,000 0 169,000 109,900 113,100 116,000 119,000 122,300 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 233,25711 190,580 II 225,180 II 34,600 I 201,1891 185,68811 171,09811 157,88811 145,5381 133,128 Reserve 1 1 54,1221 64,443 1 75,410 87,503 100,867 115,357 Available Fund Balance I 1 147,0671 121,245 I 95,688 70,385 44,671 17,771 1 1 1 I 2 - 3 7 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B fi "'"""~~FY09·10_X... SUBREGION 1 •MAINTENANCE FUND DETAIL Fund 22;n Revenues Interest earnings (m)29,147 12,000 12,331 331 11,300 3,800 9,800 18,500 26,100 30,400 Total Revenue I 29,14711 12,00011 12,33111 33q 11,300 I 3,800 II 9,800 II 18,500 II 26,100 I 30,400 1 Expenditures T Operations &maintenance (b)62,956 65,900 50,755 15,1451 77,000 79,000 71,300 73,100 75,000 77,100 Total Expenditures I 62,956 11 65,900 II 50,755 11 15,1451 77,000 I 79,000 II 71,300 II 73,100 II 75,000 I 77,100 I I SUBREGION 1-MAINTENANCE FUND NET BEFORE I (33,809)11 (53,900)11 (38,424)11 15,4761 (65,700)1 (75,200)11 (61,500)11 (54,600)11 (48,900)1TRANSFERS (46,700) 1 1 I Transfers In-from general fund 30,000 55,000 55,000 aT 55,000T 70,000 I 65,000 1 55,000 45,000 50,000 Total Transfers In I 30,000 II 55,000 II 55,000 II a I 55,000 I 70,000 II 65,000 II 55,000 II 45,000 I 50,000 1 1 I 1 Transfers Out a a a aT aT 01 01 01 a a Total Transfers Out I a II a II all a I a I all a II all a I a SUBREGION 1-MAINTENANCE FUND SUMMARY: Beginning Fund Balance 4,569 760 760 a 17,336 6,636 1,436 4,936 5,336 1,436 Plus:Revenues 29,147 12,000 12,331 331 11,300 3,800 9,800 18,500 26,100 30,400 Less:Expenditures (62,956) (65,900)(50,755)15,145 (77,000)(79,000)(71,300)(73,100)(75,000)(77,100) Plus:Transfers In 30,000 55,000 55,000 a 55,000 70,000 65,000 55,000 45,000 50,000 Less:Transfers Out a a a a a a a a a a Available Fund Balance I 76011 1,860 II 17,33611 15,4761 6,6361 1,43611 4,936 11 5,33611 1,4361 4,736 Unexpendable Endowment 750,000 750,000 750,000 1 1 1 I I Ending Fund Balance per Financial Statements 750,760 751,860 767,336 T T I I I 1 1 1 I I 2 - 3 8 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!"'MA"~~FY09-10 , MEASURE A -CAPITAL Fund-339 &MAINTENANC Fund-224\FUNDS DETAIL matched 224 with CAFR only Revenues Grant income 35,175 66,000 98,945 32,945 160,913 150,000 150,000 150,000 150,000 125,000 Rolling Hills Maintenance Allocation 0 0 0 0 1,000 1,000 1,000 1,000 1,000 1,000 Interest earnings (m)6,873 800 1,478 678 0 170 440 850 1,220 1,480 Total Revenue I 42,04811 66,800 II 100,42311 33,6231 161,9131 151,170 II 151,440 II 151,850 II 152,220 I 127,480 Expenditures Operations &maintenance 0 0 0 0 0 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 0 0 Total Expenditures I 011 011 011 01 01 011 011 011 01 0 I I I I MEASURE A -CAPITAL &MAINTENANCE FUND NET I 42,04811 66,800 II 100,42311 33,6231 161,9131 151,170 II 151,440 II 151,850 II 152,220 IBEFORETRANSFERS 127,480 Transfers Out To General fund 100,599 75,900 54,200 21,700 151,000 151,000 151,000 151,000 151,000 151,000 To CIP fund 0 0 21,700 (21,700)10,913 0 0 0 0 0 Total Transfers Out I 100,59911 75,900 II 75,900 II 01 161,9131 151,000 II 151,000 II 151,000 II 151,000 I 151,000 MEASURE A (PARKS)-CAPITAL &MAINTENANCE FUNDS SUMMARY: Beginning Fund Balance 67,956 9,405 9,405 0 33,928 33,928 34,098 34,538 35,388 36,608 Plus:Revenues 42,048 66,800 100,423 33,623 161,913 151,170 151,440 151,850 152,220 127,480 Less:Expenditures 0 0 0 0 0 0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (100,599)(75,900)(75,900)0 (161,913)(151,000)(151,000) (151,000)(151,000)(151,000) Ending Fund Balance I 9,40511 30511 33,92811 33,6231 33,9281 34,09811 34,53811 35,38811 36,6081 13,088 I I I I I I I I I I 2 - 3 9 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""TIMA"~g ~~~~_........~ ABALONE COVE SEWER DISTRICT FUND DETAIL Fund-225\ Revenues Property Assessments (al 43,091 44,750 52,150 7,400 45,650 46,560 47,490 48,440 49,410 50,400 Interest eamings (ml 5,206 460 2,021 1,561 570 280 660 1,090 1,320 1,270 Total Revenue I 48,29711 45,210 II 54,17111 8,9611 46,2201 46,840 II 48,150 II 49,530 II 50,730 I 51,670 Expenditures Maintenance Services (b)57,381 43,400 37,809 5,591 45,500 46,500 47,800 49,000 50,300 51,700 Personnel &Professional services 8,098 22,400 12,546 9,854 16,538 16,706 17,200 17,600 18,100 18,600 Capital Outlay 0 38,000 38,635 (6351 32,000 0 0 0 0 0 Total Expenditures I 65,47911 103,800 II 88,990 II 14,8101 94,0381 63,2061 65,000 I 66,600 II 68,400 I 70,300 I T I I ABALONE COVE SEWER DISTRICT FUND NET (17,18211 (58,590111 (34,819111 23,771 I (47,81811 (16,366111 (16,850111 (17,070)11 (17,67011BEFORETRANSFERS (18,630) I 1 T T Fund Transfer In I 1 I I From General Fund 80,700 10,700 10,7001 oT 10,700T 10,700 10,700 10,700 10,700 10,700 Total Transfer In 80,700 I 10,700 II 10,70011 01 10,7001 10,700 I 10,700 I 10,700 II 10,700 I 10,700 1 T I I Fund Transfer Out 0 01 01 oT oT 0 0 0 0 0 Total Transfer Out I 011 011 011 01 01 011 011 011 01 0 ABALONE COVE SEWER DISTRICT FUND Beginning Fund Balance 54,195 117,713 117,713 0 93,594 56,476 50,810 44,660 38,290 31,320 Plus:Revenues 48,297 45,210 54,171 8,961 46,220 46,840 48,150 49,530 50,730 51,670 Less:Expenditures (65,479)(103,800)(88,990)14,810 (94,038)(63,206) (65,000)(66,600)(68,400)(70,300) Plus:Transfer In 80,700 10,700 10,700 0 10,700 10,700 10,700 10,700 10,700 10,700 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 117,71311 69,82311 93,59411 23,7711 56,4761 50,810 I 44,660 I 38,290 II 31,320 I 23,390 1 I T I I I 1 T T 2 - 4 0 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~',",M"'~~~FY09-10-<...................>•••• DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND DETAIL (Fund- 2271 Revenues Restricted Donations 500,000 0 0 0 0 0 0 0 0 0 Interest eamings (m)10,651 12,200 8,458 (3,742)7,600 1,040 2,720 5,190 7,490 9,090 Total Revenue I 510,65111 12,200 II 8,45811 (3,742)1 7,6001 1,040 II 2,720 II 5,190 II 7,490 I 9,090 T T 1 1 Expenditures 1 1 1 1 Capital OuUay 18,606 0 0 oT 300,000T 0 01 01 0 0 Total Expenditures I 18,60611 011 011 01 300,0001 011 011 011 01 0 1 1 1 1 DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL I 492,04511 12,200 II 8,45811 01 (292,400)1 1,040 II 2,720 II 5,190 II 7,490 IARTSBUILDINGFUNDNETBEFORETRANSFERS 9,090 T T 1 1 Fund Transfer In 0 0 0 01 01 0 01 0 0 0 Total Transfer In I 011 011 011 01 01 011 011 011 01 0 T T 1 1 Fund Transfer Out 0 0 0 01 01 0 01 01 0 0 Total Transfer Out I 011 011 011 01 01 011 011 011 01 0 DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND SUMMARY: Beginning Fund Balance 0 492,045 492,045 0 500,503 208,103 209,143 211,863 217,053 224,543 Plus:Revenues 510,651 12,200 8,458 (3,742)7,600 1,040 2,720 5,190 7,490 9,090 Less:Expenditures (18,606)0 0 0 (300,000)0 0 0 0 0 Plus:Transfer In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 492,04511 504,24511 500,50311 (3,742)1 208,1031 209,14311 211,86311 217,05311 224,5431 233,633 1 1 1 1 T T 1 1 2 - 4 1 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '",....,'~~~FY09-10 ~..............................................> ......... RECREATION IMPROVEMENTS DONATIONS FUND DETAIL -/Fund 228\ Revenues Restricted Donations 2,014 0 0 0 300,000 0 0 0 0 0 Grant Revenue 0 0 0 0 300,000 0 0 0 0 0 Interest earnings (m)34 0 34 34 0 10 30 50 70 90 Total Revenue I 2,04811 011 3411 341 600,000 I 10 II 30 II 50 II 70 I 90 1 I T T T Expenditures 1 1 1 I I Capital Outlay 01 01 oT oT oT 0 0 0 0 0 Total Expenditures I 011 011 011 01 01 011 011 011 01 0 1 1 1 I I RECREATION IMPROVEMENTS DONATIONS FUND I 2,04811 011 3411 01 600,000 I 10 II 30 II 50 II 70 INETBEFORETRANSFERS 90 1 1 T T T Fund Transfer In 01 01 01 01 01 0 0 0 0 0 Total Transfer In I 011 011 011 01 01 011 011 011 01 0 1 1 T T T Transfer To CIP 01 01 01 01 600,000 I 0 0 0 0 0 Total Transfer Out I 011 011 011 01 600,0001 011 011 011 01 0 RECREATION IMPROVEMENTS DONATIONS BUILDING FUND SUMMARY: Beginning Fund Balance 0 2,048 2,048 0 2,082 2,082 2,092 2,122 2,172 2,242 Plus:Revenues 2,048 0 34 34 600,000 10 30 50 70 90 Less:Expenditures 0 0 0 0 0 0 0 0 0 0 Plus:Transfer In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 (600,000)0 0 0 0 0 Ending Fund Balance I 2,04811 2,04811 2,08211 341 2,0821 2,09211 2,12211 2,17211 2,2421 2,332 1 1 1 I I I I T T I 2 - 4 2 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~nMA~~~FY09-10_..................... <........ QUIMBY FUND DETAIL (Fund-334l Revenues Developer fees 0 12,000 0 (12,000)0 0 0 0 0 0 Interest earnings (m)988 310 416 106 0 130 330 630 910 1,100 Total Revenue I 98811 12,310 II 416/1 (11,894)1 01 130 II 330 II 630 II 910 I 1,100 Expenditures Improvements 0 25,000 0 25,000 0 0 0 0 0 0 Total Expenditures I 011 25,000 II 0/1 25,000 I 01 011 011 011 01 0 I I QUIMBY FUND NET BEFORE TRANSFERS I 98811 (12,690)/1 416/1 13,1061 01 130 II 330 II 630 II 910 I 1,100 1 1 1 1 Transfers In 0 0 0 01 01 01 01 0 0 0 Total Transfers In I 0/1 011 011 01 01 011 011 0/1 01 0 1 1 1 1 1 Transfers Out 0 0 0 01 01 01 01 01 0 0 Total Transfers Out I 011 011 011 01 01 011 011 0/1 01 0 QUIMBY FUND SUMMARY: Beginning Fund Balance 23,766 24,754 24,754 0 25,170 25,170 25,300 25,630 26,260 27,170 Plus:Revenues 988 12,310 416 (11,894)0 130 330 630 910 1,100 Less:Expenditures 0 (25,000)0 25,000 0 0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 24,75411 12,06411 25,170/1 13,1061 25,170 I 25,300 II 25,630 II 26,260 II 27,170 I 28,270 1 1 1 1 I I I I 2 - 4 3 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~FY09-10 . ~-------AFFORDABLE HOUSING IN -LIEU FUND NON-RDA DETAIL IFund-3371 Revenues Developer fees 0 0 0 0 931,910 0 0 0 0 0 Interest earnings (m)46,136 19,500 14,534 (4,966)16,600 40 100 200 290 350 Total Revenue I 46,13611 19,500 II 14,53411 (4,966)1 948,5101 40 II 100 II 200 II 290 I 350 Expenditures Capital Outlay 0 331,432 328,916 0 0 0 0 0 0 0 Improvements 1,200 0 2,516 (2,516)12,500 0 0 0 a 0 Total Expenditures I 1,200 II 331,43211 331,4321 (2,516>1 12,500 I all 011 all 01 0 I I AFFORDABLE HOUSING SET-ASIDE FUND NET 44,9361 (311,932)11 (316,898)~(7,482)1 936,0·10 I 40 II 100 II 200 IBEFORETRANSFERS 290 350 I I Transfers In a a 0 01 01 a a 0 0 0 Total Transfers In I 011 aII 011 01 01 011 aII 011 01 0 1 I 1 I I Transfers Out 01 01 01 o I 1,766,368 I 0 0 0 a 0 Total Transfers Out I 011 011 011 aI 1,766,3681 011 011 011 01 0 AFFORDABLE HOUSING IN -LIEU FUND SUMMARY (NON-RDAl Beginning Fund Balance 1,110,295 1,155,231 1,155,231 0 838,333 7,975 8,015 8,115 8,315 8,605 Plus:Revenues 46,136 19,500 14,534 (4,966)948,510 40 100 200 290 350 Less:Expenditures (1,200)(331,432)(331,432)a (12,500)0 0 0 a 0 Plus:Transfers In 0 0 0 a 0 0 0 0 0 0 Less:Transfers Out 0 a 0 a (1,766,368)a 0 0 a 0 Ending Fund Balance I 1,155,23111 843,29911 838,33311 (4,966)1 7,9751 8,0151 8,115 I 8,31511 8,6051 8,955 I 1 I I I I I 2 - 4 4 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~"'."'~~FY09-10 l) ~ ENVIRONMENTAL EXCISE TAX fEETl FUND DETAIL Fund-338\ Revenues Developer fees 580,954 74,240 59,111 (15,129)90,000 38,600 0 0 0 0 Interest earnings (m)21,296 19,600 14,237 (5,363)10,100 200 510 980 1,420 1,720 Total Revenue I 602,250 II 93,840 II 73,34811 (20,492)1 100,100 I 38,800 II 510 II 980 II 1,420 I 1,720 1 Expenditures T Improvements 44,704 58,295 I 58,278T 171 566,000 0 0 0 0 0 Total Expenditures I 44,70411 58,29511 58,27811 171 566,000 I 011 011 011 01 0 1 1 1 1 EET FUND NET BEFORE TRANSFERS I 557,54611 35,54511 15,07011 (20,475)1 (465,900)1 38,800 II 510 II 980 II 1,420 I 1,720 T T 1 Transfers Out 1 1 1 To CIPfund 0 29,000 0 29,000 I 332,600T 40,0001 01 0 0 0 Total Transfers Out I 011 29,000 II 011 29,000 I 332,600 I 40,000 II 011 011 01 0 ENVIRONMENTAL EXCISE TAX fEET)FUND SUMMARY Beginning Fund Balance 266,677 824,223 824,223 0 839,293 40,793 39,593 40,103 41,083 42,503 Plus:Revenues 602,250 93,840 73,348 (20,492)100,100 38,800 510 980 1,420 1,720 Less:Expenditures (44,704) (58,295) (58,278)17 (566,000)0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 (29,000)0 29,000 (332,600)(40,000)0 0 0 0 Ending Fund Balance 1 824,22311 830,76811 839,29311 8,5251 40,7931 39,59311 40,10311 41,08311 42,5031 44,223 T 1 1 1 1 1 2 - 4 5 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~~n.AIT~~FY09-10 ~·>i·.i BIKEWAYS (TDA ARTICLE 31 FUND DETAIL (Fund- 3401 Revenues Grant Income 36,825 26,802 24,630 (2,172)25,000 17,223 17,200 17,200 17,200 17,200 Interest earnings 2,770 0 174 174 0 0 0 0 0 0 Total Revenue 1 39,59511 26,80211 24,80411 (1,998)1 25,0001 17,22311 17,200 II 17,200 II 17,2001 17,200 1 1 1 1 Expenditures 1 1 1 1 Operations &maintenance 01 01 0 01 01 0 0 0 0 0 Total Expenditures 1 011 011 011 01 01 011 011 011 01 0 1 1 1 1 BIKEWAYS FUND NET BEFORE TRANSFERS I 39,59511 26,80211 24,80411 (1,998)1 25,0001 17,22311 17,200 II 17,200 II 17,2001 17,200 1 1 T T 1 Transfers Out 1 1 1 1 1 To CIPfund 80,0001 32,0001 30,002 1,9981 25,0001 17,223 17,200 17,2001 17,200 17,200 Total Transfers Out I 80,000 II 32,000 II 30,00211 1,9981 25,0001 17,22311 17,200 II 17,200 II 17,2001 17,200 BIKEWAYS FUND SUMMARY: Beginning Fund Balance 45,603 5,198 5,198 0 0 0 0 0 0 0 Plus:Revenues 39,595 26,802 24,804 (1,998)25,000 17,223 17,200 17,200 17,200 17,200 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 (80,000)(32,000)(30,002)1,998 (25,000) (17,223) (17,200)(17,200)(17,200) (17,200) Ending Fund Balance I 5,19811 011 011 01 01 011 011 011 01 0 1 1 1 1 1 1 1 1 1 1 2 - 4 6 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B Revenues Donations Grants Storm Drain User Fee Interest earnings Total Revenue Expenses Administration Maintenance Improvements &Engineering Equipment Purchases Total Expenses WOFP FUND NET BEFORE TRANSFERS Fund Transfer In From General Fund Total Transfer In Fund Transfer Out Total Transfer Out WOFP NET ASSET SUMMARY: Beginning Unrestricted Net Assets Plus:Revenues Less:Expenses Plus:Transfer In Less:Transfers Out Available Net Assets Invested in Capital Assets Ending Net Assets Per Financial Statements (m) 5,258,213 7,740,008 7,740,008 0 2,108,364 422,254 257,325 322,924 258,323 736,726 1,504,495 1,270,828 1,682,985 412,157 1,239,897 1,253,689 1,270,534 1,289,707 1,316,343 1,363,392 (3,741,893)(7,315,605)(7,314,629)976 (2,926,007)(1,418,618)(1,204,935)(1,354,308)(837,941)(767,068) 4,719,193 0 0 0 0 0 0 0 0 0 oT oT oj oj00000 0 I I I 1331 422,2541 257,32511 322,92411 258,32311 736,72611 1,333,050 2 - 4 7 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~=-"~~FY09·10 > RDA HOUSING SET·ASIDE FUND DETAIL IFund·2181 Revenues Property tax increment (e)199,645 204,600 220,201 15,601 211,700 211,400 217,700 225,400 234,400 244,900 Interest earnings (m)102,410 31,400 27,391 (4,009)10,600 3,600 8,400 20,800 36,900 53,200 Total Revenue I 302,05511 236,000 II 247,59211 11,5921 222,300 I 215,000 II 226,100 II 246,2001 271,300 298,100 Expenditures Operations &maintenance (b)20,676 174,670 308,806 (134,136)12,500 12,500 25,000 25,600 26,300 27,000 Land 0 0 432,094 (432,094)0 0 0 0 0 0 Capital Outlay 0 1,212,637 0 1,212,637 3,333,543 266,457 0 0 0 0 Total Expenditures I 20,67611 1,387,30711 740,900 II 646,4071 3,346,0431 278,95711 25,000 II 25,600 II 26,3001 27,000 I I 1 1 RDA HOUSING SET -ASIDE FUND NET BEFORE I 281,3791 (1,151,307)1 (493,308)11 657,9991 (3,123,743)1 (63,957)11 201,100 II 220,600 II 245,000 ITRANSFERS 271,100 1 1 1 1 Fund Transfer In I I 1 1 From City's Affordable Housing In-Lieu Fund 0 0 0 01 1,766,3681 01 01 0 0 0 Total Transfer In I 011 011 011 01 1,766,3681 011 011 011 01 0 RDA HOUSING SET -ASIDE FUND SUMMARY Beginning Fund Balance 2,279,680 2,561,059 2,561,059 0 2,067,751 710,376 646,419 847,519 1,068,119 1,313,119 Plus:Revenues 302,055 236,000 247,592 11,592 222,300 215,000 226,100 246,200 271,300 298,100 Less:Expenditures (20,676)(1 ,387,307)(740,900)646,407 (3,346,043)(278,957)(25,000)(25,600)(26,300)(27,000) Plus:Transfers In 0 0 0 0 1,766,368 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Available Fund Balance I 2,561,05911 1,409,75211 2,067,751 II 657,9991 710,3761 646,41911 847,51911 1,068,11911 1,313,1191 1,584,219 Land Asset 702,392 702,392 702,392 T T 1 Ending Fund Balance Per Financial Statements 3,263,451 2,112,144 2,770,143 1 1 1 T T 1 2 - 4 8 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '"..nMA"~g ~FY09·10_..........-RDA DEBT SERVICE FUND DETAIL IFund-4101 Revenues Property tax increment (e)797,983 826,800 901,061 74,261 846,900 845,500 870,900 901,400 937,500 979,700 Long term advance from city 1,122,578 0 876,927 0 760,400 885,200 802,700 1,063,700 1,330,600 1,551,800 Total Revenue I 1,920,56111 826,800 II 1,777,98811 74,261 ,1,607,300 ,1,730,700 II 1,673,600 II 1,965,100 II 2,268,100 I 2,531,500 Expenditures Pass thru to county fire department 168,784 175,700 187,211 (11,511)174,400 179,700 185,100 191,500 199,200 208,200 County administrative fee 16,491 13,900 18,509 (4,609)16,400 17,000 17,400 18,000 18,800 19,600 Repayment of county bonds 309,500 323,125 323,125 0 330,125 345,375 355,750 370,250 378,875 391,625 Repayment of county deferred interest debt 275,793 294,627 294,627 0 354,606 371,560 380,869 383,874 0 0 Interest on city advance 1,100,371 918,307 832,441 85,866 722,170 885,200 802,700 1,063,700 1,330,600 1,551,800 Total Expenditures I 1,870,93911 1,725,65911 1,655,91311 69,746'1,597,701'1,798,83511 1,741,81911 2,027,32411 1,927,4751 2,171,225 1 1 1 1 1 RDA DEBT SERVICE FUND NET BEFORE I 49,62211 (898,859)11 122,07511 144,007'9,599'(68,13511I (68,219)11 (62,224)11 340,6251 360,275 1 1 1 1 Fund Transfer In 1 1 1 1 1 From General Fund 0 0 0 01 01 01 01 01 0 0 Total Transfer In I 011 011 011 0' 0' 011 011 011 01 0 1 1 1 1 1 Fund Transfer Out 0 0 0 01 01 01 01 01 0 0 Total Transfer Out I 011 011 011 0'0'011 011 011 01 0 RDA DEBT SERVICE FUND SUMMARY: Beginning Fund Balance 431,980 481,602 481,602 0 603,677 613,276 545,141 476,922 414,698 755,323 Plus:Revenues 1,920,561 826,800 1,777,988 951,188 1,607,300 1,730,700 1,673,600 1,965,100 2,268,100 2,531,500 Less:Expenditures (1,870,939)(1,725,659) (1,655,913)69,746 (1,597,701)(1,798,835)(1,741,819) (2,027,324) (1,927,475) (2,171,225) Plus:Transfer In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Available Fund Balance For Debt Service I 481,60211 (417,257)11 603,67711 1,020,934'613,276'545,14111 476,92211 414,69811 755,3231 1,115,598 Long·Term Advance Due To The City 16,010,045 16,010,045 16,886,971 I I 1 1 1 Ending Fund Balance Per Financial Statements (15,528,443) (16,427,302) (16,283,294)I I I I I I I 1 1 1 2 - 4 9 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '"ESTIMATEg ~FY09-10 i .....~< RDA -PORTUGUESE BEND FUND DETAIL (Fund- 37~ Revenues Interest earnings (m)27,731 10,900 9,712 (1,188)7,300 2,590 6,350 11,330 15,200 17,080 Loans received 50,004 0 50,004 50,004 0 0 0 0 0 0 Total Revenue I 77,73511 10,900 II 59,7161/48,8161 7,300 I 2,5901/6,3501/11,3301/15,200 I 17,080 Expenditures Administration (b)19,561 23,900 17,829 6,071 28,675 28,966 29,800 30,600 31,400 32,300 Agency attorney (b)2,297 2,400 105 2,295 2,400 2,400 2,500 2,600 2,700 2,800 Total Expenditures I 21,85811 26,3001/17,9341/8,3661 31,0751 31,3661/32,300 II 33,2001/34,100 I 35,100 I I RDA-PORTUGUESE BEND FUND NET BEFORE I 55,87711 (15,400)11 41,78211 57,1821 (23,775)1 (28,776)11 (25,950)11 (21,870)11 (18,900)1TRANSFERS (18,020) 1 1 1 1 Transfers In 0 0 0 01 01 01 01 0 0 0 Total Transfers In I 011 01/011 01 01 011 011 011 01 0 1 1 1 1 Transfers Out 0 0 0 01 01 01 01 0 0 0 Total Transfers Out I 01/011 011 01 01 011 011 011 01 0 RDA-PORTUGUESE BEND FUND SUMMARY Beginning Fund Balance 443,382 499,259 499,259 0 541,041 517,266 488,490 462,540 440,670 421,770 Plus:Revenues 77,735 10,900 59,716 48,816 7,300 2,590 6,350 11,330 15,200 17,080 Less:Expenditures (21,858)(26,300) (17,934)8,366 (31,075) (31,366)(32,300) (33,200)(34,100)(35,100) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Less:Prior Period Adjustments 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 499,25911 483,85911 541,0411/57,1821 517,2661 488,490 II 462,540 II 440,670 II 421,770 I 403,750 1 1 I 1 2 - 5 0 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~=-~~~FY09-10 '( RDA -ABALONE COVE FUND DETAIL IFund-380\ Revenues Interest earnings (m)357 150 119 (31)90 30 80 160 230 270 Total Revenue I 35711 150 II 11911 (31)1 90 I 30 II 8011 160 II 230 I 270 I I 1 1 Expenditures I I I I Capital projects 0 0 0 01 01 01 01 01 0 0 Total Expenditures I 011 011 011 01 01 011 011 011 01 0 I I RDA -ABALONE COVE FUND NET BEFORE I 35711 150 II 11911 (31)1 90 I 30 II 80 II 160 II 230 ITRANSFERS 270 I I 1 1 1 Transfers In I I I I I From General fund 0 0 0 01 01 01 01 01 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 I I 1 1 1 Transfers Out 0 0 0 01 01 01 01 01 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 RDA -ABALONE COVE FUND SUMMARY Beginning Fund Balance 5,695 6,052 6,052 0 6,171 6,261 6,291 6,371 6,531 6,761 Plus:Revenues 357 150 119 (31)90 30 80 160 230 270 Less:Expenditures 0 0 0 0 0 0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 6,05211 6,20211 6,17111 (31)1 6,2611 6,29111 6,37111 6,53111 6,7611 7,031 1 I I 1 1 1 I I 1 1 2 - 5 1 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~.....,'~FY09-10-&ill IMPROVEMENT AUTHORITY -PORTUGUESE BEND FUND DETAIL IFund-285\ Revenues Interest earnings (m)15,780 3,880 3,969 89 2,820 1,030 2,160 3,100 3,000 1,880 Total Revenue I 15,78011 3,880 II 3,96911 891 2,820 I 1,03011 2,160 II 3,100 II 3,000 I 1,880 1 1 1 1 Expenditures 1 T T I Maintenance &Operations (b)83,331 1 135,100 82,253 52,8471 138,7001 141,700 145,800 149,6001 153,500 157,800 Total Expenditures I 83,33111 135,100 II 82,25311 52,8471 138,700 I 141,700 II 145,800 II 149,600 II 153,500 I 157,800 1 1 I I IMPROVEMENT AUTHORITY -PORTUGUESE BEND I (67,551)11 (131,220)11 (78,284)11 52,9361 (135,880)1 (140,670)11 (143,840)11 (146,500)11 (150,500)1FUNDNETBEFORETRANSFERS (155,920) 1 1 1 1 1 1 Transfers In 1 I T T I I From General fund 14,0001 91,5001 82,252 1 (9,248)1 110,0001 101,000 104,000 107,0001 110,000 113,000 Total Transfers In I 14,00011 91,500 II 82,25211 (9,248)1 110,000 I 101,000 II 104,000 II 107,000 II 110,000 I 113,000 1 1 1 1 1 1 Transfers Out 01 01 01 01 01 0 0 01 0 0 Total Transfers Out I 011 011 011 01 01 011 011 011 01 0 IMPROVEMENT AUTHORITY -PORTUGUESE BEND FUND SUMMARY Beginning Fund Balance 281,196 227,645 227,645 0 231,613 205,733 166,063 126,423 86,923 46,423 Plus:Revenues 15,780 3,880 3,969 89 2,820 1,030 2,160 3,100 3,000 1,880 Less:Expenditures (83,331)(135,100)(82,253)52,847 (138,700) (141,700) (145,800) (149,600)(153,500)(157,800) Plus:Transfers In 14,000 91,500 82,252 (9,248)110,000 101,000 104,000 107,000 110,000 113,000 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 227,64511 187,92511 231,61311 43,6881 205,7331 166,06311 126,42311 86,92311 46,4231 3,503 1 1 T T T 1 1 1 1 1 1 1 2 - 5 2 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~..nMAIT~~FY09·10_......... IMPROVEMENT AUTHORITY -ABALONE COVE FUND DETAIL IFund·795\ Revenues Interest earnings (m)85,905 32,900 26,082 (6,818)19,500 6,500 15,500 26,800 36,900 42,700 Total Revenue I 85,90511 32,900 II 26,08211 (6,818)1 19,500 I 6,500 II 15,500 II 26,800 II 36,900 I 42,700 Expenditures RDA Storm Drain User Fee 2,722 2,776 2,776 a 2,776 2,790 2,825 2,881 2,939 2,998 Operations (b)40,209 44,000 32,356 11,644 45,400 46,700 48,000 49,200 50,500 51,900 ACLAD Contribution 67,500 60,000 a 60,000 40,000 60,000 60,000 a a a Total Expenditures 1 110,43111 106,77611 35,13211 71,6441 88,1761 109,490 II 110,82511 52,08111 53,4391 54,898 1 1 1 1 1 IMPROVEMENT AUTHORITY -ABALONE COVE 1 (24,526)11 (73,876)11 (9,050)11 64,8261 (68,676)1 (102,990)11 (95,325)11 (25,281)11 (16,539)1FUNDNETBEFORETRANSFERS (12,198) 1 1 1 1 1 Transfers In I T T T I From General fund 6,000 01 01 01 01 01 a a a a Total Transfers In 1 6,000 II all a II a I a I all all all 01 a 1 1 1 1 1 Transfers Out a 01 01 01 01 01 a a a a Total Transfers Out 1 all all a II a I a I all a II all 01 a IMPROVEMENT AUTHORITY -ABALONE COVE FUND SUMMARY Beginning Fund Balance 389,807 371,281 371,281 a 362,231 293,555 190,565 95,240 69,959 53,420 Plus:Revenues 85,905 32,900 26,082 (6,818)19,500 6,500 15,500 26,800 36,900 42,700 Less:Expenditures (110,431) (106,776)(35,132)71,644 (88,176)(109,490)(110,825)(52,081)(53,439) (54,898) Plus:Transfers In 6,000 a a a a a a a a a Less:Transfers Out a a a a a a a a a a Expendable Fund Balance I 371,28111 297,40511 362,23111 64,8261 293,5551 190,56511 95,240 II 69,95911 53,420 I 41,222 Unexpendable Endowment 1,000,000 1,000,000 1,000,000 1 1 1 1 Ending Fund Balance Per Financial Statements 1,371,281 1,297,405 1,362,231 1 1 T I T T T 1 2 - 5 3 CIP FUND PROJECTS Street Infrastructure CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL CIP PLAN PROJECT EXPENDITURES EXHIBITC Ifllmllli ~~~~~~1'II~tl~IIII_~mllll~IJIFUNDINGSOURCE ~~:;~::::::~~rt::~1 '520'=Og~+~~:~~~~~~!~:==:~0~=:'5~0~'~OQ~~='=~~;~:::e~~ir~~~~[~~=~~_ Bus Shelter Improvements 1 15,441 12,450 I I 1Prop A PVDS'PVDE Roadside Landscaping 1 90,110 I I IBeautification Arterial Median Improvements 12,784 544,591 250,000 250,000 250,000 Beautification Traffic SiW;a1~Crenshaw'Crestridge -------------..--..-----..-..---------11 ,217 263,000 ---..------------------..----..-..----'-----II-::G-e-ne-r-a=--If=--un-d"":""G---ra---n-t---------------------------1 Traffi~-Calming Toscanini ----------------------2-0-,8-31 -----------------------CIP Accumulated Fund Balance PVDE Safety Improvements 280,000 90%Grant/10%General Fund ADA Curb Ramp Improvements ------..--..--..-..--..--..15,616 -25,000 ..--------------..-------------..-..--..-..General Fu~d Pedestrian Improvements on Hawthorne Blvd 1 I 285,400 I 1,141,600 180%Grant/20%City Match PVDS Bikeway Safety Project I I 813,000 I IProp C &Grant Study PVDS in Landslide Area Parks &Open Space Infrastructure 50,000 PVIC &Forrestal Traillmprovements I 106,584 7,700 I I IGeneral fund Ifi~~;~~;;:~~::----------_..__..__..~1?2_~~:~~i I ..------------..--------..-..---..---~:~:~::~~~:---====1 Ir::~l~~;::~S:~~i~nn~~~~--~~:~~-=-~:~~-~---~----~~~~g-~~:I==--"~,O~O -I=~~=~~~==:::~===-~===~::~~::::~::~~----~-__~~:T~:_~~~~~~-~~~::::~-~--------l Antenna Repeater at San Pedro Hill Trailhead I I 15,000 I ICIP Accumulated Fund Balance ~::~r~:~~~~~~c:~~~a~~~:n~e~~L---..-..--..j-..------------------~-251 ,300+------------....J..,..000,000 ..__..__..__..-1~~~eral f~_'!..__.._..__..__ Hesse Park Field Upgrade Phase I &II I I 146,300 I 500,000 IGeneral fund'EET PVIC Exhibits --Phase II 1 I 600,000 I IDonations &Annenberg Grant Forrestal Open Space Gate I I 12,000 I ICIP Accumulated Fund Balance Abalone Cove Parking Lot Gate &Railing I I 3,000 I ICIP Accumulated Fund Balance Point Vicente Interpretive Center Curb Lighting I I 5,000 I ICIP Accumulated Fund Balance Coastal Access Trail I I I 425,000 425,000 180%Grant/20%General Fund Match ~~:~~~::;E~~;:::~~~::~~~~:~:~=t=-~=:~==-=:~::~~=i 6,600;J=--=:::~=~==-~1@J@:~::~::~~~~~~~~=::-~:~:~-=-----..~~~~~~~:~~~¥~~~£:~~~~~ I~;:~~~:::~~:~~~:oe:~:::;:~:'DeSign +--------..----..---------..----1~~~Qg%,g~-----------------..---------------..--..---------------1~~:~::i~~~-..----------------1 'sewer Infrastructure I I I I Sewer Overflow Capacity Analysis GerlerarAdiTiinfstrai:loniMaintenance Total CIP Fund Expenditures 69,282 17,000 CIP Accumulated Fund Balance NOTE:The Total Expenditures above agree to Total CIP fund expenditures on Page 9 of the Model. 2 - 5 4 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL WATER QUALITY FLOOD PROTECTION (STORM DRAIN)EXPENSES EXHIBITD -II~il'~I'II~~~:Ilill_llr"lll<rlll.lliril~i]FUNDINGSOURCEWQFPFUNDPROJECTS Backbone Projects McCarrell Canyon McCarrell Canyon Land Aqcquisition Sunnyside Ridge PVDE/PVDS Roadway Stabilization 1,005,197 6,139,8881 167,000 1,408,493 377,666 10,98011,152,000 350,000 General Fund/User Fees General Fund/User Fees User Fees Pipe Lining Monero Storm Drain User Fees other 470,262 652,716 524,822 314,617 319,555 324,642 331,135 337,758 General Fund/User Fees Capacity &Secondary System Projects Via Colinita,Roan &Miraleste User Fees Via Coli nita Vickery canyon 251,500 292,500 User Fees Hawthorne Blvd 370,000 200,000 User t-ees eVlces 7,4911 User Fees 95,00 60,000 45,5 IMiscellanous Repairs &Mainlenance IMisc.Storm Drain Repairs 25,880 44,590 1 55,000 IStorm Drain &Filtration Maintenance 56,178 216,890 1 271,495 IPush Camera For Storm Drain Inspecflon IStorm Drain Master Plan Update Administration (contract/staff engineer)140,183 242,0741 144,190 Grand Total-WQFP Fund Expenditurel 3,729,7441 7,314,6281 2,926,007 IGeneral Fund 237,687 244,817 252,162 349,727 267,518 IUser Fees IGeneral Fund 625,000 IGeneral Fund 146,314 148,062 152,504 157,079 161,792 IUser Fees 1,418,61811,204,93511,354,3081 837,941 1 767,068 2 - 5 5 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL 2010-11 SUMMARY OF FUND TRANSFERS EXHIBITE TRANSFERS TO FUND: Abalone Capital Water Quality RDA RDA TRANSFERS FROM FUND:Street Cove Improvement &Flood Habitat RPV Sub1 Debt Port.Bend General Maintenance Sewer District Proaram Protection Restoration Proposition A TV Maint.CDBG Service Imp.Auth.Total General 0 10,700 3,806,052 0 109,900 60,000 85,000 70,000 0 47,200 101,000 4,289,852 Beautification 165,200 250,000 415,200 Waste Reduction 12,000 0 12,000 Utility Undergrounding 90,000 90,000 CDBG 0 0 1972 Act 204,000 204,000 1911 Act 104,100 104,100 Proposition A 0 0 0 Proposition C 500,300 0 500,300 Recreation Improve Donations 0 0 Environmental Excise Tax 40,000 40,000 Bikeways 17,223 17,223 Measure A 151,000 151,000 Public Safety Grants 100,000 100,000 TOTAL 353,000 973,600 10,700 4,113,275 0 109,900 60,000 85,000 70,000 0 47,200 101,000 5,923,675 2 - 5 6 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL 2011-12 SUMMARY OF FUND TRANSFERS EXHIBITE TRANSFERS TO FUND: Abalone Capital Water Quality RDA RDA TRANSFERS FROM FUND:Street Cove Improvement &Flood Habitat Building RPV Sub 1 Debt Port.Bend General Maintenance Sewer District Program Protection Restoration Replacement TV Maint.Service Imp.Auth.Total General 30,000 10,700 2,927,800 0 113,100 0 90,000 65,000 48,100 104,000 3,388,700 Beautification 170,000 0 170,000 Waste Reduction 12,000 12,000 Utility Undergrounding 90,000 90,000 CDBG 0 0 1972 Act 205,000 205,000 1911 Act 107,100 107,100 Proposition A 0 0 0 Proposition C 463,300 2,040,000 2,503,300 Bikeways 17,200 17,200 Measure A 151,000 151,000 Public Safety Grants 100,000 100,000 TOTAL 353,000 975,400 10,700 4,985,000 0 113,100 0 90,000 65,000 48,100 104,000 6,744,300 2 - 5 7 CITY OF RANCHO PALOS VERDES 2010 FIVE·YEAR FINANCIAL MODEL 2012-13 SUMMARY OF FUND TRANSFERS EXHIBITE TRANSFERS TO FUND: Abalone Capital Water Quality RDA RDA TRANSFERS FROM FUND:Street Cove Improvement &Flood Habitat Building RPV Sub 1 Debt Port.Bend General Maintenance Sewer District ProQram Protection Restoration Replacement TV Maint.Service Imp.Auth.Total General 105,000 10,700 1,752,800 0 116,000 0 90,000 55,000 49,100 107,000 2,285,600 Beautification 174,400 250,000 424,400 Waste Reduction 12,000 12,000 CDBG 0 0 1972 Act 205,000 205,000 1911 Act 109,900 109,900 Proposition A 0 0 0 Proposition C 475,300 0 475,300 Bikeways 17,200 17,200 Measure A 151,000 151,000 Public Safety Grants 100,000 100,000 TOTAL 263,000 1,069,600 10,700 2,020,000 0 116,000 0 90,000 55,000 49,100 107,000 3,780,400 2 - 5 8 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL 2013-14 SUMMARY OF FUND TRANSFERS EXHIBITE TRANSFERS TO FUND: Abalone Capital Water Quality RDA RDA TRANSFERS FROM FUND:Street Cove Improvement &Flood Habitat Building RPV Sub 1 Debt Port.Bend General Maintenance Sewer District ProQram Protection Restoration Replacement TV Maint.Service Imp.Auth.Total General 140,000 10,700 1,482,800 0 119,000 0 90,000 45,000 50,100 110,000 2,047,600 Beautification 178,900 178,900 Waste Reduction 12,000 12,000 CDBG 0 0 1972 Act 195,000 195,000 1911 Act 112,700 112,700 Proposition A 0 0 0 Proposition C 487,600 0 487,600 Bikeways 17,200 17,200 Measure A 151,000 151,000 Public Safety Grants 100,000 100,000 TOTAL 263,000 1,114,200 10,700 1,500000 0 119,000 0 90,000 45000 50,100 110,000 3,302,000 3,302,000 o 2 - 5 9 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL 2014-15 SUMMARY OF FUND TRANSFERS EXHIBITE TRANSFERS TO FUND: Abalone Capital Water Quality RDA RDA TRANSFERS FROM FUND:Street Cove Improvement &Flood Habitat Building RPV Sub1 Debt Port.Bend General Maintenance Sewer District Proaram Protection Restoration Replacement TV Maint.Service Imp.Auth.Total General 170,000 10,700 1,482,800 0 122,300 0 95,000 50,000 51,100 113,000 2,094,900 Beautification 183,900 250,000 433,900 Waste Reduction 12,000 12,000 CDBG 0 0 1972 Act 194,000 194,000 1911 Act 115,800 115,800 Proposition A 0 0 0 Proposition C 501,200 25,000 526,200 Bikeways 17,200 17,200 Measure A 151,000 151,000 Public Safety Grants 100,000 100,000 TOTAL 263,000 1,164900 10,700 1 775000 0 122300 0 95,000 50000 51,100 113,000 3,645,000 3,645,000 o 2 - 6 0