Riverbend Commons - Underwriting Model.xlsx

Underwriting Model · filed September 11, 2021 · deal: Riverbend Commons
Tab: Summary
Summary
Going-in cap rate (T-3 NOI / purchase price)5.92%Purchase CAP Rate
Tab: Returns
Returns
Exit, year 6: sale at a 6.17% cap rate$16,300,000Expected Sale Proceeds
Cash-on-cash by year: Y1 6.4%, Y2 6.7%, Y3 7.0%, Y4 7.2%, Y5 7.6%, Y6 8.0%Projected Returns - Yearly (1-10?)
Levered IRR13.6%Expected IRR - Hold
Equity multiple1.99xExpected Equity Multiple - Hold
Tab: Debt
Debt
Rate typeFixedLoan #1 - Floating or Fixed
Interest rate5.04% fixedLoan #1 - Rate
AmortizationAmortizing (30-year schedule)Loan #1 - I/O or Amortizing
Term5 yearsLoan #1 - Term
MaturitySeptember 29, 2026Loan #1 - Maturity Date
Tab: Capex
Capex
Capital budget: Roof $231,600, Unit renovations $827,300, Amenities $99,300; total $1,158,200Budgeted Capex (by category)
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  ↩