The URL can be used to link to this page

RPVCCA_SR_2010_06_15_04_2010_Five-Year_Fiancial_ModelCITY OF MEMORANDUM RANCHO PALOS VERDES TO: FROM: DATE: SUBJECT: REVIEWED: Staff Coordinator: HONORABLE MAYOR &MEMBERS OF THE CITY COUNCIL DENNIS McLEAN,DIRECTOR OF FINANCE &INFORMATION ~ TECHNOLOGY '{jf![) JUNE 15,2010 2010 FIVE-YEAR FINANCIAL MODE~~r) CAROLYN LEHR,CITY MANAGER c..!Y---' Kathryn Downs,Deputy Director of Finance &Information I (Jf\ Technology ~vU RECOMMENDATION 1.Approve the 2010 Five-Year Financial Model (2010 Model). 2.Determine that the utility users'tax (UUT)rate of 3%continues to be a necessary General Fund revenue source,and that the current rate of 3%should be maintained. EXECUTIVE SUMMARY Draft FY10-11 Budget The 2010 Model includes the draft FY10-11 Budget,which is currently balanced with net activity of $763 and an estimated ending General Fund Reserve of about $10.3 million at June 30,2011.The estimated ending Reserve is about $1.3 million more than the policy threshold of about $9 million (50%of annual General Fund expenditures).The estimate of excess General Fund Reserves incorporates the FY09-10 $330,125 Supplemental Educational Revenue Augmentation Fund (SERAF)payment made to the state on May 10, 2010. 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 4-1 2010 FIVE·YEAR FINANCIAL MODEL June 15,2010 Page 2 of 11 services in the operating budget.On May 22,2010,Staff provided an overview of a proposed revision of the City Council Policy No.41:"Reserve Policies"to memorialize this continuing recommendation. Staff has included the 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 grant-funded park improvements to the Coastal Access Trail,Gateway Park,and Abalone Cove Shoreline Park ($145,000). The uses of TOT revenue summarized above have been included as "funded"projects in the 2010 CIP as presented to City Council on May 22,2010. 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). Finance Advisory Committee Review The Finance Advisory Committee (FAC)reviewed the 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 of the 2010 calendar year. In response to Staff's suggestion that the Street Maintenance Fund reserve policy may be decreased to something less than one 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. With the increase of expenditures and the corresponding increase ofthe reserve threshold, the actual reserve is expected to be less than the policy level at the end of FY1 0-11.Staff believes that the Street Maintenance reserve will be replenished over the next several years through expenditure savings and additional interest earnings. 4-2 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 3 of 11 Update -State Budget and Cash Crisis The Governor's draft of the state budget (revised in May)estimates the state's FY10-11 deficit at $1 0.2 billion.Steps to balance the state budget include drastic reduction of social programs,impacts to county revenues,and salary reductions for state workers.However, the impacts to cities are indirect and primarily consist of the Transportation Funding Swap and deferral of certain payments.Rancho Palos Verdes remains largely unaffected by the state's crisis. 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 Proposition 42 revenue will 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 Redevelopment Agency may be required to make the SERAF payment for FY1 0-11, which is estimated to be about $68,000.Funding for this payment,if required,would likely necessitate an additional loan from the City's General Fund to the redevelopment agency. 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 4-3 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 4 of 11 total General Fund revenue).Based upon the capital needs of the City,as evidenced by 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. With this agenda item,the City Council must determine whether 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. 4-4 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 5 of 11 The 2010 Model includes several schedules organized as follows: Exhibit A Exhibit B Exhibit C Exhibit D Exhibit E One Page Summary -201 0 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 acquired property transfer information from a land management database that indicates a property tax increase of about 0.5%for FY10-11.Staff 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 4-5 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 6 of 11 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. 4)The Terranea Resort has generated more than $1.8 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-1 O.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.On May 22,2010,Staff 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 has been reduced from 6%of the cost of services to 4%.Total annual savings is expected to be about $120,000, which has been reflected in the 2010 Model. 6)Staff has been working with the City's grant consultantto 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. 4-6 201 0 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 7 of 11 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 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 a public hearing expected to be held on July 6,2010.Staff will recommend a 1.4% increase to the Fee for FY10-11 (from $89.47 to $90.72 per equivalent residential unit or ERU),based upon the change in CPI for the 12 months ended February 2010.The Storm Drain Oversight Committee is expected to present its annual report at the July 6th public hearing.At its June 8th meeting,the Committee unanimously supported Staff's recommendation to increase the FY1 0-11 Fee to the maximum rate of $90.72 per ERU. 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,a number of projects that affect 5 systems with an estimated total cost of about $10 million remain unfunded through FY14-15.As described previously,the estimated cost of the San Ramon Stabilization project is $19.5 million and is currently unfunded.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 (i.e.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. 4-7 2010 FIVE-YEAR FINANCIAL MODEL June 15,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 201 0 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 future average General Fund subsidies of more than $100,000 annually (reflected in this version ofthe 201 0 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 FY1 0-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. 4-8 2010 FIVE-YEAR FINANCIAL MODEL June 15,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.Staff presented several alternative funding plans for median improvements and neighborhood grants to the City Council on May 18th .The City Council established an ad-hoc committee to further study the funding alternatives. 14 )Currently,the City Council's reserve policy includes a requirement to 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 FY1 0,- 11 Budget also includes a one-time allocation of $50,000 to study long-term solutions to this consistent road maintenance problem.The FAC has recommended that the City continue to keep one year of maintenance costs on reserve.As such, the Street Maintenance reserve is expected to be about $150,000 of the policy threshold.Staff believes that this reserve will be replenished over the next several years through expenditure savings and additional interest earnings. 15)ln 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 (Le. 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 were set at 2.939%of the City's covered payroll.As a result of this payment,pension costs will decrease by about $150,000 annually; which has been included 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 4-9 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 10 of 11 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 budget document included approximately $86,000 annually for this service in the Recreation Administration program of the General Fund.The estimated FY10-11 cost of the agreement approved on December 151 is about $115,000;however,at the May 22nd Budget Workshop,the City Council enhanced this service with an additional $40,000 allocation.The total $155,000 allocation has been included in the Public Safety Special Programs expenditure of 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 FY1 0-11 and FY11-12 projects.The CIP reserve is expected to increase from FY12-13 through FY14-15 from interest earnings.Staff expects that additional project savings will replenish the reserve over the next several years until it reaches the policy threshold. 21 )The 2010 Model indicates that the fund balance of the Improvement Authority's Abalone Cove fund will continue to 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.In addition,the City is required to pay $45,274 of ACLAD assessments for city-owned property,which is about 57%of ACLAD's total assessments.Therefore, the City's total contribution to ACLAD is expected to be more than $105,000 for FY10-11. 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. 4-10 2010 FIVE-YEAR FINANCIAL MODEL June 15,2010 Page 11 of 11 23)The Marymount College petition for a ballot measure has qualified for a November 2010 Special Election.In a letter dated May 201 0,Marymount College has offered to pay for the entire cost of the Special Election,which has been estimated to be about $78,000.Therefore,this expenditure has not been added to the FY10-11 budget. 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 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.(AMCAL)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. 4-11 CITY OF RANCHO PALOS VERDES 2010 FIVE·YEAR FINANCIAL MODEL EXHIBIT A Fund Balance 0-11 Estimated Resource 0-11 Estimated Appropriation4 Fund Bal FundBal Fund Bal Fund Bal Fund Bal Fund 6/30/2010 Revenues Transfers In Expenditures Transfers Out 6/30/2011 6/30/2012 6/30/2013 6/30/2014 6/30/2015 Unrestricted GENERAL 10,264,429 21,747,717 379,848 (17,832,855)(4,293,947)10,265,192 10,792,540 12,432,888 14,522,736 16,727,484 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,117,370 (5,503,295)-3,031,888 2,898,488 2,951,488 3,035,088 3,139,488 UTILITY UNDERGROUNDING 277,870 1,390 --(90,000)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 68,500 -(255,300)-1,695,958 1,657,958 1,636,858 1,630,158 1,631,158 BUILDING REPLACEMENT 830,851 4,200 -(34,500)-800,551 810,951 830,851 859,551 894,351 EMPLOYEE BENEFITS 4 1,825,467 -(1,804,560)-20,911 21,181 21,701 22,451 23,361 Subtotal 7,204,535 3,130,877 4,202,370 (7,780,901)(505,200)6,251,681 6,044,391 5,893,171 6,041,731 5,980,771 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 244,994 -(262,146)(26,848)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,584,618)-91,325 23,825 50,924 35,226 122,150 RDA HOUSING SET ASIDE 710,376 225,900 -(278,957)-657,319 867,619 1,095,719 1,346,619 1,621,919 RDA DEBT SERVICE 613,276 1,509,880 -(1,543,615)-579,541 539,122 498,498 854,523 1,223,598 RDA -PORTUGUESE BEND 303,516 1,520 -(31,366)-273,670 244,930 217,730 191,140 163,780 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,747,876 7,155,797 1,325,200 (7,877,322)(1,155,471 6,196,080 4,175,934 4,396,320 5,004,625 5,701,020 GRAND TOTAL 24,216,840 32,034,391 5,907,418 (33,491,078)(5,954,618)22,712,953 21,012,865 22,722,379 25,569,091 28,409,274 4-12 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '"ESTIMATE~FY09·10 ........../..i ...<.ii..i ..%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 NlA 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%2.0%2.5%3.0%3.5% Sheriff Contract (%)(f)N/A N/A N/A N/A N/A 2.0%3.0% 3.0% 3.0%3.0% Planning Permit Revenues (%)(g)N/A N/A NlA N/A N/A 0.0%4.8% 4.7%4.7%5.0% Building and Safety Revenues (%)(h)N/A N/A NlA N/A N/A 0.0%4.8% 4.7%4.7%5.0% Vehicle license Fee (VLF)(%)(i)N/A N/A NlA 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 NlA 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.50%1.30%2.45%3.45%4.05% Utility Users Tax (%)(n)N/A N/A NlA N/A N/A 0.4%1.3%1.2%1.2%1.5% Franchise Tax (%)(0)N/A N/A N/A N/A N/A 0.5%1.3%1.2% 1.2%1.5% Facility Rentals (%)(p)N/A N/A N/A N/A N/A -3.0%1.3% 1.2% 1.2%1.5% 4-13 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B g .....,,~••••=..=t.~FY09·10f'Y'~~'11 ..............._.... »».......< SUMMARY OF ENDING UNRESERVED FUND w BALANCES : UNRESTRICTED FUND (101)General Fund ;~12,171,332 0 10,440,256 10,440,256 10,264,429 10,265,192 10,792,540 12,432,888 14,522,736 16,727,484 RESTRICTED BY COUNCIL ACTION I (212)Beautification Fund .1'>1 1,327,191 916,507 1,367,251 450,744 621,170 408,266 445,776 237,296 274,586 63,706 (226)RPV1VFund ·iEJ 41,593 (3,757) (4,714)(957)1,696 1,274 3,394 3,274 884 824 (330)CIP Fund :a 3,395,966 9,224,647 7,207,180 (2,017 ,467)3,487,133 3,031,888 2,898,488 2,951,488 3,035,088 3,139,488 (341)Utility Undergrounding Fund 269,241 276,041 273,770 (2,271)277,870 189,260 101,720 104,210 107,810 112,180 (342)Roadway Beautification Fund 99,875 102,375 101,553 (822)103,053 103,573 104,923 107,493 111,203 115,703 (681)Equipment Replacement Fund :~3,023,617 2,797,797 2,968,158 170,361 1,882,758 1,695,958 1,657,958 1,636,858 1,630,158 1,631,158 (686)Building Replacement Fund 1,507,730 1,322,344 1,326,051 3,707 830,851 800,551 810,951 830,851 859,551 894,351 (685)Employee Benefits Fund 899,244 37,221 204,841 167,620 4 20,911 21,181 21,701 22,451 23,361 SUBTOTAL 10,564,457 14,673,175 13,444,090 (1,229,085)7,204,535 6,251,681 6,044,391 5,893,171 6,041,731 5,980,771 RESTRICTED BY LAW OR EXTERNAL AGENCIES City Funds (202)Street Maintenance Fund 15 578,589 417,098 424,481 7,383 403,055 356,951 313,291 319,871 326,411 331,931 (203)1972 Act Landscape &Lighting Fund 1~47,305 57,478 58,659 1,181 48,018 32,645 17,686 3,848 990 964 (209)EI Prado Lighting Fund .Jttj 9,572 10,702 11,138 436 2,168 3,088 4,078 5,168 6,378 7,708 (310)CDBG Fund :il ""(17)(6)11 44,000 0 0 0 0 0 (211)1911 Act Street Lighting Fund '"1,591,701 1,444,901 1,632,607 187,706 1,560,007 1,449,607 1,342,507 1,243,307 1,147,807 1,048,007 (213)Waste Reduction Fund 319,550 175,930 174,105 (1,825)123,787 128,468 131,338 133,158 133,848 132,768 (214)Air Quality Management Fund 52,197 53,507 52,776 (731)53,376 53,446 53,936 55,056 56,756 58,856 (215)Proposition C (Streetsffransit)Fund I 1,976,356 178,385 2,564,999 2,386,614 1,303,320 1,646,890 2,400 364,560 726,940 1,067,580 (216)Proposition A (Transit)Fund 223,971 287,778 197,694 (90,084)71,917 3,131 (136,812)(287,652)(449,547)(622,757) (217)Public Safety Grants 65,200 33,635 34,540 905 905 905 915 935 965 1,005 (222)Habitat Restoration Fund =.233,257 190,580 225,180 34,600 201,189 185,688 171,098 157,888 145,538 133,128 (223)Subregion 1 Maintenance Fund 760 1,860 17,336 15,476 6,636 1,436 4,936 5,336 1,436 4,736 (224)Measure A Cap.&Main!.Funds 9,405 305 33,928 33,623 33,928 34,098 34,538 35,388 36,608 13,088 (225)Abalone Cove Sewer District Fund ~••117,713 69,823 93,594 23,771 56,476 50,810 44,660 38,290 31,320 23,390 (227)Ginsburg Cultural Arts Building Fund 492,045 504,245 500,503 (3,742)208,103 209,143 211,863 217,Q53 224,543 233,633 (228)Recreation Improvements Donations Fund 2,048 2,Q48 2,082 34 2,082 2,092 2,122 2,172 2,242 2,332 (334)Quimby Fund .•..1t]24,754 12,064 25,170 13,106 25,170 25,300 25,630 26,260 27,170 28,270 (337)Affordable Housing In-Lieu Fund :.1,155,231 843,299 838,333 (4,966)7,975 8,015 8,115 8,315 8,605 8,955 (338)Environmental Excise Tax (EEn Fund 824,223 830,768 839,293 8,525 40,793 39,593 40,103 41,083 42,503 44,223 (340)Bikeways (TDA Artide 3)Fund 5,198 0 0 0 0 0 0 0 0 0 (501)Water Quality &Flood Protection Fund 35,7,740,008 1,695,231 2,108,364 413,133 422,254 91,325 23,825 50,924 35,226 122,150 RDA &Improvement Authority Funds (218)RDA Housing Set-Aside ~$2,561,059 1,409,752 2,067,751 657,999 710,376 657,319 867,619 1,095,719 1,346,619 1,621,919 (410)RDA Debt Service Fund .~481,602 (417,257)603,677 1,020,934 613,276 579,541 539,122 498,498 854,523 1,223,598 (375)RDA -Portuguese Bend Fund =.499,259 483,859 541,041 57,182 303,516 273,670 244,930 217,730 191,140 163,780 (380)RDA -Abalone Cove Fund 6,052 6,202 6,171 (31)6,261 6,291 6,371 6,531 6,761 7,031 (285)Improvement Authority -Portuguese Bend 227,645 187,925 231,613 43,688 205,733 166,063 126,423 86,923 46,423 3,503 (795)Improvement Authority -Abalone Cove 371,281 297,405 362,231 64,826 293,555 190,565 95,240 69,959 53,420 41,222 SUBTOTAL 19,615,964 8,777,506 13,647,260 4,869,754 6,747,876 6,196,080 4,175,934 4,396,320 5,004,625 5,701,020 GRANDTOTAL-ALLFUNDSINCLUDED 42,351,753 123,450,681 II 37,531,60611 14,080,9251 24,216,840 I 22,712,9531 21,012,865 I 22,722,37911 25,569,091 I 28,409,274 I I I 4-14 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~I ESTIMATE FY09·10 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,364,200 6,523,300 6,719,000 6,954,200 Property taxes In-Lieu of VLF Revenues (e)3,210,504 3,405,000 3,388,494 (16,506)3,428,500 3,490,200 3,560,000 3,649,000 3,758,500 3,890,000 Property taxes In-Lieu of Sales Tax (e)320,839 288,400 301,454 13,054 301,500 310,500 316,700 324,600 334,300 346,000 Sales and use tax (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 tax (k)240,572 198,900 178,813 (20,087)207,100 180,000 183,600 187,300 191,000 194,800 Business license tax/Application processing (e)499,014 521,800 531,982 10,182 515,600 520,800 527,300 533,400 539,800 547,900 Transient occupancy tax (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 taxes {oj 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 Utility user tax (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 tax (e)356,963 333,000 278,343 (54,657)333,000 336,300 340,500 344,400 348,500 353,700 Total Taxes 15,291,092 15,810,100 15,656,090 (154,O10)17,916,975 18,481,517 18,763,900 19,096,300 19,491,500 19,970,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 Right of way &parking permits (h)51,478 49,800 39,819 (9,981)63,800 59,100 61,900 64,800 67,800 71,200 Building and safety permits &geology fees (h)1,446,761 1,184,950 1,278,568 93,618 691,080 1,351,200 1,415,400 1,481,200 1,550,800 1,628,300 Planning permits (g)325,396 362,763 367,545 4,782 1,116,120 495,600 519,100 543,200 568,700 597,100 Film permits (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 Total Licenses &Permits 1,913,542 1,691,913 1,754,687 62,774 1,992,100 2,014,500 2,106,800 2,201,400 2,356,300 2,412,600 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 Total Fines &Forfeitures 259,639 241,600 213,900 (21,700)218,500 217,000 221,400 225,900 230,400 235,000 USE OF MONEY &PROPERTY: Property &Monopole Leases (e)181,376 179,600 158,019 (21,561)180,500 127,300 99,700 100,800 102,000 103,500 Facility rentals -PVlC {pI 166,072 177,350 181,534 4,164 176,800 180,000 182,300 164,400 186,600 189,400 Facility rentals -Other {pI 150,456 119,100 130,699 11,599 111,900 105,000 106,300 107,500 108,800 110,400 Parking lolfees 43,522 42,800 43,857 1,057 43,500 43,500 43,500 43,500 43,500 43,500 PVlC gift shop (e)99,989 72,000 80,272 8,272 97,400 98,100 99,300 100,400 101,600 103,100 Interest earnings (m)590,139 222,500 266,124 43,624 90,100 65,000 146,400 288,900 463,400 628,700 Total Use of Money &Property 1,231,554 813,350 860,505 47,155 700,200 618,900 677,500 825,500 1,005,900 1,178,600 CHARGES FOR SERVICES: Recreation fees-REACH (e)8,338 8,900 8,863 (37)8,900 9,000 9,100 9,200 9,300 9,400 Sale of Signs/Services (e)7,746 6,500 4,618 (1,882)6,500 6,600 6,700 6,800 6,900 7,000 Interfund charges for services (a)141,200 145,300 145,300 0 148,200 151,200 154,200 157,300 160,400 163,600 Total Charges For Services 157,284 160,700 158,781 (1,919)163,600 166,800 170,000 173,300 176,600 180,000 REVENUES FROM OTHER AGENCIES Motor vehide license fees (i)195,987 172,500 147,904 (24,596)140,000 140,000 140,000 140,000 140,000 140,000 Grant income 361,104 50,000 4,797 (45,203)62,972 75,000 15,000 15,000 15,000 15,000 Total 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 15,100 15,400 15,700 16,000 16,300 Other miscellaneous (a)123,307 75,900 82,314 6,414 20,400 18,900 19,300 19,700 20,100 20,500 Total Other Revenues 137,736 90,400 119,496 29,096 35,200 34,000 34,700 35,400 36,100 36,800 TOTAL GENERAL FUND REVENUES 19,547,938 19,030,563 18,916,160 (114,403)21,229,547 21,747,717 22,129,300 22,712,800 23,451,800 24,168,600 4-15 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~'''MA''~~~FY09-10 "«......../...«................... ....... GENERAL FUND EXPENDITURE DETAIL City Council {bl 90,176 116,800 104,015 12,785 97,378 95,935 98,700 101,300 103,900 106,800 City Manager {bl 1,418,444 1,268,530 1,266,989 1,541 1,533,856 1,530,867 1,518,400 1,557,700 1,597,900 1,642,300 City Attorney (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 {bl 367,060 282,530 276,389 6,141 387,463 279,549 385,900 301,200 408,800 420,200 Community Outreach {bl 133,743 156,550 143,350 13,200 100,650 83,400 85,800 88,000 90,300 92,800 Personnel {bl 101,621 249,273 179,064 70,189 211,583 207,469 216,700 222,300 228,000 234,300 Finance {bl 901,287 1,063,042 1,053,750 9,292 1,242,180 1,283,570 1,345,200 1,380,000 1,415,600 1,455,000 Information Technology -Data {bl 559,447 776,310 705,669 70,641 568,340 628,067 649,700 666,500 683,700 702,700 Information Technology -Voice {bl 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,266,827 5,491,900 5,539,400 5,782,100 5,942,900 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 {bl 51,Q43 86,365 71,934 14,431 70,000 212,545 218,700 224,400 230,200 236,600 Animal Control (b)103,239 154,677 117,926 36,751 125,250 125,250 128,900 212,200 135,600 139,400 Emergency Preparedness {bl 64,909 81,178 69,229 11,949 114,177 99,645 107,100 109,900 112,700 115,800 Total Public Safety 4,028,825 4,322,370 4,200,970 121,400 4,291,177 4,431,527 4,568,600 4,783,800 4,842,900 4,987,100 Public Works Administration {bl 645,576 1,107,096 1,087,341 19,755 1,636,021 1,896,910 2,003,900 2,055,800 2,108,800 2,167,400 Sewer Maintenance {bl 35,785 102,480 102,344 136 115,300 61,300 63,100 64,700 66,400 68,200 Traffic Management {bl 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){bl 133,112 147,700 146,800 900 173,900 149,600 153,900 157,900 162,000 166,500 Public Building Maintenance {bl 592,620 648,703 576,573 72,130 528,200 599,000 624,200 640,400 656,900 675,200 Parks Maintenance {bl 660,472 984,452 829,796 154,656 1,164,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,931,914 4,300,459 4,484,800 4,601,000 4,719,700 4,850,900 Planning {bl 1,209,395 1,315,870 1,315,607 263 1,394,944 1,275,844 1,346,600 1,381,500 1,417,100 1,456,500 Building &Safety Services {bl 694,989 555,140 519,945 35,195 615,177 591,509 625,900 642,100 658,700 677,000 Code Enforcement {bl 149,160 210,990 177,141 33,849 201,658 191,594 201,600 206,800 212,100 218,000 View Restoration/Preservation {bl 198,433 255,980 193,154 62,826 326,288 319,276 333,700 342,300 351,100 360,900 NCCP (bl 45,538 46,450 45,581 869 0 0 0 0 0 0 Geology {bl 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,578,223 2,713,600 2,783,800 2,855,500 2,934,900 Recreation administration {bl 466,639 496,030 491,510 4,520 629,756 371,220 394,700 404,900 415,300 426,800 Recreation Facilities {bl 349,255 374,790 350,404 24,386 430,296 441,538 464,000 476,000 488,300 501,900 Special events {bl 26,629 104,670 86,667 18,003 40,904 40,980 42,200 43,300 44,400 45,600 PVlC {bl 346,861 355,070 334,067 21,003 330,331 328,291 351,100 360,200 369,500 379,800 REACH (bl 92,145 103,700 91,283 12,417 74,672 73,790 82,200 84,300 86,500 88,900 Total Recreation 1,281,529 1,434,260 1,353,931 80,329 1,505,959 1,255,819 1,334,200 1,368,700 1,404,000 1,443,000 TOTAL GENERAL FUND EXPENDITURES 14,358,934 16,789,109 15,796,631 992,478 17,855,272 17,832,855 I 18,593,100 II 19,076,700 II 19,604,200 I 20,158,800 GENERAL FUND NET BEFORE TRANSFERS 5,189,004 2,241,454 3,119,529 878,075 3,374,275 3,914,862 3,536,200 3,636,100 3,847,600 4,009,800 4-16 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B 0: ........................ g ESTIMATE ~FY09-10 ~•••••/./.••••••<••<.•.•.//« GENERAL FUND TRANSFER DETAIL GENERAL FUND TRANSFERS IN: From CDBG fund -Reach 28,574 20,646 20,646 0 26,848 26,848 26,848 26,848 26,848 26,848 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,7731 206,2461 177,5461 (28,700)1 292,6481 379,84811 379,84811 289,84811 289,8481 289,848 GENERAL FUND TRANSFERS OUT: To CIP fund 1,482,711 4,531,571 4,531,571 0 1,416,000 3,810,147 2,927,800 1,752,800 1,482,800 1,482,800 ToCDBG 0 0 0 0 0 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 RPVTV 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 375,925 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 1 5,381,2881 5,304,138 1 77,1501 3,842,7501 4,293,9471 3,388,700 1 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 (175,827)1 76311 527,34811 1,640,3481 2,089,848 2,204,748 I I I 4-17 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B 11 "TI""~~FY09-10 ...... ,...A ....._..........<.......i.......« GENERAL FUND SUMMARY Beginning Fund Balance 21,747,929 20,094,337 20,094,337 0 18,087,274 17,911,447 17,912,210 18,439,558 20,079,906 22,169,754 Plus:Revenues 19,547,938 19,030,563 18,916,160 (114,403)21,229,547 21,747,717 22,129,300 22,712,800 23,451,800 24,168,600 Less:Expenditures (14,358,934)(16,789,109) (15,796,631)992,478 (17,855,272) (17,832,855)(18,593,100)(19,076,700) (19,604,200) (20,158,800) Plus:Transfers In 231,773 206,246 177,546 (28,700)292,648 379,848 379,848 289,848 289,848 289,848 Less:Transfers Out (7,074,369)(5,381,288)(5,304,138)77,150 (3,842,750) (4,293,947) (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 17,911,447 17,912,210 18,439,558 20,079,906 22,169,754 24,374,502 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 12,171,332 1 II 10,440,2561 10,264,429 10,265,192 10,792,540 1 12,432,8881 14,522,736 16,727,484 Policy Reserve Threshold 9,773,969 I 7,898,316 8,927,636 8,916,428 9,296,550 9,538,350 9,802,100 10,079,400 Surplus/(Deficit)Reserve vs.Policy Threshold 2,397,363 I 2,541,941 1,336,793 1,348,765 1,495,990 2,894,538 4,720,636 6,648,084 I 4-18 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~"-"~~FY09-10 •.••..»•••••••••••••••••.•.•••••••••••••••••UU •••. BEAUTIFICATION FUND DETAIL IFund-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 1 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 1 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)1 52,844 1 303,3281 55,370 I 202,2961 207,510 1 215,920 II 216,1901 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 01 160,200 I 12,7841 147,4161 801,4511 415,2001 170,000 I 424,400 I 178,900 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 1 1,327,19111 916,5071 1,367,251 I 450,7441 621,170 I 408,26611 445,77611 237,29611 274,5861 63,706 I I I I 4-19 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~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 U 19211 (958)'1,160 ,1,010 II 1,02011 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 ProfessionallTechnical ServicesJEquipment (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 88,900 I 91,200 II 93,500 I 96,100 RPV TV FUND NET BEFORE TRANSFERS I (127,772)11 (99,940)1 (100,8ml 4,443'(83,590)'(85,422)1 (87,880)1 (90,120)1 (92,390) (95,060) I Fund Transfer In I From General Fund 135,040 54,590 54,590 0 90,000 I 85,000 90,000 90,000 90,000 95,000 Total Transfer In 135,040 I 54,590 II 54,590 II 0'90,000 ,85,000 II 90,000 II 90,000 II 90,000 I 95,000 RPV TV FUND 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)1 (4,714)(957)1,696 1,274 I 3,39411 3,2741 884 824 I I 4-20 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B g "TI.A"'~~FY09-10 <n ••i ······<i ........>......Hi .......... CIP FUND DETAIL IFund-330) 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 1,592,457 I 913,8201 704,184 (209,636)10,060,320 930,680 1,244,400 1 751,000 I 101,800 122,900 Expenditures Total CIP Fund Expenditures (see Exhibit C)2,803,675 1 2,262,081 II 1,501,47711 760,6041 18,118,7011 5,503,29511 6,362,800 II 2,718,0001 1,518,200 1,793,500 I I 1 CIP FUND NET BEFORE TRANSFERS (1,211,218)(1,348,261)(797,293)1 550,9681 (8,058,381)1 (4,572,615)11 (5,118,400)11 (1,967,000)1 (1,416,400)(1,670,600) Transfers In From General fund 1,482,711 4,531,571 4,531,571 0 1,416,000 3,810,147 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 1 1,815,23811 7,176,94211 4,608,50711 (2,568,435)1 4,338,3341 4,117,370 II 4,985,000 II 2,020,0001 1,500,000 1,775,000 I I T 1 Transfers Out 0 0 01 01 01 01 0 0 0 0 Total Transfers Out I 011 011 011 01 01 011 011 01 0 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,503,295)(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,117,370 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,6471 7,207,180 (2,017,467)3,487,133 3,031,888 1 2,898,48811 2,951,48811 3,035,0881 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) 4-21 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '".....,.~e ~FY09·10 ·............."'IH<> UTILITY UNDERGROUNDING FUND DETAIL (Fund· 341\ 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 I 4,5291 (2,271)1 4,100 1 1,390 II 2,46011 2,490 II 3,600 I 4,370 1 1 Expenditures I I Professionalffechnical Services 0 0 0 01 01 0 0 0 0 0 Total Expenditures I 011 011 011 01 01 01 01 011 01 0 I I UTILITY UNDERGROUNDING FUND NET BEFORE I 10,74411 6,80011 4,52911 (2,271)1 4,1001 1,390 II 2,460 II 2,490 ITRANSFERS 3,600 4,370 1 1 I Fund Transfer In I I I I From General Fund 0 0 0 01 01 01 01 0 0 0 Total Transfer In I 011 011 011 01 01 011 011 011 01 0 1 1 Transfer Out to General Fund 0 0 0 01 01 90,000 90,000 0 0 0 Total Transfer Out 01 011 011 01 01 90,000 I 90,000 I 01 0 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 1 189,260 II 101,720 II 104,210 II 107,810 I 112,180 1 1 1 I I I I I I 4-22 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B g "'MA"~~FY09·10 .•••1.1 •••••••••••••••/•••••••••••<.•••••••••••••••••••••<••••••••••• ROADWAY BEAUTIFICATION FUND DETAIL (Fund- 3421 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,986//2,500/1,678 I (822)1 1,5001 520 II 1,350 II 2,570 II 3,710 I 4,500 I I I 1 Expenditures I I I Improvement Other Than Buildings 01 0 0 01 01 0 0 0 0 0 Total Expenditures I 011 0/1 0/1 01 01 01/0/1 011 0/0 1 I I I I ROADWAY BEAUTIFICATION FUND NET BEFORE 3,9861 2,500 II 1,67811 (822)1 1,5001 520 II 1,35011 2,570 II 3,710 ITRANSFERS 4,500 I I Fund Transfer In 0 0 0 01 01 0 0 0 0 0 Total Transfer In 01 0/01 01 01 0/01 01 0 0 I I Fund Transfer Out 0 0 0 01 01 0 0 0 0 0 Total Transfer Out 01 01 01 01 01 01 01 01 0 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 99,875 I 102,3751 101,553 I (822)1 103,0531 103,5731 10'1,923 I 107,4931 111,203 115,703 I I I I 4-23 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '"~""'''~g ~FY09-10 )».......) EQUIPMENT REPLACEMENT FUND DETAIL (Fund- 6811 Revenues Interfund charges 268,100 165,600 180,600 15,000 69,700 59,100 202,700 207,900 213,300 219,200 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 1 390,31811 230,500 II 233,37211 2,8721 108,600 I 68,500 II 224,700 II 248,500 II 269,8001 285,200 Expenses Vehicles and vehicle maintenance (b)52,464 101,500 64,294 37,206 45,000 45,000 46,300 47,500 48,700 50,100 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 361,397 I 456,320 II 346,69311 109,6271 1,194,000 I 255,300 II 262,700 II 269,600 II 276,5001 284,200 1 1 EQUIPMENT REPLACEMENT FUND NET BEFORE I 28,92111 (225,820)11 (113,321)11 112,4991 (1,085,400)1 (186,800)11 (38,000JI (21,100)1TRANSFERS (6,700)1,000 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 1 Transfers Out 0 01 0 0 0 0 0 0 0 0 Total Transfers Out 01 011 01 0 0 0 01 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,158 Plus:Revenues 390,318 230,500 233,372 2,872 108,600 68,500 224,700 248,500 269,800 285,200 Less:Expenses (361,397) (456,320) (346,693)109,627 (1,194,000)(255,300)(262,700) (269,600) (276,500) (284,200) 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,15811 170,3611 1,882,7581 1,695,9581 1,657,958 1 1,636,85811 1,630,1581 1,631,158 Invested In Capital Assets 375,638 N/A 317,776 1 1 Ending Net Assets Per Financial Statements 3,399,255 N/A 3,285,934 I I 1 1 4-24 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""TIMA"'~~FY09-10 4........./•.•///..................../......./../.... 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 1 61,395!1 26,200 II 24,4191 (1,781)178,700 4,200 I 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 52,300 1 211,58611 206,09811 5,4881 673,900 I 34,500 II 011 011 01 0 1 BUILDING REPLACEMENT FUND NET BEFORE 9,0951 {185,386JI (181,679)10,400 I 19,90011 28,700 ITRANSFERS3,707 (495,200)(30,300)34,800 I Transfers In I From General fund 46,725 0 0 0 0 0 0 01 0 0 Total Transfers In 46,725 1 011 011 0'01 011 011 011 01 0 I I 1 Transfers Out 0 0 0 01 01 0 0 01 0 0 Total Transfers Out 1 011 011 011 0' 0' 01 01 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 1,507,730 I 1,322,34411 1,326,05111 3,7071 830,851'800,5511 810,951 1 830,85111 859,5511 894,351 I I 1 I I 1 4-25 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""TI.A"~g ~FY09·10 ~.."'</<'"T>.•••.••..•••.•••••••• EMPLOYEE BENEFITS FUND DETAIL (Fund·6SSI Revenues Interfund Charge for Services 1,630,930 1,689,930 1,615,134 (74,796)2,126,672 1,825,467 1,914,800 1,964,400 2,015,100 2,071,100 Interest earnings (m)19,612 960 8,927 7,967 70 0 270 520 750 910 Total Revenue I 1,650,54211 1,690,890 II 1,624,061 II (66,829)1 2,126,7421 1,825,4671 1,915,070 I 1,964,920 II 2,015,850 I 2,072,010 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.Heaffh 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 FICA/Medicare (b)55,351 77,550 (3,701)81,251 93,094 95,260 98,000 100,500 103,100 106,000 Bonus PlanlEducation 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 I 1 EMPLOYEE BENEFITS FUND NET BEFORE I 216,55211 (862,023)11 (694,403)11 176,120 I (1,798,962)1 20,9071 270 I 52011 750 ITRANSFERS 910 I I I Fund Transfer In -from general fund 0 0 0 01 1,594,1251 0 0 01 0 0 Total Transfer In I 011 011 011 01 1,594,1251 011 011 011 01 0 I 1 1 Fund Transfer Out 0 0 0 01 01 0 0 01 0 0 Total Transfer Out I 011 011 011 01 01 01 01 011 01 0 EMPLOYEE BENEFITS NET ASSET SUMMARY: Beginning Net Assets 682,692 899,244 899,244 0 204,841 4 20,911 21,181 21,701 22,451 Plus:Revenues 1,650,542 1,690,890 1,624,061 (66,829)2,126,742 1,825,467 1,915,070 1,964,920 2,015,850 2,072,010 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,2211 204,841 I 167,6201 41 20,9111 21,181 I 21,7011 22,451 23,361 I I I I 4-26 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~FY09-10 STREET MAINT.FUND DETAIL fFund-202! Revenues State gas tax 766,919 796,000 700,665 (95,335)686,900 684,112 684,000 684,000 684,000 684,000 Highway users excise tax (formerly Proposition 42 revenue)(a)0 414,829 363,197 (51,632)391,888 433,438 442,100 450,900 459,900 469,100 Sidewalk repair (a)349 4,000 105,100 101,100 4,100 14,000 14,300 14,600 14,900 15,200 Miscellaneous revenues (a)21,277 5,200 24,214 19,014 5,300 5,400 5,500 5,600 5,700 5,800 Interest earnings (m)24,985 3,800 5,846 2,046 3,200 2,020 4,640 7,680 11,040 13,220 Total Street Maintenance Fund Revenue 813,530 1,223,829 1 1,199,02211 (24,807)1 1,091,3881 1,138,9701 1,150,540 1,162,780 1 1,175,5401 1,187,320 Expenditures Street Maintenance -Pavement Management (b)316,251 283,180 282,420 760 556,000 500,300 463,300 475,300 487,600 501,200 Street Maintenance -Non-Pavement (b)1,333,311 1,730,165 1,699,243 30,922 1,631,674 1,554,274 1,599,200 1,640,600 1,682,900 1,729,700 Traffic signal maintenance (b)68,574 83,800 83,292 508 84,000 104,100 107,100 109,900 112,700 115,800 Total Street Maintenance Fund Expenditures 1,718,136 1 2,097,14511 2,064,95511 32,190 I 2,271,6741 2,158,6741 2,169,600 1 2,225,800 II 2,283,2001 2,346,700 STREET MAINTENANCE FUND NET BEFORE 1 (904,606)11 (873,316)11 {865,933)1TRANSFERS 7,383 (1,180,286) (1,019,704) (1,019,060) (1,063,020)(1,107,660) (1,159,380) Street Maintenance Fund Transfers In From General Fund 239,000 242,845 242,845 0 22,000 0 30,000 105,000 140,000 170,000 From General Fund (PB Road Maint)206,000 212,180 212,180 0 0 0 0 0 0 0 From Prop C Fund (PB Road Maint)0 0 0 0 556,000 500,300 463,300 475,300 487,600 501,200 From 1972 Act 180,000 180,000 180,000 0 200,000 204,000 205,000 205,000 195,000 194,000 From 1911 Act 66,931 76,800 76,800 0 84,000 104,100 107,100 109,900 112,700 115,800 From Beautification fund 0 0 0 0 256,860 165,200 170,000 174,400 178,900 183,900 From Waste Reduction 38,000 0 0 0 40,000 0 0 0 0 0 Total Transfers In 1 729,93111 711,82511 711,8251 0 1,158,860 973,600 975,400 1 1,069,600 II 1,114,2001 1,164,900 1 Street Maintenance Fund Transfers Out 1 To CIP Fund 0 0 0 0 0 0 0 01 0 0 Total Transfers Out 01 011 01 0 0 01 011 011 01 0 STREET MAINTENANCE FUND SUMMARY Beginning Fund Balance 753,264 578,589 578,589 0 424,481 403,055 356,951 313,291 319,871 326,411 Plus:Revenues 813,530 1,223,829 1,199,022 (24,807)1,091,388 1,138,970 1,150,540 1,162,780 1,175,540 1,187,320 Less:Expenditures (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) Plus:Transfers In 729,931 711,825 711,825 0 1,158,860 973,600 975,400 1,069,600 1,114,200 1,164,900 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance I 578,58911 417,09811 424,48111 7,3831 403,0551 356,9511 313,291 319,871 326,411 331,931 Reserve (1 year of Pavement Management Exp)I 1 I I 277,000 I 500,300 463,300 475,300 487,600 501,200 Available Fund Balance I I I 1 126,0551 (143,349)(150,009) (155,429) (161,189) (169,269) I 1 1 I I 4-27 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B 1972 ACT LANDSCAPE &LIGHTING FUND DETAIL Fund 203 - 78,200=78,200 191,35411 1,1811 189,3591 188,62711 190,04111 1 01 0 01 011 011 0 I I 205,000 205,000 I 195,0001 194,000 205,000 1 205,000 II 195,000 II 194,000 29,125 47,305 47,305 0 58,659 48,018 32,645 17,686 3,848 990 263,969 258,073 259,015 942 258,459 258,927 262,341 265,363 268,242 272,174 (65,789)(67,900) (67,661)239 (69,100) (70,300) (72,300)(74,200)(76,100) (78,200) 0 0 0 0 0 0 0 0 0 0 (180,000)(180,000) (180,000)0 (200,000)(204,000)(205,000) (205,000)(195,000)(194,000) (b) (m) Transfers In Interest earnings Total Expenditures Revenues Property assessments To Street Maintenance fund Operations &maintenance Total Transfers Out Total Transfers In 1972 ACT FUND NET BEFORE TRANSFERS Transfers Out 1972 ACT LANDSCAPE &LIGHTING FUND Expenditures Total Revenue Less:Transfers Out Plus:Transfers In Beginning Fund Balance Plus:Revenues Less:Expenditures Ending Fund Balance 4-28 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '",,"M"'~g ~FY09-10 /•.••••.>.................. EL PRADO LIGHTING FUND DETAIL IFund-209\ 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/1 2,000/1 (30)1 2,030 I 1,920/1 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 434/1 4661 11,000 I 1,000 II 1,000 II 1,000 II 1,000 I 1,000 EL PRADO LIGHTING FUND NET BEFORE I 1,82111 1,130 II 1,56611 4361 (8,970)1 920 II 990 II 1,090 II 1,210 I 1,330 1 1 1 I I 1 Transfers In 01 01 01 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 0/1 01 0 1 1 I I 1 Transfers Out 0 01 01 01 01 0 0 0 0 0 Total Transfers Out I 011 011 0/1 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 I I 1 1 4-29 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B !=-"'MA"~~FY09-10 ~•..•.•.>•.•.•.•.•.•••••.•.•.•.•.• ..•<•••.••••..•..•••••••••.•••••••••••••••••••••••••• CDBG FUND DETAIL IFund-310\ Revenues Grant income 244,904 188,908 113,021 (75,887)336,826 244,994 194,746 194,746 194,746 194,746 Total Revenue 244,904 188,908 1 113,0211 (75,887)336,826 244,994 194,746 1 194,74611 194,7461 194,746 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 I I I CDBG FUND NET BEFORE TRANSFERS 1 28,57611 20,64611 20,65711 111 26,6481 (17,152)11 26,84811 26,848 II 26,8481 26,648 1 1 I Transfers In 1 1 I From General fund 0 0 0 01 44,0061 0 0 0 0 0 Total Transfers Out I 011 011 011 01 44,0061 01 01 011 01 0 1 1 I Transfers Out I 1 I To General fund (REACH)28,574 20,646 20,646 01 26,6481 26,848 26,848 26,848 I 26,848 26,648 Total Transfers Out 1 28,57411 20,64611 20,64611 01 26,6481 26,8481 26,848 I 26,84811 26,848 I 26,848 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 244,994 194,746 194,746 194,746 194,746 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)(26,848)(26,848)(26,848)(26,848)(26,848) Ending Fund Balance I (17BI (17)11 (6)11 lq 44,0001 011 011 011 01 0 I 1 1 I I I 1 1 I I 4-30 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B g ......,,~~FY09·10 .......>> 1911 ACT STREET LIGHTING FUND DETAIL fFund· 2111 Revenues Property assessments (a)473,633 375,000 492,705 117,705 483,100 492,800 502,700 512,800 523,100 533,600 Interest earnings (m)66,092 35,000 27,552 (7,448)21,700 7,800 18,800 32,900 42,900 46,500 Total Revenue I 539,725 11 410,000 II 520,25711 110,2571 504,800 I 500,600 II 521,500 II 545,700 II 566,000 I 580,100 Expenditures Operations &maintenance (b)375,687 480,000 402,551 77,449 493,400 506,900 521,500 535,000 548,800 564,100 Total Expenditures I 375,68711 480,000 I 402,551 77,449 493,400 506,900 521,500 1 535,000 I 548,800 564,100 1911 ACT FUND NET BEFORE TRANSFERS 164,038 1 (70,000)1 117,706 1 187,7061 11,400 I (6,300)11 011 10,700 I 17,200 16,000 I I Transfers In 0 0 0 01 01 0 0 0 0 0 Total Transfers In 01 01 01 01 01 01 01 01 0 0 I T Transfers Out 1 1 To Street Maintenance Fund 66,931 76,800 76,800 01 84,0001 104,100 107,100 109,900 112,700 115,800 Total Transfers Out I 66,93111 76,800 II 76,800 II 01 84,000 I 104,100 I 107,100 1 109,900 II 112,700 I 115,800 1911 ACT STREET LIGHTING FUND SUMMARY Beginning Fund Balance 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 Plus:Revenues 539,725 410,000 520,257 110,257 504,800 500,600 521,500 545,700 566,000 580,100 Less:Expenditures (375,687)(480,000) (402,551)77,449 (493,400)(506,900)(521,500) (535,000) (548,800) (564,100) Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (66,931)(76,800) (76,800)0 (84,000)(104,100) (107,100) (109,900) (112,700)(115,800) Ending Fund Balance 1 1,591,70111 1,444,90111 1,632,60711 187,7061 1,560,0071 1,449,60711 1,342,50711 1,243,30711 1,147,8071 1,048,007 1 1 I I I I T I T I 4-31 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!ESTIMATE FY09-10 WASTE REDUCTION FUND DETAIL IFund-213\ 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 (e)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 137,518 178,040 139,128 I 6,0881 286,390 I 180,620 I 183,570 186,920 I 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 114,9761 314,660 I 284,573 I 30,0871 284,7081 163,93911 168,700 U 173,100 U 177,500 I 182,500 WASTE REDUCTION FUND NET BEFORE 22,542 I {136,620)1 (145,445)36,175 1,682 16,681 14,870 13,820 I 12,690 I 10,920 Transfers In 0 0 0 0 0 0 0 0 0 0 Total Transfers In 01 01 01 01 01 011 OU 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 1 38,000 II 7,000 I 01 7,000 I 52,000 I 12,0001 12,000 I 12,000 1 12,000 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 319,550 I 175,9301 174,105 I {1,825)1 123,7871 128,4681 131,338 I 133,1581 133,848 132,768 I I I I 4-32 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 52,695 I 51,310 U 50,57911 (731)1 100,600 I 50,Q70 I 50,490 I 51,120 II 51,700 I 52,100 Expenditures Operations &maintenance 57,818 50,000 50,000 0 100,000 50,000 50,000 50,000 50,000 50,000 Total Expenditures 57,8181 50,0001 50,000 0 100,000 50,000 50,000 I 50,0001 50,000 50,000 AQMD FUND NET BEFORE TRANSFERS (5,123>1 1,3101 579 I (731)1 600 I 70 U 490 II 1,120 I 1,700 2,100 1 1 1 Transfers Out 0 0 0 01 01 01 01 0 0 0 Total Transfers Out I 011 01 01 01 01 011 011 01 0 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,Q70 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,5071 52,776 (731)53,376 53,446 53,936 55,056 56,756 58,856 4-33 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""'M"'~e ~FY09-10 •.•.•.••<••••••< PROPOSITION C ISTREETITRANSID FUND DETAIL Fund-2151 Revenues Proposition C -1/2 cent sales tax revenue iii 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 iii 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 654,485 I 616,400 I 594,738 (21,662)703,551 843,870 858,810 1 837,4601 849,980 866,840 Expenditures Personnel services (b)4,626 5,700 6,095 (395)0 0 0 0 0 0 Total Expenditures 4,6261 5,700 II 6,09511 (395)1 01 011 011 011 01 0 1 1 PROPOSITION C FUND NET BEFORE TRANSFERS 849,859 I 610,700 I 588,643 1 (22,057)1 703,551 I 843,870 I 858,810 1 837,4601 849,980 866,840 1 1 Transfers In 0 0 0 01 01 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 01 01 011 01 0 Transfers Out To CIP fund 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,6711 01 2,408,671 I 1,965,230 I 500,3001 2,503,300 I 475,300 I 487,600 526,200 PROPOSITION C (STREETITRANSID 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 1 1,976,35611 178,3851 2,584,999 I 2,386,6141 1,303,320 I 1,846,890 II 2,400 II 384,560 II 726,940 I 1,067,580 I I I I I I 1 1 I I 4-34 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '",.nMA"~~FY09·10 ~••••...••...••>.•.••.....•.>.>••••••••••>•••••••••• PROPOSITION A (TRANSITl FUND DETAIL (Fund- 21§l 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 eamings (m)285 5,600 2,351 (3,249)1,000 360 0 0 0 0 Total Revenue I 686,983 H 726,900 II 623,920 II (102,980)1 547,9231 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 Shelter 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,8461 670,900 I 706,0001 716,843 I 727,740 II 738,7951 750,110 I I I I PROPOSITION A FUND NET BEFORE TRANSFERS I 188,632 11 82,00711 (11,127)11 (93,134)1 (122,977)1 (128,786)1 (139,943)1 (150,840)1 (161,895)(173,210) I I Transfers In from General Fund 0 0 0 01 01 60,000 0 0 0 0 Total Transfers In 1 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 17,600 18,200 I 15,150 II 3,050 I 2,800 I 01 01 011 01 0 PROPOSITION A (TRANSITl 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) (644,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 1 223,97111 287,77811 197,69411 (90,084)1 71,9171 3,13111 (136,812)11 (287,652)11 (449,547)1 (622,757) I I I I I I I I I I 4-35 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~"'MA"~~FY09-10 ••.•• ~...................---------y<••..• PUBLIC SAFETY GRANTS IFund-2171 Revenues Grant Income -State 100,000 100,000 100,000 0 100,000 100,000 100,000 100,000 100,000 100,000 Interest earnings (m)7,347 720 1,625 905 0 0 10 20 30 40 Total Revenue I 107,34711 100,720 II 101,62511 9051 100,0001 100,000 I 100,010 I 100,020 II 100,030 I 100,040 I 1 Expenditures 1 I Equipment purchases 15,600 32,285 32,2851 0 33,6351 0 0 0 0 0 Total Expenditures 15,600 I 32,28511 32,28511 01 33,6351 01 0 01 01 0 I 1 1 PUBLIC SAFETY GRANTS FUND NET BEFORE 91,7471 68,43511 69,340 II 9051 66,3651 100,000 I 100,010 I 100,020 II 100,030 ITRANSFERS 100,040 1 1 1 1 Transfers In 0 0 01 0 0 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 I I 1 1 I Transfers Out I I 1 1 I To General fund 100,000 100,000 100,000 I 01 100,0001 100,000 I 100,000 100,000 100,000 100,000 Total Transfers Out I 100,000 II 100,000 II 100,000 II 01 100,0001 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 0 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)0 (33,635)0 0 0 0 0 Plus:Transfers In 0 0 0 0 0 0 0 0 0 0 Less:Transfers Out (100,000)(100,000)(100,000)0 (100,000) (100,000) (100,000) (100,000)(100,000)(100,000) Ending Fund Balance I 65,200 II 33,63511 34,540 II 9051 9051 90511 91511 93511 9651 1,005 1 1 1 I 1 1 I I 4-36 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~!"nMA>E_FY09-10 i/ 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 I 9,113 I 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.923 H 162.07711 132,19011 29,8871 194.7911 126,4111 130.100 I 133,400 II 136,800 I 140,600 I I HABITAT RESTORATION FUND NET BEFORE I (118,296)11 (157,677)11 (123.077111 34,6001 (192,991)1 (125,401)11 (127,690)11 (129.210)1TRANSFERS (131,350) (134.710) I 1 1 1 1 Transfers In I I 1 1 1 From General fund 115,0001 115.0001 115,000 I 01 169,0001 109.900 113.100 116,000 119,000 122.300 Total Transfers In I 115.00011 115.000 II 115.000 II 01 169.0001 109,900 I 113.100 I 116,00011 119,000 I 122,300 1 1 T T Transfers Out 0 01 01 01 01 0 0 0 0 0 Total Transfers Out 01 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 233.257 I 190.580 I 225,180 34,600 201,189 185,688 171,098 I 157,8881 145.538 133,128 Reserve 54,122 64,443 75,410 87.503 100.867 115,357 Available Fund Balance 147,067 121.245 95,688 70,385 44.671 17,771 4-37 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ""'MA"~e ~FY09-10 >••••.•...........i..>...................... SUBREGION 1 -MAINTENANCE FUND DETAIL Fund 22~ 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 29,147 I 12,000 II 12,33111 3311 11,3001 3,800 II 9,800 II 18,500 II 26,100 I 30,400 I T 1 I Expenditures I I 1 1 Operations &maintenance (b)62,956 65,9001 50,7551 15,1451 77,oooT 79,000 71,300 73,100 75,000 77,100 Total Expenditures I 62,956 I!65,900 II 50,75511 15,1451 77,0001 79,000 I 71,300 I 73,100 II 75,000 I 77,100 I 1 1 1 1 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)1 (54,600)11 (48,900)1TRANSFERS (46,700) I I 1 I Transfers In-from general fund 30,0001 55,0001 55,0001 0 55,0001 70,000 65,000 55,000 45,000 50,000 Total Transfers In I 30,000 II 55,000 I!55,000 II 01 55,0001 70,000 I 65,000 I 55,000 I 45,000 50,000 I I T I T Transfers Out 01 01 01 01 01 0 0 0 0 0 Total Transfers Out I 011 011 011 01 01 01 0 0 0 0 SUBREGION 1-MAINTENANCE FUND SUMMARY: Beginning Fund Balance 4,569 760 760 0 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 0 55,000 70,000 65,000 55,000 45,000 50,000 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Available Fund Balance 760 I 1,860 II 17,33611 15,4761 6,6361 1,4361 4,936 I 5,33611 1,4361 4,736 Unexpendable Endowment 750,000 750,000 I 750,000 I 1 I Ending Fund Balance per Financial Statements 750,760 751,860 I 767,336 I 1 1 I T I T 4-38 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~FY09-10 ~««.......ii 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,Q4811 66,800 I 100,423 33,623 161,913 151,170 151,440 I 151,850 I 152,220 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 On 01 01 01 01 01 01 on 01 0 I I MEASURE A-CAPITAL &MAINTENANCE FUND NET 42,0481 66,800 II 100,42311 33,6231 161,9131 151,170 I 151,440 I 151,850 IBEFORETRANSFERS 152,220 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 CIPfund 0 0 21,700 (21,700)10,913 0 0 0 0 0 Total Transfers Out I 100,599 11 75,900 n 75,900 II 01 161,9131 151,000 n 151,000 II 151,000 II 151,0001 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,Q48 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 1 9,40511 30511 33,92811 33,6231 33,9281 34,09811 34,53811 35,388 n 36,6081 13,088 I I I I I I I I I I I 4-39 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '""'TI.Are~~FY09-10 ~.............•••••••<•••••••.•••••••••••••.••<••••••••••••••••••••••••••••• ABALONE COVE SEWER DISTRICT FUND DETAIL Fund·2251 Revenues Property Assessments (a)43,091 44,750 52,150 7,400 45,650 46,560 47,490 48,440 49,410 50,400 Interest earnings (m)5,206 460 2,021 1,561 570 280 660 1,090 1,320 1,270 Total Revenue 1 48,29711 45,21011 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 (635)32,000 0 0 0 0 0 Total Expenditures I 65,47911 103,800 I 88,990 1 14,8101 94,0381 63,20611 65,000 II 66,6001 68,400 70,300 I I I I ABALONE COVE SEWER DISTRICT FUND NET (17,182)1 (58,590)11 (34,819)~23,7711 (47,818)1 (16,366)11 (16,850)1 (17,070)1BEFORETRANSFERS (17,670) (18,630) I I I Fund Transfer In I I From General Fund 80,700 10,700 10,700 01 10,700 I 10,700 10,700 10,700 10,700 10,700 Total Transfer In I 80,700 II 10,700 II 10,700 II 01 10,7001 10,700 I 10,700 I 10,70011 10,700 I 10,700 I I I Fund Transfer Out 0 0 0 01 01 0 0 0 0 0 Total Transfer Out 1 011 01 01 01 01 01 01 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 117,7131 69,82311 93,59411 23,7711 56,4761 50,810 II 44,660 II 38,290 II 31,320 I 23,390 I I I I I I I 4-40 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~,,"MAOE~g ~FY09·10 MA ................../•.//......«..................., DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL ARTS BUILDING FUND DETAIL (Fund· 227) Revenues Restricted Donations 500,000 0 0 0 0 0 0 0 0 0 Interest earnings (m)10,651 12,200 8,458 (3,742)7,600 1,040 2,720 5,190 7,490 9,090 Total Revenue 510,651 I 12,200 II 8,45811 (3,742)1 7,6001 1,040 II 2,720 II 5,190 II 7,490 I 9,090 1 1 1 1 1 Expenditures 1 1 1 1 1 Capital Outlay 18,606 0 0 01 300,000 I 0 01 01 0 0 Total Expenditures I 18,60611 011 011 01 300,0001 011 011 011 0/0 1 1 1 DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL 492,0451 12,20011 8,45811 01 (292,400)1 1,0401 2,72011 5,190 II 7,490 IARTSBUILDINGFUNDNETBEFORETRANSFERS 9,090 1 1 1 1 1 Fund Transfer In 0 0 0 01 01 01 01 01 0 0 Total Transfer In I 011 0/1 011 01 01 011 011 011 01 0 1 1 1 1 Fund Transfer Out 0 0 0 01 01 0 01 01 0 0 Total Transfer Out I 011 0/1 011 01 01 011 011 011 0/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,503/1 (3,742)1 208,1031 209,143/211,863 217,053 I 224,5431 233,633 1 1 1 1 1 4-41 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B !_"nMAtE~~FY09-10 >i ··i·i ........................ " 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 1011 30 II 50 II 70 I 90 1 1 I 1 1 Expenditures 1 1 1 1 1 Capital Outlay 01 01 0 01 01 0 0 0 0 0 Total Expenditures I 011 011 011 01 01 011 011 011 01 0 1 1 1 1 RECREATION IMPROVEMENTS DONATIONS FUND 2,0481 011 3411 01 600,000 I 1011 30 I 5011 701NETBEFORETRANSFERS 90 1 1 1 1 Fund Transfer In 0 01 0 01 01 0 0 01 0 0 Total Transfer In I 011 011 011 01 01 011 011 011 01 0 1 1 1 1 1 Transfer To CIP 01 01 01 01 600,0001 0 0 0 0 0 Total Transfer Out I 011 011 011 01 600,000 I 01 01 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,0921 2,122 I 2,17211 2,2421 2,332 1 1 1 1 1 1 1 1 1 1 4-42 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B QUIMBY FUND DETAIL IFund-3341 Revenues Developer fees Interest earnings Total Revenue Expenditures Improvements Total Expenditures QUIMBY FUND NET BEFORE TRANSFERS Transfers In Total Transfers In Transfers Out Total Transfers Out QUIMBY FUND SUMMARY: (m)~13~I 33~I 63~I 91~I 0 1,100 o I 130 II 330 II 630 II 910 II 1,100 - 0 0 '" 1,100 0 0 '" "0 0 Beginning Fund Balance Plus:Revenues Less:Expenditures Plus:Transfers In 23,766 988 o o 24,754 12,310 (25,000) o 24,754 416 o o o (11,894) 25,000 o 25,170 o o o 25,170 130 o o 25,300 330 o o 25,630 630 o o 26,260 910 o o 27,170 1,100 o o Less:Transfers Out Ending Fund Balance 2 o o o o o o o o o o 4-43 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B e 'STIMA;e~~FY09-10 .......//..../............/.... AFFORDABLE HOUSING IN -LIEU FUND NON-RDA DETAIL IFund-337\ 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 1 46,13611 19,500 II 14,53411 (4,966)1 948,5101 40 II 10011 200 I 290 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 0 0 Total Expenditures 1,2001 331,43211 331,43211 (2,516)11 12,500 I 011 011 011 01 0 AFFORDABLE HOUSING SET-ASIDE FUND NET I 44,93611 (311,932)1 40 I 100 II 200 IBEFORETRANSFERS(316,898)(7,482)936,010 290 350 1 Transfers In 01 0 0 0 0 0 0 0 0 0 Total Transfers In I 011 011 011 01 01 011 011 011 01 0 1 Transfers Out 0 01 0 0 1,766,368 0 0 0 0 0 Total Transfers Out 01 011 01 0 1,766,368 0 01 011 01 0 AFFORDABLE HOUSING IN -LIEU FUND SUMMARY NON-RDA\ 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)0 (12,500)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 (1,766,368)0 0 0 0 0 Ending Fund Balance 1 1,155,23111 843,2991 838,333 I (4,966)1 7,9751 8,0151 8,1151 8,31511 8,6051 8,955 I I I I I T T I 4-44 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~ESTIMATE ~FY09-10 ............yy .... •••••••••••••••••••••••••••••••••••••• / ENVIRONMENTAL EXCISE TAX IEET)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 "510 "980 II 1,420 I 1,720 I Expenditures I Improvements 44,704 58,295 58,278 17 566,000 0 0 0 0 0 Total Expenditures 44,704 1 58,29511 58,2781 17 566,000 0 01 0"01 0 EET FUND NET BEFORE TRANSFERS I 557,546 "35,54511 15,07011 (20,475)1 (465,900)1 38,8001 5101 980 II 1,420 I 1,720 I Transfers Out I I To CIPfund 0 29,000 I 0 29,000 I 332,600 40,000 0 0 0 0 Total Transfers Out 1 011 29,000 II 011 29,000 I 332,600 I 40,000 I 01 011 01 0 ENVIRONMENTAL EXCISE TAX IEET)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 I 824,22311 830,768 11 839,29311 8,5251 40,7931 39,593 "40,10311 41,083 "42,5031 44,223 I I I I I I I I I I 4-45 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B .......,.~g ~FY09·10 ~>••••••••••••••••••••••••••• BIKEWAYS ITDA ARTICLE 31 FUND DETAIL IFund· 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 I 39,5950 26,80211 24,80411 (1,998)1 25,000 I 17,2231 17,200 I 17,2000 17,200 I 17,200 I I Expenditures 1 1 Operations &maintenance 0\0 0 01 01 0 0 0 0 0 Total Expenditures I 011 01 01 01 01 01 01 01 0 0 I 1 1 BIKEWAYS FUND NET BEFORE TRANSFERS I 39,59511 26,80211 24,80411 (1,998)1 25,000 I 17,2231 17,200 I 17,200 I 17,200 17,200 1 Transfers Out I To CIPfund 80,000 32,000 30,002 1,9981 25,000 17,223 17,200 17,200 17,200 17,200 Total Transfers Out I 80,0000 32,000 II 30,00211 1,9981 25,000 I 17,223 0 17,200 II 17,200 0 17,200 I 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,198 0 011 011 01 01 00 011 011 01 0 I 1 1 I I I I 4-46 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~.._..-~FY09·10 ~..................... .....~.................... WATER QUALITY &FLOOD PROTECTION (Fund- 5011 Revenues Donations 0 0 89 89 0 0 0 0 0 0 Grants 0 0 326,651 326,651 0 0 0 0 0 0 Storm Drain User Fee 1,221,825 1,240,728 1,251,733 11,005 1,239,197 1,251,589 1,267,234 1,281,807 1,307,443 1,333,592 Interest earnings (m)282,670 30,100 104,512 74,412 700 2,100 1,200 600 1,800 1,400 Total Revenue 1 1,504,49511 1,270,82811 1,682,98511 412,1571 1,239,8971 1,253,68911 1,268,43411 1,282,40711 1,309,2431 1,334,992 Expenses Administration 140,183 183,907 242,074 (58,167)144,190 146,314 148,062 152,504 157,079 161,792 Maintenance 56,178 120,214 216,890 (96,676)271,495 237,687 244,817 222,162 319,727 237,518 Improvements &Engineering 3,533,383 7,011,484 6,855,665 155,819 2,510,322 1,200,617 943,055 880,642 848,135 848,758 Equipment Purchases 12,149 0 0 0 0 0 0 0 0 0 Total Expenses 1 3,741,89311 7,315,60511 7,314,62911 9761 2,926,0071 1,584,61811 1,335,93411 1,255,30811 1,324,9411 1,248,068 I I 1 WQFP FUND NET BEFORE TRANSFERS 1 (2,237,398)11 (6,044,7771U (5,631,644H1 413,1331 (1,686,110)1 (330,929)11 (67,500)11 27,09911 (15,698)1 86,925 1 1 1 Fund Transfer In 1 I I 1 From General Fund 4,719,193 0 01 01 01 0 0 0 0 0 Total Transfer In I 4,719,19311 011 011 01 01 011 011 011 01 0 1 1 1 1 Fund Transfer Out 0 01 01 01 01 0 0 0 0 0 Total Transfer Out 01 011 011 01 01 01 01 011 01 0 WQFP NET ASSET SUMMARY: Beginning Unrestricted Net Assets 5,258,213 7,740,008 7,740,008 0 2,108,364 422,254 91,325 23,825 50,924 35,226 Plus:Revenues 1,504,495 1,270,828 1,682,985 412,157 1,239,897 1,253,689 1,268,434 1,282,407 1,309,243 1,334,992 Less:Expenses (3,741,893) (7,315,605)(7,314,629)976 (2,926,007)(1,584,618) (1,335,934) (1,255,308) (1,324,941) (1,248,068) Plus:Transfer In 4,719,193 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Available Net Assets I 7,740,00811 1,695,23111 2,108,36411 413,1331 422,2541 91,3251 23,825 1 50,92411 35,2261 122,150 Invested in Capital Assets 5,599,028 1 N/A 1 12,476,664 1 1 1 Ending Net Assets Per Financial Statements 13,339,036 1 N/A I 14,585,028 I I I 1 1 1 1 4-47 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~d!"nMm_FY09-i0 RDA HOUSING SET -ASIDE FUND DETAIL (Fund-2i8) Revenues Property tax increment (e)199,645 204,600 220,201 15,601 211,700 222,300 226,800 232,400 239,400 247,800 Interest earnings (m)102,410 31,400 27,391 (4,009)10,600 3,600 8,500 21,300 37,800 54,500 Total Revenue I 302,055 11 236,000 II 247,59211 11,592'222,300 ,225,900 II 235,300 II 253,700 II 277,200 I 302,300 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 OuUay 0 1,212,637 0 1,212,637 3,333,543 266,457 0 0 0 0 Total Expenditures 20,676 I 1,387,30711 740,900 II 646,407'3,346,043'278,95711 25,000 II 25,600 II 26,300 I 27,000 I I I RDA HOUSING SET -ASIDE FUND NET BEFORE I 281,3791 (1,151,307)1 (493,308)11 657,9991 (3,123,743)1 (53,057)11 210,300 II 228,100 ITRANSFERS 250,900 275,300 I I I Fund Transfer In I I I From City's Affordable Housing In-Lieu Fund 0 0 0 o I 1,766,368 I 0 0 0 0 0 Total Transfer In I 011 011 011 0'1,766,368'01 0 01 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 657,319 867,619 1,095,719 1,346,619 Plus:Revenues 302,055 236,000 247,592 11,592 222,300 225,900 235,300 253,700 277,200 302,300 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,999'710,376'657,31911 867,61911 1,095,71911 1,346,6191 1,621,919 Land Asset 702,392 I 702,392 I 702,392 I I I Ending Fund Balance Per Financial Statements 3,263,451 I 2,112,144 I 2,770,143 I I I I I I I I 4-48 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~B_~_~FY09-10 RDA DEBT SERVICE FUND DETAIL IFund-4101 Revenues Property tax increment (e)797,983 826,800 901,061 74,261 846,900 889,200 907,000 929,700 957,600 991,100 Long term advance from city 1,122,578 0 876,927 0 760,400 620,680 791,300 1,048,700 1,311,900 1,529,900 Total Revenue 1,920,561 826,800 I 1,777,98811 74,261'1,607,300 ,1,509,880 II 1,698,300 II 1,978,400 II 2,269,500 I 2,521,000 Expenditures Pass thru to county fire department 168,784 175,700 187,211 (11,511)174,400 189,000 192,700 197,600 203,500 210,600 County administrative fee 16,491 13,900 18,509 (4,609)16,400 17,000 18,100 18,600 19,200 19,800 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 620,680 791,300 1,048,700 1,311,900 1,529,900 Total Expenditures I 1,870,93911 1,725,65911 1,655,913 h 69,746'1,597,701'1,543,6151 1,738,719 2,019,024 1,913,475 2,151,925 /I I RDA DEBT SERVICE FUND NET BEFORE I 49,62211 (898,859)11 122,07511 144,007'9,599'(33,73511I (40,419»1 (40,624)11 356,0251 369,075 1 /I I 1 Fund Transfer In 1 //I I 1 From General Fund 01 01 0 01 01 0 0 0 0 0 Total Transfer In I 011 011 011 0'0'011 011 011 01 0 1 1 1 I I Fund Transfer Out 0/0 01 01 01 0 0 0 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 579,541 539,122 498,498 854,523 Plus:Revenues 1,920,561 826,800 1,777,988 951,188 1,607,300 1,509,880 1,698,300 1,978,400 2,269,500 2,521,000 Less:Expenditures (1,870,939)(1,725,659)(1,655,913)69,746 (1,597,701)(1,543,615) (1,738,719) (2,019,024) (1,913,475)(2,151,925) 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 481,602 I (417,257)11 603,67711 1,020,934'613,276'579,54111 539,12211 498,49811 854,5231 1,223,598 Long-Term Advance Due To The City 16,010,045 16,010,045 /16,886,971 /I I Ending Fund Balance Per Financial Statements (15,528,443)(16,427,302)1 (16,283,294)1 I I 1 1 1 I I / 4-49 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '">SnMA>E_g ~FY09-10 ~......................................~ RDA -PORTUGUESE BEND FUND DETAIL (Fund- 3711} Revenues Interest earnings (m)27,731 10,900 9,712 (1,188)7,300 1,520 3,560 6,000 7,510 7,740 Loans received 50,004 0 50,004 50,004 0 0 0 0 0 0 Total Revenue I 77,73511 10,900 II 59,71611 48,8161 7,300 I 1,520 II 3,560 II 6,000 II 7,510 I 7,740 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 Improvements 0 0 0 0 213,750 0 0 0 0 0 Total Expenditures I 21,85811 26,300 II 17,9341 8,366 244,825 31,366 32,300 I 33,200 II 34,100 I 35,100 RDA -PORTUGUESE BEND FUND NET BEFORE 55,8771 (15,400)11 41,78211 57,1821 (237,525)1 (29,846)1 (28,740)1 (27,200)1TRANSFERS (26,590)(27,360) I I Transfers In 0 0 0 01 01 0 0 0 0 0 Total Transfers In 01 011 011 01 01 01 01 011 01 0 1 Transfers Out 0 0 0 0 0 0 0 01 0 0 Total Transfers Out 01 011 01 0 0 01 011 011 01 0 RDA -PORTUGUESE BEND FUND SUMMARY Beginning Fund Balance 443,382 499,259 499,259 0 541,041 303,516 273,670 244,930 217,730 191,140 Plus:Revenues 77,735 10,900 59,716 48,816 7,300 1,520 3,560 6,000 7,510 7,740 Less:Expenditures (21,858)(26,300)(17,934)8,366 (244,825)(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,259 11 483,85911 541,04111 57,1821 303,5161 273,670 I 244,930 I 217,730 II 191,1401 163,780 1 I 1 I I 4-50 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B !~"'MA"~~FY09·10•······························i.> ../../... RDA •ABALONE COVE FUND DETAIL IFund·380! Revenues Interest earnings (m)357 150 119 (31)90 30 80 160 230 270 Total Revenue 1 35711 150 I 1191 (31)1 90 I 30 I 80 I 160 II 230 I 270 I I I Expenditures I T T Capital projects 01 0 0 01 01 0 0 0 0 0 Total Expenditures 1 011 011 011 01 01 01 01 01 0 0 1 I I RDA -ABALONE COVE FUND NET BEFORE 150 I 11911 (31)1 90 I 30 I 80 I 160 II 230 ITRANSFERS357 270 1 I I Transfers In 1 T I From General fund 0 0 01 01 oT 0 0 0 0 0 Total Transfers In 1 011 011 011 01 01 011 011 01 0 0 1 I I 1 Transfers Out 01 0 0 01 oT 01 0 0 0 0 Total Transfers Out I 011 01 01 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 6,052 I 6,20211 6,17111 (31)1 6,2611 6,29111 6,371 11 6,53111 6,7611 7,031 I I I I I 1 4-51 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B '"<SnMA"~g ~FY09·10 ............"""._~«••••••••••<.«.< IMPROVEMENT AUTHORITY·PORTUGUESE BEND FUND DETAIL IFund·2851 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 1 15,78011 3,88011 3,96911 891 2,820 I 1,030 I 2,160 3,100 I 3,0001 1,880 1 1 Expenditures 1 1 Maintenance &Operations (b)83,331 135,100 82,253 52,8471 138,7001 141,700 145,800 149,600 153,500 157,800 Total Expenditures 83,331 1 135,10011 82,25311 52,8471 138,700 I 141,700 II 145,800 II 149,600 II 153,500 I 157,800 1 1 1 1 1 IMPROVEMENT AUTHORITY·PORTUGUESE BEND 1 (67,551)11 (131,220)11 (78,284)11 52,9361 (135,880)1 (140,670)11 (143,640)1 (146,500)11 (150,500)1FUNDNETBEFORETRANSFERS (155,920) 1 1 I Transfers In 1 1 From General fund 14,000 91,500 82,252 (9,248)1 110,0001 101,000 104,000 107,000 110,000 113,000 Total Transfers In I 14,00011 91,500 II 82,25211 (9,248)1 110,000 I 101,0001 104,000 1 107,000 II 110,000 I 113,000 1 1 1 Transfers Out 0 0 0 01 01 0 0 01 0 0 Total Transfers Out 1 011 011 011 01 01 01 01 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 I I I 1 1 I I I 4-52 CITY OF RANCHO PALOS VERDES 2009 FIVE-YEAR FINANCIAL MODEL -(BY FUND) EXHIBIT B ~=oA~_~FY09·10 IMPROVEMENT AUTHORITY -ABALONE COVE FUND DETAIL IFund·7951 Revenues Interest earnings (rn)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,50011 15,500 II 26,800 II 36,900 I 42,700 Expenditures RDA Storm Drain User Fee 2,722 2,776 2,776 0 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 0 60,000 40,000 60,000 60,000 0 0 0 Total Expenditures I 110,431 11 106,77611 35,13211 71,6441 88,1761 109,490 II 110,82511 52,08111 53,4391 54,898 1 1 IMPROVEMENT AUTHORITY -ABALONE COVE (24,526~1 (73,876JI (9,050J (95,3251 (25,281JI (16,539)1FUNDNETBEFORETRANSFERS64,826 (68,676)(102,990)(12,198) Transfers In From General fund 6,000 0 0 0 0 0 0 0 0 0 Total Transfers In I 6,000 II 011 01 0 0 0 0 01 01 0 1 Transfers Out 0 01 0 0 0 0 0 0 0 0 Total Transfers Out 01 011 011 01 01 01 01 011 01 0 IMPROVEMENT AUTHORITY -ABALONE COVE FUND SUMMARY Beginning Fund Balance 389,807 371,281 371,281 0 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 0 0 0 0 0 0 0 0 0 Less:Transfers Out 0 0 0 0 0 0 0 0 0 0 Expendable Fund Balance 371,281 I 297,40511 362,23111 64,8261 293,5551 190,5651 95,240 I 69,95911 53,420 I 41,222 Unexpendable Endowment 1,000,000 1,000,0001 1,000,0001 I I 1 Ending Fund Balance Per Financial Statements 1,371,281 1,297,405 1 1,362,231 I I 1 I I I I 4-53 CIP FUND PROJECTS CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL CIP PLAN PROJECT EXPENDITURES EXHIBITC _lIIvW~_WI~I'rll~~~I_ll'~IFUNDING SOURCE ~treet Inf~~~~lJ_C::!~!~____________=-==-.._________.----j Annual Residential Pavement 1,550,354 930,461 2,904,955 1,520,000 1,800,000 1,600,000 1,500,000 1,500,000 General fund,Bikeways Annual-Arterial-Pa~e~~ji!~~~~_______---9fo~527---T72T73----5~240,755 ------------------2)(fO~060 _~~=~-----------------------------Prop-C7sTIPjMea~~~~==~~~~__=~~~~~ Pavement Management Study 4,689 5,200 120,000 25,000 Prop C Bus Shelter Improvements 115,441 12,4501 1 IProp A PVDS/PVDE Roadside Landscaping 1 90,110 I I 1Beautification ~'!e:t:i.a~!:rJ:!<a.n Improvements i--------12,784 __544~__250,Q.qQ ~0,000 ?~O,OOO Beautificati~.r:I --l1~~::~_6~~ln~~!;!a~~~restridge_________~6:~~f-263~+.__..________~;~::~~~;~~U~dBaJan~----- :~~~~:e~::~~~~:n~~~------------+-----------15,6161 2~~:ggg 1 -------------------------1~:~e~;~;~~~%Gene:.r:<a.I£~~_ Pedestrian Improvements on Hawthorne Blvd 1 1 285,400 I 1,141,600 lao%Grant/20%City Match PVDS Bikeway Safety Project I 1 813,0001 IProp C &Grant Study PVDS in Landslide Area I 1 1 50,000 ICIP Accumulated Fund Balance Parks &Open Space Infrastructure PVIC &Forrestal Trail Improvements 1 106,584 7,700 I I IGeneral fund Hesse Park Tot Lot Play Structure I 22,287 I I IGeneral fund ~~:~~::~~~~ce-Gate------------------+---1,120 1_g~~1------+---------------------------------------1~:~:~~~~----------------------------- ,~:~:~1~~~:~~~~~~~~r~ne~~-:===:~::4==::::::==:::::~igW-I-------~,~~~~.----..--------.::==:==:::::::=::::_:::=====:::~~~~T~:~~~::::~~~:::::~~ Antenna Repeater at San Pedro Hill Trailhead I 1 15,000 I ICIP Accumulated Fund Balance ~::=r~~;:t~~~~i~~;;~~~~:~n~ent~L +_-+-25f;300-t--------------------~2.QOO~9gQ----------------------------f~$~~~rl-tl.--------------------------- Hesse Park Field Upgrade Phase I &II I 1 146,300 I 500,000 IGeneral fund I EET PVIC Exhibits·Phase II 1 I 600,000 1 IDonations &Annenberg Grant Forrestal Open Space Gate 1 1 12,000 I ICIP Accumulated Fund Balance Abalone Cove Parking Lot Gate &Railing 1 1 3,000 I ICIP Accumulated Fund Balance Point Vicente Interpretive Center Curb Lighting 1 1 5,000 I ICIP Accumulated Fund Balance Coastal Access Trail I I I 425,000 425,000 lao%Grant/20%General Fund Match *~~~S;~~~£i~~;i~~~-----~-----~::~----1-6~];f =__~c~j~:=:~:J~§.-~gg -------=::====---~i~~;ii~i¥~f;:~:~~~~~~-- ·~;:;*~;;~~i-:~J~oen:1;:~~~~~;/DeSig;;----1 --1--5Q-!QQQ+--?!g¥~~~~---------------------------------------------------------------\~:~:::{~~-------------------------j Sewer Infrastructure Sewer Overflow Capacity Analysis 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. 4-54 CITY OF RANCHO PALOS VERDES 2010 FIVE-YEAR FINANCIAL MODEL WATER QUALITY FLOOD PROTECTION (STORM DRAIN)EXPENSES EXHIBIT D li~~I~JI;~III~~1 i.il.II.I~~~;IFUNDING SOURCE 1,005,197 6,139,888 WQFP FUND PROJECTS Backbone Projects McCarrell Canyon McCarrell Canyon Land Aqcquisition Sunnyside Ridge Lower San Ramon Canyon Stabilization 1,408,493 377,666 97,000 10,98011,152,000 350,000 General Fund/User Fees General Fund General Fund/User Fees User Fees Pipe Lining Other Capacity &Secondary System Projects [ViaCohnita Vickery Canyon IHawthorne Blvd PVDE Lower Switchbacks IPVDS (North of Barkentine) South Hawthorne/Frascati Filtration Systems ~nstallation of Filtration Devices Other Projects PVDE Drainage Inlets Mossbank Storm Drain Rehabilitation 470,262 245,885 652,7lHl 524,822 251,500 7,490 ~ro,ooo 314,617 319,555 324,642 331,135 337,758 IGeneral Fund/UserFees 29~,5UO User Fees 370,000 200,000 User Fees 485,000 IUser Fees 446,000 IUser Fees --- 440,000 User Fees 41,000 41,000 41,000 41,000 41,000 IUser Fees IGeneral Fund General Fund I Miscellanous Repairs &Maintenance IMisc.Storm Drain Repairs 25,880 44,590 IStorm Drain &Filtration Maintenance 56,178 216,890 Storm Drain Master Plan Update Administration (contract/staff engineer)140,183 242,074 Grand Total -WQFP Fund Expenditure!3,729,7441 7,314,628 55,000 271,495 370,000 144,190 2,926,007 IGeneral Fund 237,687 244,817 222,162 319,727 237,5181User Fees 125,000 90,000 30,000 30,000 30,000 IGeneral Fund/User Fees 146,314 148,062 152,504 157,079 161,792 IUser Fees 1,584,61811,335,93411,255,30811,324,941 11,248,068 4-55 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 Sub 1 Debt Port.Bend General Maintenance Sewer District Prollram Protection Restoration Proposition A TV Maint.CDBG Service Imp.Auth.Total General 0 10,700 3,810,147 0 109,900 60,000 85,000 70,000 0 47,200 101,000 4,293,947 Beautification 165,200 250,000 415,200 Waste Reduction 12,000 0 12,000 Utility Undergrounding 90,000 90,000 CDBG 26,848 26,848 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 379,848 973,600 10,700 4,117,370 0 109,900 60,000 85,000 70,000 0 47,200 101,000 5,954,618 4-56 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 Sub1 Debt Port.Bend General Maintenance Sewer District ProGram Protection Restoration Renlacement TV Maint.Service ImD.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 26,848 26,848 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 379,848 975,400 10,700 4,985,000 0 113,100 0 90,000 65,000 48,100 104,000 6,771,148 4-57 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 Proaram 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 26,848 26,848 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 289,848 1,069,600 10,700 2,020,000 0 116,000 0 90,000 55,000 49,100 107,000 3,807,248 4-58 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 Sub1 Debt Port.Bend General Maintenance Sewer District Proaram Protection Restoration Reolacement 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 26,848 26,848 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 Safely Grants 100,000 100,000 TOTAL 289,848 1,114,200 10,700 1,500,000 0 119,000 0 90,000 45,000 50,100 110,000 3,328,848 3,328,848 o 4-59 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 Program 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 26,848 26,848 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 289848 1164900 10700 1,775,000 0 122,300 0 95,000 50000 51,100 113,000 3671,848 3,671,848 o 4-60