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.

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 >> 
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 >> 
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 >> 
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 >>

Investing
Evaluating A Statement Of Cash Flows
The metrics for the Statement of Cash Flows is best viewed over time. 
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. 
Investing
Evaluate Stock Price With ReverseEngineering DCF
This is a more accurate method to use when trying to find a target price for a stock. 
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. 
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. 
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. 
Small Business
Understanding Cash Flow
Learn about the different types of cash flows and the importance for businesses to properly manage their cash flows.

Discounted Cash Flow (DCF)
Discounted cash flow (DCF) is a valuation method used to estimate ... 
Discounted AfterTax Cash Flow
An approach to valuing an investment that looks at the amount ... 
Free Cash Flow Yield
An overall return evaluation ratio of a stock, which standardizes ... 
Discounting
Discounting is the process of determining the present value of ... 
Cash Flow From Operating Activities (CFO)
Cash Flow From Operating Activities (CFO) is an accounting item ... 
Cash Flow
The net amount of cash and cashequivalents moving into and out ...