Each skill is a detailed, expert-written guide that teaches your AI exactly how to perform a specific CRE analysis task — the same way you'd train a junior analyst, but available on-demand.
Building a Development Model from Scratch
Build a complete ground-up real estate development model from scratch. Use when modeling a new construction project end-to-end including budget, draw schedule, lease-up, and exit. NOT for acquisition underwriting, value-add apartment models, or standalone development cash flow spreading.
Discounted Cash Flow (DCF) Method – CRE Valuation
Build a complete discounted cash flow valuation of income-producing CRE. Use when projecting cash flows, deriving IRR and equity multiple, running sensitivity tables, or pricing a deal with multi-year assumptions. NOT for direct-cap shortcut valuations or DCF model anatomy/teaching.
Industrial Income Statement Analysis
Read, transpose, and analyze industrial property income statements. Use when interpreting warehouse operating statements, modeling triple-net reimbursements, calculating leasing cost reserves, or summarizing industrial OpEx. NOT for multifamily, office, retail, or hotel income statements.
Multifamily Income Statement and Rent Roll Analysis
Read, transpose, and analyze multifamily income statements and rent rolls. Use when interpreting apartment operating statements, calculating loss-to-lease, normalizing concessions and vacancy, or summarizing OpEx categories. NOT for office, retail, industrial, or hotel income statements.
Retail Income Statement – Reading, Transposing, and Annualizing
Read, transpose, and annualize retail income statements. Use when interpreting retail operating statements, modeling base and percentage rent, computing CAM and tax reimbursements, or assessing occupancy cost ratios. NOT for multifamily, office, industrial, or hotel income statements.
Building a Value-Add Apartment Model from Scratch
Build a single-worksheet multifamily value-add model from scratch. Use when underwriting an apartment renovation with rolling renovation schedule, blended rents, multi-tranche debt, and GP/LP waterfall. NOT for stabilized acquisitions, ground-up development, or non-multifamily value-add.
Hotel Income Statement – Structure, Line Items, and Key Metrics
Read and analyze hotel income statements organized by the Uniform System of Accounts. Use when interpreting lodging operating statements, calculating RevPAR and ADR, computing departmental profits, or analyzing GOP. NOT for multifamily, office, retail, or industrial income statements.
Modeling Development Cash Flow
Spread development budget line items over time using bell-curve, steady-growth, straight-line, and custom periodic formulas. Use when building monthly construction cash flows, area/budget tabs, or unlevered development returns. NOT for construction loan debt modeling or building a full acquisitions/value-add model.
Modeling Development Debt and the Draw Schedule
Model a construction loan draw schedule and interest reserve, including the circular reference and Solver-based LTC calibration. Use when building development debt, sizing loan fees, modeling capitalized interest, or calculating levered development returns. NOT for permanent loan amortization or development cost spreading.
Modeling Short and Long-Term Leases
Model short-term and long-term commercial lease cash flows. Use when projecting month-to-month or annual lease income, building multi-year leases with escalations, or comparing lease structures across property types.
Office Income Statement – Reading, Transposing, and Annualizing
Read, transpose, and annualize office income statements. Use when interpreting office operating statements, normalizing contractual rent and expense escalations, modeling tenant reimbursements, or analyzing CAM charges. NOT for multifamily, retail, industrial, or hotel income statements.
Key Risk and Return Metrics – CRE Investment Analysis
Calculate and interpret CRE investment metrics including IRR, equity multiple, cash-on-cash, yield-on-cost, and return partitioning. Use when computing investment returns, comparing deals, or splitting return between income and appreciation.
Hub Recipes
Run pre-built multi-dataset recipes combining A.CRE Intelligence Hub data into a focused signal. Use when asked to run a recipe by name, combine Hub datasets for an address, or check oversupply, rate exposure, demand story, or macro backdrop. NOT a replacement for full analysis skills.
Modeling Real Estate Debt
Model permanent real estate debt from scratch. Use when building interest-only or amortizing loan schedules, computing DSCR and debt yield, sizing a loan, or calculating loan payoff. NOT for construction loans, draw schedules, or development interest reserves.
Modeling Partnership Cash Flows (Waterfall Model)
Model partnership cash flow distributions through a multi-tier waterfall. Use when structuring GP/LP splits, computing preferred returns and promote, tracking capital accounts, or distributing exit proceeds across hurdles.
Anatomy of the Real Estate DCF – Model Structure and Hold/Sell Analysis
Explain the three-component structure of a real estate DCF — investment, operating, and reversion cash flows — and perform hold/sell analysis. Use when teaching DCF model layout, framing hold-vs-sell decisions, or interpreting an existing DCF. NOT for building a new DCF valuation or running direct-cap valuation.
Direct Capitalization Method – CRE Valuation
Value income-producing CRE using the direct capitalization method. Use when computing value from stabilized NOI and a cap rate, deriving cap rates from comps, or applying valuation adjustments. NOT for multi-year DCF valuation or DCF model anatomy/teaching.
Offering Memorandum Market Slides
Generate data-backed demographics and employment slides for a CRE offering memorandum using A.CRE Intelligence Hub data. Use when a user asks for OM market slides, trade area demographics, employment overview, or pitch book market section for an address. NOT for full OM creation or financial underwriting.
Building an Acquisitions Model from Scratch
Build a full acquisition underwriting model from scratch for any CRE property type. Use when modeling a stabilized acquisition with multi-tab structure, debt sizing, partnership waterfall, and returns. NOT for ground-up development models or value-add apartment renovation models.