Gross Profit
Returns the gross profit, calculated as total revenue minus cost of goods sold (COGS). This represents the profit before operating expenses.
Calculation
Gross Profit = Revenue - Cost of Goods SoldSupported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Canadian | SYMBOL:CA | SHOP:CA |
Notes
- Value is in the company's reporting currency (usually USD)
- Uses trailing twelve months data
- Shows profitability at the product level
Syntax
=GrossProfit(Symbol)Examples
=GrossProfit("AAPL")=GrossProfit("MSFT")=GrossProfit("GOOGL")=GrossProfit(A1)=GrossProfit("AAPL")/1e9When to Use
- Product profitability analysis
- Manufacturing efficiency
- Gross margin calculation
- Industry comparison
- Trend analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need gross margin (%) | GrossMargin() |
| Need operating income | EBIT/operating functions |
| Need net income | hf_Net_Income() |
| Need total revenue | Revenue() |
Common Issues & FAQ
How do I calculate gross margin from this?
Gross Margin = GrossProfit / Revenue
Why is the number so large?
Values are in dollars. Divide by 1000000000 for billions.
What's included in COGS?
Direct costs of production including materials, direct labor, and manufacturing overhead.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?