DSCR calculator
The debt service coverage ratio (DSCR) is net operating income divided by annual debt service. A DSCR of 1.25 means the property earns $1.25 of NOI for every $1.00 of loan payments; below 1.00, NOI does not cover the payments.
Enter annual NOI and the loan terms. The result shows the monthly payment, annual debt service, the DSCR and, for a target DSCR, the largest payment and loan the NOI supports.
Calculator
Estimates only. Check the numbers against your lease and your books.
How the calculation works
- Find the monthly payment. For principal and interest: loan x i / (1 - (1 + i) ^ -n), where i is the annual rate / 12 and n is the years x 12. For interest only: loan x i.
- Annual debt service is the monthly payment x 12.
- DSCR = NOI / annual debt service. Use NOI before debt service, depreciation and income taxes.
- Cash flow after debt service is NOI minus annual debt service.
- For a target DSCR, the largest annual debt service the NOI supports is NOI / target. The largest loan is the loan whose payment equals that amount at the same rate and term.
- If there is no loan, annual debt service is 0 and the calculator shows a DSCR of 0 rather than an infinite ratio.
NOI $144,000.00, loan $1,500,000.00 at 6.5% over 30 years. Monthly rate: 0.065 / 12 = 0.0054167; payments: 360. Monthly payment: $9,481.02. Annual debt service: $9,481.02 x 12 = $113,772.24. DSCR: $144,000.00 / $113,772.24 = 1.27. At a 1.25 target, the largest annual debt service is $144,000.00 / 1.25 = $115,200.00, which supports a loan of about $1,518,824.
How do you calculate DSCR?
Divide annual net operating income by annual debt service, which is all principal and interest payments for the year. $144,000 of NOI over $113,772 of debt service is a DSCR of 1.27.
What is a good DSCR for a rental property?
Many lenders look for 1.20 to 1.25 or higher on multifamily loans, and some ask for more on riskier properties. Each lender sets its own minimum, so ask yours.
What does a DSCR below 1.0 mean?
The property's NOI does not cover its loan payments, so the owner has to add cash to make them.
Which NOI should I use?
Use the NOI the lender will underwrite, which is often trailing 12 months with a vacancy allowance and a replacement reserve. The NOI calculator shows the steps.
Is this a loan quote?
No. It is arithmetic on the numbers you enter. Your lender's terms, fees and underwriting decide the real loan amount, and this is not financial advice.
See Zrico run your portfolio.
Bring a property. We will show you, on your own data, what Zrico would have handled last month.