MarketXLS

Net Income Common Stock USD (Historical)

Returns the historical net income attributable to common stockholders, converted to USD. This metric represents the portion of net income available to common shareholders after deducting preferred dividends and other adjustments.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Period Codes

Code Description
lq Last reported quarter
lq-1 One quarter ago
ly Last fiscal year
ly-1 Previous fiscal year
lt Last twelve months (TTM)

Notes

  • Values are in USD regardless of company's reporting currency
  • Excludes net income attributable to non-controlling interests
  • Excludes preferred dividends

Syntax

=hf_Net_Income_Common_Stock_USD(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Net income attributable to common stockholders in USD

Examples

=hf_Net_Income_Common_Stock_USD("AAPL", 2023, 4)
Q4 2023 net income common USD
=hf_Net_Income_Common_Stock_USD("MSFT", "ly")
Last fiscal year
=hf_Net_Income_Common_Stock_USD("GOOGL", 2023, , "TTM")
Trailing 12 months
=hf_Net_Income_Common_Stock_USD(A1, B1, C1)
From cell references
=hf_Net_Income_Common_Stock_USD("NVDA", "lq")
Last quarter

When to Use

  • Comparing profitability across companies with different currencies
  • Analyzing earnings trends for common shareholders
  • Computing EPS manually with shares outstanding
  • Building financial models requiring USD standardization
  • Valuation analysis for common equity

When NOT to Use

Scenario Use Instead
Need total net income hf_Net_Income()
Need discontinued operations income hf_Net_Income_from_Discontinued_Operations()
Need EPS directly hf_Earnings_per_Basic_Share()
Need local currency values hf_Net_Income_Common_Stock()

Common Issues & FAQ

Why is my value different from the annual report?

This returns USD-converted values. Check if the company reports in a different currency. Also verify the fiscal period matches.

What's the difference from hf_Net_Income?

hf_Net_Income_Common_Stock_USD() excludes preferred dividends and non-controlling interests, showing only what common shareholders earned.

How do I get quarterly data?

Specify the quarter parameter: =hf_Net_Income_Common_Stock_USD("AAPL", 2023, 3) for Q3 2023.

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
MarketXLS Excel Add-in Tutorial - How to Use Net Income Common Stock USD (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions