FCFF Valuation Model in Excel

The discounted cash flow model is the most advocated model for valuing a stock. Under this model, an analyst will estimate the future cash flows for the company, and discount it with the appropriate discount rate.

Traditionally, analysts have used dividends as the proxy for cash flows, hence the dividend discount model. However, the problem with dividends is that it does not fully reflect the cash flow earned by the firm.

The two new cash flow measures used to value a firm are Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity (FCFE).

FCFF represents the free cash flow available to both equity and debt holders, while FCFE represents free cash flow available for only equity holders.

A firm can be valued by estimating the Free Cash Flow to Firm and discounting them by the Weighted Average Cost of Capital (WACC). The value we arrive at will represent the value of the entire firm We can then deduct the value of debt to arrive at the value of equity alone.

FCFF valuation is more suitable compared to FCFE when the company has high leverage, and/or negative FCFE. FCFF is also suitable for firms that have a tendency to frequently change their degree of financial leverage.

FCFF can be calculated from Net Income using the following formula:

FCFF from Net Income = Net Income + Non-cash Charges + (Interest Expense * (1-tax rate)) – Fixed Capital Investment – Working Capital Investment

One can easily extract the information required to value a frim using FCFF from the company’s financial statements and build a FCFF valuation model using Excel. Below you can find a sample excel model for FCFF valuation (By Aswath Damodaran). You can download it and adapt it to your requirements to value a company.

FCFF Valuation Model Excel Sheet

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.