|
City of Pleasanton
<br />2025 Water Rate Study
<br />
<br />Water Resources Economics
<br />40
<br />Table 2-24: Projected Potable and Recycled Cash Flows (Proposed Financial Plan)
<br />Line Cash Flow Projections (Potable and Recycled) FY 2025 FY 2026 FY 2027 FY 2028 FY 2029
<br />1 Revenues 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 $3,116,681 $9,817,544 $15,600,025 $20,172,487
<br />4 Non-Rate Revenue $635,541 $635,541 $635,541 $635,541 $635,541
<br />5 Interest Income $275,000 $367,158 $432,710 $387,611 $176,202
<br />6 Subtotal $40,211,229 $45,675,121 $52,441,536 $58,178,919 $62,539,971
<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 $5,794,525 $8,311,591 $12,436,257 $15,676,999
<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 Proposed Debt $0 $1,111,973 $1,853,289 $2,594,604 $2,594,604
<br />25 Subtotal $1,547,489 $2,660,618 $3,403,433 $4,145,499 $4,145,499
<br />26
<br />27 Net Revenue Minus Debt $2,312,944 $3,133,907 $4,908,158 $8,290,759 $11,531,500
<br />28
<br />29 CIP
<br />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
<br />33 Net Cash Flow ($7,194,162) $3,133,907 $4,423,311 $134,554 ($7,507,090)
|