| 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 |
