Agenda Item B.2
CONSENT CALENDAR
Meeting Date: May 17, 2022
TO: Mayor and Councilmembers
FROM: Luke Rioux, Finance Director
SUBJECT: Acceptance of the March 2022 Investment Transaction Report
RECOMMENDATION:
Accept the investment transaction report for the month of March 2022.
BACKGROUND:
Transmitted herewith is the investment transaction report for the month of March 2022.
The City Treasurer continues to monitor idle cash balances with the help of the accountants in the Fina nce Department, transferring cash between the checking and money market accounts daily, or as needed to maximize interest earnings. On a quarterly basis, staff submits a comprehensive report on the City’s portfolio and related activity pursuant to the City’s Investment Policy.
DISCUSSION:
Investment Transaction Report
As of March 31, 2022, the City’s investment portfolio totaled $78,887,407.05. The City’s weighted average yield in March was 0.606%.
Attachment 1 contains the Investment Transactio n Report, which includes the Investment Activity and Interest Report, Summary of Cash and Investments, and Investment Portfolio detail as of March 31, 2022.
Benchmark Comparisons
Figure 1 shows a 2-year interest rat e trend chart which compares the Cit y’s portfolio yield by quarter, compared to its benchmarks, LAIF, and the 1 - and 2 - Year US Treasury Notes. These benchmarks serve as indicators of the City ’s performance.
Trends over time that substantial ly de viate f rom these benchm arks would wa rrant further analysis and review.
1 Figure 1
(Note: The most recent LAIF apportionment rate is displayed for benchmark purposes.)
As of March 31, 2022, LAIF’s apportionment rate was at 0.32%, 1 Year US Treasury Yield was at 1.63% and the 2 Year US Treasury Yield was at 2.28%, compared to the City’s portfolio yield at 0.0.606%. By the end of the quarter Treasury yields were higher across the maturity terms of the yield curve. Since the prior quarter the 1 Year US Treasury has increased from 0.39% to 1.63% increasing by 124 basis points and the 2 Year US Treasury has increased from 0.73% to 2.28% increasing by 155 basi s points.
The LAIF daily rate is trending above 0.60% at the time of preparing this report.
It should be noted that on March 16, 2022 the Federal Res erve (Fed) raised the federal funds rate, which in turn influences Treasury yields to a range of 0.25% to 0.50 %.
Additionally, the Fed ended its bond -purchasing program , also known as Quantitative Easing, resulting accele rating the withdrawal of the monetary accommodati on introduced during the pandemic. As a rea ction to the Fed sign aling its resolve to counter current high inflation, interest rates across the yield curve have moved sharply higher. In the current interest rate environment, the City ’s interest earning s are forecasted to gradually increase.
Most recently at the time of preparing this report, the Fed raised the target fo r the fed funds rate by half a point to 0.75% to 1.0% during its May 3-4, 2022, meeting, the largest rate hike since 2000.
The pooled ca sh report is included as Attachment 2 . Balance Sheets for the Ge neral Fund and all Special Funds are included as well, as Attachment 3.
2 Investment Program Update
Since the star t of the pandemic Finance staff has had to re -prioritize its work efforts from further enhancing its investmen t program and focus on other competing critical items, such as transitioning process es electronically and implementing the fin ancial software system. In addition, workload capacity was strained with changes in staff and vacancies. A s staffing levels begin to increase and workload capaci ty be comes available, staff will continue its work on the investment program to incorporate the other allowable investments into its overall portfolio. Now that the new Management Assistant has started and is providing additional support , staff will be moving forward with this work effort.
Section 115 Trust Update
Staff has completed establishing its Section 11 5 Trust s with PARS to help address future costs increases associated with pe nsion and retiree health care costs. Staff has initiated the transfer of funds held in reserves to the trus ts. Next steps with the Section 115 Trust will include reviewing and adop tion an ongoing funding strategy and p olicy.
Now that the new Management Assistant has started and is providing additional support, staff will be moving forward with this work effort.
FISCAL IMPACTS:
As of March 31, 2022, the investmen t portfolio is in compliance with all State laws and the City’s Investm ent Policy. Ther e are suffic ient funds available to meet the City’s expenditure requirements for the next six months.
Reviewed By: Approved By:
___________________ _________________
Kristine Schmidt Michelle Greene
Assistant City Manager City Manager
ATTACHMENTS:
1. Investment Transaction Report for March 2022
2. Pooled Cash Report for the Quarter Ending March 31, 2022
3. Balance Sheets for the Quarter Ending March 31, 2022 3 ATTACHMENT 1
Investment Transaction Report March 2022
4 Attachment 1
INVESTMENT ACTIVITY INVESTMENT INCOME
PURCHASES OR DEPOSITS POOLED INVESTMENTS
Transfer to LAIF from CWB Money Market 30,000,000.00$ Interest Earned on Investments 33,970.12$ Total
Total 30,000,000.00$
SALES, MATURITIES, CALLS OR WITHDRAWALS
Transfer from CWB Money Market to LAIF (30,000,000.00)$ Total (30,000,000.00)$
ACTIVITY TOTAL -$ INCOME TOTAL 33,970.12$ City of Goleta
Investment Activity and Interest Report
March 31, 2022
5 Attachment 1
ENDING BALANCE AS OF FEBRUARY 28, 2022
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 3,096,962.09 $ 3,096,962.09 $ 3.889% 0.000% 1 Money Market Accounts 70,116,359.24 70,116,359.24 88.044% 0.710% 1 (1) Local Agency Investment Funds 1,468,351.56 1,464,591.29 1.844% 0.230% 1 (2) Certificates of Deposit 4,956,000.00 4,945,650.71$ 6.223% 1.780% 1684 Totals and Averages 79,637,672.89 79,623,563.33$ 100.000% 0.750% 106 Total Cash and Investments 79,637,672.89$
NET CASH AND INVESTMENT ACTIVITY FOR MARCH 2022
(750,265.84)$
ENDING BALANCE AS OF MARCH 31, 2022
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 1,216,832.54 $ 1,216,832.54 $ 1.542% 0.000% 1 Money Market Accounts (1) 40,742,722.95 40,742,722.95 51.647% 0.710% 1 Local Agency Investment Funds (2) 31,468,351.56 31,114,443.94 39.890% 0.320% 1 Certificates of Deposit 4,956,000.00 4,868,357.37 6.282% 1.780% 1684 U.S. BANK (PARS) 503,500.00 500,803.77 0.638% 0.000% 1 Totals and Averages 78,887,407.05$ 78,443,160.57$ 100.000% 0.606% 107 Total Cash and Investments 78,887,407.05$
Notes:
(1)
(2)
City of Goleta
Summary of Cash and Investments
March 31, 2022
Community West Bank serves as the City's primary banking institution. Interest earnings are guaranteed at a minimum rate 0.7098% per banking agreement for the money market account. The rate may be adjusted to match the higher of the Pooled Money Investment Account (PMIA) or quarterly Local Agency Investment Fund (LAIF) apportionment rate. All deposits held are required to be fully collateralized by State law. The City has a written collateralization agreement with Community West Bank to ensure the safety of public funds and utilizes an irrevocable letter of credit through the Federal Home Loan Bank of San Francisco.
For reporting purposes the LAIF yield displayed is the apportionment rate available at the time of preparing this report. The apportionment rate is the actual interest earned from LAIF and is based on the prior three-month average of the PMIA effective yield, net of administrative costs. As of FY 17/18 the quarterly apportionment rate includes interest earned on the CalPERS Supplemental Pensio n
Payment loan pursuant to Government Code 20825 (c)(1) and in FY 18/19 interest earned on Wildfire Fund loan pursuant to Public Utility Code 3288 (a), which are not reflected in the PMIA monthly effective yield, due to the structure of the loan.
6 City of Goleta
Investment Portfolio
March 31, 2022
Attachment 1
PURCHASE MATURITY DAYS TO STATED YIELD AT FACE BOOK MARKET** DATE DATE MATURITY RATE 365 VALUE VALUE VALUE
CHECKING ACCOUNTS
COMMUNITY WEST BANK GENERAL CHKING ACCT - - 1 0 0.000% 706,993.60 706,993.60 706,993.60 COMMUNITY WEST BANK GENERAL REV ACCT 1 0 0.000% - - - COMMUNITY WEST BANK PAYROLL CHKING ACCT 1 0 0.000% 277,124.30 277,124.30 277,124.30 PERSHING - SAFE KEEPING ACCT 0 0.000% 232,714.64 232,714.64 232,714.64 Subtotal, Checking Accounts 0.000% 0.000% 1,216,832.54$ 1,216,832.54 $ 1,216,832.54 $
MONEY MARKET ACCOUNTS
COMMUNITY WEST BANK MMA - - 1 0.7098% 0.7098% 40,742,722.95 40,742,722.95 40,742,722.95 Subtotal, MMA Account 1 0.7098% 0.7098% 40,742,722.95 $ 40,742,722.95 $ 40,742,722.95 $
LOCAL AGENCY INVESTMENT FUND
LOCAL AGENCY INVESTMENT FUND - - 1 0.320% 0.320% 31,468,351.56 31,468,351.56 31,114,443.94 Subtotal, LAIF 1 0.320% 0.320% 31,468,351.56 $ 31,468,351.56$ 31,114,443.94$
CERTIFICATES OF DEPOSIT
SALLIE MAE BK SLT LAKE CITY UT 8/1/2019 7/31/2022 1,095 2.150% 2.150% $247,000.00 $247,000.00 248,254.76 $ 7954503V5 ALLY BK SANDY UTAH CTF DEP 8/1/2019 7/31/2022 1,095 2.150% 2.150% $247,000.00 $247,000.00 248,348.62 $ 02007GLA9 MERRICK BANK 8/1/2019 7/31/2022 1,095 2.050% 2.050% $249,000.00 $249,000.00 250,259.94 $ 59013KBY1 MEDALLION BK UTAH 8/1/2019 7/31/2023 1,460 2.100% 2.100% $249,000.00 $249,000.00 250,693.20 $ 58404DEV9 CAPITAL ONE NA 8/1/2019 7/30/2024 1,825 2.250% 2.250% $247,000.00 $247,000.00 246,856.74 $ 14042RMU2 CAPITAL ONE BANK USA NA 8/1/2019 7/30/2024 1,825 2.250% 2.250% $247,000.00 $247,000.00 246,856.74 $ 14042TBQ9 ENERBANK USA 8/1/2019 7/30/2024 1,825 2.150% 2.150% $247,000.00 $247,000.00 246,293.58 $ 29278TKJ8 MORGAN STANLEY BANK NA 8/1/2019 7/30/2024 1,825 2.200% 2.200% $247,000.00 $247,000.00 246,567.75 $ 61690UJX9 MORGAN STANLEY PVT BANK 8/1/2019 7/30/2024 1,825 2.200% 2.200% $247,000.00 $247,000.00 246,567.75 $ 61760AS75 LIVE OAK BKG CO WILMINGTON NC 2/12/2020 8/12/2024 1,643 1.700% 1.700% $247,000.00 $247,000.00 243,700.08 $ 538036HY3 WASHINGTON FEDERAL 8/1/2019 7/30/2024 1,825 2.050% 2.050% $249,000.00 $249,000.00 247,588.17 $ 938828BJ8 WELLS FARGO BK N A SIOUX FALLS S D 1/29/2020 1/29/2025 1,827 1.950% 1.950% $247,000.00 $247,000.00 243,438.26 $ 949763T30 RAYMOND JAMES BK NATL ASSN ST PETERSBURG 2/18/2020 2/14/2025 1,823 1.750% 1.750% $247,000.00 $247,000.00 241,906.86 $ 75472RBB6 ENCORE BK LITTLE ROCK ARK CTF DEP 3/25/2020 3/25/2025 1,826 1.150% 1.150% $249,000.00 $249,000.00 239,035.02 $ 29260MAV7 POPPY BK SANTA ROSA CA CTF DEP 4/27/2020 3/27/2025 1,795 1.100% 1.100% $249,000.00 $249,000.00 238,644.09 $ 73319FAK5 AMERICAN EXPRESS NATL BK BROKERED INTL CTF4/16/2020 3/31/2025 1,810 1.550% 1.550% $248,000.00 $248,000.00 240,862.56 $ 02589AB68 PACIFIC ENTERPRISE BK IRVINE CA CTF DEP 4/30/2020 3/31/2025 1,796 1.150% 1.150% $249,000.00 $249,000.00 238,942.89 $ 694231AC5 STATE BK INDIA NEW YORK NY CTF DEP 5/15/2020 4/29/2025 1,810 1.600% 1.600% $248,000.00 $248,000.00 241,031.20 $ 856285TF8 TOYOTA FINANCIAL SAVINGS BANK HEND NV 10/14/2021 10/14/2026 1,826 1.050% 1.050% $247,000.00 $247,000.00 230,436.18 $ 89235MLU3 US BANK USA SALT LAKE CITY UT 10/27/2021 10/27/2026 1,826 1.050% 1.050% $249,000.00 $249,000.00 232,072.98 $ 90348JV56 Subtotal, Certificates of Deposit 1,684 1.780% 1.780% 4,956,000.00 $ 4,956,000.00 $ 4,868,357.37 $
PUBLIC AGENCY RETIREMENT SERVICES (PARS)
OPEB - Moderate Index Plus 2/4/2022 1 0.000% 333,500.00$ 333,500.00$ 331,714.11$ PENSION - Moderate Index Plus 2/4/2022 1 0.000% 170,000.00$ 170,000.00$ 169,089.66$ Subtotal 1 0.000% 503,500.00$ 503,500.00$ 500,803.77$ Total 78,887,407.05$ 78,887,407.05$ 83,311,517.94$
Notes:
* Comments for Certificates of Deposit represent the CUSIP Number (Committee on Uniform Securities Identification Procedures). * *Market Value on Certificates of Deposit have been obtained from the City's safekeeping agent, Pershing LLC, a subsidiary of The Bank of New York Mellon Corporation. Market value disclosure is for informational purposes only.
City policy is to hold all investments to maturity; therefore, any unrealized gain or loss reflected between the book value and market value of an investment will not be realized. **Market Value on U.S. Bank, Trustee for PARS: Account balances are inclusive of Trust Administration, Trustee and Investment Management fees.
DESCRIPTION COMMENTS *
7 ATTACHMENT 2:
Pooled Cash Report for the Quarter Ending March 31, 2022
8 TYLERHOST\SYSTEM Page 1 of 34.22.2022
Pooled Cash Report
City of Goleta, CA
For the Period Ending 3/31/2022
ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
CLAIM ON CASH
101-1010.000 Claim on Cash 36,140,949.32 (467,220.36) 35,673,728.96 201-1010.000 Claim on Cash 2,704,422.19 (94,229.86) 2,610,192.33 202-1010.000 Claim on Cash 199,906.29 3,845.33 203,751.62 203-1010.000 Claim on Cash 1,594,762.59 (54,382.18) 1,540,380.41 205-1010.000 Claim on Cash 4,209,646.75 142,590.91 4,352,237.66 206-1010.000 Claim on Cash (311,111.93) (130,308.63) (441,420.56) 208-1010.000 Claim on Cash 107,539.48 (76,148.53) 31,390.95 209-1010.000 Claim on Cash 102,376.71 (4,457.75) 97,918.96 210-1010.000 Claim on Cash 72,730.52 (4,494.52) 68,236.00 211-1010.000 Claim on Cash 1,319,830.79 59,749.86 1,379,580.65 212-1010.000 Claim on Cash 29,861.30 13.06 29,874.36
213-1010.000 Claim on Cash 110,712.23 (21,492.54) 89,219.69 214-1010.000 Claim on Cash 91,395.06 (22,492.98) 68,902.08 220-1010.000 Claim on Cash 11,337,414.36 946,940.15 12,284,354.51 221-1010.000 Claim on Cash 8,849,640.29 (132,878.90) 8,716,761.39 222-1010.000 Claim on Cash 256,028.63 111.96 256,140.59 223-1010.000 Claim on Cash 217,409.42 9,072.95 226,482.37 224-1010.000 Claim on Cash 109,829.57 30,883.60 140,713.17 225-1010.000 Claim on Cash 1,285,284.36 (24,448.90) 1,260,835.46 226-1010.000 Claim on Cash 172,610.12 75.48 172,685.60
229-1010.000 Claim on Cash 3,372,644.75 51,342.87 3,423,987.62 230-1010.000 Claim on Cash 190,933.91 (12,191.19) 178,742.72 231-1010.000 Claim on Cash 615,163.38 0.00 615,163.38
232-1010.000 Claim on Cash (12,105.80) (24,412.32) (36,518.12) 233-1010.000 Claim on Cash (285,000.00) 153,589.68 (131,410.32) 234-1010.000 Claim on Cash 533,411.35 233.25 533,644.60 235-1010.000 Claim on Cash 420,747.47 183.99 420,931.46 236-1010.000 Claim on Cash 45,727.47 (423.14) 45,304.33 237-1010.000 Claim on Cash (60,778.05) 0.00 (60,778.05) 302-1010.000 Claim on Cash (35,271.70) 24,122.29 (11,149.41) 304-1010.000 Claim on Cash 30,999.60 0.00 30,999.60
305-1010.000 Claim on Cash (415,736.17) 0.00 (415,736.17) 306-1010.000 Claim on Cash 443.68 (21,044.80) (20,601.12) 308-1010.000 Claim on Cash (4,309.08) 0.00 (4,309.08)
311-1010.000 Claim on Cash 10,408.71 0.00 10,408.71
317-1010.000 Claim on Cash (49,404.49) 0.00 (49,404.49) 318-1010.000 Claim on Cash (14,755.20) 0.00 (14,755.20) 319-1010.000 Claim on Cash (54,488.75) (8,026.25) (62,515.00) 320-1010.000 Claim on Cash 14,231.00 0.00 14,231.00
321-1010.000 Claim on Cash (687,751.41) 0.00 (687,751.41) 322-1010.000 Claim on Cash (314,143.86) (121,561.82) (435,705.68) 323-1010.000 Claim on Cash 52,958.00 0.00 52,958.00
324-1010.000 Claim on Cash (107,790.00) 0.00 (107,790.00) 325-1010.000 Claim on Cash 83,987.13 (9,810.40) 74,176.73 401-1010.000 Claim on Cash (163,014.38) (34,515.59) (197,529.97) 402-1010.000 Claim on Cash (45,633.16) (19,682.00) (65,315.16) 409-1010.000 Claim on Cash (4,537.01) 0.00 (4,537.01)
417-1010.000 Claim on Cash (9,134.99) 0.00 (9,134.99)
420-1010.000 Claim on Cash 58,107.00 0.00 58,107.00
421-1010.000 Claim on Cash (5,559.91) 0.00 (5,559.91)
423-1010.000 Claim on Cash 2,966,995.00 0.00 2,966,995.00 501-1010.000 Claim on Cash 731,547.74 (39,569.52) 691,978.22 502-1010.000 Claim on Cash 147,535.98 (23,327.13) 124,208.85 9 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 2 of 34.22.2022
503-1010.000 Claim on Cash 240,591.95 (93,497.17) 147,094.78 504-1010.000 Claim on Cash 27,812.52 680.45 28,492.97
605-1010.000 Claim on Cash 1,218,239.00 532.72 1,218,771.72 701-1010.000 Claim on Cash 150,023.61 65.60 150,089.21
801-1010.000 Claim on Cash 464,439.60 25,815.90 490,255.50 77,708,772.94 9,233.57 77,718,006.51TOTAL CLAIM ON CASH
CASH IN BANK
Cash in Bank
999-1012.000 Community West Cash Account 300,099.62 16,494.93 316,594.55 999-1013.000 CWB Revenue Cash Account 639,859.86 (638,293.89) 1,565.97 999-1080.000 LAIF 1,468,351.56 30,000,000.00 31,468,351.56 999-1082.000 Money Market-Community West 70,116,359.24 (29,373,636.29) 40,742,722.95 999-1083.000 Pershing C.D. 4,956,000.00 0.00 4,956,000.00 999-1083.001 Pershing Sweep Cash Account 228,102.66 4,668.82 232,771.48 TOTAL: Cash in Bank 77,708,772.94 9,233.57 77,718,006.51 77,708,772.94 9,233.57 77,718,006.51TOTAL CASH IN BANK
DUE TO OTHER FUNDS
Due to Other Funds 77,708,772.94 9,233.57 77,718,006.51999-2070.000 77,708,772.94 9,233.57 77,718,006.51TOTAL DUE TO OTHER FUNDS 77,718,006.51
77,718,006.51 77,718,006.51
Claim on Cash
Cash in Bank Due To Other Funds
Difference 0.00
77,718,006.51
0.00 77,718,006.51
77,718,006.51
0.00 Due To Other Funds
Difference Difference
Claim on Cash Cash in Bank
10 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 3 of 34.22.2022
ACCOUNTS PAYABLE PENDING
0.00TOTAL ACCOUNTS PAYABLE PENDING 0.00 0.00
DUE FROM OTHER FUNDS
TOTAL DUE FROM OTHER FUNDS 0.00 0.00 0.00
ACCOUNTS PAYABLE
TOTAL ACCOUNTS PAYABLE 0.00 0.00 0.00
0.00 0.00 0.00
AP Pending
Due From Other Funds Accounts Payable
Difference 0.00 0.00
0.00 0.00
0.00 Accounts Payable
Difference Difference
AP Pending 0.00 Due From Other Funds
11 ATTACHMENT 3:
Balance Sheets for the Quarter Ending March 31, 2022
12 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
General Fund Gas Tax Measure A
101 201 205
ASSETS
Cash & Investments
Claim on Cash 35,673,729 2,610,192 4,352,238 Petty Cash 1,316 - - Bond Discount - - - Cash with Fiscal Agent - - - Investments - - - Unrealized Gain/Loss on Investmen 78,720 6,665 9,722 Receivables - - - Accounts 41,378 - - RDA Settlement Receivable - - - Interest - - - Prepaid Expenditures - - - Security Deposit - - - Deposit - Earnest Money - - - Deposit - State Condemnation - - - Prepaid Items (Expenditures) 284,095 - - Prepaid Bond Insurance Premium - - - Deferred Loss on Refunding - - - TOTAL ASSETS 36,079,237 - 2,616,857 - 4,361,960
LIABILITIES
Accounts Payable - - - Accrued Salaries & Benefits 7,113 - - Retentions Payable 1,922 - 4,357 Accrued Expenses - - - Deferred Revenue 32,706 - - Interest Payable - - - Bond Payable - - - Bond Premium 764,196 - - Deferred Loss on Refunding - - - Deposit - Miscellaneous - - - Developer Deposit Payable - - - TOTAL LIABILITIES 805,936 - 4,357
FUND BALANCES
Non-spendable 74,711 - - Committed 11,065,624 - -
Assigned 503,500 - -
Unassigned Fund Balance 23,629,467 - - Fund Balance (Other Funds) - 2,616,857 4,357,603 TOTAL FUND BALANCE 35,273,301 2,616,857 4,357,603
TOTAL LIABILITIES &
FUND BALANCE 36,079,237 2,616,857 4,361,960 13 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
County Per
Capita - Goleta
County Per
Capita -
Buellton
County Per
Capita -
Solvang
208 209 210
31,391 97,919 68,236
- - -
- - -
- - -
- - -
852 310 263
- - -
- - -
- - -
- - -
13,609 - -
- - -
- - -
- - -
- - -
- - -
- - -
- 45,852 - 98,229 - 68,499 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
45,852 98,229 68,499
45,852 98,229 68,499
45,852 98,229 68,499
14 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
Solid Waste GTIP Parks DIF
211 220 221
1,379,581 12,284,355 8,716,761
- - -
- - -
- - -
- - -
2,055 34,405 26,313
- - -
- - -
- - -
- - -
7,049 - -
- - -
- - -
- 2,500,000 -
- 6,156 -
- - -
- - -
- 1,388,685 - 14,824,915 - 8,743,074 - - -
- - -
- - 19,801
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - 19,801
- - -
- - -
- - -
- - -
1,388,685 14,824,915 8,723,273
1,388,685 14,824,915 8,723,273
1,388,685 14,824,915 8,743,074
15 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
Public Facilities
DIF Library DIF Sheriff
Facilities DIF
222 223 224
256,141 226,482 140,713
- - -
- - -
- - -
- - -
738 730 317
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 256,879 - 227,212 - 141,030 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
256,879 227,212 141,030
256,879 227,212 141,030
256,879 227,212 141,030
16 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
Housing in Lieu Fire DIF
Long Range
Development
Plan (LRDP)
225 229 230
1,260,835 3,423,988 178,743
- - -
- - -
- - -
- - -
3,705 9,723 -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 1,264,540 - 3,433,711 - 178,743 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
1,264,540 3,433,711 178,743
1,264,540 3,433,711 178,743
1,264,540 3,433,711 178,743
17 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
Developer
Agreements County Fire DIF RSTP State
Grant
231 232 305
615,163 (36,518) (415,736)
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 615,163 - (36,518) - (415,736) - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
615,163 (36,518) (415,736)
615,163 (36,518) (415,736)
615,163 (36,518) (415,736)
18 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
STIP HBP CDBG
308 401 402
(4,309) (197,530) (65,315)
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- (4,309) - (197,530) - (65,315) - - -
- - -
- - -
- -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
(4,309) (197,530) (65,315)
(4,309) (197,530) (65,315)
(4,309) (197,530) (65,315)
19 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
RDA Successor-
NonHousing Other Funds TOTAL FUNDS
605 *
1,218,772 5,902,177 77,718,007
- 228 1,544 - - -
1,121 - 1,121
- 503,500 503,500
4,158 11,129 189,803 - - -
- (1,775,379) (1,734,001) 3,879,705 - 3,879,705 - - -
- 22,372 43,030
- - -
- - -
- - 2,500,000 - - 290,251 62,549 - 62,549
652,206 - 652,206
- 5,818,511 - 4,664,026 84,107,713 - - -
- - 7,113
- 2,640 28,719 - - -
- 40,000 72,706
106,396 - 106,396
- - -
- 926 765,122 11,760,000 - 11,760,000
1,447,399 - 1,447,399 - 667,533 667,533
13,313,795 711,099 14,854,988
- - 74,711 - - 11,065,624 - - 503,500 - - 23,629,467 (7,495,284) 3,952,927 33,979,424
(7,495,284) 3,952,927 69,252,725
5,818,511 4,664,026 84,107,713
20 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
*Other Funds Include:
202 Transportation
203 RMRA
206 Measure A- Other
212 Public Safety Donations
226 Environmental Programs
233 OBF - SCE
236 Misc Grans Library
237 Local Grants
301 State Park Grant
302 COPS - Public Safety Grant
304 Solid Waste - Recycling Grant
306 LSTP
311 Misc. Grant
314 SCG
317 SSARP Grant
318 ATP (State)
319 Housing and Community Developme
320 Cal OES
21 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2021
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Invest
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures
Security Deposit
Deposit - Earnest Money
Deposit - State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premium
Deferred Loss on Refunding
TOTAL ASSETS
LIABILITIES
Accounts Payable
Accrued Salaries & Benefits
Retentions Payable
Accrued Expenses
Deferred Revenue
Interest Payable
Bond Payable
Bond Premium
Deferred Loss on Refunding
Deposit - Miscellaneous
Developer Deposit Payable
TOTAL LIABILITIES
FUND BALANCES
Non-spendable
Committed
Assigned
Unassigned Fund Balance
Fund Balance (Other Funds)
TOTAL FUND BALANCE
TOTAL LIABILITIES &
FUND BALANCE
321 TIRCP
409 OTS Public afety Fund
417 Highway Safety Improvement Program
419 TIGER
420 FHWA - FEMA Reimb
421 HMGP - Hazard Mit Grant
423 ARPA
501 Library Services
502 Street Lighting
503 PEG
504 CASp Cert & Training
701 Plover Endowment
702 CASp Cert & Training
703 Plover Endowment
801 Developer Deposits
806 iBank
nt
22