Course Alert:
If you would like to learn in detail, how to calculate income statement variances and the impact they have on sales $, profit $ and profit margin % and ebitda %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://ebitda.thinkific.com/courses/learn

Looking for more personalized help?

Get in touch with me on one of these platforms:
Instagram: https://www.instagram.com/learnaccountingfinance
Facebook: https://www.facebook.com/profile.php?id=100063564513161
Tiktok: https://www.tiktok.com/@learnaccountingfinance
Website: https://www.learnaccountingfinance.com
Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

How do you calculate selling price of a product with cost and margin, while taking into account discount and rebates offered to the customer?

Download Excel file for product price calculation, if you would like to practice while watching the video: https://bit.ly/3sdjJic

Some Recommendations:
Learn all about Excel in one place: https://amzn.to/3laCXQx
Learn what financial numbers really mean here: https://amzn.to/2HPYDUI
Accounting explained in 100 pages or Less: https://amzn.to/3rCProc
Are you a First Time or New Manager? Check this out: https://amzn.to/35qWzLc

Videos you may Like:
Sort Pivot Table values, text and Dates Tutorial: https://youtu.be/s8PkgI51a5o
Advanced Pivot Tables for Reporting and Analysis: https://youtu.be/j_ugVlcfm0k
Pivot Table Basics: https://youtu.be/qEL695eaB6E

Here is the link for previous video (markup vs margin and price calculation): https://youtu.be/NDqPX5gnmlw
Here is the link to video explaining Gross profit and net profit: https://youtu.be/Px4pEhiTRdI

If you have tried this calculation of selling price of a product which requires not only the calculation of markup as you only have margin %, but also complicating the calculation are the discount and rebate factors, you may have ended up seeing a Circular Reference error in Excel. This is because the Selling price needs to be calculated, but discount and rebate / commission are also calculated based on the selling price. So, we end up in a circular loop. In this video, I will show you how computers and Excel can help.

Microsoft Excel comes with a built in Solver add-in that does the calculation for you. The Solver Add-in is an advanced version of the Goal Seek function and can even consider constraints to the calculation. All you need to do is to set up the product cost calculation template in a way that the Solver Add-in can do the calculation for you. If you had to do it on your own, you would have to use the trial and error method. But with the Excel Solver Add-in, you don’t have to worry, as it is very quick and easy to calculate selling price of a product so that you can achieve the target margin as well as consider discount and rebates and commissions (if applicable). So, if you are provided with, say discount of 1% and rebates of 3% that the customer would usually be able to claim, you can consider this in the product pricing decisions, and with the help of this calculation, you can calculate exactly the price you need to sell for, in order to still achieve the margin % that was originally required.

Connect:
https://www.instagram.com/learnaccountingfinance
https://www.learnaccountingfinance.com

Subscribe:
http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance #sellingprice #profitmargin