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    Format413    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format408    Format415    Format416    Format417   

Guggenheim Demo

Input array: ALTI

  AVI/MV Trial 1 Trial 2 Trial 3 Trial 4 Trial 5 Trial 6 Trial 7 Trial 8
AVI[ 2] Land cost (/acre or /sq.ft.)(Total $ if AVI[1]=0) 2 5000 5000 5000 10000 3000 5000 5000 3000
AVI[ 11] Depr. assets acquired 11   10000   10000   10000   7000
AVI[ 13] Building cost ($/sq.ft.if AVI[101]=sq.ft.) 13 55000 45000 70000 55000 35000 42500 70000 28000
AVI[ 15] Architecture & engineering 15 15000 15000 18750 18750 9000 15000 16667 8000
AVI[ 18] Misc. admin 18 5000 5000 6250 6250 3000 7500 8333 4000
AVI[ 55] Operating expenses (fixed, per unit) 55 3240 3300 3600 3600 2700 3300 3600 2700
AVI[ 62] 1st mortgage interest rate 62 0.085 0.085 0.085 0.085 0.085 0.07 0.07 0.07
AVI[ 63] 1st mortgage term in Years (0=interest only) 63 28.8956 28.8956 28.8956 28.8956 28.8956 29.076 29.076 29.076
AVI[ 87] Equity contribution ($ or % Costs Less Land&Fin.) 87 7 7 7 7 7 7.5 7.5 7.5
AVI[102] Utilities allowance (for rent formula, AVI[3] periods) 102 75 75 80 80 75 75 80 75
AVI[130] Points 1st Mtge at Perm. Mtge.Close AVI[23 26] 130                
AVI[159] Financing is tax exempt (default=not tax exempt) 159           1 1 1
AVI[173] LIHTC Tax Credit: Const./Major Rehab(.09 or .04) 173 0.09 0.04 0.09 0.04 0.09 0.04 0.09 0.04


 Home   E-Mail  home at CD root