How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.

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