rental property underwriting model

Real estate developers and investors often struggle with opaque spreadsheets that hide critical risks or rely on unverified assumptions. This skill converts raw property data into a transparent, auditable underwriting model for rental assets. It reconciles actual income and expenses with financing terms to produce a complete picture of Net Operating Income (NOI), debt coverage, and cash flow.

What it does

• Income & Expense Reconciliation builds schedules from rent rolls, occupancy evidence, and historical operating data.
• Debt Service Analysis calculates DSCR, loan-to-value ratios, and interest impacts on equity cash flow.
• Hold/Exit Modeling projects net exit proceeds and investment basis over a defined hold period.
• Sensitivity Testing delivers downside scenarios and identifies funding gaps based on explicit growth assumptions.
• Evidence-Based Reporting labels material unknowns and separates confirmed records from modeled assumptions.

How it works

1. Supply property data including price, rents, expenses, loan terms, and acquisition costs.
2. The skill reconciles the periods represented and builds a separated income/expense and financing model.
3. It calculates core metrics like cap rate, cash-on-cash return, and debt service coverage.
4. You receive an auditable breakdown of cash flow, investment basis, and exit proceeds.

Frameworks & tools

This skill is framework-agnostic and works with raw text, CSV data, or property records. It produces Markdown tables or editable artifacts if file creation tools are enabled in your agent environment.

Why this beats prompting it yourself

Standard prompts often hallucinate market data or fail to separate capital costs from operating expenses. This skill follows a rigorous accounting workflow that reconciles reporting periods and forces explicit labeling of unknowns to prevent bad investment decisions.

Use cases

• Acquisition Due Diligence to verify a seller's Pro Forma against actual historical records.
• Lender Preparation to generate DSCR and NOI metrics for commercial loan applications.
• Portfolio Stress-Testing to model how vacancy or interest rate changes impact cash-on-cash returns.

Known limitations

Does not provide professional tax or legal advice. Requires users to supply specific loan terms and growth assumptions for accurate projections. Cannot verify off-chain local zoning laws.