10/09/2024 - A Strategic Approach to Commercial Real Estate Underwriting

On this Commercial Call, Chris introduces a spreadsheet tool for underwriting commercial real estate deals, focusing on loan sizing using three key metrics: Loan-to-Value (LTV), Debt Service Coverage Ratio (DSCR), and debt yield. The tool helps users input assumptions like interest rates, amortization period, NOI, property value, and coverage ratio to calculate the maximum loan amount. Specific topics are discussed as well, such as:

· How does the spreadsheet calculate the maximum loan amount based on LTV, DSCR, and debt yield?
· How do interest rates and amortization periods impact loan sizing in commercial real estate deals?
· How does net operating income (NOI) influence the loan sizing process?
· How can adjusting the coverage ratio affect the maximum loan amount?
· How do different assumptions in the spreadsheet affect the loan outcome?
· What are the key assumptions users need to input in the underwriting spreadsheet?
· What role do LTV, DSCR, and debt yield play in determining loan size?
· What is the relationship between property value and the loan amount?
· What factors should be considered when determining the appropriate debt coverage ratio (DCR)?
· What is the significance of using a spreadsheet tool for loan sizing in commercial real estate underwriting?