Excel Formula Reference: Income Statement

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

Yahoo Finance generally provides the past 4 years of reported annual data and the last 5 quarters of quarterly data.

Excel Price Feed makes it very easy to get this data into your spreadsheet via simple Excel formulas, for annual, quarterly and trailing twelve months (TTM) data.

Yahoo Finance Excel Formulas Income Statement

Annual Income Statement Formulas

All these formulas require both a stock ticker and reporting year, for example: =EPF.Yahoo.AnnualRevenue("GOOG",2021)

Please download our example spreadsheet and select the "Financials - Income Statement" tab for an example of how these formulas are used.

Yahoo Finance Excel Formulas Annual Income Statement

Formula	Description
`EPF.Yahoo.AnnualRevenue`	Annual Total Revenue
`EPF.Yahoo.AnnualCostOfRevenue`	Annual Cost of Revenue
`EPF.Yahoo.AnnualGrossProfit`	Annual Gross Profit
`EPF.Yahoo.AnnualResearchAndDevelopmentExpense`	Annual Research and Development Expense (R&D)
`EPF.Yahoo.AnnualSellingGeneralAndAdministrationExpense`	Annual Selling, general and administration expenses
`EPF.Yahoo.AnnualSellingAndMarketingExpense`	Annual Selling and Marketing Expenses
`EPF.Yahoo.AnnualTotalOperatingExpenses`	Annual Total Operating Expenses
`EPF.Yahoo.AnnualOperatingIncome`	Annual Total Operating Income
`EPF.Yahoo.AnnualSpecialIncomeCharges`	Annual Special Income Charges
`EPF.Yahoo.AnnualRestructuringAndMergersAcquisition`	Annual Restructuring & Mergers Acquisition
`EPF.Yahoo.AnnualImpairmentOfCapitalAssets`	Annual Impairment of Capital Assets
`EPF.Yahoo.AnnualWriteOff`	Annual Write Off
`EPF.Yahoo.AnnualOtherSpecialIncomeCharges`	Annual Other Special Charges
`EPF.Yahoo.AnnualInterestExpense`	Annual Interest Expense
`EPF.Yahoo.AnnualTotalOtherIncomeExpenseNet`	Annual Total Other Income / Expenses net
`EPF.Yahoo.AnnualPretaxIncome`	Annual Pre-tax Income / Income before tax
`EPF.Yahoo.AnnualTaxProvision`	Annual Tax Provision / Expense
`EPF.Yahoo.AnnualIncomeContinuingOperations`	Annual Income from Continuing Operations
`EPF.Yahoo.AnnualBasicEPS`	Annual Basic EPS
`EPF.Yahoo.AnnualDilutedEPS`	Annual Diluted EPS
`EPF.Yahoo.AnnualBasicSharesOutstanding`	Annual Basic Shares Outstanding
`EPF.Yahoo.AnnualDilutedSharesOutstanding`	Annual Diluted Shares Outstanding
`EPF.Yahoo.AnnualEBITDA`	Annual EBITDA
`EPF.Yahoo.AnnualEBITDANormalized`	Annual Normalized EBITDA

Quarterly Income Statement Formulas

All these formulas require both a stock ticker and reporting quarter, for example: =EPF.Yahoo.QuarterlyRevenue("AAPL",0)

The quarter parameter corresponds to the requested quarter, with the most recent quarter being 0, the previous quarter being 1 and so on. Yahoo Finance generally provides upto 5 quarters of historic data so the usual maximum quarter value is 4.

Please download our example spreadsheet and select the "Financials - Income Statement" tab for an example of how these formulas are used.

Yahoo Finance Excel Formulas Quarterly Income Statement

Please note due the dynamic nature of these formulas, each time the sheet is refreshed if new quarterly results are available these will be automatically populated in the relevant cells.

Formula	Description
`EPF.Yahoo.QuarterlyDate`	Quarter End Date
`EPF.Yahoo.QuarterlyRevenue`	Quarterly Total Revenue
`EPF.Yahoo.QuarterlyCostOfRevenue`	Quarterly Cost of Revenue
`EPF.Yahoo.QuarterlyGrossProfit`	Quarterly Gross Profit
`EPF.Yahoo.QuarterlyResearchAndDevelopmentExpense`	Quarterly Research and Development Expense (R&D)
`EPF.Yahoo.QuarterlyRestructuringAndMergersAcquisition`	Quarterly Restructuring And Mergers Acquisition
`EPF.Yahoo.QuarterlySellingGeneralAndAdministrationExpense`	Quarterly Selling, General and Administration Expenses
`EPF.Yahoo.QuarterlySpecialIncomeCharges`	Quarterly Special Income Charges
`EPF.Yahoo.QuarterlySellingAndMarketingExpense`	Quarterly Selling and Marketing Expenses
`EPF.Yahoo.QuarterlyTotalOperatingExpenses`	Quarterly Total Operating Expenses
`EPF.Yahoo.QuarterlyWriteOff`	Quarterly Write Off
`EPF.Yahoo.QuarterlyOperatingIncome`	Quarterly Total Operating Income
`EPF.Yahoo.QuarterlyOtherSpecialIncomeCharges`	Quarterly Other Special Income Charges
`EPF.Yahoo.QuarterlyImpairmentOfCapitalAssets`	Quarterly Impairment Of Capital Assets
`EPF.Yahoo.QuarterlyInterestExpense`	Quarterly Interest Expense
`EPF.Yahoo.QuarterlyTotalOtherIncomeExpenseNet`	Quarterly Total Other Income / Expenses Net
`EPF.Yahoo.QuarterlyPretaxIncome`	Quarterly Pre-tax Income / Income Before Tax
`EPF.Yahoo.QuarterlyTaxProvision`	Quarterly Tax Provision / Expense
`EPF.Yahoo.QuarterlyIncomeContinuingOperations`	Quarterly Income from Continuing Operations
`EPF.Yahoo.QuarterlyBasicEPS`	Quarterly Basic EPS
`EPF.Yahoo.QuarterlyDilutedEPS`	Quarterly Diluted EPS
`EPF.Yahoo.QuarterlyBasicAverageShares`	Quarterly Basic average shares
`EPF.Yahoo.QuarterlyDilutedAverageShares`	Quarterly Diluted average shares
`EPF.Yahoo.QuarterlyEBITDA`	Quarterly EBITDA
`EPF.Yahoo.QuarterlyNormalizedEBITDA`	Quarterly Normalized EBITDA

