Max Loan Calculator

Max Loan Calculator: Free Excel Tool

Size a commercial real estate loan the way lenders actually do it. Enter your purchase price, NOI, and debt assumptions, then select your desired metric (LTV, LTC, DSCR, or Debt Yield) to see your max loan proceeds along with how all four metrics look at that loan amount.

A note on how we build.



Every tool and template on Model The Deal is intentionally simple. Unnecessary complexity gets in the way of understanding. Every formula is visible and nothing is hidden behind a black box. We actively encourage you to open the model, follow the logic, and rebuild it yourself. While our goal is to give you a working template that is ready to go, it is also to build your understanding of how these calculations actually work.

This template is provided as-is. For general questions or feedback, reach out at contact@modelthedeal.com.