Net Income Common Stock (Historical) Formula in Excel

Easily fetch a company's net income available to common stockholders for specific historical periods right from Excel using the Net Income Common Stock (Historical) formula with MarketXLS. This powerful function helps you quickly analyze past performance and make data-driven decisions in your Excel workflows.

Understanding Net Income Common Stock (Historical)

Net income available to common stockholders (also known as net income common stock) represents the earnings attributable to regular shareholders after deducting any preferred dividends.

• It is a vital metric that reflects a company's profitability over a specified time period.
• Analysts and investors frequently use this metric to evaluate financial health and compare performance over different years or quarters.
• Suitable for both short-term (quarterly) analysis and long-term (annual or TTM) trend evaluation.

Syntax and Parameters

Use the following syntax to call the Net Income Common Stock (Historical) formula:

=hf_Net_Income_Common_Stock(symbol, year, [quarter], [TTM])

Below is a detailed explanation of the parameters:

?? Note: The function returns "NA" if the symbol is invalid or if there’s an issue retrieving data.

Return Value

• Returns a numeric value representing the company's net income available to common stockholders for the specified period.
• If MarketXLS data subscription or license is not valid, the function may return an error message.

? Pro Tip: Combine this function with other historical fundamental functions (for example, Revenue (Historical), Cost Of Revenue (Historical), etc.) to perform in-depth financial analysis in Excel.

Examples and Usage

Below are some practical examples showing different ways to use the hf_Net_Income_Common_Stock function in Excel:

1. By referencing a cell that has the symbol or date:

   =hf_Net_Income_Common_Stock(A1, B1)

   Where A1 contains "MSFT" and B1 contains "2022".

2. By directly specifying parameters (yearly data):

   =hf_Net_Income_Common_Stock("MSFT", 2022)

3. Including quarter:

   =hf_Net_Income_Common_Stock("MSFT", 2022, 2)

4. Using TTM for trailing twelve months data:

   =hf_Net_Income_Common_Stock("MSFT", 2022, 3, "TTM")

5. Using shortcuts for last quarter and last year:

   • Last Quarter

     =hf_Net_Income_Common_Stock("MSFT", "lq")

   • Last Quarter Minus One

     =hf_Net_Income_Common_Stock("MSFT", "lq-1")

   • Last Year

     =hf_Net_Income_Common_Stock("MSFT", "ly")

   • Last Year Minus One

     =hf_Net_Income_Common_Stock("MSFT", "ly-1")

   • Last 12 Months

     =hf_Net_Income_Common_Stock("MSFT", "lt")

   • Previous Last 12 Months

     =hf_Net_Income_Common_Stock("MSFT", "lt-1")

?? Note: Date parameters can be set up using cell references, direct dates as text, or Excel date functions. For example:
• Cell reference: =hf_Net_Income_Common_Stock(A1, YEAR(A2))
• Direct date: =hf_Net_Income_Common_Stock("MSFT", "2024-03-15")
• Excel date function: =hf_Net_Income_Common_Stock("MSFT", TEXT(A2,"yyyy-mm-dd"))

Common Questions

1. Why am I getting “NA” as a result?

• The symbol may be invalid or unsupported.
• Your MarketXLS subscription plan might not include this historical fundamental data.
• The date or period specified could be out of range.

2. How can I ensure the data is up to date?

• Confirm your MarketXLS license is active and refresh your data.
• Historical fundamental data updates may depend on regulatory filing times.

3. Are there performance considerations when using multiple historical fundamental functions?

• Yes. Each function call may fetch data from MarketXLS servers.
• For faster calculations, consider caching results locally or limiting the number of calls.

4. Can I use this function with other MarketXLS historical fundamental functions?

• Absolutely! Combine it with “Revenue (Historical)” or “Gross Profit (Historical)” to get a comprehensive view of a company’s financial performance.

? Pro Tip: Use Excel’s built-in features like conditional formatting or charts with the returned values to visualize net income trends over time.

Related Functions:

• Revenue (Historical)
• Cost Of Revenue (Historical)
• Gross Profit (Historical)
• R & D Expenses (Historical)
• Selling General and Administrative Expense (Historical)