Excel Formula Reference: Cash Flow

Excel Price Feed Quandl Example Spreadsheet Download
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.AnnualEarnings("MSFT",2019)

Yahoo Finance generally provides the past 4 years of reported data.

Click on a category below to view the formulas:


Cash Flows from Operating Activities

Yahoo Finance Excel Formulas Cash Flow From Operating Activities

Formula Description
EPF.Yahoo.AnnualTotalCashflowsFromOperatingActivities Total Cashflows from operating activities.
EPF.Yahoo.AnnualEarnings Net Income / Earnings.
EPF.Yahoo.AnnualDepreciationAndAmortization Depreciation & Amortization.
EPF.Yahoo.AnnualDeferredIncomeTax Deferred Income Tax.
EPF.Yahoo.AnnualStockBasedCompensation Stock based compensation.
EPF.Yahoo.AnnualOtherNonCashItems Other non cash items.
EPF.Yahoo.AnnualChangeInWorkingCapital Change in working capital.
EPF.Yahoo.AnnualAccountsReceivableChange Change in Accounts Receivable.
EPF.Yahoo.AnnualInventoryChange Change in Inventory.
EPF.Yahoo.AnnualAccountsPayableChange Change in Accounts Payable.


Cash Flows from Investing Activities

Yahoo Finance Excel Formulas Cash Flow From Investing Activities

Formula Description
EPF.Yahoo.AnnualTotalCashflowsFromInvestingActivities Total Cashflows from investing activities.
EPF.Yahoo.AnnualCapitalExpenditures Investments in property, plant and equipment / Capital Expenditures.
EPF.Yahoo.AnnualAcquisitions Acquisitions / purchases of businesses.
EPF.Yahoo.AnnualPurchasesOfInvestments Purchases of investments.
EPF.Yahoo.AnnualSalesOfInvestments Sales / maturities of investments.
EPF.Yahoo.AnnualOtherCashflowsFromInvestingActivities Other Cashflows from investing activities.


Cash Flows from Financing Activities

Yahoo Finance Excel Formulas Cash Flow From Financing Activities

Formula Description
EPF.Yahoo.AnnualTotalCashflowsFromFinancingActivities Total Cashflows from financing activities.
EPF.Yahoo.AnnualDebtRepayment Debt repayment.
EPF.Yahoo.AnnualCommonStockIssued Common stock issued.
EPF.Yahoo.AnnualCommonStockRepurchased Common stock repurchased.
EPF.Yahoo.AnnualDividendsPaid Total dividends paid.
EPF.Yahoo.AnnualOtherFinancingActivities Other financing activities.


Other Cash Flow Data

Yahoo Finance Excel Formulas Cash Flow Other Activities

Formula Description
EPF.Yahoo.AnnualChangeInCash Annual change in cash.
EPF.Yahoo.AnnualBeginningCashPosition Annual beginning cash position.
EPF.Yahoo.AnnualEndCashPosition Annual end cash position.
EPF.Yahoo.AnnualCapitalExpenditures Investments in property, plant and equipment / Capital Expenditures.
EPF.Yahoo.AnnualFreeCashFlow Free cash flow / other working capital.