This article illustrates how to calculate the retail price in Excel. Markup and Margin are two basic elements in sales when determining the retail price of a product. You can calculate the retail price of a product from the cost of the product and either the markup or the margin of it. Following this article, you can learn how to calculate the retail price in both cases.
How to Calculate Retail Price in Excel: 2 Ways
1. Calculate Retail Price from Markup
Markup is the percentage of gross profit to the cost price. It is the ratio of the gross profit and the cost of the goods sold.
For example, assume the total cost to manufacture a bicycle is $600. Revenue earned from the sale is $800. The gross profit is $800 – $600 = $200. Therefore, the markup is ($200/$600)×100% = 33.33%.
Assume you have a list of cost prices along with markup percentages. Now you need to calculate the retail price for each cost price.
Then enter the following formula in cell D5.
=B5*(1+C5)
Read More: How to Calculate Selling Price in Excel
2. Calculate Retail Price from Margin
Margin is the percentage of gross profit to the sale price. To simplify, it is the ratio of the gross profit and the revenue earned from a product.
Consider the earlier example. The gross profit is $200 while the revenue is $800. Therefore, the margin is = ($200/$800)×100% = 25%
Now assume you have the margin percentages instead of the markup percentages.
Then apply the following formula in cell D5 to calculate the retail price.
=B5/(1-C5)
Read More: How to Calculate Selling Price from Cost and Margin in Excel
Things to Remember
- First, make sure whether you have the markup % or the margin % before calculating the retail price.
- Markup % should be greater than the margin % to profit from the retail price.
Download Practice Workbook
You can download the practice workbook from the download button below.
Conclusion
Now you know how to calculate the retail price in Excel. Hopefully, this article has helped you with your queries. Please use the comment section below for any suggestions or further queries. You can also visit our ExcelDemy blog to explore more about Excel. Stay with us and keep learning.
