Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

How to Calculate the DSCR in Excel Before calculating the ratio, in Excel, we must first create the column and row heading names.