|
.... -.0.- - - - - - - 1 - .... ..,. - - - ... e. SIM •
<br /> Cash Flows
<br /> 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 107,595.00 179,327 00 176,886 00 269,872 00 157,196 00 103,516 00 1,449,494 31
<br /> Total Operating Revenue 70,166 50 63,746 74 59,507.64 63,349 23 82,645 50 115,686 70 107,595 00 179,327.00 176,886 00 269,872 00 157,196 00 103,516 00 1,449,494 31
<br /> Other Operating Revenue -
<br /> Interest/Dividend Income 1,054 79 3,422 73 2,574 05 2,824 54 7,997 74 1,800 00 1,000 00 500 00 500 00 1,000 00 1,000.00 23,673 85
<br /> Customer Penalties 556 47 1,016 29 995 20 543 56 792.86 1,027.05 800 00 800 00 800 00 800 00 800 00 800 00 9,731 43
<br /> Connection Fees 97,430 00 47,940 00 36,345 00 96,437 50 141,951 20 70,521 00 28,000 00 28,000.00 28,000.00 28,000 00 28,000.00 28,000 00 658,624.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 30,600.00 29,800 00 29,300.00 29,300 00 29,800.00 29,800.00 691,968.20
<br /> Total Revenue 168,152 97 113,757.82 100,270 57 162,904.34 228,214 10 195,170 71 138,195 00 209,127.00 206,186 00 299,172 00 186,996.00 133,316.00 2,141,462 51
<br /> EXPENSES -
<br /> Production Expense 1,242.18 2,219.04 1,013 04 1,460 62 1,278 36 1,237 00 800 00 800 00 800 00 800 00 800 00 800 00 13,250 24
<br /> Pumping Expense 14,514.36 21,860 91 26,259 66 36,652 07 30,563.23 28,419 88 21,000 00 21,000.00 21,000 00 21,000 00 21,000 00 21,000 00 284,270 11
<br /> Distribution Expense 12,559.12 12,983 87 18,137.84 15,241 71 13,433.38 15,142.61 13,000.00 11,000 00 8,000 00 9,000 00 12,000 00 20,000 00 160,498 53
<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 9,865 33 9,865 33 9,865 33 9,865 33 9,865.33 9,865 33 168,807 27
<br /> Other Operating Expense 537.76 483.00 461.00 461.00 461 00 461 00 500 00 500 00 500 00 500 00 500 00 500 00 5,864.76
<br /> Customer Accounts Expense 1,423 55 149 07 286.62 2,478 64 53 00 603 27 400 00 400 00 400 00 400 00 7,000 00 400 00 13,994.15
<br /> Administrative&General Expense 40,932 71 36,723 70 23,051 45 36,138 52 68,839.36 40,954 33 23,000 00 23,000 00 23,000 00 23,000 00 23,000 00 23,000 00 384,640.07
<br /> Total Expenses 131,075.01 190,049.56 139,074 94 162,297 89 184,493.66 161,342 09 128,565.33 126,565.33 123,565.33 124,565 33 134,165 33 135,565.33 1,741,325 13
<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 138,195 00 209,127.00 206,186 00 299,172.00 186,996 00 133,316 00 2,141,462.51
<br /> TOTAL EXPENSES 131,075.01 190,049 56 139,074 94 162,297 89 184,493.66 161,342 09 128,565 33 126,565.33 123,565.33 124,565 33 134,165 33 135,565 33 1,741,325.13
<br /> NET INCOME PROFIT(LOSS) 37,077.96 (96,291.74) (38,804 37) 606.45 43,720.44 33,828.62 9,629 67 82,561 67 82,620.67 174,606 67 52,830 67 (2,249 33) 380,137 38
<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 9,865.33 (42,134.67) 9,865.33 9,865 33 9,865 33 9,865.33 (27,610.41)
<br /> Payroll Liabilities (13,106.25) (14,442.88) (23,785 80) (13,159 58) (24,972.94) (15,572 12) (14,500.00) (14,500 00) (14,500 00) (13,000 00) (13,000.00) (13,000.00) (187,539.56)
<br /> Accounts Payable (29,062.20) (27,006 00) (8,638 25) (28,000.00) (12,521.74) (28,000.00) (28,000.00) (28,000.00) (28,000 00) (28,000.00) (28,000.00) (273,228 19)
<br /> Capitalized Items (20,412.00) (10,143.00) (52,536.49) (86,598 46) (155,000.00) (50,000.00) (10,000.00) (7,000 00) (7,000.00) (5,000 00) (403,689 95)
<br /> LTD&Bond Principal (441,256 96)
<br /> (441,256 96)
<br /> Accounts Receivable (71,773.11) 188,995.72 (19,069 92) (97,950 35) 75,507.37 (29,129.86) 76,091 70 26,268 00 70,441.00 35,014 00 180,676 00 121,680 00 556,750.55
<br /> Inventory Purchases (1,200.00) (19,308 28) (25,221.50) (14,458 94) (19,682 05) (3,925.81) (10,000
<br /> 00) (5,000 00) (5,000 00) (5,000 00) (5,000.00) (5,000.00) (118,796.58)
<br /> Change in Cash Balances (38,610.27) (448,240 85) (45,654 51) (55,097.09) 63,901 66 (39,395 37) (51,913 30) 29,195.00 165,427.00 226,486 00 250,372.00 138,296.00 194,766 28
<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,124,428.94 1,153,623 94 1,319,050.94 1,545,536.94 1,795,908 94 1,934,204.94
<br />
|