to home page  Home   E-Mail  SiteTree (all case studies)    HomePage    Index (this case study)    MV    AVI    ALTI    Format420    Format418    Format424    Format426    Format421    Format409    Format410    Format401    Format423    Format413    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format407    Format408    Format415    Format416    Format417   

MXD Proposal, Scenario 2-A:Phase 1: Hotel

Schedule T: Detail Of Present Value

by participant

( bty )( aty ) 0% 10% 12% 15% 18% 20% 25%
Developer( )( )              
Start-up Oper. Losses (exp.) ( 1 167) -1866887 -1697170 -1666863 -1623380 -1582107 -1555739 -1493509
Investment Adj. ( 1 320) -6091165 -5537423 -5438540 -5296665 -5162004 -5075971 -4872932
Return of Investment ( 1 370) 7,164,416 2,762,193 2,306,750 1,770,934 1,368,865 1,157,093 769273
Subtotal: Developer( )( ) -793635 -4472400 -4798653 -5149111 -5375246 -5474616 -5597168
               
Public ( )( )              
Net Cash Flow (NCF) ( 2 699)              
               
Investor ( 8.5%)( )              
Investment ( 3 310) -7056000 -6414545 -6300000 -6135652 -5979661 -5880000 -5644800
Return of Investment ( 3 370) 7,056,000 2,720,393 2,271,843 1,744,135 1,348,151 1,139,583 757632
Special Return of Equity ( 3 686) 5,977,993 3,098,370 2,751,689 2,319,676 1,971,554 1,776,628 1,388,864
Net Cash Flow (NCF) ( 3 699)              
Subtotal: Investor ( 8.5%)( ) 5,977,993 -595782 -1276468 -2071841 -2659956 -2963789 -3498303
               
Other ( )( )              
Const.Interest ( 4 155) 3,583,000 3,257,273 3,199,107 3,115,652 3,036,441 2,985,833 2,866,400
               
Lender ( ****)( )              
Financing Fees ( 5 158) 391000 355455 349107 340000 331356 325833 312800
Orig.Mtge(s) ( 5 240) -17812000 -16192727 -15903571 -15488696 -15094915 -14843333 -14249600
Mtge Interest ( 5 660) 15,913,679 9,635,352 8,829,080 7,798,952 6,942,978 6,451,007 5,437,076
Mtge Amortization ( 5 670) 2,538,108 1,416,339 1,278,215 1,104,493 962850 882715 720971
Mtge Amortization ( 5 670) 15,273,892 5,888,747 4,917,785 3,775,473 2,918,298 2,466,819 1,640,022
Subtotal: Lender ( ****)( ) 16,304,679 1,103,165 -529384 -2469778 -3939433 -4716959 -6138731
               
Total 25,072,037 -707744 -3405398 -6575077 -8938195 -10169531 -12367802


 Home   E-Mail  home at CD root