Assignment #3: Valuation
Assignment #2: Valuation
Submit a hardcopy of this assignment in the class by the due date.
|Your Name: |Date: |
|Company: |Ticker Symbol: |
|Current Stock Price: |Sector: |
Use 10 years of history for the valuation information below.
S&P 500 Valuation (Type in stock ticker SPX )
Use GF function in Bloomberg to find the following
|Absolute Basis |High |Low |Median |Current |
|P/E | | | | |
|P/B | | | | |
|P/S | | | | |
|P/EBITDA | | | | |
Do you think your stock should trade at a premium multiple to the market as a whole? Why? Think about its long-term growth and cyclicality vs. the market as a whole.
Sector Valuation (Type Bloomberg code )
|Sector |Bloomberg Code | |Sector |Bloomberg Code |
|IT |S5INFT | |Utilities |S5UTIL |
|Financials |S5FINL | |Cons Discret |S5COND |
|Materials |S5MATR | |Cons Staples |S5CONS |
|Healthcare |S5HLTH | |Industrials |S5INDU |
|Real Estate |S5RLST | |Energy |S5ENRS |
|Telecom |S5TELS | | | |
|Absolute Basis |High |Low |Median |Current |
|P/E | | | | |
|P/B | | | | |
|P/S | | | | |
|P/EBITDA | | | | |
|Relative to SP500 |High |Low |Median |Current |
|P/E | | | | |
|P/B | | | | |
|P/S | | | | |
|P/EBITDA | | | | |
Do you think your sector is relatively cheap/expensive/inline on this basis? Why?
(Answer should be determined by how the sector currently trades versus its historical norm and whether that is warranted. Abbreviated example: Sector is trading below its 10 yr average, but this is warranted since growth has slowed and higher risk)
Consensus Revenue and Earnings Estimates
Using Bloomberg, what is the latest full calendar year of reported earnings?
Complete the table below:
Using Bloomberg (EM function), what are the latest annual reported revenues and EPS? What are the consensus annual revenue and EPS estimates (and growth rates) for the upcoming three years?
|Year |Last reported year |1 yr forward estimate |2 yr forward estimate |3 yr forward estimate |
|Revenue | | | | |
|% growth from prior year | | | | |
|Shares Outstanding | | | | |
|Earnings Per Share | | | | |
|% growth from prior year | | | | |
Stock Valuation
Use GF function in Bloomberg to find the following:
|Absolute Basis |High |Low |Median |Current |
|P/E | | | | |
|P/B | | | | |
|P/S | | | | |
|P/EBITDA | | | | |
Use function in Bloomberg and select tab
|Ticker |P/E TTM |P/S TTM |P/B |P/CF TTM |EV/ EBITDA TTM |
|Your Ticker | | | | |
|P/E | | | | |
|P/B | | | | |
|P/S | | | | |
|P/EBITDA | | | | |
* Your target Earnings/Share should come from the Consensus Revenue and Earnings Estimates section of this assignment.
There are ten sectors in the S&P500, what are the returns of each over the given time frame? Use the TRA function in Bloomberg.
|Sector |Last 12 months |Last 3 months |Last 1 month |
|S&P500 (SPX ) | | | |
|Energy (S5ENRS ) | | | |
|Material (S5MATR ) | | | |
|Industrials (S5INDU ) | | | |
|Cons Discr (S5COND ) | | | |
|Cons Stap (S5CONS ) | | | |
|Healthcare (S5HLTH ) | | | |
|Financials (S5FINL ) | | | |
|Info Tech (S5INFT ) | | | |
|Telecom (S5TELS ) | | | |
|Real Estate (S5RLST) | | | |
|Utilities (S5UTIL ) | | | |
When will the company next report earnings? (Ticker DES )
Knowing what you now know, would you want to own this stock? Why?
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- a short guide on bloomberg
- using spreadsheet to determine value using residual income
- new mexico s flagship university the university of new
- assignment 3 valuation
- mergers and acquisitions a beginners guide
- math rwlo template title placeholder
- activision stock market analysis tools for investors
- bloomberg jan röman
Related searches
- bond valuation calculator
- basic bond valuation calculator
- bond valuation formula
- date of death valuation calculator
- date of death valuation letter
- bond valuation excel template
- bond valuation relationship calculator
- bond valuation explained
- business valuation formula
- coupon bond valuation calculator
- common stock valuation calculator
- stock valuation calculator online