FCFF (Free Cash Flow for the Firm) Excel Model with exposure to country risk
Originally published: 17/06/2016 14:07
Last version published: 02/02/2018 14:49
Publication number: ELQ-57555-2
View all versions & Certificate
certified

FCFF (Free Cash Flow for the Firm) Excel Model with exposure to country risk

An Excel FCFF Model allowing the user to enter a measure of company exposure to country risk when making a valuation

Description
This FCFF Excel model is designed to value firms with operating income that is either positive or can be normalized to be positive. It allows for up to 15 years of high growth, and can be used either as a 2-stage or a 3-stage model.

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

- Present Value of FCFF in high growth phase
- Present Value of Terminal Value of Firm
- Value of operating assets of the firm
- Value of Cash, Marketable Securities & Non-operating assets
- Value of Firm
- Market Value of outstanding debt
- Minority Interest in consolidated holdings
- Market Value of Equity
- Value of Equity in Options
- Value of Equity in Common Stock
- Market Value of Equity/share

- Market Value of Equity/share in BR


4.7 / 5 (12 votes)

please wait...