|
■ -e. - II - _ 4 1
<br /> Cash Flows
<br /> Actual Actual Actual Actual Actual Actual Actual Actual Actual
<br /> Electric _ Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
<br /> REVENUE
<br /> Operating Revenue
<br /> Electric Sales 1,094,096 37 1,019,638 83 927,091 07 1,019,072 92 937,626.78 1,196,423 51 1,578,956 86 1,657,735 80 1,447,150 45 1,636,277 00 1,105,354 00 1,118,130 00 14,737,553 59
<br /> Public St&Hwy Lighting 14,922 54 14,841 22 14,358 03 14,694 58 14,800 32 14,281 08 14,694 10 14,597 77 13,194 25 14,500 00 14,500 00 14,500 00 173,883 89
<br /> Service Charge
<br /> Generation Credit 29,374 72 29,374 72 29,374 72 29,374 72 29,374 72 29,098 18 29,098.18 29,055 52 29,055 52 29,374 72 29,374 72 29,374 72 351,305 16
<br /> Dispersed Generation Credit (3,850 00) (3,850 00) (3,850 00) (2,000 00) (1,937 50) (2,562 50) (9,862 50) (10,175 00) (10,175 00) (48,262 50)
<br /> Additional Revenue/CIP&Rate Increase
<br /> 1,134,543 63 1,060,004 77 966,973 82 1,061,142.22 979,864 32 1,237,240 27 1,612,886 64 1,691,214 09 1,479,225 22 1,680,151 72 1,149,228 72 1,162,004 72 15,214,480 14
<br /> Other Operating Revenue
<br /> Interest/Dividend Income 3,078 57 315 97 139 61 1,210 30 4,813 24 191 45 1,903 62 662.03 5,193 31 100 00 200 00 200 00 18,008 10
<br /> Customer Penalties 16,675.78 9,560 52 12,363 24 7,025 32 9,957 23 8,508 24 11,574 48 16,331 22 16,499 24 9,000 00 9,000 00 9,000 00 135,495 27
<br /> LFG Project 60,878 54 60,554 78 54,419 02 59,411 40 58,642 95 60,380 67 58,481 96 59,508 56 58,723 36 81,813 85 55,267 70 55,906 50 723,989 29
<br /> Connection Fees 29,121 28 50,662 10 36,772 05 63,915 18 55,476 77 38,502 32 20,670 00 64,184 96 16,597 00 29,000 00 29,000 00 29,000 00 462,901 66
<br /> Misc Revenue 44,371 67 17,246 12 25,393 49 17,822 02 11,237 50 18,290 98 7,896 56 25,107 32 10,540 67 15,000 00 20,000 00 25,000 00 237,906 33
<br /> 154,125 84 138,339 49 129,087 41 149,384 22 140,127 69 125,873 66 100,526 62 165,794 09 107,553.58 134,913 85 113,467 70 119,106 50 1,578,300 65
<br /> 1,288,669 47 1,198,344 26 1,096,061 23 1,210,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008 18 1,586,778 80 1,815,065 57 1,262,696 42 1,281,111 22 16,792,780 79
<br /> EXPENSES
<br /> Purchased Power 754,532 57 670,528 36 613,674 34 575,453 84 576,306 33 1,202,888.70 1,267,977 77 1,229,914 17 725,080 27 785,135 00 621,277 00 618,635 00 9,641,403 35
<br /> Operating&Mtce Expense 13,114 47 18,693 27 16,649 51 14,218 56 15,195 68 19,235 23 3,849 82 9,722.62 15,335 57 18,000 00 18,000.00 18,000 00 180,014 73
<br /> Landfill Gas 19,859.43 19,836 00 20,053 43 35,138 93 23,301 93 19,864 93 20,328 50 19,874 16 22,411 61 19,836.00 19,836 00 19,836 00 260,176 92
<br /> Distribution Expense 15,445 72 15,885 99 11,276 06 12,375 31 11,624 38 14,047 90 7,263 91 26,829 76 12,356 03 15,000 00 15,000 00 15,000 00 172,105 06
<br /> Maintenance Expense 36,692.45 46,817 20 57,501 54 63,581 21 44,061 42 79,639 90 45,943 94 54,179 49 40,265 34 45,000 00 41,000.00 40,000 00 594,682 49
<br /> Depreciation 94,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000.00 118,000 00 118,000 00 118,000 00 1,392,000 00
<br /> Interest Expense 4,461 67 39,890 21 4,811 67 4,461 67 4,461 67 4,588 00 4,588 00 4,588 00 4,588 00 4,461 67 4,461 67 4,461 67 89,823 90
<br /> Other Operating Expense 15,124 64 4,834 94 13,967 31 10,362 28 11,048 37 13,398 21 14,915 61 12,077 15 19,439 83 10,000 00 15,000 00 20,000 00 160,168 34
<br /> Services to the City 56,520 07 56,128 92 54,265 95 56,935 34 57,812 81 56,261 99 64,264 21 60,854 12 60,191 42 55,000 00 55,000 00 55,000 00 688,234 83
<br /> Customer Accounts Expense 10,851 94 3,614.27 11,990 39 34,062 31 7,100 76 14,103 59 6,704.34 6,196.22 7,164 55 11,000 00 11,000.00 11,000 00 134,788 37
<br /> Administrative&General Expense 124,552 56 131,186 72 193,775 00 145,183 68 129,314 71 115,101 81 103,505 56 100,519 59 87,423 38 125,000 00 125,000 00 125,000 00 1,505,563 01
<br /> 1,145,155.52 1,125,415 88 1,115,965 20 1,069,773 13 998,228 06 1,657,130 26 1,657,341 66 1,642,755 28 1,112,256 00 1,206,432 67 1,043,574 67 1,044,932 67 14,818,961 00
<br /> TOTAL REVENUES 1,288,669 47 1,198,344 26 1,096,061 23 1,210,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008 18 1,586,778 80 1,815,065 57 1,262,696 42 1,281,111 22 16,792,780.79
<br /> TOTAL EXPENSES 1,145,15552 1,125,41588 1,115,96520 1,069,773 13 998,22806 1,657,13026 1,657,341 66 1,642,75528 1,112,25600 1,206,43267 1,043,57467 1,044,93267 14,818,961 00
<br /> NET INCOME PROFIT(LOSS) 143,513 95 72,928 38 (19,903 97) 140,753 31 121,763 95 (294,016 33) 56,071 60 214,252 90 474,522 80 608,632 90 219,121 75 236,178 55 1,973,819 79
<br /> Other Cash Items
<br /> Depreciation 94,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000.00 118,000 00 118,000 00 1,392,000 00
<br /> Accrued Interest 4,461 67 (8,923 34) 4,461.67 4,461 67 4,461 67 4,588 00 4,588.00 (39,145 12) 4,588 00 4,461 67 4,461 67 4,461 67 (3,072 77)
<br /> Payroll Liabilities (52,425 19) (97,771 52) (95,143 20) (52,638 30) (124,864 69) (77,860 60) (60,142 65) (11,543 65) (55,604 83) (70,000 00) (70,000 00) (70,000 00) (837,994 63)
<br /> Accounts Payable (221,126 67) (233,771 77) (237,710 88) (240,678 99) (305,700 32) (338,202 05) (384,356 27) (62,860 83) (258,905 69) (225,000.00) (225,000 00) (225,000 00) (2,958,313 47)
<br /> Capitalized Items (14,107 20) (130,784 58) (226,489 78) (210,992 10) (20,000.00) (15,000 00) (10,000 00) (627,373 66)
<br /> LTD&Bond Principal (144,394 67) (51,457 17) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (10,409.83) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (299,950 14)
<br /> Accounts Receivable 68,436 18 246,734 39 310,781 62 143,790 35 326,052 44 98,811 00 345,991 82 42,606 45 76,342 03 322,273 45 530,923 00 151224 00 2,663,966 73
<br /> Inventory Purchases (4,082.56) (55,333 47) (92,852.00) (220,956 99) (201,650 45) (197,050 00) (56,066 45) (875 00) (66,161 55) (70,000 00) (90,000 00) (110,000 00) (1,165,028 47)
<br /> Change in Cash Balances (111,617 29) (23,701 70) (153,561 17) (117,678 78) (72,347 23) (696,139 81) 13,676 22 23,535 14 71,378 83 657,958 19 462,096 59 84,454 39 138,053 38
<br /> Cash Balance 2,250,238 48 2,226,536 78 2,072,975 61 1,955,296 83 1,882,949 60 1,186,809 79 1,200,486 01 1,224,021 15 1,295,399 98 1,953,358 17 2,415,454 76 2,499,909 15
<br />
|