Excel Formula Reference: Income Statement

Click the Excel icon to download a sample spreadsheet with all Excel Price Feed Yahoo Finance stock formulas.

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.AnnualSellingAndMarketingExpense`	Selling and marketing expenses.
`EPF.Yahoo.AnnualTotalOperatingExpenses`	Total operating expenses.
`EPF.Yahoo.AnnualOperatingIncome`	Total operating income.
`EPF.Yahoo.AnnualSpecialIncomeCharges`	Special Income Charges.
`EPF.Yahoo.AnnualRestructuringAndMergersAcquisition`	Restructuring & Mergers Acquisition.
`EPF.Yahoo.AnnualImpairmentOfCapitalAssets`	Impairment of Capital Assets.
`EPF.Yahoo.AnnualWriteOff`	Write Off.
`EPF.Yahoo.AnnualOtherSpecialIncomeCharges`	Other Special Charges
`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.
`EPF.Yahoo.AnnualEBITDANormalized`	Normalized EBITDA.