API: Total Assets to Invested Capital Reconciliation

This data set contains the adjustments we make to convert reported total assets to Invested Capital. Updated daily.

API: Total Assets to Invested Capital Reconciliation: Single Datapoint

Endpoint
URL
Method
/reconciliation/total-assets-to-invested-capital/:ticker
GET
URL Parameters
Name
Description
Example
:ticker
Ticker of the stock. You can use the coverage endpoint to get full lists of options.
A
Query Parameters
Name
Required
Description
Example
:datapoint
Required
Name of data point. Click here for a full list of available data points
EXCESS_CASH
:year
Required
Fiscal year of the data point. We generally cover companies back to the first digital document filed with the SEC.
2017
:quarter
Optional
Fiscal quarter Options:
Omit for annual data
1 = Q1 quarterly data
2 = Q2 quarterly data
3 = Q3 quarterly data
4 = Q4 quarterly data
1
:ttm
Optional
Trailing twelve months (TTM) data Options:
Omit for annual data
1 = TTM data ending with Q1 (indicated fiscal year Q1 + prior fiscal year Q4, Q3, & Q2)
2 = TTM data ending with Q2 (indicated fiscal year Q2 & Q1 + prior fiscal year Q4 & Q3)
3 = TTM data ending with Q3 (indicated fiscal year Q3, Q2, & Q1 + prior fiscal year Q4)
4 = TTM data ending with Q4 (indicated fiscal year Q4, Q3, Q2, & Q1).
1
Header Parameters
Name
Value
x-api-key
[New Constructs-provided API key]
Content-Type
application/json
Return Values
Name
Description
Example
ticker
Ticker of the listed security.
AAPL
year
Fiscal year of the data value.
2017
period
Period of the requested data; 1-4 indicate quarterly or TTM periods and 5 indicates an annual period.
5
periodtype
Period type of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
periodstring
Period string of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
datapoint
Name of data point.
EXCESS_CASH
datavalue
Value of the requested datapoint in ones.
200991700000.00000000000000000
filingtype
Type of filing the datapoint is from.
10-K
Sample Call:
curl -i -H 'x-api-key: [New Constructs-provided API key]' -H "Content-Type: application/json" 'https://api.newconstructs.com/v1/reconciliation/total-assets-to-invested-capital/AAPL?datapoint=EXCESS_CASH&year=2015'
Success Response:

{
  "statusCode": 200,
  "headers": {"Content-Type": "application/json"},
  "body": {
    "results": [
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "EXCESS_CASH",
        "datavalue": "200991700000.00000000000000000",
      "filingtype": "10-K"
      }
    ]
  }
}
  

API: Total Assets to Invested Capital Reconciliation: All Datapoints

Endpoint
URL
Method
/reconciliation/total-assets-to-invested-capital/:ticker
GET
URL Parameters
Name
Description
Example
:ticker
Ticker of the stock. You can use the coverage endpoint to get full lists of options.
A
Query Parameters
Name
Required
Description
Example
:year
Required
Fiscal year of the data point. We generally cover companies back to the first digital document filed with the SEC.
2017
:quarter
Optional
Fiscal quarter Options:
Omit for annual data
1 = Q1 quarterly data
2 = Q2 quarterly data
3 = Q3 quarterly data
4 = Q4 quarterly data
1
:ttm
Optional
Trailing twelve months (TTM) data Options:
Omit for annual data
1 = TTM data ending with Q1 (indicated fiscal year Q1 + prior fiscal year Q4, Q3, & Q2)
2 = TTM data ending with Q2 (indicated fiscal year Q2 & Q1 + prior fiscal year Q4 & Q3)
3 = TTM data ending with Q3 (indicated fiscal year Q3, Q2, & Q1 + prior fiscal year Q4)
4 = TTM data ending with Q4 (indicated fiscal year Q4, Q3, Q2, & Q1).
1
Header Parameters
Name
Value
x-api-key
[New Constructs-provided API key]
Content-Type
application/json
Return Values
Name
Description
Example
ticker
Ticker of the listed security.
AAPL
year
Fiscal year of the data value.
2017
period
Period of the requested data; 1-4 indicate quarterly or TTM periods and 5 indicates an annual period.
5
periodtype
Period type of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
periodstring
Period string of the requested data (ANNUAL, QUARTERLY, or TTM)
ANNUAL
datapoint
Name of data point.
EXCESS_CASH
datavalue
Value of the datapoint in ones.
200991700000.00000000000000000
filingtype
Type of filing the datapoint is from.
10-K
Sample Call:
curl -i -H 'x-api-key: [New Constructs-provided API key]' -H "Content-Type: application/json" 'https://api.newconstructs.com/v1/reconciliation/total-assets-to-invested-capital/AAPL?year=2015'
Success Response:

