• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• 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 Business

59 reviews4,681 views|Start the discussion!|Bookmark

fcfefcfffinancereconcilevaluation

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 business tool includes
1 Excel Model

Prof. Aswath Damodaran offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• Choi Tony(last updated: 19/02/2019 15:04)
  
• Frederick(last updated: 17/02/2019 12:00)
  
• Prakash Shirke(last updated: 15/02/2019 12:06)
  
• Nash M(last updated: 28/01/2019 14:55)
  
• Rich Ramey(last updated: 22/01/2019 00:11)
  
• Jerry Stecher(last updated: 11/01/2019 19:00)
  

  Valuation Model

  Outstanding
• Elaine Lu(last updated: 04/01/2019 02:19)
  
• ali rosadi(last updated: 26/12/2018 13:40)
  
• Norbert Labeja MBA,CFE, ACCA(last updated: 20/12/2018 08:00)
  
• Najam Us Saqib(last updated: 12/12/2018 10:49)
  
• Michał Bialowas(last updated: 30/11/2018 00:28)
  
• Mario van Essen(last updated: 28/11/2018 11:02)
  
• Alexander West(last updated: 10/11/2018 14:36)
  
• Ron Jnr(last updated: 08/11/2018 22:15)
  
• Santos Jd(last updated: 06/11/2018 03:59)
  
• Umesh Sahu(last updated: 05/11/2018 09:40)
  
• snadkarni(last updated: 04/11/2018 03:04)
  
• Md Tazul Islam(last updated: 30/10/2018 03:31)
  
• Jonah Jones(last updated: 27/10/2018 02:30)
  
• ANKUR VYAS(last updated: 17/10/2018 10:56)
  
• M Caroline(last updated: 17/10/2018 03:43)
  
• A S(last updated: 16/10/2018 11:10)
  
• Hardik Dave(last updated: 14/10/2018 16:36)
  
• Abdelrhman Alaa ,CMA Candidate(last updated: 12/10/2018 10:20)
  
• Miguel Olano(last updated: 09/10/2018 14:42)
  
• YG Park(last updated: 22/09/2018 16:01)
  
• Sandip Modha(last updated: 19/09/2018 20:42)
  
• Antonio Amati(last updated: 16/09/2018 08:45)
  
• amril faisal(last updated: 13/09/2018 09:21)
  
• Viet Can Thanh(last updated: 12/09/2018 06:42)
  

People using this tool also downloaded