Free Cost of Goods Sold Calculator

Learn how to calculate your COGS using our free-to-download cost of goods sold calculator! You can follow right along with the same template used in this video! Our excel COGS template will automatically calculate your COGS using our COGS formula.

Calculate Cost of Goods Sold in Minutes

Our template takes the cost of goods sold equation and automatically calculates your COGS for you

Our easy-to-use COGS calculator will have your monthly AND annual COGS tallied up in just minutes and ready to be plugged into your accounting.

How do I calculate the cost of goods sold?

The calculation for cost of goods sold is starting inventory + purchases − ending inventory = cost of goods sold. For example, at the beginning of each month you should calculate your starting inventory amount and at the end of the month calculate your ending inventory amount. Add your inventory purchases for the month to your starting inventory and subtract your ending inventory amount to determine your cost of goods sold (COGS).

What is COGS?

COGS stands for Cost of Goods Sold.

What should be included in COGS?

COGS should include the direct material expenses and direct labor expenses to produce your product or service.

What is an example of the cost of goods sold?

An example of cost of goods sold would be the cost of food and ingredients at a restaurant as well as the labor cost for the cooks preparing the food.

Which expenses are included in the cost of goods sold?

All direct materials and direct labor costs involved in producing your product or service should be included in your cost of goods sold.

Get the Template!

Check out our Highly Rated Financial Projection Templates

View Templates

★★★★★

I was already trying to create my own spreadsheet and having a system in place that already has the formulas and has the data the SBA lender will be looking for is a time saver. I'm trying to look at as much content from your channel as I can to get insight on what to expect.

Heather Brady

Buck's Labradors

★★★★★

As an investor in multiple industries, my first step before diving deep into the investment is to do a financial analysis and projections for the next 5 years. Over the years, I've developed my own excel worksheets, and have adapted them to fit my needs. On a whim, I decided to google for such an investment template, willing to pay for the time-it will save me in the long-term. Given the money-back guarantee, I went ahead and purchased the first template. I was blown away by the level of detail and care Adam has provided, and after a few hours of inputting the data and seeing the results, I was convinced it was a wise investment on my part. No regrets. I had a question which I asked Adam via his on-line chat, and within an hour or two, he made a custom video showing me the answer to my question. I would have never imagined this level of personal service given by someone who clearly cares about his customer's experience. Bottom line, awesome tools, awesome service, and I feel very pleased with my purchase decision.

M. N.

Investor

See More Reviews