Discounted cash flow analysis is a powerful tool used by investors to estimate the value of a company's future cash flows. DCF takes into account the time value of money and can be used to calculate the present value of a company's expected cash flows and its terminal value. This information can help you assess a company's worth and make informed investment decisions.â€‹

## How to use discounted cash flow analysis

Discounted cash flow analysis is based on the principle that the value of a company or investment is the sum of all its future cash flows, discounted at a rate that reflects their riskiness. This discount rate is often referred to as the weighted average cost of capital (WACC)

There are two main uses for DCF analysis:

- To estimate the intrinsic value of a company or investment
- To compare the relative value of different companies or investments

Discounted cash flow analysis can estimate a company's intrinsic value by discounting its expected future cash flows back to the present using the companyâ€™s WACC.

The terminal value is the present value of a company's future cash flows beyond the forecast period. It is calculated using a growth rate that reflects the expected long-term growth of the company's cash flows.

DCF analysis can also be used to compare the relative value of different companies or investments. This is often done by calculating each investment's net present value (NPV), which is the present value of all expected cash flows minus the initial investment cost. The investment with the highest NPV is typically considered the most attractive.

## How to do a discounted cash flow analysis

There are two main steps in a DCF analysis: estimating a company's future cash flows and discounting them back to the present.

1. Estimating future cash flows

The first step in a DCF analysis is estimating a company's future cash flows. This typically involves creating a financial forecast for the company. A financial forecast estimates a company's future financial performance based on its past performance and current trends. It typically covers a period of 3-5 years.

Forecasting a company's future cash flows can be challenging, and there are many different ways to do it. The most important thing is to use assumptions that are realistic and supported by evidence.

2. Discounting cash flows back to the present

The second step in doing a DCF analysis is discounting those expected future cash flows back to the present. This is done using the company's WACC as the discount rate. The higher a company's WACC, the greater the discount rate that will be applied to its future cash flows, meaning a company with a higher WACC will have a lower intrinsic value than a company with a lower WACC.

To calculate a company's WACC, you will need to know its cost of debt and cost of equity. The cost of debt is the interest rate the company pays on its borrowings. The cost of equity is the return investors expect to earn on their investment.

Once you have estimated a company's future cash flows and calculated its WACC, you can discount those cash flows back to the present using the following formula:

Where *t* is the number of years into the future that the cash flow is expected to occur. For example, if a company is expected to generate $100 in cash flow next year and its WACC is 10%, the present value of that cash flow would be $90.91:

You can use the same formula to discount all of a company's expected future cash flows back to the present. The company's intrinsic value is the sum of all these discounted cash flows.

For example, letâ€™s assume a company expects to receive the following stream of cash flows over the next five years and has a 10% WACC.

To calculate the present value, we apply the previous formula to each year and sum the results.

Adding the discounted cash flow for each of the five years gives a present value of $549 dollars. This represents the current worth of the businessâ€™ expected cash flow. Remember, the further out a cash flow is received, the less it is worth in todayâ€™s dollars.

## Cash flow types in DCF analysis

The different types of cash flows that are considered in a DCF analysis include operating cash flow, investment cash flow, and financing cash flow.

- Operating cash flow:Â Operating cash flow is the cash that a company generates from its normal business operations. It includes items such as revenue, expenses, and working capital changes.
- Investment cash flow:Â Investment cash flow is the cash that a company generates (or uses) from its investments in property, plant, and equipment.
- Financing cash flow: Financing cash flow is the cash that a company generates (or uses) from its borrowings and equity issuances.

## How the discount rate is determined and how it affects the value of a business or investment

The discount rate is the interest rate used to discount a company's future cash flows back to the present. It is also known as the weighted average cost of capital (WACC).

The WACC reflects the overall riskiness of a company's cash flows. The higher the WACC, the greater the discount that will be applied to its future cash flows and the lower its intrinsic value.

To calculate a company's WACC, consider the companyâ€™s debt, equity, and preferred capital. Take the cost of each form of capital times the weight of that capital in the companyâ€™s overall capital structure and sum the pieces together.Â

Once you have estimated a company's future cash flows and calculated its WACC, you can discount those cash flows back to the present.

## How to use Excel to do a DCF analysis**Â **

One way to do a DCF analysis is to use Excel. Excel has a built-in function called the "discount function" that can be used to discount cash flows back to the present.

To use the discount function, you need to know the interest rate (i.e., the WACC) and the number of years into the future that the cash flow is expected to occur.

The syntax for the discount function is as follows:

=DISCOUNT(cash flow, interest rate, years)

For example, if a company is expected to generate $100 in cash flow one year from now, and its WACC is 10%, the present value of that cash flow would be $90.91:

=DISCOUNT($100, 10%, 1)

= $90.91

You can use the same formula to discount all of a company's expected future cash flows back to the present. The company's intrinsic value is the sum of all these discounted cash flows.

## Discounted cash flow analysis examples

Discounted cash flow analysis is a popular method for valuation in business and investing. It is often used to value companies, projects, and investments.

DCF analysis can be used to value a wide range of things, including:

- Companies: DCF analysis is commonly used to value public companies. The most important inputs in a DCF analysis of a public company are the discount rate and the expected cash flows.
- Projects: DCF analysis is also commonly used to value individual projects. Projects that are riskier typically receive a higher, risk-adjusted WACC.
- Investments: DCF analysis can also be used to value investments. Again, the riskier the investment, the higher the WACC used to discount the expected cash flows.