To calculate the simple interest you’ll earn in a savings account, multiply the account balance by the interest rate by the time period the money is in the account.

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

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