Data
Cash and Equivalents
LiveCash and cash equivalents are the most liquid current assets found on a business's balance sheet. Cash equivalents are short-term commitments "with temporarily idle cash and easily convertible into a known cash amount".
How calculated | No calculations |
Example usage | =hf_Cash_and_Equivalents("MSFT",2019) - Returns the value for the year 2019.
=hf_Cash_and_Equivalents("MSFT",2019,2) - Returns the value for the year 2019 and the calendar quarter 2
=hf_Cash_and_Equivalents("MSFT",2019,3,"TTM") - Returns the value for the year 2019 and trailing twelve months from the calendar quarter
=hf_Cash_and_Equivalents("MSFT","lq") - Returns the value for the last quarter
=hf_Cash_and_Equivalents("MSFT","lq-1") - Returns the value for the last quarter-1
=hf_Cash_and_Equivalents("MSFT","ly") - Returns the value for the last year
=hf_Cash_and_Equivalents("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Cash_and_Equivalents("MSFT","lt") - Returns the value for the last 12 months.
=hf_Cash_and_Equivalents("MSFT","lt-1") - Returns the value for the previous last 12 months. |
Notes | Cash and cash equivalents do not include inventory and/or credit collateral. |
Assets | Stocks |
| Stock | Cash and Equivalents |
|---|
AAC Holdings Inc.
AAC
NYE
Sector: Healthcare
Industry: Medical Care
10.76
USD
0.00
(0.00%)
Optionable: No Market Cap: 760 M 90-day average vol: 249,032
Previous close: 10.76 Open: 10.76 Bid: 10.68 Ask: 11.24
52 week range
9.91 10.79
Last updated: Thursday 28th September 2023
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todaySearch for a stock
🎉 Exciting news! 🎉
You are invited to join our Discord Channel.
Interact, learn, and grow with experts in the markets!
Join our DiscordCall: 1-877-778-8358
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today
Get started today