Reconcile FactLot's DCF with another system's export (ARGUS or any other model; parity is not claimed and is untested against real ARGUS output): give the calc_dcf_pro_forma input plus the other system's annual lines {label, values: [year 1, …]}, optionally its value, unlevered IRR and sale price, a tolerance (absolute and relative) and your label mapping. Labels map to FactLot lines by your mapping, else by common CRE line names (Potential Base Rent, Absorption & Turnover Vacancy, Free Rent, Expense Reimbursements, General Vacancy, Credit Loss, Effective Gross Revenue, Operating Expenses, Net Operating Income, Tenant Improvements, Leasing Commissions, Capital Reserves, Cash Flow Before Debt Service); positive deductions are negated (sign_convention). Returns per line and year FactLot's amount, the other amount, the difference and whether it is within tolerance; unmapped labels; and for each differing line a likely_cause from FactLot's documented conventions, worded as a hypothesis to check: differences only in rollover years (fractional downtime and free rent), a rate on a different base (general vacancy), only the exit year, a one-year shift, management fee inside operating expenses, a growth rate, a constant factor or amount, rounding; and for the value FactLot rerun with mid-year or end-of-year discounting, the other exit NOI basis, or no selling costs. Deterministic: the same inputs always give the same result, with formula ID calc.reconcile_dcf@1, every step, and any warnings.
View input schema
{
"type": "object",
"properties": {
"dcf": {
"type": "object",
"properties": {
"hold_years": {
"type": "integer",
"minimum": 1,
"maximum": 30,
"description": "Holding period in years. The property is sold at the end of the last year; one more year is projected for the forward NOI."
},
"leases": {
"minItems": 1,
"maxItems": 200,
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 200,
"description": "Suite or tenant label, e.g. \"Suite 200\"."
},
"area_sf": {
"type": "number",
"description": "Leased area, SF. Must be greater than 0.",
"minimum": 0
},
"rent_psf_annual": {
"type": "number",
"minimum": 0,
"description": "Current in-place base rent, USD/SF/yr (0 for space vacant at the start)."
},
"months_remaining": {
"type": "integer",
"minimum": 0,
"maximum": 600,
"description": "Months left on the lease from the analysis start: the lease runs through this month (1 = expires at the end of month 1). 0 means the space is vacant at the start and is leased to a new tenant after downtime_months."
},
"escalation_rate": {
"default": 0,
"description": "Annual bump in the in-place rent, e.g. 0.03, applied first in next_escalation_month and every 12 months after. Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"next_escalation_month": {
"default": 13,
"description": "Analysis month of the next in-place rent bump (default 13, the start of year 2). Use the lease's anniversary month.",
"type": "integer",
"minimum": 1,
"maximum": 600
},
"free_rent_months_remaining": {
"default": 0,
"description": "Months of in-place free base rent still to run from the analysis start (months 1 to this are abated).",
"type": "integer",
"minimum": 0,
"maximum": 600
},
"recovery": {
"default": "nnn",
"description": "In-place expense recovery: \"nnn\", \"gross\", or \"base_year\" (needs base_year_opex_psf_annual).",
"type": "string",
"enum": [
"nnn",
"gross",
"base_year"
]
},
"base_year_opex_psf_annual": {
"description": "Operating expenses in the lease's base year, USD/SF/yr: the tenant pays the excess above it. Required when recovery is base_year.",
"type": "number",
"minimum": 0
},
"market_rent_psf_annual": {
"type": "number",
"minimum": 0,
"description": "Market rent for this space today, USD/SF/yr. Grows at market_rent_growth_rate each analysis year."
},
"leasing": {
"type": "object",
"properties": {
"renewal_probability": {
"type": "number",
"minimum": 0,
"maximum": 1,
"description": "Probability the tenant renews at expiration, 0 to 1 (e.g. 0.65). Blends the renewal and new-tenant assumptions below."
},
"lease_term_months": {
"type": "integer",
"minimum": 1,
"maximum": 240,
"description": "Term of each lease signed at rollover (renewal or new tenant), months."
},
"downtime_months": {
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months vacant before a new tenant starts paying (no downtime is assumed on renewal). Blended downtime = (1 − renewal_probability) × this, kept fractional, not rounded: the suite is vacant for the whole months and the rollover lease's first month collects 1 − the fraction of its rent and recoveries (0.45 months of downtime: the first month collects 55%)."
},
"renewal_rent_pct_of_market": {
"type": "number",
"maximum": 2,
"description": "Renewal rent as a share of market rent, e.g. 0.95 for a 5% renewal discount; new tenants pay market rent. Must be greater than 0.",
"minimum": 0
},
"rent_escalation_rate": {
"type": "number",
"minimum": 0,
"description": "Annual bump in a rollover lease's base rent, compounding every 12 months from its start, e.g. 0.03. Must be less than 1.",
"maximum": 1
},
"free_rent_months_new": {
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months of free base rent for a new tenant at the start of its lease."
},
"free_rent_months_renewal": {
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months of free base rent on a renewal. Blended free rent = p × this + (1 − p) × free_rent_months_new, kept fractional: the whole months are fully abated and the next month by the fraction."
},
"ti_psf_new": {
"type": "number",
"minimum": 0,
"description": "Tenant improvement allowance for a new tenant, USD/SF in today's dollars (grown at market_rent_growth_rate to the lease start)."
},
"ti_psf_renewal": {
"type": "number",
"minimum": 0,
"description": "Tenant improvement allowance on a renewal, USD/SF in today's dollars."
},
"lc_rate_new": {
"type": "number",
"minimum": 0,
"description": "Leasing commission for a new tenant as a share of the base rent payable over the lease term after free rent, e.g. 0.06. Must be less than 1.",
"maximum": 1
},
"lc_rate_renewal": {
"type": "number",
"minimum": 0,
"description": "Leasing commission on a renewal, same basis, e.g. 0.03. Must be less than 1.",
"maximum": 1
},
"recovery": {
"type": "string",
"enum": [
"nnn",
"gross",
"base_year"
],
"description": "Expense recovery on rollover leases: \"nnn\" (tenant pays its share of operating expenses), \"gross\" (none), or \"base_year\" (expenses above the lease's first-year level)."
}
},
"description": "Per-lease overrides of market_leasing (any subset of its fields)."
}
},
"required": [
"name",
"area_sf",
"rent_psf_annual",
"months_remaining",
"market_rent_psf_annual"
]
},
"description": "Rent roll: one entry per lease or vacant suite (at most 200). The building area is the sum of their areas."
},
"market_leasing": {
"type": "object",
"properties": {
"renewal_probability": {
"type": "number",
"minimum": 0,
"maximum": 1,
"description": "Probability the tenant renews at expiration, 0 to 1 (e.g. 0.65). Blends the renewal and new-tenant assumptions below."
},
"lease_term_months": {
"type": "integer",
"minimum": 1,
"maximum": 240,
"description": "Term of each lease signed at rollover (renewal or new tenant), months."
},
"downtime_months": {
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months vacant before a new tenant starts paying (no downtime is assumed on renewal). Blended downtime = (1 − renewal_probability) × this, kept fractional, not rounded: the suite is vacant for the whole months and the rollover lease's first month collects 1 − the fraction of its rent and recoveries (0.45 months of downtime: the first month collects 55%)."
},
"renewal_rent_pct_of_market": {
"default": 1,
"type": "number",
"maximum": 2,
"description": "Renewal rent as a share of market rent, e.g. 0.95 for a 5% renewal discount; new tenants pay market rent. Must be greater than 0.",
"minimum": 0
},
"rent_escalation_rate": {
"default": 0,
"type": "number",
"minimum": 0,
"description": "Annual bump in a rollover lease's base rent, compounding every 12 months from its start, e.g. 0.03. Must be less than 1.",
"maximum": 1
},
"free_rent_months_new": {
"default": 0,
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months of free base rent for a new tenant at the start of its lease."
},
"free_rent_months_renewal": {
"default": 0,
"type": "integer",
"minimum": 0,
"maximum": 60,
"description": "Months of free base rent on a renewal. Blended free rent = p × this + (1 − p) × free_rent_months_new, kept fractional: the whole months are fully abated and the next month by the fraction."
},
"ti_psf_new": {
"default": 0,
"type": "number",
"minimum": 0,
"description": "Tenant improvement allowance for a new tenant, USD/SF in today's dollars (grown at market_rent_growth_rate to the lease start)."
},
"ti_psf_renewal": {
"default": 0,
"type": "number",
"minimum": 0,
"description": "Tenant improvement allowance on a renewal, USD/SF in today's dollars."
},
"lc_rate_new": {
"default": 0,
"type": "number",
"minimum": 0,
"description": "Leasing commission for a new tenant as a share of the base rent payable over the lease term after free rent, e.g. 0.06. Must be less than 1.",
"maximum": 1
},
"lc_rate_renewal": {
"default": 0,
"type": "number",
"minimum": 0,
"description": "Leasing commission on a renewal, same basis, e.g. 0.03. Must be less than 1.",
"maximum": 1
},
"recovery": {
"default": "nnn",
"type": "string",
"enum": [
"nnn",
"gross",
"base_year"
],
"description": "Expense recovery on rollover leases: \"nnn\" (tenant pays its share of operating expenses), \"gross\" (none), or \"base_year\" (expenses above the lease's first-year level)."
}
},
"required": [
"renewal_probability",
"lease_term_months",
"downtime_months"
],
"description": "Market leasing assumptions applied at every lease expiration (and to space vacant at the start). A lease's own `leasing` object overrides any of them."
},
"market_rent_growth_rate": {
"default": 0,
"description": "Annual market rent growth, e.g. 0.03. Market rent and TI in analysis year y = today's × (1 + g)^(y − 1). Must be greater than -1. Must be less than 1.",
"type": "number",
"minimum": -1,
"maximum": 1
},
"operating_expenses_psf_annual": {
"default": 0,
"description": "Year-1 recoverable operating expenses, USD/SF/yr over the whole building area.",
"type": "number",
"minimum": 0
},
"non_recoverable_expenses_annual": {
"default": 0,
"description": "Year-1 operating expenses no tenant reimburses, USD/yr.",
"type": "number",
"minimum": 0
},
"expense_growth_rate": {
"default": 0,
"description": "Annual growth of operating expenses and capital reserves, e.g. 0.03: year y = year 1 × (1 + g)^(y − 1). Must be greater than -1. Must be less than 1.",
"type": "number",
"minimum": -1,
"maximum": 1
},
"management_fee_rate": {
"default": 0,
"description": "Management fee as a share of effective gross revenue, e.g. 0.03; not recovered. Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"general_vacancy_rate": {
"default": 0,
"description": "General vacancy allowance as a share of gross revenue (base rent after free rent, plus recoveries), on top of the downtime modelled at rollover. Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"credit_loss_rate": {
"default": 0,
"description": "Credit loss as a share of gross revenue, on top of general vacancy. Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"capital_reserve_psf_annual": {
"default": 0,
"description": "Year-1 capital reserve, USD/SF/yr over the building area, below NOI. Grows with expense_growth_rate.",
"type": "number",
"minimum": 0
},
"exit_cap_rate": {
"type": "number",
"description": "Exit (terminal) cap rate applied to the exit NOI, e.g. 0.07. Must be greater than 0. Must be less than 1.",
"minimum": 0,
"maximum": 1
},
"exit_noi_basis": {
"default": "forward",
"description": "\"forward\": the NOI of the year after the hold (the usual convention); \"trailing\": the NOI of the final hold year.",
"type": "string",
"enum": [
"forward",
"trailing"
]
},
"selling_cost_rate": {
"default": 0,
"description": "Selling costs as a share of the gross sale price, e.g. 0.02. Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"discount_rate": {
"type": "number",
"minimum": 0,
"description": "Annual unlevered discount rate, e.g. 0.08. The present value at this rate is the value. Must be less than 1.",
"maximum": 1
},
"timing": {
"default": "end_of_year",
"description": "\"end_of_year\": each year's cash flow is discounted (1 + r)^y (Excel NPV). \"mid_year\": operating cash flows at (1 + r)^(y − 0.5); the sale is always discounted at the end of the hold.",
"type": "string",
"enum": [
"end_of_year",
"mid_year"
]
},
"purchase_price": {
"description": "Price paid at the start, USD. Adds the NPV (value − price), the unlevered IRR and the going-in cap rate on price. Must be greater than 0.",
"type": "number",
"minimum": 0
}
},
"required": [
"hold_years",
"leases",
"market_leasing",
"exit_cap_rate",
"discount_rate"
],
"description": "The FactLot DCF input, exactly as calc_dcf_pro_forma takes it (the same rent roll and assumptions you entered in the other system)."
},
"other": {
"type": "object",
"properties": {
"system": {
"default": "other system",
"description": "Name of the system or file the lines come from, echoed in the result, e.g. \"ARGUS export, Nov 2026\" (free text).",
"type": "string",
"minLength": 1,
"maxLength": 200
},
"lines": {
"minItems": 1,
"maxItems": 200,
"type": "array",
"items": {
"type": "object",
"properties": {
"label": {
"type": "string",
"minLength": 1,
"maxLength": 200,
"description": "Line name as the other system prints it, e.g. \"Potential Base Rent\". Compared ignoring case and punctuation, \"&\" read as \"and\"."
},
"values": {
"minItems": 1,
"maxItems": 31,
"type": "array",
"items": {
"type": "number"
},
"description": "Annual amounts in USD, year 1 first, one per analysis year (the hold plus the year after it at most). Deductions may be negative or positive; see sign_convention."
}
},
"required": [
"label",
"values"
]
},
"description": "The other system's annual cash-flow lines (factlot.reconcile_files reads them from a CSV or XLSX)."
},
"value": {
"description": "The other system's present value at the discount rate, USD.",
"type": "number"
},
"unlevered_irr": {
"description": "The other system's unlevered IRR as a decimal (0.0825 for 8.25%). Compared only when dcf.purchase_price is given. Must be greater than -1.",
"type": "number",
"maximum": 1,
"minimum": -1
},
"gross_sale_price": {
"description": "The other system's gross sale (reversion) price before selling costs, USD.",
"type": "number"
},
"net_sale_proceeds": {
"description": "The other system's sale proceeds after selling costs, USD.",
"type": "number"
}
},
"required": [
"lines"
],
"description": "What the other system reported for the same property."
},
"mapping": {
"default": [],
"description": "Your label mappings; they override the defaults (common CRE line names such as Potential Base Rent, General Vacancy, Net Operating Income, Cash Flow Before Debt Service).",
"maxItems": 200,
"type": "array",
"items": {
"type": "object",
"properties": {
"label": {
"type": "string",
"minLength": 1,
"maxLength": 200,
"description": "A label in other.lines (matched ignoring case and punctuation)."
},
"line": {
"type": "string",
"enum": [
"potential_base_rent",
"free_rent",
"expense_recoveries",
"gross_revenue",
"general_vacancy",
"credit_loss",
"effective_gross_revenue",
"operating_expenses",
"management_fee",
"net_operating_income",
"tenant_improvements",
"leasing_commissions",
"capital_reserves",
"cash_flow_before_debt",
"turnover_vacancy",
"ignore"
],
"description": "FactLot line to compare it with. \"turnover_vacancy\" is a deduction compared together with potential_base_rent (FactLot's potential base rent already excludes rollover downtime); \"ignore\" leaves the line out. Several labels mapped to one line are summed."
}
},
"required": [
"label",
"line"
]
}
},
"sign_convention": {
"default": "auto",
"description": "FactLot reports deductions (free rent, vacancy, credit loss, expenses, fees, TI, commissions, reserves) as negative amounts. \"auto\": a deduction line whose amounts are all zero or positive is read as positive deductions and negated; \"as_reported\": compare as given; \"deductions_positive\": negate every deduction line.",
"type": "string",
"enum": [
"auto",
"as_reported",
"deductions_positive"
]
},
"tolerance": {
"default": {
"absolute": 1,
"relative": 0,
"irr": 0.0001
},
"description": "When two amounts agree: |FactLot − other| ≤ max(absolute, relative × |other|); the IRR within irr. Default: 1.00 USD, 0, and one basis point.",
"type": "object",
"properties": {
"absolute": {
"default": 1,
"description": "Largest difference, USD, still counted as agreeing (default 1.00).",
"type": "number",
"minimum": 0
},
"relative": {
"default": 0,
"description": "Largest difference as a share of the other system's amount still counted as agreeing, e.g. 0.0001; the larger of the two tolerances applies (default 0). Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
},
"irr": {
"default": 0.0001,
"description": "Largest IRR difference still counted as agreeing, as a decimal (default 0.0001, one basis point). Must be less than 1.",
"type": "number",
"minimum": 0,
"maximum": 1
}
}
}
},
"required": [
"dcf",
"other"
],
"$schema": "http://json-schema.org/draft-07/schema#"
}