Pro Forma Debt Service Ratio Calculator and Formula

A pro forma debt service ratio (DSCR) compares projected cash available for debt payments with projected principal and interest payments. Enter projected annual cash flow and annual debt service to calculate the ratio, shown as a multiple and a percentage; the result is a planning estimate, not a loan approval decision.

Formula

The pro forma debt service ratio is projected cash flow available for debt service divided by projected debt service:

Pro forma DSCR = projected cash flow available for debt service ÷ projected debt service

• Projected cash flow available for debt service (CF): annual dollars available to pay principal and interest, based on the definition used in the analysis.
• Projected debt service (DS): total scheduled principal and interest payments for the same period, in annual dollars.
• Ratio: a unitless multiple. The percentage output is the same relationship multiplied by 100.
• Cash flow after debt service: CF minus DS, in dollars. This is a simple arithmetic difference, not a full measure of profit or free cash.

The denominator must be greater than zero, and both amounts must cover matching periods and use consistent assumptions. The calculator accepts a positive debt-service amount and nonnegative cash flow. It does not determine which expenses belong in cash flow; the lender, analyst, or agreement may specify its own calculation method.

Worked Example

Using the calculator’s default annual inputs, projected cash flow is $120,000 and projected debt service is $90,000.

1. Divide cash flow by debt service: $120,000 ÷ $90,000 = 1.3333…
2. Rounded to two decimal places, the pro forma DSCR is 1.33x.
3. Expressed as a percentage, 1.3333… × 100 = 133.33%.
4. Subtract debt service from cash flow: $120,000 − $90,000 = $30,000.

In this example, projected cash flow is about 1.33 times the annual debt payments. The remaining $30,000 is before any costs omitted from the cash-flow definition or other obligations not entered into the calculation.

What “Pro Forma” Means

“Pro forma” means presented on a projected or hypothetical basis rather than solely as a record of past results. A pro forma DSCR may use forecasts for a future period, such as expected operating income after a change in occupancy, expenses, ownership, or financing. It may also combine historical figures with specific adjustments. The ratio is only as dependable as the assumptions and evidence behind those projections.

This differs from a historical DSCR, which is calculated from results for a completed period. A projected ratio can help describe how a proposed financing arrangement might look under stated assumptions, but it does not establish that projected revenue will occur. Actual performance can differ because of vacancies, customer demand, operating costs, delays, or other changes.

There is no single universal definition of cash available for debt service. For a business, an analysis might begin with operating cash flow and make specified adjustments. For a rental property, it may use net operating income. Those terms are not automatically interchangeable: net operating income commonly excludes financing costs, while cash-flow measures may include additional adjustments. Follow the definition required by the document or analysis being reviewed.

How to Read the Result

A ratio above 1.00x means the entered projected cash flow exceeds the entered debt service. A ratio of exactly 1.00x means the two amounts are equal. A ratio below 1.00x means projected cash flow is less than the entered debt service. These describe the arithmetic, not a universal threshold for lending or a prediction of payment performance.

• 1.25x means $1.25 of projected cash flow for each $1 of debt service, under the inputs and definitions used.
• 0.90x means $0.90 of projected cash flow for each $1 of debt service, leaving a shortfall of $0.10 per dollar before considering other sources or adjustments.
• 133.33% and 1.33x communicate essentially the same coverage; percentage display does not mean a separate test.

The ratio does not show when cash arrives, whether it is available for scheduled payment dates, or how much cash must be kept for working capital. It also does not account for debt obligations unless those are included in the debt-service input.

Building a Useful Projection

Before calculating, identify the period, the cash-flow definition, and the debts included. Then document how each forecast amount was developed. A clear calculation is easier to check than a ratio presented without its inputs.

• Use the same time span for both inputs, such as a full year for annual cash flow and annual debt service.
• Include the scheduled principal and interest obligations that the relevant analysis counts. Do not mix annual operating cash flow with a single monthly payment.
• Make assumptions visible, including expected revenue, occupancy or sales, operating expenses, and any adjustments.
• Consider separate scenarios for uncertain assumptions rather than treating one forecast as certain. Recalculate the ratio for each scenario using consistent inputs.
• Check whether the source defines debt service to include other amounts. This calculator models only the figures entered; it does not infer fees, taxes, leases, or additional debt.

For example, if an annual cash-flow forecast falls from $120,000 to $105,000 while debt service remains $90,000, the ratio becomes 1.17x. That change illustrates how sensitive coverage is to the forecast; it is not a statement about what will happen.

Common Errors and Limits

A frequent mistake is comparing mismatched periods: monthly debt payments against annual cash flow. Another is treating a forecast as guaranteed or assuming that different institutions use the same cash-flow adjustments. Rounding can also obscure small differences, so retain the underlying amounts when checking a result.

The calculator performs a simple division. It does not verify the source data, evaluate the quality of a forecast, calculate a lender-specific DSCR, or establish whether debt can be repaid. It does not include taxes, insurance, capital spending, working-capital needs, or other cash demands unless they are already reflected in the cash-flow figure. Ask the party requesting the ratio which definitions and projection period it requires, and obtain actual loan-payment figures from the lender for a financing analysis.

Frequently Asked Questions

What is a pro forma debt service ratio?
It is projected cash available for debt payments divided by projected principal and interest payments for the same period. It expresses projected coverage as a multiple.

How do you calculate pro forma DSCR?
Divide projected cash flow available for debt service by projected debt service. For example, $120,000 divided by $90,000 gives 1.33x when rounded to two decimal places.

What does a 1.0 DSCR mean?
It means the entered cash flow and debt service are equal. The calculation alone does not determine whether a particular lender, contract, or analyst will accept that result.

Is pro forma DSCR the same as historical DSCR?
No. Pro forma DSCR uses projected or hypothetical inputs, while historical DSCR uses results from a past period. Either measure depends on its stated definitions and adjustments.

Does DSCR include taxes and insurance?
Not necessarily. Definitions vary, and this calculator includes only amounts represented in the cash-flow and debt-service inputs. Check the applicable calculation instructions rather than assuming those items are included.

Assumptions

• The two inputs cover the same annual period and use the same currency.
• Cash flow is already adjusted to the applicable definition of cash available for debt service.
• Debt service is the relevant annual principal-and-interest amount; no payment schedule is calculated.
• No fees, taxes, insurance, or other obligations are added unless reflected in the supplied inputs.

This result is an estimate based on your inputs; the lender’s disclosure gives the exact figures for its transaction.

Related

• Debt Service Ratio Calculator and Formula Explained
• Debt Service Ratio Calculator: Formula and Meaning
• Debt Service Ratio Equation and How to Use It

in cf | Projected annual cash flow | $ | 120000 | 0 | 1000000000
in ds | Projected annual debt service | $ | 90000 | 0.01 | 1000000000
out ratio | Pro forma debt service ratio | x | cf / ds | 2
out pct | Coverage ratio | % | cf / ds * 100 | 2
out margin | Cash flow after debt service | $ | cf - ds | 2