|
NM 111111ir MO IMIN M NM = MINI la Mill NM M IIIII MN 1011. Mill di NM
<br /> Shee
<br /> Al B I C I D I E I F I G I H I I I J j K I L I M 1 N I 0 I P 10 I R
<br /> 1
<br /> 2 Rev 10-18-05
<br /> 3 6 1 295 1 405 1 623 1 82 6 5 1 95 2.15 2 2 2 25 2 3 2 35 2 4 2 45
<br /> 4 1500 1750 2000 2250
<br /> 5 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
<br /> 6 Description
<br /> 7 Pumping Units 706804 651253 786500 796725 824610 849348 883322 927488 964588 1003171 1043298 1085030 1128431 4%-5%
<br /> 8 Sales Units 632590 642019 676390 685183 709164 747426 759657 797640 819900 852696 886803 922275 959167 85%ofCol 7
<br /> 9 #Meters 3321 3696 3876 4056 4236 4416 4596 4776 4956 5136 5316 5496 5676 180/Year
<br /> 10 WAC Units 444 560 260 238 238 238 230 220 220 215 215 200 200
<br /> 11 Operations
<br /> 12 Revenue
<br /> 13 Revenue from Sales $1,047,560 $1,167,954 $1,376,853 $1,539,065 $1,699,239 $1,787,889 $1,977,711 $2,113,296 $2,217,302 $2,347,768 $2,484,596 $2,628,109 $2,778,646 Rate+3%
<br /> 14 WAC Revenue $666,231 $839,911 $455,000 $476,000 $476,000 $476,000 $460,000 $495,000 $495,000 $483,750 $483,750 $450,000 $450,000
<br /> 15 Other Revenue $115,629 $135,754 $72,800 $71,000 $72,065 $73,146 $74,243 $75,357 $76,487 $77,634 $78,799 $79,981 $81,181 1 5%
<br /> 16 Total Revenue $1,829,420 $2,143,619 $1,904,653 $2,086,065 $2,247,304 $2,337,035 $2,511,954 $2,683,652 $2,788,789 $2,909,152 $3,047,145 $3,158,090 $3,309,827
<br /> 17
<br /> 18 Expense
<br /> 19 Water Production $19,244 $29,341 $10,000 $10,282 $10,801 $11,555 $11,920 $12,704 $13,254 $13,991 $14,769 $15,590 $16,457 1 5%
<br /> 20 Water Pumping $411,527 $282,227 $258,818 $367,950 $396,061 $434,127 $458,881 $501,098 $535,685 $579,397 $626,676 $677,812 $733,122 4%
<br /> 21 Water Distnbution $123,250 $148,216 $142,400 $177,850 $183,186 $188,681 $194,341 $200,172 $206,177 $212,362 $218,733 $225,295 $232,054 3%
<br /> 22 Meter Reading $15,633 $23,512 $22,643 $24,175 $17,791 $21,197 $22,061 $22,925 $23,789 $27,734 $28,706 $29,678 $30,650 Step
<br /> 23 Depreciation $585,354 $720,044 $600,000 $750,000 $787,500 $826,875 $868,219 $911,630 $957,211 $1,005,072 $1,055,325 $1,108,092 $1,163,496 Step
<br /> 24 Interest Expense $356,701 $256,207 $256,683 $244,908 $231,729 $217,923 $245,629 $228,269 $289,767 $268,182 $244,842 $219,703 $199,537 Study Sheet
<br /> 25 Other Operating(1999 P&I) $37,710 $33,897 $29,648 $28,808 $27,958 $32,088 $30,988 $29,875 $28,750 $27,600 $31,425 P&I 1999 Bond
<br /> 26 Other Operating $26,046 $0 $0 $0 $0 $0 $0 $0 SO $0 SO $0
<br /> 27 Customer Expenses $17,389 $16,300 $29,413 $21,861 $22,517 $23,192 $23,888 $24,605 $25,343 $26,103 $26,886 $27,693 $28,524 3%
<br /> 28 Administrative&General $262,636 $314,824 $280,134 $435,426 $465,906 $498,519 $533,416 $570,755 $610,707 $653,457 $699,199 $748,143 $800,513 7 00%
<br /> 29 Total Expense $1,829,444 $1,850,614 $1,629,739 $2,061,259 $2,143,449 $2,254,158 $2,389,343 $2,502,031 $2,690,684 $2,813,898 $2,946,562 $3,052,007 $3,204,353
<br /> 30 Gross Margin(Operation) -$24 $293,005 $274,914 $24,806 $103,855 $82,878 $122,611 $181,622 $98,105 $95,254 $100,583 $106,083 $105,474
<br /> 31
<br /> 32 Operation Funded CP $457,500 $364,667 $383,750 $345,250 $462,250 $388,500 $337,250 $312,250 $115,250 $139,250 $667,000 $125,500 $297,750
<br /> 33 Net Margin -$457,524 -$71,662 -$108,836 -$320,444 -$358,395 -$305,622 -$214,639 -$130,628 -$17,145 -$43,996 -$566,417 -$19,417 -$192,276
<br /> 34
<br /> 35 Capital Projects w Bonds
<br /> 36
<br /> 37 Revenue
<br /> 38 Bond Revenue $1,300,000 $0 $0 $0 $0 $0 $800,000 $0 $1,500,000 $0 $0 $0 $0
<br /> 39
<br /> 40
<br /> 41 Expense
<br /> 42 Bond Payments Pnn $280,000 $218,750 $388,750 $410,000 $425,000 $395,000 $421,250 $468,100 $489,880 $548,499 $578,486 $597,411 $302,781 Study Sheet
<br /> 43 Capital Outlay Expenses $1,209,212 $471,182 $0 $120,000 $20,000 $0 $400,000 $400,000 $1,700,000 $0 $1,200,000 $0 $0
<br /> 44 Total Expense $1,489,212 $689,932 $388,750 $530,000 $445,000 $395,000 $821,250 $868,100 $2,189,880 $548,499 $1,778,486 $597,411 $302,781
<br /> 45 Gross Bond Margin -$189,212 -$689,932 -$388,750 -$530,000 -$445,000 -$395,000 -$21,250 -$868,100 -$689,880 -$548,499 -$1,778,486 -$597,411 -$302,781
<br /> 46
<br /> 47
<br /> 48 Inventory &Acc Payable Adj $12,030 -$23,489
<br /> 49 Deprecation $186,000 $585,354 $720,044 $600,000 $750,000 $787,500 $826,875 $868,219 $911,630 $957,211 $1,005,072 $1,055,325 $1,108,092 $1,163,496 23
<br /> 50 Reserve Account $806,157 $916,157 $1,026,157 $1,136,157 $1,246,157 $1,356,157 $1,466,157 $1,576,157 $1,686,157 $1,796,157 $1,906,157 $2,016,157 $2,126,157 $120k/year
<br /> 51 Bond Account $998,472 $823,433 $815,847 $605,402 $479,507 $495,760 $1,018,089 $820,991 $961,177 $1,263,754 -$135,825 $245,439 $803,878 51-49
<br /> 52 Total Cash Balance $4,966,312 $1,804,629 $1,739,590 $1,842,004 $1,741,559 $1,725,664 $1,851,917 $2,484,246 $2,397,148 $2,647,334 $3,059,911 $1,770,332 $2,261,596 $2,930,035 51+32+44+47+48
<br /> SpringstadBcaWater Page 1
<br />
|