|
<br />TWIN LAKES n.......... y ......'" ..,...... AREA
<br />?_~nllth 3 & 4 - ,.. ..
<br />CASH FLOW AND n..."'.....1 VALUE ANALYSIS
<br />
<br />/....T.: "-\
<br />,f t ....: }
<br />
<br />. . ..,
<br />
<br />......{a)
<br />
<br />i
<br />
<br />ANNUAL
<br />(b) (c)
<br />Original I C~lIllldltjU
<br />Tax Tax
<br />Capacity Capacity
<br />(see i)
<br />2.5%'lnfbtinn
<br />
<br />(c2) (d)
<br />Fiscal ( :~ntllrpr1
<br />- Tax
<br />- Capacity
<br />((c) - (b)) x (c) - (b) - (c2)
<br />31.8268% (prev. year)
<br />
<br />I...
<br />
<br />Date
<br />
<br />!
<br />
<br />
<br />)1/03! 257,126 257,126
<br />12/01/03 257,126 257,126
<br />! 06/01/04 257,126 257,126 0
<br />12/01/04 257,126 I 257,126 Q ....
<br />06/01/05 257,126 257,126 0
<br />12/01/05 257.126 257.126 0
<br />'06761706 257,126 257,126 0
<br />12/01/06 257,126 257,126 0
<br />06/01/07 257,126 636,259 (120.666) 0
<br />__._ 12/01/07 257,126 636,259 (120,666) 0
<br />1 I 06/01/08 1 257,126 815,206 (177,619) 258,467
<br />-112701708T 257,126 815,206 (177,619) 258,467
<br />2 i 06/61/0~] 257~1-~~]-~~,t)~i3r II?4~1(5)[~'.-~]:Q~~1-
<br />12/01/09 I 257,126 i 835,586 I (184,105)1 380,461
<br />
<br />3 :~~i~l;~]~j ,,~~r~~~+-' ~;~:1~~ 1 ~~~~:~;:~I ;~::;;;
<br />
<br />4 i 06/01/11 1 257,126 877,888 (197,569) 408,596
<br />'--l 12/01/11 257,126 877,888 (197,569) 408,596
<br />5 06/01/12 257,126 899,835 (204,554) 423,193
<br />12/01/12 257,126 899,835 (204,554) 423,193
<br />6 I 06/01/13 257,126 922,331 (211,713) 438,155
<br />. '112/01/13 257,126 I 922,331 (211,713) 438,155
<br />...l+ 06/01/14 257,126 945,389 (219,052) 453,491
<br />, 12/01/14 I 257,126 I . 945,389... (219,052) 453,491
<br />8 . 06/01/15 -r 257.126']-. 969,024 j- . (226,574)1-'" 469,211'-
<br />
<br />;~~~~}~~i~ '};i~1Il= ~~;:~;~t- ~;~~:;~*j--- :~;:~~~
<br />
<br />12/01/16 I 2-57~1-26T-993,250T(234,284T 485,323
<br />10 ! 06/01/17 257,126 1,018,081' (242,187) 501,839
<br />-."] 12/01/17 257,126 1,018,081 (242,187) 501,839
<br />11 1 06/01/18 I 257,126 j. 1,043,533 (250,288) 518,767
<br />-112/01/18 257,126 1,043,533 (250,288) 518,767
<br />12 06/01/19 257,126 1,069,621 (258,591) 536,118
<br />12/01/19 257,126 1,069,621 (258,591) 536,118
<br />13 06/01/20 257,126 1,096,362 (267,102) 553,904
<br />12/01/20 257,126 1,096,362 (267,102) 553,904
<br />14 06/01/21 257,126 1,123,771 (275,825) 572,134
<br />12/01/21 257,126! 1,123,771 I (275,825) 572,134
<br />15t'06/01/22-j~ . 257,126 I 1,151,865! (284,767) 590,819
<br />----.l_J2/01/22 1 257,126 I 1,151,865 (284,767) 590,819
<br />16 I 06/01/23: 257,126! 1,180,662! (293,932)1 609,972
<br />T1'2/01l23l-'257,1261- 1,180,662 (293,932)1 609,972
<br />J1J 06/01/24 1 257,126 1,210,178 (303,326) 629,604
<br />I 12/01/24 257,126 1,210,178 (303,326) 629,604
<br />181 06/01/25 257,126 1,240,433 (312,955) 649,726
<br />- -12/01/25 257,126 1,240,433 I (312,955) 649,726
<br />19 06/01/26 257,126 1,271,443 (322,825) 670,351
<br />_____.12/01/26 257,126 1,271,443 (322,825)1 670,351
<br />20 06/01/27 257,126 1,303,230 r (332,941) 691,492
<br />12/01/27 257,126 1,303,230 (332,941) 691,492
<br />~.1LQ6/01/2B_ 257,126 1,335,810 (343,311) 713,162
<br />1 12/01/28 257,126 1,335,810 (343,311) 713,162
<br />-2'21 06/01/29 , 257,126 I 1,369,206 (353,939) 735,373
<br />
<br />2i+f~!;~i;!:~m:i~~t n~m~llHH~t m:m
<br />
<br />-24" 06/01/31 257,126 i 1,438,522 (376,000) 781,476
<br />J 12/01/31 257,126 1,438,522 I (376000) 781,476
<br />')') I 06/01/32 I .' 00 i 1,181,395
<br />12/01/32 " 1,181,395
<br />.~J 06/01/33
<br />I 12/01/33
<br />27 06/01/34
<br />12/01/34
<br />28 I! 06/01/35
<br />12/01/35
<br />..1 I
<br />
<br /><---------------
<br />
<br />(e) (f)
<br />;:"~;IIICllC;U Less:
<br />Tax Admin
<br />II 'v, <O"'<O'" Fees
<br />(d)x (e)x
<br />1.04922 10.00%
<br />
<br />o 0
<br />o 0
<br />o 0
<br />Q 0
<br />o 0
<br />o 0
<br />o 0
<br />o 0
<br />o 0
<br />o 0
<br />135,594 13,559
<br />135,594 13,559
<br />m~. 199,594J19,959 I'
<br />-- -199,594 1 -..- 19,959 T-
<br />206,882 20,688
<br />206,882 20,688
<br />214,353 21,435
<br />214,353 21,435
<br />222,011 22,201
<br />222,011 22,201
<br />229,861 22,986
<br />229,861 22,986
<br />237,906 23,791
<br />237,906 L 23,791
<br />246,153 I 24,615
<br />246,15iJ:_ 24,615 I
<br />254,606 25,461 I
<br />254,606 25,461
<br />263,270 26,327
<br />263,270 26,327
<br />272,150 27,215
<br />272,150 27,215
<br />281,253 28,125 I
<br />281,253 28,125
<br />290,583 29,058
<br />290,583 29,058
<br />300,147 30,015
<br />300,147 I 30,015 I
<br />309,950 I 30,995
<br />309,950 30,995
<br />319,997 32,000
<br />319,997 32,000
<br />330,296 33,030
<br />330,296 33,030
<br />340,853 34,085
<br />340,853 34,085
<br />351,673 35,167
<br />351,673 35,167
<br />362,764 36,276
<br />362,764 36,276
<br />374,132 37,413
<br />374,132 I _ 37,413 I
<br />385,784 38,578
<br />385,784 38,578
<br />397,728 39,773
<br />397,728 39,773
<br />409,970 40,997
<br />409,970 40,997
<br />619,772 61,977
<br />619,772 61,977
<br />
<br />1---- SEMI - ANNUAL
<br />(q) (h)
<br />^ ':u CunlUidiive
<br />TaxAvaif' Tax
<br />
<br />(i)(])
<br /><_m__ Present Value _m__>
<br />I Semi Annual ('"rn"bt;\Ip
<br />Balance Balance
<br />P.V. of (g) Total of (i)
<br />7.00%106/01/06
<br />
<br />o 0 0 0
<br />o 0 0 0
<br />o 0 0 0
<br />o ]f. . ....... 0 0
<br />o 0 0 0
<br />o 0 O. 0
<br />o 0 0 0
<br />o 0 0 0
<br />o 0 0 I 0
<br />o 0 0 0
<br />122,035 122,0351 106,346 106,346
<br />_J22,035._.?44~~_ 102,750 I 209,096
<br />
<br />+j~:~~~ ~~;:~~: . ~:~:~~~ F.. ~~~~~~;---
<br />
<br />186,194 789,532 141,3981 637,818
<br />186,194 975,726 136,616 I 774,434
<br />192,918 1,168,644 136,763 911,197
<br />192,918 1,361,562 132,138 1,043,336
<br />199,810 1,561,373 132,231 1,175,567
<br />199,810 1,761,183 127,759 1,303,326
<br />206,875 1,968,057 127,803, 1,431,130
<br />206,875 2,174,932 123,481 1,554,611
<br />214,115 2,389,047 123,482 1,678,093
<br />214,115 2,603,163 119,306 1,797,399
<br />221,537 2,824,700 1- - 119,267 I 1,916,666 ..-
<br />. -..---1.--------.-i.----- .-
<br />221,537 3,046,238 _. 115,234! 2,031,900 _
<br />229,145 3,275,383 115,160 2,147,060
<br />229,145 3,504,528 111,266 2,258,326
<br />236,943 3,741,470 111,162 2,369,488
<br />236,943 3,978,413 107,403 2,476,891
<br />244,935 4,223,348 107,271 2,584,162
<br />244,935 4,468,284 103,644 2,687,806
<br />253,128 4,721,411 103,488 2,791,294
<br />253,128 4,974,539 99,989 2,891,282
<br />261,525 5,236,064 99,812 2,991,095
<br />261,525 5,497,589 96,437 3,087,531
<br />270,132 5,767,722 96,242 3,183,774
<br />270,132 j_ 6,037,854 92,988 I 3,276,762
<br />278,955 6,316,809 92,777 i 3,369,539
<br />278,955 6,595,763 89,640 I 3,459,179
<br />287,998 6,883,761 89,416 3,548,595
<br />287,998 7,171,759 86,393 3,634,988
<br />297,267 7,469,025 86,158 3,721,146
<br />297,267 7,766,292 83,244 3,804,390
<br />306,767 8,073,060 83,000 3,887,389
<br />306,767 8,379,827 80,193 3,967,582
<br />316,506 8,696,333 79,941 4,047,523
<br />316,506 9,012,838 77 ,237 4,124,760
<br />326,487 9,339,326 76,979 4,201,739
<br />326,487 9,665,813 74,376 I 4,276,115
<br />336,719 10,002,532 74,113 I 4,350,227
<br />336,719 10,339,251 71,606 1~~._~~1,834 -_~-:-~
<br />347,206 10,686,457 71,340 I 4,493,173_
<br />347,206 11,033,662 68,927! 4,562,101
<br />357,955 11,391,617 68,658 4,630,759
<br />357,955 11,749,573 66,336 4,697,095
<br />368,973 12,118,546 66,066 4,763,161
<br />368,973 12,487,519 63,832 4,826,993
<br />557,795 13,045,313 93,234 4,920,227
<br />557,795 13,603,108 90,082 5,010,308
<br />
<br />. .
<br />111t-1 tjllltjlll
<br />
<br />(e)-(f)
<br />
<br />1111,,;1 tjllltjlll
<br />
<br />T'0taI0f (g)
<br />
<br />.----
<br />
<br />., ,
<br />
<br />15,114,564: 1,511,456 i 13,603,108! 13,603,108
<br />
<br />5,010,308
<br />
<br />5,010,308
<br />
|