What “Pro Forma Software” Actually Needs to Solve
A pro forma is a projection of a property’s cash flows over a hold period, built to answer one question: what is this asset worth to me, given what I know about its income, its expenses, and how both will change. That definition sounds simple. In practice, the tool you use to build it determines how much of the underlying complexity you actually capture versus how much you approximate.
The category of “pro forma software” spans three very different approaches: general-purpose spreadsheet templates, purpose-built enterprise cash flow engines like Argus, and a newer generation of web-based underwriting platforms that combine modeling with document extraction. Acquisitions professionals evaluating this space are usually choosing between speed of setup, depth of lease-level modeling, and how much manual data entry they are willing to accept.
For a broader walkthrough of the underwriting process itself, see our commercial real estate underwriting guide, and for the mechanics of the calculation, our real estate pro forma guide.
The Core Requirements of a Real Pro Forma Tool
Six capabilities separate a pro forma that survives diligence from one that collapses under scrutiny.
Contractual rent steps, not flat growth assumptions. Most commercial leases have scheduled rent increases written into the document: fixed dollar steps, percentage increases, or CPI-indexed adjustments. A tool that models rent growth as a single blended assumption across the portfolio will diverge from actual contractual cash flow the moment a handful of leases have irregular step schedules, which is the norm rather than the exception in any multi-tenant asset.
Recovery and expense reimbursement structures. Triple net, modified gross, and base-year stop leases each shift operating expense risk differently between landlord and tenant. A pro forma that nets out expenses at the property level without modeling tenant-by-tenant recovery will overstate or understate net operating income, sometimes materially, on any asset with a mixed rent roll.
Rollover and releasing assumptions. Every lease expires eventually. A pro forma needs an explicit assumption for what happens next: renewal probability, downtime between tenants, releasing costs (tenant improvements and leasing commissions), and market rent at the time of rollover. Tools that ignore rollover, or bury it in a single portfolio-wide vacancy factor, understate both the risk and the leasing capital required to sustain the asset.
Debt and refinancing events. A hold period pro forma that only models a static loan at acquisition misses the more common real-world case: a bridge loan refinanced into permanent debt 18-24 months in, or a value-add plan that assumes a cash-out refinance funds a return of capital before exit. The tool needs to let you insert a mid-hold refinancing event without rebuilding the model.
Exit valuation methodology. Terminal value is typically calculated via a direct capitalization of forward NOI or a full discounted cash flow approach. The tool should support both and make the exit cap rate assumption an explicit, auditable input rather than a number buried in a formula.
An audit trail back to source documents. When an investment committee asks where a specific rent figure came from, “it’s in the spreadsheet” is not an answer. The strongest pro forma tools tie every modeled figure back to the lease clause, rent roll line, or operating statement entry that produced it.
Pro Forma Software Landscape: Category Comparison
| Category | Examples | Setup Speed | Lease-Level Modeling | Document Extraction | Audit Trail | Best For |
|---|---|---|---|---|---|---|
| Spreadsheet templates | Custom Excel models, downloadable templates | Fast (minutes) | Manual, as detailed as you build it | None — manual entry | Only as good as your own formulas | Single-asset deals, teams with a proven internal template |
| Enterprise cash flow engines | Argus Enterprise, Rockport VAL | Slow (days to weeks) | Deep, lease-by-lease native modeling | Limited | Strong, institutionally recognized | High-volume shops underwriting complex multi-tenant assets |
| Modern web underwriting platforms | Moraine, and category peers | Fast (same day) | Varies by platform — increasingly lease-level | AI-driven extraction from rent rolls and leases (where supported) | Increasingly built in, ties output to source docs | Teams that want spreadsheet speed with fewer manual entry errors |
Argus Enterprise remains the institutional standard for lease-by-lease cash flow modeling, particularly for office and retail assets with complex rollover profiles; it is what many lenders and joint venture partners expect to see when reviewing a deal. The tradeoff is a real learning curve and licensing cost that makes it hard to justify for lower deal volumes or simpler asset types. Our Argus software overview and appraisal methods guide cover where a formal cash flow engine earns its cost.
Rockport VAL occupies similar territory to Argus for teams that want lease-level modeling with a somewhat different workflow and pricing structure, and is worth evaluating alongside Argus rather than as a categorically different tool.
Spreadsheet templates, whether built in-house or purchased, remain the right choice for a large share of single-asset, straightforward deals. Their limitation is manual entry rather than modeling depth: a well-built Excel model can handle rent steps and recoveries just fine, but every typed input is a potential transcription error, and the model doesn’t scale gracefully across a growing pipeline.
The newer category of web-based underwriting platforms, where Moraine operates, targets the middle ground: modeling that captures lease-level detail without Argus’s setup overhead, combined with document AI that reads rent rolls, leases, and operating statements directly rather than requiring manual transcription. For a due diligence team running multiple deals concurrently, removing the data entry step is often a bigger accuracy lever than any modeling refinement, since rent roll software errors compound directly into pro forma output.
Selection Criteria: What to Actually Evaluate
Deal volume should be the first filter. A shop underwriting one or two deals a quarter rarely needs more than a well-built spreadsheet template; the fixed cost of learning a new platform outweighs the time saved. A shop running ten or more deals a month, or evaluating a large portfolio, hits the limits of manual entry fast, and the calculus shifts toward automation regardless of category.
The second filter is asset class complexity. Multifamily pro formas are comparatively simple — unit mix, market rent growth, and a handful of expense line items. Office, industrial, and retail pro formas carry lease-level complexity that punishes any tool without genuine rollover and recovery modeling. A tool evaluated favorably for multifamily may be inadequate for a mixed-use retail center with twenty different lease structures.
Team composition is easy to underweight. A team with a dedicated Excel modeler who maintains institutional formulas may get more mileage from a flexible spreadsheet than from a rigid platform template. A leaner team without a full-time modeler benefits more from a platform that handles the modeling logic natively and lets analysts focus on assumptions rather than formula maintenance.
Finally, weigh how the tool fits into the rest of diligence. A pro forma built in isolation from lease abstraction, rent roll verification, and T-12 reconciliation forces analysts to reconcile three separate workstreams by hand. Platforms that connect pro forma modeling to the underlying document review, including our own, reduce that reconciliation burden, which is where most of the time savings in a compressed diligence window actually comes from. We built Moraine around that connection: pulling rent roll and lease data directly into the underwriting model rather than treating document review and modeling as separate steps.
The Pro Forma Selection Table
| Criteria | Spreadsheet Template | Argus Enterprise / Rockport VAL | Modern Web Platform |
|---|---|---|---|
| Cost | Free to ~$200 one-time | Enterprise license, typically per-seat | Per-deal or subscription pricing |
| Time to first model | Minutes | Days to weeks (setup + training) | Hours |
| Handles complex rent steps | Yes, if built correctly | Yes, natively | Varies — check lease-level depth |
| Recovery structures (NNN, MG, base year) | Manual formula work | Native | Increasingly native |
| Document data extraction | None | Limited | AI-driven, where supported |
| Institutional recognition | Depends on firm | High — industry standard | Growing |
| Best fit | Single-asset, low volume | High-volume, complex multi-tenant | Teams prioritizing speed + fewer manual errors |
Multifamily vs. Commercial: Different Pro Forma Demands
The complexity a pro forma tool needs to handle diverges sharply by asset class, and that divergence should drive the category choice.
Multifamily pro formas are built around unit-level rent comps, a market rent growth assumption, and a relatively short list of operating expense categories: payroll, utilities, repairs and maintenance, real estate taxes, insurance. Turnover assumptions and loss-to-lease matter, but the modeling surface is narrow enough that a well-built spreadsheet template handles it comfortably for most single-asset deals. Where multifamily pro formas get harder is at portfolio scale, where dozens of properties each need unit-mix-specific comps and the reconciliation burden across properties becomes the real bottleneck rather than any single model’s complexity.
Office, retail, and industrial pro formas carry a fundamentally different burden: every tenant is effectively its own mini-model, with a distinct rent schedule, recovery structure, option package, and rollover date. A twenty-tenant retail center has twenty separate contractual cash flow streams that all need to be modeled correctly and then aggregated, which is exactly the scenario where flat blended assumptions break down and lease-by-lease engines like Argus, Rockport VAL, or a document-AI-driven platform earn their cost. Industrial net-lease portfolios sit closer to multifamily in simplicity per asset, but the underwriting stakes per tenant are often higher given single-tenant concentration risk.
Mixed-use and value-add deals combine both problems: multifamily-style unit modeling on some floors, commercial lease-by-lease modeling on others, plus a capital plan and repositioning timeline layered on top. These are the deals where the choice of pro forma tool has the highest consequence, because errors compound across asset types rather than staying contained to one modeling approach.
Build vs. Buy: The Internal Template Question
Many acquisitions teams, particularly at established shops, have an internal Excel pro forma template refined over years of deals, with house conventions for growth assumptions, formatting that matches the IC memo format, and formulas the whole team already trusts. That institutional muscle memory is a real asset, and it’s a legitimate reason to stay on a spreadsheet rather than migrate to a platform, even when volume would otherwise justify it.
The calculus changes when the bottleneck isn’t the model itself but what feeds it. If the team’s actual time sink is retyping rent roll line items and reconciling lease amendments against the operating statement before the model even opens, no amount of spreadsheet refinement fixes that; the constraint has moved upstream to document review. In that case, either pairing the existing template with a document extraction tool that outputs clean, model-ready data, or moving the whole workflow onto a platform that combines modeling with extraction, addresses the actual constraint. Teams evaluating this tradeoff should time an actual deal end-to-end, from data room receipt to a defensible pro forma, before assuming the spreadsheet is still the faster path.
What to Watch Out For
The most common failure mode in pro forma software is silent approximation. A tool that lets you input a single blended rent growth rate instead of forcing you to model actual contractual steps will produce a plausible-looking output that’s simply wrong the moment you compare it to the underlying leases. The same applies to tools that model vacancy as a flat percentage rather than tying it to an actual rollover schedule.
Before adopting any pro forma tool, run it against a deal you’ve already closed and reconcile the output line by line against the actual leases and operating statements. If the tool can’t reproduce known contractual cash flow without manual overrides, it will not hold up on a deal where you don’t already know the answer. This is also where document-level verification, cross-checking a T-12 against modeled expenses, catches most of the errors that a pro forma alone won’t surface.
The right tool is the one that matches your deal complexity and volume without forcing you to either over-invest in enterprise software you don’t need or under-model a deal that genuinely requires lease-level detail.