Manual Deal Studio entry. Any prefilled numbers are illustrative, not facts about a selected listing; verify all assumptions.
04 Investment mandate & evidence Rent roll, leases, deposits, and delinquencies verified Legal use, zoning, permits, and unit count verified Physical inspection and capital plan completed Post-acquisition property tax confirmed Binding insurance quote obtained Lender term sheet and debt sizing confirmed Title, survey, access, and liens reviewed
Hurdles determine the maximum investment basis. Evidence controls the confidence level; unchecked items remain diligence conditions, not assumed facts. DSCR on NOI is the usual quote; many lenders size on NOI after replacement reserves and TI, which this page also reports.
05 Monte Carlo risk laboratoryEvery run includes all three cases so the committee view is complete regardless of the result tab in focus. The simulation runs on this device and shows its progress.
Interest-rate band: follows the interest rate you entered (6.75%).Vacancy band: follows the vacancy you entered (5%).Exit-cap band: follows the exit cap rate you entered (6.5%).The simulation draws the loan's interest rate from the band above, which follows the interest rate you entered until you change the band yourself. For a loan whose rate is fixed, set low, mode and high to that rate. The vacancy and exit-cap bands follow the vacancy and exit cap you entered the same way, with the mode a point above vacancy and a quarter point above the exit cap, so the simulation leans to the downside; the rent and expense bands are illustrations to set to your own view.
Reproducible triangular distributions, percentile outcomes, downside probabilities, and excluded-iteration disclosure.
Run Monte Carlo Every metric includes its formula, components, assumptions, warnings, and audit version.
Download deal-specific Excel Run base analysis