|
■ MIVP - M M - - M 3 - - .... - - - -4.... ....
<br /> Cash Flows
<br /> 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 176,886.00 269,872 00 157,196.00 103,516 00 1,593,041.84
<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 176,886 00 269,872 00 157,196 00 103,516 00 1,593,041.84
<br /> Other Operating Revenue -
<br /> InteresUDividend Income 1,054.79 3,422 73 2,574 05 2,824 54 7,997.74 4,155 54 18,115 69 500.00 500 00 1,000 00 1,000 00 43,145 08
<br /> Customer Penalties 556.47 1,016.29 995 20 543 56 792 86 1,027.05 989.14 1,830 79 800 00 800.00 800 00 800.00 10,951.36
<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 28,000 00 28,000 00 28,000 00 28,000 00 704,144 20
<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 29,300.00 29,300 00 29,800.00 29,800 00 758,178 86
<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 206,186 00 299,172 00 186,996 00 133,316 00 2,351,220 70
<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 800 00 800.00 800 00 800.00 29,508 35
<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 21,000 00 21,000 00 21,000 00 21,000.00 290,481.52
<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 8,000 00 9,000 00 12,000.00 20,000 00 166,596.08
<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 9,865 33 9,865.33 9,865.33 9,865.33 178,124 61
<br /> Other Operating Expense 537.76 483.00 461.00 461 00 461 00 461.00 461.00 994.40 500 00 500 00 500 00 500 00 6,320 16
<br /> Customer Accounts Expense 1,423 55 149.07 286.62 2,478 64 53.00 603.27 622 67 642 30 400 00 400 00 7,000 00 400 00 14,459 12
<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 23,000 00 23,000 00 23,000 00 23,000.00 402,059.64
<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 123,565 33 124,565 33 134,165 33 135,565 33 1,797,549.48
<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 206,186 00 299,172 00 186,996 00 133,316 00 2,351,220 70
<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 123,565 33 124,565 33 134,165 33 135,565 33 1,797,549 48
<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 82,620.67 174,606 67 52,830 67 (2,249.33) 533,671 22
<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) 9,865 33 9,865 33 9,865 33 9,865.33 (91,818.08)
<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) (14,500.00) (13,000 00) (13,000 00) (13,000 00) (179,652.17)
<br /> Accounts Payable (29,062.20) (27,006.00) (8,638.25) (28,000.00) (12,521 74) 27,778.43 27,834 13 (28,000.00) (28,000 00) (28,000 00) (28,000 00) (161,615.63)
<br /> Capitalized Items (20,412 00) (10,143.00) (52,536 49) (86,598 46) (4,000 00) (42,755.04) (10,000 00) (7,000 00) (7,000 00) (5,000.00) (245,444 99)
<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) 151,721 86 35,014 00 180,676.00 121,680 00 371,991.88
<br /> Inventory Purchases (1,200 00) (19,308 28) (25,221.50) (14,458.94) (19,682 05) (3,925 81) (1,958 87) 3,483 87 (5,000.00) (5,000 00) (5,000 00) (5,000 00) (102,271.58)
<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 246,707.86 226,486 00 250,372.00 138,296.00 393,603.70
<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,517,888.36 1,744,374 36 1,994,746 36 2,133,042 36
<br /> 00
<br />
|