How do you forecast the free cash flows for a DCF valuation? (2024)

Last updated on Apr 9, 2024

  1. All
  2. Company Valuation

Powered by AI and the LinkedIn community

1

Understand the business

2

Project the revenue

3

Project the expenses

4

Project the capital expenditures and working capital

5

Calculate the free cash flow

6

Here’s what else to consider

Discounted cash flow (DCF) is a popular method to estimate the value of a company based on its future cash flows. To perform a DCF valuation, you need to forecast the free cash flows (FCF) of the company for a certain period, usually five to ten years. FCF is the cash that the company generates from its operations after deducting the capital expenditures and changes in working capital. Here are the main steps to forecast the FCF for a DCF valuation.

Top experts in this article

Selected by the community from 19 contributions. Learn more

How do you forecast the free cash flows for a DCF valuation? (1)

Earn a Community Top Voice badge

Add to collaborative articles to get recognized for your expertise on your profile. Learn more

  • How do you forecast the free cash flows for a DCF valuation? (3) How do you forecast the free cash flows for a DCF valuation? (4) 7

  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism…

    How do you forecast the free cash flows for a DCF valuation? (6) 4

  • Filipe Sandes Rocha Financial Markets | Quantitative Finance

    How do you forecast the free cash flows for a DCF valuation? (8) 1

How do you forecast the free cash flows for a DCF valuation? (9) How do you forecast the free cash flows for a DCF valuation? (10) How do you forecast the free cash flows for a DCF valuation? (11)

1 Understand the business

Before you start projecting the FCF, you need to understand the business model, the industry, and the competitive landscape of the company. This will help you identify the key drivers of revenue, costs, and investments, as well as the risks and opportunities that may affect the future performance. You should also review the historical financial statements and trends of the company to get a sense of its profitability, growth, and cash flow generation.

Add your perspective

Help others by sharing more (125 characters min.)

  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.
    • Report contribution

    In the Free Cash Flow (FCF) Model, the primary inputs include the cash flows, the discount rate, and the growth rate. The calculated intrinsic value is highly sensitive to assumptions about the discount rates and growth rates. The choice between a two-stage or three-stage DCF model hinges on the company's current growth phase.For companies in a mature phase, a two-stage DCF model is suitable. This model involves forecasting explicit cash flows for the initial stage and calculating a terminal value with the Gordon Growth Model for the second stage.For companies expected to transition through different growth phases, a three-stage DCF model is advisable. This approach includes an intermediary growth phase for a more nuanced forecast.

    Like

    How do you forecast the free cash flows for a DCF valuation? (20) 4

    Unhelpful
  • Filipe Sandes Rocha Financial Markets | Quantitative Finance
    • Report contribution

    Focus on the business and the big numbers, the drivers are there. Although it's important to be analyze the financial statements and business plan completely, one should not spend a big chunk of the project's time by going through the least relevant aspects.Understand the business as a whole, find out which are the most sensible numbers (maybe margins, CapEx or Working Capital, for example) and go through it. When these are well-understood and appropriately modeled, you might focus on other details.If a slight change on a business aspect vary the cash flows in 15%, why would you start with the line with a 1% impact? Remember of Pareto: 80% of the cash flows are concentrated on 20% of the numbers, and I'd say it is even less than twenty.

    Like

    How do you forecast the free cash flows for a DCF valuation? (29) 1

    Unhelpful
    • Report contribution

    Start by being fully aware of the nature of the company. This entails figuring out important sources of income, cost arrangements, and operational dynamics. Think about things like market trends, the level of competition, and any special features that might affect the company's cash flows.

    Like

    How do you forecast the free cash flows for a DCF valuation? (38) 1

    Unhelpful
    • Report contribution

    Importante ter a percepção de especialistas no setor e no modelo de negócio. Ajustando expectativas enviesadas por otimismo ou pessimismo. Entenda os modelos de receita, cadeia de distribuição e como está se comportando o mercado e a concorrência.

    Translated

    Like

    How do you forecast the free cash flows for a DCF valuation? (47) 1

    Unhelpful

Load more contributions

2 Project the revenue

The next step is to project the revenue of the company for each year of the forecast period. Depending on the availability and reliability of data, there are various methods to do this, such as using historical growth rates or industry averages, market share and market size estimates, customer segments and unit economics, or bottom-up or top-down approaches. It is important to select the method that best suits the nature and characteristics of the business, and to justify your assumptions and sources.

Add your perspective

