API: Economic Book Value Calculation

The data used to calculate Economic Book Value, our measure of the no-growth value of a stock. Updated daily.

API: Economic Book Value Calculation: Single Datapoint

Endpoint
URL
Method
/metrics/ebv/: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/metrics/ebv/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: Economic Book Value Calculation: All Datapoints

Endpoint
URL
Method
/metrics/ebv/: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/metrics/ebv/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": "NOPAT",
        "datavalue": "52716962727.16620000000000000",
      "filingtype": "10-K"
      },
      ...
    ]
  }
}
  

Datapoints

Name
Description
Datapoint
NOPAT (Net Operating Profit After Tax)
NOPAT (Net Operating Profit After Tax)
NOPAT
/ WACC (Weighted Average Cost of Capital)*
WACC (Weighted Average Cost of Capital)
WACC
+ 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
+ Net Assets from Discontinued Operations
Net Assets from Discontinued Operations
ASSETS_DISCONTINUED_NET
+ Fair Value of Unconsolidated Subsidiary Assets (non-operating)
Fair Value of Unconsolidated Subsidiary Assets (non-operating)
ASSETS_FIXED_UNCONSOLIDATED_ADJUSTED
+ Net Deferred Tax Liability
Net Deferred Tax Liability
DEFERRED_TAX_NET_ADJUSTED
+ Net Deferred Compensation Assets
Net Deferred Compensation Assets
ASSETS_DEFERRED_COMPENSATION_NET
- Fair Value of Total Debt
Short-Term Debt and Long-Term Debt adjusted to fair value.
DEBT_ADJUSTED
- Fair Value of Preferred Capital
Dollar value of the preferred capital adjusted for fair value of preferred stock.
STOCK_PREFERRED_ADJUSTED
- Fair Value of Minority Interests
Carrying value of minority interests adjusted to fair value.
INTEREST_MINORITY_ADJUSTED
- Value of Outstanding ESO After-Tax*
The after-tax fair market value of ESOs net of assumed options cancelled.
ESO_TRANCHE_VALUE_AFTER_TAX
+ Pensions Net Funded Status
Funded status of pension plans.
PENSION_FUNDED_STATUS_ADJUSTED
= Economic Book Value (EBV)*
Economic book value measures the no-growth value of the company based on the current Net Operating Profit After Tax (NOPAT) of the business.
BOOK_VALUE_ECONOMIC

*Indicates the datapoint is affected by stock price.

API: Fundamental Data Errors

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