Trailing Twelve Months (TTM) Income Statement Formulas

All these formulas require just a stock ticker, for example: =EPF.Yahoo.TTMRevenue("AAPL")

Please download our example spreadsheet and select the "Financials - Income Statement" tab for an example of how these formulas are used.

Yahoo Finance Excel Formulas TTM Income Statement

Formula	Description
`EPF.Yahoo.TTMRevenue`	Trailing 12 Months (TTM) Total Revenue
`EPF.Yahoo.TTMCostOfRevenue`	Trailing 12 Months (TTM) Cost of Revenue
`EPF.Yahoo.TTMGrossProfit`	Trailing 12 Months (TTM) Gross Profit
`EPF.Yahoo.TTMOperatingExpense`	Trailing 12 Months (TTM) Total operating expenses
`EPF.Yahoo.TTMResearchAndDevelopment`	Trailing 12 Months (TTM) Research and development expense (R&D)
`EPF.Yahoo.TTMRestructuringAndMergersAcquisition`	Trailing 12 Months (TTM) Restructuring And Mergers Acquisition
`EPF.Yahoo.TTMSellingGeneralAndAdministration`	Trailing 12 Months (TTM) Selling, general and administration expenses
`EPF.Yahoo.TTMSpecialIncomeCharges`	Trailing 12 Months (TTM) Special Income Charges
`EPF.Yahoo.TTMSellingAndMarketingExpense`	Trailing 12 Months (TTM) Selling and Marketing Expenses
`EPF.Yahoo.TTMOperatingIncome`	Trailing 12 Months (TTM) Total Operating Income
`EPF.Yahoo.TTMOtherIncomeExpense`	Trailing 12 Months (TTM) Total Other Income / Expenses Net
`EPF.Yahoo.TTMOtherSpecialIncomeCharges`	Trailing 12 Months (TTM) Other Special Income Charges
`EPF.Yahoo.TTMPretaxIncome`	Trailing 12 Months (TTM) Pre-tax income / Income Before Tax
`EPF.Yahoo.TTMTaxProvision`	Trailing 12 Months (TTM) Tax Provision / Expense
`EPF.Yahoo.TTMWriteOff`	Trailing 12 Months (TTM) Write Off
`EPF.Yahoo.TTMNetIncome`	Trailing 12 Months (TTM) Net Income
`EPF.Yahoo.TTMNetIncomeContinuousOperations`	Trailing 12 Months (TTM) Income from Continuing Operations.
`EPF.Yahoo.TTMBasicEPS`	Trailing 12 Months (TTM) Basic EPS
`EPF.Yahoo.TTMDilutedEPS`	Trailing 12 Months (TTM) Diluted EPS
`EPF.Yahoo.TTMBasicAverageShares`	Trailing 12 Months (TTM) Basic Average Shares
`EPF.Yahoo.TTMDilutedAverageShares`	Trailing 12 Months (TTM) Diluted Average Shares
`EPF.Yahoo.TTMImpairmentOfCapitalAssets`	Trailing 12 Months (TTM) Impairment Of Capital Assets
`EPF.Yahoo.TTMInterestExpense`	Trailing 12 Months (TTM) Interest Expense
`EPF.Yahoo.TTMEBITDA`	Trailing 12 Months (TTM) EBITDA
`EPF.Yahoo.TTMNormalizedEBITDA`	Trailing 12 Months (TTM) Normalized EBITDA

Getting Started

General Formulas

Technical Analysis Toolkit

Federal Reserve Economic Data(FRED)

Yahoo Finance

IG Index / IG Markets

EODHistoricalData.com

Nasdaq Data Link

Excel Formula Reference: Income Statement

Annual Income Statement Formulas

Quarterly Income Statement Formulas

Trailing Twelve Months (TTM) Income Statement Formulas

Federal Reserve Economic Data
(FRED)