• 

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 392

83 reviews5,350 views|Start the discussion!|Bookmark

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

• Helimah Kemboi(last updated: 06/06/2019 13:45)
  
• Rajesh Sah(last updated: 01/06/2019 12:17)
  
• Desmond N. Agboifo(last updated: 20/05/2019 20:00)
  
• Supreet Anurag Sahu(last updated: 20/05/2019 02:55)
  
• Ravi00(last updated: 17/05/2019 21:16)
  
• Sidharth Mohanty(last updated: 16/05/2019 07:10)
  
• Joe Nuttapong(last updated: 08/05/2019 12:39)
  
• Md. Nazrul Islam Bhuiyan(last updated: 07/05/2019 09:14)
  
• Lenin Terán(last updated: 03/05/2019 01:50)
  
• Hafizal Aziz(last updated: 30/04/2019 08:18)
  
• Durdana Nazarli(last updated: 28/04/2019 10:42)
  
• Presley Sakwa(last updated: 26/04/2019 12:52)
  
• EUNJU LEE(last updated: 25/04/2019 02:40)
  
• 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

People using this tool also downloaded