Claude Skill (AI Skill) for Commercial Mortgage Loan Analysis Model

Why It Matters

Embedding AI skills into financial models can speed underwriting, standardize checks and documentation, and make complex models more accessible—potentially improving deal turnarounds and reducing human error—while still requiring domain knowledge to validate results.

Summary

The video demos an AI “skill” built for a commercial mortgage loan analysis Excel model that helps users install the tool, select a role (e.g., lender), and run underwriting workflows that populate model inputs, recalculate the workbook, and summarize outputs like underwritten NOI, cap rate, value, and loan sizing. The presenter emphasizes that the skill teaches the AI the model’s worksheets, key formulas and outputs, and can both edit the file and answer explanatory questions about model flow. In the demo the skill ran a lender baseline, inferred inputs, produced an underwritten NOI of roughly $674K and sized a loan around $6.1M, and provided plain‑English explanations of the model and lender credit checks. The host warns users to understand how inputs map to outputs and not to treat the tool as a substitute for financial modeling expertise.

Original Description

In this video, Spencer walks through the AI Skill built for the A.CRE Commercial Mortgage Loan Analysis Model. He demonstrates how to install the Skill in ChatGPT in Excel, run the role-triage interview, and let the AI populate the workbook, size the loan, and explain the model, all from inside Excel.

Download the Commercial Mortgage Loan Analysis Model + AI Skill:

https://www.adventuresincre.com/ai-skill-for-the-commercial-mortgage-loan-analysis-model

View all models in our Library of Real Estate Excel Models: https://www.adventuresincre.com/library-real-estate-excel-models/

Learn to build institutional-quality real estate models:

https://www.adventuresincre.com/accelerator/

SUBSCRIBE: https://www.youtube.com/user/sburtonhome?sub_confirmation=1