<br /> e .
<br /> Work Sheet Showing Growth of Funds
<br /> Available for Purchase of Additional Capacity
<br /> Calculated as of July 28,1999
<br /> Description Entity Attributed To:
<br /> Total La Porte Morgan's pt Shoreacres
<br />9/30/97 left Over Distribution Funds B 326,801 279,415 23,856 23,530
<br /> Capital Recovery Fee A 180,064 163,804 7,725 8,535
<br /> Available Working Capital B 331,770 283,664 24,219 23,887
<br /> Total 9/30/97 838,635 726,883 55,800 55,952
<br />97-98 Billing for Capital Reserve A 176,295 160,376 7,563 8,356
<br /> Interest D 13,760 11,926 916 918
<br /> Down Payment:
<br /> left Over Dist = 338,458;
<br /> WC = 161,542 A (500,000) (454,850) (21,450) (23,700)
<br /> Total For Year (309,945) (282,548) (12,971) (14,426)
<br /> Cumulative Total 528,690 444,335 42,829 41,526
<br />98-99 Billing for Capital Reserve A 176,295 160,376 7,563 8,356
<br /> Transfer from City of La Porte 400,000 400,000
<br /> Interest Income D 40,872 34,351 3,311 3,210
<br /> Total for Year 617,167 594,727 10,874 11,566
<br /> Cumulative Total 1,145,857 1,039,062 53,703 53,092
<br />99-00 Billing for Capital Reserve A 176,295 160,376 7,563 8,356
<br /> Transfer from Morgan's Point 250,000 250,000
<br /> Interest Income D 81,124 73,563 3,802 3,759
<br /> Refunidng Savings A 100,000 90,970 4,290 4,740
<br /> Refunding - Release of Contingenc~ C 200,000 176,470 11,590 11 ,940
<br /> Total for Year 807,419 501,379 277,245 28,795
<br /> Cumulative Total 1,953,276 1,540,441 330,948 81,887
<br />00-01 Billing for Capital Reserve A 176,295 160,376 7,563 8,356
<br /> Interest Income 0 97,648 77,009 16,545 4,094
<br /> Refunding Savings C 600,000 529,410 34,770 35,820
<br /> Total for Year 873,943 766,795 58,878 48,270
<br /> Cumulative Total 2,827,219 2,307,236 389,826 130,157
<br />Note: Per the Contract, 2,912,700 needs to be available by August, 2001.
<br />Because of the various contribution levels, there are three percentages that are being used to show the
<br />allocations to the various entities. They are coded by the Alpha Letter in front of the first dollar column:
<br /> La Porte Morgan's PI. Shoreacres Total
<br /> A - Percentages for Production 90.97% 4.29% 4.74% 100.00%
<br /> B - Percentages for Distribution 85.50% 7.30% 7.20% 100.00%
<br /> C - Average of above Percentages 88.24% 5.79% 5.97% 100.00%
<br /> D - Based on Cumulative Totals
<br /> ~
<br />
|