How to Calculate Profit Margin in Excel: Step-by-Step

Calculating your profit margin in Excel can be simple once you know the formulas. Here's a quick step-by-step guide you can follow:

Step 1: Calculate Profit

First, you need to find your profit. The basic formula is:

Profit = Revenue - Cost of Goods Sold (COGS) - Other Expenses

Example:

  • Revenue: $2,000,000
  • COGS: $700,000
  • Other Expenses: $500,000

Profit = $2,000,000 - $700,000 - $500,000 = $800,000

Step 2: Calculate Profit Margin

Next, calculate the profit margin by dividing your profit by your revenue.

Profit Margin = (Profit ÷ Revenue) × 100

Example: Using the numbers above:

Profit Margin = ($800,000 ÷ $2,000,000) × 100 = 40%

Step 3: Set Up the Calculation in Excel

If spreadsheets aren’t your thing 👉Try our pre-built template and skip the setup entirely,

avatar
Leah Tran

Content Executive at TrueProfit & eCommerce Content Specialist

Leah Tran

Leah Tran is a Content Specialist at TrueProfit, where she crafts SEO-driven and data-backed content to help eCommerce merchants understand their true profitability. With a strong background in content writing, research, and editorial content, she focuses on making complex financial and business concepts clear, engaging, and actionable for Shopify merchants.

Let's Collaborate