An acquisition of a suburban logistics asset. Change any assumption and the five-year cash flow, debt metrics, returns and sensitivity grid rebuild together, the way an investment committee actually interrogates a case. Flags appear when an assumption starts doing too much work.
$ thousands · year 5 includes net sale proceeds
Exit cap rate (rows) × NOI growth (columns) · base case outlined
Equity multiple decomposed · $ thousands
IRR, multiple, cash-on-cash, DSCR and debt yield move together. An attractive IRR that needs a 1.15x DSCR is a different proposition from one that doesn't, and the committee should see both at once.
The sensitivity grid re-runs the whole model for every cell, so the question "what if exit caps widen 75 bps and growth halves?" is answered before it's asked.
Exit cap tighter than entry, growth above market, leverage past covenant headroom: the page says so, in plain words, as soon as it happens.
