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. Are taxes calculated in operating cash flow?

    Learn how taxes are involved with the calculations for operating cash flow, and find out about the importance of operational ... 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 >>
  5. What is the difference between the operating cash flow ratio and operating cash flow ...

    Find out more about the operating cash flow ratio, the operating cash flow margin, how to calculate these ratios and the ... Read Answer >>
  6. What is the difference between cash flow and fund flow?

    See how cash flow and fund flow differ from each other, and why fund flow can be used very differently by accountants and ... Read Answer >>
Related Articles
  1. Investing

    Top 3 Pitfalls Of Discounted Cash Flow Analysis

    The DCF method can be difficult to apply to real-life valuations. Find out where it comes up short.
  2. Investing

    Evaluating A Statement Of Cash Flows

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

    Analyze Cash Flow The Easy Way

    Find out how to analyze the way a company spends its money to determine whether there will be any money left for investors.
  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

    Free Cash Flow Yield: A Fundamental Indicator

    Free cash flow can measure a business’s performance as if you’re looking at its net income line.
  7. Tech

    Cash Flow Is King: How to Keep it Running

    Why is cash flow so important, and what steps can a business take to improve it?
  8. Investing

    Cash Flow Statement and Financial Health

    A cash flow statement records the amounts of cash and cash equivalents entering and leaving a company.
RELATED TERMS
  1. Price to Free Cash Flow

    A valuation metric that compares a company's market price to ...
  2. Free Cash Flow Yield

    An overall return evaluation ratio of a stock, which standardizes ...
  3. Discounted After-Tax Cash Flow

    An approach to valuing an investment that looks at the amount ...
  4. Operating Cash Flow - OCF

    Operating Cash Flow (or OCF) is a measure of the amount of cash ...
  5. Operating Cash Flow Margin

    A measure of the money a company generates from its core operations ...
  6. Cash Flow Statement

    One of the quarterly financial reports any publicly traded company ...
Hot Definitions
  1. Retirement Planning

    Retirement planning is the process of determining retirement income goals and the actions and decisions necessary to achieve ...
  2. Drawdown

    The peak-to-trough decline during a specific record period of an investment, fund or commodity. A drawdown is usually quoted ...
  3. Inverse Transaction

    A transaction that can cancel out a forward contract that has the same value date.
  4. Redemption

    The return of an investor's principal in a fixed income security, such as a preferred stock or bond; or the sale of units ...
  5. Solvency

    The ability of a company to meet its long-term financial obligations. Solvency is essential to staying in business, but a ...
  6. Dilution

    A reduction in the ownership percentage of a share of stock caused by the issuance of new stock. Dilution can also occur ...
Trading Center