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

Use Microsoft Excel to calculate EBITDA (earnings before interest, tax, depreciation, and amortization) profit margin.

When Excel asks for your data range, select the cells with the values you want to visualize. The moment you click OK, your Sparkline will appear right in the cell you specified.