1. Catalog
  2. Finance
  3. FCFF vs FCFE - Valuation Excel Model
Valuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel Model
  • Valuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel Model
Originally published: 11/07/2016 13:07
Last version published: 02/02/2018 14:49
Publication number: ELQ-43096-2
View all versions & Certificate
certified

Valuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel Model

Excel Valuation model that reconciles FCFF (Free Cash Flow to the Firm) and FCFE (Free Cash Flow to Equity)

Prof. Aswath Damodaranby Prof. Aswath Damodaran
Professor at NYU Stern School of BusinessFollow 1,062
NYU Stern School of Businesswith NYU Stern School of Business
An Education in PossibleFollow 56
125 reviews7,872 views|Start the discussion!|Bookmark download for free
financevaluationfcfffcfereconcile
Description
User must define the following inputs:
- Earnings before interest and taxes
- Expected growth for next 5 years
-Expected growth after year 5
-Tax rate
-Debt ratio for the firm
-Cost of equity
- Pre-tax cost of debt
- Return on capital in high growth
- Return on capital in stable growth

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Outputs:
- Value of Firm
- Value of Equity
- Value of Debt
- Cost of Equity
- Pre-tax Cost of Debt
- After-tax Cost of Debt
- Cost of Capital


4.6 / 5 (125 votes)

please wait...