Cities Index.
PFA Treasurer's Cash Statement Nov 1, 2021 through Oct 31, 2022

Diamond Bar City Council
December 6, 2022

Document
PFA Treasurer's Cash Statement Nov 1, 2021 through Oct 31, 2022
Meeting
December 6, 2022
Body
Diamond Bar City Council
Original file
435 KB
Text extracted from the city's file for reading and search. Open the original on diamondbarca.iqm2.com. That file is the official record.

CITY OF DIAMOND BAR

PUBLIC FINANCING AUTHORITY
Lease Revenue Refunding Bonds, 2021 Series A
Total Bonds Issued: $6,735,000
Transaction Summary for Fiscal Year Ended October 31, 2022 US Bank
Costs of Issuance Account #: -4003 (G/L Account #: 100-11000) Beginning Debt Svc Fees & Transfers-In Account
Date Balance Dividend Princ. & Int. Expenses & Other Balance November 2021 22,757.94 0.12 - - - 22,758.06
December 2021 22,758.06 0.11 - - (22,758.17) -
January 2022 - - - - - -
February 2022 - - - - - -
March 2022 - - - - - -
April 2022 - - - (17,000.00) 17,000.00 -
May 2022 - - - - - -
June 2022 - - - - - -
July 2022 - - - - - -
August 2022 - - - - - -
September 2022 - - - - - -
October 2022 - - - - - -
$ 0.23 $ - $ (17,000.00) $ (5,758.17) $ -
Total Cash with Fiscal Agent $ -

CITY OF DIAMOND BAR

PUBLIC FINANCING AUTHORITY
Lease Revenue Refunding Bonds, 2021 Series A
Total Bonds Issued: $6,735,000
Transaction Summary for Fiscal Year Ended October 31, 2022 US Bank
Interest Fund #: -4001 (G/L Account #: 100-11000)
Beginning Debt Svc Fees & Transfers-In Account
Date Balance Dividend Princ. & Int. Expenses & Other Balance November 2021 - - - - - -
December 2021 - - (128,713.33) - 151,471.50 22,758.17
January 2022 22,758.17 0.01 - - - 22,758.18
February 2022 22,758.18 0.12 - - - 22,758.30
March 2022 22,758.30 0.10 - - - 22,758.40
April 2022 22,758.40 0.12 - - (17,000.00) 5,758.52
May 2022 5,758.52 0.06 - - 128,941.42 134,700.00
June 2022 134,700.00 14.40 (134,700.00) - - 14.40
July 2022 14.40 0.01 - - - 14.41
August 2022 14.41 0.01 - - - 14.42
September 2022 14.42 0.02 - - - 14.44
October 2022 14.44 0.02 - - - 14.46
$ 14.87 $ (263,413.33) $ - $ 263,412.92 $ 14.46
Total Cash with Fiscal Agent $ 14.46

CITY OF DIAMOND BAR

PUBLIC FINANCING AUTHORITY
Lease Revenue Refunding Bonds, 2021 Series A
Total Bonds Issued: $6,735,000
Transaction Summary for Fiscal Year Ended October 31, 2022 US Bank
Principal Account #: -4002 (G/L Account #: 100-11000)
Beginning Debt Svc Fees & Transfers-In Account
Date Balance Dividend Princ. & Int. Expenses & Other Balance November 2021 - - - - - -
December 2021 - - - - -
January 2022 - - - - -
February 2022 - - - - -
March 2022 - - - - -
April 2022 - - - - -
May 2022 - - - 455,000.00 455,000.00
June 2022 455,000.00 41.87 (455,000.00) - - 41.87
July 2022 41.87 0.02 - - - 41.89
August 2022 41.89 0.04 - - - 41.93
September 2022 41.93 0.06 - - - 41.99
October 2022 41.99 0.07 42.06
$ 42.06 $ (455,000.00) $ - $ 455,000.00 $ 42.06
Total Cash with Fiscal Agent $ 42.06

PAYMENT DUE PRINCIPAL DUE INTEREST DUE TOTAL PAYMENT ENDING BALANCE

FY TOTAL

PAYMENTS
12/1/2022 $0.00 $125,600.00 $125,600.00 $6,280,000.00 FY 2023 6/1/2023 $465,000.00 $125,600.00 $590,600.00 $5,815,000.00 $716,200.00 12/1/2023 $0.00 $116,300.00 $116,300.00 $5,815,000.00 FY 2024 6/1/2024 $480,000.00 $116,300.00 $596,300.00 $5,335,000.00 $712,600.00 12/1/2024 $0.00 $106,700.00 $106,700.00 $5,335,000.00 FY 2025 6/1/2025 $505,000.00 $106,700.00 $611,700.00 $4,830,000.00 $718,400.00 12/1/2025 $0.00 $96,600.00 $96,600.00 $4,830,000.00 FY 2026 6/1/2026 $530,000.00 $96,600.00 $626,600.00 $4,300,000.00 $723,200.00 12/1/2026 $0.00 $86,000.00 $86,000.00 $4,300,000.00 FY 2027 6/1/2027 $550,000.00 $86,000.00 $636,000.00 $3,750,000.00 $722,000.00 12/1/2027 $0.00 $75,000.00 $75,000.00 $3,750,000.00 FY 2028 6/1/2028 $580,000.00 $75,000.00 $655,000.00 $3,170,000.00 $730,000.00 12/1/2028 $0.00 $63,400.00 $63,400.00 $3,170,000.00 FY 2029 6/1/2029 $605,000.00 $63,400.00 $668,400.00 $2,565,000.00 $731,800.00 12/1/2029 $0.00 $51,300.00 $51,300.00 $2,565,000.00 FY 2030 6/1/2030 $625,000.00 $51,300.00 $676,300.00 $1,940,000.00 $727,600.00 12/1/2030 $0.00 $38,800.00 $38,800.00 $1,940,000.00 FY 2031 6/1/2031 $650,000.00 $38,800.00 $688,800.00 $1,290,000.00 $727,600.00 12/1/2031 $0.00 $25,800.00 $25,800.00 $1,290,000.00 FY 2032 6/1/2032 $680,000.00 $25,800.00 $705,800.00 $610,000.00 $731,600.00 12/1/2032 $0.00 $12,200.00 $12,200.00 $610,000.00 FY 2033 6/1/2033 $610,000.00 $12,200.00 $622,200.00 $0.00 $634,400.00 $6,280,000.00 $1,595,400.00 $7,875,400.00

CITY OF DIAMOND BAR

PUBLIC FINANCING AUTHORITY
Lease Revenue Refunding Bonds, 2021 Series A
Total Bonds Issued: $6,735,000
Balances as of 10/31/2022

← All documents from this meeting