What we show
- Industry-standard formulas
- Input-to-output relationships
- Worked examples with numbers
- Interpretation rules and caveats
Solsten is US commercial real estate underwriting software built around deterministic, assumption-driven calculations. The goal is straightforward: help teams model faster without sacrificing clarity around how outputs are produced.
This page is the public methodology layer: we show core formulas, required inputs, and worked examples for major metric families. We do not disclose proprietary implementation details.
EGI is modeled as potential income net of vacancy and credit loss.
EGI = PGI - Vacancy Loss - Credit Loss + Other Income NOI is operating income after operating expenses, before debt service and below-the-line items.
NOI = EGI - Operating Expenses EGI = 1,250,000 - 90,000 + 40,000 = $1,200,000
NOI = 1,200,000 - 470,000 = $730,000
Solsten follows ARGUS/Altus-style occupancy logic for operating expense scaling.
Occupancy % = Occupied Rentable SF / Total Rentable SF Common area is excluded from both numerator and denominator.
To avoid double-counting occupancy effects, entered amounts are normalized to a 100% baseline.
occupancy_factor = percent_fixed + (1 - percent_fixed) * occupancy
base_100 = entered_amount / occupancy_factor
forecast_amount = base_100 * inflation_factor * occupancy_factor occupancy_factor = 0.20 + (0.80 × 0.50) = 0.60
base_100 = 1,000 / 0.60 = $1,666.67
Tenant pays pro-rata share of recoverable expenses.
Tenant Recovery = Recoverable Pool * Tenant Pro-Rata Share Tenant pays only expense growth above a base-year level.
Excess = max(0, Current Recoverable Pool - Base Year Pool)
Tenant Recovery = Excess * Tenant Pro-Rata Share Uses gross-up logic on selected categories before allocation.
Grossed Pool = Eligible Expenses / Gross-Up Occupancy Factor
Tenant Recovery = Grossed Pool * Tenant Pro-Rata Share DSCR = NOI / Annual Debt Service LTV = Loan Balance / Estimated Market Value NPV = SUM( CashFlow_t / (1 + discount_rate)^t ) - Initial Equity Equity Multiple = Total Distributions / Total Equity Invested IRR is the discount rate that makes net present value equal to zero.
Find r such that: 0 = SUM( CashFlow_t / (1 + r)^t ) - Initial Equity Solsten provides calculation and reporting tools for user-supplied inputs. Content and demonstrations are for software education only and do not constitute financial, investment, legal, tax, or underwriting advice.
Create a free account to review workflow-level guidance inside the app.