1. Catalog
  2. Finance
  3. Valuation Models
  4. Actual vs Potential Dividends
Actual vs Potential Dividends
  • Actual vs Potential Dividends
  • Actual vs Potential Dividends
  • Actual vs Potential Dividends
  • Actual vs Potential Dividends
  • Actual vs Potential Dividends
  • Actual vs Potential Dividends
Originally published: 20/06/2016 14:00
Publication number: ELQ-91661-1
View all versions & Certificate
certified

Actual vs Potential Dividends

Compares the dividends paid to what a firm could have paid, by estimating the free cash flow to equity

Prof. Aswath Damodaranby Prof. Aswath Damodaran
Professor at NYU Stern School of BusinessFollow 1,062
NYU Stern School of Businesswith NYU Stern School of Business
An Education in PossibleFollow 56
7 reviews624 views|Start the discussion!|Bookmark download for free
potentialfinancefree cash flow to equitydividendsactualstockholder returnproject qualityforecasts
Description
With this excel model, you can:

1. To compare how much a firm has returned to its stockholder historically (up to 10 years) with how much it could have returned.
2. To provide an assessment of project quality (ROE compared to cost of equity) and stock price performance over the period.
3. To provide forecasts of how much cash the firm will have available for stock buybacks in the future

Free Cash Flow to Equity = the cash flow left over after net debt payments, net capital expenditures and working capital investments

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 Slide

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:

Historical Analysis
1. FCFE and Cash Returned each year for the historical period
2. Returns on equity, the stock and your required return each year for the historical period
3. Averages of both over the entire period
Forecasts
1. Forecasted FCFE for next 5 years
2. Forecasted dividends for next 5 years
3. Cash available each year for stock buybacks for next 5 years.


5.0 / 5 (7 votes)

please wait...