|
■ w 1111111111 MO w - EN M ■N I N■ 11 1•11 - 1 MI el EN
<br /> Cash Flows
<br /> 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 179,327 00 176,886.00 269,872 00 157,196 00 103,516 00 1,511,760 98
<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 179,327 00 176,886.00 269,872 00 157,196 00 103,516 00 1,511,760 98
<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 1,000 00 500.00 500 00 1,000.00 1,000 00 26,029.39
<br /> Customer Penalties 556.47 1,016.29 995 20 543 56 792 86 1,027.05 989 14 800 00 800.00 800 00 800 00 800.00 9,920 57
<br /> Connection Fees 97,430 00 47,940.00 36,345 00 96,437 50 141,951 20 70,521.00 51,473 00 28,000 00 28,000 00 28,000.00 28,000 00 28,000 00 682,097 70
<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 29,800 00 29,300 00 29,300 00 29,800 00 29,800.00 717,985 88
<br /> Total Revenue 168,152 97 113,757 82 100,270 57 162,904 34 228,214 10 195,170.71 226,479 35 209,127.00 206,186,00 299,172.00 186,996.00 133,316.00 2,229,746 86
<br /> EXPENSES -
<br /> Production Expense 1,242.18 2,219 04 1,01304 1,460 62 1,278 36 1,237 00 13,745 95 800 00 800 00 800.00 800 00 800.00 26,196.19
<br /> Pumping Expense 14,514.36 21,860.91 26,259 66 36,652.07 30,563 23 28,419 88 15,400 32 21,000.00 21,000.00 21,000.00 21,000.00 21,000.00 278,670 43
<br /> Distribution Expense 12,559.12 12,983.87 18,137 84 15,241 71 13,433 38 15,142.61 14,534 79 11,000 00 8,000.00 9,000.00 12,000.00 20,000.00 162,033 32
<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 9,865.33 9,865 33 9,865 33 9,865.33 9,865.33 173,465 94
<br /> Other Operating Expense 537.76 483.00 461.00 461 00 461.00 461.00 461.00 500.00 500.00 500.00 500.00 500.00 5,825 76
<br /> Customer Accounts Expense 1,423.55 149.07 286 62 2,478 64 53 00 603 27 622.67 400.00 400 00 400.00 7,000.00 400 00 14,216.82
<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 23,000.00 23,000 00 23,000.00 23,000.00 23,000 00 392,787.75
<br /> Total Expenses 131,075.01 190,049 56 139,074 94 162,297 89 184,493 66 161,342 09 150,436 41 126,565.33 123,565.33 124,565.33 134,165.33 135,565 33 1,763,196 21
<br /> Operating Transfer 20,000 00
<br /> 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 209,127 00 206,186.00 299,172 00 186,996 00 133,316.00 2,229,746.86
<br /> TOTAL EXPENSES 131,075.01 190,049 56 139,074 94 162,297 89 184,493 66 161,342.09 150,436 41 126,565 33 123,565 33 124,565 33 134,165.33 135,565 33 1,763,196 21
<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 82,561.67 82,620 67 174,606.67 52,830 67 (2,249 33) 446,550 65
<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 (42,134 67) 9,865 33 9,865.33 9,865.33 9,865 33 (22,951.74)
<br /> Payroll Liabilities (13,106 25) (14,442.88) (23,785 80) (13,159.58) (24,972 94) (15,572 12) (15,035 66) (14,500.00) (14,500 00) (13,000.00) (13,000 00) (13,000.00) (188,075.23)
<br /> Accounts Payable (29,062.20) (27,006.00) (8,638 25) (28,000.00) (12,521.74) 27,778.43 (28,000 00) (28,000.00) (28,000 00) (28,000.00) (28,000.00) (217,449.76)
<br /> Capitalized Items (20,412 00) (10,143 00) (52,536 49) (86,598.46) (4,000.00) (50,000 00) (10,000.00) (7,000 00) (7,000 00) (5,000 00) (252,689.95)
<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) 88,534.67 70,441 00 35,014 00 180,676.00 121,680 00 469,259 78
<br /> Inventory Purchases (1,200.00) (19,308 28) (25,221 50) (14,458 94) (19,682 05) (3,925.81) (1,958.87) (5,000 00) (5,000.00) (5,000 00) (5,000.00) (5,000 00) (110,755.45)
<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 91,461.67 165,427.00 226,486.00 250,372 00 138,296.00 392,631.35
<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,351,489.01 1,516,916.01 1,743,402 01 1,993,774.01 2,132,070 01
<br /> 9
<br />
|