How To Calculate Percentage Drop In Revenue. You subtract the second number from the first, then divide it. Subtract the gross receipts of any quarter of 2020 from gross receipts from the same quarter of 2019, and divide that amount by the gross receipts of your chosen quarter of 2019.
On your excel spreadsheet, if this month's revenue, $12500 is in cell b1 while last month's revenue $17,500 is in cell b2; Where new is the newer quantity or measure, and old is the older quantity or measure. How to calculate percentage decrease.
