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   

Guggenheim LIHTC Tests

Input array: ALTI

  AVI/MV Trial 1 Trial 2 Trial 3 Trial 4 Trial 5 Trial 6 Trial 7
AVI[ 2] Land cost (/acre or /sq.ft.)(Total $ if AVI[1]=0) 2 5000 2100 1500 900 5000 2100 1500
AVI[ 11] Depr. assets acquired 11   18900 13500 18100   18900 13500
AVI[ 13] Building cost ($/sq.ft.if AVI[101]=sq.ft.) 13 50000 17500 14000 1000 50000 17500 14000
AVI[ 20] Est.const.int,fin.fees,acctg.adj.(ProCash checks) 20 2607.93 1635.24 1242.29 719.27 3572.58 2509.03 2029.261343
AVI[ 44] Start-up operating losses (financed & expensed) 44 5495.141177 3041.618062 2335.723979 1076.407103 2980.16852 2163.030222 3192.341624
AVI[ 55] Operating expenses (fixed, per unit) 55 2400 2700 2700 2700 2400 2700 2700
AVI[ 62] 1st mortgage interest rate 62 0.105 0.105 0.105 0.105 0.09 0.09 0.09
AVI[ 87] Equity contribution ($ or % Costs Less Land&Fin.) 87 0.5926666667 0.6267696268 0.6238888889 0.6609947644 0.698 0.6978021978 0.6972727273
AVI[130] Points 1st Mtge at Perm. Mtge.Close AVI[23 26] 130 0.03 0.03 0.03 0.03 0.07 0.07 0.07
AVI[159] Financing is tax exempt (default=not tax exempt) 159         1 1 1
AVI[172] LIHTC Tax Credit: Acquisition (e.g. .04) 172   0.04 0.04 0.04   0.04 0.04
AVI[173] LIHTC Tax Credit: Const./Major Rehab(.09 or .04) 173 0.09 0.09 0.09   0.04 0.04 0.04



 Home   E-Mail  home at CD root