Excel Formula Reference: Income Statement

  • 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 reported data.

Yahoo Finance Excel Formulas Income Statement

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.