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

Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
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

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.