A:

It's relatively simple and straightforward to calculate free or operating cash flow in Microsoft Excel; each only needs a few cell data entries and a short formula. Calculating discounted cash flow (DCF) is a little more involved and requires specific functions to calculate the present and future value of assets.

Operating Cash Flow

Operating cash flow, which tracks the net cash flow from business operations, can be found on a company's cash flow statement. In Excel, add a value in different cells for each way in which the company receives revenue from operations (such as cash receipts) and subtract their sum from the sum of net cash outflows (such as wages or material).

Free Cash Flow

Free cash flow (FCF) is calculated as earnings before interest and taxes (EBIT) multiplied by (1 - tax rate), plus depreciation and amortization and less capital expenditures. All of these figures can be found in a company's financial statement.

An alternative method of figuring FCF is to subtract all capital expenditures from the operating cash flow from above.

Discounted Cash Flow

To find a company's DCF, you should first find its normal cash flows and its discount rate. Cash flows can be the same as the FCF from above or any flow from which a hypothetical investor could be paid (dividends, repayments, interest). The discount rate should be equal to the hypothetical investor's required rate of return.

DCF models normally span five or more years, so you need annual cash flow for at least five years. These should be entered separately into different cells and multiplied by the discount rate. This returns the discount factor for each year at (1 + discount rate) * (years from present). Divide the annual cash flow by the discount factor to find a company's DCF.

For example, a company with cash flows equal to $100 and a discount rate of 10% has a discount factor of 1.1 and a DCF of $90.91 for the first year.

RELATED FAQS
  1. What is the formula for calculating free cash flow?

    FCF is the total amount of money that could be returned to shareholders if no future growth is realized. It is the cash a ... Read Answer >>
  2. Free & operating cash flows: What's the Difference?

    Learn the difference between free cash flow and operating cash flow. Explore how analysts use earnings and cash flow to evaluate ... Read Answer >>
  3. Why would you take DCF into account rather than simply projecting future revenues?

    Learn what discounted cash flow analysis is and why it is considered a better equity valuation tool than simply projecting ... Read Answer >>
  4. How is cash flow from operating activities calculated?

    Discover why cash flow from operating activities is significant to businesses, and learn the direct and indirect methods ... Read Answer >>
Related Articles
  1. Investing

    Evaluating A Statement Of Cash Flows

    The metrics for the Statement of Cash Flows is best viewed over time.
  2. Investing

    Fundamental Case Study: Is Amazon's Cash Flow Actually Solid? (AMZN)

    Review Amazon's cash flow situation, including its free cash flow yield, operating cash flow from organic growth and cash flow from debt financing.
  3. Investing

    Evaluate Stock Price With Reverse-Engineering DCF

    This is a more accurate method to use when trying to find a target price for a stock.
  4. Investing

    Free Cash Flow Yield: The Best Fundamental Indicator

    Cash in the bank is what every company strives to achieve. Find out how to determine how much a company is generating and keeping.
  5. Investing

    Free Cash Flow: Free, But Not Always Easy

    Free cash flow is a great gauge of corporate health, but it's not immune to accounting trickery.
  6. Investing

    Cash Flow From Investing

    Cash flow analysis is a critical process for both companies and investors. Find out what you need to know about it.
  7. Small Business

    Understanding Cash Flow

    Learn about the different types of cash flows and the importance for businesses to properly manage their cash flows.
RELATED TERMS
  1. Discounted Cash Flow (DCF)

    Discounted cash flow (DCF) is a valuation method used to estimate ...
  2. Discounted After-Tax Cash Flow

    An approach to valuing an investment that looks at the amount ...
  3. Free Cash Flow Yield

    An overall return evaluation ratio of a stock, which standardizes ...
  4. Discounting

    Discounting is the process of determining the present value of ...
  5. Cash Flow From Operating Activities (CFO)

    Cash Flow From Operating Activities (CFO) is an accounting item ...
  6. Cash Flow

    The net amount of cash and cash-equivalents moving into and out ...
Hot Definitions
  1. Bubble

    1. An economic cycle characterized by rapid expansion followed by a contraction. 2. A surge in equity prices, often more ...
  2. Swap

    A swap is a derivative contract through which two parties exchange financial instruments, such as interest rates, commodities, ...
  3. Yield Curve

    A yield curve is a line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but ...
  4. Gross Profit

    Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
  5. Risk Tolerance

    The degree of variability in investment returns that an individual is willing to withstand. Risk tolerance is an important ...
  6. Donchian Channels

    A moving average indicator developed by Richard Donchian. It plots the highest high and lowest low over the last period time ...
Trading Center