|
■ 1 I I 1 I M N 0 I NE I - I - 1111Nr r
<br /> Cash Flows
<br /> Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual
<br /> Water Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
<br /> REVENUE
<br /> Operating Revenue
<br /> Water Sales 70,166 50 63,746 74 59,507.64 63,349 23 82,645 50 115,686 70 169,861.67 260,607 86 201,039 70 113,426 39 157,196.00 103,516 00 1,460,749 93
<br /> Total Operating Revenue 70,166 50 63,746 74 59,507 64 63,349 23 82,645 50 115,686 70 169,861 67 260,607 86 201,039 70 113,426 39 157,196 00 103,516 00 1,460,749 93
<br /> Other Operating Revenue -
<br /> Interest/Dividend Income 1,054 79 3,422.73 2,574.05 2,824.54 7,997 74 4,155 54 18,115 69 4,966 46 5,315 01 1,000 00 1,000 00 52,426 55
<br /> Customer Penalties 556 47 1,016 29 995 20 543 56 792 86 1,027 05 989 14 1,830 79 3,419 39 - 800 00 800 00 12,770 75
<br /> Connection Fees 97,430 00 47,940.00 36,345 00 96,437 50 141,951 20 70,521 00 51,473 00 50,046.50 74,557 79 84,372.50 28,000 00 28,000 00 807,074 49
<br /> Misc Revenue (61 78) (61 78)
<br /> Total Other Revenue 97,986 47 50,011 08 40,762 93 99,555 11 145,568 60 79,484.01 56,617 68 69,992 98 82,943 64 89,687 51 29,800 00 29,800 00 872,210 01
<br /> Total Revenue 168,152 97 113,757 82 100,270 57 162,904 34 228,214 10 195,170.71 226,479 35 330,600 84 283,983.34 203,113 90 186,996 00 133,316 00 2,332,959 94
<br /> EXPENSES -
<br /> Production Expense 1,242 18 2,219 04 1,013 04 1,460 62 1,278.36 1,237 00 13,745 95 4,112.16 804 75 629 42 800 00 800 00 29,342.52
<br /> Pumping Expense 14,514 36 21,860 91 26,259 66 36,652 07 30,563 23 28,419 88 15,400 32 32,811 09 23,362 88 20,523 22 21,000 00 21,000 00 292,367 62
<br /> Distribution Expense 12,559 12 12,983 87 18,137 84 15,241 71 13,433.38 15,142 61 14,534 79 15,562 76 12,173 90 19,018 66 12,000 00 20,000.00 180,788.64
<br /> Depreciation 50,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000.00 60,000 00 710,000.00
<br /> Interest Expense 9,865.33 55,629 97 9,865.33 9,865 33 9,865 33 14,524.00 14,524 00 14,524 00 14,524 00 14,524 00 14,524 00 14,524 00 196,759.29
<br /> Other Operating Expense 537 76 483 00 461 00 461 00 461 00 461.00 461.00 994 40 994 40 994.40 500 00 500 00 7,308.96
<br /> Customer Accounts Expense 1,423 55 149 07 286 62 2,478.64 53 00 603 27 622 67 642 30 642 30 612 08 7,000 00 400 00 14,913.50
<br /> Administrative&General Expense 40,932 71 36,723.70 23,051 45 36,138 52 68,839 36 40,954 33 31,147.68 32,271 89 32,271 89 36,221.70 23,000.00 23,000 00 424,553.23
<br /> Total Expenses 131,075 01 190,049 56 139,074 94 162,297 89 184,493.66 161,342 09 150,436 41 160,918 60 144,774 12 152,523 48 138,824 00 140,224 00 1,856,033.76
<br /> Operating Transfer 20,000 00 20,000 00
<br /> TOTAL REVENUES 168,152 97 113,757 82 100,270 57 162,904.34 228,214 10 195,170 71 226,479.35 330,600 84 283,983 34 203,113 90 186,996 00 133,316 00 2,332,959.94
<br /> TOTAL EXPENSES 131,075 01 190,049 56 139,074 94 162,297.89 184,493 66 161,342 09 150,436 41 160,918 60 144,774 12 152,523 48 138,824 00 140,224 00 1,856,033.76
<br /> NET INCOME PROFIT(LOSS) 37,077.96 (96,291 74) (38,804 37) 606 45 43,720.44 33,828 62 76,042 94 169,682 24 139,209 22 50,590 42 48,172 00 (6,908 00) 456,926.18
<br /> Other Cash Items -
<br /> Depreciation 50,000 00 60,000 00 60,000 00 60,000 00 60,000 00 60,000.00 60,000 00 60,000 00 60,000 00 60,000.00 60,000 00 60,000.00 710,000.00
<br /> Accrued Interest 9,865 33 (88,787 71) 9,865 33 9,865 33 9,865 33 14,524 00 14,524 00 (111,001 01) 14,524 00 14,524 00 14,524 00 14,524 00 (73,183.40)
<br /> Payroll Liabilities (13,106 25) (14,442 88) (23,785 80) (13,159.58) (24,972 94) (15,572 12) (15,035 66) (6,076 94) (13,901 21) (13,844 67) (13,000 00) (13,000 00) (179,898.04)
<br /> Accounts Payable (29,062 20) (27,006.00) (8,638 25) (28,000 00) (12,521 74) 27,778 43 27,834 13 (108,774 53) 12,564 62 (15,000 00) (15,000 00) (175,825.54)
<br /> Capitalized Items (20,412 00) (10,143 00) (52,536.49) (86,598 46)
<br /> (4,000 00) (42,755 04) 4,864 84 (7,000 00) (5,000 00) (223,580.15)
<br /> LTD&Bond Principal (441,256.96) (441,256.96)
<br /> Accounts Receivable (71,773 11) 188,995 72 (19,069 92) (97,950 35) 75,507 37 (29,129 86) (73,665.74) (90,014 09) 77,791 28 61,915.03 40,000 00 46,000 00 108,606 33
<br /> Inventory Purchases (1,200.00) (19,308.28) (25,221 50) (14,458 94) (19,682.05) (3,925 81)
<br /> (1,958 87) 3,483 87 4,102 95 (1,207 84) (3,500 00) (1,000 00) (83,876 47)
<br /> Change in Cash Balances (38,610 27) (448,240 85) (45,654 51) (55,097.09) 63,901 66 (39,395 37) 83,685.10 11,153 16 172,951 71 189,406 41 124,196.00 79,616 00 97,911.95
<br /> Cash Balance 1,700,828.39 1,252,587 54 1,206,933.03 1,151,835 95 1,215,737 61 1,176,342 24 1,260,027 34 1,271,180 50 1,444,132 21 1,633,538 61 1,757,734 61 1,837,350 61
<br />
|