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 CashThis 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 |
Examples
=hf_Cash_at_end_of_period("AAPL", 2023, 4)=hf_Cash_at_end_of_period("MSFT", "ly")=hf_Cash_at_end_of_period("GOOGL", 2023, , "TTM")=hf_Cash_at_end_of_period(A1, B1, C1)=hf_Cash_at_end_of_period("META", "lq")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
Q: Why doesn't this match the balance sheet cash? A: They should match. Small differences may arise from restricted cash treatment or rounding. Check if restricted cash is included or excluded.
Q: What's included in cash equivalents? A: Generally, highly liquid investments with original maturities of 3 months or less, such as Treasury bills, money market funds, and commercial paper.
Q: How do I calculate cash runway? A: Divide ending cash by monthly cash burn rate (negative operating cash flow / months). This estimates how long the company can operate on current cash.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today