Calculate the debt service coverage ratio in Excel: As a reminder, the formula to calculate the DSCR is as follows: Net Operating Income / Total Debt Service. Place your cursor in cell D3.