When you need to hand off the pro-forma — to a partner, an investor, or your IC committee — Excel export gives you a .xlsx of the full model with formulas live.
How to export
- Open the Financial section of the property.
- Click Export to Excel in the section header.
- Pick a destination on your machine.
The download is a single .xlsx file with the property name and date in the filename.
What's in the file
- Cover sheet — property summary (address, asset class, units, year built, key returns).
- Pro-forma — the full 10-year model with formulas on derived cells.
- Assumptions sheet — every assumption Relm used, with rationales as cell notes.
- Debt schedule — amortization table, IO period, refi date if applicable.
- Returns summary — IRR, equity multiple, DSCR, peak/trough operating metrics.
- Citations sheet — for each cell with a citation, the source URL or document page.
Formulas, not values
The exported file uses formulas for derived cells. Year 4 EGI is =GPR_Y4 - VacancyConcessions_Y4, not a hard-coded number. This means:
- You can edit any input (rent growth, vacancy assumption) and the model recomputes.
- Excel's "Trace Precedents" works as expected, so the model is auditable.
- The model is also portable — paste cells into a master template and references hold.
Relm-emitted formulas are wrapped in IFERROR(..., "") so empty or error states render blank rather than #REF! or #DIV/0!.
What edits round-trip back
If you have the Excel add-in installed, edits you make in Excel can be pushed back to Relm. See Push-back from Excel.
Without the add-in, the exported .xlsx is one-way — edits there don't sync back to Relm. That's fine for a final hand-off but tedious if you keep editing on both sides.
Re-exporting
Re-exporting creates a new .xlsx with the current state. Older exports are not invalidated — you can keep prior snapshots if you want a paper trail.
Limitations
- No charts. Charts require asset-class-specific styling we haven't standardized; build your own off the data.
- No conditional formatting. Same reason.
- No macros. Relm-exported files are macro-free for security.
- Workbook protection. Cells aren't locked by default — your team can edit anything.
Common issues
- "Excel says formulas need to be enabled." That's Excel's default for downloaded files. Click "Enable Editing" in the yellow security bar.
- Numbers look truncated. Excel sometimes auto-narrows columns; widen them.
- Currency format is wrong. Relm exports in USD by default. Change the currency format on the relevant cells via Excel's number-format menu.