Restricted Cash (Historical) Formula in Excel

Understanding Restricted Cash (Historical)

Restricted cash refers to the portion of a company's funds set aside for specific use and not freely accessible for general business purposes. This can include money that must be reserved to meet legal obligations, loan repayments, or other contractual requirements. By using the "Restricted Cash (Historical)" formula in Excel with MarketXLS, you can:

• Track the historical restricted cash of a company over specific years or quarters.
• Gain insight into the liquidity and operational constraints a company may face.
• Make more informed decisions based on past trends of reserved funds.

? Pro Tip: Use this formula alongside other financial metrics (like revenue or gross profit) to build a comprehensive historical analysis of a company's financial statements.

Syntax and Parameters

=hf_Restricted_Cash(Symbol, Year, [Quarter], [TTM])

?? Note:

• If an invalid symbol is provided or the data is unavailable, the function returns "NA".
• Licensing checks may apply. If your MarketXLS plan is not valid for this function, "NA" is returned.

Return Value

The function returns a numeric value representing the restricted cash for the specified period. If the data is unavailable or an error occurs, the function returns "NA".

Date Input Formats

You can supply Year in multiple ways:

1. Cell references:

   =hf_Restricted_Cash(A1, B1)

2. Direct Year strings:

   =hf_Restricted_Cash("MSFT", "2024")

3. Using Excel date functions:

   =hf_Restricted_Cash("MSFT", TEXT(A1,"yyyy"))

Examples and Usage

Basic Examples

1. Display restricted cash for a specific year:

   =hf_Restricted_Cash("MSFT", 2022)

   Retrieves restricted cash for Microsoft in 2022.

2. Check the value for a year and quarter:

   =hf_Restricted_Cash("MSFT", 2022, 2)

   Returns the value for the second quarter of 2022.

3. Obtain trailing twelve months restricted cash:

   =hf_Restricted_Cash("MSFT", 2022, 3, "TTM")

   Returns TTM restricted cash as of the third quarter of 2022.

Advanced Scenarios

• Last Quarter or Last Year shortcuts:

  • =hf_Restricted_Cash("MSFT", "lq")

    Get restricted cash for the most recent quarter (last quarter).

  • =hf_Restricted_Cash("MSFT", "ly-1")

    Get restricted cash for the previous year prior to the last year.

• Combining with other date-based inputs:

  • =hf_Restricted_Cash("BTCUSD:DEFAULT", "lq-2")

    Retrieves restricted cash data for a crypto-referenced symbol two quarters before the last quarter (if available).

? Pro Tip: Combine this formula with other MarketXLS historical financial functions (e.g., hf_Revenue, hf_Gross_Profit) for a comprehensive view of a company’s historical performance.

Common Questions

1. Why am I getting "NA" instead of a numeric value?

"NA" indicates either invalid symbol, unavailable data for the requested period, or insufficient licensing. Verify the symbol, date range, and your MarketXLS subscription plan.

2. Does this function work for different security types?

Yes. You can use standard stock symbols ("MSFT"), indices ("^SPX"), options ("@MSFT 110122C00020000"), and cryptocurrencies ("BTCUSD:DEFAULT"), as long as MarketXLS supports them.

3. Are there performance considerations?

If you repeatedly call this function for many symbols, you might see slower performance due to multiple data requests. To optimize, consider:

• Using fewer calls by batching them in selected cells or worksheets.
• Refreshing data less frequently if your spreadsheet includes a large number of formulas.

4. How do I update the formula for new data?

MarketXLS automatically updates the data feed. Recalculate your workbook or press "Refresh All" in Excel to fetch the latest restricted cash information.

?? Note: Always ensure your MarketXLS plugin is up to date to access the most recent data and features.