Be sure to copy this formula down the column so additional shifts on other rows will calculate, as well. Click the bottom line of a cell and drag it down the column to copy it.

Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row.