Help us improve
Share bugs, ideas, or general feedback.
Generate a real estate pro forma model in Python or Excel format
npx claudepluginhub aznatkoiny/zai-skills --plugin real-estate-investmentHow this command is triggered — by the user, by Claude, or both
Slash command
/real-estate-investment:pro-formaThe summary Claude sees in its command listing — used to decide when to auto-load this command
# Generate Pro Forma Model
ARGUMENTS: Optional output format ("python", "excel", or "both")
## Instructions
When this command is invoked, generate a complete real estate pro forma financial model:
### 1. Collect Property Details
Use AskUserQuestion to gather:
- **Property type**: SFR, multifamily, commercial, STR
- **Purchase price and acquisition costs**
- **Financing terms**: Down payment, interest rate, loan term, amortization
- **Income assumptions**: Monthly rent, vacancy rate, other income, annual growth rate
- **Operating expenses**: Property taxes, insurance, maintenance, manag.../3-statement-modelPopulates a 3-statement financial model template (Income Statement, Balance Sheet, Cash Flow Statement) using provided file path or prompts for one.
/effective-rentAnalyzes lease deal economics using the Ponzi Rental Rate framework. Extracts terms from lease documents, matches landlord parameters, runs NPV/NER analysis, and generates an investment report.
/returnsBuilds IRR/MOIC sensitivity tables for PE deals across entry multiple, leverage, exit multiple, and growth scenarios. Uses provided parameters or prompts for entry EBITDA, valuation, and financing assumptions.
/financial-model-architectBuilds 3-5 year financial models projecting revenue, expenses, headcount, cash flow, runway, unit economics, scenarios, and profitability path. Generates investor-ready HTML reports with projections and charts.
/financial-projectionsCreates interactive 3-5 year startup financial model with cohort revenue, costs, headcount, cash flow, key metrics, and conservative/base/optimistic scenarios.
/budget-narrativeGenerates professional budget narratives and financial summaries for property board review, including variance explanations and assessment impact analysis.
Share bugs, ideas, or general feedback.
ARGUMENTS: Optional output format ("python", "excel", or "both")
When this command is invoked, generate a complete real estate pro forma financial model:
Use AskUserQuestion to gather:
Ask for output format (skip if provided via ARGUMENTS):
Read the financial metrics reference:
the references/financial-metrics.md file from the real-estate-investment skill in this plugin
Create a complete Python pro forma model using the RealEstateProForma class pattern from the reference:
Include:
Output:
pro_forma.py in working directoryCreate cell-by-cell Excel layout with formulas:
Structure:
Provide formulas for:
=B3*(1+$C$5)^A10 (where B3=Year 1 rent, C5=growth rate, A10=year)=B10*$C$6 (where C6=vacancy rate)=B10-C10=EGI-Total OpEx=PMT($C$8,$C$9,-$C$7) (rate, periods, loan amount)=NOI-DebtService=SUM($H$10:H10)=XIRR(CashFlows, Dates)Output:
pro_forma_formulas.txt with clear layout instructionsCreate both Python script and Excel formula layout.
Save generated file(s) to the user's working directory and confirm: