Commercial Mortgage Loan Analysis Model V27
Operate the A.CRE Commercial Mortgage Loan Analysis Model (file `Commercial_Mortgage_Loan_Analysis_Model_v2_7.xlsx` or any v2.x commercial mortgage loan model) on the user's behalf, whether uploaded to chat or open live in Excel via the Claude add-in. Use whenever the user wants to size a commercial mortgage, underwrite a debt request, evaluate refinance proceeds, or compute a yield-maintenance prepayment fee on an existing loan. Trigger on phrases like "size this loan," "what's the max loan amount," "underwrite this debt request," "DSCR test," "debt yield test," "LTV test," "refinance proceeds," "yield maintenance," "prepayment fee," "commercial mortgage," or any combination of "loan" / "mortgage" / "debt" with "size," "underwrite," "test," "refi," or "prepay." Handles the full workflow from role triage through inputs and outputs. Do NOT trigger for equity returns analysis (use a property acquisition or development model), construction loan draw schedules, or mezzanine / preferred equity sizing.
Already included with AI.Edge Pro & A.CRE Accelerator
This skill is bundled into the A.CRE Intelligence Hub direct connector (MCP server) and is available to every AI.Edge Pro and A.CRE Accelerator member — no separate download required to use it.
Join AI.Edge Pro → What's AI.Edge Pro?What this skill does
Commercial Mortgage Loan Analysis Model V27 is an A.CRE Intelligence Hub skill that gives your AI agent the analyst-grade workflow a senior commercial real estate professional would run. Operate the A.CRE Commercial Mortgage Loan Analysis Model (file `Commercial_Mortgage_Loan_Analysis_Model_v2_7.xlsx` or any v2.x commercial mortgage loan model) on the user's behalf, whether uploaded to chat or open live in Excel via the Claude add-in. Use whenever the user wants to size a commercial mortgage, underwrite a debt request, evaluate refinance proceeds, or compute a yield-maintenance prepayment fee on an existing loan. Trigger on phrases like "size this loan," "what's the max loan amount," "underwrite this debt request," "DSCR test," "debt yield test," "LTV test," "refinance proceeds," "yield maintenance," "prepayment fee," "commercial mortgage," or any combination of "loan" / "mortgage" / "debt" with "size," "underwrite," "test," "refi," or "prepay." Handles the full workflow from role triage through inputs and outputs.
How you'll use it
Say something like this to your AI agent in the Hub, Claude, or ChatGPT to activate this skill.
Skill activation rules
Detailed routing logic, prompts the skill responds to, and operational guardrails as documented by the author.
Operate the A.CRE Commercial Mortgage Loan Analysis Model (file `Commercial_Mortgage_Loan_Analysis_Model_v2_7.xlsx` or any v2.x commercial mortgage loan model) on the user's behalf, whether uploaded to chat or open live in Excel via the Claude add-in. Use whenever the user wants to size a commercial mortgage, underwrite a debt request, evaluate refinance proceeds, or compute a yield-maintenance prepayment fee on an existing loan. Trigger on phrases like "size this loan," "what's the max loan amount," "underwrite this debt request," "DSCR test," "debt yield test," "LTV test," "refinance proceeds," "yield maintenance," "prepayment fee," "commercial mortgage," or any combination of "loan" / "mortgage" / "debt" with "size," "underwrite," "test," "refi," or "prepay." Handles the full workflow from role triage through inputs and outputs. Do NOT trigger for equity returns analysis (use a property acquisition or development model), construction loan draw schedules, or mezzanine / preferred equity sizing.
What's inside
Commercial Mortgage Loan Analysis Model — Operator Skill
You are operating the A.CRE Commercial Mortgage Loan Analysis Model on behalf of the user. This skill teaches you (1) what investment decision the model is solving for, (2) how to triage the user into the correct…
Show full previewShow less
Commercial Mortgage Loan Analysis Model — Operator Skill
You are operating the A.CRE Commercial Mortgage Loan Analysis Model on behalf of the user. This skill teaches you (1) what investment decision the model is solving for, (2) how to triage the user into the correct workflow based on their role, (3) how to read and write the model safely, and (4) how to interpret the outputs.
Distributed under the A.CRE software license — see LICENSE.txt in the skill bundle. Permitted for personal, organizational, and client-facing analysis; not for resale or systematic redistribution. Use by an AI assistant operating on behalf of an authorized human user is expressly permitted.
The model in one paragraph
Full instructions and any reference files ship in the .skill bundle.
commercial-mortgage-loan-analysis-model-v27/
├── SKILL.md # Required: instructions + metadata
├── assets/ # Optional: templates, resources
│ └── Commercial_Mortgage_Loan_Analysis_Model_v2_7.xlsx # 254.3 KB
└── references/ # Optional: documentation
├── acre-modeling-conventions.md # 3.2 KB
├── inputs.md # 13.4 KB
├── outputs.md # 13.4 KB
├── recalc.md # 5.5 KB
└── role-workflows.md # 14.6 KB
How to run it
Not in the Hub? Download the .skill bundle above and follow the A.CRE skills install guide → to load it into Claude Desktop, ChatGPT, Cursor, or any other agent that supports skills.
Already in the Hub. If you're an AI.Edge Pro or A.CRE Accelerator member, this skill is bundled into the A.CRE Intelligence Hub direct connector (MCP server) — just ask your agent.
About this skill
Proprietary A.CRE skill. © Adventures in CRE, LLC. Bundled into the A.CRE Intelligence Hub direct connector and available to AI.Edge Pro and A.CRE Accelerator members.