# How to Calculate the Debt Service Coverage Ratio in Excel (2 Examples)

## Dataset Overview

Letâ€™s say we have a userâ€™s Debt and Income Statement, or Balance Sheet as shown in the image below. And we want to find the Debt Service Coverage Ratio (DSCR) from it.

Debt and Income Statement

Balance Sheet

## What Is Debt Service Coverage Ratio (DSCR)?

The Debt Service Coverage Ratio (DSCR) is a financial metric that helps companies, organizations, or individuals assess their ability to meet debt obligations. It compares the Net Operating Income (or Cash Flow) to the Debt Service. A DSCR greater than 1 indicates a safer financial position. Hereâ€™s the formula:

`Debt Service Coverage Ratio (DSCR)=Net Operating Income/Debt Service`

Net Operating Income = Represents the cash flow after deducting all expenses.

Debt Service = Refers to the total obligations that need to be met.

## Basic Debt Service Coverage Ratio (DSCR) Calculation

To calculate the DSCR, youâ€™ll need two fundamental entities:

1. Net Income or Cash Flow (after deducting expenses)
2. Total Debt or Debt Service

Simply find the ratio between Net Income (or Cash Flow) and Debt Service to determine the DSCR.

## Example 1 – Calculating DSCR from Income and Debt Statement

Suppose you have an Income and Debt Statement like the one shown below. You can obtain this statement from your accountant or financial logs.

• Insert the following formula (Net Income / Total Debt Service) into any blank cell:
`=H10/E10`

• Press ENTER, and youâ€™ll instantly get the DSCR.

You can use your financial statement or the attached dataset as a template.

## Example 2 –Â Determining DSCR from Balance Sheet

Companies or institutions often maintain Balance Sheets that depict their Incomes and Expenses. Using the relevant entries, you can find the DSCR.

Suppose your Balance Sheet looks like the following screenshot:

• Enter the following formula in any cell:
`=-C13/C12`

In the formula, C13 refers to the Net Cash Flow or Income, and C12, Debt Service.

• Press ENTER, and then drag the Fill Handle to the right to calculate DSCRs for each column.

Remember that the specific fields in Financial Balance Statements may vary from company to company, but essential entries like Net Income (or Cash Flow) and Debt (or Liability) are always present.

Read More:Â How to Graph Ratios in Excel

## Related Articles

<< Go Back to Ratio in Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF