C150269 feasibility Study - Laserfiche WebLink

Home Browse Search

I 14 I I I I I I I I I I ** See Section 4.3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ncrease) $140,000 $144,900 $149,972 $155,221 $160,653 $166,276 $172,096 $178,119 $184,353 $190,806 $197,484 $204,396 $211,550 $218,954 $226,617 $234,549 $242,758 $251,255 $260,048 $269,150 $278,570 $288,320 $298,412 $308,856 $319,666 $330,854 $342,434 $354,419 $366,824 $379,663 Revenue and Expenditure Projections for explanation of projection method $156,308 $158,608 $160,908 $163,208 $165,508 $206,885 $209,760 $212,635 $215,510 $218,385 $270,106 $273,700 $277 ,293 $280,887 $284,481 $305,297 $305,297 $305,297 $305,297 $305,297 $315,982 $327,042 $338,488 $350,335 $362,597 $375,288 $388,423 $402,018 $416,088 $430,652 $17,500 $17,500 $17,500 $12,250 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ncrease) $30,000 $31,050 $32,137 $33,262 $34,426 $35,631 $36,878 $38,168 $39,504 $40,887 $42,318 $43,799 $45,332 $46,919 $48,561 $50,260 $52,020 $53,840 $55,725 $57,675 $59,694 $61,783 $63,945 $66,183 $68,500 $70,897 $73,379 $75,947 $78,605 $81,356 $343,808 $352,058 $360,516 $363,940 $380,587 $428,792 $438,733 $448,922 $459,368 $470,078 $529,908 $541 ,894 $554,175 $566,760 $579,659 $610,106 $620,075 $630,392 $641,070 $652,122 $654,247 $677,145 $700,845 $725,375 $750,763 $777,040 $804,236 $832,384 $861,518 $891,671 ncrease) $164,000 $169,740 $175,681 $181,830 $188,194 $194,781 $201,598 $208,654 $215,957 $223,515 $231,338 $239,435 $247,815 $256,489 $265,466 $274,757 $284,374 $294,327 $304,628 $315,290 $326,325 $337,747 $349,568 $361,803 $374,466 $387,572 $401,137 $415,177 $429,708 $444,748 (+3~% Annual (+3~% Annual Increase) after Increase) after adjustment adjustment $32,000 $32,538 $33,120 $34,064 $34,279 $36,394 $35,479 $39,555 $36,721 $43,577 $38,006 $48,490 $39,336 $54,324 $40,713 $61,113 $42,138 $68,889 $43,613 $77,688 $45,139 $87,544 $46,719 $98,496 $48,354 $110,581 $50,047 $123,838 $51,798 $128,173 $53,611 $132,659 $55,488 $137,302 $57,430 $142,107 $59,440 $147,081 $61,520 $152,229 $63,673 $157,557 $65,902 $163,071 $68,208 $168,779 $70,596 $174,686 $73,067 $180,800 $75,624 $187,128 $78,271 $193,678 $81,010 $200,456 $83,846 $207,472 $86,780 $214,734 ncrease) $62,000 $64,170 $66,416 $16,604 $17,185 $17,787 $18,409 $19,053 $19,720 $20,411 $21,125 $21,864 $22,630 $23,422 $24,241 $25,090 $25,968 $26,877 $27,817 $28,791 $29,799 $30,842 $31,921 $33,038 $34,195 $35,392 $36,630 $37,912 $39,239 $40,613 ncrease) $3,000 $3,105 $3,214 $3,326 $3,443 $3,563 $3,688 $3,817 $3,950 $4,089 $4,232 $4,380 $4,533 $4,692 $4,856 $5,026 $5,202 $5,384 $5,572 $5,768 $5,969 $6,178 $6,395 $6,618 $6,850 $7,090 $7,338 $7,595 $7,861 $8,136 CWCS Loan Reserve $3,915 $3,915 $3,915 $3,915 $3,915 $3,915 $3,915 $3,915 $3,915 $3,915 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 CWCS Loan Total Repayment Expenditures $39,150 $336,603 $39,150 $347,264 $39,150 $359,049 $39,150 $319,859 $39,150 $332,184 $39,150 $345,691 $39,150 $360,420 $39,150 $376,415 $39,150 $393,720 $39,150 $412,380 $39,150 $428,528 $39,150 $450,044 $39,150 $473,063 $39,150 $497,637 $39,150 $513,684 $39,150 $530,293 $39,150 $547,483 $39,150 $565,275 $39,150 $583,689 $39,150 $602,748 $39,150 $622,474 $39,150 $642,890 $39,150 $664,021 $39,150 $685,891 $39,150 $708,527 $39,150 $731,956 $39,150 $756,204 $39,150 $781,301 $39,150 $807,276 $39,150 $834,160 NET $7,205 $4,794 $1 ,468 $44,081 $48,403 $83,101 $78,313 $72,508 $65,648 $57,698 $101,379 $91,850 $81,112 $69,122 $65,975 $79,813 $72,592 $65,117 $57,381 $49,374 $31,773 $34,255 $36,824 $39,483 $42,236 $45,084 $48,032 $51,084 $54,242 $57,511 $7,205 $11,999 $13,466 $57,547 $105,950 $189,051 $267,364 $339,872 $405,520 $463,217 $564,597 $656,447 $737,559 $806,681 $872,656 $952,470 $1,025,061 $1,090,179 $1,147,560 $1,196,934 $1,228,707 $1,262,962 $1,299,787 $1,339,270 $1,381,506 $1,426,590 $1,474,622 $1,525,706 $1,579,948 $1,637,458 (+3~% Annual (+3~% Annual (+3~% Annual (+3~% Annual (+3~% Annual Accumulation ncome I I I 2001 2002 2003 2004 2005 2006 2007* 'unaudited $107,988 $114,203 $121,338 $121,054 $122,633 $128,907 $139,796 Annual Net Water Fees ** Sales ** $32,700 $126,671 $44,560 $47,743 $69,887 $60,700 $57,887 $53,299 $114,274 $102,266 $181,368 $60,305 $154,008 $109,088 $24,254 $32,850 $19,389 $16,923 $34,250 $37,190 $56,620 Projections Following Purchase of 1/3rd Interest in Pine River Weminuche Pass Ditch Total Income $291,613 $239,356 $271,314 $249,163 $373,42;3 $407,770 $459,512 Admin &OH $120,532 $141,441 $177,857 $133,206 $138,830 $144,244 $163,563 Facility Maintenance ** $810 $5,360 $17,935 $40,414 $9,579 $31,560 $19,032 Storage Costs ** $14,679 $20,791 $21,296 $12,400 $8,435 $21,324 $31,788 Legal/ Engineering ** $15,750 $32,584 $88,303 $66,472 $86,797 $77,960 $81,336 $1,192 $940 $4,269 $5,036 $3,177 $1 ,463 $483 Total Expenditures $152,963 $201,116 $309,660 $257,528 $246,818 $276,551 $296,202 $138,650 one large water sale $38,240 -$38,346 -$8,365 $126,605 annual $131,219 $163,310 fee increase I CWCS Loan Reserve CWCS Loan Repayment Taxes Misc Misc I YEAR Seven Year Historical Financial Analysis prepared by L. Fleming; OS/23/08 Source: Financial Audit Reports NCOME EXPENDITURES NET Notes I I I TABLE 4-1 Revenue and Expenditure Projections