| AVI[1] No. of acres (or sq.ft. of land) |
7.07 |
| AVI[2] Land cost (/acre or /sq.ft.)(Total $ if AVI[1]=0) |
143564.3564 |
| AVI[6] Units to develop |
202 |
| AVI[11] Depr. assets acquired |
6290.841584 |
| AVI[13] Building cost ($/sq.ft.if AVI[101]=sq.ft.) |
16.06849725 |
| AVI[17] Furniture & equipment |
3237.306931 |
| AVI[18] Misc. admin |
12.84158416 |
| AVI[20] Est.const.int,fin.fees,acctg.adj.(ProCash checks) |
13546.56436 |
| AVI[26] Mortgage close (mos.after opening, % rented, or date) |
6 |
| AVI[37] Bridge loan interest rate:equity & operations |
0.1 |
| AVI[40] Minimum income/unit before vacancy(ex.AVI[7]units) |
443.9009901 |
| AVI[50] Other income (inflation not applied unless MV[15]) |
17040 |
| AVI[51] Other income (vacancy rate not applied) |
9696 |
| AVI[53] Vacancy rate (in normal operating years) |
0.05 |
| AVI[60] Capital replacement (decimal of DFI or $/unit/yr) |
115.6188119 |
| AVI[61] 1st mortgage loan to value Ratio or $ Amount |
5838700 |
| AVI[62] 1st mortgage interest rate |
0.0925 |
| AVI[63] 1st mortgage term in Years (0=interest only) |
40 |
| AVI[96] Mortgage amounts based on cost (default=value) |
1 |
| AVI[101] Square feet/unit (affects AVI[13]) |
893.1485149 |
| AVI[102] Utilities allowance (for rent formula, AVI[3] periods) |
53.79207921 |
| AVI[105] Credit Enhancement (e.g.annual points 1st mtge) |
0.0075 |
| AVI[113] Capitalization Rate for Ending Value(0=Orig.Cost) |
7294617.622 |
| AVI[135] Periods from Start of Analysis to Opening(MV[18]) MV[5] |
0.5833333333 |
| AVI[150] Term Over Which to Depreciate Capital Improvements MV[23] |
7 |
| AVI[151] Depreciation Rate Capital Improvements (0 if ACRS) MV[24] |
2 |
| AVI[152] Exclude operating losses AVI[44] from mortgage financing(0=inc.)MV[25] |
|
| AVI[154] Appreciation Rate Current Market Value if AVI[113]>1 MV[27] |
0.04 |
| AVI[155] Periods to Lag MV[27] App.Rate to be Conservative MV[28] |
1 |
| AVI[158] Starting Year (if MV[31]=0, then 1 2..) MV[31] |
1987 |
| AVI[173] LIHTC Tax Credit: Const./Major Rehab(.09 or .04) MV[50] |
0.09 |
| AVI[174] LIHTC Units Qualifying (Low Income Hsg.TaxCredit) MV[51] |
0.7720343989 |
