Once you've imported a property's data into your Excel workbook, the pro-forma is yours to model. This page covers a few less-obvious features.
Cell notes carry rationales
Every assumption cell carries a cell note with the AI rationale. Hover the cell to see the note:
Year-1 rent growth: 3.0% Submarket median rent growth past 24 months (3.2%), discounted slightly for incoming supply pipeline (8% increase to inventory over 18 mo).
The note travels with the cell. If you copy/paste assumption cells into another worksheet, the rationale travels with them.
Named ranges for the model
The imported pro-forma uses named ranges for assumptions and inputs:
RentGrowth_Y1,RentGrowth_Y2, …Vacancy_Y1,Vacancy_Y2, …ExitCapRate,HoldPeriod, …
You can reference named ranges in formulas elsewhere in the workbook. The names are stable across re-imports.
The pro-forma comparison view
The taskpane has a Pro-forma comparison view that shows the cloud pro-forma side-by-side with your worksheet's current values. Edits you've made show up as deltas. Useful for:
- A quick "did I move IRR materially?" check.
- Spotting accidental overwrites of derived cells.
- A pre-push-back review.
Common operations
- Switch to base case. Re-import discards your worksheet edits and pulls the cloud version. (Push back first if you want to preserve.)
- Sandbox a what-if scenario. Duplicate the Pro-Forma sheet, edit the duplicate. The original stays in sync with the cloud; your duplicate is your scratch.
- Plug into a master template. Reference the named ranges from your firm's standard template.
What changes mid-model
A re-export from the web (or a re-import here) can change the structure of the model in rare cases — adding a new line item, renaming a section. The taskpane warns you when a structural change happened since your last import; you'll be asked to either re-import or live with the structural mismatch (which is allowed but means push-back may flag certain rows).