Pillar II · Templates · Forthcoming Q3 2026
The Excel patterns CRE analysts use every single day.
A reference cheat sheet plus working examples workbook covering the Excel patterns CRE analysts actually use — XIRR, NPV with irregular cash flows, lease-level NER math, debt yield trios, time-weighted vs. dollar-weighted returns, sensitivity-table mechanics.
What it is
~30 patterns
The patterns that come up daily in acquisitions, asset management, and capital markets.
PDF + XLSX
Printable cheat sheet + companion workbook with each pattern as a working example.
$12
$19 retail. 30 days no-questions refund.
Who this is for
CRE analysts
First or second year in the role. Build up the reference patterns in the first month rather than the first year.
Career-changers into CRE
Transitioning from finance, consulting, or operations. Learn the CRE-specific Excel conventions without retracing every general-finance pattern.
Asset managers
Refresh the patterns you don't use daily. The lease-level NER math, the dollar-weighted return calc, the LTC drawdown schedule.
Solo sponsors
DIY analysis without paying for a full UW Workbook subscription. The cheat sheet gets you 80% of the toolkit.
What's in the file
- XIRR for irregular cash flows
- NPV vs. XNPV (the common error)
- Lease-level NER math (free rent, TI allowance)
- Debt service coverage + debt yield + LTV trios
- Sensitivity tables (Data Table mechanics)
- Goal Seek + Solver for refinance sizing
- Time-weighted vs. dollar-weighted returns
- Equity multiple + average equity calc
- Pivot-table patterns for rent rolls
FAQ
Does it cover VBA or Power Query?
No. Both are out of scope — both add complexity that outweighs the benefit for most CRE analyst workflows. The reference focuses on native formulas and Data Table mechanics.
Google Sheets compatibility?
~90% of the patterns work identically in Google Sheets. The Data Table mechanics (sensitivity tables) differ; an addendum flags the Sheets-equivalent approach.
Refund policy?
30 days, no questions, no forms. Email support@valoreregistry.com.
Pricing
Retail at release $19
Founders' price (first 14 days) $12
Single ZIP delivery: PDF cheat sheet + XLSX companion. Free point-update releases for 12 months. Informational only.