Common Stock Equity (Historical)
Returns common stock equity (book value) from historical balance sheets.
Examples
=hf_Common_stock_equity("AAPL", 2023, 4)=hf_Common_stock_equity("MSFT", "ly", 2)When to Use
- Book value analysis
- Price-to-book calculations
- Return on equity calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total equity | hf_Total_equity() |
| Need preferred equity | hf_Preferred_stock_equity() |
Common Issues & FAQ
Q: Is this the same as book value? A: Yes, common stock equity is the book value of common shareholders' equity.
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?