Report catalog

The catalog behind Reports & exports: 29 reports in five groups. Add any of them to a package in any order; Sheet is the worksheet tab name the report produces in the exported workbook.

Returns & Valuation

Report	Sheet	What’s on it — and the question it answers
Deal Snapshot	Deal Snapshot	Pricing, cap rates, IRR, equity multiple, DSCR, headline metrics — “give me the deal on one page”
Annual Cash Flow	Annual Cash Flow	The full pro forma build, potential gross revenue → NOI → levered cash flow, by year
Monthly Cash Flow	Monthly Cash Flow	The same rows and styling, one column per month across the hold — the Argus-paste companion
XIRR Working	XIRR Working	The exact dated cash-flow series behind levered and unlevered IRR — rebuild the IRR with =XIRR in Excel
Valuation & Returns	Valuation & Returns	DCF value, NPV, resale, going-in and exit caps, yield-on-cost — “how was this valued?”
Exit & Resale Analysis	Exit Analysis	The reversion build: forward NOI, exit cap, selling costs, loan payoff, prepayment penalty, net proceeds
Sensitivity Matrix	Sensitivity	Two-axis IRR grids, each cell a full engine run — “where does the deal break?”
Partnership Waterfall	Waterfall	Tier-by-tier distribution working: timing, source splits, hurdles, GP fees, promote splits, LP/GP totals
In-Place vs. Pro Forma NOI	In-Place vs Pro Forma	The bridge from in-place income to Year-1 pro forma NOI, with per-line commentary — “what are we assuming improves?”

Debt & Financing

Report	Sheet	What’s on it — and the question it answers
Debt Schedule & Terms	Debt Schedule	Every loan: principal, sizing, rate, amortization, term, I/O, origination
Debt Service Ledger	Debt Service Ledger	Annual interest, principal, fees, ending balance, DSCR, debt yield — the debt audit trail
Refinance Analysis	Refinance Analysis	Per refi event: sizing method, NTM NOI, implied value, proceeds, retired loans, cash to equity

Revenue & Leases

Report	Sheet	What’s on it — and the question it answers
Rent Roll	Rent Roll	The as-modeled rent roll: suites, areas, terms, rents, steps, recovery methods
Tenancy Summary	Tenancy Summary	Occupied vs vacant roll-up with percent-of-property and available-space detail
Tenant Cash Flow Detail	Tenant Cash Flows	Per-tenant, per-year: base rent, steps, CPI, abatements, recoveries, TI and LC — “show me this tenant’s whole story”
Building Area Occupancy	Occupancy	Occupied area by month and year against net rentable area
Lease Expiration Schedule	Expiry Schedule	Rollover exposure by year: expiring leases, SF, share of rent
Market Leasing Assumptions	MLAs	The MLA matrix: market rent, renewal probability, downtime, TI/LC, free rent, term
Lease-Up & Absorption	Lease-Up	The vacant-space absorption plan with start rents, costs, timing
Expiring Rent vs. Market	Expiring vs Market	Each expiring lease’s contract rent against market grown to that date, spread in $/SF and % — “how much upside is in the rollover?”
Lease Metrics	Lease Metrics	WALT, retention, loss-to-lease, net effective rents, releasing spreads
Rent Schedule Audit	Rent Schedule Audit	Per-lease rent build: starting rent, every step with dates, CPI escalations — the check-my-rent-math sheet

Expenses & Recoveries

Report	Sheet	What’s on it — and the question it answers
Operating Expense Schedule	Expense Schedule	Every expense line: growth, PSF, above/below-line position, recoverability
Recovery Structures	Recovery Structures	Per-tenant recovery setup: pools, methods, pro-rata shares, stops, caps, admin fees
Recovery by Expense Line Item	Recovery by Expense	Each expense line with how much every tenant recovers against it, by year
Recovery by Tenant	Recovery by Tenant	Each tenant’s total recoveries, broken out by expense line, by year
Reimbursement Audit	Reimbursement Audit	The full trail per tenant per year: eligible expense → share → stop → admin fee → billed — the sheet that settles recovery arguments

Assumptions & Audit Trail

Report	Sheet	What’s on it — and the question it answers
Assumptions Register	Assumptions	Every value-moving input in one sheet: growth, vacancy, debt, exit, capital, discounting
Source Lineage & Warnings	Sources & Warnings	Two sections: where each number came from (document, page, confidence) and the engine’s warnings register — “prove it”

Every exported workbook also carries the non-suppressible trust stamp — rating, issue counts, model version, and as-of timestamp.