KPI calculator

Debt Ratio Calculator

Enter your values to calculate Debt Ratio. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Debt Ratio books Books that help you understand Debt Ratio and related business metrics more deeply. Explore resources → Debt Ratio audiobooks Audiobook searches for learning Debt Ratio while commuting, walking, or working. Explore resources → Accounting Excel resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Financial statement analysis Practical resources for turning Debt Ratio into reports, dashboards, and business decisions. Explore resources →

Calculate Debt Ratio

Total Debt Total Assets

Result—

Formula

Total Debt / Total Assets

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Debt Ratio =
DIVIDE(
    [Total Debt],
    [Total Assets]
)

Read the complete Debt Ratio formula guide →