Accrued Expenses (Historical)

Returns accrued expenses from historical balance sheets.

Syntax

=hf_Accrued_expenses(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring
TTMstring

Returns

number

Accrued expenses amount

Examples

=hf_Accrued_expenses("AAPL", 2023, 4)

When to Use

  • Working capital analysis
  • Understanding timing of expenses
  • Liability breakdown

When NOT to Use

Scenario Use Instead
Need accounts payable hf_Accounts_payable()

Common Issues & FAQ

What's included in accrued expenses?

Wages, interest, taxes, and other expenses incurred but not yet paid.

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 Accrued Expenses (Historical) and Other Financial Formulas
How does MarketXLS work?