All these formulas require both a stock ticker and reporting year, for example: =EPF.Yahoo.AnnualRevenue("GOOG",2018)
Yahoo Finance generally provides the past 4 years of reported data.
Formula | Description |
---|---|
EPF.Yahoo.AnnualRevenue |
Total Revenue. |
EPF.Yahoo.AnnualCostOfRevenue |
Cost of Revenue. |
EPF.Yahoo.AnnualGrossProfit |
Gross Profit. |
EPF.Yahoo.AnnualResearchAndDevelopmentExpense |
Research and development expense (R&D). |
EPF.Yahoo.AnnualSellingGeneralAndAdministrationExpense |
Selling, general and administration expenses. |
EPF.Yahoo.AnnualTotalOperatingExpenses |
Total operating expenses. |
EPF.Yahoo.AnnualOperatingIncome |
Total operating income. |
EPF.Yahoo.AnnualInterestExpense |
Interest expense. |
EPF.Yahoo.AnnualTotalOtherIncomeExpenseNet |
Total other income / expenses net. |
EPF.Yahoo.AnnualPretaxIncome |
Pre-tax income / income before tax. |
EPF.Yahoo.AnnualTaxProvision |
Tax provision / expense. |
EPF.Yahoo.AnnualIncomeContinuingOperations |
Income from Continuing Operations. |
EPF.Yahoo.AnnualBasicEPS |
Basic EPS. |
EPF.Yahoo.AnnualDilutedEPS |
Diluted EPS. |
EPF.Yahoo.AnnualBasicSharesOutstanding |
Basic shares outstanding. |
EPF.Yahoo.AnnualDilutedSharesOutstanding |
Diluted shares outstanding. |
EPF.Yahoo.AnnualEBITDA |
EBITDA. |