Home MS Excel TutorialExcelTips and Tricks How To Calculate Cogs In Excel

How To Calculate Cogs In Excel

by Easy Excel Tutorials

How To Calculate Cogs In Excel

In this lesson you can learn how to calculate COGS in Excel.

COGS stands for cost of goods sold.

Let’s build the cost of goods sold calculator in Excel. To calculate COGS in Excel first you need some data. You need: Beginning Inventory, Purchases During the Period and Ending Inventory

The formula to calculate COGS is as follows:

Cost of Goods Sold = Beginning Inventory + Purchases During the Period – Ending Inventory

Copy and paste this ROI(Return on investment) formula in cell B5: .


how to calculate COGS

This formula will calculate the COGS for data you place in cells B2, B3 and B4 and is based on cogs formula:

COGS= Inventory difference + Purchases


You can download the Template here – Download

You may also like