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

Finance Train Premium
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
I WANT TO JOIN
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.

Saylient AI Logo

Accelerate your finance career with cutting-edge data skills.

Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.