Non Current Deferred Income Taxes (Historical)
Returns the non-current (long-term) portion of deferred income taxes, representing timing differences between book and tax accounting that will reverse after one year.
Notes
- Balance sheet liability (usually) or asset
- Results from temporary differences in accounting
- Examples: depreciation timing, revenue recognition
- Long-term portion vs current deferred taxes
Syntax
=hf_Non_Current_Deferred_Income_Taxes(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
Examples
=hf_Non_Current_Deferred_Income_Taxes("AAPL", 2023)=hf_Non_Current_Deferred_Income_Taxes("MSFT", 2023, 2)=hf_Non_Current_Deferred_Income_Taxes("GOOGL", "lq")=hf_Non_Current_Deferred_Income_Taxes("TSLA", "ly")=hf_Non_Current_Deferred_Income_Taxes(A1, B1, C1)When to Use
Tax analysis, balance sheet breakdown, deferred tax liability tracking
When NOT to Use
| Need current deferred taxes | hf_Deferred_income_taxes() |
| Need total tax expense | hf_Income_Tax_Expense() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Normalized Income (Historical)
- Normalized Income Per Employee (Historical)
- Normalized Low Price Earnings Ratio (Historical)
- Normalized Net Profit Margin (Historical)
- Normalized Return On Assets (Historical)
- Normalized Return On Invested Capital (Historical)
- Normalized Return On Stock Equity (Historical)
- Notes Payable (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today