Advanced Amortization Table V32
Operate the A.CRE Advanced Amortization Table (file `Advanced-Mortgage-Amortization-v3_2.xlsx` or any v3.x advanced amortization 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 build a monthly loan amortization schedule, compute lender yield/APR, duration, average life, or balloon payoff for a fixed- or variable-rate commercial mortgage, or model an assumed loan. Trigger on phrases like "build an amortization schedule," "amortize this loan," "what's the monthly payment," "loan payoff at year X," "lender yield," "APR," "duration and average life," "variable-rate loan with a SOFR curve," "loan assumption schedule," or any combination of "amortization" / "loan" / "mortgage" with "schedule," "payment," "payoff," "yield," or "interest." Do NOT trigger for loan sizing (LTV/DSCR-constrained — use a property or development model), DSCR / debt-yield analysis (needs NOI), or prepayment-penalty / yield-maintenance calculations.
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
Advanced Amortization Table V32 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 Advanced Amortization Table (file `Advanced-Mortgage-Amortization-v3_2.xlsx` or any v3.x advanced amortization 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 build a monthly loan amortization schedule, compute lender yield/APR, duration, average life, or balloon payoff for a fixed- or variable-rate commercial mortgage, or model an assumed loan.
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 Advanced Amortization Table (file `Advanced-Mortgage-Amortization-v3_2.xlsx` or any v3.x advanced amortization 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 build a monthly loan amortization schedule, compute lender yield/APR, duration, average life, or balloon payoff for a fixed- or variable-rate commercial mortgage, or model an assumed loan. Trigger on phrases like "build an amortization schedule," "amortize this loan," "what's the monthly payment," "loan payoff at year X," "lender yield," "APR," "duration and average life," "variable-rate loan with a SOFR curve," "loan assumption schedule," or any combination of "amortization" / "loan" / "mortgage" with "schedule," "payment," "payoff," "yield," or "interest." Do NOT trigger for loan sizing (LTV/DSCR-constrained — use a property or development model), DSCR / debt-yield analysis (needs NOI), or prepayment-penalty / yield-maintenance calculations.
What's inside
A.CRE Advanced Amortization Table — Operator Skill
This skill lets you operate the A.CRE Advanced Amortization Table on behalf of a real estate professional. It builds a monthly loan amortization schedule for a fixed- or variable-rate commercial mortgage and reports the…
Show full previewShow less
A.CRE Advanced Amortization Table — Operator Skill
This skill lets you operate the A.CRE Advanced Amortization Table on behalf of a real estate professional. It builds a monthly loan amortization schedule for a fixed- or variable-rate commercial mortgage and reports the loan's cash flow, lender yield/APR, duration, average life, and balloon payoff.
Distributed under the A.CRE software license — see references/LICENSE.txt. 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.
advanced-amortization-table-v32/
├── SKILL.md # Required: instructions + metadata
├── assets/ # Optional: templates, resources
│ └── Advanced-Mortgage-Amortization-v3_2.xlsx # 109.4 KB
└── references/ # Optional: documentation
├── acre-modeling-conventions.md # 3.2 KB
├── inputs.md # 5.2 KB
├── LICENSE.txt # 3.7 KB
├── outputs.md # 3.7 KB
├── recalc.md # 5.5 KB
├── role-workflows.md # 4.5 KB
└── schema.yaml # 11.8 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.