Valuation Sheet

Document Sample
Valuation Sheet Powered By Docstoc
					                                                    HISTORY
            Revenue   g         FCF       g         Dividends g         EPS       g
2008                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2007                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2006                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2005                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2004                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2003                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2002                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2001                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
2000                  #DIV/0!             #DIV/0!             #DIV/0!             #DIV/0!
1999

Average     #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!

                                                    MODELS
Morningstar FV        Constant Dividend                   Supernormal FCF                 Supernormal Dividend
                      D0                                    Growth    FCF
                      Growth                        FCF0                          D0
Yahoo 1-Yr Target     Ks                            FCF1              0           D1
                      Price    #DIV/0!              FCF2              0           D2
                                                    FCF3              0           D3
Current Price             Constant FCF              FCF4              0           D4
                      FCF0                          FCF5              0           D5
                      Growth                        Tg                0           Tg
                      WACC                          WACC                          Ks
                      Price    #DIV/0!              TV      #DIV/0!               TV
                                                    Price   #DIV/0!               Price
              PE
             Beta
        Tax Rate
       Total Debt
    Market Equity   0
              Wd    #DIV/0!
              Ws    #DIV/0!
              Krf
              Km
              Kd
      Ks (CAPM)     0.0%
          WACC      #DIV/0!
     Shares Out.


Supernormal Dividend
   Growth         Div.

                    0.00
                    0.00
                    0.00
                    0.00
                    0.00
                    0.00

   #DIV/0!
   #DIV/0!

				
DOCUMENT INFO