RPVCCA_CC_SR_2013_05_07_C_Monthly_Cash_BalancesCITY OF
MEMORANDUM
4o RANCHO PALOS VERDES
TO:
FROM:
DATE:
SUBJECT:
REVIEWED:
Staff Coordinator:
HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL
DIRECTOR OF FINANCE AND INFORMATION TECHNOLOGY I£lt
MAY 7,2013 W
MARCH 2013 MONTHLY REPORT OF CASH BALANCES
CITY MANAGER oSL-,
Jane Lin,Accountant
RECOMMENDATION
Receive and file the March 2013 Monthly Report of Cash Balances for the City of Rancho
Palos Verdes.
BACKGROUND
With the adoption of the state budget for FY06-07,government agencies are no longer
required to submit a treasurer's report to their governing board,as defined by California
Government Code.Notwithstanding the change of California law,staff has continued to
submit a cash balance report to the Council for review each month.This report summarizes
the cash activity associated with all funds of the City.
A separate report is prepared monthly for the Improvement Authority and is presented
under separate cover before the Authority Commission.The attached report includes the
cash activities of the City for the month of March 2013.
ANALYSIS
The overall cash balances of the City totaled $49,568,376 at March 31,2013.This
represents a $686,452 decrease during the month.The overall decrease is a result of
various factors over several individual funds of the City.These factors are discussed in
detail below for each fund experiencing a noteworthy cash event (defined as more than
$50,000 and 5%of the cash balance in a particular fund).
Gas Tax Fund -The cash balance in this fund decreased by more than $164,000 during
the month.The decrease was attributable to the large disbursements to Hardy &Harper for
roadway rehabilitation in the landslide area.
C-1
March 2013 Monthly Report of Cash Balances
May 7,2013
Page 2
Proposition A Fund -The cash balance in this fund increased by more than $57,000 during
the month due to receipt of the March Proposition A apportionment.The Proposition A fund
pays for the Palos Verdes Peninsula Transit Authority contribution.Disbursements for that
contribution are only made twice per year in August and January.
Employee Benefits Fund -The cash balance in this fund decreased by more than $66,000
during the month.The most significant factor was the City's share of employee insurance
premiums totaling $59,378.
Redevelopment Obligation Retirement Fund -The cash balance in this fund decreased
more than $315,000 during the month.Pursuant to the Other Funds and Accounts Due
Diligence Review,the Successor Agency was required to remit $313,535 of unencumbered
cash to the County of Los Angeles for distribution to the taxing entities.
C-2
BEGINNING BALANCE
PLUS DEPOSITS
PLUS INTEREST EARNINGS(1)
LESS CHECK DISBURSEMENTS
LESS ELECTRONIC DISBURSEMENTS(2)
ADJUSTMENTS(3)
PLUS:TRANSFERS IN
LESS:TRANSFERS OUT
ENDING BALANCE
(1)All LAIF interest is paid querterly.
(2)Electronic Disbursements:
CalPers
Postege
Bank and Merchant Fees
OPERATING
3,522,297.03
1,772,611.51
(1,791,566.12)
(55,815.03)
(484.72)
(611,198.11)
2,835,844.56
50,986.83
2,500.00
2,328.20
55,815.03
CITY OF RANCHO PALOS VERDES
MONTHLY REPORT OF CASH BALANCES
MARCH 2013
TREASURIES TREASURIES
BANKCARD PETTY CASH PAYROLL LAIF-CITY BOA BOA TREAS DIRECT TOTAL CASH
0.00 2,500.00 372,568.93 46,357,462.78 0.00 0.00 0.00 50,254,828.74
611,198.11 2,383,809.62
0.00
(611,198.13)(2,402,764.25)
(55,815.03)
(48472)
0.00
(611,198.11)
0.00 2,500.00 372,568.91 46,357,462.78 0.00 0.00 0.00 49,568,376.25
YTD INT
RECEIVED
73,789.53
73,789.53
(3)The net adjustment was due to a nor-sufficient check item and other adjustment.
CASH BALANCES BY FUND
BALANCE
FORWARD DEBIT CREDIT CASH
Change In
Ending Cash
Balance
%Change of
Cash Balance
from Previous
Month-End
GENERAL FUND 14,707,654.73 1,294,288.70 1,373,808.47 14,628,134.96 (79,519.77)1%
GAS TAX 872,517.92 116,483.81 280,545.38 708,456.35 (164,061.57)19%
1972 ACT 175,100.71 0.00 1,400.00 173,700.71 (1,400.00)1%
ELPRADO 17,978.11 5.74 0.00 17,983.85 5.74 0%
CDBG (94,598.27)43,904.98 64,730.25 (115,423.54)(20,825.27)22%
CDBG-R 0.00 0.00 0.00 0.00 0.00 0%
1911 ACT 1,729,344.33 1,472.21 27,385.93 1,703,430.61 (25,913.72)1%
RECYCLING 1,199,087.27 0.00 1,316.97 1,197,770.30 (1,316.97)0%
SOLID WASTE 331,490.40 43,795.06 11,971.11 363,314.35 31,823.95 10%
AIR QUALITY MANAGEMENT 114,187.79 11,681.75 0.00 125,869.54 11,681.75 10%
PROPOSITION C 1,710,996.22 47,354.62 0.00 1,758,350.84 47,354.62 3%
PROPOSITION A 381,583.21 57,042.67 0.00 438,625.88 57,042.67 15%
PUBLIC SAFETY GRANTS 97,150.12 0.00 0.00 97,150.12 0.00 0%
MEASURE R 665,238.65 36,426.51 0.00 701,665.16 36,426.51 5%
HABITAT RESTORATION 214,858.07 0.00 0.00 214,858.07 0.00 0%
SUBREGION 1 MAINTENANCE 818,162.35 0.00 2,400.86 815,761.49 (2,400.86)0%
MEASURE A MAINTENANCE 26,888.71 0.00 0.00 26,888.71 0.00 0%
ABALONE COVE SEWER DISTRICT 40,913.79 0.00 1,253.62 39,660.17 (1,253.62)3%
RPVTV 0.00 0.00 0.00 0.00 0.00 0%
GINSBURG CULTURE ARTS BUILDING 138,722.47 0.00 0.00 138,722.47 0.00 0%
RECREATION IMPRV DONATION 407,462.71 0.00 0.00 407,462.71 0.00 0%
CIP 16,591,871.74 104,972.58 206,225.86 16,490,618.46 (101,253.28)1%
QUIMBY 29,468.67 0.00 0.00 29,468.67 0.00 0%
AFFORDABLE HSNG IN LIEU 499,319.78 0.00 820.44 498,499.34 (820.44)0%
EET 437,533.78 0.00 0.00 437,533.78 0.00 0%
MEASURE A CAPITAL 7,440.11 0.00 0.00 7,440.11 0.00 0%
BIKEWAYS 9,811.08 41,028.00 0.00 50,839.08 41,028.00 100%
UNDERGROUND UTILITIES 0.00 0.00 0.00 0.00 0.00 0%
ROADWAY BEAUTIFICATION 000 0.00 0.00 0.00 0.00 0%
WATER QUALITY FLOOD PROTECTION 3,553,640.94 2,306.84 114,392.10 3,441,555.68 (112,085.26)3%
EQUIPMENT REPLACEMENT 2,876,999.73 0.00 18,464.52 2,858,535.21 (18,464.52)1%
EMPLOYEE BENEFITS 291,423.63 661,335.52 727,918.80 224,840.35 (66,583.28)23%
BUILDING REPLACEMENT 944,478.43 0.00 0.00 944,478.43 0.00 0%
REDEVELOPMENT OBLIGATION RETIRE 574,158.19 4,167.00 319,834.94 258,490.25 (315,667.94)55%
IMPROVEMENT DISTRICT 9 0.00 0.00 000 0.00 0.00 0%
SPECIAL TRUSTS 883,943.37 16,125.82 16,375.05 883,694.14 (249.23)0%
50,254,828.74 2,482,391.81 3,168,844.30 49,568,376.25 (686,452.49)1%
Total Investment:49,568,376.25
C-3
CITY OF RANCHO PALOS VERDES
SUMMARY MONTHLY REPORT OF CASH BALANCES
MARCH 2013
On Demand $3,210,913
On Demand $46,357,463
Investment
Checking Accounts
Local Agency Investment
Fund (LAIF)
Issuer of Acquisition
Investment Date Term
Bank of America N/A N/A
State of
California N/A N/A
Maturity
Date
Market
Value
NOTE (1)
NOTE (2)
Par
Value
N/A
N/A
Book
Value
$3,210,913
$46,357,463
Yield
0.00%
0.29%
Total Investment:$49,568,376
Total Investment Weighted Average Return 0.3%
NOTE:
(1)See footnote on the summary page
(2)LAIF market values will be reported to very from book value if the City calculated share of total LAIF assets is less than the
City book value.
To the best of my knowledge,there are no misstatements of material amounts within this report;
or omissions of material amounts to cause the report to be misleading.
I certify that this report accurately reflects all City Investments and complies with the investment policy of the City
of Rancho Palos Verdes as approved by the City Council.Furthermore,I certify that sufficient investment liquidity
and anticipated revenues are available to meet the City's expenditure requirements for the next six months.
C-4