MarketXLS

Cash At End Of Period (Historical)

Returns the cash and cash equivalents balance at the end of a reporting period. This is the closing cash position after all cash flows for the period.

Understanding the Metric

This represents:

  • Cash in bank accounts
  • Highly liquid short-term investments (typically < 3 months maturity)
  • Other cash equivalents

Relationship:

Ending Cash = Beginning Cash + Net Change in Cash

This becomes the next period's beginning cash balance.

Parameters

Parameter Description
Symbol Stock ticker (e.g., AAPL, MSFT)
Year Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1)
Quarter Optional: 1, 2, 3, or 4 (default: 1)
TTM Optional: "TTM" for trailing twelve months

Period Codes

Code Meaning
lq Last reported quarter
lq-1 Quarter before last
ly Last fiscal year
ly-1 Year before last
lt Last trailing twelve months
lt-1 Prior trailing twelve months

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year (e.g., 2023) or period code (lq, lq-1, ly, ly-1, lt, lt-1)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Cash and cash equivalents at end of period (in currency units)

Examples

=hf_Cash_at_end_of_period("AAPL", 2023, 4)
Q4 2023 ending cash
=hf_Cash_at_end_of_period("MSFT", "ly")
Last fiscal year end
=hf_Cash_at_end_of_period("GOOGL", 2023, , "TTM")
TTM period end
=hf_Cash_at_end_of_period(A1, B1, C1)
Cell references
=hf_Cash_at_end_of_period("META", "lq")
Last quarter end

When to Use

  • Tracking historical cash positions
  • Analyzing liquidity trends
  • Reconciling cash flow statements
  • Evaluating financial health
  • Building cash position timelines

When NOT to Use

Scenario Use Instead
Need beginning cash balance hf_Cash_at_beginning_of_period()
Need cash change amount hf_Net_change_in_cash_and_cash_equivalents()
Need total liquidity Include short-term investments
Need current cash Use latest period (lq)

Common Issues & FAQ

Why doesn't this match the balance sheet cash?

They should match. Small differences may arise from restricted cash treatment or rounding. Check if restricted cash is included or excluded.

What's included in cash equivalents?

Generally, highly liquid investments with original maturities of 3 months or less, such as Treasury bills, money market funds, and commercial paper.

How do I calculate cash runway?

Divide ending cash by monthly cash burn rate (negative operating cash flow / months). This estimates how long the company can operate on current cash.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

See hf_Cash_at_end_of_period used in a complete workbook: DCF Model Excel: Build a Discounted Cash Flow Valuation Template (2026)

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 At End Of Period (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions