Simple FCFF Model (Free Cash Flow for the Firm)

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

fcfffinancefree cash from for the firmpresent valuesimplevaluation

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 business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool for free!

Download for free

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.

Reviews

  • No review yet!

Any questions on Simple FCFF Model (Free Cash Flow For The Firm)?

The user community and author are here to help. Go ahead!

please wait...