Auditors Name (Historical)

Returns the name of the auditing firm responsible for auditing the company's financial statements.

Common Auditors

Auditor Type
Deloitte, PwC, EY, KPMG Big Four
BDO, Grant Thornton, RSM Mid-tier
Various regional firms Smaller companies

Notes

  • Big Four auditors typically audit large public companies
  • Auditor changes may signal issues or simply cost management
  • Part of financial statement due diligence

Examples

=hf_Auditors_Name("AAPL", 2023)
Annual data for 2023
=hf_Auditors_Name("MSFT", 2023, 2)
Q2 2023 data
=hf_Auditors_Name("GOOGL", "lq")
Last quarter
=hf_Auditors_Name("TSLA", "ly")
Last year
=hf_Auditors_Name(A1, B1, C1)
Cell references

When to Use

Due diligence, audit firm analysis, corporate governance review

When NOT to Use

| Need audit opinion | hf_Auditors_Report() |

Common Issues & FAQ

Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).

Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.

Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.

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 Auditors Name Aud Name And Aud Op (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions