Home   E-Mail  HomePage    index    Format420    Format418    Format424    Format426    Format421    Format409    Format410    Format411    Format401    Format423    Format413    Format414    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format407    Format408    Format415    Format416    Format417    AVI    MV    ALTI    UNITMIX   

Covenant Village:FAHP & LIHTC Test:Trial 6: Test All Form Inputs: Projection

Schedule T: Detail Of Present Value

by participant

( bty )( aty ) 0% 10% 12% 15% 18% 20% 25%
Developer ( 8.3%)( )              
Land ( 1 132) -350000 -318182 -312500 -304348 -296610 -291667 -280000
Start-up Oper. Losses (exp.) ( 1 167) -212649 -188569 -184432 -178576 -173101 -169645 -161612
Working Capital ( 1 172) -14400 -8941 -8171 -7159 -6294 -5787 -4719
Operating Reserve ( 1 173) -335600 -208381 -190428 -166853 -146694 -134870 -109969
Land Residual ( 1 195) 1102680 239975 179871 117838 78044 59642 31038
Equity Residual ( 1 196) 24021 5228 3918 2567 1700 1299 676
Investment Adj. ( 1 320) 562710 114460 51136 -31809 -102365 -143491 -229085
Investment Adj. ( 1 320) 350000 76170 57093 37403 24772 18931 9852
Ground Rent ( 1 631) 315000 145207 127704 106778 90613 81821 64836
Net Cash Flow (NCF) ( 1 699) 5038 1663 1362 1022 778 653 432
Subtotal: Developer ( 8.3%)( ) 1446801 -141370 -274447 -423136 -529158 -583115 -678552
               
Lender ( ****)( )              
Financing Fees ( 2 158) 63000 57273 56250 54783 53390 52500 50400
Financing Fees ( 2 158) 39646 32765 31605 29978 28473 27532 25373
Orig.Mtge(s) ( 2 240) -1321519 -1092164 -1053507 -999258 -949094 -917722 -845772
Mtge Interest ( 2 660) 1561631 701221 611840 504886 422270 377386 290945
Mtge Amortization ( 2 670) 378108 142313 120264 94844 76064 66230 48151
Mtge Amortization ( 2 670) 943411 205314 153891 100817 66771 51027 26555
Subtotal: Lender ( ****)( ) 1664276 46720 -79657 -213951 -302126 -343047 -404349
               
Investor ( 1.5%)( ****)              
Equity Residual ( 3 196) 2378096 517543 387919 254135 168313 128626 66937
Investment ( 3 310) -2404588 -1732323 -1630262 -1492401 -1370443 -1296842 -1135735
Net Cash Flow (NCF) ( 3 699) 498742 164656 134867 101220 77035 64685 42787
Income Taxes (Const.) ( 3 820) 1939 1763 1731 1686 1643 1616 1551
Income Taxes (Annual) ( 3 850) 288769 229170 218200 202915 189046 180556 161746
Inc.Taxes:Equity Residual ( 3 880) -451273 -98210 -73612 -48225 -31939 -24408 -12702
Tax Credit ( 3 890) 3431828 1917009 1731303 1497700 1307028 1198987 980268
Tax Credit ( 3 890) -131000 -73176 -66088 -57171 -49892 -45768 -37419
Subtotal: Investor ( 1.5%)( ****) 3612512 926431 704058 459858 290790 207452 67433
               
Other ( ****)( )              
Const.Interest ( 4 155) 423168 368867 359507 346256 333872 326059 307925
Const.Loan ( 4 220)   -311557 -360561 -427366 -486956 -523083 -602335
Subtotal: Other ( ****)( ) 423168 57310 -1054 -81110 -153084 -197024 -294410
               
Public ( )( )              
Income Taxes (Const.) ( 5 820) -1939 -1763 -1731 -1686 -1643 -1616 -1551
Income Taxes (Annual) ( 5 850) -288769 -229170 -218200 -202915 -189046 -180556 -161746
Inc.Taxes:Equity Residual ( 5 880) 451273 98210 73612 48225 31939 24408 12702
Tax Credit ( 5 890) -3431828 -1917009 -1731303 -1497700 -1307028 -1198987 -980268
Tax Credit ( 5 890) 131000 73176 66088 57171 49892 45768 37419
Subtotal: Public ( )( ) -3140262 -1976555 -1811534 -1596905 -1415885 -1310982 -1093444
               
Secondary Lender ( 2.9%)( )              
Orig.Mtge(s) ( 6 240) -2000000 -1652893 -1594388 -1512287 -1436369 -1388889 -1280000
Mtge Interest ( 6 660) 658543 304487 266991 221826 186673 167457 130168
Mtge Amortization ( 6 670) 934807 388412 334378 270806 222672 196940 148373
Mtge Amortization ( 6 670) 1065193 231817 173756 113832 75390 57614 29983
Subtotal: Secondary Lender ( 2.9%)( ) 658543 -728176 -819263 -905823 -951634 -966878 -971476
               
Underwriter/Syndctr( )( )              
Financing Fees ( 7 158) 157300 130000 125399 118941 112971 109236 100672
Credit Enhancement ( 7 641) 156000 77491 68824 58259 49927 45327 36289
Subtotal: Underwriter/Syndctr( )( ) 313300 207491 194222 177200 162898 154563 136961
               
Total 4978339 -1608148 -2087674 -2583867 -2898200 -3039031 -3237837



 Home   E-Mail  home at CD root