Home   E-Mail  HomePage    index    Format420    Format418    Format424    Format426    Format421    Format409    Format410    Format401    Format423    Format413    Format414    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format407    Format408    Format415    Format416    Format417    AVI    ALTI    MV    Analysis for Affordable Housing Study Commission (ahsc)   

Analysis for Affordable Housing Study Commission

Input array: ALTI

  AVI/MV Trial 1 Trial 2 Trial 3 Trial 4 Trial 5 Trial 6 Trial 7 Trial 8 Trial 9 Trial 10 Trial 11
AVI[ 20] Est.const.int,fin.fees,acctg.adj.(ProCash checks) 20 1800 1059.564 1059.564 2192.92425 1937.7678 1938.13095 2657.813085 2249.1768 2249.4711 1368.079 1800
AVI[ 37] Bridge loan interest rate:equity & operations 37       0.1 0.1 0.1 0.1 0.1 0.1    
AVI[ 44] Start-up operating losses (financed & expensed) 44       1024.354842 3087.62362 3099.374399 4604.260854 4609.206047 4618.270287    
AVI[ 62] 1st mortgage interest rate 62 0.0825 0.105 0.11 0.0825 0.105 0.11 0.0825 0.105 0.11 0.105 0.0725
AVI[ 63] 1st mortgage term in Years (0=interest only) 63 30 30 30 30 30 30 30 30 30 30  
AVI[ 64] 1st mortgage months Til Balloon 64 180   180 180   180 180   180   180
AVI[ 65] 2nd mortgage loan to value ratio or $ amount 65 2000000 2000000 2000000 2000000 2000000 2000000 2000000 2000000 2000000   2000000
AVI[ 83] Developers share of ownership 83 1 1 1 0.01 0.01 0.01 0.01 0.01 0.01 1 1
AVI[ 85] Investors share of ownership 85       0.99 0.99 0.99 0.99 0.99 0.99    
AVI[ 86] Number of equity payments (for AVI[87]) 86       4 4 4 4 4 4    
AVI[ 87] Equity contribution ($ or % Costs Less Land&Fin.) 87       0.5 0.5 0.5 0.7 0.7 0.7    
AVI[ 89] When equity contribution available 89       2 2 2 2 2 2    
AVI[ 97] Return on equity allowable (for rent formula) 97 0.06 0.06 0.06 20 20 20 20 20 20 0.06 0.06
AVI[105] Credit Enhancement (e.g.annual points 1st mtge) 105 0.015 0.015   0.015 0.015   0.015 0.015   0.015  
AVI[120] Investors Tax Rate 120       0.34 0.34 0.34 0.34 0.34 0.34    
AVI[125] Points for Raising AVI[87] Equity Contribution 125       0.065 0.065 0.065 0.065 0.065 0.065    
AVI[130] Points 1st Mtge at Perm. Mtge.Close AVI[23 26] 130 0.05 0.03 0.03 0.05 0.03 0.03 0.05 0.03 0.03 0.03 0.05
AVI[159] Financing is tax exempt (default=not tax exempt) 159 1     1     1       1
AVI[172] LIHTC Tax Credit: Acquisition (e.g. .04) 172                      
AVI[173] LIHTC Tax Credit: Const./Major Rehab(.09 or .04) 173       0.04 0.09 0.09 0.04 0.09 0.09    
AVI[181] Required debt service coverage (e.g. 1.15 or 1.2) 181 1.1 1.1 1.15 1.1 1.1 1.15 1.1 1.1 1.15 1.1 1.1



 Home   E-Mail  home at CD root