Commercial Mortgage Loan Analysis Model + AI Skill

Excel model for underwriting commercial mortgage loans. Underwrite subject property value using the direct cap method. Calculate the maximum loan amount using debt service coverage, debt yield, and loan-to-value tests. Assess balloon risk using the included refinance risk analysis tool. Estimate the Yield Maintenance or % of Loan Balance prepayment penalty for a loan. Run analysis using either fixed rate or floating rate debt, with various interest rate calculation methods. Now includes an AI Skill that teaches Claude and other AI assistants how to operate the model on your behalf. triaging your role as borrower, lender, broker, or student, populating inputs conversationally from a term sheet or T-12, and interpreting the Maximum Loan Amount, Lender Yield, and binding test in the language of your investment decision. (View description of model | View description of AI Skill)

Note: Compatible with Microsoft Excel 2013 and newer. AI Skill works with Claude (including Claude in Excel) and is portable to other capable AI assistants. Skill bundle includes a clean copy of the model — no upload needed to get started.

To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (choose ‘Free’ if you need) or maximum (your paid support helps keep the content coming – typical real estate models sell for $100 – $300+ per license).
Instructions: 1) set a price, 2) tell us where (email address) to send the model, 3) enter payment details (if applicable), and then 4) click ‘Proceed with Download’. The system will send you a download link, as well as add the file to your ‘My Downloads’ page.