Agenda Item A.2
CONSENT CALENDAR
Meeting Date: December 19, 2023
TO: Mayor and Councilmembers
FROM: Luke Rioux, Finance Director
SUBJECT: Acceptance of the September 2023 Investment Transaction Report RECOMMENDATION:
Accept the investment transaction report for the month of September 2023.
BACKGROUND:
Transmitted herewith is the investment transaction report for the month of September 2023.
The City Treasurer continue s to monitor idle cash balances with the help of the accountants in the Finance 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 comprehens ive report on the City’s portfolio and related activity pursuant to the City’s Investment Policy.
DISCUSSION:
Investment Transaction Report
As of September 30, 2023, the City‘s investment portfolio totaled $75,478,474.47. The City’s weighted average yield in September was 3.380%.
Attachment 1 contains the Investment Transaction Report, which includes the Investment Activity and Interest Report, Summary of Cash and Investments, and Investment Portfolio detail as of September 30, 2023.
Benchmark Comparisons
Figure 1 shows a 2-year interest rate trend chart that compares the City’s portfolio yield by quarter, compared to its benchmarks, the Local Agency Investment Fund (LAIF), and the 1- and 2 -Year US Treasury Notes. These benchmarks serve as indicators of the City’s performance. Trends over time that substantially deviate from these benchmarks would warrant further analysis and review.
1 Figure 1
(Note: The most recent LAIF apportionment rate is displayed for benchmark purposes.) As of September 30, 202 3, LAIF’s apportionment rate was at 3.59%, 1 Year US Treasury yield was at 5.46% and the 2 Year US Treasury yield was at 5.03%, compared to the City’s portfolio yield at 3.380%. By the end of the quarter Treasu ry yields were higher across the maturity terms of the yield curve. Since the prior quarter , the 1 Year US Treasury yield has increased from 5.40% to 5.46%, increasing by 6 basis points.
The 2 Year US Treasury yield has increased from 4.87% to 5.03%, increasing by 16 basis points. The LAIF daily rate is trending above 3.59% at the time of preparing this report (11/27/2023).
In the current interest rate environment, the City’s interest earning s are forecasted to gradually increase. Short-term and liqu id investments like local government investment pools and money market funds typically follow the Federal Funds Rate very closely. On July 26 th the Federal Open Market Committee (FOMC) increased the Federal Funds Rate by 25 basis points to the current range of 5.25% and 5.50%. The rate increase follows FOMC’s ongoing goal of combatting rising inflation while minimizing financial impacts to consumers, entities, and financial markets.
The pooled cash report is included as Attachment 2. Balance Sheets fo r the General Fund and all Special Funds are included as well, as Attachment 3. 2 Investment Program Update
On October 3rd, 2023, the City Council adopted the updated Investment Policy and authorized the continued annual delegation of authority to the Finance Director/City Treasurer to invest city funds in accordance with the Investment Policy. Since the start of the pandemic Finance staff has re -prioritized work efforts from further enhancing the City’s investment program to focus on other competing c ritical items, such as transitioning processes to function electronically and implementing the City’s financial software system. In addition, workload capacity was strained by staff turnover and vacancies. As staffing levels increase and workload capacity becomes available, staff will continue working on the investment program to incorporate the other allowable investments into its overall portfolio and continue building out its laddering program .
Staff anticipates this work effort to begin in January 2024.
Section 115 Trust Update
Staff have begun drafting a n ongoing funding strategy and investment policy for the Section 115 Trust . The City just received its June 30, 202 3, Actuarial Valuation Report in November 2023, which has the current projected retiree health liabilities. The next steps will include reviewing the updated liability information and recommending funding amounts for other employee benefit (OPEB) retiree health liabilities and pension liabilities. Staff will then discuss first with the Finance Committee for review and City Council for adoption of an ongoing funding strategy and policy.
FISCAL IMPACTS:
As of September 30, 2023, the investment portfolio complies with all State and Federal laws and the City’s Investment Policy. Sufficient funds are available to meet the City’s expenditure requirements for the next six months.
Reviewed by: Approved by:
_____________________ _____________________
Kristine Schmidt Robert Nisbet
Assistant City Manager City Manager
ATTACHMENTS:
1. Investment Transaction Report for September 30, 2023
2. Pooled Cash Report for the Quarter Ending September 30, 2023
3. Balance Sheets for the Quarter Ending September 30, 2023 3 ATTACHMENT 1
Investment Transaction Report September 2023
4 Attachment 1
INVESTMENT ACTIVITY INVESTMENT INCOME
PURCHASES OR DEPOSITS POOLED INVESTMENTS
Interest Earned on Investments 56,305.19$
Total
Total - $
SALES, MATURITIES, CALLS OR WITHDRAWALS
Total -$
ACTIVITY TOTAL -$ INCOME TOTAL 56,305.19 $ City of Goleta
Investment Activity and Interest Report
September 30, 2023
5 Attachment 1
ENDING BALANCE AS OF August 31, 2023
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 3,163,530.05 $ 3,163,530.05 $ 4.195% 0.000% 1 Money Market Accounts 19,477,120.91 19,477,120.91 25.830% 2.822% 1 (1) Local Agency Investment Funds 42,563,400.07 41,980,610.89 56.447% 2.740% 1 (2) Certificates of Deposit 5,200,000.00 4,668,862.51 $ 6.896% 1.960% 1794 United States Treasury Bill 4,999,538.83 5,004,212.40 $ 6.630% 5.366% 182 SUBTOTAL 75,403,589.86 74,294,336.76 100.000% 2.767% 124.583 Held by Fiscal Agent (US Bank - PARS) 503,500.00 482,573.70 $ 1 Held by Fiscal Agent (BNY Mellon) 899.57 899.57 $ 1 SUBTOTAL 504,399.57 483,473.27
Totals and Averages 75,907,989.43 74,777,810.03
Total Cash and Investments 75,907,989.43$
NET CASH AND INVESTMENT ACTIVITY FOR SEPTEMBER 2023
(429,514.96)$
ENDING BALANCE AS OF September 30, 2023
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 3,345,860.01 $ 3,345,860.01 $ 4.463% 0.000% 1 Money Market Accounts (1) 18,865,275.99 18,865,275.99 25.162% 3.425% 1 Local Agency Investment Funds (2) 42,563,400.07 41,980,610.89 56.771% 3.534% 1 Certificates of Deposit 5,200,000.00 4,928,761.43 6.936% 2.219% 1814 United States Treasury Bill $4,999,538.83 5,027,348.70 6.668% 5.366% 182 SUBTOTAL 74,974,074.90 74,147,857.02 100.000% 3.380% 126.692 Held by Fiscal Agent (US Bank - PARS) 503,500.00 465,836.87 1 Held by Fiscal Agent (BNY Mellon) 899.57 899.57 $ 1 SUBTOTAL 504,399.57 466,736.44
Totals and Averages 75,478,474.47$ 74,614,593.46$
Total Cash and Investments 75,478,474.47$
Notes:
(1)
(2)
City of Goleta
Summary of Cash and Investments
September 30, 2023
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
September 30, 2023
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% 2,920,347.46 2,920,347.46 2,920,347.46 COMMUNITY WEST BANK GENERAL REV ACCT 1 0 0.000% 297,686.51 297,686.51 297,686.51 COMMUNITY WEST BANK PAYROLL CHKING ACCT 1 0 0.000% 89.06 89.06 89.06 PERSHING - SAFE KEEPING ACCT 0 0.000% 127,736.98 127,736.98 127,736.98 Subtotal, Checking Accounts 0.000% 0.000% 3,345,860.01$ 3,345,860.01$ 3,345,860.01$
MONEY MARKET ACCOUNTS
COMMUNITY WEST BANK MMA - - 1 3.4250% 3.4250% 18,865,275.99 18,865,275.99 18,865,275.99 Subtotal, MMA Account 1 3.4250% 3.4250% 18,865,275.99 $ 18,865,275.99$ 18,865,275.99$
LOCAL AGENCY INVESTMENT FUND
LOCAL AGENCY INVESTMENT FUND - - 1 3.534% 3.534% 42,563,400.07 42,563,400.07 41,980,610.89 Subtotal, LAIF 1 3.534% 3.534% 42,563,400.07 $ 42,563,400.07$ 41,980,610.89$
CERTIFICATES OF DEPOSIT
CAPITAL ONE NA 8/7/2019 8/7/2024 1,827 2.250% 2.250% $247,000.00 $247,000.00 240,017.31$ 14042RMU2 CAPITAL ONE BANK USA NA 8/7/2019 8/7/2024 1,827 2.250% 2.250% $247,000.00 $247,000.00 240,017.31$ 14042TBQ9 ENERBANK USA 8/7/2019 8/7/2024 1,827 2.150% 2.150% $247,000.00 $247,000.00 239,812.30$ 29278TKJ8 MORGAN STANLEY BANK NA 8/8/2019 8/8/2024 1,827 2.200% 2.200% $247,000.00 $247,000.00 239,891.34$ 61690UJX9 MORGAN STANLEY PVT BANK 8/8/2019 8/8/2024 1,827 2.200% 2.200% $247,000.00 $247,000.00 239,891.34$ 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 238,742.79$ 538036HY3 WASHINGTON FEDERAL BK 8/23/2019 8/23/2024 1,827 2.050% 2.050% $249,000.00 $249,000.00 241,129.11$ 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 235,257.62$ 949763T30 RAYMOND JAMES BK NATL ASSN ST PETERSBURG 2/14/2020 2/14/2025 1,827 1.750% 1.750% $247,000.00 $247,000.00 234,331.37$ 75472RBB6 ENCORE BK LITTLE ROCK ARK CTF DEP 4/25/2020 3/25/2025 1,795 1.150% 1.150% $249,000.00 $249,000.00 233,064.00$ 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 232,829.94$ 73319FAK5 AMERICAN EXPRESS NATL BK BROKERED INTL CTF3/31/2020 3/31/2025 1,826 1.550% 1.550% $248,000.00 $248,000.00 233,578.80$ 02589AB68 PACIFIC ENTERPRISE BK IRVINE CA CTF DEP 3/31/2020 3/31/2025 1,826 1.150% 1.150% $249,000.00 $249,000.00 232,927.05$ 694231AC5 STATE BK INDIA NEW YORK NY CTF DEP 4/29/2020 4/29/2025 1,826 1.600% 1.600% $248,000.00 $248,000.00 233,055.52$ 856285TF8 ALLY BK SANDY UTAH CRF ACT/365 6/2/2022 6/2/2027 1,826 3.100% 3.100% $249,000.00 $249,000.00 234,575.43$ 02007GSH7 TOYOTA FINANCIAL SAVINGS BANK HEND NV 10/14/2021 10/14/2026 1,826 1.050% 1.050% $247,000.00 $247,000.00 217,322.95$ 89235MLU3 UBS BANK USA SALT LAKE CITY UT 10/27/2021 10/27/2026 1,826 1.050% 1.050% $249,000.00 $249,000.00 218,480.07$ 90348JV56 DISCOVER BK GREENWOOD DEL 6/1/2022 6/1/2027 1,826 3.200% 3.200% $245,000.00 $245,000.00 228,038.65$ 254673F76 FIRST TECHNOLOGY FED CREDIT UNION #19976 8/5/2022 8/5/2027 1,826 3.650% 3.650% $247,000.00 $247,000.00 233,088.96$ 33715LEB2 DORT FINANCIAL CREDIT UNION 6/20/2023 6/20/2028 1,827 4.500% 4.500% $247,000.00 $247,000.00 238,925.57$ 25844MBB3 BAXTER CREDIT UNION VERNON HILLS 8/22/2023 8/22/2028 1,827 5.000% 5.000% $248,000.00 $248,000.00 243,784.00$ 07181JBB9 Subtotal, Certificates of Deposit 1,814 2.219% 2.219% 5,200,000.00$ 5,200,000.00$ 4,928,761.43$
US TREASURY SECURITIES - DISCOUNT
UNITED STS TREAS BILLS 8/17/2023 2/15/2024 182 5.366% 5.366% $5,130,000.00 $4,999,538.83 5,027,348.70 $ 912797GN1 Subtotal, US Treasuries 182 5.366% 5.366% 5,130,000.00$ 4,999,538.83$ 5,027,348.70$ Total 75,104,536.07$ 74,974,074.90$ 74,147,857.02$ Held By Fiscal Agent (US Bank - PARS)
PUBLIC AGENCY RETIREMENT SERVICES (PARS) -
OPEB - Moderate Index Plus 2/4/2022 1 -0.940% 333,500.00$ 333,500.00 $ 308,553.31 $
PUBLIC AGENCY RETIREMENT SERVICES (PARS) -
PENSION - Moderate Index Plus 2/4/2022 1 -0.940% 170,000.00$ 170,000.00 $ 157,283.56 $ Subtotal 1 -0.940% 503,500.00 $ 503,500.00 $ 465,836.87 $ Total 503,500.00$ 503,500.00 $ 465,836.87 $ Held By Fiscal Agent (BNY Mellon)
Holding Account 1 899.57 $ 899.57 $ 899.57 $ Total 899.57$ 899.57 $ 899.57 $ Grand Total 75,608,935.64$ 75,478,474.47 $ 74,614,593.46 $ Notes:
DESCRIPTION COMMENTS *
7 ATTACHMENT 2:
Pooled Cash Report for the Quarter Ending September 30, 2023
8 TYLERHOST\SYSTEM Page 1 of 711.27.2023
Pooled Cash Report
City of Goleta, CA
For the Period Ending 9/30/2023
ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
CLAIM ON CASH
101-1010.000 Claim on Cash 37,686,947.93 (2,254,093.90) 35,432,854.03 102-1010.000 Claim on Cash 0.00 0.00 0.00
201-1010.000 Claim on Cash 1,395,729.59 0.00 1,395,729.59 202-1010.000 Claim on Cash 259,251.38 1,645.23 260,896.61 203-1010.000 Claim on Cash 767,338.79 68,746.42 836,085.21 205-1010.000 Claim on Cash 5,874,058.48 131,624.73 6,005,683.21 206-1010.000 Claim on Cash (721,401.89) (227,192.74) (948,594.63) 207-1010.000 Claim on Cash 0.00 0.00 0.00
208-1010.000 Claim on Cash 209,541.67 0.00 209,541.67
209-1010.000 Claim on Cash 178,449.90 (5,249.07) 173,200.83 210-1010.000 Claim on Cash 117,059.02 (8,352.52) 108,706.50 211-1010.000 Claim on Cash 1,563,237.02 132,206.68 1,695,443.70 212-1010.000 Claim on Cash 11,747.71 0.00 11,747.71
213-1010.000 Claim on Cash (21,492.01) (15,016.43) (36,508.44) 214-1010.000 Claim on Cash (29,052.79) (17,901.74) (46,954.53) 215-1010.000 Claim on Cash (213,430.80) (116,028.60) (329,459.40) 216-1010.000 Claim on Cash (14,799.48) (7,201.11) (22,000.59) 217-1010.000 Claim on Cash (8,273.16) (25,528.78) (33,801.94) 220-1010.000 Claim on Cash 8,207,701.34 (39,285.03) 8,168,416.31 221-1010.000 Claim on Cash 8,517,802.02 (284,073.39) 8,233,728.63 222-1010.000 Claim on Cash (2,408.61) 0.00 (2,408.61)
223-1010.000 Claim on Cash 170,283.76 0.00 170,283.76
224-1010.000 Claim on Cash 144,182.62 0.00 144,182.62
225-1010.000 Claim on Cash 1,266,850.26 0.00 1,266,850.26 226-1010.000 Claim on Cash 176,945.55 0.00 176,945.55
227-1010.000 Claim on Cash 0.00 0.00 0.00
228-1010.000 Claim on Cash 0.00 0.00 0.00
229-1010.000 Claim on Cash 3,494,806.88 0.00 3,494,806.88 230-1010.000 Claim on Cash 43,626.20 (19,489.63) 24,136.57 231-1010.000 Claim on Cash 615,163.38 0.00 615,163.38
232-1010.000 Claim on Cash (277,074.68) (1,420.00) (278,494.68) 233-1010.000 Claim on Cash 128,210.41 0.00 128,210.41
234-1010.000 Claim on Cash 522,657.77 (705.00) 521,952.77 235-1010.000 Claim on Cash 227,185.43 0.00 227,185.43
236-1010.000 Claim on Cash 34,822.81 17,607.00 52,429.81 237-1010.000 Claim on Cash (60,778.05) 0.00 (60,778.05) 238-1010.000 Claim on Cash 6,437.60 0.00 6,437.60
301-1010.000 Claim on Cash 0.00 0.00 0.00
302-1010.000 Claim on Cash 0.00 0.00 0.00
303-1010.000 Claim on Cash 0.00 0.00 0.00
304-1010.000 Claim on Cash 66,138.92 (2,947.62) 63,191.30 305-1010.000 Claim on Cash (420,350.11) 0.00 (420,350.11) 306-1010.000 Claim on Cash (220,140.09) 0.00 (220,140.09) 307-1010.000 Claim on Cash 0.00 0.00 0.00
308-1010.000 Claim on Cash (5,848.80) 0.00 (5,848.80)
309-1010.000 Claim on Cash 0.00 0.00 0.00
310-1010.000 Claim on Cash 0.00 0.00 0.00
311-1010.000 Claim on Cash 213,551.97 (137,568.45) 75,983.52 312-1010.000 Claim on Cash 0.00 0.00 0.00
313-1010.000 Claim on Cash 0.00 0.00 0.00
314-1010.000 Claim on Cash 0.00 0.00 0.00
315-1010.000 Claim on Cash 0.00 0.00 0.00
317-1010.000 Claim on Cash (53,481.99) 0.00 (53,481.99) Attachment 2
9 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 2 of 711.27.2023
318-1010.000 Claim on Cash (14,755.20) 0.00 (14,755.20) 319-1010.000 Claim on Cash (86,078.50) 0.00 (86,078.50) 320-1010.000 Claim on Cash 14,231.00 0.00 14,231.00
321-1010.000 Claim on Cash (338,112.06) 338,555.97 443.91 322-1010.000 Claim on Cash (1,249,815.96) 634,178.62 (615,637.34) 323-1010.000 Claim on Cash 5,520.86 (5,518.18) 2.68
324-1010.000 Claim on Cash 0.00 0.00 0.00
325-1010.000 Claim on Cash 0.00 0.00 0.00
401-1010.000 Claim on Cash (511,815.00) (29,360.02) (541,175.02) 402-1010.000 Claim on Cash (3,476.70) (47,839.59) (51,316.29) 403-1010.000 Claim on Cash 0.00 0.00 0.00
404-1010.000 Claim on Cash 0.00 0.00 0.00
405-1010.000 Claim on Cash 0.00 0.00 0.00
406-1010.000 Claim on Cash 0.00 0.00 0.00
407-1010.000 Claim on Cash 0.00 0.00 0.00
408-1010.000 Claim on Cash 0.00 0.00 0.00
409-1010.000 Claim on Cash (3,972.01) 0.00 (3,972.01)
410-1010.000 Claim on Cash 0.00 0.00 0.00
411-1010.000 ClaIm on Cash 0.00 0.00 0.00
412-1010.000 Claim on Cash 0.00 0.00 0.00
413-1010.000 Claim on Cash 0.00 0.00 0.00
414-1010.000 Claim on Cash 0.00 0.00 0.00
415-1010.000 Claim on Cash 0.00 0.00 0.00
416-1010.000 Claim on Cash 0.00 0.00 0.00
417-1010.000 Claim on Cash 5,636.00 0.00 5,636.00
418-1010.000 Claim on Cash 0.00 0.00 0.00
419-1010.000 Claim on Cash 0.00 0.00 0.00
420-1010.000 Claim on Cash 58,107.00 0.00 58,107.00
421-1010.000 Claim on Cash (1,217,467.15) (663,843.97) (1,881,311.12) 422-1010.000 Claim on Cash 0.00 0.00 0.00
423-1010.000 Claim on Cash 4,963,490.00 0.00 4,963,490.00 424-1010.000 Claim on Cash 0.00 0.00 0.00
501-1010.000 Claim on Cash 897,488.50 0.00 897,488.50
502-1010.000 Claim on Cash 236,099.68 0.00 236,099.68
503-1010.000 Claim on Cash 240,700.81 0.00 240,700.81
504-1010.000 Claim on Cash 36,937.98 420.00 37,357.98
605-1010.000 Claim on Cash 876,740.17 0.00 876,740.17
606-1010.000 Claim on Cash 0.00 0.00 0.00
607-1010.000 Claim on Cash 0.00 0.00 0.00
608-1010.000 Claim on Cash 0.00 0.00 0.00
701-1010.000 Claim on Cash 152,653.87 0.00 152,653.87
702-1010.000 Claim on Cash 0.00 0.00 0.00
703-1010.000 Claim on Cash 0.00 0.00 0.00
801-1010.000 Claim on Cash 529,918.93 57,842.18 587,761.11 74,443,228.17 (2,525,788.94) 71,917,439.23TOTAL CLAIM ON CASH
CASH IN BANK
Cash in Bank
999-1010.000 Cash 0.00 0.00 0.00
999-1011.000 Payroll Cash 0.00 0.00 0.00
999-1012.000 Community West Cash Account 2,167,457.74 (2,155,890.27) 11,567.47 999-1013.000 CWB Revenue Cash Account 4,327.42 295,243.99 299,571.41 999-1080.000 LAIF 42,563,400.07 0.00 42,563,400.07
999-1082.000 Money Market-Community West 19,404,231.56 (665,142.66) 18,739,088.90 999-1083.000 Pershing Investments 10,199,538.83 0.00 10,199,538.83 999-1083.001 Pershing Sweep Cash Account 104,272.55 0.00 104,272.55 999-1083.002 Pershing Investment-Unrealized Gain/Loss 0.00 0.00 0.00 TOTAL: Cash in Bank 74,443,228.17 (2,525,788.94) 71,917,439.23 Attachment 2
10 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 3 of 711.27.2023
74,443,228.17 (2,525,788.94) 71,917,439.23TOTAL CASH IN BANK
DUE TO OTHER FUNDS
Due to Other Funds 74,443,228.17 (2,525,788.94) 71,917,439.23999-2070.000 74,443,228.17 (2,525,788.94) 71,917,439.23TOTAL DUE TO OTHER FUNDS 71,917,439.23
71,917,439.23 71,917,439.23
Claim on Cash
Cash in Bank Due To Other Funds
Difference 0.00
71,917,439.23
0.00 71,917,439.23
71,917,439.23
0.00 Due To Other Funds
Difference Difference
Claim on Cash Cash in Bank
Attachment 2
11 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 4 of 711.27.2023
ACCOUNTS PAYABLE PENDING
Accounts Payable 66,941.02 0.00 66,941.02101-2020.000
Accounts Payable 0.00 0.00 0.00102-2020.000
Accounts Payable 0.00 0.00 0.00201-2020.000
Accounts Payable 0.00 0.00 0.00202-2020.000
Accounts Payable 0.00 0.00 0.00203-2020.000
Accounts Payable 0.00 0.00 0.00205-2020.000
Accounts Payable 0.00 0.00 0.00206-2020.000
Accounts Payable 0.00 0.00 0.00207-2020.000
Accounts Payable 0.00 0.00 0.00208-2020.000
Accounts Payable 0.00 250.18 250.18209-2020.000
Accounts Payable 0.00 0.00 0.00210-2020.000
Accounts Payable 0.00 0.00 0.00211-2020.000
Accounts Payable 0.00 0.00 0.00212-2020.000
Accounts Payable 0.00 0.00 0.00213-2020.000
Accounts Payable 0.00 0.00 0.00214-2020.000
Accounts Payable 0.00 0.00 0.00215-2020.000
Accounts Payable 0.00 0.00 0.00216-2020.000
Accounts Payable 0.00 0.00 0.00217-2020.000
Accounts Payable 0.00 0.00 0.00220-2020.000
Accounts Payable 0.00 0.00 0.00221-2020.000
Accounts Payable 0.00 0.00 0.00222-2020.000
Accounts Payable 0.00 0.00 0.00223-2020.000
Accounts Payable 0.00 0.00 0.00224-2020.000
Accounts Payable 0.00 0.00 0.00225-2020.000
Accounts Payable 0.00 0.00 0.00226-2020.000
Accounts Payable 0.00 0.00 0.00227-2020.000
Accounts Payable 0.00 0.00 0.00228-2020.000
Accounts Payable 0.00 0.00 0.00229-2020.000
Accounts Payable 0.00 0.00 0.00230-2020.000
Accounts Payable 0.00 0.00 0.00231-2020.000
Accounts Payable 0.00 0.00 0.00232-2020.000
Accounts Payable 0.00 0.00 0.00233-2020.000
Accounts Payable 0.00 0.00 0.00234-2020.000
Accounts Payable 0.00 0.00 0.00235-2020.000
Accounts Payable 0.00 0.00 0.00236-2020.000
Accounts Payable 0.00 0.00 0.00237-2020.000
Accounts Payable 0.00 0.00 0.00238-2020.000
Accounts Payable 0.00 0.00 0.00301-2020.000
Accounts Payable 0.00 0.00 0.00302-2020.000
Accounts Payable 0.00 0.00 0.00303-2020.000
Accounts Payable 0.00 0.00 0.00304-2020.000
Accounts Payable 0.00 0.00 0.00305-2020.000
Accounts Payable 0.00 0.00 0.00306-2020.000
Accounts Payable 0.00 0.00 0.00307-2020.000
Accounts Payable 0.00 0.00 0.00308-2020.000
Accounts Payable 0.00 0.00 0.00309-2020.000
Accounts Payable 0.00 0.00 0.00310-2020.000
Accounts Payable 0.00 0.00 0.00311-2020.000
Accounts Payable 0.00 0.00 0.00312-2020.000
Accounts Payable 0.00 0.00 0.00313-2020.000
Accounts Payable 0.00 0.00 0.00314-2020.000
Accounts Payable 0.00 0.00 0.00315-2020.000
Accounts Payable 0.00 0.00 0.00317-2020.000
Accounts Payable 0.00 0.00 0.00318-2020.000
Accounts Payable 0.00 0.00 0.00319-2020.000
Accounts Payable 0.00 0.00 0.00320-2020.000
Accounts Payable 0.00 0.00 0.00321-2020.000
Accounts Payable 0.00 0.00 0.00322-2020.000
Accounts Payable 0.00 0.00 0.00323-2020.000
Accounts Payable 0.00 0.00 0.00324-2020.000
Attachment 2
12 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 5 of 711.27.2023
Accounts Payable 0.00 0.00 0.00325-2020.000
Accounts Payable 0.00 0.00 0.00401-2020.000
Accounts Payable 0.00 0.00 0.00402-2020.000
Accounts Payable 0.00 0.00 0.00403-2020.000
Accounts Payable 0.00 0.00 0.00404-2020.000
Accounts Payable 0.00 0.00 0.00405-2020.000
Accounts Payable 0.00 0.00 0.00406-2020.000
Accounts Payable 0.00 0.00 0.00407-2020.000
Accounts Payable 0.00 0.00 0.00408-2020.000
Accounts Payable 0.00 0.00 0.00409-2020.000
Accounts Payable 0.00 0.00 0.00410-2020.000
Accounts Payable 0.00 0.00 0.00411-2020.000
Accounts Payable 0.00 0.00 0.00412-2020.000
Accounts Payable 0.00 0.00 0.00413-2020.000
Accounts Payable 0.00 0.00 0.00414-2020.000
Accounts Payable 0.00 0.00 0.00415-2020.000
Accounts Payable 0.00 0.00 0.00416-2020.000
Accounts Payable 0.00 0.00 0.00417-2020.000
Accounts Payable 0.00 0.00 0.00418-2020.000
Accounts Payable 0.00 0.00 0.00419-2020.000
Accounts Payable 0.00 0.00 0.00420-2020.000
Accounts Payable 0.00 0.00 0.00421-2020.000
Accounts Payable 0.00 0.00 0.00422-2020.000
Accounts Payable 0.00 0.00 0.00423-2020.000
Accounts Payable 0.00 0.00 0.00424-2020.000
Accounts Payable 0.00 0.00 0.00501-2020.000
Accounts Payable 0.00 0.00 0.00502-2020.000
Accounts Payable 0.00 0.00 0.00503-2020.000
Accounts Payable 0.00 0.00 0.00504-2020.000
Accounts Payable 0.00 0.00 0.00605-2020.000
Accounts Payable 0.00 0.00 0.00606-2020.000
Accounts Payable 0.00 0.00 0.00607-2020.000
Accounts Payable 0.00 0.00 0.00608-2020.000
Accounts Payable 0.00 0.00 0.00701-2020.000
Accounts Payable 0.00 0.00 0.00702-2020.000
Accounts Payable 0.00 0.00 0.00703-2020.000
Accounts Payable 0.00 0.00 0.00801-2020.000
66,941.02TOTAL ACCOUNTS PAYABLE PENDING 250.18 67,191.20
DUE FROM OTHER FUNDS
Due from General Fund (66,941.02) 0.00 (66,941.02)999-1310.101 Due from General Fund Reserves 0.00 0.00 0.00999-1310.102 Due from Vehicle Replace 0.00 0.00 0.00999-1310.198
Due from City Debt Service Fnd 0.00 0.00 0.00999-1310.199 Due from Gas Tax 0.00 0.00 0.00999-1310.201
Due from Transportation 0.00 0.00 0.00999-1310.202
Due from Road Maint Rehab Acct 0.00 0.00 0.00999-1310.203 Due from Measure D 0.00 0.00 0.00999-1310.205
Due from Measure A - Other 0.00 0.00 0.00999-1310.206
Due from Meas A SBCAG Light Ra 0.00 0.00 0.00999-1310.207 Due from County Per Capita 0.00 0.00 0.00999-1310.208
Due from County Per Capita 0.00 (250.18) (250.18)999-1310.209 Due from County Per Capita 0.00 0.00 0.00999-1310.210
Due from Solid Waste Fund 0.00 0.00 0.00999-1310.211
Due from Pub. Safety Donations 0.00 0.00 0.00999-1310.212 Due from Buellton Library 0.00 0.00 0.00999-1310.213
Due from Solvang Library 0.00 0.00 0.00999-1310.214
Due from Library Fund 0.00 0.00 0.00999-1310.215
Due from Library Book Van 0.00 0.00 0.00999-1310.216
Due from Goleta Community Center 0.00 0.00 0.00999-1310.217 Due from GTIP 0.00 0.00 0.00999-1310.220
Attachment 2
13 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 6 of 711.27.2023
Due from Park Development Fees 0.00 0.00 0.00999-1310.221 Due from Devel. Impact Fees 0.00 0.00 0.00999-1310.222
Due from Library Facilities DI 0.00 0.00 0.00999-1310.223 Due from Sherrif Facilities DI 0.00 0.00 0.00999-1310.224 Due from Housing In-Lieu Fund 0.00 0.00 0.00999-1310.225 Due from Environmental Program 0.00 0.00 0.00999-1310.226 Due from Mangement Habitat 0.00 0.00 0.00999-1310.227
Due from Housing In-Lieu-RDA 0.00 0.00 0.00999-1310.228 Due from Fire DIF Fund 0.00 0.00 0.00999-1310.229
Due from LRDP 0.00 0.00 0.00999-1310.230
Due from Developer Agreement 0.00 0.00 0.00999-1310.231 Due from County Fire DIF 0.00 0.00 0.00999-1310.232
Due from OBF - SCE 0.00 0.00 0.00999-1310.233
Due from Storm Drain DIF 0.00 0.00 0.00999-1310.234
Due from Bicycle & Ped DIF 0.00 0.00 0.00999-1310.235
Due from Other Funds Misc. Grt 0.00 0.00 0.00999-1310.236 Due from Local Grants 0.00 0.00 0.00999-1310.237
Due from Non-Residential Affordable Housing DIF 0.00 0.00 0.00999-1310.238 Due From Citywide CIP Fund 0.00 0.00 0.00999-1310.247
Due from State Park Fund 0.00 0.00 0.00999-1310.301
Due from Public Safety 0.00 0.00 0.00999-1310.302
Due from OTS Grant 0.00 0.00 0.00999-1310.303
Due from Solid Waste Grant 0.00 0.00 0.00999-1310.304
Due from RSTP - State Grant 0.00 0.00 0.00999-1310.305
Due from LSTP 0.00 0.00 0.00999-1310.306
Due from Environmental Justice 0.00 0.00 0.00999-1310.307 Due from STIP 0.00 0.00 0.00999-1310.308
Due from LSR - STATE GRANT 0.00 0.00 0.00999-1310.309
Due From Cal Fire Grant 0.00 0.00 0.00999-1310.310
Due from Other Funds Misc. Grt 0.00 0.00 0.00999-1310.311 Due from Other Funds SLPP 0.00 0.00 0.00999-1310.312
Due From Other Prop84 0.00 0.00 0.00999-1310.313
Due from Strategic Growh Counc 0.00 0.00 0.00999-1310.314 Due from State Water Grant 0.00 0.00 0.00999-1310.315
Due from SSARP Grant 0.00 0.00 0.00999-1310.317
Due from ATP-State 0.00 0.00 0.00999-1310.318
Due from Housing&Community Dev 0.00 0.00 0.00999-1310.319 Due from Cal-OES 0.00 0.00 0.00999-1310.320
Due from TIRCP 0.00 0.00 0.00999-1310.321
Due from MBHMP 0.00 0.00 0.00999-1310.322
Due from CALOES 0.00 0.00 0.00999-1310.323
Due from Planning Grants Program PGP 0.00 0.00 0.00999-1310.324 Due from Isla Vista Grant 0.00 0.00 0.00999-1310.325
Due from ISTEA 0.00 0.00 0.00999-1310.401
Due from CDBG 0.00 0.00 0.00999-1310.402
Due from Capital Improvement 0.00 0.00 0.00999-1310.403 Due from STIP 0.00 0.00 0.00999-1310.404
Due from LSTP 0.00 0.00 0.00999-1310.405
Due from RSTP-Fed Grant 0.00 0.00 0.00999-1310.406
Due from TCSP 0.00 0.00 0.00999-1310.407
Due from EPA Grant 0.00 0.00 0.00999-1310.408
Due from Public Safety Fund 0.00 0.00 0.00999-1310.409
Due from STE 0.00 0.00 0.00999-1310.410
Due from FEMA 0.00 0.00 0.00999-1310.411
Due from Winter Storm Prep 0.00 0.00 0.00999-1310.412
Due from 0.00 0.00 0.00999-1310.413
DUE FROM EECBG 0.00 0.00 0.00999-1310.414
Due from Fish Restoration 0.00 0.00 0.00999-1310.415
Due from BPMP 0.00 0.00 0.00999-1310.416
Due from HSIP 0.00 0.00 0.00999-1310.417
Due from ATP-Federal 0.00 0.00 0.00999-1310.418
Attachment 2
14 ACCOUNT # ACCOUNT NAME
BEGINNING
BALANCE
CURRENT
ACTIVITY
CURRENT
BALANCE
TYLERHOST\SYSTEM Page 7 of 711.27.2023
Due from TIGER 0.00 0.00 0.00999-1310.419
Due from FHWA - FEBA Reimb 0.00 0.00 0.00999-1310.420
Due from HMGP Hazard Mit Grant 0.00 0.00 0.00999-1310.421 Due from CARES 0.00 0.00 0.00999-1310.422
Due From State & Local Fiscal Recovery Fund 0.00 0.00 0.00999-1310.423 Due from Community Project Funding 0.00 0.00 0.00999-1310.424 Due from Library Fund 0.00 0.00 0.00999-1310.501
Due from St Light Assessmnt 0.00 0.00 0.00999-1310.502
Due from PEG 0.00 0.00 0.00999-1310.503
Due from CASp 0.00 0.00 0.00999-1310.504
Due from RDA Project 0.00 0.00 0.00999-1310.601
Due from RDA Housing 0.00 0.00 0.00999-1310.602
Due from RDA Debt Service 0.00 0.00 0.00999-1310.603
Due from RDA Bond Proceeds 0.00 0.00 0.00999-1310.604
Due from RDA Successor Agency 0.00 0.00 0.00999-1310.605 Due from LMI Successor Agency 0.00 0.00 0.00999-1310.606 DUE FROM SUCCESSOR DBT SVC 0.00 0.00 0.00999-1310.607
Due from IBank 0.00 0.00 0.00999-1310.608
Due from Comstock Plover Endow 0.00 0.00 0.00999-1310.701 Due from Section 115 Trust - Pension 0.00 0.00 0.00999-1310.702 Due from Section 115 Trust - OPEB 0.00 0.00 0.00999-1310.703 Due from Developer Deposit Fund 0.00 0.00 0.00999-1310.801 TOTAL DUE FROM OTHER FUNDS (66,941.02) (250.18) (67,191.20)
ACCOUNTS PAYABLE
Accounts Payable-Control 66,941.02 250.18 67,191.20999-2020.000 TOTAL ACCOUNTS PAYABLE 66,941.02 250.18 67,191.20
67,191.20
67,191.20 67,191.20
AP Pending
Due From Other Funds Accounts Payable
Difference 0.00 0.00
67,191.20
67,191.20
0.00 Accounts Payable
Difference Difference
AP Pending 67,191.20 Due From Other Funds
Attachment 2
15 ATTACHMENT 3:
Balance Sheets for the Quarter Ending September 30, 2023 16 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
General Fund Gas Tax Measure A County Per
Capita ‐ Goleta
County Per
Capita ‐
Buellton
101 201 205 208 209
ASSETS
Cash & Investments
Claim on Cash 35,432,854 1,395,730 6,005,683 209,542 173,201 Petty Cash 1,150 ‐ ‐ ‐ ‐ Bond Discount ‐ ‐ ‐ ‐ ‐ Cash with Fiscal Agent ‐ ‐ ‐ ‐ ‐ Investments
Unrealized Gain/Loss on Invest ‐ ‐ ‐ ‐ ‐ Receivables ‐ ‐ ‐ ‐ ‐ Accounts 442,845 ‐ ‐ ‐ ‐ RDA Settlement Receivable ‐ ‐ ‐ ‐ ‐ Interest ‐ ‐ ‐ ‐ ‐ Prepaid Expenditures (Other) ‐ ‐ ‐ ‐ ‐ Security Deposit ‐ ‐ ‐ ‐ ‐ Deposit ‐ Earnest Money ‐ ‐ ‐ ‐ ‐ Deposit ‐ State Condemnation ‐ ‐ ‐ ‐ ‐ Prepaid Items (Expenditures) 50,065 ‐ ‐ ‐ ‐ Prepaid Bond Insurance Premium ‐ ‐ ‐ ‐ ‐ Deferred Loss on Refunding ‐ ‐ ‐ ‐ ‐ TOTAL ASSETS 35,926,914 1,395,730 6,005,683 209,542 173,201
LIABILITIES
Accounts Payable 66,941 ‐ ‐ ‐ 250 Accrued Salaries & Benefits (1,907) ‐ ‐ ‐ ‐ Retentions Payable 123,961 64,582 26,028 ‐ ‐ Accrued Expenses ‐ ‐ ‐ ‐ ‐ Deferred Revenue 111,299 ‐ ‐ ‐ ‐ Interest Payable ‐ ‐ ‐ ‐ ‐ Bond Payable ‐ ‐ ‐ ‐ ‐ Bond Premium 936,906
‐ ‐ ‐ ‐ Deferred Loss on Refunding ‐ ‐ ‐ ‐ ‐ Deposit ‐ Miscellaneous ‐ ‐ ‐ ‐ ‐ Developer Deposit Payable ‐ ‐ ‐ ‐ ‐ TOTAL LIABILITIES 1,237,200 64,582 26,028 ‐ 250 FUND BALANCES
Non‐spendable 74,711 ‐ ‐ ‐ ‐ Committed 11,065,624 ‐ ‐ ‐ ‐ Assigned 503,500 ‐ ‐ ‐ ‐ Unassigned Fund Balance 23,045,879 ‐ ‐ ‐ ‐ Fund Balance (Other Funds) ‐ 1,331,148 5,979,655 209,542 172,951 TOTAL FUND BALANCE 34,689,714 1,331,148 5,979,655 209,542 172,951 TOTAL LIABILITIES &
FUND BALANCE 35,926,914 1,395,730 6,005,683 209,542 173,201 17 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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 ‐
Solvang
Solid Waste Library Fund Library Book
Van GTIP
210 211 215 216 220
108,707 1,695,444 (329,459) (22,001) 8,168,416 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 5,000 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2,578,900 ‐ ‐ ‐ ‐ 35,156 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 108,707 1,695,444 (329,459) (22,001) 10,787,472 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 8,198 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 8,198 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 108,707 1,695,444 (337,658) (22,001) 10,787,472 108,707 1,695,444 (337,658) (22,001) 10,787,472 108,707 1,695,444 (329,459) (22,001) 10,787,472 18 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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
Parks DIF Public Facilities
DIF Library DIF Sheriff
Facilities DIF Housing in Lieu
221 222 223 224 225
8,233,729 (2,409) 170,284 144,183 1,266,850 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 8,233,729 (2,409) 170,284 144,183 1,266,850 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 9,269 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 9,269 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 8,224,459 (2,409) 170,284 144,183 1,266,850 8,224,459 (2,409) 170,284 144,183 1,266,850 8,233,729 (2,409) 170,284 144,183 1,266,850 19 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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
Fire DIF
Long Range
Development
Plan (LRDP)
Developer
Agreements
County Fire
DIF
RSTP State
Grant
229 230 231 232 305
3,494,807 24,137 615,163 (278,495) (420,350) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐
‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 3,494,807 24,137 615,163 (278,495) (420,350) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 3,494,807 24,137 615,163 (278,495) (420,350) 3,494,807 24,137 615,163 (278,495) (420,350) 3,494,807 24,137 615,163 (278,495) (420,350) 20 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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 RDA Successor‐
NonHousing Other Funds
308 401 402 605 *
(5,849) (541,175) (51,316) 876,740 5,553,025 ‐ ‐ ‐ ‐ 228 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 900 ‐ 503,500
‐ ‐ ‐ ‐ (21,350) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 40,009 ‐ ‐ ‐ 2,327,823 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 80 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 57,207 ‐ ‐ ‐ ‐ 596,502 ‐ (5,849) (541,175) (51,316) 3,859,172 6,075,492 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 161,970 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 5,148,990 ‐ ‐ ‐ 39,496 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ (79,192) ‐ ‐ ‐ 11,025,000 ‐ ‐ ‐ ‐ 1,323,777 ‐ ‐ ‐ ‐ ‐ 853,206 ‐ ‐ ‐ 12,388,273 6,084,974 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ (5,849) (541,175) (51,316) (8,529,101) (9,482) (5,849) (541,175) (51,316) (8,529,101) (9,482) (5,849) (541,175) (51,316) 3,859,172 6,075,492 21 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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
TOTAL FUNDS
71,917,439
1,378
‐
900
503,500
(21,350)
‐
482,854
2,327,823
‐
80 5,000
‐
2,578,900
85,221
57,207
596,502
78,535,454
67,191
6,291
385,811
‐
5,260,289
39,496
‐
857,714
11,025,000
1,323,777
853,206
19,818,775
74,711
11,065,624
503,500
23,045,879
24,026,965
58,716,679
78,535,454
22 City of Goleta
Balance Sheet (Unaudited)
For the Quarter Ending September 30, 2023
Attachment 3
ASSETS
Cash & Investments
Claim on Cash
Petty Cash
Bond Discount
Cash with Fiscal Agent
Investments
Unrealized Gain/Loss on Inves
t
Receivables
Accounts
RDA Settlement Receivable
Interest
Prepaid Expenditures (Other)
Security Deposit
Deposit ‐ Earnest Money
Deposit ‐ State Condemnation
Prepaid Items (Expenditures)
Prepaid Bond Insurance Premiu
m
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
217 GCC
226 Environmental Programs
233 OBF ‐ SCE
236 Misc Grans Library
237 Local Grants
238 DIF Non‐Residential
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 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
23