Share Based Compensation (Historical)
Stock options and RSU expenses.
Syntax
=hf_Share_Based_Compensation(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Stock-based compensation in USD
Examples
=hf_Share_Based_Compensation("META", 2023, 4)When to Use
- Dilution analysis
- True cash flow calculation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Operating expenses | hf_Operating_Expenses() |
Common Issues & FAQ
Non-cash expense added back in cash flow.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?