Help others by sharing more (125 characters min.)

  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.
    • Report contribution

    There are generally two ways around revenue forecast.For most companies, revenue is simply a function of sales volume multiplied by price per unit of product/service. Hence, the first approach is a bottom-up forecast of potential unit sales volume and price trajectory. For volume, observe past trends and see if there is a pattern, taking reference from industry projections if any. For the unit price, one can either make an estimate based on the company's pricing strategy (for e.g., premiumization), or incorporating the level of pricing needed to stay relevant in a competitive market.On the other hand, another common approach is to estimate the overall industry revenue, and assuming the % that the company can capture over time.

    Like

    How do you forecast the free cash flows for a DCF valuation? (56) 2

    Unhelpful
    • Report contribution

    To forecast future revenue, use industry trends and historical financial data. Take into account elements like price tactics, market demand, and possible client base growth or reduction. Be reasonable and consider any outside influences that might affect sales.

    Like
    Unhelpful

Load more contributions

3 Project the expenses

After projecting the revenue, you need to project the expenses of the company for each year of the forecast period. These expenses include Cost of Goods Sold (COGS), Operating Expenses (OPEX), and Depreciation and Amortization (D&A). Estimate these expenses as a percentage of revenue, based on historical margins or industry benchmarks. Additionally, take into account any changes in the cost structure or efficiency that may affect the margins in the future.

Add your perspective

Help others by sharing more (125 characters min.)

    • Report contribution

    Project and estimate all pertinent operating expenditures, both variable and fixed. These expenses include COGS, Capex, and D&A. Take into account variables like production cost fluctuations, inflation, and any upcoming cost-cutting or efficiency-boosting projects. A thorough comprehension of cost drivers is essential for precise estimations.

    Like

    How do you forecast the free cash flows for a DCF valuation? (73) How do you forecast the free cash flows for a DCF valuation? (74) 3

    Unhelpful
  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.
    • Report contribution

    Generally the approach is to assume the % margin by observing historical trends and incorporating future outlook (for e.g., cost reduction), taking into account the important differences in margins across different divisions in the same company.Note that some companies have contracts that allow them to pass on costs to their customers, hence their margins would be relatively stable. However, in such cases, care should be taken about the lag effects of price adjustments.When faced with overly high margins compared to industry standards, question its sustainability and try to understand if the company deserves it (for e.g., due to a longstanding brand name). Understand that a wide margin can also be threatened in the face of competition.

    Like

    How do you forecast the free cash flows for a DCF valuation? (83) 2

    Unhelpful

Load more contributions

4 Project the capital expenditures and working capital

The next step is to project the capital expenditures (CAPEX) and working capital (WC) of the company for each year of the forecast period. CAPEX is the cash spent on acquiring or upgrading fixed assets, such as machinery, equipment, or buildings. WC is the difference between current assets and current liabilities, such as inventory, accounts receivable, and accounts payable. CAPEX and WC reflect the cash invested or released from the operations of the business.

You should estimate the CAPEX and WC as a percentage of revenue, based on historical ratios or industry standards. You should also consider any changes in the investment needs or working capital cycle that may affect the cash flow in the future.

Add your perspective

Help others by sharing more (125 characters min.)

  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.

    (edited)

    • Report contribution

    When we talk about capex, there are two kinds in general. The first one is maintenance capex, which is recurring in nature. Such capex is usually spent on maintaining the value of an asset as it depreciates over time, hence depreciation is a good proxy for the level of maintenance capex needed in a specific year.The second kind of capex is growth capex, aka expansionary capex. This capex is more lumpy in nature, and is often found in company active in M&A activities. Projecting this capex requires an understanding of the company's growth strategy. Oftentimes, company management would guide to a pre-determined amount of capex they intend to spend over several years, giving us a rough estimate of the annual spend.

    Like

    How do you forecast the free cash flows for a DCF valuation? (92) 2

    Unhelpful
    • Report contribution

    Estimate capital expenditures (CapEx) by figuring out which long-term assets will require future investments. Expenses for technology, property, plant, and equipment may fall under this category. Project changes in working capital should also take into consideration variations in current liabilities (such as accounts payable) and current assets (such as inventory, accounts receivable).

    Like
    Unhelpful

5 Calculate the free cash flow

To calculate the Free Cash Flow (FCF) of the company for each year of the forecast period, you must use the formula: Revenue - COGS - OPEX - Taxes + D&A - CAPEX - Change in WC. Additionally, you should calculate the tax rate and effective tax rate of the company using historical data or statutory rates. The effective tax rate is calculated by dividing actual tax paid by earnings before tax (EBT). After following these steps, you can forecast the FCF for a DCF valuation. However, you should be mindful of the limitations and uncertainties associated with this approach, such as sensitivity to changes in assumptions and inputs, difficulty predicting future performance and cash flow, need to estimate a terminal value or growth rate beyond the forecast period, and need to discount the FCF by an appropriate discount rate or cost of capital.

Add your perspective

