|
City of Pleasanton
<br />2025 Water Rate Study
<br />
<br />Water Resources Economics
<br />42
<br />Table 2-25: Projected Potable Cash Flows (Proposed Financial Plan)
<br />Line Cash Flow Projections (Potable) FY 2025 FY 2026 FY 2027 FY 2028 FY 2029
<br />1 Revenues
<br />2 Rate Revenues at Existing Rates $37,007,044 $39,130,425 $39,130,425 $39,130,425 $39,130,425
<br />3 Revenue Adjustments $0 $2,934,782 $9,244,563 $14,689,562 $18,995,160
<br />4 Non-Rate Revenue $626,041 $626,041 $626,041 $626,041 $626,041
<br />5 Interest Income $275,000 $369,506 $431,479 $383,169 $265,577
<br />6 Subtotal $37,908,085 $43,060,754 $49,432,508 $54,829,196 $59,017,203
<br />7 8 Expenses 9 Maintenance and Repair Expenses $91,000 $93,730 $96,542 $99,438 $102,421
<br />10 Material and Service Expenses $3,862,705 $3,991,086 $4,123,944 $4,261,443 $4,403,757
<br />11 Water Supply Expenses $24,194,417 $25,383,665 $26,652,848 $27,985,490 $29,384,765
<br />12 Personnel Expenses $5,729,749 $5,953,592 $6,186,747 $6,429,625 $6,682,653
<br />13 Transportation and Training Expenses $129,000 $132,870 $136,856 $140,962 $145,191
<br />14 OM Program Improvements $312,000 $1,075,110 $2,477,922 $2,155,890 $1,273,670
<br />15 Increase in O&M for CIP $0 $0 $1,067,761 $1,139,718 $1,191,390
<br />16 Insurance Liability Cost Allocation $0 $350,000 $360,500 $371,315 $382,454
<br />17 Additional Staffing Costs $0 $777,670 $808,777 $841,128 $874,773
<br />18 Subtotal $34,318,871 $37,757,723 $41,911,898 $43,425,010 $44,441,075
<br />19 20 Net Revenue $3,589,214 $5,303,031 $7,520,610 $11,404,186 $14,576,129
<br />21 22 Debt Service 23 Existing Debt $1,112,594 $1,113,750 $1,115,250 $1,116,000 $1,116,000
<br />24 Proposed Debt $0 $1,111,973 $1,853,289 $2,594,604 $2,594,604
<br />25 Subtotal $1,112,594 $2,225,723 $2,968,539 $3,710,604 $3,710,604
<br />26 27 Net Revenue Minus Debt $2,476,620 $3,077,308 $4,552,071 $7,693,582 $10,865,525
<br />28 29 CIP 30 Rate Funded $9,507,105 $0 $484,846 $8,156,205 $19,038,590
<br />31 Subtotal $9,507,105 $0 $484,846 $8,156,205 $19,038,590
<br />32 33 Net Cash Flow ($7,030,485) $3,077,308 $4,067,225 ($462,623) ($8,173,065)
|