|
■ i 1111106111111 i i i i i i 11. i i i i i i 11111 j... i
<br /> Cash Flows
<br /> 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 269,872 00 157,196.00 103,516 00 1,617,195 54
<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 269,872 00 157,196.00 103,516 00 1,617,195 54
<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 500 00 1,000.00 1,000.00 47,611 54
<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 800.00 13,570 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 28,000.00 28,000.00 28,000 00 750,701.99
<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 29,300 00 29,800.00 29,800 00 811,822 50
<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 299,172.00 186,996.00 133,316 00 2,429,018.04
<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 800.00 800.00 800.00 29,513.10
<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 21,000.00 21,000.00 21,000.00 292,844.40
<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 9,000.00 12,000 00 20,000 00 170,769 98
<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 9,865 33 9,865 33 9,865 33 182,783 28
<br /> Other Operating Expense 537 76 483.00 461.00 461.00 461.00 461.00 461 00 994.40 994 40 500.00 500 00 500.00 6,814 56
<br /> Customer Accounts Expense 1,423.55 149.07 286 62 2,478 64 53.00 603.27 622.67 642 30 642.30 400.00 7,000 00 400 00 14,701 42
<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 23,000 00 23,000 00 23,000 00 411,331 53
<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 124,565 33 134,165 33 135,565 33 1,818,758 27
<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 299,172 00 186,996.00 133,316.00 2,429,018.04
<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 124,565 33 134,165 33 135,565.33 1,818,758 27
<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 174,606.67 52,830.67 (2,249.33) 590,259.77
<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 9,865 33 9,865.33 9,865.33 (87,159.41)
<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,000 00) (13,000 00) (13,000 00) (179,053 37)
<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) (8,001.25) (48,000 00) (48,000.00) (262,391.41)
<br /> Capitalized Items (20,412.00) (10,143 00) (52,536.49) (86,598.46) (4,000.00) (42,755 04) (7,000 00) (7,000 00) (5,000 00) (235,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) 77,791 28 79,167 70 42,676.00 33,680 00 116,215 00
<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 4,102.95 (5,000.00) (5,000 00) (5,000.00) (93,168 63)
<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 290,638 45 92,372 00 30,296 00 118,000 00
<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,734,770 66 1,827,142 66 1,857,438.66
<br /> CV
<br />
|