{
  "statusCode": 200,
  "headers": {"Content-Type": "application/json"},
  "body": {
    "results": [
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "EXCESS_CASH",
        "datavalue": "200991700000.00000000000000000",
      "filingtype": "10-K"
      },
      {
        "ticker": "AAPL",
        "year": 2015,
        "period": 5,
        "periodtype": "ANNUAL",
        "periodstring": "ANNUAL",
        "datapoint": "CAPITAL_INVESTED",
        "datavalue": "21193617485.12970000000000000",
      "filingtype": "10-K"
      },
      ...
    ]
  }
}
  

Datapoints

Name
Description
Datapoint
Total Assets (Unadjusted)
Reported total assets as shown in the filing.
ASSETS_UNADJUSTED
- Excess Cash
The amount of cash on hand over and above what is needed in the current year to fund the operations of the business for the foreseeable future.
EXCESS_CASH
- NIBCL (Non-Interest-Bearing Current Liabilities)
Total non-interest bearing current operating liabilities including accrued expenses and payables.
NIBCL
+ Hidden Short-Term Debt
Short-term debt hidden in non-interest bearing current liabilities (NIBCLs).
DEBT_SHORT_TERM_IN_NIBCL_OPERATING
+ Total Reserves
Sum of the current ending reserve balances for LIFO, inventory, and loan loss reserves.
RESERVES_TOTAL
- Total Reported Operating Lease Assets
The total value of operating lease assets reported on the balance sheet.
TOTAL_REPORTED_OPERATING_LEASE_ASSETS
- Hidden Fixed Operating Lease Assets Less Current Operating Lease Liabilities
The total value of hidden operating lease assets less current operating lease liabilities.
TOTAL_HIDDEN_OPERATING_LEASES_ASSETS_NET
+ Total Standardized Present Value of Operating, Variable and Non-Commenced Leases
Net Present Value of Operating Lease Payments, Variable Leases, and Not Yet Commenced Leases.
LEASES_PRESENT_VALUE_TOTAL
- Unconsolidated Subsidiary Assets (non-operating)
Investment in unconsolidated subsidiaries that are not part of operations. A fixed asset on the balance sheet.
ASSETS_FIXED_UNCONSOLIDATED
- Total Discontinued Operations Assets
None
ASSETS_DISCONTINUED_OPERATIONS
+ Accumulated Goodwill Amortization
Accumulated Goodwill Amortization
GOODWILL_AMORTIZATION_ADJUSTED_ACCUMULATED
+ Accumulated Asset Write-Downs After-Tax
Total of all write-downs after tax from the current year plus all write-downs from prior years.
WRITE_DOWNS_AFTER_TAX_TOTAL_ACCUMULATED
+ Accumulated Unrecorded Goodwill
Total amount of unrecorded goodwill collected from the current year and all other previous years.
GOODWILL_UNRECORDED_ACCUMULATED
- Total Reported Deferred Tax Assets
The total value of deferred tax assets reported on the balance sheet.
TOTAL_REPORTED_DEFERRED_TAX_ASSETS
- Hidden Deferred Tax Assets Less Current Deferred Tax Liabilities
Hidden Deferred Tax Assets Less Current Deferred Tax Liabilities
TOTAL_HIDDEN_DEFERRED_TAX_ASSETS_NET
- Total Reported Deferred Compensation Assets
The total value of deferred compensation assets reported on the balance sheet.
TOTAL_REPORTED_DEFERRED_COMPENSATION_ASSETS
- Hidden Deferred Compensation Assets Less Current Deferred Compensation Liabilities
The total value of hidden deferred compensation assets minus hidden current deferred compensation liabilities.
TOTAL_HIDDEN_DEFERRED_COMPENSATION_ASSETS_NET
- Over Funded Pensions
Overfunded status of a pension plan (if the pension plan is an unfunded liability this value will be 0).
PENSION_FUNDED_STATUS_LIMITED
- Accumulated OCI (Other Comprehensive Income), Including Quarterly Estimates
Estimate of Accumulated Other Comprehensive Income, from the shareholders' equity section of the balance sheet. Primarily for IFRS companies that don't report OCI in their quarterly filings.
OCI_ADJUSTED
= Invested Capital
Invested capital is the value of the money invested in a business over its lifetime.
CAPITAL_INVESTED

*Indicates the datapoint is affected by stock price.

API: Fundamental Data Errors

Error
Message
Error Code
DataPointNotFound
The requested datapoint was not found.
404