KPI calculator

Days Payable Outstanding Calculator

Enter your values to calculate Days Payable Outstanding. 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.

Days Payable Outstanding books Books that help you understand Days Payable Outstanding and related business metrics more deeply. Explore resources → Days Payable Outstanding audiobooks Audiobook searches for learning Days Payable Outstanding 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 Days Payable Outstanding into reports, dashboards, and business decisions. Explore resources →

Calculate Days Payable Outstanding

Accounts Payable Cost of Goods Sold Days

Result—

Formula

(Accounts Payable / Cost of Goods Sold) × Days

Excel formula

=IFERROR((B2/C2)*D2,0)

Power BI DAX measure

Days Payable Outstanding =
DIVIDE([Accounts Payable], [Cost of Goods Sold]) * [Days]

Read the complete Days Payable Outstanding formula guide →