Formula How to Calculate Total Revenue Total Revenue Price x Quantity. Operating profit margin Operating profit Total revenue In this case we obtain. Next lets figure out what percent of our 1100 total is 100.
This feature was introduced in Excel 2010 so applies only to 2010 and later versions.
Divide net income by net revenue 71 million 46 million 01543. The following table calculation for finding the percent of total sales. As we know revenue can be calculated by multiplying the quantity of goods or services with its price. So if you earned 1 million in revenue last year and 2 million this year then your growth is 100 percent.