Debt Service Coverage Ratio Template
Debt Service Coverage Ratio (DSCR) measures the ability of a company to use its operating incomeOperating IncomeOperating Income, also referred to as operating profit or Earnings Before Interest & Taxes (EBIT), is the amount of revenue left after deducting operational direct and indirect costs. Interest expense, interest income, and other non-operational revenue sources are not considered in computing operating income to repay all its debt obligations, including repayment of principal and interest on both short-term and long-term debtLong Term DebtLong Term Debt (LTD) is any amount of outstanding debt a company holds that has a maturity of 12 months or longer. It is classified as a non-current liability on the company’s balance sheet. The time to maturity for LTD can range anywhere from 12 months to 30+ years and the types of debt can include bonds, mortgages. DSCR is often used when a company has any borrowings on its balance sheetBalance SheetThe balance sheet is one of the three fundamental financial statements. These statements are key to both financial modeling and accounting. The balance sheet displays the company’s total assets, and how these assets are financed, through either debt or equity. Assets = Liabilities + Equity such as bondsBondsBonds are fixed-income securities that are issued by corporations and governments to raise capital. The bond issuer borrows capital from the bondholder and makes fixed payments to them at a fixed (or variable) interest rate for a specified period., loans, and lines of credit. It is also a commonly used ratio in a leveraged buyoutLeveraged Buyout (LBO)A leveraged buyout (LBO) is a transaction where a business is acquired using debt as the main source of consideration. An LBO transaction typically occur when a private equity (PE) firm borrows as much as they can from a variety of lenders (up to 70-80% of the purchase price) to achieve an internal rate return IRR >20% transaction to evaluate the debt capacity of the target company, along with other credit metrics such as total debt/EBITDADebt/EBITDA RatioNet debt to earnings before interest, taxes, depreciation, and amortization (debt/EBITDA ratio) is a measure of financial leverage and a company’s ability to pay off its debt. Essentially, the net debt to EBITDA ratio gives an indication as to how long a company would need to operate at its current level to pay off multiple, net debt/EBITDA multiple, interest coverage ratioInterest Coverage RatioInterest Coverage Ratio (ICR) is a financial ratio that is used to determine the ability of a company to pay the interest on its outstanding debt. The ICR is commonly used by lenders, creditors, and investors to determine the riskiness of lending capital to a company. The interest coverage ratio is also called “times and fixed charge coverage ratioFixed-Charge Coverage Ratio (FCCR)The Fixed-Charge Coverage Ratio (FCCR) is a measure of a company’s ability to meet fixed-charge obligations such as interest and lease expenses. The FCCR is a broader measure of the times interest coverage ratio, as it also includes other fixed costs such as leases and insurance. A higher FCCR value is preferred..
This debt service coverage ratio template built in Excel will help you calculate the debt service coverage ratio, both including and excluding capex.
Download the Free Template
Enter your name and email in the form below and download the free template now!
Debt Service Coverage Ratio Formula
There are two ways to calculate the debt service coverage ratio:
Where:
- EBITDAEBITDAEBITDA or Earnings Before Interest, Tax, Depreciation, Amortization is a company's profits before any of these net deductions are made. EBITDA focuses on the operating decisions of a business because it looks at the business’ profitability from core operations before the impact of capital structure. Formula, examples = Earnings Before Interest, Tax, Depreciation and Amortization
- Principal = the total amount of short-term and long-term borrowings
- Interest = the interest payable on any borrowings
- CapexCapital ExpenditureA Capital Expenditure (Capex for short) is the payment with either cash or credit to purchase goods or services that are capitalized on the balance sheet. Put another way, it is an expenditure that is capitalized (i.e. not expensed directly on the income statement) and is considered an "investment". Analysts view Capex = Capital Expenditure
Some companies might prefer to use the latter formula because capital expenditure is not expensed on the income statementIncome StatementThe Income Statement (or Statement of Profit and Loss) shows performance from operations of a business. The financial statement begins with revenues and but rather considered as an “investment”. Excluding Capex from EBITDA will give the company the actual amount of operating income available for debt repayment.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These templates can be used for transactions, legal, financial modeling, financial analysis, business planning and business analysis. Download and use these financial business templates for free.
