Agenda Item B.4
CONSENT CALENDAR
Meeting Date: February 15, 2022
TO: Mayor and Councilmembers
FROM: Luke Rioux, Finance Director
SUBJECT: Acceptance of the December 2021 Investment Transaction Report
RECOMMENDATION:
Accept the investment transaction report for the month of December 2021.
BACKGROUND:
Transmitted herewith is the invest ment transaction report for t he month of December 2021.
The City Treasurer continues to m onitor idle cash balances with the help of the accountants in the Finance Department, transferring cash betwee n 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 Ci ty’s portfolio and related activity pursuant to the City’s Investment Policy.
DISCUSSION:
Investment Transaction Report
As of December 31, 2021, the City’s investment portfolio totale d $76,820,093.65. The City’s weighted average yield in December was 0.755%.
Attachment 1 contains the Investment Transaction Report, which includes the Investment Activity and Intere st Report, Summary of Cash and In vestments, and Investment Portfolio detail as of December 31, 2021.
Benchmark Comparisons
Figure 1 shows a 2-year interest rate trend chart which compares the City’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 Cit y’s performance.
Trends over time that substantially deviate from these benchmar ks would warrant further analysis and review.
1 Meeting Date: February 15, 2022
2 Figure 1
(Note: The most recent LAIF apportionment rate is displayed for benchmark purposes.)
As of December 31, 2021, LAIF’ s apportionment rate was at 0.24% , 1 Year US Treasury Yield was at 0.39% and t he 2 Year US Treasury Yield wa s at 0.73%, compared to the City’s portfolio yield at 0.755%.
It should be noted that through t he end of the quarter, the Fed eral Reserve (Fed) kept interest rates unchanged, with t he federal funds rate, which in turn influences Treasury yields, at a range of 0 percent t o 0.25 percent (effectively ze ro). However at a recent Federal Open Market Committee (FOMC) meeting, the Fed indicated as an acknowledgement of improving fi nancial conditions and accelerat ing inflation, the Fed has started to withdraw some of the monetary accommodations int roduced during the pandemic, by slowing the pace of their monthly bond purchase (a process called “tapering”) and has signaled the intention to start raising interest rates as soon as March 2022. As a reaction to the Fed’s action and announcement, inter est rates across the yield curve have started to mov e higher. More information will be known in the March Investment Transaction Report.
The pooled cash report is included as Attachment 2. Balance She ets for the General Fund and all Special Funds are included as well, as Attachment 3.
Investment Program Update
Since the start of the pandemic Finance staff has had to re-pri oritize its work efforts from further enhancing its invest ment program and focus on othe r competing critical 2 Meeting Date: February 15, 2022
3 items, such as transitioning pr ocesses electronically and implementing the financial software system. In addition, workload capacity was strained wi th changes in staff and vacancies. As staffing levels begin to increase and workload ca pacity becomes available, staff will continue its work on the investment progr am to incorporate the other allowable investments into its overall portfolio. Staff anticip ates this work effort to begin in 2022 when the new Management Assistant is expected to start and provide additional support.
Section 115 Trust Update
Staff is near completion of establishing and funding its Section 115 Trusts with PARS to help address future costs incr eases associated with pension and retiree health care costs. Staff has initiated the transfer of funds held in reserves to the trusts. Next steps with the Section 115 Trust will include reviewing and adoption an ongoing funding strategy and policy. Given the current staff capacity, it is an ticipated this work effort will start in 2022 when the new Management Assistant is expected to start and provide additional support.
FISCAL IMPACTS:
As of December 31, 2021, the inve stment portfolio is in complia nce with all State laws and the City’s Investment Policy. There are sufficient funds av ailable 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 December 2021
2. Pooled Cash Report for the Quarter Ending December 31, 2021
3. Balance Sheets for the Quarter Ending December 31, 2021 3 ATTACHMENT 1
Investment Transaction Report December 2021
4 Attachment 1
INVESTMENT ACTIVITY INVESTMENT INCOME
PURCHASES OR DEPOSITS POOLED INVESTMENTS
Interest Earned on Investments 43,873.67$
Total
Total -$
SALES, MATURITIES, CALLS OR WITHDRAWALS
Total -$
ACTIVITY TOTAL -$ INCOME TOTAL 43,873.67$ City of Goleta
Investment Activity and Interest Report
December 31, 2021
5 Attachment 1
ENDING BALANCE AS OF NOVEMBER 30, 2021
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 2,216,220.93$ 2,216,220.93$ 2.927% 0.000% 1 Money Market Accounts 67,086,818.30 67,086,818.30 88.591% 0.710% 1 (1) Local Agency Investment Funds 1,467,506.87 1,467,321.47 1.938% 0.240% 1 (2) Certificates of Deposit 4,956,000.00 5,058,506.20$ 6.545% 1.780% 1630 Totals and Averages 75,726,546.10 75,828,866.90$ 100.000% 0.750% 108 Total Cash and Investments 75,726,546.10$
NET CASH AND INVESTMENT ACTIVITY FOR DECEMBER 2021
1,093,547.55$
ENDING BALANCE AS OF DECEMBER 31, 2021
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 1,568,920.12$ 1,568,920.12$ 2.042% 0.000% 1 Money Market Accounts (1) 68,827,666.66 68,827,666.66 89.596% 0.710% 1 Local Agency Investment Funds (2) 1,467,506.87 1,467,321.47 1.910% 0.240% 1 Certificates of Deposit 4,956,000.00 5,051,515.26 6.451% 1.780% 1684 Totals and Averages 76,820,093.65$ 76,915,423.51$ 100.000% 0.755% 110 Total Cash and Investments 76,820,093.65$
Notes:
(1)
(2)
City of Goleta
Summary of Cash and Investments
December 31, 2021
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 Pension 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
December 31, 2021
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% 1,366,533.36 1,366,533.36 1,366,533.36 COMMUNITY WEST BANK GENERAL REV ACCT 1 0 0.000% 1,632.18 1,632.18 1,632.18 COMMUNITY WEST BANK PAYROLL CHKING ACCT 1 0 0.000% - - - PERSHING - SAFE KEEPING ACCT 0 0.000% 200,754.58 200,754.58 200,754.58 Subtotal, Checking Accounts 0.000% 0.000% 1,568,920.12$ 1,568,920.12$ 1,568,920.12$
MONEY MARKET ACCOUNTS
COMMUNITY WEST BANK MMA - - 1 0.7098% 0.7098% 68,827,666.66 68,827,666.66 68,827,666.66 Subtotal, MMA Account 1 0.7098% 0.7098% 68,827,666.66$ 68,827,666.66$ 68,827,666.66$
LOCAL AGENCY INVESTMENT FUND
LOCAL AGENCY INVESTMENT FUND - - 1 0.240% 0.240% 1,467,506.87 1,467,506.87 1,467,321.47 Subtotal, LAIF 1 0.240% 0.240% 1,467,506.87$ 1,467,506.87$ 1,467,321.47$
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 249,647.84$ 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 249,818.27$ 02007GLA9 MERRICK BANK 8/1/2019 7/31/2022 1,095 2.050% 2.050% $249,000.00 $249,000.00 251,689.20$ 59013KBY1 M
EDALLION BK UTAH 8/1/2019 7/31/2023 1,460 2.100% 2.100% $249,000.00 $249,000.00 255,227.49$ 58404DEV9 CAPITAL ONE NA 8/1/2019 7/30/2024 1,825 2.250% 2.250% $247,000.00 $247,000.00 256,215.57$ 14042RMU2 CAPITAL ONE BANK USA NA 8/1/2019 7/30/2024 1,825 2.250% 2 .250% $247,000.00 $247,000.00 256,215.57$ 14042TBQ9 ENERBANK USA 8/1/2019 7/30/2024 1,825 2.150% 2.150% $247,000.00 $247,000.00 255,578.31$ 29278TKJ8 MORGAN STANLEY BANK NA 8/1/2019 7/30/2024 1,825 2.200% 2.200% $247,000.00 $247,000.00 255,901.88$ 61690UJX9 MORGAN STANLEY PVT BANK 8/1/2019 7/30/2024 1,825 2.200% 2.200% $247,000.00 $247,000.00 255,901.88$ 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 252,730.40$ 538036HY3 WASHINGTON FEDERAL 8/1/2019 7/30/2024 1,825 2.050% 2.050% $249,000.00 $249,000.00 257,075.07$ 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 254,590.31$ 949763T30 RAYMOND JAMES BK NATL ASSN ST PETERSBURG2/18/2020 2/14/2025 1,823 1.750% 1.750% $247,000.00 $247,000.00 253,231.81$ 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 250,553.76$ 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 250,150.38$ 73319FAK5 AMERICAN EXPRESS NATL BK BROKERED INTL CT 4/16/2020 3/31/2025 1,810 1.550% 1.550% $248,000.00 $248,000.00 252,687.20$ 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 250,531.35$ 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 253,054.24$ 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 244,416.38$ 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 246,298.35$ 90348JV56 Subtotal, Certificates of Deposit 1,684 1.780% 1.780% 4,956,000.00$ 4,956,000.00$ 5,051,515.26$ Total 76,820,093.65$ 76,820,093.65$ 76,915,423.51$
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.
DESCRIPTION COMMENTS *
7 ATTACHMENT 2:
Pooled Cash Report for the Quarter Ending December 31, 2021
8 TYLERHOST\SYSTEM Page 1 of 31.19.2022
Pooled Cash Report
City of Goleta, CA
For the Period Ending 12/31/2021
ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
CLAIM ON CASH
101-1010.000 Claim on Cash 33,448,962.43 1,041,872.41 34,490,834.84 201-1010.000 Claim on Cash 2,609,777.32 57,959.21 2,667,736.53 202-1010.000 Claim on Cash 188,160.36 3,084.11 191,244.47 203-1010.000 Claim on Cash 1,436,664.33 51,700.14 1,488,364.47 205-1010.000 Claim on Cash 3,785,772.46 161,844.13 3,947,616.59 206-1010.000 Claim on Cash (105,870.29) (5,036.79) (110,907.08) 208-1010.000 Claim on Cash (41,396.39) (85,468.97) (126,865.36) 209-1010.000 Claim on Cash 65,242.66 (2,472.54) 62,770.12 210-1010.000 Claim on Cash 46,023.79 (3,182.96) 42,840.83 211-1010.000 Claim on Cash 1,234,883.08 (21,363.99) 1,213,519.09 212-1010.000 Claim on Cash 29,802.79 0.00 29,802.79
213-1010.000 Claim on Cash 182,058.61 (22,729.70) 159,328.91 214-1010.000 Claim on Cash 150,478.76 (27,008.23) 123,470.53 220-1010.000 Claim on Cash 11,426,851.98 (137,310.56) 11,289,541.42 221-1010.000 Claim on Cash 9,091,989.08 (180,782.92) 8,911,206.16 222-1010.000 Claim on Cash 255,526.84 0.00 255,526.84
223-1010.000 Claim on Cash 222,084.65 (3,362.39) 218,722.26 224-1010.000 Claim on Cash 109,614.32 0.00 109,614.32
225-1010.000 Claim on Cash 1,282,765.33 0.00 1,282,765.33 226-1010.000 Claim on Cash 172,271.82 0.00 172,271.82
229-1010.000 Claim on Cash 3,359,228.65 (140.00) 3,359,088.65 230-1010.000 Claim on Cash 190,559.69 0.00 190,559.69
231-1010.000 Claim on Cash 615,163.38 0.00 615,163.38
232-1010.000 Claim on Cash (156,385.86) (25,225.50) (181,611.36) 233-1010.000 Claim on Cash (285,000.00) 0.00 (285,000.00) 234-1010.000 Claim on Cash 526,946.83 0.00 526,946.83
235-1010.000 Claim on Cash 419,922.84 0.00 419,922.84
236-1010.000 Claim on Cash 43,426.11 (8,180.28) 35,245.83 237-1010.000 Claim on Cash (60,778.05) 0.00 (60,778.05) 302-1010.000 Claim on Cash (72,675.53) 12,030.76 (60,644.77) 304-1010.000 Claim on Cash 30,999.60 0.00 30,999.60
305-1010.000 Claim on Cash (353,362.92) (29,910.75) (383,273.67) 306-1010.000 Claim on Cash 443.68 0.00 443.68
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 (26,451.49) (9,167.50) (35,618.99) 320-1010.000 Claim on Cash 14,231.00 0.00 14,231.00
321-1010.000 Claim on Cash (224,168.00) (150,720.82) (374,888.82) 322-1010.000 Claim on Cash (211,381.82) (6,210.00) (217,591.82) 323-1010.000 Claim on Cash 72,945.00 (19,987.00) 52,958.00 324-1010.000 Claim on Cash (107,790.00) 0.00 (107,790.00) 325-1010.000 Claim on Cash 120,731.17 (8,172.17) 112,559.00 401-1010.000 Claim on Cash (138,019.02) 0.00 (138,019.02) 402-1010.000 Claim on Cash (29,620.52) (252.70) (29,873.22) 409-1010.000 Claim on Cash (10,038.00) 0.00 (10,038.00) 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 651,753.85 145,923.43 797,677.28 502-1010.000 Claim on Cash 26,327.85 164,999.04 191,326.89 9 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 2 of 31.19.2022
503-1010.000 Claim on Cash 224,117.67 0.00 224,117.67
504-1010.000 Claim on Cash 26,209.25 354.80 26,564.05
605-1010.000 Claim on Cash 763,142.62 0.00 763,142.62
701-1010.000 Claim on Cash 149,729.58 0.00 149,729.58
801-1010.000 Claim on Cash 463,520.96 20,911.17 484,432.13 74,567,739.49 913,993.43 75,481,732.92TOTAL CLAIM ON CASH
CASH IN BANK
Cash in Bank
999-1012.000 Community West Cash Account 9,190.99 62,574.76 71,765.75 999-1013.000 CWB Revenue Cash Account 850,340.36 (848,484.47) 1,855.89 999-1080.000 LAIF 1,467,506.87 0.00 1,467,506.87
999-1082.000 Money Market-Community West 67,086,818.30 1,699,903.14 68,786,721.44 999-1083.000 Pershing C.D. 4,956,000.00 0.00 4,956,000.00 999-1083.001 Pershing Sweep Cash Account 197,882.97 0.00 197,882.97 TOTAL: Cash in Bank 74,567,739.49 913,993.43 75,481,732.92 74,567,739.49 913,993.43 75,481,732.92TOTAL CASH IN BANK
DUE TO OTHER FUNDS
Due to Other Funds 74,567,739.49 913,993.43 75,481,732.92999-2070.000 74,567,739.49 913,993.43 75,481,732.92TOTAL DUE TO OTHER FUNDS 75,481,732.92
75,481,732.92 75,481,732.92
Claim on Cash
Cash in Bank Due To Other Funds
Difference 0.00
75,481,732.92
0.00 75,481,732.92
75,481,732.92
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 31.19.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 December 31, 2021
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 34,490,835 2,667,737 3,947,617 Petty Cash 1,316 - - Bond Discount - - - Cash with Fiscal Agent - - - Unrealized Gain/Loss on Investment 78,720 6,665 9,722 Receivables - - - Accounts 36,501 - - RDA Settlement Receivable - - - Interest - - - Security Deposit - - - Deposit - Earnest Money - - - Deposit - State Condemnation - - - Prepaid Items (Expenditures) 10,000 - - Prepaid Bond Insurance Premium - - - Deferred Loss on Refunding - - - TOTAL ASSETS 34,617,372 - 2,674,402 - 3,957,339
LIABILITIES
Accounts Payable - - - Accrued Salaries & Benefits 14,851 - - Retentions Payable 1,922 - 4,357 Accrued Expenses - - - Deferred Revenue 32,706 - - Interest Payable - - - Bond Payable - - - Bond Premium 736,470 - - Deferred Loss on Refunding - - - Deposit - Miscellaneous - - - Developer Deposit Payable - - - TOTAL LIABILITIES 785,949 - 4,357
FUND BALANCES
Non-spendable 74,711 - - Committed 11,065,624 - -
Assigned 503,500 - - Unassigned Fund Balance 22,187,589 - - Fund Balance (Other Funds) - 2,674,402 3,952,982 TOTAL FUND BALANCE 33,831,423 2,674,402 3,952,982
TOTAL LIABILITIES &
FUND BALANCE 34,617,372 2,674,402 3,957,339 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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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
(126,865) 62,770 42,841
- - -
- - -
- - -
852 310 263
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- (126,014) - 63,080 - 43,103 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
(126,014) 63,080 43,103
(126,014) 63,080 43,103
(126,014) 63,080 43,103
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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,213,519 11,289,541 8,911,206
- - -
- - -
- - -
2,055 34,405 26,313
- - -
- - -
- - -
- - -
- - -
- - -
- 2,500,000 -
- 6,156 -
- - -
- - -
- 1,215,574 - 13,830,102 - 8,937,519 - - -
- - -
- - 9,382
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - 9,382
- - -
- - -
- - -
- - -
1,215,574 13,830,102 8,928,137
1,215,574 13,830,102 8,928,137
1,215,574 13,830,102 8,937,519
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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
255,527 218,722 109,614
- - -
- - -
- - -
738 730 317
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 256,265 - 219,452 - 109,931 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
256,265 219,452 109,931
256,265 219,452 109,931
256,265 219,452 109,931
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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,282,765 3,359,089 190,560
- - -
- - -
- - -
3,705 9,723 -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 1,286,470 - 3,368,812 - 190,560 - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
1,286,470 3,368,812 190,560
1,286,470 3,368,812 190,560
1,286,470 3,368,812 190,560
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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 (181,611) (383,274)
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- 615,163 - (181,611) - (383,274) - - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
615,163 (181,611) (383,274)
615,163 (181,611) (383,274)
615,163 (181,611) (383,274)
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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) (138,019) (29,873)
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- (4,309) - (138,019) - (29,873) - - -
- - -
- - -
- -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
(4,309) (138,019) (29,873)
(4,309) (138,019) (29,873)
(4,309) (138,019) (29,873)
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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 *
763,143 6,925,036 75,481,733
- 228 1,544 - - -
1,121 - 1,121 4,158 11,129 189,803 - - -
- (1,775,379) (1,738,878) 3,879,705 - 3,879,705 - - -
- - -
- - -
- - 2,500,000 - - 16,156 62,549 - 62,549 652,206 - 652,206 - 5,362,882 - 5,161,014 81,045,939 - - -
- - 14,851 - 2,640 18,300 - - -
- 40,000 72,706 106,396 - 106,396 - - -
- (35,843) 700,627 11,760,000 - 11,760,000 1,447,399 - 1,447,399 - 696,616 696,616 13,313,795 703,413 14,816,895
- - 74,711 - - 11,065,624 - - 503,500 - - 22,187,589 (7,950,913) 4,457,601 32,397,620
(7,950,913) 4,457,601 66,229,044
5,362,882 5,161,014 81,045,939
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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)
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
Unrealized Gain/Loss on Investm
Receivables
Accounts
RDA Settlement Receivable
Interest
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
319 Housing and Community Development
320 Cal OES
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
801 Developer Deposits
806 iBank
22