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

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.


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Ways to Calculate Retail Price in Excel

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. Then 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 (4 Easy Methods)


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.

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

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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo