• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 11/07/2016 13:07
Last version published: 02/02/2018 14:49
Publication number: ELQ-43096-2
View all versions & Certificate

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)

by Prof. Aswath Damodaran
Professor at NYU Stern School of BusinessFollow 883

with NYU Stern School of Business
An Education in PossibleFollow 36

114 reviews7,068 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

Reviews

• • 
    4.6 / 5 (114 votes)

    • 71%
    • 23%
    • 4%
    • 2%
    • 1%
  • Rate this Downloadable Best Practice
    

    Write a review

• WalidD(last updated: 03/02/2021 12:22)
  
• Deepak Sharma923(last updated: 25/01/2021 09:18)
  
• Adib Basbous(last updated: 10/09/2020 07:54)
  
• Soban AHMAD(last updated: 26/07/2020 03:22)
  
• Bobby67(last updated: 07/05/2020 08:54)
  
• Siddhartha(last updated: 03/05/2020 10:27)
  
• Haitham Abdel-Nabi(last updated: 08/04/2020 20:03)
  
• David Chousa(last updated: 07/04/2020 04:22)
  
• Osareme Ekhator(last updated: 30/03/2020 10:53)
  
• Yashraj Pandey(last updated: 26/03/2020 09:03)
  
• rssida(last updated: 19/02/2020 07:41)
  
• Vignesh V(last updated: 22/01/2020 16:00)
  
• Asher(last updated: 22/01/2020 14:19)
  
• Joe Bou Onk(last updated: 18/01/2020 11:30)
  
• vikas gupta73(last updated: 30/12/2019 13:54)
  
• Rati Phutkaradze(last updated: 25/11/2019 11:47)
  
• Valeri Mirchev(last updated: 15/11/2019 14:36)
  
• Ato Wilberforce(last updated: 29/10/2019 23:49)
  
• Nathan Ronce(last updated: 24/10/2019 22:04)
  
• Mariam Muhammed(last updated: 17/10/2019 13:46)
  
• Dumisani Ngwenya(last updated: 30/09/2019 13:35)
  
• Michael Ross348(last updated: 25/09/2019 02:20)
  
• Ihsovanny HB(last updated: 11/09/2019 20:42)
  
• Ali Syahbana N. Siregar(last updated: 03/09/2019 08:02)
  
• Robert Reichelt(last updated: 12/08/2019 01:37)
  
• Douglas Estrada(last updated: 28/07/2019 09:00)
  
• Chandrasekar Raghavan(last updated: 16/07/2019 16:10)
  
• Edvinas Navickas(last updated: 01/07/2019 19:50)
  
• mcarthurjr(last updated: 24/06/2019 00:52)
  
• Sunny Joe(last updated: 22/06/2019 23:23)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded