RPVCCA_SR_2011_06_07_03_Draft_2011_5Yr_Financial_ModelCITY OF
MEMORANDUM
RANCHO PALOS VERDES
TO:
FROM:
DATE:
SUBJECT:
REVIEWED:
Staff Coordinator:
HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCI~
DENNIS McLEAN,DIRECTOR OF FINANCE &INFORMATION ~
TECHNOLOGY
JUNE 7,2011
DRAFT 2011 FIVE-YEAR FINANCIAL ~ODE.L
CAROLYN LEHR,CITY MANAGERQ>L--
Kathryn Downs,Deputy Director of Finance &Information
Technology
RECOMMENDATION
Review the Draft 2011 Five-Year Financial Model ("2011 Model")and provide direction to
Staff.
EXECUTIVE SUMMARY
Draft FY11-12 Budget
The draft 2011 Model includes the proposed FY11-12 budget,which is balanced with a
surplus of $44,782;and each of the City Council's policy reserve thresholds are expected
to be exceeded as of June 30,2012.The 2011 Model assumes no significant changes to
core service levels.
To date,the City's only apparent impact from the state's ongoing budget crisis is a potential
loss of the Citizens'Options for Public Safety (COPS)allocation of $100,000.This state
shared revenue is used to partially fund the City's $187,000 commitment to the Sheriff's
Community Resource (CORE)program.If the COPS funding is lost,the City may not
receive the Sheriff's discounted rate for grant deputies.The City Council will need to
consider the level of continued participation and funding for the program.
Summary 2011 Model Information
The Model has a history of showing a decrease in the General Fund Reserve due to
conservative assumptions about the future.Each year,a balanced budget is adopted by
using the latest revenue information and the evolution of the spending plan.Once again,
the current Model indicates that if expenditures and revenues grow at the assumed rates
3-1
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 2 of 9
and action is not taken to balance future budgets,the General Fund Reserve may fall
below the policy threshold of 50%of annual expenditures by the end of FY12-13,and
continue to decline by about $0.8 million each year thereafter.There are several factors
that are primarily responsible for the trend presented in the 2011 Model:
~Expenditures are expected to grow at an average rate of about 3.3%annually,
whereas revenue is expected to only increase an average of about 2.5%annually
(annual deficit of about $185,000);
~The Reserve threshold (50%of annual expenditures)grows with expenditure growth
(average of $322,000 annually);and
~It will become necessary for the General Fund to subsidize the Street Maintenance
Fund (contributions ranging from $100,000 to $190,000 annually),as the estimated
cost of maintenance of Palos Verdes Drive South in the landslide area of the City
increases faster than the estimated Proposition C revenue dedicated to that
purpose.
As noted above,Staff and the City Council will continue to work together each year to
ensure that the City maintains a balanced budget.
Per the City Council's Reserve Policy,the 2011 Model includes annual transfers from the
General Fund to the Capital Improvement Projects (CIP)Reserve for Future Projects,in
the amount of the annual transient occupancy tax (TOT)revenue.The 2011 Model
currently indicates that the CIP Reserve will grow to nearly $16 million by the end of FY15-
16.However,the draft 2011 Capital Improvement Plan includes a list of unfunded projects
with a total cost range of $70 million to $105 million.Staff expects that as the Capital
Improvement Plan evolves,the City Council will provide direction to fund additional
projects;and the CIP Reserve will stabilize at an amount closer to the policy threshold of
$3 million for emergency projects.
BACKGROUND AND DISCUSSION
Overview
The 2011 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 ofthe Model.The 2011 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)conducted its review of the draft 2011 Model on
April 2ih and May 18th •The FAC was concerned that the 2011 Model presents a decline
in General Fund Reserves,yet the CIP Reserve for Future Projects (funded with General
Fund money)is estimated to grow to nearly $16 million by FY15-16.The total of the
General Fund Reserve and CIP Reserve for future projects is presented in the draft 2011
Model as follows.
3-2
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 3 of 9
General Fund Reserve $9,388,911
CIP Reserve for Future Projects 7,908,841 10,490,641 10,694,241 13,384,641 15,957,141
t~iii~iilli~i[l!!lliJbflil;i~;;;liliiiJlifi&~;I~;lfIi~t~1&111~~~1Illii~J)I~'~'llfI4~m~;1;11fl~:'il~ri0~~I;i1]I~:~lli~~~ji:
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 FY11-12 UUT revenue is $2.52 million (or approximately 11%of
total General Fund revenue).Based upon the capital needs of the City,including the
unfunded San Ramon Canyon stabilization project (estimated cost of $19.4 million),Staff
recommends that the current UUT rate of 3%continues to be a necessary General Fund
revenue source to provide current program service levels and CIP funding.
On June 21 St,the City Council is expected to determine whether the UUT rate of 3%
continues to be a necessary General Fund revenue source and whether 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 2011 Model
The 2011 Model includes the presentation of:
~Actual FY08-09 and FY09-10 revenue,expenditures and ending fund balances for
all funds;
~The final adjusted budget and the calculated budget variance for FY09-1 0 revenue,
expenditures and ending fund balances for all funds;
~Estimated FY1 0-11 activity,primarily based on the adjusted FY1 0-11 budget;and
~The draft FY11-12 budget as the first year of the 2011 Model.
The 2011 Model includes the segregation of funds as follows:
3-3
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 4 of 9
~General Fund -The General Fund balance represents the City's unrestricted
reserve monies.These monies may be used for any City expenditure,including
general operations of the City.
~Funds restricted by action of the City Council -The fund balances of these funds
represent monies restricted by City Council action for a particular purpose.The
funds were initiated with transfers from the General Fund.These monies may be
returned to the General Fund or used for other purposes (e.g.infrastructure
projects)upon the action of the City Council.
~Funds restricted by law or external agencies -The fund balances of these funds
represent monies restricted by law or external agencies,such as the Federal
Government,State of California,or Los Angeles County.These monies can only be
used for the purpose outlined by the restricting agency in accordance with the terms
and conditions set by legislation and voter ballot measures.
The 2011 Model includes several schedules organized as follows:
Exhibit A
Exhibit B
Exhibit C
Exhibit D
Exhibit E
One Page Summary -2011 Five-Year Financial Model
2011 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 2011 Model.
Complete List of 2011 Model Assumptions
The following General Assumptions are consistent with previous years'Models:
1)General Fund expenditures have been increased an average of 4.2%in FY11-12.
The increase is primarily due to a more proactive approach to Public Works
maintenance,a one-time community survey,additions to the Emergency
Preparedness program,and unfreezing the Recreation Director position.
Forthe remaining years of the Model,expenditures have been increased by a range
of 2.7%to 3.7%.The increases are based on a weighted combination of the
forecasted increase of Consumer Price Index from the Congressional Budget
Office,annual 3%merit increases for employee salaries (after FY12-13),and
consideration of cyclical expenditures.
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 2011 Model using an
alphabetical index (a through p)and are referenced throughout the 2011 Model.
3-4
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 5 of9
Assumptions Specific to the Funds and Program Revenues and Expenditures Included in
the 2011 Model:
3)Property tax represents about 42%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.
The budgeted FY10-11 property tax revenue included a catch-up payment for the
Terranea Resort improvements.Due to the timing of the County re-assessment
process,additional property tax for FY09-1 0 was not paid to the City until FY10-11.
The FY11-12 estimate is based on the maximum 2%increase allowable by
Proposition 13 and an additional 0.3%increase for property sales and re-
assessments,based on Staff's analysis of information from the City's parcel
database.
4)With the FY1 0-11 Midyear Financial Report presented to City Council on February
15,2011,Staff estimated that transient occupancy tax (TOT)from Terranea would
reach $2.6 million.Staff is currently estimating that FY11-12 TOT revenue will
reach $2.8 million,and the revenue estimate in the Model has been increased by
the Consumer Price Index each fiscal year thereafter.On December 21,2010,the
City Council approved an amendment to its City Council Policy No.41:Reserve
Policies.Subject to the annual budgeting process,the CIP reserve will be funded,
to the extent possible,by allocating General Fund money equivalent to annual TOT
revenue.This practice provides a funding source for future capital projects,instead
of growing the General Fund operating budget.The 2011 Model includes annual
General Fund transfers to the CIP fund in accordance with the policy.During each
budget process,the City Council may allocate funding from the CIP Reserve to
recommended projects.Staff has included a recommended use of the CIP Reserve
for the following projects to improve the City's compliance with mandates,and to
take advantage of grant opportunities.
~Eastview Park playground improvements to address issues noted during a
playground safety audit (FY11-12 $80,000).
~Gateway Park development to be primarily funded with a grant.The City is
currently awaiting notification of grant award.The CIP Reserve would pay
the 20%matching contribution of $40,000 for FY11-12 and $55,000 for
FY12-13.
~Abalone Cove Shoreline Park improvements to be primarily funded with a
grant.The City is currently awaiting notification of grant award.The CIP
Reserve would pay the 20%matching contribution of $20,000 for FY11-12
and $30,000 for FY12-13.
~Americans with Disabilities Act (ADA)Transition Plan annual placeholder of
$400,000 for projects to improve the City's ADA compliance,beginning in
FY12-13.
3-5
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 6 of 9
5)The regional general law contract for police services is the single largest
expenditure of the General Fund (about 22%of total General Fund expenditures).
The Los Angeles County Sheriff's Department has provided a 3.07%cost increase
estimate for FY11-12 services.A 3%increase for years thereafter has been
included in the 2011 Model.
Both the cities of Rolling Hills Estates and Rolling Hills participate in the regional law
contract.This contract includes a provision for 2 CORE deputies,who provide
services such as Student &the Law classes at the local high schools,assistance
with resolving domestic and neighbor disputes,and patrols of shopping areas
surrounding the schools.The cost of the CORE program is about $332,000,of
which the City's 60%share is about $187,000.This program is partially funded by
$100,000 of COPS revenue from the state,which enables the City to receive a
"grant discount"on the CORE services.The state has not passed legislation that
would extend the 0.15%vehicle license fee that funds the COPS allocations to
cities.The League of California Cities has advised cities to not include the COPS
revenue in their draft FY11-12 budgets.If the City does not receive COPS revenue,
there is a question about whether CORE services would continue to be provided at
a discount.The City Council will need to consider the level of participation and
funding for the CORE program.
In the meantime,as the lead agency in the regional law contract,City Staff is
pursuing a potential federal grant to help fund the program and secure the
discounted rate,although the outcome will probably not be known until after
adoption of the FY 11-12 budget.
6)Staff continues to work with the City's grant consultant and federal advocate to
secure federal funding for San Ramon Canyon Stabilization Project.The project
has widespread support from federal,state and local representatives.The City has
submitted applications for both 50%funding from a state Proposition 1E grant and
an earmark from the federal Water Resources Development Act (WRDA).Staff
does not expect to hear from either agency until the end of 2011 or early 2012.Per
the San Ramon Project Study Report presented to City Council on March 1,2011,
construction of the ultimate solution is estimated to cost $19.4 million.Until funding
is secured,the project has been included in the CIP unfunded project list.
The FY10-11 budget includes a $1.4 million appropriation for the study report
necessary to apply for outside funding,as well as development of bid-ready
construction documents.On March 1,2011,the City Council authorized staff to
pursue final design and California Environmental Quality Act (CEQA)clearances.
Council also directed staff to urgently develop plans to relocate the sanitary sewer
currently located at the edge of the canyon.Finally,Council affirmed their desire to
have a "shelf-ready"early action plan (EAP)to stabilize the PVDE switchbacks.
Design of the EAP is nearly complete.The EAP project with an estimated cost of
about $2 million could be built in about 3 months.The EAP project mayor may not
be necessary,depending on the timing of construction of the ultimate solution.Staff
3-6
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 7 of 9
expects to request an appropriation of $200,000 in the FY10-11 budget,prior to
June 30,2011 for relocation of the sanitary sewer line.
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.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 funding.The cost of Master Plan update has been included in the 2011 ModeL
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 June 21,2011.As the CPI increase forthe
12 months ended February 2011 was 2.3%,Staff proposes a recommendation for a
2%increase to the Fee for FY11-12 (from $90.72 to $92.53 per equivalent
residential unit or ERU).During the Public Hearing conducted at the Oversight
Committee on May 25th
,the Committee voted (4-1 with Constantino dissenting)to
support Staff's recommendation to increase the Fee to $92.53 for FY11-12.The
Storm Drain Oversight Committee is expected to present its annual report at the
June 21 st public hearing.
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 regional systems with an estimated total
cost of about $9.4 million remain unfunded through FY15-16.As described
previously,the estimated cost of the San Ramon Canyon Stabilization project is
$19.4 million and is currently unfunded.The original 2005 program also included
about $4.6 million of pipe lining over 30 years.Through FY15-16,about $5.1 million
of pipe lining will have been completed over a period of 11 years.
8)The draft 2011 Capital Improvement Plan includes a list of unfunded projects with a
total cost range of $70 million to $105 million.The unfunded list includes the San
Ramon Canyon Stabilization project,a new civic center,various arterial roadway
projects,and many other projects.The 2011 Model does not include any projects
from the unfunded list.
9)On November 17,2009,the City Council approved a contract with Harris &
Associates engineering firm to develop a City-wide sewer user fee.Staff continues
to study the issue and the City's options,and will likely prepare a report for City
Council near the end of 2011.Nothing has been included in the 2011 Model for
potential future sewer fee revenue or the use of it for projects and/or maintenance.
10)The residential pavement program is primarily funded with General Fund monies.
Capital expenditures associated with the residential pavement management
program total about $7.8 million for FY11-12 through FY15-16.The estimates
included in the 2010 Model are based upon information provided by the City's
3-7
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 8 of9
pavement consulting engineer.Staff has included an allocation of $120,000 in the
draft FY11-12 budget for an update to Pavement Management Plan.
The 2011 Model also includes a $2.4 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,
Staff expects that the City's entire annual Proposition C allocation will be necessary
to fund maintenance of Palos Verdes Drive South in the Portuguese Bend area of
the City's active landslide.Therefore,the only restricted funding expected to be
available for other arterial projects is about $360,000 of Measure Rand $120,000 of
STIP annually.Although more information will become available after the Pavement
Management Plan is updated,it appears that this total annual allocation of
approximately $480,000 will not be sufficient to maintain the City's arterial streets
after FY11-12.The City Council and Staff will need to work together to develop a
sustainable solution for the future.
11 )The Citywide Americans with Disabilities Act (ADA)Transition Plan,which is
expected to be presented to the City Council during 2011,has identified projects
with cost estimates totaling $6,675,000.The Transition Plan addresses accessibility
to City facilities.The estimate does not include ADA improvements for City Hall and
Ladera Linda Community Center,as potential future improvements at those sites
are expected to make the facilities fully accessible.Additionally,the estimate does
not include sidewalks and curb ramps,as those improvements are expected to be
addressed as part of street improvement projects.As the City Council has not yet
reviewed the Plan,a placeholder of $400,000 annually has been included in the CIP
fund of the 2011 Model,beginning in FY12-13 until specific projects are identified
and approved by City Council during FY11-12.
12)The FY10-11 budget includes a $2 million appropriation for the development of
Lower Hesse and Grandview Parks,which was funded with TOT revenue from
Terranea.An allocation of $2.4 million has been included in the FY13-14 column of
the 2011 Model for a potential next phase of development,which will also likely be
funded with TOT revenue.In November and December 2010,the City Council
approved conceptual designs for development of both parks;and on April 19,2011,
the City Council approved a contract to prepare the necessary environmental
reviews.At this time,it is too early in the process to determine whether the existing
appropriation and future allocation will be sufficient to construct improvements at
both parks.Once better cost estimates are available,the City Council may consider
a phasing approach to these projects.
13)The City participates in the California Public Employee Retirement System
(CaIPERS)to provide a defined benefit retirement plan for its employees.The
required employer contribution for FY11-12 is 13.353%of payroll (about $735,000).
Annual rates thereafter are estimated to be 13.9%for FY12-13,15.5%for FY13-14,
15.8%for FY14-15,and 16.1 %for FY15-16.These contribution rates have been
included within the expenditures presented in the 2011 Model.
3-8
2011 FIVE-YEAR FINANCIAL MODEL
June 7,2011
Page 9 of9
14)On April 19,2011 the City Council approved implementation of Governmental
Accounting Standards Board Statement No.54,Fund Balance Reporting and
Governmental Fund Type Definitions.Three funds do not meet the more narrow
definition of a Special Revenue Fund and will be closed during FY1 0-11,with the
balances transferred to the General Fund.The Roadway Beautification,Utility
Undergrounding and RPV TV Funds were each funded with General Fund money.
Only the RPV TV Fund had a regular operating annual budget,which has been
included as a separate General Fund expenditure program in the 2011 Model.No
activity has been included in the five years of the Model for the closed funds.
15)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 maintenance expenditures outpacing interest earnings on the
non-expendable $1,000,000 portion of the fund balance.Therefore,Staff has not
included any further capital contributions to the Abalone Cove Landslide Abatement
District (ACLAD)beyond what is available through June 30,2011.
16)ln 2009,the City's Affordable Housing Fund purchased a condominium to be re-sold
as affordable housing.Staff expects that the unit will be sold during FY11-12,and
has included a placeholder for sale proceeds in the 2011 Model.The selling price is
currently unknown,and the placeholder amount is based upon the original purchase
price of the condominium unit.
17)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 November 2013.The governor's proposal for the state budget includes an
elimination of redevelopment agencies.At this time,the proposal has not garnered
enough votes for passage,but it remains a part of ongoing budget negotiations.
Should the proposal pass,it is unknown how the RDA's repayment of debt would be
affected.In addition to the County debt,the RDA has an outstanding long-term
advance from the City estimated to be $18.6 million at June 30,2011.Repayment
of the debt to the City cannot begin until the County deferred interest debt is paid
off;therefore,no repayment of the debt to the City has been included in the 2011
Model.
3-9
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
EXHIBIT A
Fund Balance 11-12 Estimated Resources 1-12 Estimated Appropriation Fund Bal Fund Bal Fund Bal Fund Bal Fund Bal
Fund Purpose 6/30/2011 Revenues Transfers In Expenditures Transfers Out 6/30/2012 6/30/2013 6/30/2014 6/30/2015 6/30/2016
Unrestricted
GENERAL primary operating budget 9,344,129 23,199,100 452,000 (18,767,065)(4,839,253)9,388,911 8,915,356 8,434,006 7,864,936 7,170,506
Restricted by Council Action
waste hauler fees for citywide
BEAUTIFICATION FUND beautification 319,698 281,600 -(95,400)(116,000)389,898 133,318 123,748 112,898 100,788
RPVTVFUND closed in 2011 - - - - -
0 0 0 0 0
centralized accounting for
CAPITAL IMPROVEMENT PROJECTS infrastructure projects 5,785,514 1,587,879 6,459,480 (5,924,032)-7,908,841 10,490,641 10,694,241 13,384,841 15,957,141
UTILITY UNDERGROUNDING closed in 2011 -- - - -
0 0 0 0 0
ROADWAY BEAUTIFICATION closed in 2011 -- - - -
0 0 0 0 0
EQUIPMENT REPLACEMENT sinking fund for future equipment 1,726,848 488,600 -(479,700)-1,735,548 1,748,848 1,766,248 1,788,448 1,815,248
BUILDING REPLACEMENT fund for future needs 645,019 3,200 - -
(145,000)503,219 507,019 512,119 518,519 526,319
EMPLOYEE BENEFITS centralized accounting 343,546 2,192,620 -(2,190,900)(340,000)5,266 5,306 5,356 5,426 5,506
Subtotal 8,820,425 4,553,899 6,459,480 (8,690,032)(601,000)10,542,772 12,884,932 13,101,712 15,809,932 18,405,002
Restricted by Law or External Agencies
STREET MAINTENANCE highway users tax 602,834 1,160,810 1,074,400 (2,320,679)-517,365 527,766 549,646 567,816 581,336
assessments for right of way
1972 ACT maintenance 35,371 258,180 -(71,800)(200,000)21,751 6,911 1,231 4,712 2,420
assessments for El Prado
EL PRADO LIGHTING neighborhood entrance 13,770 1,970 -(1,000)-14,740 15,750 16,860 18,070 19,390
fderal grant for home improvement
CDBG loans/grants &ADA projects -201,673 -(201,673)-0 0 0 0 0
1911 ACT assessments for street lighting 1,528,718 447,600 -(444,400) (202,000)1,329,918 1,221,018 1,108,518 990,618 865,118
WASTE REDUCTION hauler fees for recycling programs 194,176 204,175 -(182,650)(52,000)163,701 133,681 99,521 60,561 16,371
restricted revenue to improve air
AIR QUALITY MANAGEMENT quality 51,478 50,260 - - -
101,738 92,498 143,418 195,208 248,138
sales tax for arterial
PROPOSITION C streets/transportation 1,365,269 495,230 - -
(1,823,327)37,172 52 852 662 672
PROPOSITION A safes tax for transit 36,478 586,380 -(595,100)-27,758 18,968 20,458 14,818 1,638
PUBLIC SAFETY GRANTS restricted for special programs 34,918 170 -(19,600)-15,488 15,608 15,768 15,968 16,208
restricted for arterial
MEASURE R streets/transportation 1 364,600 - -
(384,000)601 166,701 539,571 924,911 1,325,681
HABITAT RESTORATION mitigation for other projects 259,692 1,300 90,000 (129,000)-221,992 182,652 159,582 159,272 169,662
SUBREGION 1 MAINTENANCE open space near Oceanfront Estates 758,720 3,800 60,000 (70,000)-752,520 753,120 753,520 753,520 752,920
MEASURE A restricted for park maintenance 34,331 100,170 - -
(100,000)34,501 34,761 35,111 35,551 36,081
assessments for sewer in the
ABALONE COVE SEWER DISTRICT landslide area 52,676 46,860 10,700 (63,900)-46,336 39,586 32,156 23,816 14,356
restricted for future specific purpose
GINSBURG CULTURAL ARTS BUILDING building 183,196 920 - --184,116 185,496 187,346 189,686 192,536
RECREATION IMPROVE DONATIONS private donations 403,847 2,020 - - -
405,867 408,907 412,997 418,157 424,427
developer fees for park
QUIMBY improvements 29,335 150 -(29,000)-485 485 485 495 505
AFFORDABLE HOUSING IN LIEU developer fees for affordable housing 2,065 330,010 -(2,000)-330,075 332,555 335,885 340,085 345,185
ENVIRONMENTAL EXCISE TAX developer fees for city facilities 82,076 410 -(51,000)-31,486 31,726 32,046 32,446 32,936
restricted for bike and pedestrian
BIKEWAYS access -25,000 --(25,000)0 0 0 0 0
user fees for storm drain
WATER QUALITY/FLOOD PROTECTION maintenance/projects 563,692 1,279,800 -(1,429,889)-413,603 431,381 569,447 724,942 1,335,565
20%set-aside of tax increment for
RDA HOUSING SET ASIDE affordable housing 18,133 234,600 -(12,500)-240,233 468,783 705,783 952,683 1,210,783
RDA DEBT SERVICE accounts for debt payments 304,726 1,608,500 -(1,554,250)-358,976 414,426 644,049 1,021,524 1,401,274
RDA -PORTUGUESE BEND capital projects in the landslide area 273,510 1,370 -(36,800)-238,080 202,670 166,400 128,980 90,010
RDA -ABALONE COVE capital projects in the landslide area 6,234 -- - -
6,234 6,234 6,234 6,234 6,234
maintenance of landslide mitigation
IMPROV AUTH -PORTUGUESE BEND projects 243,650 1,220 60,000 (143,350)-161,520 125,330 86,880 45,570 650
maintenance of landslide mitigation
IMPROV AUTH -ABALONE COVE projects 230,232 6,200 -(49,750)-186,682 145,682 105,828 66,713 28,029
Subtotal 7,309,128 7,413,378 1,295,100 (7,408,341)'(2,766;327)'5,842,938 5,962,747 6,729,592 7,693,018 9,118,125
GRAND TOTAL 25,473,682 3"5,166,377 8,206,580 ,.:(34,865,4381 '(8,206,580)25,774,621 27,763,035 28,265,310 31,367,886 34,693,633
3
-
1
0
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B I_esn...._
~FY10-11
-%Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase %Increase
ECONOMIC MODEL INPUT FACTORS (a-p):
Increase Factor (%)Revenues (a)N/A NlA N/A N/A N/A 2.0%2.0%2.0%2.0%2.0%
Increase Factor (%)Expenditures (b)N/A NlA N/A N/A N/A 4.3%2.9%3.0%3.2%3.4%
Consumer Price Index (%)(c)NlA N/A N/A N/A N/A 1.3%1.5%1.8%2.0%2.2%
Sales Tax (%)(d)N/A N/A N/A N/A N/A 2.0%2.0%2.0%2.0% 2.0%
Property Taxes (%)(e)NlA NlA N/A N/A N/A 2.3%2.5% 2.5% 2.5%2.5%
Sheriff Contract (%)(f)N/A N/A N/A N/A N/A 3.-;-%3.0%3.0%3.0%3.0%
Planning Permit Revenues (%)(g)NlA N/A N/A N/A N/A 5.4%4.5% 4.8%5.0% 5.2%
Building and Safety Revenues (%)(h)NlA NlA N/A N/A N/A 5.4%4.5%4.8%5.0% 5.2%
Vehicle License Fee (VLF)(%)(i)NlA N/A N/A N/A N/A 0.0%0.0%0.0% 0.0%0.0%
Transportation Sales Tax (%)(j)N/A NlA N/A N/A N/A 1.3%1.5%1.8%2.0% 2.2%
Property Transfer Tax (%)(k)NlA NlA N/A N/A N/A 2.0%2.0%2.0%2.0%2.0%
Transient Occupancy Tax(%)(I)NlA N/A N/A N/A N/A 1.3%1.5% 1.8%2.0%2.2%
Investment Interest (%)(m)NlA N/A N/A N/A N/A 0.50% 0.75%1.00%1.25% 1.50%
Utility Users Tax (%)(n)NlA NlA N/A N/A N/A 1.3%1.5%1.8%2.0% 2.2%
Franchise Tax (%)(0)NlA NlA N/A N/A N/A 1.3%1.5% 1.8%2.0%2.2%
Facility Rentals (%)(p)NlA NlA N/A N/A N/A 1.3%1.5%1.8%2.0%2.2%
3
-
1
1
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
i (l~.~I~III~.t~l~lllll
1111~i:M::i:i:iii:~);l~p:\~t~i\~[\\;~~;!~\jiii::i!i;mT;~\:;iili~m~~ji
SUMMARY OF ENDING FUND BALANCES lIJ
~
UNRESTRICTED FUND
(101)General Fund
RESTRICTED BY COUNCIL ACTION
(212)Beautification Fund
(226)RPV TV Fund
(330)CIP Fund
(341)Utility Undergrounding Fund
(342)Roadway Beautification Fund
(681)Equipment Replacement Fund
(686)Building Replacement Fund
(685)Employee Benefrts Fund
SUBTOTAL
RESTRICTED BY LAW OR EXTERNAL AGENCIES
City Funds
(202)Street Maintenance Fund
(203)1972 Act Landscape &lighting Fund
(209)EI Prado lighting Fund
(310)CDBG Fund
(211)1911 Act Street lighting Fund
(213)Waste Reduction Fund
(214)Air Quality Management Fund
(215)Proposition C (StreetslTransit)Fund
(216)Proposition A (Transit)Fund
(217)Public Safety Grants
(220)Measure R
(222)Habitat Restoration Fund -NCCP
(223)Subregion 1 Maintenance Fund
(224)Measure A Cap.&Main!.Funds
(225)Abalone Cove Sewer District Fund
(227)Ginsburg Cultural Arts Building Fund
(228)Recreation Improvements Donations Fund
(334)Quimby Fund
(337)Affordable Housing I"""lieu Fund
(338)Environmental Excise Tax (EET)Fund
(340)Bikeways (TDA Article 3)Fund
(501)Water Quality &Flood Protection Fund
RDA &Improvement Authority Funds
(218)RDA Housing Set -Aside
(410)RDA Debt Service Fund
(375)RDA -Portuguese Bend Fund
(380)RDA -Abalone Cove Fund
(285)Improvement Authority -Portuguese Bend
(795)Improvement Authority -Abalone Cove
SUBTOTAL
GRAND TOTAL·ALL FUNDS INCLUDED '
&;344:.12&1 9;388,911]IM'15,3~1 8,434,®61 7,864,&361 7,170,506
1.367.251 449.621 858.102 408,481 319.698 389,898 133,318 123,748 112,898 100,788
(4,714)(13,304)1,152 14,456 0 0 0 0 0 0
7.207,180 9,798.481 7,081.596 (2.716,885)5,785.514 7,908,841 10,490.841 10.694,241 13.384.841 15.957,141
273,770 277;870 275.159 (2,711)0 0 0 0 0 0
101,553 103,053 102,068 (985)0 0 0 0 0 0
2.968,158 2.617.458 2.818.448 200.990 1,726.648 1,735,548 1,748.648 1.766.248 1,788.448 1.815,248
1.326,051 1,172;851 1,042.319 (130,532)845.019 503,219 507.019 512,119 518.519 526,319
204,841 36,312 358,947 322,835 343,546 5,266 5.306 5.356 5,426 5,506
13,444,0$0 14,442,342 12,537,791 (1,904;5511 &,&2Q,425 10,542,772 12,&&4,932 13,10t,m 15,&09,&32 18,405,002
424,481 277.195 778;018 49a,B23 602,&34 517.365 527.7136 549,846 567,816 581.336
58;859 48.1!111 50,744 2.726 35,371 21,751 6.911 1,231 4.712 2,420
11.138 2.168 12;850 1Q,682 13,770 14,740 15.750 16,1I60 18.070 19,390
(6)(6)0 6 0 0 0 0 0 0
1,632.607 1,560.007 1,639.1111 79,111 1,528,718 1.329,918 1,221.018 1,108,518 990.618 865,118
174,105 123.787 230,495 106.708 194,176 163,701 133.681 99,521 60.561 16.371
52,776 53.376 51.406 (1.968)51.478 101,738 92,498 143,418 195.208 248,138
2,564.999 83,512 1.695.557 1.612.045 1.365;269 37,172 52 852 662 672
197,694 4.917 100.264 95,347 36,478 27.758 18.968 20,458 14.818 1,638
34,540 905 34,918 34;013 34.918 15,4811 15.608 15,768 15,968 16,208
0 221.267 273.216 51.949 1 601 166,701 539,571 924.911 1,325,681
225.180 201.189 275.193 74,004 259,692 221,992 182.652 159,582 159,272 169,662
767.336 766.636 773;920 7.264 758,120 752.520 753,120 753,520 753.520 752,920
33.9211 33.928 34.161 233 34.331 34,501 34,761 35,111 35.551 36,081
93.594 52,476 58.342 5,866 52.676 46,336 39,586 32,156 23.816 14,356
500.503 202,684 202.156 (508)183.196 184,116 1115,496 187,346 189.686 192,536
2.082 2.01l2 403.1I37 401,755 403.847 405.867 408,907 412,997 418.157 424,427
25.170 1,325.170 29.205 (1,295,965)29.335 485 485 485 495 505
838.333 7.975 1.773,393 1.765,418 2;065 330,675 332,555 335,885 340.085 345.185
839.293 562,468 664.251 121,783 82.076 31,486 31.726 32,046 32.446 32.936
0 0 0 0 0 0 0 0 0 0
2.108.364 (3.967,344)2.824,621 6.791,965 563,692 413,603 431,381 569.447 724.942 1,335,565
2.067.751 456,423 1,424.713 968,290 18.133 240,233 468,783 705.783 952.683 1,210,783
603,677 (477,248)338,461 815,709 304.726 358,976 414,426 644,049 1.021.524 1,401,274
541,041 516,268 565.803 49,535 273,510 238,080 202,670 166.400 128.980 90,010
6,171 6.261 6.204 (57)6.234 6.234 6.234 6,234 6.234 6,234
231,613 205.733 283.320 77,587 243,650 161.520 125,330 86,880 45,570 650
362,231 273,555 333.222 59;667 230.232 186.6112 145.682 105.828 66.713 28.029
14,397,260 2,543,382 14,&75,390 12,332,®8 I'7,3119,128 5,842,938 5,962,747 6,729,592 7,693,018 9,118,125
I
38,281;6061116,985,72411 '38,157,3100 (21,171,586'1:25,473,682;I 25,774,62111 27,763,035U 28,265,310.31,367,8861 34,693,633 I
3
-
1
2
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
,,",MA"
;::FY10-11
GENERAL FUND REVENUE DETAIL
TAXES:
Property taxes (e)5,855,099 5,924,893 5,820,225 (104,668)6,239,417 6,172,700 6,327,000 6,485,200 6,647,300 6,813,500
Property taxes In-Lieu of VLF Revenues (e)3,388,494 3,428,500 3,433,202 4,702 3,490,200 3,599,400 3,689,400 3,781,600 3,876,100 3,973,000
Property taxes In-Lieu of Sales Tax (d)301,454 301,500 296,349 (5,151)310,500 440,000 448,800 457,800 467,000 476,300
Sales and use tax (d)1,060,220 1,211,767 1,157,795 (53,972)1,630,400 1,543,300 1,574,200 1,605,700 1,637,800 1,670,600
Property transfer tax (k)178,813 207,100 238,303 31,203 180,000 209,100 213,300 217,600 222,000 226,400
Business license lax (e)531,982 515,600 609,176 93,576 608,800 593,300 605,200 616,100 628,400 642,200
Transient occupancy lax (I)85,245 1,826,100 1,954,507 128,407 2,626,100 2,830,000 2,872,500 2,924,200 2,982,700 3,048,300
Franchise taxes (0)1,709,009 1,719,715 1,711,456 (8,259)1,726,000 1,811,700 1,847,900 1,881,200 1,918,800 1,961,000
Utility user tax (n)2,267,431 2,448,800 2,395,107 (53,693)2,461,800 2,520,700 2,571,100 2,617,400 2,669,700 2,728,400
Golf tax (e)278,343 333,000 346,413 13,413 336,300 338,600 345,400 351,600 358,600 366,500
Total Taxes 15,656,090 17,916,975 17,962,533 45,558 19,609,517 20,058,800 20,494,800 20,938,400 21,408,400 21,906,200
LICENSES AND PERMITS:
Animal control fees (a)45,810 55,000 50,161 (4,839)58,600 51,200 52,200 53,200 54,300 55,400
Right of way &parking permits (h)39,819 63,800 58,947 (4,853)59,100 87,500 91,900 96,300 101,100 106,400
Building and safety permits &geology fees (h)1,278,568 1,015,800 1,310,514 294,714 1,351,200 1,446,800 1,511,600 1,577,000 1,648,400 1,726,300
Planning permits (9)367,545 791,400 462,509 (328,891)495,600 378,400 397,300 416,400 437,200 459,900
Film permits (e)21,408 66,100 88,982 2,882 50,000 76,900 78,400 79,800 81,400 83,200
Massage Permits (e)1,537 0 2,715 2,715 0 2,800 2,900 3,000 3,100 3,200
Tolal Licenses &Permits 1,754,687 1,992,100 1,953,828 (38,272)2,014,500 2,043,600 2,134,300 2,225,700 2,325,500 2,434,400
FINES &FORFEITURES:
Miscellaneous court fines (a)205,635 205,400 173,049 (32,351)140,600 148,900 151,900 154,900 158,000 161,200
False alarm fines (a)8,265 13,100 5,900 (7,200)13,400 6,000 6,100 6,200 6,300 6,400
Tolal Fines &Forfeitures 213,900 218,500 178,949 (39,551)154,000 154,900 158,000 161,100 184,300 167,600
USE OF MONEY &PROPERTY:
Property &Monopole Leases (e)158,019 179,300 228,814 49,514 125,800 142,500 145,400 148,000 151,000 154,300
Facility rentals -PVlC (p)181,534 176,800 208,855 32,055 180,000 123,800 126,300 128,600 131,200 134,100
Facility rentals -Other (p)130,699 113,100 115,118 2,018 106,500 115,600 117,900 120,000 122,400 125,100
Parking lot fees 43,857 43,500 50,582 7,082 43,500 48,900 48,900 48,900 48,900 48,900
PVlC gift shop (e)80,272 97,400 97,738 338 98,100 110,000 112,000 114,000 116,300 118,900
Interest earnings (m)266,124 90,100 73,144 (16,956)65,000 51,700 77,920 99,150 117,930 132,970
Total Use of Money &Property 860,505 700,200 774,251 74,051 618,900 592,500 628,420 658,650 687,730 714,270
CHARGES FOR SERVICES:
Recreation fees (e)8,863 8,900 6,695 (2,205)9,000 9,400 9,600 9,800 10,000 10,200
Sale of Signs/Services (e)4,618 6,500 7,308 808 6,600 7,500 7,700 7,800 8,000 8,200
Interfund charges for services (a)145,300 148,200 148,200 0 151,200 154,300 157,400 160,500 163,700 167,000
Total Charges For Services 158,781 163,600 162,203 (1,397)166,800 171,200 174,700 178,100 181,700 185,400
REVENUES FROM OTHER AGENCIES
Motor vehide license fees (i)147,904 140,000 127,658 (12,342)140,000 151,900 151,900 151,900 151,900 151,900
Grant income 4,797 62,972 43,018 (19,954)15,000 0 0 0 0 0
Total Revenues From Other Agencies 152,701 202,972 170,676 (32,296)155,000 151,900 151,900 151,900 151,900 151,900
OTHER REVENUES:
Donations (a)37,182 14,800 11,722 (3,078)15,100 21,000 21,300 21,700 22,100 22,500
Other miscellaneous (a)82,314 20,400 89,069 68,669 18,900 5,200 5,300 5,400 5,500 5,600
Total Other Revenues 119,496 35,200 100,791·65,591 34,000,26,200 26,600 27,100 27,600 28,100
TOTAL GENERAL FUND REVENUES 18,916,160 21,229,547 21,303,231 73,684 22,752,717 23,199,100 23,768,720 24,340,950 24,947,130 25,587,870
3
-
1
3
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
GENERAL FUND EXPENDITURE DETAIL
~Ji'l~t.III.I.i ::~~f:~~:~:::::::~:::~::~~~:~~:
City Council
City Manager (indudes Risk Management)
City Attorney
City Clerk
Community Outreach
RPVTV
Personnel
Total Administration
Finance
Information Technology -Data
Information Technology -Voice
Total Finance &Information Technology
Public Safety -Sheriff Services
Special Safety Programs
Animal Control
Emergency Preparedness
Total Public Safety
Public Works Administration (Staffing.Project
Management.and Engineering)
Traffic Management
Storm Water Quality (NPDES Compliance)
Public Building Maintenance
Parks,Trails &Open Space Maintenance
Sewer Maintenance
Total Public Works
Planning
Building &Safety Services
Code Enforcement
View RestorationlPreservation
Natural Community Conservation Planning (NCCP)
Geology (Privately Initiated Projects)
Total Community Development
Recreation Administration (Staffing.Park Rangers)
Recreation Facilities
Special Events
PI.Vicente Interpretive Center (PVlC)
REACH
Total Recreation &Parks
Contingent Liabilities
TOTAL GENERAL FUND EXPENDITURES
GENERAL FUND NET BEFORE TRANSFERS
(b)104.015 106.766 105,935 633 106,135 .'136,500 143,500 147,600 152.500 157.700
(b)1,266,969 1.544,156 1.375,577 166,579 1,716.767 1,696,300 1,675,000 1.725,300 1,760.500 1,641.000
(b)1,000,542 1,075,000 1,046,721 26,279 1,065,000 1,065,000 1,065.000 1.097,000 1,132.100 1,170.600
(b)276,369 367,463 379,289 6,174 460,549 492,550 414,450 507,300 427.700 524.500
(b)143.350 69,650 65,961 3;669 94,400 107,800 107,800 111.000 114.600 116,500
(b)0 0 0 0 0 101,000 104.700 107,600 111,200 115,000
(b)179.064 211,563 206,212 5,371 247.469 251,350 204.250 272,200 260.900 290.500
2,970.369 3,414,620 3.201,695 212,925 3.692.320 3,850,500 3,774.700 3.968,400 3,999.500 4,217,800
(b)T 1,053.750 1,272,160 1.269,290 2,890 1,324,570 1,3:75,300 1,454.000 1,497,600 1,545.500 1.596.000
(b)I 705.669 566.340 545,915 22,425 506.747 599,200 586.600 604,400 623.700 644,900
(b)l '65.399 81.705 73,675 8,030 92.970 93,600 123,400 127,100 131,200 135.700
1,824.818 1,922,225 1.668,680 33,345 1,926.287 2,068,300 2;154.200 2.229,100 2,300,400 2,376,600
(f)3,941.861 3,995.750 3.939.g97 55,753 3,994.067 3.953.000 4.235.000 4.362.100 4,493.000 4.627,600
(b)71,934 42,000 36,294 3,706 240,545 71,500 71.500 73,600 76,000 76,600
(b)117,926 125,250 92,529 32,721 140.250 120.250 122,750 126,400 130,400 134,600
(b)69,229 172,177 171,265 912 176.745 148,300 156,900 161,600 168.600 172.500
4,2oo,g70 4.335,177 4.242.085 9$,092 4,551.627 4.293,050 4,586,150 4.723,700 4,866.200 5,013.700
(b)1.081,341 1.711,021 1.658,617 52,404 1,995,660 2,055.000 2,154.200 2.229.100 2,300,400 2,378.600
(b)291.539 220.600 209,778 10,822 346.400 154.000 156,000 160.700 165.800 171,400
(b)146,800 221,900 122,283 99,617 174,600 180.300 180.800 186.200 192.200 198.700
(b)576.573 572,200 447,625 124.375 634,000 614.600 564,200 601,700 621.000 542.100
(b)629.796 699,693 613,556 266,337 1;617,249 1,130.250 1,124;000 1.157.700 1.194.700 1.235.300
(b)102.344 131.300 57.194 74.106 90,300 63,000 63,000 54.900 67.000 69.300
3.034,393 3.756.914 3,109,253 547,661 5.060,209 4,197.350 4;272.200 4.400,300 4,541.100 4,695,400
(b)1,315,607 1,310.944 1,320.667 (g.923)1,462,644 1,296.600 1.352,500 1,393,100 1,437,700 1,466,600
(b)519.945 646,177 611.145 35,032 650,509 653.200 666,300 706,900 729,500 754,300
(b)177,141 201,658 179,496 22,162 191,594 206.500 221,200 227,600 235,100 243,100
(b)193.154 326,286 324.139 2,149 326.276 339,500 353.800 364,400 376,100 366,900
(b)45.561 10,550 10,550 0 65.450 0 0 0 0 0
(b)160,722 200,000 106,453 91,547 200.000 150,000 150.000 154,500 159,400 154,600
2,412.150 2,695,617 2,554,650 140,967 2,916,673 2,648,000 2,763,600 2,646,700 2.937,600 3.037,700
(b)491,510 639,756 593,121 46.629 323.220 779,300 624,700 949,400 676,600 906,400
(b)350,404 430,296 419,636 10,460 461,536 441,190 467.250 461,300 496,700 513.600
(b)66.667 40.904 25,767 15.117 40.960 52,200 69,500 71.600 73,900 76,400
(b)334,067 335,331 294,565 40.766 326,291 363,375 407,375 419,600 433,000 447.700
(b)91,263 74.672 66,468 6.164 53,790 53,600 50.200 51.700 53,400 55.200
1.353,931 1.520,959 1,401,603 119.156 1,207,819 1,709,665 1,619.025 1.873.600 1,933.600 1,999.300
0 0 320,000 (320.000)0 0 0 0 0 0
15.796,631 1 17.645.512 1 16.718,366 I 927,1461 19,354,9351 16.767.06511 19.360,07511 20.041,600 1f20.576.6oo II 21,342.500
I I 1 I I 1
3.119,5291 3.564,0351 4,564.6651 1,000,8301 3,397.762;I 4,432.03511 4,366,64511 4,299,15011 4,366,530 II 4,245,370
I 1 1 I I 1 I I
3
-
1
4
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!_~nMA~~FY10-ll
GENERAL FUND TRANSFER DETAIL
GENERAL FUND TRANSFERS IN:
From CDBG fund -REACH 20,646 26,848 26,847 (1)0 0 0 0 0 0
From RPVTV 0 0 0 0 0 0 0 0 0 0
From Measure A Maint 54,200 151,000 38,460 (112,540)151,000 100,000 100,000 100,000 100,000 100,000
From Public Safety Grants fund 100,000 100,000 100,000 0 100,000 0 0 0 0 0
From Waste Reduction 0 12,000 0 (12,000)12,000 12,000 12,000 12,400 12,800 13,200
From Employee Benefits 0 0 0 0 0 340,000 0 0 0 0
From Utility Undergrounding 0 0 0 0 276,549 0 0 0 0 0
From Roadway Beautification 0 0 0 0 102,588 0 0 0 0 0
From Proposition A 2,700 2,800 2,800 0 0 0 0 0 0 0
Total General Fund Transfers In 177,546 292,648 168,107 (124,541)642,137 452,000 I 112,000 II 112,400 U 112,800 I 113,200
GENERAL FUND TRANSFERS OUT:
To CIPfund 4,531,571 1,416,000 1,416,000 0 6,413,299 4,618,553 4,702,500 4,499,200 4,577,700 4,523,300
ToCDBG 0 0 0 0 44,000 0 0 0 0 0
To Improvement Authority PB 82,252 110,000 110,000 0 101,000 60,000 106,000 108,000 110,000 112,000
To Abalone Cove Sewer District 10,700 14,700 14,700 0 32,700 10,700 10,700 10,700 10,700 10,700
To Habitat Restoration 115,000 169,000 169,000 0 109,900 90,000 90,000 110,000 137,000 152,000
To Subregion 1 Maintenance fund 55,000 55,000 55,000 0 70,000 60,000 65,000 65,000 65,000 65,000
To Street Maintenance fund 455,025 22,000 22,000 0 0 0 0 100,000 150,000 190,000
To RPVTV 54,590 105,000 105,000 0 84,270 0 0 0 0 0
To Employee Benefits 0 1,594,125 1,575,501 18,624 0 0 0 0 0 0
To RDA Debt Service fund 0 45,800 0 45,800 47,200 0 0 0 0 0
Total General Fund Transfers Out 5,304,138 I 3,531,62511 3,467,201 II 64,4241 6,902,3691 4,839,25311 4,974,200 II 4,892,900 II 5,050,400 I 5,053,000
I I I I
Net Activity (2,007,063)I 345,05811 1,285,77111 811,8651 (2,862,450)1 44,78211 (473,555)11 (481,350)11 (569,070)1 (694,430)
I I
3
-
1
5
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
GENERAL FUND SUMMARY
Beginning Fund Balance
Plus:Revenues
Less:Expenditures
Plus:Transfers In
Less:Transfers Out
Ending Fund Balance
Less Fund Balance Reservations:
PB &AC RDA Loans,Bond Restructuring
Continuing Appropriations
Prepaid Items &Other
Available Fund Balance
Policy Reserve Threshold
surplus/(Deficit)Reserve vs.Policy Threshold
~
20,094,337 18,087,274 18,087,274 0 19,373,045 16,510,595 16,555,377 16,081,822 15,600,472 15,031,402
18,916,160 21,229,547 21,303,231 73,684 22,752,717 23,199,100 23,768,720 24,340,950 24,947.130 25.587.870
(15,796,631) (17,845,512) (16.718,366)927,146 (19,354,935)(18,767,065)(19.380,075)(20,041,800)(20,578.600) (21.342,500)
177,546 292,848 168,107 (124,541)842,137 452,000 112.000 112,400 112.800 113,200
(5.304,138)(3,531,625)(3,467,201)84,424 (6.902,369)(4,:>39,253)(4,974.200)(4.892,900) (5,050,400)(5.053.000)
18,087,274 18,432.332 19,373,045 940.713 16.510,595 16,555,377 16,081.822 15.600,472 15.031,402 14.336,972
6,306.376
1,462.450
860.090
.744,129
8.359,183
2,384,946
3
-
1
6
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10·11
BEAUTIFICATION FUND DETAIL IFund·2121
Revenues
Beautification revenue (c)198,398 150,000 200,220 50,220 296,000 280,000 280,000 285,000 290,700 297,100
Interest earnings (m)22,672 12,900 7,188 (5,712)3,110 1,600 2,920 1,330 1,550 1,690
Total Revenue 221,070 I 162,900 II 207,40811 44,5081 299,110 I 281,600 II 282,920 II 286,330 n 292,2501 298,790
Expenditures
Personnel services (b)20,151 15,230 14,670 560 15,414 15,900 16,900 17,400 18,000 18,600
Beautification Grants 143,875 11,000 6,833 4,167 150,000 75,000 75,000 75,000 75,000 75,000
Operations &maintenance (b)4,200 6,300 4,300 2,000 6,400 4,500 4,600 4,700 4,900 5,100
Total Expenditures I 168,22611 32,530 II 25,80311 6,7271 171,8141 95,400 II 96,500 n 97,100 n 97,900 1 98,700
I I I
BEAUTIFICATION FUND NET BEFORE TRANSFERS 52,844 130,370 I 181,6051\51,2351 127,2961 186,200 I 186,420 I 189,230 n 194,3501 200,090
Transfers Out
To CIP fund·Street Improvements (median projects)
12,784 838,000 480,754 357,246 500,500 0 250,000 0 0 0
To Street Maintenance fund (median maintenance)0 210,000 210,000 0 165,200 116,000 193,000 198,800 205,200 212,200
Total Transfers Out 12,784 I 1,048,000 II 690,754 n 357,2461 665,700 I 116,000 n 443,000 n 198,800 H 205,200 1 212,200
BEAUTIFICATION FUND SUMMARY
Beginning Fund Balance 1,327,191 1,367,251 1,367,251 0 858,102 319,698 389,898 133,318 123,748 112,898
Plus:Revenues 221,070 162,900 207,408 44,508 299,110 281,600 282,920 286,330 292,250 298,790
Less:Expenditures (168,226)(32,530)(25,803)6,727 (171,814)(95,400)(96,500)(97,100)(97,900)(98,700)
Less:Transfers Out (12,784)(1,048,000)(690,754)357,246 (665,700)(116,000) (443,000)(198,800)(205,200) (212,200)
Ending Fund Balance 1,367,251 449,621 I 858,10211 408,481 I 319,6981 389,89811 133,318 n 123,74811 112,8981 100,788
I I I
3
-
1
7
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10·11...,•..•,~.,..,.•••••••.••••.•,•••••,?..•••.••
RPV TV IFund·226)
Revenues
Donations 0 1,000 0 (1,000)1,000 0 0 0 0 0
Interest earnings 192 160 (12)(172)10 0 0 0 0 0
Total Revenue 192 I 1,160 II (12)11 (1,172)1 1,010 I 01 01 011 01 0
Expenditures
Personnel services 16,990 30,250 23,547 (6,703)31,132 0 0 0 0 0
ProfessionallTechnical ServiceslEquiprnent 84,099 69,500 75,575 (6,075)55,300 0 0 0 0 0
Total Expenditures 101,089 99,750 99,122 (12,778)86,432 01 011 011 01 0
RPV TV FUND NET BEFORE TRANSFERS (100,897 I (98,590)11 (99,134)11 (13,950)1 (85,422)1 011 011 On 01 0
T
Fund Transfer In I
From General Fund 54,590 90,000 105,000 15,000 I 84,270 0 0 0 0 0
Total Transfer In 54,590 I 90,000 II 105,000 II 15,000 I 84,270 I 01 01 011 01 0
I I I
Transfers Out -General Fund 0 01 0 oT oT 0 0 0 0 0
Total Transfers Out 01 011 011 01 01 01 01 on 01 0
RPV TV FUND SUMMARY:
Beginning Fund Balance 41,593 (4,714) (4,714)0 1,152 0 0 0 0 0
Plus:Revenues 192 1,160 (12)(1,172)1,010 0 0 0 0 0
Less:Expenditures (101,089)(99,750)(99,122)628 (86,432)0 0 0 0 0
Plus:Transfer In 54,590 90,000 105,000 15,000 84,270 0 0 0 0 0
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Ending Fund Balance (4,714)1 (13,304)11 1,15211 14,4561 01 011 011 On 01 0
I I I I I
T T T I I
3
-
1
8
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
CIP FUND DETAIL (F"'"cl4$OI
~~~.ll~~.'\il~t.II.I:E~~~~E :~~
Revenues
Grant-Federal
Grant-State
Miscellaneous revenues
Interest eamings
Total CIP Fund Revenue
(m)
1,400
640.620
17,803
44,361
1.262.000
1.542.720
5,950,000
64,600
1.278.874
220,000
5,936,747
30,220
16.874
(1,322,720)
(13,253)
(34,380)
o
2,236,000
o
17,400
362.000
1.196.979
o
28,900
o
590.000
o
59.300
o
o
o
104,900
104,900
o
o
o
133,700
133,700
o
o
o
200,800
200,800
Expenditures
Total CIP Fund Expenditures (see Exhibit C)
CIP FUND NET BEFORE TRANSFERS
Transfers In
1,501,47711 12,004,303 U 10,484,860 II 1,519,4431 11,715,7071 5,924,03211 3,245,000 II 4,425,500 1 2,046,000 II 2,176,600
1
(797,293~1 (3.184,983)11<3,019.019)11 165,9841 (9,462,307)1 (4,336,153)11 (2,595,700)11 (4,320.600)11 (1,912,300)11 (1,975,800~
From General fund 1 1 4,531,5711 1,416,000 I 1,416,0001 01 6,413,2991 4,618,553 1 4,702,500 I 4,499,200 I 4,577,700 I 4,523,300
From Street Maintenance fund 1 1 0 1 0 1 01 01 127;0801 0 1 0 I 0 1 0 1 0
From Waste Reduction fund 1 1 0 1 0 1 0 1 01 111,0001 0 1 0 1 0 1 0 1 0
From Measure R fund 1 1 0 I 0 1 0 1 0 1 638;080 I 364.000 1 200,000 1 0 1 0 1 0
From Measure A CapitallMaintenance fund 1 1 21,700 1 10,913 1 10,9131 01 01 0 1 0 1 0 1 0 1 0
From Proposition C fund 1 I 0 I 2,486,771 1 760,8801 (1,705,891)1 262.9931 1,306,927 I 0 1 0 1 0 1 0
From Proposition A fund 1 1 12,450 I 67,000 101 (67,000)1 01 0 1 0 1 0 1 0 1 0
From Recreation Improvements Donations fund 1 I 0 I 600.000 1 01 (600,000)1 01 0 I 0 1 0 1 0 1 0
From Building Replacement 1 I 0 I 0 1 01 01 01 145,000 1 0 1 0 1 0 1 0
From Bikeways fund 1 I 30.002 I 25,000 1 18.5881 (6,412)1 26,9731 25,0001 25,000 I 25,000 I 25,000 1 25,000
From EET fund I 1 0 1 332,600 1 186,300 1 (146,300)1 86,3001 0 1 0 1 0 1 0 1 0
From Beautification fund
Total Transfers In
Transfers Out 0
Total Transfers Out 0
CIP FUND SUMMARY
Beginning Fund Balance
Plus:Revenues
Less:Expenditures
Plus:Transfers In
Less:Transfers Out
Fund Balance
3,395,966 7.207.180 7,207,180 0 7,081,596 5,785,514 7,908,841 10,490.641 10,694,241 13,384,641
704.184 8,819,320 7,465,841 (1.353,479)2.253,400 1,587,879 849,300 104,900 133,700 200,800
(1,501,477)(12,004,303) (10,484,860)1,519,443 (11,715.707)(5,924,032) (3,245.000)(4,425,500)(2,046,000)(2,176.600)
4,608,5071 5,776,284 2,893,435 (2,882,849)8,166,225 6,459,480 5.177.500 4,524.200 4,602,700 4,548,300
I
01 0 0 01 01 01 01 01 01 0
7,207,180]1 .9,7{l8,±8.1JI__7"081,59611 (2,716.885)1 5,785,5141 7,908,84111 10,490,64111 10,694,2411 13,384,641 11f5,957,141
Emergency Reserve +Reserve for FEMA revenue
received for disaster projects not yet closed
Available Fund Balance
3.274,430
2.511,084
3,274,430
4,634,411
3,274,430
7,216,211
3,274,430
7,419,811
3,274,430
10,110,211
3.274,430
12,682,711
3
-
1
9
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!'l.ESTIMATE
FY10·11
UTILITY UNDERGROUNDING FUND DETAIL IFund·
3411
Revenues
Interest earnings 4,529 4,100 1,389 (2,711)1,390 0 0 0 0 0
Total Revenue 4,529 I 4,100 II 1,38911 (2,711>!1,390 I 01 01 On 01 0
1 1
Expenditures 1 1
ProfessionalfTechnical Services 0 0 0 0 01 0 0 01 0 0
Total Expenditures 0 01 011 01 01 ..~On on 01 0
1
UTILITY UNDERGROUNDING FUND NET BEFORE
I 4,52911 4,100 II 1,38911 (2,711)1 1,390 I 01 01 01 01TRANSFERS 0
I I T I
Fund Transler In 1 1 1
From General Fund 01 0 0 01 01 0 0 0 0 0
Total Transfer In I 011 011 011 01 01 011 on on 01 0
1 1 1 1
Transfer Out to General Fund 0 0 0 01 276,5491 01 01 0 0 0
Total Transfer Out 1 011 011 011 01 276,5491 011 On on 01 0
UTILITY UNDERGROUNDING FUND SUMMARY:
Beginning Fund Balance 269,241 273,770 273,770 0 275,159 0 0 0 0 0
Plus:Revenues 4,529 4,100 1,389 (2,711)1,390 0 0 0 0 0
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 (276,549)0 0 0 0 0
Ending Fund Balance 273,770 I 277,870 II 275,159 n (2,711)1 01 011 On on 01 0
1 I T I
1 I 1 I
3
-
2
0
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10·11
ROADWAY BEAUTIFICATION FUND DETAIL (Fund·
3421
Revenues
Inlerest eamings 1,678 1,500 515 (985)520 0 0 0 0 0
Total Revenue 1,678 1,500 I 51511 (985)1 520 I 01 01 011 01 0
Expenditures
Improvement Other Than Buildings 0 0 0 0 0 0 0 0 0 0
Total Expenditures 01 01 01 01 01 011 011 On 01 0
T T I
ROADWAY BEAUTIFICATION FUND NET BEFORE
1,6781 1,500 II 51511 (985)1 520 I 011 011 011 01TRANSFERS 0
I I I I
Fund Transfer In 0 0 0 01 01 0 0 01 0 0
Total Transfer In I On 011 011 01 01 01 01 on 01 0
1 1 1
Fund Transfer Out 0 0 0 01 102,5881 0 0 01 0 0
Total Transfer Out 01 011 011 01 102,5881 011 On on 01 0
ROADWAY BEAUTIFICATION FUND SUMMARY:
Beginning Fund Balance 99,875 101,553 101,553 0 102,068 0 0 0 0 0
Plus:Revenues 1,678 1,500 515 (985)520 0 0 0 0 0
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 (102,588)0 0 0 0 0
Ending Fund Balance 101,553 I 103,053 n 102,06811 (985)1 01 011 On on 01 0
I I T 1
I I 1 I
3
-
2
1
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!_6".m::FY10·11
EQUIPMENT REPLACEMENT FUND DETAIL (Fund·
6811
Revenues
Interfund charges (b)180,600 69,700 69,700 0 59,100 480,000 568,600 647,500 668,200 690,900
Interest earnings (m)52,772 38,900 14,864 (24,036)9,400 8,600 13,000 17,500 22,100 26,800
Total Revenue I 233,372 11 108,600 II 64,5641 (24,036)68,500 488,600 I 581,600 II 665,000 II 690,300 I 717,700
Expenses
Vehicles and vehicle maintenance (b)64,294 70,900 66,261 4,639 70,000 52,000 82,000 64,500 87,200 90,200
Computer equipment and maintenance (b)121,765 216,200 91,573 124,627 955,800 342,500 458,500 472,300 487,400 504,000
Furniture and equipment maintenance (b)160,634 172,200 130,870 41,330 134,500 85,200 88,000 90,600 93,500 96,700
Total Expenses I 346,69311 459,300 II 288,70411 170,5961 1,160,300 I 479,700 II 628,500 II 647,400 II 668,100 I 690,900
1 I 1 I I 1
EQUIPMENT REPLACEMENT FUND NET BEFORE I (113,321JI (350,700)11 (204,140JI 146,5601 (1,091,800)1 8,900 II (46,900)11 17,600 II 22,200 ITRANSFERS 26,800
I I I 1 1
Transfers In 0 0 0 01 01 01 60,0001 01 0 0
Total Transfers In 01 011 011 01 01 011 60,000 II 011 01 0
I
Transfers Out 0 0 0 0 0 0 0 01 0 0
Total Transfers Out I 011 011 01 0 0 0 01 011 01 0
EQUIPMENT REPLACEMENT NET ASSET
Beginning Net Assets 3,023,617 2,968,158 2,968,158 0 2,818,448 1,726,648 1,735,548 1,748,648 1,766,248 1,788,448
Plus:Revenues 233,372 108,600 64,564 (24,036)68,500 488,600 581,600 665,000 690,300 717,700
Less:Expenses (346,693)(459,300)(288,704)170,596 (1,160,300)(479,700)(628,500)(647,400)(668,100)(690,900)
Plus:Transfers In 0 0 0 0 0 0 60,000 0 0 0
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
(Increase)/Decrease in Capital Assets 57,862 0 54,430 54,430 0
Available Net Assets 2,968,158 I 2,617,45811 2,818,44811 200,990 I 1,726,6481 1,735,54811 1,748,64811 1,766,24811 1,788,4481 1,815,248
Invested In Capital Assets 317,776 N/A 263,346 I I
Ending Net Assets Per Financial Statements 3,285,934 N/A 3,081,794 I I
I I
3
-
2
2
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-11
BUILDING REPLACEMENT FUND DETAIL IFund-6861
Revenues
Grant Revenue 0 162,900 6,806 (156,094)0 0 0 0 0 0
Interest earnings (m)24,419 15,800 6,456 (9,344)4,200 3,200 3,800 5,100 6,400 7,800
Total Revenue 24,419 I 178,700 II 13,26211 (165,438)1 4,200 I 3,200 I 3,800 5,1001 6,400 I 7,800
Expenses
Professional Services 38,249 97,500 17,554 79,946 7,500 0 0 0 0 0
Building Improvements 167,849 234,400 279,440 (45,040)394,000 0 0 0 0 0
Total Expenses 206,098 I 331,900 II 296,99411 34,9061 401,500 I 01 01 On 01 0
T 1 T 1
BUILDING REPLACEMENT FUND NET BEFORE
(153,200)1 (283,732)11 (130,532)1 (397,300)1 3,200 ~3,800 II 5,100 I 6,400 1TRANSFERS(181,679)7,800
1 1 1 1 1
Transfers In T 1 1 1 1
From General fund 0 0 0 01 oT 01 01 0 0 0
Total Transfers In 01 011 011 01 01 011 011 OU 01 0
T 1 T 1 1 1
To CIPfund 0 0 0 01 01 145,0001 01 01 0 0
Total Transfers Out 01 011 011 01 01 145,000 II 011 011 01 0
BUILDING REPLACEMENT NET ASSET SUMMARY:
Beginning Net Assets 1,507,730 1,326,051 1,326,051 0 1,042,319 645,019 503,219 507,019 512,119 518,519
Plus:Revenues 24,419 178,700 13,262 (165,438)4,200 3,200 3,800 5,100 6,400 7,800
Less:Expenses (206,098) (331,900)(296,994)34,906 (401,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 0 (145,000)0 0 0 0
Ending Net Assets I 1,326,051 II 1,172,851 II 1,042,31911 (130,532>1 645,0191 503,21911 507,01911 512,119 H 518,5191 526,319
I 1 I
I 1 I
3
-
2
3
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-ll
EMPLOYEE BENEFITS FUND DETAIL
IFund-6851
Revenues
Interfund Charge for Services 1,615,134 2,126,672 2,126,672 0 1,825,467 2,190,900 2,354,300 2,495,600 2,563,000 2,635,300
Interest earnings (m)8,927 70 846 776 0 1,720 40 50 70 80
Total Revenue 1,624,061 I 2,126,74211 2,127,5181 776 1,825,467 2,192,620 I 2,354,340 II 2,495,650 II 2,563,070 I 2,635,380
Expenses
Retirement (PERS)-regular contribution 808,304 1,163,510 994,205 169,305 831,000 769,000 835,700 931,900 949,900 967,900
PERS Side-Fund Liability Pay Down 700,000 1,500,000 1,481,376 18,624 0 0 0 0 0 0
Defined Cant.Ret.Health Care Accounts (b)3,824 171,998 174,091 (2,093)76,900 80,200 82,600 85,100 87,800 90,800
Insurance -Employee Health (b)673,281 618,935 668,168 (49,233)636,800 1,069,000 1,150,700 1,185,200 1,223,100 1,264,700
FICNMedicare (b)(3,701)93,094 84,619 8,475 95,260 89,600 93,800 96,600 99,700 103,100
Performance Incentive Program (b)70,607 262,409 81,845 180,564 117,408 114,300 119,700 123,300 127,200 131,500
Education Reimbursement 573 2,250 792 1,458 2,400 800 800 800 800 800
Deferred Camp Match 0 0 0 0 0 15,000 15,000 15,000 15,000 15,000
Worker Compensation Insurance (b)65,576 77,200 63,817 13,383 81,100 53,000 56,000 57,700 59,500 61,500
Total Expenses 2,318,464 1 3,889,39611 3,548,91311 340,4831 1,840,8681 2,190,900 I 2,354,300 I 2,495,600 II 2,563,000 I 2,635,300
I I I 1
EMPLOYEE BENEFITS FUND NET BEFORE
(694,403)1 (1,762,654)11 (1,421,395)11 341,2591 (15,401)1 1,72011 40 II 50 II 701TRANSFERS 80
I I I 1
Fund Transfer In - from General Fund 0 1,594,125 I 1,575,501 T (18,624).-oT 0 0 0 0 0
Total Transfer In 01 1,594,12511 1,575,501 II (18,624)1 01 011 011 011 01 0
I T 1
Fund Transfer Out -to General Fund 0 0 01 01 01 340,000 0 0 0 0
Total Transfer Out 0 01 011 01 01 340,000 II 011 011 01 0
EMPLOYEE BENEFITS NET ASSET SUMMARY:
Beginning Net Assets 899,244 204,841 204,841 0 358,947 343,546 5,266 5,306 5,356 5,426
Plus:Revenues 1,624,061 2,126,742 2,127,518 776 1,825,467 2,192,620 2,354,340 2,495,650 2,563,070 2,635,380
Less:Expenses (2,318,464)(3,889,396)(3,548,913)340,483 (1,840,868)(2,190,900)(2,354,300)(2,495,600)(2,563,000)(2,635,300)
Plus:Transfers In 0 1,594,125 1,575,501 (18,624)0 0 0 0 0 0
Less:Transfers Out 0 0 0 0 0 (340,000)0 0 0 0
Ending Net Assets 204,841 1 36,31211 358,94711 322,6351 343,5461 5,26611 5,30611 5,35611 5,4261 5,506
I I I I
I 1 I I
3
-
2
4
ESTIMATE
FY10-11
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
STREET MAINT.FUND DETAIL (Fund-2021
Revenues
State gas tax 700,665 686,900 694,180 7,280 684,112 694,200 694,200 694,000 694,000 694,000
Highway users excise tax (formerly Proposition 42
revenue)1 I 363,197 1 391,8881 387,2781 (4,610)1 433,4381 435,600 1 435,600 I 436,000 I 436,000 I 436,000
Sidewalk repair 1 (a)I 105,100 1 4,100 1 7,960 1 3,8601 14,000 1 14,000 1 14,000 I 14,300 I 14,600 I 14,900
Miscellaneous revenues (a)24,214 5,300 16,100 10,800 5,400 14,000 14,000 14,300 14,600 14,900
Interest earnings I (rn)I 5,846 I 3,200 I 1,319 (1,881)1 2,0201 3,010 3,880 5,280 I 6,870 8,520 I
Total Street Maintenance Fund Revenue I.1,199,022jl 1,091,388J 1,106,a37II 15,4491 1,138,910 I 1,160,8101 1,161,680 1 1,163,8801 1,166,0701 1,168,3201
I
Expenditures
Street Maintenance -Landslide Road Maint I (b)I 282,420 I 556,000 1 554,768 I 1,2321 570,3001 516,400 I 526,400 I 542,200 I 559,600
Street Maintenance -Non-Pavement I (b)I 1,699,243 I 1,631,674 1 1,228,6Z0 I 403,0541 1,554,2741 1,602,279 1 1,584,279 I 1,631,800 I 1,684,000
Traffic signal maintenance
Total Street Maintenance Fund Expenditures
578,600
1,741,300
124,200
2,444,100
STREET MAINTENANCE FUND NET BEFORE
TRANSFERS
Street Maintenance Fund Transfers In
(885,933 430,911 1 {1,089,704)1 (1,159,869)11 (1,081,999)11 (1,126,520)1 (1,19-__J ,275,780
From General Fund
From Prop C Fund (Landslide Road Maint)
From 1972 Act
From 1911 Act
From Beautification fund
From Waste Reduction
Total Transfers In
455,025 22,000 22,000 0 0 0 0 100,000 150,000 190,000
0 477,000 556,088 79,088 570,300 516,400 526,400 497,000 508,000 519,000
180,000 200,000 200,000 0 204,000 200,000 200,000 195,000 190,000 200,000
76,800 84,000 72,824 (11,176)104,100 202,000 113,000 116,400 120,100 124,200
0 210,000 210,000 0 165,200 116,000 193,000 198,800 205,200 212,200
0 40,000 40,000 0 0 40,000 40,000 41,200 42,500 43,900
111,825]1 1,033,000 II 1,100,91211 67,9121 1,043;600 1 1,074,40011 1,072,400 II 1,148,400 II 1,215,800 II 1,289,300
Street Maintenance Fund Transfers Out
ToCIP Fund
Total Transfers Out
STREET MAINTENANCE FUND SUMMARY
01 01 0
0lr 011 0li
o
o
127,080
127,080
o
o
o
o
o
o
o
o
o
o
Beginning Fund Balance
Plus:Revenues
Less:Expenditures
Plus:Transfers In
Less:Transfers Out
Ending Fund Balance
Reserve (1 year of Landslide Road Maint)
Available Fund Balance
578,589 I 424,481 I 424,481 I 0 776,018 602,834 517,365 527,788 549,6461 567,816
1
1,199,022 1,091,388 1,108,837 15,449 1,138,970 1,160,810 1,161,680 1,163,880 1,166,0701 1,168,320
(2,064,955) (2,271,674)(1,856,212)415,462 (2,228,674)(2,320,679) (2,223,679)(2,290,400)(2,363,700)t (2,444,100)
I
711,825 1,033,000 1,100,912 67,912 1,043,600 1,074,400 1,072,400 1,148,400 1,215,8001 1,289,300
0 0 0 0 (127,080)0 0 0 01 0
I
424,481 II 277,19511
3
-
2
5
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~I ESTIMATE
FY10·11
1972 ACT LANDSCAPE &LIGHTING FUND DETAIL
Fund 2031
Revenues
Property assessments (e)257,138 257,559 262,417 4,858 258,687 258,000 258,000 264,450 271,061 277,838
Interest earnings (m)1,877 900 641 (259)240 180 160 70 20 70
Total Revenue 259,015 258,459 I 263,05811 4,5991 258,9271 258,180 II 258,160 II 264,520 II 271,0811 277,908
Expenditures
Operations &maintenance (b)67,661 69,100 70,973 (1,873)70,300 71,800 73,000 75,200 77,600 80,200
Total Expenditures 67,661 1 69,100 II 70,97311 (1,873)1 70,300 I '?1,8OOJ 73,000 I 75,200 II 77,600 I 80,200
1 1 1
1972 ACT FUND NET BEFORE TRANSFERS 191,3541 189,35911 192,08511 2,7261 188,6271 186,380 II 185,160 II 189,320 II 193,4811 197,708
I I 1 I
Transfers In 0 01 01 01 01 0 0 0 0 0
Total Transfers In I 011 011 011 01 01 01 01 011 01 0
Transfers Out
To Street Maintenance fund 180,000 200,000 200,000 0 204,000 200,000 200,000 195,000 190,000 200,000
Total Transfers Out 180,000 1 200,000 II 200,000 II 01 204,000 I 200,0001 200,000 I 195,000 II 190,000 1 200,000
1972 ACT LANDSCAPE &LIGHTING FUND
Beginning Fund Balance 47,305 58,659 58,659 0 50,744 35,371 21,751 6,911 1,231 4,712
Plus:Revenues 2511,015 258,459 263,058 4,599 258,927 258,180 258,160 264,520 271,081 277,908
Less:Expenditures (67,661)(69,100)(70,973)(1,873)(70,300)(71,800)(73,000)(75,200)(77,600)(80,200)
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out (180,000) (200,000)(200,000)0 (204,000)(200,000)(200,000) (195,000)(190,000)(200,000)
Ending Fund Balance 58,659 I 48,01811 50,74411 2,7261 35,371 I 21,75111 6,91111 1,231 II 4,7121 2,420
I I I I I I
I 1 1 I I I
3
-
2
6
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B ,....,.-
;::FY10-11
El PRADO LIGHTING FUND DETAil
IFund-209\
Revenues
Property assessments (a)1,827 1,870 1,887 17 1,910 1,900 1,900 1,950 2,000 2,050
Interest earnings (m)173 160 59 (101)10 70 110 160 210 270
Total Revenue I 2,00011 2,030 II 1,94611 (84)1 1,920 I 1,970 II 2,010 II 2,110 II 2,210 I 2,320
Expenditures
Light and Power (b)348 300 234 66 300 300 300 300 300 300
Maintenance Services (b)86 10,700 0 10,700 700 700 700 700 700 700
Total Expenditures I 43411 11,000 II 23411 10,7661 1,000 I 1,00011 1,000 II 1,000 U 1,000 I 1,000
1 1 1
El PRADO LIGHTING FUND NET BEFORE 1,566 I (8,970)11 1,71211 10,6821 920 I 97011 1,010 II 1,11011 1,210 I 1,320
1 1 1
Transfers In 0 0 0 01 01 0 01 0 0 0
Total Transfers In 01 011 011 01 01 011 011 011 01 0
1 I 1
Transfers Out 0 0 0 01 01 0 01 0 0 0
Total Transfers Out 01 011 011 01 01 011 011 011 01 0
El PRADO LIGHTING FUND SUMMARY:
Beginning Fund Balance 9,572 11,138 11,138 0 12,850 13,770 14,740 15,750 16,860 18,070
Plus:Revenues 2,000 2,030 1,946 (84)1,920 1,970 2,010 2,110 2,210 2,320
less:Expenditures (434)(11,000)(234)10,766 (1,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 11,138 I 2,16811 12,850 II 10,6821 13,770 I 14,74011 15,750 II 16,860 II 18,070 I 19,390
I I 1 1
I I 1 1
3
-
2
7
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-ll
CDSG FUND DETAIL IFund-3101
Revenues
Grant income 113,021 336,826 247,079 (89,747)244,994 201,673 171,865 171,865 171,865 171,865
Total Revenue 113,021 336,826 1 247,07911 (89,747>1 244,9941 201,67311 171,86511 171,8651 171,8651 171,865
Expenditures
Operations &maintenance 92,364 309,978 220,226 89,752 167,898 161,865 161,865 161,865 161,865 161,865
Capital outlay 0 0 0 0 121,096 39,808 10,000 10,000 10,000 10,000
Total Expenditures 1 92,36411 309,97811 220,22611 89,7521 288,9941 201,67311 171,86511 171,8651 171,8651 171,865
I I I I 1 I
CDBG FUND NET BEFORE TRANSFERS 20,657 1 26,64811 26,85311 51 (44,000)1 011 011 01 01 0
Transfers In
From General fund 0 0 0 0 44,000 0 0 0 0 0
Total Transfers Out 01 011 011 01 44,000 I 011 011 011 01 0
1 I I I 1 I 1
Transfers Out 1 I I I 1 I 1
To General fund (REACH)20,646 26,6481 26,847 I 11 01 01 01 01 0 0
Total Transfers Out I 20,64611 26,64811 26,84711 11 01 011 011 011 01 0
CDBG FUND SUMMARY:
Beginning Fund Balance (17)(6)(6)0 0 0 0 0 0 0
Plus:Revenues 113,021 336,826 247,079 (89,747)244,994 201,673 171,865 171,865 171,865 171,865
Less:Expenditures (92,364)(309,978) (220,226)89,752 (288,994)(201,673) (171,865) (171,865) (171,865)(171,865)
Plus:Transfers In 0 0 0 0 44,000 0 0 0 0 0
Less:Transfers Out (20,646)(26,848) (26,847)1 0 0 0 0 0 0
Ending Fund Balance 1 (6)11 (6)11 011 61 01 011 011 011 01 0
I I I 1
1 1 I 1
3
-
2
8
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~ESTIMATE
;::FY10-11
1911 ACT STREET LIGHTING FUND DETAIL (Fund-
2111
Revenues
Property assessments (a)492,705 483,100 492,606 9,506 492,800 440,000 440,000 451,000 462,300 473,900
Interest earnings (m)27,552 21,700 8,441 (13,259)7,800 7,600 10,000 12,200 13,900 14,900
Total Revenue 520,257 1 504,800 II 501,04711 (3,753)1 500,6001 447,600 I 450,000 1 463,2001 476,200 I 488,800
I 1 I
Expenditures I 1 I
Operations &maintenance (b)402,551 493,400 421,712 I 71,688 506,900 I 444,400 445,900 459,300 I 474,000 490,100
Tolal Expenditures 402,551 I 493,400 II 421,71211 71,6881 506,900 1 444,400 II 445,900 II 459,3001 474,000 I 490,100
I
1911 ACT FUND NET BEFORE TRANSFERS I 117,70611 11,40011 79,33511 67,9351 (6,300)1 3,200 I 4,100 I 3,9001 2,2001 (1,300)
I I I I
Transfers In 0 01 0 01 01 0 0 0 0 0
Total Transfers In 01 011 011 01 01 011 011 01 01 0
1 1
Transfers Out 1 1
To Street Maintenance Fund 76,800 84,0001 72,824 11,176 104,1001 202,000 113,000 116,400 120,100 124,200
Tolal Transfers Out 76,800 I 84,000 II 72,82411 11,1761 104,1001 202,000 II 113,000 II 116,4001 120,100 I 124,200
1911 ACT STREET LIGHTING FUND SUMMARY
Beginning Fund Balance 1,591,701 1,632,607 1,632,607 0 1,639,118 1,528,718 1,329,918 1,221,018 1,108,518 990,618
Plus:Revenues 520,257 504,800 501,047 (3,753)500,600 447,600 450,000 463,200 476,200 488,800
Less:Expenditures (402,551) (493,400) (421,712)71,688 (506,900) (444,400) (445,900) (459,300)(474,000)(490,100)
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out (76,800) (84,000) (72,824)11,176 (104,100) (202,000) (113,000)(116,400)(120,100)(124,200)
Ending Fund Balance 1,632,607 I 1,560,00711 1,639,11811 79,111 1 1,528,7181 1,329,91811 1,221,01811 1,108,518 H 990,6181 865,118
1 1 1 I
1 1 1 I
3
-
2
9
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!_..nMA~~FY10-11
WASTE REDUCTION FUND DETAIL (Fund-213!
Revenues
Collection Fees (AB939)68,454 25,000 70,418 45,418 0 0 0 0 0 0
Allocation of refuse hauler collection fees (c)0 36,150 0 (36,150)155,000 155,705 158,800 161,700 164,900 168,500
State income 66,092 65,000 91,119 26,119 117,500 47,500 47,500 47,500 47,500 47,500
Mise revenue 0 158,500 152,500 (6,000)0 0 0 0 0 0
Interest eamings (m)4,582 1,740 1,003 (737)620 970 1,230 1,340 1,240 910
Total Revenue 139,128 I 286,390 II 315,040 II 28,650 I 273,120 I 204,17511 207,530 II 210,540 U 213,640 I 216,910
Expenditures
Personnel services (b)64,707 54,958 31,273 23,685 55,889 68,800 71,500 73,600 76,000 78,600
Operations &maintenance (b)219,866 229,750 187,377 42,373 130,550 113,850 114,050 117,500 121,300 125,400
Total Expenditures I 284,57311 284,70811 218,650 II 66,0581 186,4391 182,650 II 185,550 II 191,100 II 197,300 I 204,000
I I I 1 1
WASTE REDUCTION FUND NET BEFORE I (145,445)11 1,68211 96,390 II 94,7081 86,681 I 21,52511 21,980 II 19,440 II 16,3401 12,910
1 I 1 1 I I I
Transfers In 01 0 01 01 01 0 0 0 0 0
Total Transfers In I 011 011 011 01 01 011 011 011 01 0
Transfers Out
To General Fund -Park Maintenance 0 12,000 0 12,000 12,000 12,000 12,000 12,400 12,800 13,200
To CIP Fund -Street Improvements 0 0 0 0 111,000 0 0 0 0 0
To Street Maintenance Fund 0 40,000 40,000 0 0 40,000 40,000 41,200 42,500 43,900
Total Transfers Out 01 52,000 II 40,000 II 12,0001 123,0001 52,000 II 52,000 II 53,600 II 55,300 I 57,100
WASTE REDUCTION FUND SUMMARY
Beginning Fund Balance 319,550 174,105 174,105 0 230,495 194,176 163,701 133,681 99,521 60,561
Plus:Revenues 139,128 286,390 315,040 28,650 273,120 204,175 207,530 210,540 213,640 216,910
Less:Expenditures (284,573)(284,708)(218,650)66,058 (186,439) (182,650)(185,550) (191,100)(197,300)(204,000)
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out 0 (52,000) (40,000)12,000 (123,000)(52,000) (52,000)(53,600) (55,300) (57,100)
Ending Fund Balance I 174,10511 123,78711 230,49511 106,7081 194,1761 163,701 II 133,681 II 99,52111 60,561 I 16,371
I 1 1 I I I
I I I I I
3
-
3
0
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
AIR QUALITY MANAGEMENT FUND DETAIL IFund-
ll!
Revenues
AB 2766 fees 50,124 99,800 98,462 I (1,338)1 49,8001 50,000 50,0001 50,000 I 50,000 50,000
Interest earnings (m)455 800 1701 (630)1 2701 260 760 I 9201 1,790 2,930
Total Revenue I 50,579 II 100,600 II 98,632 II (1,968)1 50,070 I 50,260 II 50,760 II 50,920 n 51,790 II 52,930
1 1 I 1
Expenditures 1 1 I 1
Operations &maintenance 50,000 100,000 100,0001 0 50,0001 0 01 01 0 0
Total Expenditures 50.000 I 100.000 II 100.000 II 01 50.000 1 011 011 011 01 0
AQMD FUND NET BEFORE TRANSFERS I 0---57911 600 II (1,368)11 (1,968)1 701 5(),26()II 50,760 II 50,920 n 51~19OJ1 52,930
oT oT oT oTTransfersOuttoEquipmentFund0 0 60,000 0 0 0
TotalTransfers Out 01 011 011 01 01 01 60,000 I On 01 0
AIR QUALITY MANAGEMENT FUND DETAIL
101,7381 92,4981 143,4181BeginningFundBalance52,197 52,776 52,776 0 51,408 51,478 195,208
Plus:Revenues 50,579 100,600 98,632 (1,968)50,Q70 50,260 50,7601 50,9201 51,7901 52,930
Less:Expenditures (50,000)(100,000) (100,000)0 (50,000)0 0 0 0 0
IPlus:Transfers In 0 0 0 0 0 0 0 0 0 0
I
ILess:Transfers Out 0 0 0 0 0 0 (60,000)0 0 0
Ending Fund Balance I 52,77611 53,37611 51,40811 (1,968)1 51,4781 101,7381 92,498 1 143,41811 195,20811 248,138
3
-
3
1
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-11
PROPOSITION C ISTREETITRANSITl FUND DETAIL
Fund-215\
Revenues
Proposition e -1/2 cent sales tax revenue (j)557,794 457,384 453,443 (3,941)478,485 488,400 489,000 497,800 507,800 519,000
Other revenues 0 0 0 0 18,000 0 0 0 0 0
Interest earnings (m)36,944 24,900 14,083 (10,817)6,520 6,830 280 0 10 10
Total Revenue 594,738 I 482,28411 467,52611 (14,758)1 503,0051 495,230 II 489,280 II 497,800 II 507,810 I 519,010
1 T r T
Expenditures 1 1 1 1
Personnel services 6,095 01 01 01 01 0 0 0 0 0
Total Expenditures I 6,09511 011 011 01 01 01 01 011 01 0
1
PROPOSITION e FUND NET BEFORE TRANSFERS 588,843 I 482,28411 467,5261 (14,758)503,005 495,230 489,280 I 497,800 II 507,810 I 519,010
Transfers In 0 0 0 0 0 0 0 01 0 0
Total Transfers In I 011 011 011 01 01 011 011 011 01 0
Transfers Out
To elP fund 0 2,486,771 780,880 1,705,891 262,993 1,306,927 0 0 0 0
To Street Maintenance fund -Landslide Road
Maintenance 0 477,000 556,088 (79,088)570,300 516,400 526,400 497,000 508,000 519,000
Total Transfers Out 01 2,963,771 II 1,336,96811 1,626,8031 833,2931 1,823,32711 526,400 II 497,000 II 508,000 \519,000
PROPOSITION e (STREETITRANSID FUND
SUMMARY:
Beginning Fund Balance 1,976,356 2,564,999 2,564,999 0 1,695,557 1,365,269 37,172 52 852 662
Plus:Revenues 594,738 482,284 467,526 (14,758)503,005 495,230 489,280 497,800 507,810 519,010
Less:Expenditures (6,095)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 (2,963,771) (1,336,968)1,626,803 (833,293)(1,823,327)(526,400)(497,000)(508,000)(519,000)
Ending Fund Balance 2,564,999 I 83,51211 1,695,557\\1,612,0451 1,365,2691 37,1721 52 I 85211 6621 672
I 1 I
1 1 I
3
-
3
2
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~ESTIMATE
;::FY10-11
PROPOSITION A (TRANSIT!FUND DETAIL (Fund-
21lil
Revenues
Proposition A -1/2 cent sales tax revenue (j)621,569 546,923 546,618 (305)576,854 586,200 586,200 596,800 608,700 622,100
Other revenues 0 0 0 0 65,000 0 0 0 0 0
Interest earnings (m)2,351 1,000 459 (541)360 180 210 190 260 220
Total Revenue 623,920 1 547,92311 547,07711 (846)1 842,2141 586,380 II 586,410 II 596,990 II 608,9601 622,320
Expenditures
Personnel services 6,095 0 0 0 0 0 0 0 0 0
Operations (PV Transit)(b)524,229 670,900 535,949 134,951 565,000 578,100 578,200 595,500 614,600 635,500
Operations (MAX)104,723 0 105,758 (105,758)124,500 0 0 0 0 0
Capital Outlay (Bus Shelter Improvements)0 0 0 0 16,500 17,000 17,000 0 0 0
Total Expenditures I 635,04711 670,900 II 841,70711 29,1931 706,000 I 595,100 II 595,200 II 595,500 U 614,600 I 635,500
I 1 1 I 1 1
PROPOSITION A FUND NET BEFORE TRANSFERS (11,127>1 (122,977)11 (94,630~1 28,3471 (63,786)1 (8,720)11 (8,790)11 1,490 II (5,640)1 (13,180)
I 1 1 I 1 1
Transfers In 0 0 0 01 01 01 01 01 0 0
Total Transfers In 01 011 011 01 01 011 011 011 01 0
Transfers Out
To General Fund (b)2,700 2,800 2,800 0 0 0 0 0 0 0
To CIP Fund 12,450 67,000 0 67,000 0 0 0 0 0 0
Total Transfers Out 15,150 1 69,800 II 2,80011 67,000 I 01 011 011 011 01 0
PROPOSITION A ITRANSID FUND SUMMARY:
Beginning Fund Balance 223,971 197,694 197,694 0 100,284 36,478 27,758 18,968 20,458 14,818
Plus:Revenues 623,920 547,923 547,077 (846)842,214 586,380 586,410 596,990 608,960 622,320
Less:Expenditures (635,047) (670,900)(841,707)29,193 (706,000)(595,100)(595,200) (595,500)(614,600)(635,500)
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out (15,150) (69,800)(2,800)67,000 0 0 0 0 0 0
Ending Fund Balance 197,694 I 4,91711 100,26411 95,3471 36,4781 27,7581 18,968 I 20,45811 14,8181 1,638
1 1 1
1 I I
3
-
3
3
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
.....J!ESTIMATE
FY10·11
PUBLIC SAFETY GRANTS
IFund·2171
Revenues
Grant Income -Slate 100,000 100,000 100,000 0 100,000 0 0 0 0 0
Interest earnings (m)1,625 0 378 378 0 170 120 160 200 240
Total Revenue I 101,62511 100,000 II 100,37811 3781 100,000 I 170 II 120 II 160 n 200 I 240
Expenditures
Equipment purchases 32,285 33,635 0 33,635 0 19,600 0 0 0 0
Total Expenditures 32,285 I 33,63511 011 33,6351 01 19,600 II 011 011 01 0
I I I I
PUBLIC SAFETY GRANTS FUND NET BEFORE
69,340 I 66,36511 100,37811 34,0131 100,000 I (19.430)11 120 II 160 II 2001TRANSFERS 240
1 1 I I
Transfers In 0 01 01 01 01 0 0 0 0 0
Total Transfers In 01 011 011 01 01 011 011 011 01 0
1 1
Transfers Out I I
To General fund 100,000 100,0001 100,000 I 0 100,000 0 0 0 0 0
Tolal Transfers Out I 100,000 II 100,000 II 100,000 II 01 100,0001 011 011 011 01 0
PUBLIC SAFETY GRANTS FUND SUMMARY:
Beginning Fund Balance 65,200 34,540 34,540 0 34,918 34,918 15,488 15,608 15,768 15,968
Plus:Revenues 101,625 100,000 100,378 378 100,000 170 120 160 200 240
Less:Expenditures (32,285)(33,635)0 33,635 0 (19,600)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)0 0 0 0 0
Ending Fund Balance I 34,540 II 90511 34,91811 34,0131 34,9181 15,48811 15,60811 15,76811 15,9681 16,208
I I I I I
I I I I I
3
-
3
4
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-11
MEASURE R FUND DETAIL
IFund-2201
Revenues
Measure R 01 0 221,267 272,826 51,559 358,865 364,600 364,600 371,200 378,600 386,900
Other revenues 0 0 0 0 6,000 0 0 0 0 0
Interest earnings (m)0 0 390 390 0 0 1,500 1,670 6,740 13,870
Total Revenue 01 221,26711 273,21611 51,9491 364,8651 364,600 II 366,100 II 372,870 II 385,340 I 400,770
1
Expenditures 1
Equipment purchases 0 0 0 0 01 0 0 0 0 0
Total Expenditures 01 011 011 01 01 01 01 011 01 0
1
MEASURE R FUND NET BEFORE TRANSFERS 01 221,26711 273,21611 51,9491 364,8651 364,600 g 366,100 II 372,870 II 385,340 I 400,770
I
Transfers In 0 01 0 0 0 0 0 0 0 0
Total Transfers In 01 011 01 0 0 0 01 011 01 0
Transfers Out
To CIP Fund 0 0 0 0 638,080 364,000 200,000 0 0 0
Total Transfers Out 01 011 011 01 638,080 I 364,000 II 200,000 II 011 01 0
MEASURE R FUND SUMMARY:
Beginning Fund Balance 0 0 0 0 273,216 1 601 166,701 539,571 924,911
Plus:Revenues 0 221,267 273,216 51,949 364,865 364,600 366,100 372,870 385,340 400,770
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 (638,080)(364,000)(200,000)0 0 0
Ending Fund Balance 01 221,26711 273,21611 51,9491 11 60111 166,701 II 539,571 II 924,9111 1,325,681
I I I I
1 1 I
3
-
3
5
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
<sn..,.
~~~1
HABITAT RESTORATION FUND DETAIL INCCPI
IFund·2221
Revenues
Grants 6,528 0 0 0 0 0 0 0 0 0
Interest earnings (m)2,585 1,800 5,804 4,004 1,010 1,300 1,660 1,830 1,990 2,390
Total Revenue 9,113 I 1,80011 5,80411 4,0041 1,010 I 1,300 II 1,660 II 1,830 II 1,990 I 2,390
Expenditures
Preserve Management (b)109,199 108,800 108,800 0 109,900 112,000 114,000 117,400 121,200 125,300
Oceanfront Estates Habitat Maintenance and
Monitoring (b)15,488 15,991 15,991 0 16,511 17,000 17,000 17,500 18,100 18,700
Habitat Restoration Projects 7,503 70,000 0 70,000 0 0 0 0 0 0
Total Expenditures 132,190 I 194,79111 124,79111 70,0001 126,411 I 129,000 II 131,000 II 134,900 II 139,300 I 144,000
1 1 1 1 1
HABITAT RESTORATION FUND NET BEFORE
(123,0771 (192,991)11 (118,987)11 74,0041 (125,401)1 (127,700)11 (129,340)~(133,070)~(137,310)1TRANSFERS (141,610)
1 1 1 I 1
Transfers In I I I 1 1
From General fund 115,000 169,000 169,000 01 109,900 1 90,0001 90,000 I 110,0001 137,000 152,000
Total Transfers In 115,000 I 169,000 II 169,00011 01 109,9001 90,00011 90,000 II 110,000 II 137,000 I 152,000
1 I I I 1
Transfers Out 0 0 0 01 01 01 01 01
0 0
Total Transfers Out 01 011 011 01 01 011 011 011 01 0
HABITAT RESTORATION FUND SUMMARY:
Beginning Fund Balance 233,257 225,180 225,180 0 275,193 259,692 221,992 182,652 159,582 159,272
Plus:Revenues 9,113 1,800 5,804 4,004 1,010 1,300 1,660 1,830 1,990 2,390
Less:Expenditures (132,190) (194,791) (124,791)70,000 (126,411)(129,000) (131,000) (134,900)(139,300) (144,000)
Plus:Transfers In 115,000 169,000 169,000 0 109,900 90,000 90,000 110,000 137,000 152,000
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Ending Fund Balance 225,180 I 201,18911 275,19311 74,0041 259,6921 221,99211 182,65211 159,58211 159,2721 169,662
NCCP Future Maintenance Reserve 64,414 74,786 85,422 96,376 107,706 119,471
NCCP Emergency Project Reserve 50,000 50,000 50,000 SO,OOO 50,000 50,000
Available Fund Balance 145,278 97,206 47,230 13,206 1,566 191
3
-
3
6
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B_!ESTIMATE
FY10·11
SUBREGION 1 -MAINTENANCE FUND DETAIL tFun
2231
Revenues
Interest earnings (m)12,331 11,300 3,795 (7,505)3,800 3,800 5,600 7,500 9,400 11,300
Total Revenue I 12,33111 11,300 n 3,79511 (7,505)1 3,800 I 3,800 I 5,600 I 7,500 II 9,400 I 11,300
Expenditures
OperaUons &maintenance (b)50,755 67,000 52,211 14,789 89,000 70,000 70,000 72,100 74,400 76,900
Total Expenditures I 50,75511 67,000 II 52,21111 14,7891 89,000 I 70,000 II 70,000 II 72,100 II 74,400 I 76,900
I I I
SUBREGION 1 -MAINTENANCE FUND NET BEFORE
(38,424)1 (55,700)11 (48,416)11 7,2841 (85,200)1 (66,200)11 (84,400)11 (84,600)1 (65,000)1TRANSFERS (65,600)
I I
Transfers In -from General Fund 55,000 55,000 1 55,0001 01 70,000 I 60,000 65,000 65,000 65,000 65,000
Total Transfers In 55,000 I 55,000 II 55,000 II 01 70,000 I 60,000 I 65,000 I 65,000 n 65,000 I 65,000
1 1 I I
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
SUBREGION 1 -MAINTENANCE FUND SUMMARY:
Beginning Fund Balance 750,760 767,336 767,336 0 773,920 758,720 752,520 753,120 753,520 753,520
Plus:Revenues 12,331 11,300 3,795 (7,505)3,800 3,800 5,600 7,500 9,400 11,300
Less:Expenditures (50,755)(67,000)(52,211)14,789 (89,000)(70,000) (70,000)(72,100)(74,400)(76,900)
Plus:Transfers In 55,000 55,000 55,000 0 70,000 60,000 65,000 65,000 65,000 65,000
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Available Fund Balance 767,336 I 766,63611 773,920 II 7,2841 758,720 I 752,520 II 753,120 II 753,520 II 753,520 I 752,920
I I I I I
I I I I I
I I I I
3
-
3
7
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-ll
MEASURE A -CAPITAL IFund-339\&MAINTENANC
Fund-224)FUNDS DETAIL
Revenues
Grant income 98,945 161,913 49,373 (112,540)151,000 100,000 100,000 100,000 100,000 100,000
Interest earnings (m)1,478 0 233 233 170 170 260 350 440 530
Total Revenue 100,423 I 161,91311 49,60611 (112,307)1 151,170 I 100,170 II 100,260 II 100,350 0 100,440 I 100,530
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 01 011 01 0 0 0 01 00 01 0
I
MEASURE A -CAPITAL &MAINTENANCE FUND NET
161,9131 49,6061 100,260 I 100,350 I 100,440 IBEFORETRANSFERS100,423 (112,307)151,170 100,170 100,530
Transfers Out
To General fund (Park Maintenance)54,200 151,000 38,460 112,540 151,000 100,000 100,000 100,000 100,000 100,000
To CIP fund 21,700 10,913 10,913 0 0 0 0 0 0 0
Talai Transfers Out 75,900 I 161,9130 49,37311 112,540 I 151,000'100,000 II 100,000 II 100,0000 100,000 1 100,000
MEASURE A (PARKS)-CAPITAL &MAINTENANCE
FUNDS SUMMARY:
Beginning Fund Balance 9,405 33,928 33,928 0 34,161 34,331 34,501 34,761 35,111 35,551
Plus:Revenues 109,423 161,913 49,606 (112,307)151,170 100,170 100,260 100,350 100,440 100,530
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 (75,900)(161,913)(49,373)112,540 (151,000)(100,000)(100,000) (100,000)(100,000)(100,000)
Ending Fund Balance 33,928 I 33,92811 34,161 0 2331 34,331 I 34,5011 34,761 I 35,1110 35,5511 36,081
I I I I
I I I I
3
-
3
8
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-ll
ABALONE COVE SEWER DISTRICT FUND DETAIL
IIFund-2251
Revenues
Property Assessments (e)52,150 45,650 46,247 597 46,560 46,600 46,600 47,770 48,960 50,180
Interest eamings (m)2,021 570 1,584 1,014 280 260 350 400 400 360
Total Revenue 54,171 I 46,220 II 47,83111 1,611 I 46,840 I 46,860 II 46,950 II 48,170 II 49,360 I 50,540
Expenditures
Maintenance Services (b)37,809 49,500 80,842 (31,342)16,706 17,300 17,700 18,200 18,800 19,400
Personnel &Professional services (b)12,546 16,538 16,941 (403)68,500 46,600 46,700 48,100 49,600 51,300
Capital Outlay 38,635 32,000 0 32,000 0 0 0 0 0 0
Total Expenditures 88,990 I 98,03811 97,78311 2551 85,2061 63,9001 64,400 1 66,300 II 68,400 I 70,700
T I I
ABALONE COVE SEWER DISTRICT FUND NET
(34,819)1 (51,818)11 (49,952)11 1,8661 (38,366)1 (17,040)11 (17,450)11 (18,130)1 (19,040)1BEFORETRANSFERS (20,160)
I I 1
Fund Transfer In T T I
From General Fund 10,700 10,700 14,700 4,000 I 32,700 I 10,700 10,700 10,700 1 10,700 10,700
Total Transfer In 10,700 I 10,700 II 14,700 II 4,000 I 32,700 I 10,700 II 10,700 II 10,700 II 10,7001 10,700
I I I
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
ABALONE COVE SEWER DISTRICT FUND
Beginning Fund Balance 117,713 93,594 93,594 0 58,342 52,676 46,336 39,586 32,156 23,816
Plus:Revenues 54,171 46,220 47,831 1,611 46,840 46,860 46,950 48,170 49,360 50,540
Less:Expenditures (88,990) (98,038)(97,783)255 (85,206)(63,900) (64,400) (66,300) (68,400) (70,700)
Plus:Transfer In 10,700 10,700 14,700 4,000 32,700 10,700 10,700 10,700 10,700 10,700
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Ending Fund Balance I 93,59411 52,47611 58,34211 5,8661 52,6761 46,3361 39,586 I 32,15611 23,8161 14,356
1 1 1 I I
1 1 1 T I
3
-
3
9
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~I ESTIMATE
FY10-11
DR.ALLEN AND CHARLOTTE GINSBURG
CULTURAL ARTS BUILDING FUND DETAIL (Fund-
~
Revenues
Restricted Donations 0 0 0 0 0 0 0 0 0 0
Interest earnings (m)8,458 7,600 1,653 (5,947)1,040 920 1,380 1,850 2,340 2,850
Total Revenue 8,458 7,6001 1,65311 (5,947)1 1,040 I 9201 1,3801 1,850.2,340 1 2,850
1 1 I
Expenditures 1 1 1
Capital Outlay -Park &Recreation 0 305,439 300,0001 5,439 1 20,000 I 0 0 0 0 0
Total Expenditures 01 305,43911 300,00011 5,4391 20,000 I 01 01 011 01 0
1 1 1 I
DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL
8,4581 (297,839)11 {298,347~(508)1 (18,960)1 92011 1,380 II 1,8501ARTSBUILDINGFUNDNETBEFORETRANSFERS 2,340 2,850
Fund Transfer In 0 0 0 0 0 0 0 0 0 0
Total Transfer In 01 011 01 0 0 0 01 011 01 0
1
Fund Transfer Out 0 0 0 0 0 0 0 01 0 0
Total Transfer Out 01 011 011 01 01 011 011 011 01 0
DR.ALLEN AND CHARLOTTE GINSBURG CULTURAL
ARTS BUILDING FUND SUMMARY:
Beginning Fund Balance 492,045 500,503 500.503 0 202,156 183,196 184,116 185,496 187,346 189,686
Plus:Revenues 8,458 7,600 1,653 (5,947)1,040 920 1,380 1,850 2,340 2,850
Less:Expenditures 0 (305,439)(300,000)5,439 (20,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 500,503 I 202,66411 202,15611 (508)1 183,1961 184,11611 185,49611 187,3460 189,6861 192,536
I I 1 I
1 I 1 1
3
-
4
0
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~5'~~;:;FY10·ll
RECREATION IMPROVEMENTS DONATIONS FUND
DETAIL -IFund 228\
Revenues
Restricted Donations 0 300,000 399,820 99,820 0 0 0 0 0 0
Grant Revenue 0 300,000 0 (300,000)0 0 0 0 0 0
Interest earnings (m)34 0 1,935 1,935 10 2,020 3,040 4,090 5,160 6,270
Total Revenue 34 600,000 I 401,75511 (198,245)1 10 I 2,020 II 3,040 II 4,090 II 5,160 I 6,270
1
Expenditures 1
Capital Outlay 0 0 0 0 oT 0 0 0 0 0
Total Expenditures 01 011 011 01 01 01 01 011 01 0
T
RECREATION IMPROVEMENTS DONATIONS FUND
341 600,000 II 401,7551 (198,245)1 101 2,0201 3,040 I 4,090 INETBEFORETRANSFERS 5,160 6,270
1 T 1 1
Fund Transfer In 0 01 01 01 01 0 0 0 0 0
Total Transfer In 01 011 011 01 01 011 011 011 01 0
1 1 1 1
Transfer To CIP 0 600,0001 01 600,000 I 01 0 0 0 0 0
Total Transfer Out 01 600,000 II 011 600,0001 01 011 011 011 01 0
RECREATION IMPROVEMENTS DONATIONS
BUILDING FUND SUMMARY:
Beginning Fund Balance 2,048 2,082 2,082 0 403,837 403,847 405,867 408,907 412,997 418,157
Plus:Revenues 34 600,000 401,755 (198,245)10 2,020 3,040 4,090 5,160 6,270
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 (600,000)0 600,000 0 0 0 0 0 0
Ending Fund Balance 2,082 I 2,08211 403,83711 401,7551 403,8471 405,867\1 408,90711 412,99711 418,1571 424,427
I 1 I
I 1 1
3
-
4
1
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-11
QUIMBY FUND DETAIL IFund-3341
Revenues
Developer fees 0 1,300,000 3,898 (1,296,102)0 0 0 0 0 0
Interest earnings (m)416 0 137 137 130 150 0 0 10 10
Total Revenue 4161 1,300,000 II 4,03511 (1,295,965)1 130 I 150 II 011 011 101 10
I
Expenditures 1
Improvements 0 0 0 01 0 29,000 0 0 0 0
Total Expenditures 01 011 011 01 01 ,2if.OOO)01 011 01 0
1 1
QUIMBY FUND NET BEFORE TRANSFERS 4161 1,300,000 II 4,03511 (1,295,965)1 130 I (28,850)11 011 011 10 I 10
1 1
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
I 1 1
Transfers Out 0 0 0 01 01 0 0 01 0 0
Total Transfers Out 01 011 011 01 01 011 011 011 01 0
QUIMBY FUND SUMMARY:
Beginning Fund Balance 24,754 25,170 25,170 0 29,205 29,335 485 485 485 495
Plus:Revenues 416 1,300,000 4,035 (1,295,965)130 150 0 0 10 10
Less:Expenditures 0 0 0 0 0 (29,000)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 25,170 I 1,325,170 II 29,20511 (1,295,965)1 29,3351 48511 48511 48511 4951 505
I 1 1 I
1 1 1 I
3
-
4
2
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-ll
AFFORDABLE HOUSING IN -LIEU FUND NON-RDA
DETAIL IFund-337\
Revenues
Developer fees 0 931,910 932,910 1,000 0 0 0 0 0 0
Proceeds of Affordable Housing Unit 0 0 0 0 0 330,000 0 0 0 0
Interest earnings (m)14,534 16,600 5,681 (10,919)40 10 2,480 3,330 4,200 5,100
Total Revenue 14,534 I 948,510 II 938,591 11 (9,919)1 40 I 330,010 II 2,480 II 3,330 II 4,200 I 5,100
Expenditures
Capital Outlay 328,916 1,766,368 0 (1,766,368)0 0 0 0 0 0
Improvements 2,516 12,500 3,531 8,969 5,000 2,000 0 0 0 0
Total Expenditures 331,432 I 1,778,86811 3,53111 (1,757,399)11 5,000 I 2,000 II 011 011 01 0
1 I
AFFORDABLE HOUSING IN-LIEU FUND NET
(316,898)1 (830,358)11 935,060 II (1,767,318>1 (4,960)1 328,010 II 2,480 II 3,330 I 4,2001BEFORETRANSFERS 5,100
T 1
Transfers In 0 0 0 01 01 0 0 0 0 0
Total Transfers In I 011 011 011 01 01 011 011 011 01 0
1
Transfers Out 0 01 0 0 0 0 0 0 0 0
Total Transfers Out I 011 011 01 0 0 0 01 011 01 0
AFFORDABLE HOUSING IN -LIEU FUND SUMMARY
INON-RDA\
Beginning Fund Balance 1,155,231 838,333 838,333 0 7,025 2,065 330,075 332,555 335,885 340,085
Plus:Revenues 14,534 948,510 938,591 (9,919)40 330,010 2,480 3,330 4,200 5,100
Less:Expenditures (331,432)(1,778,868)(3,531)1,775,337 (5,000)(2,000)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 838,333 I 7,97511 1,773,39311 1,765,4181 2,0651 330,07511 332,55511 335,88511 340,0851 345,185
AM CAL Net Long-Term Loan Receivable (1,766,368)T 1 I 1 I
Net Spendable Fund Balance 7,025 I 1 1 I
I 1 1 I
3
-
4
3
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
ESTIMATE
FY10·11
ENVIRONMENTAL EXCISE TAX IEED FUND DETAIL
Fund·338\
Revenues
Developer fees 59.111 97.000 79.624 (17.376)38.600 0 0 0 0 0
Interest earnings (m)14.237 10,100 4,386 (5,714)200 410 240 320 400 490
Total Revenue 73,348 I 107,100 I 84,010 I (23,090)1 38,800 I 41011 240 II 320 II 400 I 490
1 1
Expenditures 1
Improvements 58.278 51.325 52.752 (1,427)554.675 51,000 0 01 0 0
Total Expenditures 58,278 I 51,32511 52.7521 (1,427)554,675 51,000 I 011 011 01 0
EET FUND NET BEFORE TRANSFERS 15.070 I 55,77511 31,25811 (24,517)1 (515,875)1 (50,590)11 240 II 320 II 400 I 490
T
Transfers Out I I
To CIP fund 0 332,600 186,300 146.300 I 86,300 0 01 0 0 0
Total Transfers Out 01 332,600 II 186,300 II 146.3001 86,3001 011 011 011 01 0
ENVIRONMENTAL EXCISE TAX IEED FUND
SUMMARY
Beginning Fund Balance 824,223 839,293 839,293 0 664,251 82,076 31,486 31.726 32,046 32,446
Plus:Revenues 73,348 107,100 84,010 (23,090)38,800 410 240 320 400 490
Less:Expenditures (58.278)(51.325)(52,752)(1,427)(554.675)(51,000)0 0 0 0
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out 0 (332,600) (186,300)146.300 (86,300)0 0 0 0 0
Ending Fund Balance 839.293 I 562,46811 684,2511 121.783 82.076 31,4861 31.72611 32,D4611 32.4461 32,936
1
I
3
-
4
4
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~I ESTIMATE
FY10·11
BIKEWAYS (TDA ARTICLE 3\FUND DETAIL (Fund-
340\
Revenues
Grant Income 24,630 25,000 18,540 (6,460)17,223 25,000 25,000 25,000 25,000 25,000
Other revenues 0 0 0 0 9,750 0 0 0 0 0
Interest earnings (m)174 0 48 48 0 0 0 0 0 0
Total Revenue 24,804 I 25,000 II 18,5881 (6,412)26,973 25,000 I 25,000 II 25,000 D 25,000 I 25,000
1
Expenditures 1
Operations &maintenance 0 01 0 0 0 0 0 0 0 0
Total Expenditures 01 011 011 01 01 01 01 00 01 0
1 1
BIKEWAYS FUND NET BEFORE TRANSFERS 24,804 25,000 I 18,58811 (6,412)1 26,9731 25,000 I 25,000 I 25,0000 25,000 I 25,000
1
Transfers Out I
To CIP fund 30,002 25,000 18,588 6,4121 26,973 25,000 25,000 25,000 25,000 25,000
Total Transfers Out 30,002 I 25,000 II 18,58811 6,4121 26,9731 25,000 II 25,000 II 25,000 II 25,000 I 25,000
BIKEWAYS FUND SUMMARY:
Beginning Fund Balance 5,198 0 0 0 0 0 0 0 0 0
Plus:Revenues 24,804 25,000 18,588 (6,412)26,973 25,000 25,000 25,000 25,000 25,000
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 (30,002)(25,000)(18,588)6,412 (26,973)(25,000)(25,000)(25,000)(25,000)(25,000)
Ending Fund Balance I 011 011 011 01 01 011 011 011 01 0
1 1 I 1
1 1 1 I 1
3
-
4
5
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
FY10-11
WATER QUALITY &FLOOD PROTECTION (Fund-
5011
Revenues
Donations 89 0 180 180 0 0 0 0 0 0
Grants 326,651 0 0 0 0 0 0 0 0 0
Storm Drain User Fee (e)1,251,733 1,239,197 1,263,572 24,375 1,251,589 1,277,000 1,303,000 1,326,454 1,352,983 1,382,749
Interest earnings (m)104,512 700 13,995 13,295 2,100 2,800 3,100 4,300 7,100 10,900
Total Revenue 1,682,985 I 1,239,89711 1,277,74711 37,8501 1,253,6891 1,279,800 II 1,306,100 II 1,330,75411 1,360,0831 1,393,649
Expenses (see Exhibit D)
Administration 242,074 183,907 140,242 43,665 146,314 148,017 153,518 157,080 161,792 166,646
Maintenance 216,890 120,214 111,253 8,961 237,687 194,817 222,162 229,727 237,518 245,544
Improvements &Engineering 6,855,665 7,011,484 309,995 6,701,489 3,130,617 1,087,055 912,642 805,881 805,278 370,836
Total Expenses 7,314,629 I 7,315,60511 561,490 II 6,754,1151 3,514,6181 1,429,8891 1,288,322 I 1,192,688 H 1,204,5881 783,026
1 I I
WQFP FUND NET BEFORE TRANSFERS (5,631,644)I (6,075,708)11 716,25711 6,791,965 1 (2,260,929)1 (150,089)11 17,77811 138,06611 155,4951 610,623
1 I I
Fund Transfer In 0 01 0 01 01 0 0 0 0 0
Total Transfer In 01 011 011 01 01 011 011 On 01 0
I I I
Fund Transfer Out 0 01 0 01 01 0 0 0 0 0
Total Transfer Out I 011 011 011 01 01 01 01 011 01 0
WQFP NET ASSET SUMMARY:
Beginning Unrestricted Net Assets 7,740,008 2,108,364 2,108,364 0 2,824,621 563,692 413,603 431,381 569,447 724,942
Plus:Revenues 1,682,985 1,239,897 1,277,747 37,850 1,253,689 1,279,800 1,306,100 1,330,754 1,360,083 1,393,649
Less:Expenses (7,314,629)(7,315,605)(561,490)6,754,115 (3,514,618)(1,429,889)(1,288,322)(1,192,688) (1,204,588)(783,026)
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 Net Assets 2,108,364 I (3,967,344)11 2,824,62111 6,791,965 1 563,6921 413,6031 431,381 I 569,44711 724,9421 1,335,565
Invested in Capital Assets 12,476,664 N/A 12,458,305 1 I I
Ending Net Assets Per Financial Statements 14,585,028 N/A 15,282,926 1 I I
I I I
3
-
4
6
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
....m
~FY10·11
RDA HOUSING SET·ASIDE FUND DETAIL
(Fund·218)
Revenues
Property tax increment (e)220,201 211,700 215,652 3,952 222,300 234,500 239,250 245,200 251,400 257,600
Interest earnings (m)27,391 10,600 8,303 (2,297)3,600 100 1,800 4,700 8,800 14,300
Proceeds of sales of land 0 0 2,990,000 2,990,000 0 0 0 0 0 0
Total Revenue 247,592 I 222,300 II 3,213,95511 2,991,6551 225,9001 234,600 II 241,050 II 249,900 II 260,200 I 271,900
Expenditures
Operations &maintenance (b)308,806 12,500 46,055 (33,555)12,500 12,500 12,500 12,900 13,300 13,800
Land 432,094 0 0 0 0 0 0 0 0 0
Capital OuUay 0 1,821,128 3,810,938 (1,989,810)714,896 0 0 0 0 0
Total Expenditures 740,900 I 1,833,62811 3,856,99311 (2,023,365)1 727,3961 12,50011 12,500 II 12,900 II 13,300 I 13,800
1 I
RDA HOUSING SET -ASIDE FUND NET BEFORE
(493,308)1 (1,611,328)11 (643,038)11 968,290 I (501.496)1 222,100 I 228,550 I 237,000 II 246,900 ITRANSFERS 258,100
1 1 1 1
Fund Transfer In 0 01 01 01 01 0 0 0 0 0
Total Transfer In 01 011 011 01 01 011 011 011 01 0
RDA HOUSING SET·ASIDE FUND SUMMARY
Beginning Fund Balance 2,561,059 2,067,751 2,067,751 0 519,629 18,133 240,233 468,783 705,783 952,683
Plus:Revenues 247,592 222,300 3,213,955 2,991,655 225,900 234,600 241,050 249,900 260,200 271,900
Less:Expenditures (740,900)(1,833,628)(3,856,993) (2,023,365)(727,396)(12,500)(12,500)(12,900)(13,300)(13,800)
Plus:Transfers In 0 0 0 0 0 0 0 0 0 0
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Ending Fund Balance 2,067,751 I 456,42311 1,424,71311 968,2901 18,1331 240,2331 468,783 I 705,78311 952,6831 1,210,783
AMCAL Net Long-Teon Loan Receivable (905,064)1 1 I
Net Spendable Fund Balance 519,629 I I I
1 I I
3
-
4
7
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
~FY10-11
RDA DEBT SERVICE FUND DETAIL
Fund-4101
Revenues
Property tax increment (e)901,061 846,900 862,792 15,892 889,200 938,000 957,000 980,900 1,005,400 1,030,500
Long teon advance from city 876,927 0 707,704 707,704 620,680 670,500 745,000 800,600 885,600 978,600
Total Revenue 1,777,988 846,900 1 1,570,49611 723,5961 1,509,8801 1,608,500 II 1,702,000 II 1,781,500 II 1,891,000 1 2,009,100
Expenditures
Pass thru to county fire department (e)187,211 174,400 183,625 (9,225)189,000 199,300 203,400 208,400 213,600 219,000
County administrative fee (b)18,509 16,400 16,358 42 17,000 21,000 21,400 22,000 22,700 23,500
SERAF Shift 0 330,125 330,125 0 0 0 0 0 0 0
Repayment of county bonds 323,125 330,125 330,125 0 345,375 355,750 370,250 378,875 391,625 408,250
Repayment of county deferred interest debt 294,627 354,606 354,606 0 456,560 328,700 327,900 142,002 0 0
Interest on city advance 832,441 722,169 620,873 101,296 535,680 649,500 723,600 800,600 885,600 978,600
Total Expenditures 1,655,913 I 1,927,8251 1,835,712 I 92,1131 1,543,615'1,554,250 II 1,646,550 II 1,551,87711 1,513,5251 1,629,350
1 1
RDA DEBT SERVICE FUND NET BEFORE 122,075 1 (1,080,925)1 (265,216 I 815,7091 (33,735)'54,250 II 55,450 II 229,62311 377,4751 379,750
Fund Transfer In
From General Fund 0 0 0 0 0 0 0 0 0 0
Total Transfer In 01 011 011 01 0'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 0 01 01 0
RDA DEBT SERVICE FUND SUMMARY:
Beginning Fund Balance
481,602 603,677 603,677 0 338,461 304,726 358,976 414,426 644,049 1,021,524
Plus:Revenues 1,777,988 846,900 1,570,496 723,596 1,509,880 1,608,500 1,702,000 1,781,500 1,891,000 2,009,100
Less:Expenditures (1,655,913)(1,927,825) (1,835,712)92,113 (1,543,615)(1,554,250) (1,646,550) (1,551,877)(1,513,525)(1,629,350)
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 603,677 1 (477,248)1 338,461 I 815,7091 304,726'358,9761 414,426 I 644,049 11 1,021,5241 1,401,274
Long-Term Advance Due To The City 16,886,971 16,886,971 17,594,675 1 1 1
Ending Fund Balance Per Financial Statements (16,283,294) (17,364,219)(17,256,214)I I I
1 1
3
-
4
8
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
;::FY10·11
RDA •PORTUGUESE BEND FUND DETAIL {Fund·
3751
Revenues
Interest eamings (m)9,712 7,300 2,837 (4,463)1,520 1,370 1,790 2,030 2,080 1,930
Loans received 50,004 0 50,004 50,004 0 0 0 0 0 0
Total Revenue 59,716 I 7,300 II 52,84111 45,5411 1,520 I 1,370 II 1,790 II 2,030 II 2,080 I 1,930
Expenditures
Administration (b)17,829 28,675 24,681 3,994 28,966 26,800 27,200 28,000 28,900 29,900
Agency attomey (b)105 3,398 3,398 0 10,000 10,000 10,000 10,300 10,600 11,000
Improvements 0 0 0 0 254,847 0 0 0 0 0
Total Expenditures 17,934 I 32,07311 28,07911 3,9941 293,8131 36,800 II 37,200 II 38,300 II 39,500 I 40,900
T
RDA -PORTUGUESE BEND FUND NET BEFORE
41,7821 (24,773)11 24,76211 49,5351 (292,293)1 (35,430)11 (35,410)11 (36,270)11 (37,420)1TRANSFERS (38,970)
1 T 1 T
Transfers In 0 01 ,01 01 01 0 0 0 0 0
Total Transfers In 01 011 011 01 01 01 01 011 01 0
1 1 1 1
Transfers Out 0 01 01 01 01 0 0 0 0 0
TotalTransfers Out 01 011 011 01 01 01 01 011 01 0
RDA -PORTUGUESE BEND FUND SUMMARY
Beginning Fund Balance 499,259 541,041 541,041 0 565,803 273,510 238,080 202,670 166,400 128,980
Plus:Revenues 59,716 7,300 52,841 45,541 1,520 1,370 1,790 2,030 2,080 1,930
Less:Expenditures (17,934)(32,073) (28,079)3,994 (293,813)(36,800) (37,200) (38,300) (39,500) (40,900)
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 541,041 I 516,26811 565,80311 49,5351 273,5101 238,080 II 202,670 II 166,400 II 128,980 I 90,010
1 1 1 1
3
-
4
9
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B ..nMA~_
~FY10-11
RDA -ABALONE COVE FUND DETAIL
IFund-3801
Revenues
Interest earnings (rn)119 90 33 (57)30 a a a a a
Total Revenue I 11911 9011 3311 (57)1 30 I a II all all 01 a
Expenditures
Capital projects a a a a a a a a a a
Total Expenditures a I all all 01 a I .~I all all 01 a
1 1 1 1
RDA -ABALONE COVE FUND NET BEFORE
I 11911 9011 3311 (57)1 30 I a II all a II 01TRANSFERS a
1 1 1 1
Transfers In a 01 01 01 01 a a a a a
Total Transfers In a I all all 01 01 a II all a II 01 a
1 1 1 1 1
Transfers Out a 01 01 01 01 a 01 a a a
Total Transfers Out 01 all a II 01 01 a II all all 01 a
RDA -ABALONE COVE FUND SUMMARY
Beginning Fund Balance 6,052 6,171 6,171 a 6,204 6,234 6,234 6,234 6,234 6,234
Plus:Revenues 119 90 33 (57)30 a a a a a
Less:Expenditures a a a a a a a a a a
Plus:Transfers In a a a a a a a a a a
Less:Transfers Out a a a a a a a a a a
Ending Fund Balance 1 6,17111 6,26111 6,20411 (57)1 6,2341 6,23411 6,23411 6,23411 6,2341 6,234
I I I 1 I 1
I 1 1 1 1 I
3
-
5
0
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
"'TIM'"
~FY10-11
IMPROVEMENT AUTHORITY -PORTUGUESE BEND
FUND DETAIL /Fund-285l
Revenues
Interest earnings (m)3,969 2,820 1,041 (1,779)1,030 1,220 1,210 1,250 1,090 680
Total Revenue 3,969 I 2,820 II 1,04111 (1,779}1 1,030 I 1,220 I 1,210 I 1,250 II 1,090 I 680
I I 1
Expenditures I I 1
Maintenance &Operations (b)82,253 138,700 I 59,334 I 79,366 141,700 143,350 143,400 147,700 1 152,400 157,600
Total Expenditures 82,253 I 138,700 II 59,33411 79,3661 141,700 I 1~3.35OI1 143,400 II 147,700 II 152,400 I 157,600
I I
IMPROVEMENT AUTHORITY -PORTUGUESE BEND
(78,284)1 (135,880)11 (58,293}11 77,5871 (140,670}1 (142,130JI (142,190}11 (146,450}1 (151,310}1FUNDNETBEFORETRANSFERS (156,920)
I T I T I I
Transfers In I I 1 1 I I 1
From General fund 82,252 110,0001 110,000 1 01 101,000 1 60,0001 106,0001 108,000 1 110,000 112,000
Total Transfers In I 82,25211 110,000 II 110,000 II 01 101,000 I 60,000 II 106,000 II 108,000 I 110,000 I 112,000
1 1 1 1 1 I 1
Transfers Out 0 0 oT 01 01 01 01 01 0 0
Total Transfers Out 01 011 011 01 01 011 011 011 01 0
IMPROVEMENT AUTHORITY -PORTUGUESE BEND
FUND SUMMARY
Beginning Fund Balance 227,845 231,613 231,613 0 283,320 243,650 161,520 125,330 86,880 45,570
Plus:Revenues 3,969 2,820 1,041 (1,779)1,030 1,220 1,210 1,250 1,090 680
Less:Expenditures (82,253)(138,700)(59,334)79,366 (141,700) (143,350)(143,400)(147,700)(152,400) (157,600)
Plus:Transfers In 82,252 110,000 110,000 0 101,000 60,000 106,000 108,000 110,000 112,000
Less:Transfers Out 0 0 0 0 0 0 0 0 0 0
Ending Fund Balance 231,613 I 205,73311 283,320 II 77,5871 243,650 I 161,520 II 125,330 II 86,880 II 45,570 I 650
I T 1
I 1 1 I
3
-
5
1
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL -(BY FUND)
EXHIBIT B
~!ESTIMATE
;:;FY10-11
IMPROVEMENT AUTHORITY -ABALONE COVE
FUND DETAIL IFund-7951
Revenues
Interest earnings (m)26,082 19,500 7,085 (12,415)6,500 6,200 8,900 11,500 13,800 16,000
Total Revenue 26,082 1 19,500 II 7,08511 (12,415)1 6,500 I 6,2001 8,900 I 11,500 II 13,800 I 16,000
Expenditures
RDA Storm Drain User Fee (c)2,776 2,776 2,794 (18)2,790 2,900 3,000 3,054 3,115 3,184
Operations (b)32,356 45,400 33,300 12,100 46,700 46,850 46,900 46,300 49,800 51,500
ACLAD Contribution 0 60,000 0 60,000 60,000 0 0 0 0 0
Total Expenditures 35,132 I 108,17611 36,09411 72,0821 109,490 I 49,750 II 49,900 II 51,3541 52,9151 54,684
1 r 1
IMPROVEMENT AUTHORITY -ABALONE COVE
(9,050)1 (88,676)11 (29,009~59,6671 (102,990)1 (43,550)11 (41,000)1FUNDNETBEFORETRANSFERS (39,654)(39,115)(38,684)
1 1
Transfers In 0 0 01 oT 0 0 0 0 0 0
Total Transfers In 01 011 011 01 01 01 01 01 01 0
1 T I
Transfers Out 0 0 01 01 01 0 0 0 0 0
Total Transfers Out 01 oU 011 01 01 011 011 oU 01 0
IMPROVEMENT AUTHORITY -ABALONE COVE
FUND SUMMARY
Beginning Fund Balance 37"1,281 362,231 362,231 0 333,222 230,232 186,682 145,682 105,828 66,713
Plus:Revenues 26,082 19,500 7,085 (12,415)6,500 6,200 8,900 11,500 13,800 16,000
Less:Expenditures (35,132)(108,176)(36,094)72,082 (109,490)(49,750)(49,900)(51,354) (52,915)(54,684)
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
Expendable Fund Balance 362,231 I 273,55511 333,22211 59,6671 230,2321 186,68211 145,682 U 105,82811 68,7131 28,029
Unexpendable Endowment 1,000,000 1,000,000 I 1,000,0001 1 1,000,000 1 1,000,000 1 1,000,000 1 1,000,000 1,000,000 1,000,000
Ending Fund Balance Per Financial Statements 1,362,231 1,273,555 I 1,333,2221 1 1,230,2321 1,186,6821 1,145,682 I 1,105,828 1,066,713 1,028,029
I T I I I
3
-
5
2
li~~i1;·I~llf~·I'1CIPFUNDPROJECTS
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
CIP PLAN PROJECT EXPENDITURES
EXHIBITC
BUDGET
FY10-11 FUNDING SOURCE
Street Infrastructurer:A~;;-;;1 Resid~~tialpavem~~------------------t930~461---1;095,06it~-168,1521 1,600,000 1,600,000 1,600,000 1,500,000 1,500,000 IGeneral Fund,TDA Article 3/$25K
Annual Arterial Pavement I 172,173 2,149,0991 2,543,5601 2,380,000 IPropC/STPUMeasureR
Pavement Management Plan Update 4,689 5,003 120,000 120,000 General Fund'Ej~~~~!t.~~~!!1£~~~~!1:!~~~:'_?.i?2__-_-~_-_-_~-__~=---------------------------~--~-------------------------------c:.-P~-E'==~_=_.::__-~_=-~-_=_-~-~-=~-
Arterial Median Improvements 12,784 480,754 500,500 250,000 250,000 Beautification Fund
Traffic Signal-Crenshaw/Crestridge 11,217 8,796 254,000 General fund/Grant
Traffic Signal Synchronization -Hawthorne Blvd 785,532 HSIP GranVCIP Excess Reserve 10%matcl
~~f!!.~~I!!,~.!L'!?~~.!.".i.~~~.:'________9~~~n:!.~~<!.r:..~<!..~~~~~_
PVDE Safety Improvements -Early Action Impr (Guardrails)280,000 90%GranVl0%General Fund
ADA-C~rt;-R~~pl~p~~~;;~;;~t~------------------------------------1-i{61'6'----------------------25;000------------------~---------------------------------------------------------------G;~;;~iF~;;d--------------------------
~:strian Improvements on Hawtho":!e Blvd -1 p427,OOO I 80%GranV20%City Match
PVDS Bikeway Safety Project 11,852 801,000 Prop C &Grant
------
Study PVDS in Landslide Area I I 50,000 I ICIP Accumulated Fund Balance
Parks &Open Space Infrastructure1-'-------------------------------------,---------------
PVIC &Forrestal Trail Improvements 7,700
Klondike Canyon Trail Repair I 21,700
Other Park Facility Improvements I 57,398 11,193
---------l------------------------------------------+-----------------------
General fund
EET
Hesse Park Lower Picnic Playgroung --1 198,377 ~_L___________IEET
'He;se Park Field Upgrade Phase I &II ---223,150T--General Fund /EET
Hesse Park Drop Ceiling RetrofrtlReplacement I I I 145,000 IBuilding Replacement Fund
,~!lr!:!~11 Co~~~~¥_Room Drop Ceiling RetrofrtlRePlaceme~__+--------~15,000 IGener!'Fund _
Ryan Park Field Upgrade I ..323,150 IGeneral FundlEET
Ryan Park Southern Entrance Road -t-~I 20,000 220,000 JCIP Excess Reserve/General Fund
'California Coa~alTraii -------280,000 280,000 -----~GranV12%Match from CIP Exces;-R~serve
~~~;!i~1o~g~:!c:~:1¥f;~~ntS------~.::--~----~-=~~~~~6~~~~~==------t--i~~:%~~~~.::-.::-.::-N~~~l====~~-~-~------------i~:~t~~~~~:Kf:~~~-~-=-~-
Grandview Park &Lower Hesse Park Development I 11,378 1 2,046,595 1 2,400,000 IGeneral Fund/CIP Reserve
~~-=--~Trails Beach Lifeguard St~~!c:?~_~~.c:~service!~?_\\1_~_1 -+_20,000 t_--3000 ICIP ~~ss ~~!!rve _
Pl.Vicente Blufflop Drainage Control 80,000 lCIP Excess Reserve
Subregion 1/0ceanfront Estates Blufflop Drainage Control I I I 22,000 ICIP Excess Reserve
~:~~i~~;~~~:~;;~:~~~rovem~nt;---------------t_---------------+----------1 89,000 35,000 ---------------i~;~~;:~:d ------------
,~isc ~roject Design _-+__________-1-----I 10,000 __~2!.Q9~____-----t CIP ~~ss Reserve -----I
Facilitiest~~!!.:~~nPian-==_~~~~~_~~~~~~~~_=:__=~~_~~~~~_~~_i=~~==-~~~-~__=__=_=_l~.::_~=~=_~t_~~===-~~~~~~~9-(j;00(f--40O'OO(f----400,OO0--400,ooot~~~~~~;;:__~~~~_=~~~~~~~=_~_~_=_~_1
Sewer Infrastructure
Sewer Overflow Capacity Analysis 69,282 4,989 CIP Accumulated Fund Balance
General Administration/MaintenancE
Total CIP Fund Expenditures
165,176 1,985
1,501,477 110,484,860
53,600
11,715,707
27,500 25,000 25,500 26,000 26,600 ICIP Fund Interest Earnings
5,924,032 1 3,245,000 I 4,425,50-()1 2,046,000 I 2,176,600
NOTE:The Tota/Expenditures above agree to Total CIP fund expenditures on Page 9 of the Model.
3
-
5
3
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
WATER QUALITY FLOOD PROTECTION (STORM DRAIN)EXPENSES
EXHIBITD
IJ:[liillli'!~r~'~!~iflfljll;BUDGET i,1~lllilll;~I~I.lil~l~ft!lllli""~:111]'rjll'I:;~rl:!r\iIII,';:WQFP FUND PROJECTS FY10-11 FUNDING SOURCE
Backbone Projects
McCarrell Canyon 6,139,888 79,075 General Fund/User Fees
San Ramon Canyon Stabilization 10,980 118,102 1,385,000 User Fees
PVDE San Pedro Canyon Backbone System 200,000 User Fees
Pipe Lining
uther 652,716 20,000 839,617 ::S19,555 324,642 ::S29,881 335,278 340,836 IUser Fees
Icapacity &Secondary System Projects
Roan ::>ystem (via GOllnitalVlcKery Ganyon)92,818 242,500 IUser Fees
I::>an Pedro Ganyon ::>ystem 370,000 IUser Fees
t->VLJl:.Lower ::>wltchbacKs 485,000 ,User Fees
t->VLJ::>(North ot Barkentme)446,000 ,User Fees
,::>outh HawthornelVla t-rascatl 440,000 ,User Fees
Filtration systems
IInstallation ot t-Iltratlon uevlces 7,490 41,UOU IUser Fees
IGatch Ijasm t-Iltratlon uevlces 73,000 User Fees
lother Projects
IVia Canada 100,000 iUser Fees
Mlscellanous R.epalrs &Mamtenance
uramage Master t-'Ian t-'rogram 495,UOO.
MIsc.storm Dram Repairs 44,590 ,General Fund
storm Dram &Filtration Maintenance 216,890 111,253 237,687 194,817 222,162 229,727 237,518 245,544 IUser Fees
storm Drain Master Plan Update 225,000 30,000 30,000 30,000 30,uuu iGeneral t-undtUser t-ees
iAdmlnlstratlon (contract/staff engmeer)242,074 140,242 146,314 148,017 153,518 157,080 161,792 166,646 luser t-ees
Grand Total -WQFP Fund Expenditure~7,314,6281 561,490 3,514,618 1,429,8891 1,288,322 11,192,688 I 1,204,588 1 783,026
3
-
5
4
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
2011·12 SUMMARY OF FUND TRANSFERS
EXHIBITE
TRANSFERS TO FUND:
Abalone Capital RDA
TRANSFERS FROM FUND:Street Cove Improvement Habitat Prop.Sub 1 Port.Bend
General Maintenance Sewer District Pro!lram Restoration A Maint.Imp.Auth.Total
General 10,700 4,618,553 90,000 60,000 60,000 4,839,253
Beautification 116,000 116,000
Waste Reduction 12,000 40,000 52,000
1972 Act 200,000 200,000
1911 Act 202,000 202,000
Proposition C 516,400 1,306,927 1,823,327
Building Improvement 145,000 145,000
Bikeways 25,000 25,000
Measure R 364,000 364,000
Measure A 100,000 100,000
Employee Benefits 340,000 340,000
TOTAL 452,000 1,074,400 10,700 6,459,480 90,000 0 60,000 60,000 8,206,580
3
-
5
5
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
2012-13 SUMMARY OF FUND TRANSFERS
EXHIBITE
TRANSFERS TO FUND:
Abalone Capital Equip RDA
TRANSFERS FROM FUND:Street Cove Improvement Habitat Replace Sub 1 Port.Bend
General Maintenance Sewer District Proaram Restoration ment Maint.ImD.Auth.Total
General 10,700 4,702,500 90,000 65,000 106,000 4,974,200
Beautification 193,000 250,000 443,000
Waste Reduction 12,000 40,000 52,000
1972 Act 200,000 200,000
1911 Act 113,000 113,000
ProDosition C 526,400 526,400
AQMD 60,000 60,000
Measure R 200,000 200,000
Bikewavs 25,000 25,000
Measure A 100,000 100,000
TOTAL 112,000 1,072,400 10,700 5,177,500 90,000 60,000 65000 106,000 6693,600
3
-
5
6
CITY OF RANCHO PALOS VERDES
2011 FIVE-YEAR FINANCIAL MODEL
2013-14 SUMMARY OF FUND TRANSFERS
EXHIBITE
TRANSFERS TO FUND:
Abalone Capital RDA
TRANSFERS FROM FUND:Street Cove Improvement Habitat Prop.Sub 1 Port.Bend
General Maintenance Sewer District Program Restoration A Maint Imp.Auth.Total
General 100,000 10,700 4,499,200 110,000 65,000 108,000 4,892,900
Beautification 198,800 198,800
Waste Reduction 12,400 41,200 53,600
1972 Act 195,000 195,000
1911 Act 116,400 116,400
Proposition A 497,000 497,000
Bikeways 25,000 25,000
Measure A 100,000 100,000
TOTAL 112,400 1,148,400 10,700 4,524,200 110,000 0 65,000 108,000 6,078,700
3
-
5
7
CITY OF RANCHO PALOS VERDES
2011 FIVE·YEAR FINANCIAL MODEL
2014·15 SUMMARY OF FUND TRANSFERS
EXHIBITE
TRANSFERS TO FUND:
Abalone Capital RDA
TRANSFERS FROM FUND:Street Cove Improvement Habitat Sub 1 Port.Bend
General Maintenance Sewer District Proaram Restoration Maint.ImD.Auth.Total
General 150,000 10,700 4,577,700 137,000 65,000 110,000 5,050,400
Beautification 205,200 205,200
Waste Reduction 12,800 42,500 55,300
1972 Act 190,000 190,000
1911 Act 120,100 120,100
Proposition C 508,000 0 508,000
Bikeways 25,000 25,000
Measure A 100,000 100,000
TOTAL 112,800 1,215,800 10,700 4,602,700 137,000 65,000 110,000 6,254,000
6,254,000
o
3
-
5
8
CITY OF RANCHO PALOS VERDES
2011 FIVE·YEAR FINANCIAL MODEL
2015-16 SUMMARY OF FUND TRANSFERS
EXHIBITE
TRANSFERS TO FUND:
Abalone Capital RDA
TRANSFERS FROM FUND:Street Cove Improvement Habitat Sub 1 Port.Bend
General Maintenance Sewer District Proaram Restoration Maint.Imp.Auth.Total
General 190,000 10,700 4,523,300 152,000 65,000 112,000 5,053,000
Beautification 212,200 0 212,200
Waste Reduction 13,200 43,900 57,100
1972 Act 200,000 200,000
1911 Act 124,200 124,200
Proposition C 519,000 0 519,000
Bikeways 25,000 25,000
Measure A 100,000 100,000
TOTAL 113,200 1,289,300 10,700 4,548,300 152,000 65,000 112,000 6,290,500
6,290,500
o
3
-
5
9