How to Calculate Percentage Change Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.

As a reminder, the formula to calculate the DSCR is as follows: Net Operating Income / Total Debt Service. Place your cursor in cell D3. The formula in Excel will begin with the equal sign.

Sales tax is a percentage of a retail price. To calculate it, convert the state sales tax percentage to a decimal, then multiply it by the retail price of the product or service.