Owners Earnings

The owners data type returns the owners earnings for a stock on a quarterly basis. Owners earnings is a valuation method first coined by Warren Buffet in his 1986 letter to Berkshire Hathaway shareholders. It is a measure of the cash that is available to shareholders after capital expenditures and working capital needs are met. See Owners Earnings Calculation Method for the detailed calculation.

=SF(symbol, "owners", metrics, year, options)

• symbol is the ticker symbol of the financial asset (e.g., "AAPL"). You can use our Symbol Search to find the correct ticker symbol.

• metrics selects what metrics to display (see options below), display all metrics by leaving blank or using "all". Chain together as many metrics as you'd like using &, e.g., "date&growthCapex&ownersEarnings".

• year is year or range of years for which you want to retrieve the data. You can enter a single year (e.g. 2020) or a range of years (e.g. 2019-2021).

• options adjusts the formatting of the output. Available options include: (1) "NH" for no header rows, (2)"-" for reversing the output and (3) "calYear" which adjusts the search to calendar years instead of fiscal years. You can chain together as many options as you'd like using &, e.g., "NH&-".

The Owners Earnings metrics options are:

• All ("all")

• Date ("date")

• Average PPE-Sales ("averagePPE")

• Maintenance Capex ("maintenanceCapex")

• Growth Capex ("growthCapex")

• Owners Earnings ("ownersEarnings")

• Owners Earnings Per Share ("ownersEarningsPerShare")

Owners Earnings Calculation Method

Average PPE-Sales

Average PPE-Sales = sum of PPE last 7 statements / sum of revenue last 7 statements

Growth Capex

Growth Capex = Average PPE-Sales * (Revenue - Revenue Prev. Quarter)

Maintenance Capex

IF Revenue < Revenue Prev. Quarter: Maintenance Capex = Capital Expenditure
IF Growth Capex <= Capital Expenditure: Maintenance Capex = 0
IF Capital Expenditure <= Growth Capex: Maintenance Capex = Capital Expenditure - Growth Capex

Owners Earnings

Owner's Earnings = Operating Cash Flow + Maintenance Capex

Owners Earnings Per Share

Owner's Earnings Per Share = Owner's Earnings / Weighted Av. Shares Out. (Diluted)

Examples

Example 1 - Display the most recent year of Owners Earnings data

=SF("AAPL", "owners")

Example 2 - Display several selected metrics, specific year

=SF("AAPL", "owners", "date&growthCapex&ownersEarnings", "2022")

Example 3 - Display all metrics for a range of years with options selected (no header and reversed)

=SF("AAPL", "owners", "all", "2019-2023", "NH&-")