SheetFix AI

Profit Calculator Template

Tracks revenue and costs and calculates profit and profit margin automatically. Enter what you sold and what it cost; the sheet returns gross profit and the margin as a percentage so you can see at a glance which products or jobs actually make money.

Profit & margin formulas
Gross profit:   =B2-C2
Profit margin:  =(B2-C2)/B2          (format the cell as a percentage)

Try it free

2 of 2 free tries left

How to use it

  1. Put revenue in column B and cost of goods in column C.
  2. Add the gross-profit formula in column D and the margin formula in column E.
  3. Format column E as a percentage.
  4. Need it broken down by product line, by month, or after fees and tax? Describe that in SheetFix AI and get the exact formula for your layout.

Markup vs margin

With revenue in column B and cost in column C, =(B2-C2)/B2 gives profit margin. For a markup-from-cost view instead, use =(B2-C2)/C2.

Related

Build your own version in seconds

Describe the tweak you need — SheetFix AI writes the formula.