Commercial Mortgage Loan Analysis Model

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 (View description of model).

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.