Help others by sharing more (125 characters min.)

    • Report contribution

    Operating Cash Flow (OCF) less Capital Expenditures is the formula for calculating Free Cash Flow (FCF). The general expression for the formula is FCF = OCF - CapEx. For consistency, make sure that OCF and CapEx are taken into account annually. Net income can be used to calculate OCF after accounting for changes in working capital and non-cash expenses.

    Like

    How do you forecast the free cash flows for a DCF valuation? (109) How do you forecast the free cash flows for a DCF valuation? (110) 7

    Unhelpful
  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.
    • Report contribution

    There are two types of FCF: FCFF and FCFE.For the former, since it is FCF to the firm where the interests of both equity and debt holders are considered, we have to discount it back to the present value using the WACC. If you are valuing a stock's value, there is an additional step where you have to deduct the value of the firm attributable to non-common-equity holders.I prefer the FCFE approach in valuing stocks, where we apply the cost of equity as a discount rate to the cash flows to arrive at a present value that when divided by the number of shares outstanding, represents the theoretical fair value of the stock.For a longer term forecast, we tend to assume normalized cash flows where mostly maintenance capex is considered.

    Like
    Unhelpful

6 Here’s what else to consider

This is a space to share examples, stories, or insights that don’t fit into any of the previous sections. What else would you like to add?

Add your perspective

Help others by sharing more (125 characters min.)

    • Report contribution

    Forecasting free cash flows for a DCF valuation involves, in a summarized manner:Define Revenue Drivers and Assumptions:Identify revenue drivers and establish realistic assumptions.Understand the Market:Analyze market trends, competition, and opportunities.Financial Projection and Integration:Develop integrated financial projections for income statements, balance sheets, and cash flows.Risk Management:Recognize and quantify risks, developing sensitivity scenarios.Regular Review and Update:Establish regular reviews to update forecasts based on new information and market changes.

    Like
    Unhelpful
  • Jia Ding Chen, CFA Real estate professional by education, equity analyst by training, creating impactful stories in financial journalism by passion.
    • Report contribution

    There are times when we try to calculate the terminal value, we cannot do so reasonably because the final year's FCF is negative. In this case, we can extend our explicit forecast period to a year when the subject company turns FCF-positive, then calculate a terminal value based on it. If you are calculating a terminal value based on a perpetual growth rate, the FCF often has to be a normalized one.When conducting a multi-stage DCF, it is important to note that a company's risk profile throughout the different stages is likely going to be different. For e.g., investors might require a higher rate of return (cost of equity) in the initial phase, while as the company matures, the required rate of return could fall in tandem with risk.

    Like
    Unhelpful

Company Valuation How do you forecast the free cash flows for a DCF valuation? (135)

Company Valuation

+ Follow

Rate this article

We created this article with the help of AI. What do you think of it?

It’s great It’s not so great

Thanks for your feedback

Your feedback is private. Like or react to bring the conversation to your network.

Tell us more

Report this article

More articles on Company Valuation

No more previous content

  • What are some best practices or tips for using terminal value in your company valuation? 2 contributions
  • What are the main challenges of using comparable transactions in emerging markets? 5 contributions
  • How do you find and access reliable data sources for comparable transactions? 5 contributions
  • How do you use market multiples to assess the reasonableness of a valuation range or offer price? 6 contributions

No more next content

See all

More relevant reading

  • Investment Banking What are the most effective ways to forecast cash flows in IB?
  • Investment Banking What are the most common assumptions in DCF analysis?
  • Financial Management How can you use multiples in a discounted cash flow analysis?

Help improve contributions

Mark contributions as unhelpful if you find them irrelevant or not valuable to the article. This feedback is private to you and won’t be shared publicly.

Contribution hidden for you

This feedback is never shared publicly, we’ll use it to show better contributions to everyone.

Are you sure you want to delete your contribution?

Are you sure you want to delete your reply?

How do you forecast the free cash flows for a DCF valuation? (2024)

FAQs

How do you forecast the free cash flows for a DCF valuation? ›

To calculate the Free Cash Flow (FCF) of the company for each year of the forecast period, you must use the formula: Revenue - COGS - OPEX - Taxes + D&A - CAPEX - Change in WC. Additionally, you should calculate the tax rate and effective tax rate of the company using historical data or statutory rates.

How do you calculate cash flow for DCF? ›

The discounted cash flow (DCF) formula is equal to the sum of the cash flow in each period divided by one plus the discount rate (WACC) raised to the power of the period number.

What is the DCF model of free cash flow? ›

A DCF model is a specific type of financial modeling tool used to value a business. DCF stands for Discounted Cash Flow, so a DCF model is simply a forecast of a company's unlevered free cash flow discounted back to today's value, which is called the Net Present Value (NPV).

What is the formula for free cash flow forecast? ›

