Current Deferred Income Taxes (Historical)

Returns current (short-term) deferred income taxes from historical balance sheets.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Calendar quarter 1-4
TTM No Set to "TTM" for trailing twelve months

Notes

  • Represents timing differences between book and tax accounting
  • Current portion expected to reverse within one year
  • Can be asset or liability depending on timing differences

Examples

=hf_Current_deferred_income_taxes("AAPL", 2023, 4)
Apple Q4 2023
=hf_Current_deferred_income_taxes("MSFT", "ly", 2)
Microsoft last year Q2
=hf_Current_deferred_income_taxes(A1, B1, C1)
Cell references

When to Use

  • Tax planning analysis
  • Understanding book-tax differences
  • Current asset/liability breakdown
  • Tax timing difference analysis

When NOT to Use

Scenario Use Instead
Need long-term deferred taxes hf_Deferred_income_taxes()
Need tax expense hf_Income_tax_expense()
Need effective tax rate hf_Effective_tax_rate()

Common Issues & FAQ

Q: Why do deferred taxes exist? A: Differences in timing between when expenses/income are recognized for book vs tax purposes.

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 Current Deferred Income Taxes (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions