City of Point Arena
Cash Flow worksheet
Actuals through November
Projections using budget
2023-24 Capital Total
General Gas Tax RLF Projects Governmental
Beginning cash, July 1, $ 51,581 $ - $ 48,367 $ - $ 99,948 Cash Received 773,522 30,445 280,426 134,071 1,218,463
Cash Disbursed (850,360) - (214,860) (48,520) (1,113,739) Transfers 30,445 (30,445) - -
Ending Cash, June 30 $ 5,188 $ - $ 113,933 $ 85,551 $ 204,672 Cash Received
July 46,082.91 2,345.45 2,200.53 - 50,628.89
August 5,201.06 4,917.21 117,142.05 - 127,260.32
September 49,480.27 967.22 1,819.94 - 52,267.43
October 112,398.72 4,031.99 5,168.31 - 121,599.02
November 34,094.46 1,048.29 900.65 4,140.50 40,183.90
December 15 116,960.73 1,531.69 1,305.70 - 119,798.12
December 31 36,712.59 - - - 36,712.59
January 83,376.00 3,639.00 1,820.00 - 88,835.00
February 32,000.00 842.00 39,041.00 91,293.00 163,176.00 March 86,983.00 3,200.00 1,306.00 - 91,489.00
April 58,000.00 3,038.00 78,452.00 139,490.00
May 50,475.00 2,345.00 10,882.00 - 63,702.00
June 61,757.00 2,539.00 20,388.00 38,637.00 123,321.00
Total 773,521.74 30,444.85 280,426.18 134,070.50 1,218,463.27 Cash Disbursed
July (71,511.79) - (3,978.86) (3,258.63) (78,749.28)
August (85,122.86) - (108,733.50) (4,639.65) (198,496.01) September (146,264.62) - (2,062.50) (7,625.10) (155,952.22) October (79,795.63) - (1,250.00) (341.72) (81,387.35)
November (50,043.81) - - (5,962.14) (56,005.95)
December 15 (24,548.02) - - (176.04) (24,724.06)
December 31 (12,658.30) - - (10.22) (12,668.52)
January (60,383.00) - (17,219.00) (3,139.00) (80,741.00) February (72,638.00) - (5,990.00) (6,086.00) (84,714.00) March (64,292.00) - (8,904.00) (1,018.00) (74,214.00)
April (86,856.00) - (2,625.00) (2,300.00) (91,781.00)
May (49,575.00) - (45,772.00) (2,297.00) (97,644.00)
June (46,671.00) - (18,325.00) (11,666.00) (76,662.00)
Total (850,360.03) - (214,859.86) (48,519.50) (1,113,739.39) Over (under)
July (25,428.88) 2,345.45 (1,778.33) (3,258.63) (28,120.39) August (79,921.80) 4,917.21 8,408.55 (4,639.65) (71,235.69) September (96,784.35) 967.22 (242.56) (7,625.10) (103,684.79) October 32,603.09 4,031.99 3,918.31 (341.72) 40,211.67
November (15,949.35) 1,048.29 900.65 (1,821.64) (15,822.05) December 15 92,412.71 1,531.69 1,305.70 (176.04) 95,074.06 December 31 24,054.29 - - (10.22) 24,044.07
January 22,993.00 3,639.00 (15,399.00) (3,139.00) 8,094.00 February (40,638.00) 842.00 33,051.00 85,207.00 78,462.00 March 22,691.00 3,200.00 (7,598.00) (1,018.00) 17,275.00 April (28,856.00) 3,038.00 75,827.00 (2,300.00) 47,709.00 May 900.00 2,345.00 (34,890.00) (2,297.00) (33,942.00)
June 15,086.00 2,539.00 2,063.00 26,971.00 46,659.00
Total (76,838.29) 30,444.85 65,566.32 85,551.00 104,723.88 City of Point Arena
Cash Flow worksheet
Actuals through November
Projections using budget
2023-24 Capital Total
General Gas Tax RLF Projects Governmental
Adjusted cash balance by month:
July 26,152.12 2,345.45 46,588.67 (3,258.63) 71,827.61
August (53,769.68) 7,262.66 54,997.22 (7,898.28) 591.92 September (150,554.03) 8,229.88 54,754.66 (15,523.38) (103,092.87) October (117,950.94) 12,261.87 58,672.97 (15,865.10) (62,881.20) November (133,900.29) 13,310.16 59,573.62 (17,686.74) (78,703.25) December 15 (41,487.58) 14,841.85 60,879.32 (17,862.78) 16,370.81 December 31 (17,433.29) 14,841.85 60,879.32 (17,873.00) 40,414.88 January 5,559.71 18,480.85 45,480.32 (21,012.00) 48,508.88 February (35,078.29) 19,322.85 78,531.32 64,195.00 126,970.88 March (12,387.29) 22,522.85 70,933.32 63,177.00 144,245.88 April (41,243.29) 25,560.85 146,760.32 60,877.00 191,954.88 May (40,343.29) 27,905.85 111,870.32 58,580.00 158,012.88 June (25,257.29) 30,444.85 113,933.32 85,551.00 204,671.88 City of Point Arena
Cash Flow worksheet
Actuals through November
Projections using budget
2023-24
Beginning cash, July 1,
Cash Received
Cash Disbursed
Transfers
Ending Cash, June 30
Cash Received
July
August
September
October
November
December 15
December 31
January
February
March
April
May
June
Cash Disbursed
July
August
September
October
November
December 15
December 31
January
February
March
April
May
June
Over (under)
July
August
September
October
November
December 15
December 31
January
February
March
April
May
June
Exhibit C-1.0
Total Total
Pier Wastewater Enterprise All Funds
$ - $ - $ - $ 99,948
61,700 231,734 293,434 1,511,897
(152,036) (388,545) (540,581) (1,654,321)
- - -
$ (90,336) $ (156,811) $ (247,147) $ (42,475)
956.75 - 956.75 51,586
5,249.05 17,014.00 22,263.05 149,523
5,528.75 - 5,528.75 57,796
3,712.20 - 3,712.20 125,311
3,418.40 - 3,418.40 43,602
940.00 2,600.41 3,540.41 123,339
2,129.14 3,812.25 5,941.39 42,654
2,240.00 33,427.00 35,667.00 124,502
8,805.00 26,256.00 35,061.00 198,237
5,697.00 5,697.00 97,186
2,855.00 112,038.00 114,893.00 254,383
2,369.00 31,586.00 33,955.00 97,657
17,800.00 5,000.00 22,800.00 146,121
61,700.29 231,733.66 293,433.95 1,511,897
(12,208.02) (20,573.64) (32,781.66) (111,531)
(47,706.52) (35,803.09) (83,509.61) (282,006)
(23,908.63) (42,453.09) (66,361.72) (222,314)
(18,422.51) (32,818.70) (51,241.21) (132,629)
(6,762.62) (17,191.64) (23,954.26) (79,960)
(3,666.87) (50,698.76) (54,365.63) (79,090)
(2,320.99) (4,143.09) (6,464.08) (19,133)
(5,253.00) (31,669.00) (36,922.00) (117,663)
(5,725.00) (11,695.00) (17,420.00) (102,134)
(5,534.00) (81,071.00) (86,605.00) (160,819)
(7,299.00) (17,430.00) (24,729.00) (116,510)
(5,429.00) (17,598.00) (23,027.00) (120,671)
(7,800.00) (25,400.00) (33,200.00) (109,862)
(152,036.16) (388,545.01) (540,581.17) (1,654,320.56)
(11,251.27) (20,573.64) (31,824.91) (59,945.30)
(42,457.47) (18,789.09) (61,246.56) (132,482.25)
(18,379.88) (42,453.09) (60,832.97) (164,517.76)
(14,710.31) (32,818.70) (47,529.01) (7,317.34)
(3,344.22) (17,191.64) (20,535.86) (36,357.91)
(2,726.87) (48,098.35) (50,825.22) 44,248.84
(191.85) (330.84) (522.69) 23,521.38
(3,013.00) 1,758.00 (1,255.00) 6,839.00
3,080.00 14,561.00 17,641.00 96,103.00
163.00 (81,071.00) (80,908.00) (63,633.00)
(4,444.00) 94,608.00 90,164.00 137,873.00
(3,060.00) 13,988.00 10,928.00 (23,014.00)
10,000.00 (20,400.00) (10,400.00) 36,259.00
(90,335.87) (156,811.35) (247,147.22) (142,423.34)
City of Point Arena
Cash Flow worksheet
Actuals through November
Projections using budget
2023-24
Adjusted cash balance by month:
July
August
September
October
November
December 15
December 31
January
February
March
April
May
June
Exhibit C-1.0
Total Total
Pier Wastewater Enterprise All Funds
(11,251.27) (20,573.64) (31,824.91) 40,002.70
(53,708.74) (39,362.73) (93,071.47) (92,479.55)
(72,088.62) (81,815.82) (153,904.44) (256,997.31)
(86,798.93) (114,634.52) (201,433.45) (264,314.65)
(90,143.15) (131,826.16) (221,969.31) (300,672.56)
(92,870.02) (179,924.51) (272,794.53) (256,423.72)
(93,061.87) (180,255.35) (273,317.22) (232,902.34)
(96,074.87) (178,497.35) (274,572.22) (226,063.34)
(92,994.87) (163,936.35) (256,931.22) (129,960.34)
(92,831.87) (245,007.35) (337,839.22) (193,593.34)
(97,275.87) (150,399.35) (247,675.22) (55,720.34)
(100,335.87) (136,411.35) (236,747.22) (78,734.34)
(90,335.87) (156,811.35) (247,147.22) (42,475.34)
Month
Governmental
Received
Governmental
Disbursed Enterprise Received Enterprise Disbursed All Funds received All Funds disbursed July 50,629 78,749 957 32,782 115,519 109,172
August 127,260 198,496 22,263 83,510 102,099 230,378
September 52,267 155,952 5,529 66,362 426,089 468,900
October 121,599 81,387 3,712 51,241 105,156 336,595
November 40,184 56,006 3,418 23,954 103,359 191,415
December 15 119,798 24,724 3,540 54,366 35,795 138,671
December 31 36,713 12,669 5,941 6,464 127,070 51,326
January 88,835 80,741 35,667 36,922 124,502 217,663
February 163,176 84,714 35,061 17,420 321,149 107,134
March 91,489 74,214 5,697 86,605 95,995 166,819
April 139,490 91,781 114,893 24,729 299,094 86,510
May 63,702 97,644 33,955 23,027 97,159 132,804
June 123,321 76,662 22,800 33,200 145,382 109,862
total 1,218,463 1,113,739 293,434 540,581 2,098,368 2,347,249 $0
$50,000
$100,000
$150,000
$200,000
$250,000
Governmental & Enterprise Funds Cash Flow
Governmental Received Governmental Disbursed Enterprise Received Enterprise Disbursed