VAL = Valuation Models
Copyright 2011, 2014 BusinessAllstars.com - All Rights Reserved
XL Name Date
DIVIDEND DISCOUNT MODEL
Now Next Year Year +2 Year +3 Year +4 Year +5
Future Dividends per share $ $ $ $ $
Short-term Constant Growth % % % %
Long-term Constant Growth %
Required Return on Equity % $
Horizon
Present Value of Future Cash Flows $ $ $ $
Value of Equity Today $
PRICE/EARNINGS MODEL
Now High (1) High (2) Low (1) Low (2) Average
Historic P/E Ratios past 10 years
Projected P/E Ratio
Earnings Per Share $
Value of Equity Today $ Equity Value based on average historic P/E
MULTIPLES MODEL
Now EV/EBITDA EV/EBIT EV/NOPAT P/SALES P/BV
Multiples (leave blank if not applicable)
  Base (EBITDA; EBIT; NOPAT; SALES; & BV) $ $ $ $ $
Total Enterprise Value $ $ $
    Debt (Minus) $ $ $ $
    Non-Operating (Plus) $ $ $ $
Total Equity Value (000) $ $ $ $ $
    Outstanding Shares (000)
Value per share for each multiple $ $ $ $ $
Value of Equity Today $

Enter Inputs in YELLOW boxes and tab from box to box