Cash And Equivalents (Historical)

Returns the historical cash and cash equivalents balance from the balance sheet - highly liquid assets that can be converted to cash immediately.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

What's Included

Item Description
Cash Currency on hand and demand deposits
Cash Equivalents Money market funds, T-bills < 90 days
Short-term Investments May be included (varies by company)

Notes

  • Most liquid asset on balance sheet
  • Balance sheet item (point-in-time)
  • Companies may also hold marketable securities separately
  • For international companies, use USD version for comparison

Examples

=hf_Cash_and_Equivalents("AAPL", 2023, 4)
Q4 2023 cash balance
=hf_Cash_and_Equivalents("MSFT", "ly")
Last fiscal year
=hf_Cash_and_Equivalents("GOOGL", 2023, , "TTM")
Trailing period
=hf_Cash_and_Equivalents(A1, B1, C1)
From cell references

When to Use

  • Liquidity analysis
  • Cash position monitoring
  • Quick ratio calculation
  • M&A capacity assessment
  • Financial flexibility analysis

When NOT to Use

Scenario Use Instead
Need USD-converted cash hf_Cash_and_Equivalents_USD()
Need total current assets hf_Current_Assets()
Need operating cash flow hf_Net_Cash_Flow_from_Operations()
Need net cash change hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents()

Common Issues & FAQ

Q: Why is Apple's cash lower than expected? A: Apple holds much of its liquidity in marketable securities, not pure cash. Check both cash and short-term investments for full picture.

Q: How do I calculate quick ratio? A: Quick Ratio = (Cash + Receivables) / Current Liabilities: =(hf_Cash_and_Equivalents("AAPL","lq") + hf_Trade_and_Non_Trade_Receivables("AAPL","lq")) / hf_Current_Liabilities("AAPL","lq")

Q: Cash decreased but the company was profitable? A: Common reasons: large CapEx, acquisitions, share buybacks, debt repayment, or working capital build. Check the cash flow statement sections.

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 Cash And Equivalents (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions