How to Calculate Retail Price in Excel (2 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

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)

Calculate Retail Price from Markup

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)

Calculate Retail Price from Margin

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Shamim Reza
Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo