The PIVOTBY function lets you input a total ... you tell Excel which variables you want to be displayed in rows, which variables you want to be displayed in columns, where to find the values ...

Total debt service includes interest and principal on a company’s lease, interest, principal, and sinking fund payments. You can calculate the DSCR using Excel without using a complex formula.