Sale Of Property Plant Equipment (Historical)
Returns the cash proceeds from the sale of property, plant, and equipment (PP&E) for a company. This is an investing activity that generates cash from disposing of fixed assets.
Understanding the Metric
This line item represents:
- Cash received from selling buildings, land, machinery
- Proceeds from equipment disposals
- Asset sales as part of restructuring or optimization
Positive values indicate cash received from asset sales. Zero or small values are common for companies not actively divesting assets.
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_Sale_of_property_plant_equipment("GE", 2023, 4)=hf_Sale_of_property_plant_equipment("MSFT", "ly")=hf_Sale_of_property_plant_equipment("CAT", 2023, , "TTM")=hf_Sale_of_property_plant_equipment(A1, B1, C1)=hf_Sale_of_property_plant_equipment("BA", "lq")When to Use
- Analyzing asset restructuring activities
- Understanding investing cash flow components
- Evaluating asset turnover strategies
- Calculating net capital expenditures
- Assessing divestiture programs
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need capital expenditures | hf_Capital_Expenditures() |
| Need net PP&E balance | hf_Property_Plant_Equipment() |
| Need investment sales | hf_Sale_of_long_term_investments() |
| Need total investing cash flow | Combine all investing activities |
Common Issues & FAQ
Q: Why is this value often zero? A: Many companies don't actively sell PP&E in a given period. Large values typically occur during restructuring, downsizing, or strategic asset disposals.
Q: Does this include gains on sale? A: This shows the cash proceeds, not the gain/loss. The gain or loss (proceeds minus book value) appears on the income statement.
Q: How does this relate to net capital expenditures? A: Net CapEx = Capital Expenditures - Sale of PP&E. This gives a clearer picture of net investment in fixed assets.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today