Commercial Real Estate Debt Service Calculation for Underwriting
A commercial real estate debt service calculation starts by adding the included loan payments for a defined reporting period. For a full year of constant monthly P&I, multiply the unrounded monthly payment by 12. For changing payments or a partial year, sum the relevant payments instead. Then compare that total with property income measured over the same period.
This guide uses a simplified model in which recurring debt service means scheduled principal and interest. It shows how to build a compact worksheet, calculate a basic debt-service coverage ratio, and keep maturity funding separate from recurring operating-period payments.
All examples are hypothetical and educational—not a financing offer, underwriting approval, or personalized financial advice. Actual lender definitions, loan documents, and property-income adjustments require confirmation and qualified review.
In this guide: Define debt service · Payment totals · Cash flow · DSCR · Stress tests and audit
What counts as debt service in your property model?
Scheduled principal and interest in a stated reporting period
For this worksheet, recurring debt service is the sum of included scheduled P&I payments during the stated period. Both components matter: principal reduces the outstanding loan, while interest is the modeled interest charge. Both are payment cash outflows.
This definition is deliberately scoped. It excludes the residual maturity balance from the recurring-service metric, while keeping that balance visible in a separate maturity cash-flow line. It also excludes fees, reserves, and other adjustments unless a revised model explicitly includes them.
Write the definition beside the worksheet. A label such as “annual debt service” is incomplete if reviewers cannot tell which debt, which dates, and which payment components it contains.
Check lender-specific inclusions and adjustments
Do not assume this simplified definition is identical to a lender’s underwriting measure. Verify the required treatment of other financing obligations, fees, reserves, income adjustments, and maturity amounts against the relevant documentation.
For every included obligation, identify the source schedule and reporting dates. For an exclusion, record the reason. This creates an audit trail without inventing a universal rule about how every lender calculates debt service.
The financing scope also needs to match the property analysis. A worksheet covering one property should not inadvertently use a payment total for a larger financing arrangement without an explained allocation.
How to convert loan payments into periodic debt-service totals
Annualize a full year of constant monthly payments
The shared example assumes:
- $1,000,000 principal.
- Fixed 6% nominal annual interest.
- 25-year amortization and a five-year term.
- Monthly, end-of-period payments.
- No fees, escrows, prepayments, or interest-only period.
Its monthly P&I is $6,443.014014855…, displayed as $6,443.01. If you need to verify that input, calculate the underlying P&I payment before building the underwriting worksheet.
For 12 unchanged payments:
Annual scheduled P&I = 12 × $6,443.014014855… = $77,316.17, rounded for display.
Using the displayed payment instead would give $77,316.12. The difference reflects rounding, not a different loan structure. This guide retains precision through calculations and rounds final displayed amounts to cents; actual contractual cent-rounding may differ slightly.
Sum actual periods when payments change or a year is partial
Annualization is a shortcut that works only when the period contains the assumed 12 equal payments. For a six-payment period, include six payments—not a full year merely because the income worksheet has an annual heading.
A period containing an interest-only transition needs the payments from both phases. For example, if a hypothetical reporting year contains six payments of $5,000 and six payments of $7,164.310584… after a reset, its scheduled total is $72,985.86. Multiplying either phase’s payment by 12 would describe a different period.
That example is a defined arithmetic scenario, not a claim about a particular contract. The actual dates, rate, and reset payment must come from the financing assumptions being modeled.
Combine included loan obligations consistently
When the model includes more than one loan, calculate each obligation’s payment total over the same dates, then combine the totals. Do not mix one loan’s annual amount with another loan’s monthly amount.
Check for double counting as well as omissions. A consolidated payment total might already contain an obligation listed separately elsewhere. The worksheet should make clear whether a row is an individual loan or a subtotal.
A useful input register contains obligation name, schedule source, included dates, payment structure, and period total. This makes later changes traceable without requiring the cash-flow worksheet to reproduce every payment formula.
How to apply debt service to property cash flow
Align NOI and debt service to the same period
In this simplified example, net operating income (NOI) is a supplied pre-debt-service property-income figure. It is not calculated by subtracting loan payments first. The illustrative annual NOI is $100,000.
Compare annual NOI with annual debt service. Comparing annual income with one month’s payment would produce a ratio with incompatible periods. Similarly, pairing trailing historical income with a future debt-payment scenario needs explicit labeling; it is not automatically a matched-period historical result.
This guide does not establish a lender-approved NOI definition. Property accounting and underwriting adjustments should be separately documented rather than assumed from the word “NOI.”
Calculate illustrative cash flow after scheduled debt service
Subtract annual scheduled P&I from the illustrative annual NOI:
$100,000 − $77,316.17 = $22,683.83.
| Worksheet line | Amount or ratio | Period and meaning |
|---|---|---|
| Illustrative NOI | $100,000.00 | Annual, before debt service |
| Regular monthly P&I | $6,443.01 | Monthly display value |
| Scheduled recurring debt service | $77,316.17 | 12 payments, internal precision |
| Cash flow after scheduled debt service | $22,683.83 | Annual, before other adjustments |
| Basic DSCR | 1.29× | Annual NOI divided by annual service |
The remaining $22,683.83 is not automatically distributable cash or a complete investment return. The worksheet has not modeled other cash requirements or the maturity payoff. Preserve its full label instead of shortening it to “profit.”
How to calculate a basic debt-service coverage ratio
DSCR equals NOI divided by debt service
Under the definitions used here:
Debt-service coverage ratio (DSCR) = NOI ÷ recurring debt service.
Substituting annual amounts gives:
$100,000 ÷ $77,316.168178… = approximately 1.29×.
[IMAGE: Commercial real estate debt service calculation example with $100,000 annual NOI, $77,316.17 annual P&I, and 1.29 times DSCR.]The ratio means the illustrative NOI is about 1.29 times the scheduled recurring P&I included in this worksheet. It is a multiple, not a dollar amount, and not a percentage return on investment.
Interpret coverage without promising loan approval
A larger ratio can result from more NOI, less included debt service, or both. Before comparing two ratios, confirm that neither denominator has excluded obligations included by the other.
There is no approval threshold established by this example. A 1.29× result does not guarantee financing, and a ratio alone does not describe maturity liquidity, property condition, or every underwriting consideration.
The same caution applies to income assumptions: a ratio calculated from hypothetical NOI is a scenario result. It should not be presented as verified property performance simply because the arithmetic is correct.
How to stress-test and audit your underwriting worksheet
Compare 20-year versus 25-year amortization
Hold principal at $1 million, the fixed nominal rate at 6%, and illustrative annual NOI at $100,000. Changing amortization changes recurring P&I and therefore this model’s coverage.
| Repayment assumption | Monthly payment | Annual recurring service | Basic DSCR |
|---|---|---|---|
| 25-year amortization | $6,443.01 | $77,316.17 | 1.29× |
| 20-year amortization | $7,164.31 | $85,971.73 | 1.16× |
| Full year interest only | $5,000.00 | $60,000.00 | 1.67× |
The IO row has lower current payments but no principal reduction from those interest payments alone. Its larger recurring-service ratio does not remove the unpaid principal or establish that it is the preferable structure.
Model an IO transition or rate-change scenario separately
To compare interest-only and amortizing debt service, specify the IO duration, subsequent amortization period, rate, and maturity. Do not assume the amortization clock restarts when IO ends.
A separate hypothetical 25-year loan with five years IO and 20 years remaining would amortize the unchanged $1 million over 240 months after the IO phase. At an assumed unchanged 6% rate, that produces the $7,164.31 payment in the table.
A rate sensitivity must likewise identify when the assumed rate changes and how the payment is recalculated. A series of separate fixed-rate scenarios is not evidence of a future rate path. Label assumptions rather than presenting them as forecasts.
Keep the balloon cash requirement visible at maturity
The five-year-term, 25-year-amortization base case leaves $899,320.87 after regular payment 60. This amount is outside the simplified recurring-service ratio but remains a cash requirement in the maturity-period model.
The companion guide explains how to plan for the maturity cash requirement. If installment 60 is already counted in scheduled service, do not count it again when adding the post-payment residual. Actual lender treatment of maturity amounts must be verified separately.
Check periods, precision, NOI treatment, and financing scope
Before using the worksheet, confirm:
- Income and payment periods are aligned or clearly distinguished.
- Monthly and annual amounts have explicit units.
- Changing or partial-period payments are summed correctly.
- Internal precision is consistent across outputs.
- NOI is not already reduced by the debt service being subtracted.
- All included obligations appear once, with exclusions documented.
- Maturity principal is visible outside the recurring metric.
Reconcile the model with the loan documents and schedule
Trace each payment total to its schedule and each scenario to its input assumptions. Retain dates and versions so an updated rate, balance, or payment does not silently overwrite the basis for an earlier result.
A useful final review asks two questions: “Does the arithmetic reconcile?” and “Does the model represent the intended documents and reporting period?” Passing the first check does not automatically satisfy the second, and neither constitutes lender approval.
FAQ
Can I multiply monthly P&I by 12?
Yes, for a full year containing 12 equal modeled payments. Sum the actual included payments when the year is partial or the amount changes.
Does DSCR include the balloon here?
Not in the simplified recurring-service ratio. The residual appears separately in the maturity cash-flow model. Confirm the required treatment for any actual underwriting analysis.
Is 1.29× a guaranteed approval result?
No. It is the arithmetic result of the hypothetical NOI and scheduled payments, not an approval standard.
Why does interest only show higher coverage?
Its current payment denominator is smaller at the same assumed principal and rate. That does not reduce principal or remove the future repayment requirement.