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   

Low Income Housing Tax Credit Syndication Demo

Input array: AVI

AVI[1] No. of acres (or sq.ft. of land) 8.75
AVI[2] Land cost (/acre or /sq.ft.)(Total $ if AVI[1]=0) 40000
AVI[6] Units to develop 144
AVI[12] Land development 5100
AVI[13] Building cost ($/sq.ft.if AVI[101]=sq.ft.) 36
AVI[20] Est.const.int,fin.fees,acctg.adj.(ProCash checks) 2301.388889
AVI[27] Contruction interest to impose (or CSF[;12]) 400
AVI[37] Bridge loan interest rate:equity & operations 0.095
AVI[41] Other income/unit (vacancy applies;ex.AVI[7]units) 84
AVI[44] Start-up operating losses (financed & expensed) 4217.119093
AVI[53] Vacancy rate (in normal operating years) 0.07
AVI[55] Operating expenses (fixed, per unit) 1550
AVI[59] Rounding factor for financing amounts (e.g.1000) 1000
AVI[60] Capital replacement (decimal of DFI or $/unit/yr) 150
AVI[61] 1st mortgage loan to value Ratio or $ Amount 1
AVI[62] 1st mortgage interest rate 0.095
AVI[63] 1st mortgage term in Years (0=interest only) 25
AVI[65] 2nd mortgage loan to value ratio or $ amount 0.33
AVI[66] 2cd mortgage interest rate 0.03
AVI[67] 2cd mortgage term in years (0=interest only) 25
AVI[69] Who provides 2nd mortgage (see AVI[ 65]) 6
AVI[83] Developers share of ownership 0.01
AVI[85] Investors share of ownership 0.99
AVI[86] Number of equity payments (for AVI[87]) 4
AVI[87] Equity contribution ($ or % Costs Less Land&Fin.) 0.7
AVI[89] When equity contribution available 2
AVI[90] Land lease rate (% of AVI[92] Price or $/Year) 0.06
AVI[93] Who will own land (if land lease exists) 1
AVI[101] Square feet/unit (affects AVI[13]) 786
AVI[102] Utilities allowance (for rent formula, AVI[3] periods) 63.33
AVI[105] Credit Enhancement (e.g.annual points 1st mtge) 0.0125
AVI[106] Who Gets Credit Enhancement (see AVI[105]) 7
AVI[120] Investors Tax Rate 0.34
AVI[125] Points for Raising AVI[87] Equity Contribution 0.065
AVI[128] Points 1st Mtge at Const. Loan Settlem AVI[24] 0.065
AVI[130] Points 1st Mtge at Perm. Mtge.Close AVI[23 26] 0.03
AVI[131] Annual Growth Rate for Gross Income MV[1] 0.03
AVI[132] Annual Growth Rate for Operating Expenses MV[2] 0.05
AVI[150] Term Over Which to Depreciate Capital Improvements MV[23] 7
AVI[152] Exclude operating losses AVI[44] from mortgage financing(0=inc.)MV[25]  
AVI[156] Inv.Returned Before Dist.in End.Vlu.(0) or Inv.Ignored (1) MV[29] 1
AVI[173] LIHTC Tax Credit: Const./Major Rehab(.09 or .04) MV[50] 0.09
AVI[190] Preserve 1st period as cost to date, discount future only MV[68] 1
AVI[194] Experimental:depreciate & inc. for LIHTC land dev. & F&E MV[72] 1



 Home   E-Mail  home at CD root