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

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

101 reviews6,370 views|Start the discussion!|download for free

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

Objectives

Outputs:
- Value of Firm
- Value of Equity
- Value of Debt
- Cost of Equity
- Pre-tax Cost of Debt
- After-tax Cost of Debt
- Cost of Capital

Reviews

- 4.6 / 5 (101 votes)
  - 70%
  - 25%
  - 3%
  - 2%
  - -
- Rate this Downloadable Tool
  Write a review
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)
CHETAN AGGARWAL(last updated: 18/06/2019 16:34)
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)