Profit Margin and Price Markup Calculation and Formulas [Excel]

In this post I am going to run through some Business Maths; to those that are heaving a sigh and have a mental block on maths, I feel your pain. As a high school student my issue with maths in a classroom was always how the examples were relevant to the real world, it was all poles and shadows, angles and area of odd shapes. In Business Maths and Business Statistics everything always ties back to a real problem, or the need for an answer that must be quantified or qualified. The problem could be how much production, how much money, how much profit or simply how many sales days to break-even? This automatically gives relevance to the numbers that you are working with because you are working with money, time (days, weeks, months, quarters, years) and the answer either tell you whether you are mistakes which will cost you money or doing it right and making profit.

This post is fairly high-level and expects you to understand basic maths. We’ll explain some of the concepts and cover Selling Price, Mark-up Percentage, Gross Margin Percentage, and Selling Price Margin which are the sales formulas for businesses. We additionally cover some of the terminology like net, gross, and cost of goods which you hear business people talk about. As we go along we’ll make mention of price-points and other marketing terminology which you might find interesting to look up, and some other academically worthwhile things, that you may or may not know.

Continue reading →