to home page  Home   E-Mail  SiteTree (all case studies)    HomePage    Index (this case study)    MV    AVI    KICKERS    UNITMIX    ALTI    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   

Turnkey Syndication (+2.5%/yr)

Input array: AVI

AVI[1] No. of acres (or sq.ft. of land) 8.27
AVI[2] Land cost (/acre or /sq.ft.)(Total $ if AVI[1]=0) 42321.6445
AVI[6] Units to develop 144
AVI[12] Land development 5146.895833
AVI[13] Building cost ($/sq.ft.if AVI[101]=sq.ft.) 30.02992883
AVI[14] Service structures 1666.666667
AVI[15] Architecture & engineering 926.7013889
AVI[18] Misc. admin 380.5555556
AVI[19] Expensed costs (except interest) 40
AVI[20] Est.const.int,fin.fees,acctg.adj.(ProCash checks) 2292.278091
AVI[21] Contingency, errors & ommissions 1580.597222
AVI[27] Contruction interest to impose (or CSF[;12]) 393.7222222
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) 3099.201295
AVI[53] Vacancy rate (in normal operating years) 0.07
AVI[55] Operating expenses (fixed, per unit) 1550
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[64] 1st mortgage months Til Balloon 180
AVI[65] 2nd mortgage loan to value ratio or $ amount 1,200,000
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[70] First kicker 0.0528652637
AVI[76] Who gets first kicker (see AVI[ 70]) -7
AVI[83] Developers share of ownership  
AVI[84] Lenders 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.6924050231
AVI[89] When equity contribution available 2
AVI[90] Land lease rate (% of AVI[92] Price or $/Year) -1
AVI[93] Who will own land (if land lease exists) 1
AVI[96] Mortgage amounts based on cost (default=value) 1
AVI[97] Return on equity allowable (for rent formula) 0.08
AVI[102] Utilities allowance (for rent formula, AVI[3] periods) 63.33
AVI[105] Credit Enhancement (e.g.annual points 1st mtge) 83.33333333
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.06541666667
AVI[128] Points 1st Mtge at Const. Loan Settlem AVI[24] 63000
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.0386
AVI[132] Annual Growth Rate for Operating Expenses MV[2] 0.05
AVI[148] Who Accepts Developer Role MV[21] 9
AVI[149] Partners Share Oper.Losses(0) No=1 (2=dev.meets from Fin./Eq) MV[22]  
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[156] Inv.Returned Before Dist.in End.Vlu.(0) or Inv.Ignored (1) MV[29] 1
AVI[158] Starting Year (if MV[31]=0, then 1 2..) MV[31] 1987
AVI[164] Who Accepts Lender Role MV[37] 8
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] 1
AVI[186] Base Data in MV[64] 7



 Home   E-Mail  home at CD root