Summitwoods Apartments - Underwriting Model.xlsx

Underwriting Model · filed February 17, 2023 · deal: Summitwoods Apartments
Tab: Summary
Summary
Going-in cap rate (T-3 NOI / purchase price)5.67%Purchase CAP Rate
Tab: Returns
Returns
Exit, year 6: sale at a 5.92% cap rate$8,890,000Expected Sale Proceeds
Cash-on-cash by year: Y1 4.8%, Y2 5.4%, Y3 6.1%, Y4 7.0%, Y5 7.1%, Y6 7.3%Projected Returns - Yearly (1-10?)
Levered IRR15.6%Expected IRR - Hold
Equity multiple2.19xExpected Equity Multiple - Hold
Hold period6 years (exit 2029)Expected Hold
Refinance in 2027 at 65% LTV on stabilized valueExpected Refi Year
Refinance proceeds: new loan $5,580,000, less payoff $4,550,000 = $1,030,000 to equityExpected Refi Proceeds
Tab: Debt
Debt
Rate typeFixedLoan #1 - Floating or Fixed
Interest rate6.13% fixedLoan #1 - Rate
AmortizationAmortizing (30-year schedule)Loan #1 - I/O or Amortizing
Term5 yearsLoan #1 - Term
MaturityMarch 6, 2028Loan #1 - Maturity Date
Tab: Capex
Capex
Renovation program complete2024Last Renovated
Capital budget: Roof $119,500, Unit renovations $426,700, Amenities $51,200; total $597,400Budgeted Capex (by category)
Interior upgrades on 38 of 96 units as they turn, $11,229 per unitUnits to Rehab
On file

Nothing is read from this document for the fields below: having it on file is the answer.

Answers: UW

A static rendering for this demo: the passages each deal-sheet value was read from, highlighted where they sit. In the application this link opens the filed document itself. Every name and figure on it is invented.

Static demo · synthetic data · read-only  ↩