Assignment #3: Valuation - Ohio State University
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
- statutory accounting principles working group
- solutions to chapter 4 problems
- fin432 investments csun
- answers to questions
- annual compounding finance department
- answers to final exams exinfm
- solutions for homework accounting 311 cost winter 2009
- home office of the washington state auditor
- 3 u s department of education
- chapter 4 net present value finance department
Related searches
- ohio state university degrees
- ohio state university medical center
- ohio state university holiday
- ohio state university calendar
- ohio state university academic calendar 2018
- ohio state university academic calendar
- ohio state university jobs
- ohio state university campus jobs
- ohio state university holiday calendar
- ohio state university financial statements
- the ohio state university wexner medical center
- ohio state university calendar 2020