From the course: Financial Analysis: Analyzing the Bottom Line with Excel
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
The basics of gross margin analysis - Microsoft Excel Tutorial
From the course: Financial Analysis: Analyzing the Bottom Line with Excel
The basics of gross margin analysis
In this chapter we will be focusing on the analysis of gross margin. Gross margin is what is left over from your revenue once you have paid all the costs that relate to the production of goods. The more you get of it, the better for your business. To make it simple, the concept is that once a customer has paid for your product, you use that money to pay for all the elements that came into play for the production of your product such as raw material and the labor costs of producing the goods. Of course in real life, you usually pay for those things before you sell them, so that means that you first have to spend the money, and then recover it as you sell your products. Most of the time, you actually buy the raw material in bulk and sell the products one at a time. So there's a bit of computation to be done. Let's imagine that you produce and sell pens. You then have to buy raw material to produce those pens, which in this case is plastic and ink to simplify. Once those are bought they…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
The basics of gross margin analysis3m
-
Finding the data points6m 9s
-
Preparing the data3m 50s
-
Categorizing expenditures3m 48s
-
Allocating costs by category33s
-
Calculating standard costs13m 42s
-
Using standard costs to calculate gross margin2m 30s
-
Adding standard costs to your revenue database4m 39s
-
Calculating gross margin9m 12s
-
Performing a price/mix analysis5m 32s
-
Analyzing overall gross margin performance5m 57s
-
The gross margin percentage levers4m 33s
-
-
-