Crosswater Portfolio - Underwriting Model.xlsx

Underwriting Model · filed January 26, 2022 · deal: Crosswater Portfolio
Tab: Summary
Summary
Going-in cap rate (T-3 NOI / purchase price)5.55%Purchase CAP Rate
Tab: Returns
Returns
Exit, year 6: sale at a 5.80% cap rate$42,900,000Expected Sale Proceeds
Cash-on-cash by year: Y1 4.2%, Y2 5.2%, Y3 6.0%, Y4 6.8%, Y5 7.0%, Y6 7.2%Projected Returns - Yearly (1-10?)
Levered IRR15.6%Expected IRR - Hold
Equity multiple2.19xExpected Equity Multiple - Hold
Hold period6 years (exit 2028)Expected Hold
Refinance in 2026 at 65% LTV on stabilized valueExpected Refi Year
Refinance proceeds: new loan $26,940,000, less payoff $21,968,000 = $4,970,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
MaturityFebruary 13, 2027Loan #1 - Maturity Date
Tab: Capex
Capex
Renovation program complete2023Last Renovated
Capital budget: Roof $576,800, Unit renovations $2,060,000, Amenities $247,200; total $2,884,000Budgeted Capex (by category)
Interior upgrades on 120 of 300 units as they turn, $17,167 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  ↩