Simple FCFF Model (Free Cash Flow for the Firm)
Originally published: 17/06/2016 15:52
Publication number: ELQ-91506-1
View all versions & Certificate
certified

Simple FCFF Model (Free Cash Flow for the Firm)

A complete FCFF model that allows for changing margins and has default assumptions built in

Description
This excel model is a complete FCFF model that allows for changing margins and has default assumptions built in (to protect you from inconsistent assumptions)

Note: this model is being shared with the authorization of Professor Aswath Damodaran from NYU Stern Business School (www.damodaran.com)

This Best Practice includes
1 Excel Model File

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

The objective of this model is to get the following output values for a firm:
- Terminal cash flow
- Terminal cost of capital
- Terminal value
- PV(Terminal value)
- PV (CF over next 10 years)
- Sum of PV
- Probability of failure
- Proceeds if firm fails
- Value of operating assets
- Value of equity
- Value of options
- Value of equity in common stock
- Number of shares
- Estimated value /share
- Price
- Price as % of value

If you want a quick, all-in-one model to value a company with relatively few inputs, try this.


4.6 / 5 (14 votes)

please wait...