• 

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 BusinessFollow 342

70 reviews5,051 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

• Harsh Modi(last updated: 19/04/2019 06:27)
  
• Wchynn(last updated: 04/04/2019 21:52)
  
• Lin Giralt CMC(last updated: 31/03/2019 15:05)
  
• Pankti Desai(last updated: 23/03/2019 09:27)
  
• Model ME Financial Modelling Solutions(last updated: 22/03/2019 03:53)
  
• Sacred Ibis(last updated: 19/03/2019 14:46)
  
• Paul Motley(last updated: 11/03/2019 13:14)
  
• Munaf Thakur(last updated: 06/03/2019 08:12)
  
• Yiming Si(last updated: 27/02/2019 03:18)
  
• Kim Jichang(last updated: 24/02/2019 07:14)
  
• Deddy Koesrindartoto(last updated: 22/02/2019 10:00)
  
• 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)
  

People using this tool also downloaded