Answer
How do I see who changed an assumption in a real estate model?
In CRE Build, each changed line shows who changed it, the day and why, and the deal's Activity log records what happened, by whom and when. Lines that differ from the template carry a ◆ flag, and the inspector shows the impact if the line were reverted.
Answer
Can I write my own formulas in CRE Build?
Yes, on expense and budget lines. Custom formulas use a fixed subset of Excel syntax (IF, AND, OR, NOT, MIN, MAX, ABS, ROUND, SUM and AVERAGE) that references named variables, each read back as how and when it's computed ("Computed each month as …"). Expense lines also take Default, Hardcode or an Alternate method; budget lines take a stated amount.
What you do with it
Take over a line without losing track of it
The method band
Default is the template's method. Hardcode is your number, in your unit. Alternate method comes from the library. Custom formula is yours.
Custom formulas, read back as computed
On expense and budget lines, write formulas in a fixed subset of Excel syntax (IF, AND, OR, NOT, MIN, MAX, ABS, ROUND, SUM, AVERAGE) over named variables, read back as how and when the line is computed ("Computed each month as …").
The ◆ flag and Impact if reverted
A ◆ marks every line that differs from its baseline. Each changed line shows who changed it, the day and why, and the Inspector shows what reverting would do to IRR.
The Deviations section
Every line changed versus the baseline, with Who and why. Revert one line or all of them, and see each line's IRR impact.
Everything in one place
Everything line-item control does
- Default
- Hardcode
- Alternate method
- Custom formula
- ◆ deviation flag
- Inspector
- Impact if reverted
- Deviations
- Revert
- Revert all
- Who and why
Versions
Your edits autosave. Save a version whenever you're ready.
Save model commits a version (V1, V2 …). Compare any two line by line, with the IRR impact and who made each change.
Deal Activity
A per-deal log of what happened
Each changed line shows who changed it, the day and why, and the deal's Activity log records what happened: Created, Stage, Commit, Share, Note, Renamed, Duplicated, Archived, Restored, Deleted, Rates and Accept.
How it works
How it works
- 01
Select a line
Click any line item in a section.
- 02
Pick a method
Default, Hardcode, Alternate method or Custom formula.
- 03
See the flag and the impact
◆ on the line; Impact if reverted in the Inspector.
- 04
Review in Deviations
Revert one line or all of them, and Save model.
Methodology
Named lines, not cell addresses
Every line has a name, a method and its latest note: who changed it, the day and why. The methodology page shows how each figure is calculated.
FAQ
Questions
What are the ways to set a line?
Expense lines take four: Default, Hardcode, Alternate method and Custom formula. Budget lines take a stated amount or a custom formula, and any other input you change is flagged on the line. A custom formula is read back as how and when the line is computed ("Computed each month as …").
Can I undo an override?
Yes. The Deviations section lists every line changed from the baseline, with Revert and Revert all, and shows the IRR impact of each one.
Is every past note on a line kept?
No. Each line keeps its latest note, showing who changed it, the day and why. Saved versions and the Activity log cover what happened before that.
Pricing
Explore
Related features
Related feature
Versions & compare
Save versions, compare them line by line, and restore any one.
Explore →Related feature
Multifamily model
Every section of a multifamily deal, in order.
Explore →Related feature
Returns, sensitivity & scenarios
See what moves the deal before your investment committee does.
Explore →