|
City of Pleasanton
<br />2025 Water Rate Study
<br />
<br />Water Resources Economics
<br />34
<br />Table 2-20: Projected Potable and Recycled Cash Flows (Status Quo Financial Plan)
<br />Line Cash Flow Projections FY 2025 FY 2026 FY 2027 FY 2028 FY 2029
<br />1 Revenues
<br />2 Rate Revenues at Existing Rates $39,300,688 $41,555,742 $41,555,742 $41,555,742 $41,555,742
<br />3 Revenue Adjustments $0 $0 $0 $0 $0
<br />4 Non-Rate Revenue $635,541 $635,541 $635,541 $635,541 $635,541
<br />5 Interest Income $275,000 $218,367 $0 $0 $0
<br />6 Subtotal $40,211,229 $42,409,649 $42,191,283 $42,191,283 $42,191,283
<br />7
<br />8 Expenses
<br />9 Maintenance and Repair Expenses $91,000 $93,730 $96,542 $99,438 $102,421
<br />10 Material and Service Expenses $4,046,205 $4,180,261 $4,318,972 $4,462,510 $4,611,053
<br />11 Water Supply Expenses $25,376,250 $26,624,589 $27,955,819 $29,353,610 $30,821,290
<br />12 Personnel Expenses $6,386,842 $6,636,580 $6,896,716 $7,167,709 $7,450,036
<br />13 Transportation and Training Expenses $138,500 $142,655 $146,935 $151,343 $155,883
<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 $36,350,797 $39,880,596 $44,129,945 $45,742,662 $46,862,972
<br />19
<br />20 Net Revenue $3,860,432 $2,529,053 ($1,938,663) ($3,551,379) ($4,671,689)
<br />21
<br />22 Debt Service
<br />23 Existing Debt $1,547,489 $1,548,645 $1,550,145 $1,550,895 $1,550,895
<br />24 Subtotal $1,547,489 $1,548,645 $1,550,145 $1,550,895 $1,550,895
<br />25
<br />26 Net Revenue Minus Debt $2,312,944 $980,408 ($3,488,808) ($5,102,274) ($6,222,584)
<br />27
<br />28 CIP
<br />29 Rate Funded $9,507,105 $8,242,931 $17,241,915 $18,156,205 $19,038,590
<br />30 Subtotal $9,507,105 $8,242,931 $17,241,915 $18,156,205 $19,038,590
<br />31
<br />32 Net Cash Flow ($7,194,162) ($7,262,523) ($20,730,723) ($23,258,479) ($25,261,174)
<br />
|