Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Easily Get Non-Current Deferred Income Taxes with MarketXLS

The hf_non_current_deferred_income_taxes function in MarketXLS allows you to pull a company’s non-current deferred income tax values directly into Excel. This data can help you analyze a business’s tax liabilities on the balance sheet. With this function, you can select specific historical periods (annual, quarterly) or even a trailing twelve-month (TTM) figure, giving you the flexibility to align these numbers with your financial models.

Why Use This Function?

  • Integrate real-time or historical data on non-current deferred taxes directly into Excel.
  • Perform quick comparisons across different years and quarters for any symbol.
  • Retrieve trailing twelve-month figures for more up-to-date analysis.
  • Streamline your workflow by avoiding manual data entry and reducing potential errors.
  • Gain deeper insight into a company’s tax positions and overall financial health.

How to Use in Excel

=hf_non_current_deferred_income_taxes(Symbol,Year,Quarter,[TTM])

• Symbol: Stock ticker symbol in the market (e.g., "AAPL").
• Year: Numeric year (e.g., 2021).
• Quarter: Numeric quarter (1, 2, 3, or 4). Defaults internally to "1" if not supplied in Excel.
• [TTM]: Optional. Use "TTM" to return the trailing twelve-month value.

When you enter the function in Excel, MarketXLS will query the MarketXLS data service. If the data is not yet cached or is being updated, it may temporarily return "Refreshing". If an invalid symbol or period is provided (or if your license does not support this feature), the function returns "NA".

Parameters Explained

Parameter Description Example Values Notes
Symbol The stock ticker of the company you want to query. "AAPL", "MSFT" Use recognized, valid market symbols. Returns "NA" if symbol is invalid.
Year The year for which you want the non-current deferred taxes. 2020, 2021 Accepts numeric values. Used together with Quarter or TTM.
Quarter The quarter you want (1, 2, 3, or 4). 1, 2, 3, 4 Defaults to "1" if not explicitly provided in Excel. When not used, code may fall back to yearly mode for some calls.
TTM Optional parameter to retrieve trailing twelve months data. "TTM" If set to "TTM", the function looks up TTM data. Otherwise, it will return quarterly or annual data depending on other parameters.

Example Usage

Basic Examples

  1. Retrieve Non-Current Deferred Taxes for Apple, Annual 2020
    =hf_non_current_deferred_income_taxes("AAPL", 2020, 1)
    Explanation: Returns Apple’s non-current deferred taxes for FY2020. Even though Quarter = 1 is provided, the code will handle annual data if needed.

  2. Retrieve Non-Current Deferred Taxes for Microsoft, Q2 2021
    =hf_non_current_deferred_income_taxes("MSFT", 2021, 2)
    Explanation: Returns Microsoft’s non-current deferred tax figure for the second quarter of 2021.

  3. Retrieve Non-Current Deferred Taxes TTM for Tesla, Q3 2022
    =hf_non_current_deferred_income_taxes("TSLA", 2022, 3, "TTM")
    Explanation: Returns Tesla’s trailing twelve-month non-current deferred tax figure as of the third quarter of 2022.

Advanced Scenarios

• Comparing quarterly vs. TTM data:
=hf_non_current_deferred_income_taxes("AAPL", 2021, 4)
vs.
=hf_non_current_deferred_income_taxes("AAPL", 2021, 4, "TTM")
This can show you the difference between one quarter’s data and the rolling twelve-month figure.

• Using historical data in a model:
=hf_non_current_deferred_income_taxes("GOOGL", 2019, 1)
Pulls the non-current deferred taxes for Alphabet in Q1 2019, which you can compare across multiple years to spot trends or anomalies in tax liabilities.

• Tracking data while refreshing:
If the data is still loading or updating, you might briefly get the result "Refreshing". You can set up your spreadsheet to re-check that cell after some time or trigger a manual refresh.

Common Questions and Troubleshooting

  1. "Why am I getting 'NA'?"

    • Make sure the symbol is valid.
    • Check that the year and quarter (if provided) are numeric and within a reasonable range.
    • Confirm your MarketXLS license supports this function.
  2. "Why does the return sometimes display 'Refreshing'?"

    • The data may be in the process of being updated or added to the waitlist on the backend. Let it finish loading, or refresh again later.
  3. "Can I use partial years or advanced date references?"

    • Currently, the function expects a standard numeric year and optionally a quarter. If you need advanced references (e.g., last quarter, last year), consider additional MarketXLS functions or referencing the built-in Excel date/time features.
  4. "What if the TTM data doesn't exist for my symbol and year?"

    • Some companies may not have TTM values for certain historical periods. In those cases, you will see "NA". Make sure that the symbol has enough historical financial data for TTM calculations.

By using hf_non_current_deferred_income_taxes in your MarketXLS-enabled spreadsheet, you can seamlessly integrate crucial tax liability data across your analyses, track trends, and make informed financial decisions—all without leaving Excel.