DSCR Calculator

Click on the button to download your preferred calculator based on your property type (1-4 units or above 4 units). Once you download the DSCR calculator based on your needs, here’s how to use it:

  1. Open the downloaded Excel file using Microsoft Excel or compatible software such as Google Sheets or LibreOffice Calc. Make sure that macros are enabled if needed.

  2. Fill in the required information in the designated input areas of the spreadsheet. These sections are clearly marked, such as Borrower NameLoan Number, and other financial details.

  3. Ensure you input accurate figures such as property income, expenses, and loan details in the provided fields. Avoid making changes to any other areas or formulas in the sheet.

  4. The calculator will automatically compute relevant values, including the DSCR (Debt Service Coverage Ratio), based on the data you entered.

  5. Review the results displayed in the output sections of the sheet.

For clarity or troubleshooting, you may want to save a fresh copy of the original file in case any formulas are accidentally modified.