|
IIIIII INII1011111 Eli Ell IIIII INIII NMI 11111 III NMI =I MIMI Mil MIN IIIIII MII ir Mil •
<br /> Cash Flows
<br /> 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,139,022 00 1,334,215 00 1,552,167 00 1,636,277 00 1,105,354 00 1,118,130 00 14,079,114 48
<br /> Public St&Hwy Lighting 14,922.54 14,841 22 14,358 03 14,694 58 14,800 32 14,281 08 14,500 00 14,500 00 14,500 00 14,500 00 14,500 00 14,500 00 174,897 77
<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,374 72 29,374 72 29,374 72 29,374 72 29,374 72 29,374 72 352,220 10
<br /> Dispersed Generation Credit (1,937 50) (2,562 50) (4,500 00)
<br /> Additional Revenue/CIP&Rate Increase
<br /> 1,138,393 63 1,063,854 77 970,823 82 1,063,142 22 979.864 32 1,237,240 27 1,182,896 72 1,378,089 72 1,596,041 72 1,680,151 72 1,149,228 72 1,162,004 72 14,601,732 35
<br /> Other Operating Revenue
<br /> Interest/Dividend Income 3,078 57 315 97 139 61 1,210 30 4,813 24 191.45 100 00 100 00 100 00 100 00 200.00 200 00 10,549 14
<br /> Customer Penalties 16,675 78 9,560 52 12,363 24 7,025 32 9,957 23 8,508 24 9,000 00 9,000 00 9,000 00 9,000 00 9,000 00 9,000.00 118,090 33
<br /> LFG Project 60,878.54 60,554.78 54,419 02 59.411 40 58,642 95 60,380 67 56,951 10 66,710 75 77,608 35 81,813 85 55,267 70 55,906 50 748,545 61
<br /> Connection Fees 29,121 28 50,662 10 36,772 05 63,915 18 55,476 77 38,502 32 29,000 00 29,000 00 29,000 00 29,000 00 29,000 00 29,000 00 448,449 70
<br /> Misc Revenue 44,371 67 17,246 12 25,393 49 17,822 02 11,237 50 18,290 98 15,000 00 20,000 00 25,000 00 15,000 00 20,000 00 25,000 00 254,361 78
<br /> 154,125 84 138,339 49 129,087 41 149,384 22 140,127 69 125,873 66 110,051 10 124,810 75 140,708 35 134,913 85 113,467 70 119,106 50 1,579,996 56
<br /> 1,292,519 47 1,202,194 26 1,099.911 23 1,212,526 44 1,119,992 01 1,363,113 93 1,292,947 82 1,502,900 47 1,736,750 07 1,815,065.57 1,262,696.42 1,281,111 22 16,181,728 91
<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,050,451 00 1,172,833 00 1,303,437 00 785,135 00 621,277 00 618,635 00 9,945,152.14
<br /> Operating&Mice Expense 13,114.47 18,693 27 16,649 51 14,218 56 15,195 68 19,235 23 20,000 00 20,000 00 18,000 00 18,000 00 18,000 00 18,000 00 209,106 72
<br /> Landfill Gas 19,859.43 19,836 00 20,053 43 35,138 93 23,301 93 19,864 93 19,836 00 19,836.00 19,836 00 19,836 00 19,836 00 19,836 00 257,070 65
<br /> Distribution Expense 15,445 72 15,885 99 11,276 06 12,375 31 11,624 38 14,047 90 17,500 00 17,500 00 15,000 00 15,000 00 15,000 00 15,000 00 175,655 36
<br /> Maintenance Expense 36,692 45 46,817.20 57,501 54 63,581 21 44,061 42 79,639 90 60,000 00 60,000 00 50,000 00 45,000 00 41,000 00 40,000 00 624,293 72
<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,461 67 24,461 67 4,461 67 4,461 67 4,461 67 4,461 67 109,444 91
<br /> Other Operating Expense 15,124.64 4,834 94 13,967 31 10,362 28 11,048 37 13,398 21 10,000 00 15,000 00 20,000 00 10,000.00 15,000 00 20,000 00 158,735.75
<br /> Services to the City 56,520.07 56,128 92 54,265 95 56,935 34 57,812 81 56,261 99 55,000 00 55,000 00 55,000 00 55,000 00 55,000.00 55,000 00 667,925 08
<br /> Customer Accounts Expense 10,851 94 3,614 27 11,990 39 34,062.31 7,100 76 14,103 59 11,000 00 11,000.00 11,000 00 11,000 00 11,000 00 11,000 00 147,723.26
<br /> Administrative&General Expense 124,552 56 131,186 72 193,775 00 145,183 68 129,314 71 115,101 81 125,000.00 125,000 00 125,000 00 125,000 00 125,000 00 125,000 00 1,589,114 48
<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,491,248 67 1,638,630 67 1,739,734 67 1,206,432 67 1,043,574 67 1,044,932 67 15,276,222 07
<br /> TOTAL REVENUES 1,292,519.47 1,202,194.26 1,099,911 23 1,212,526 44 1,119,992 01 1,363,113 93 1,292,947 82 1,502,900.47 1,736,750 07 1,815,065 57 1,262,69642 1,281,111.22 16,181,728.91
<br /> TOTAL EXPENSES 1,145,155.52 1,125,415 88 1,115,965.20 1,069,773 13 998,228 06 1,657,130 26 1,491,248 67 1,638,630 67 1,739,734 67 1,206,432 67 1,043,574 67 1,044,932 67 15,276,222 07
<br /> NET INCOME PROFIT(LOSS) 147,363 95 76,778.38 (16,053 97) 142,753.31 121,763 95 (294,016.33) (198,300.85) (135,730 20) (2,984 60) 608,632 90 219,121 75 236,178.55 905,506 84
<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,461 67 (50,338 33) 4,461 67 4,461 67 4,461.67 4,461 67 (14,518 64)
<br /> Payroll Liabilities (52,425 19) (97,771.52) (95,143 20) (52,638 30) (124,864.69) (77,860 60) (80,000 00) (80,000.00) (70,000.00) (70,000.00) (70,000 00) (70,000 00) (940,703 50)
<br /> Accounts Payable (224,976 67) (237,621 77) (241,560 88) (242,678 99) (305,700 32) (338,202 05) (325,000 00) (325,000 00) (325,000 00) (225,000.00) (225,000 00) (225,000 00) (3,240,740.68)
<br /> Capitalized Items (14,107 20) (130,784 58) (350,000 00) (250,000 00) (150,000 00) (20,000 00) (15,000.00) (10,000.00) (939,891.78)
<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 223,401.51 286,807 00 319.548 00 577,290 00 789,923 00 251,224.00 3,642,799.49
<br /> Inventory Purchases (4,082 56) (55,333 47) (92,852.00) (220,956 99) (201,650.45) (197,050 00) (90,000 00) (41,000 00) (50,000 00) (70,000 00) (90,000 00) (110,000 00) (1,222,925 47)
<br /> Change in Cash Balances (111,617 29) (23,701 70) (153,561 17) (117,678 78) (72,347.23) (696,139 81) (707,847 50) (487,671 36) (166,384.76) 912,974 74 721,096.59 184,454 39 (718,423 88)
<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 478,962 29 (8,709.07) (175,093 83) 737,880 91 1,458,977 50 1,643,431 89
<br />
|