Free Cash Flow for the Firm (FCFF) Stable Growth Excel Model

A stable growth FCFF discount excel model.

User defined inputs.

The user has to define the following inputs to the model:

1. Current EBIT and tax rate

2. Capital Spending and Depreciation

3. Change in working capital

4. Debt ratio

5. Cost of Equity or Inputs to the CAPM (Beta, Riskfree rate, Risk Premium) and Cost of Debt

6. Expected Growth Rate in free cashflows to firm forever.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!