Level 1Analyst HabitsPractice, 3 min
Gross margin
The task
Gross profit is already calculated in B4. In B5, calculate gross margin: gross profit as a share of revenue.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | 2026 | |
| 2 | Revenue | $966,000 |
| 3 | Cost of goods sold | $541,000 |
| 4 | Gross profit | =B2-B3 |
| 5 | Gross margin |