C150237 Feasibility Study - Laserfiche WebLink

Home Browse Search

Available Resources: January 1 Revenues: User charge revenue 1) 2) 3) Taxes 4) Tap Fees 5) Interest 6) Miscellaneous fees and other 7) Total Revenues Expenditures: Operations and Maintenance 8) Capital outlay 9) Debt service 10) Total Expenditures Excess (Deficiency) of Revenues Over Expenditures Available Resources: As of December 31 Loan Feasibility Study for Raw Water Acquisition and Utilization Page 44 Table 15 Penrose Water District 1) User charge revenues are the combined contributions from the base water sales and the water consumption sales. 2) User charges increase in year 2036 by 5 %. 3) The assumption is made that the District's 1,838 EQR's will stay constant for the duration of the loan. 4) Taxes are assumed to increase at 4% annually. 5) No tap fees are assumed to be collected for the duration of the loan 6) Interest is assumed to be 5% on retained earnings for the duration of the loan. 7) Miscellaneous fees are assumed to increase 3% annually. 8) Operations and maintenance includes payroll, office related expenses, plant and distribution repairs, and general government. All expenses are assumed to increase 3% annually. 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 will have ongoing replacement of water treatment 10) Retirement of the USDA and DOLA loans will be undertaken in year 2010 with District retained eamings. In 2012, the privately held bonds will be fully paid resulting in only the CWCB loan Leonard Rice Engineers, Inc. GMS, Inc. August 2006 - 1018PEN05 Projected Revenues and Ex enditures for Life of CWCB Loan Actual 2,150,696 2,431,672 2,491,613 2,640,173 Budgeted 2,797,994 Estimate Without Loan 2,895,038 2,730,273 3,077,210 3486,814 Estimated With Loan 3,696,744 Y3,722,120 3,758,847 3,967,985 4,185,567 3,412,016 3,597,779 720,633 687,576 588,874 571,072 700,201 767,547 871,056 934,021 995,148 1,046,727 1,060,099 1,073,871 1,088,056 1,102,667 1,117,716 1,133,217 1,149,183 102,802 108,374 113,473 106,365 111,030 117,147 121,833 126,706 131,774 137,045 142,527 148,228 154,157 160,324 166,737 173,406 180,342 95,500 119,500 3,000 72,000 217,000 74,000 - - - - - - - - - - - 77,410 39,662 50,417 62,022 80,985 76,171 144,752 136,514 153,861 174,341 184,837 186,106 187,942 198,399 209,278 170,601 179,889 9,052 3,370 9,546 14,505 31,050 12,196 1,392,000 1 515 000 3,520,000 2,830 000 12,000 12,360 12,731 13,113 13,506 13,911 14,329 1,005 397 958,482 765,310 825,964 1,140 266 1,047 061 2,529,641 2,712,241 4,800,783 4,188,114 1 399 463 1,420,565 1,442,887 1,474,503 1,507 237 1,491,135 1 523 743 474,439 448,154 469,040 510,560 535,408 640,617 638,000 657,140 676,854 697,160 728,075 749,917 772,414 795,587 819,454 844,038 869,359 144,788 28,650 19,622 - 3,185,587 - 1,865,000 1,515,000 3,520,000 3,108,011 - - - - 1,000,000 - - 209,913 211,841 188,784 195,013 260,309 309,400 191,406 193,164 194,325 173,013 646,013 633,922 461,334 461,334 461,334 461,334 461,334 829,140 688,645 677,446 705,573 3,981,304 950,017 2,694,406 2,365,304 4,391,179 3,978,183 1,374,087 1,383,838 1,233,748 1256,921 2,280,788 1,305,372 1,330,693 176,257 269,837 87,864 120,391 (2,841,038) 97,044 (164,765) 346,937 409,604 209,930 25,376 36,727 209,138 217,592 (773,551) 185,763 193,049 176,257 2,420,533 2,519,536 2,612 004 L200,865)1 2,895,038 1 2,730 273 3,077,210 3,486,814 3,696,744 13,722,120 3,758,847 3,967,985 4,195,567 3,412,016 3,597,779 3,790 829 1) User charge revenues are the combined contributions from the base water sales and the water consumption sales. 2) User charges increase in year 2036 by 5 %. 3) The assumption is made that the District's 1,838 EQR's will stay constant for the duration of the loan. 4) Taxes are assumed to increase at 4% annually. 5) No tap fees are assumed to be collected for the duration of the loan 6) Interest is assumed to be 5% on retained earnings for the duration of the loan. 7) Miscellaneous fees are assumed to increase 3% annually. 8) Operations and maintenance includes payroll, office related expenses, plant and distribution repairs, and general government. All expenses are assumed to increase 3% annually. 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 will have ongoing replacement of water treatment 10) Retirement of the USDA and DOLA loans will be undertaken in year 2010 with District retained eamings. In 2012, the privately held bonds will be fully paid resulting in only the CWCB loan Leonard Rice Engineers, Inc. GMS, Inc. August 2006 - 1018PEN05