Other Investing Changes Net (Historical)
Returns the net cash flow from other investing activities for a company. This is a catch-all category for investing cash flows not separately classified.
Understanding the Metric
Other investing activities may include:
- Acquisitions and divestitures
- Insurance proceeds
- Settlement receipts/payments
- Joint venture cash flows
- Other non-standard investing items
Positive values indicate cash inflow from other investing activities. Negative values indicate cash outflow.
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_Other_investing_changes_net(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year (e.g., 2023) or period code (lq, lq-1, ly, ly-1, lt, lt-1)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Net other investing activities (in currency units)
Examples
=hf_Other_investing_changes_net("AAPL", 2023, 4)=hf_Other_investing_changes_net("MSFT", "ly")=hf_Other_investing_changes_net("GOOGL", 2023, , "TTM")=hf_Other_investing_changes_net(A1, B1, C1)=hf_Other_investing_changes_net("META", "lq")When to Use
- Reconciling total investing cash flow
- Identifying unusual investing transactions
- Analyzing non-standard investment activities
- Building complete cash flow models
- Investigating cash flow variances
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need capital expenditures | hf_Capital_Expenditures() |
| Need PP&E sales | hf_Sale_of_property_plant_equipment() |
| Need investment purchases | hf_Purchase_of_long_term_investments() |
| Need investment sales | hf_Sale_of_long_term_investments() |
Common Issues & FAQ
What's included in "other investing"?
This is a residual category that captures investing activities not separately reported. Contents vary by company and may include acquisition cash, insurance proceeds, lawsuit settlements, and other items.
Why is this sometimes a large number?
Significant values often indicate acquisitions, major settlements, or unusual investing transactions. Check the company's filings for details on material items.
How do I calculate total investing cash flow?
Sum all investing activities: CapEx + PP&E sales + Investment purchases + Investment sales + Other investing changes. The signs will net to total investing cash flow.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today