• 

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

47 reviews4,976 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

• 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)
  
• Jason Rusli(last updated: 11/09/2018 08:27)
  
• WILLY CAMPOS(last updated: 07/09/2018 17:21)
  
• Dr. Michael Samonas(last updated: 06/09/2018 20:03)
  
• mdshrf shrf(last updated: 04/09/2018 03:38)
  
• Mohammad Almutairi(last updated: 01/09/2018 18:52)
  
• Nuryadin Usman(last updated: 22/08/2018 14:57)
  
• Luis Barbarulo(last updated: 20/08/2018 00:00)
  
• Arpan Bhattacharya(last updated: 10/08/2018 12:33)
  
• Giovanni Quaranta(last updated: 26/07/2018 07:58)
  
• Azeez Lawal, B.Sc, ACA, ACCA DipIFR(last updated: 24/07/2018 10:31)
  
• wahyu pranata(last updated: 17/07/2018 07:44)
  
• Rourou Lee(last updated: 10/07/2018 01:38)
  

People using this tool also downloaded