The pro forma that is really a pitch
A common way to lose money is to underwrite to the pro forma instead of to actuals. The stabilized cap rate that assumes every unit is leased at market, vacancy drops to a tidy 3 percent, and expenses stay flat is not a real cap rate. It is a hope with a number attached.
The standard deliverable is supposed to carry a downside: sensitivity across exit cap scenarios, a conservative rent case, and a real vacancy case. Without them, the analysis reads as a pitch rather than an underwriting document. Anyone can model the version where everything goes right. Rigor is modeling the version where it does not.
Rigor is a linked model, not a prettier spreadsheet
The mechanical test of a serious model is simple: is the returns tab linked to the assumptions? Change the exit cap or the rent growth and the internal rate of return and the equity multiple should move on their own. A template that makes you retype a number in several places will eventually contain a version that disagrees with the others, and you will not know which one went to committee.
This is why "rigor" is not the same as "a nicer-looking spreadsheet." A beautiful model that is stitched together by hand is still one careless paste away from being wrong in a way nobody can see.
Manual transfers create false confidence
The biggest modeling risks are rarely exotic. They come from incomplete data, outdated assumptions, manual file transfers, and inconsistent version control. When rent rolls, operating statements, and valuation assumptions are copied across files by hand, the output can look authoritative while quietly resting on a number that changed two versions ago. That is worse than an obvious gap. It is false confidence, and it presents well right up until it does not.
Where the model lives decides whether it stays honest
All of this points at something the underwriting guides rarely say out loud: the discipline is easier to keep when the model is not a loose file. A model that lives on the deal, linked to its own assumptions and shared with the team from one record, removes the two failure modes above by construction. There are no manual transfers to drift, and there is one version, not seven.
MyDealTeams does not run your sensitivity analysis for you, and it will not tell you what your downside assumptions should be. What it does is give the model a home where it stays linked, current, and shared, so the rigor you bring is not undone by the medium you keep it in.
MyDealTeams is free during Early Access: Community free, Pro $69/month, everything free while we are in Early Access. Nothing to lose, and a deal team to organize.
Sources: [Thesis Driven: real estate pro forma](https://thesisdriven.com/guides/real-estate-pro-forma) · [The Cauble Group: CRE underwriting](https://www.tylercauble.com/blog/commercial-real-estate-underwriting-how-to) · [Blooma: CRE financial modeling](https://www.blooma.ai/blog/commercial-real-estate-financial-modeling)