|
Available Resources: January 1
<br />Revenues:
<br />User charge revenue 1) 2) 3)
<br />Taxes 4)
<br />Tap Fees 5)
<br />Interest 6)
<br />Miscellaneous fees and other 7)
<br />Total Revenues
<br />Expenditures:
<br />Operations and Maintenance 8)
<br />Capital outlay 9)
<br />Debt service 10)
<br />Total Expenditures
<br />Excess (Deficiency) of
<br />Revenues Over Expenditures
<br />Available Resources:
<br />As of December 31
<br />Loan Feasibility Study for
<br />Raw Water Acquisition and Utilization
<br />Page 46
<br />Table 15
<br />Penrose Water District
<br />Projected Revenues and Expenditures for Life of CWCB Loan, Continued
<br />Estimated With Loan
<br />4,273,517`-`4,682,322
<br />4 051 060
<br />4,007,411
<br />3 950 485
<br />3,879,339
<br />3 642 980 3,994,190
<br />4 419 064 4844 795 5,271,745 5 550 302
<br />5,980,883
<br />6 413 933
<br />6,849,932
<br />1,534,226
<br />127,869
<br />213,676
<br />24,394
<br />1,592,273
<br />132,984
<br />204,116
<br />25,125
<br />1,621,109
<br />138,303
<br />202,553
<br />25,879
<br />1,650,810
<br />143,835
<br />200,371
<br />26,655
<br />1,681,402
<br />149,589
<br />197,524
<br />27,455
<br />1,712,912
<br />155,572
<br />193,967
<br />28,279
<br />1,745,367
<br />161,795
<br />182,149
<br />29,127
<br />1,778,796
<br />168,267
<br />268,055
<br />30,001
<br />1,813,227
<br />174,998
<br />281,458
<br />30,901
<br />1,848,692
<br />181,998
<br />295,531
<br />31,828
<br />1,885,220
<br />189,278
<br />310,307
<br />32,783
<br />1,922,844
<br />196,849
<br />325,823
<br />33,766
<br />1,961,597
<br />204,723
<br />342,114
<br />34,779
<br />2,001,513
<br />212,912
<br />359,220
<br />35,823
<br />2,042,626
<br />221,428
<br />377,181
<br />36,897
<br />1,900,165
<br />1 954 499
<br />1,987,845
<br />2 021 672
<br />2,055,970
<br />2 090 730
<br />2,119,438
<br />2 245 119
<br />2,300,584
<br />2 358 048
<br />2,417,588
<br />2 479 282
<br />2,543,213
<br />2 609 467
<br />2,678,132
<br />1,480,026
<br />150,000
<br />461,334
<br />1,524,427
<br />-
<br />461,334
<br />1,570,159
<br />-
<br />461334
<br />1,617,264
<br />-
<br />461334
<br />1,665,782
<br />-
<br />461334
<br />1,715,756
<br />150,000
<br />461,334
<br />1,767,228
<br />-
<br />1,820,245
<br />-
<br />1,874,852
<br />-
<br />1,931,098
<br />-
<br />1,989,031
<br />150,000
<br />2,048,702
<br />-
<br />2,110,163
<br />-
<br />2,173,468
<br />-
<br />2,238,672
<br />-
<br />2,091,360
<br />1 985 761
<br />2,031,493
<br />2,078 598
<br />2,127,116
<br />2,327,090
<br />1,767 228
<br />1,820,245
<br />1,874 852
<br />1,931 098
<br />2,139,031
<br />2,048,702
<br />2,110,163
<br />2,173,468
<br />2,238,672
<br />(191,195)
<br />(31,262)
<br />(43,649)
<br />(56,927)
<br />(71,146)
<br />(236,360)
<br />351,210
<br />424,874
<br />425,732
<br />426,950
<br />278,557
<br />430,580
<br />433,050
<br />435,999
<br />439,460
<br />4,082 322
<br />4,051,060
<br />4,007 411
<br />3,950,485
<br />3,879,339
<br />_1,642,980
<br />3,994,190
<br />4,419,064
<br />4,844 795
<br />5,271,745
<br />5,550 302
<br />5,980 883
<br />6,413,933
<br />6,849,932
<br />7,289,392
<br />1) User charge revenues are the combined contributions from the base water sales and the water consumption sales.
<br />2) User charges increase in year 2036 by 5 %.
<br />3) The assumption is made that the District's 1,838 EQR's will stay constant for the duration of the loan.
<br />4) Taxes are assumed to increase at 4% annually.
<br />5) No tap fees are assumed to be collected for the duration of the loan
<br />6) Interest is assumed to be 5% on retained earnings for the duration of the loan.
<br />7) Miscellaneous fees are assumed to increase 3% annually.
<br />8) Operations and maintenance includes payroll, office related expenses, plant and distribution repairs, and general government. All expenses are assumed to increase 3% annually.
<br />9) In year 2015 the assumption is made that the District will have to replace a portion of its distribution system resulting in a $1,000,000 capital outlay. Thereafter, the assumption is made that the District
<br />will have ongoing replacement of water treatment
<br />10) Retirement of the USDA and DOLA loans will be undertaken in year 2010 with District retained earnings. In 2012, the privately held bonds will be fully paid resulting in only the CWCB loan thereafter.
<br />Leonard Rice Engineers, Inc.
<br />GMS, Inc.
<br />August 2006 - 1018PEN05
<br />
|