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 Excel in the toolbar above the pro-forma table. (It's hidden while you're in Edit mode or while the pro-forma is generating.)
- Your browser downloads the file.
The download is a single .xlsx file named proforma_ followed by the property's ID. It contains the last saved version of the model, so save any pending edits first.
What's in the file
- ProForma sheet — the full 10-year model. Income, loss, and operating expense lines are values; section totals, EGI, NOI, Net Cash Flow, debt service, DSCR, cash flows, and valuation metrics are formulas.
- Inputs sheet — the assumptions the formulas use: cap rate, tax rate, down payment, loan amount, interest rate, amortization, and annual debt service, plus each line's Year-1 value and implied growth rate for reference.
- Review sheet — added (and opened first) only when Relm flagged the pro-forma as needing review, with the reasons listed.
Formulas, not values
The exported file uses formulas for derived cells. Effective Gross Income is Income + Losses and NOI is EGI + Operating Expenses (expenses are negative), not hard-coded numbers. This means:
- You can edit any line-item value — or the cap rate, tax rate, down payment, or annual debt service on the Inputs sheet — and the totals and metrics recompute. The line items themselves are values, so changing a growth rate on the Inputs sheet doesn't reproject them.
- 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.
Divisions are guarded, so a zero denominator shows 0 rather than #DIV/0!.
What edits round-trip back
The downloaded file is one-way — edits you make in it don't sync back to Relm, even if you have the Excel add-in installed. That's fine for a final hand-off. To keep editing in Excel and send changes back, open the pro-forma through the Excel add-in instead (Import to Excel, then Push to Relm). See Push-back from Excel.
Re-exporting
Re-exporting creates a new .xlsx with the current saved 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 amounts in US dollars as plain numbers with thousands separators (negatives in red parentheses), without a currency symbol. Apply a currency format via Excel's number-format menu if you want one.