Calculating the Debt Service Coverage Ratio in Excel Example. Investopedia You’ll notice that Excel automatically highlights the cells in the formula calculation as you type. Once you press Enter, the calculation will be completed, as shown below: Calculating the Debt Service Coverage...
Let’s look at an example. Assume the client below had $20 million in long-term debt plus $5 million in current portion of long-term debt (CPLTD). Based on that information, plus what’s been provided in the income statement below, what is the borrower’s DSCR? We would plug the nu...
Let’s look at an example. Assume the client below had $20 million in long-term debt plus $5 million in current portion of long-term debt (CPLTD). Based on that information, plus what’s been provided in the income statement below, what is the borrower’s DSCR? We would plug the nu...