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
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
Q: How do I calculate gross margin from this? A: Gross Margin = GrossProfit / Revenue
Q: Why is the number so large? A: Values are in dollars. Divide by 1000000000 for billions.
Q: What's included in COGS? A: 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?