Free Cash Flow = Net income + Depreciation/Amortization – Change in Working Capital – Capital Expenditure. Operating Cash Flow = Operating Income + Depreciation – Taxes + Change in Working Capital. Cash Flow Forecast = Beginning Cash + Projected Inflows – Projected Outflows = Ending Cash.

How do you calculate free cash flow valuation? ›

FCFE = CFO – FCInv + Net borrowing. FCFF can also be calculated from EBIT or EBITDA: FCFF = EBIT(1 – Tax rate) + Dep – FCInv – WCInv. FCFF = EBITDA(1 – Tax rate) + Dep(Tax rate) – FCInv – WCInv.

How do you forecast free cash flow for DCF? ›

To calculate the Free Cash Flow (FCF) of the company for each year of the forecast period, you must use the formula: Revenue - COGS - OPEX - Taxes + D&A - CAPEX - Change in WC. Additionally, you should calculate the tax rate and effective tax rate of the company using historical data or statutory rates.

How to forecast cash flow? ›

How to forecast your cash flow
  1. Forecast your income or sales. First, decide on a period that you want to forecast. ...
  2. Estimate cash inflows. ...
  3. Estimate cash outflows and expenses. ...
  4. Compile the estimates into your cash flow forecast. ...
  5. Review your estimated cash flows against the actual.

How long does it take to forecast DCF? ›

The 3-statement models that support a DCF are usually annual models that forecast about 5-10 years into the future. However, when valuing businesses, we usually assume they are a going concern.

How do you forecast free cash flow to equity? ›

FCFE Formula
  1. FCFE = Net Income + D&A – Change in NWC – Capex + Net Borrowing. ...
  2. Net Borrowing = Debt Borrowing – Debt Paydown. ...
  3. FCFE = Cash from Operations (CFO) – Capex + Net Borrowing. ...
  4. FCFE = EBITDA – Interest – Taxes – Change in NWC – Capex + Net Borrowing.
Feb 28, 2024

What is the FCF method of valuation? ›

Free cash flow (FCF) is a key metric for evaluating the financial performance and value of a company. It represents the amount of cash that a company generates after deducting the capital expenditures required to maintain or expand its operations.

Why unlevered free cash flow in DCF? ›

Why is Unlevered Free Cash Flow Used? Unlevered free cash flow is used to remove the impact of capital structure on a firm's value and to make companies more comparable. Its principal application is in valuation, where a discounted cash flow (DCF) model is built to determine the net present value (NPV) of a business.

How to calculate free cash flow in Excel? ›

Enter "Total Cash Flow From Operating Activities" into cell A3, "Capital Expenditures" into cell A4, and "Free Cash Flow" into cell A5. Then, enter "=80670000000" into cell B3 and "=7310000000" into cell B4. To calculate FCF, enter the formula "=B3-B4" into cell B5. There you go.

How do you calculate the cash flow? ›

How to Calculate Net Cash Flow
  1. Net Cash-Flow = Total Cash Inflows – Total Cash Outflows.
  2. Net Cash Flow = Operating Cash Flow + Cash Flow from Financial Activities (Net) + Cash Flow from Investing Activities (Net)
  3. Operating Cash Flow = Net Income + Non-Cash Expenses – Change in Working Capital.
Feb 16, 2023

How do you calculate levered free cash flow DCF? ›

The LFCF formula is as follows:
  1. Levered free cash flow = earned income before interest, taxes, depreciation and amortization - change in net working capital - capital expenditures - mandatory debt payments. ...
  2. LFCF = EBITDA - change in net working capital - CAPEX - mandatory debt payments. ...
  3. Year 2.
  4. EBITDA. ...
  5. CAPEX. ...
  6. Working capital.

How do you calculate DCF factor? ›

For example, to calculate discount factor for a cash flow one year in the future, you could simply divide 1 by the interest rate plus 1. For an interest rate of 5%, the discount factor would be 1 divided by 1.05, or 95%.

How do you calculate cash flow for NPV? ›

NPV formula for an investment with a single cash flow

Here's the NPV formula for a one-year project with a single cash flow:NPV = [cash flow / (1+i)^t] - initial investmentIn this formula, "i" is the discount rate, and "t" is the number of time periods.

Top Articles
Latest Posts
Article information

Author: Francesca Jacobs Ret

Last Updated:

Views: 6080

Rating: 4.8 / 5 (68 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Francesca Jacobs Ret

Birthday: 1996-12-09

Address: Apt. 141 1406 Mitch Summit, New Teganshire, UT 82655-0699

Phone: +2296092334654

Job: Technology Architect

Hobby: Snowboarding, Scouting, Foreign language learning, Dowsing, Baton twirling, Sculpting, Cabaret

Introduction: My name is Francesca Jacobs Ret, I am a innocent, super, beautiful, charming, lucky, gentle, clever person who loves writing and wants to share my knowledge and understanding with you.