aachimp:
hey guys, I'm learning about stock valuation and was wonderin if you someone knew how to set a convincing price target. what types of analysis would you have to use to go about it? thanks

Really depends. You can use all sorts of multiples such as FCF, EBIT, EPS, ROE, etc to come up with a target price.

 
Best Response

1) Open Excel and import 1-yr of historical EOD price data for that company 2) Calculate Mean chg per day 3) Calculate Standard Deviation 4) Set up 120 rows to represent trading days... day 0 = current price. 5) On day 1, multiply day 0 cell by (1 + Norminv(Rand(),mean cell, std cell))... don't forget to pray to the normal distribution gods 6) On day 2, do the same as day 1... drag to repeat for all trading days. Make sure it compounds the % chg each day.

Repeat simulation and cherish that normal distribution. Don't think about tail scenarios. And mathematically, your safest target price is today's closing price. I apologize for my cynicism.

More seriously, google DCF analysis if you think you can predict future CFs (or use historical earnings and make assumption of trend provided a stable business).. No guarantee that it will trade near that price but that should be the best "intrinsic" value data point.

 

Ah I see - so if the report was written on June 1, 2015, the 1 year price target would be for June 1, 2016, is that right?

Also along those lines, if that report was written on June 1, 2015 (and the company's FY is simply from Jan-Dec), presumably the LTM earnings would have been used, and so if they used a DCF, the DCF would be based off of LTM figures and not the last FY numbers, is that right?

 

Two ways and then trying to reconcile between them:

1) relative valuation - comparing to other companies using tons of ratios as tools 2) DCF - discounting cash flows by finding WACC or Return on Equity

During training they will explain when one is inappropriate and when one is preferred (ex. company experiencing losses, company is high growth, etc.).

Or listen to inscrutable, he actually is a equity researcher whereas I'm a summer analyst.

 

Any type of comp based valuation (transaction or comperable) is, like the B / S, taken at a moment in time. I.e. you're not forecasting future transactions or forward market data. So any multiple you arrive at is as of the day you compile the data.

That said, simply multiply your 2014 multiple by your EV/Sales 2011E.

Ace all your PE interview questions with the WSO Private Equity Prep Pack: http://www.wallstreetoasis.com/guide/private-equity-interview-prep-questions
 
Stringer Bell:
Any type of comp based valuation (transaction or comperable) is, like the B / S, taken at a moment in time. I.e. you're not forecasting future transactions or forward market data. So any multiple you arrive at is as of the day you compile the data.

That said, simply multiply your 2014 multiple by your EV/Sales 2011E.

i'm assuming you mean 2014 sales X EV/Sales for 2011? so that would give me a EV, but how do I get the 1 year target price from that?

 

What has been discussed so far is really more of what you think fair value is for the stock today. I.e. if you think it should trade at parody with its comp group, you would apply 6x multiple (the peer multiple) to your 2014E sales and determine the equity value per share today (or tomorrow as indicated).

What it "should" trade at today can be very different from your price target methodology. For your 1 year price target, you can set a valuation which the stock will need to grow into. For instance, let's say the comp group trades for 8x EV/Sales 24 months out. Then you could take an 8x multiple to your 2014E estimate (effectively 36 months out) and suggest this will be the EV in 12 months. Also, in this case you need to forecast the cap structure to 1 year out and find the new derived equity value per share.

Personally, I think the first method is not a price target at all, but it surprises me how many guys on the street use fair value and price target interchangeably.

 

I should have also mentioned that comp'ing to a peer multiple in 2014E will not have much integrity because the number of analysts publishing 2014E numbers - even in a heavily covered name - is likely very thin.

To your point, this is where discounting comes into play. You could use a 2012E multiple applied to your 2014E sales and then discount the results. The discount rate will be company specific.

 

Not an expert at valuation by any means. But some thoughts:

Did you remember to subtract out net debt when you are using EV/Sales as comp ratio? Typically, more than one ratio would be used to find a target range. How conservative are your revenue projections?

 

Not sure what the problem is.. your description was fairly vague... but your sum of parts valuation should be yielding something fairly close to the current price.. assuming your mechanics are correct, i.e. share value calc from EV as suggested above...

its really no different than taking a weighted average multiple and using that to value the entire firm...

check this: is the current trading multiple significantly different than the comps being used? i.e. is your company trading at 20x EBITDA when the comps (in both different industries) trading at 8x-10x?? There is often a reason that comps don't align, may be growth prospects? but if your company is currently trading at a multiple outside of it's range then you may need to adjust for the differentiating factor in order to arrive at a "true" fair value.

 

Depending on the industry EV/Sales may not be a good metric. For example, if the industry is composed of competitors with different business models (high margin/low volume and high volume/low margin) then averaging the EV/Sales of those competitors is going to give you a bogus comp. Do some research to see if EV/Sales is a common valuation tool in the industries you are comparing. Other thoughts: - Like another commenter said, make sure you subtract net debt from EV to get to your equity value when comparing stock price - Sum of parts may not be appropriate depending on the industries the businesses engaged in. If the businesses are highly correlated investors should require a greater return on equity (lower stock price) to own them.

 
Boothorbust:
Depending on the industry EV/Sales may not be a good metric. For example, if the industry is composed of competitors with different business models (high margin/low volume and high volume/low margin) then averaging the EV/Sales of those competitors is going to give you a bogus comp. Do some research to see if EV/Sales is a common valuation tool in the industries you are comparing. Other thoughts: - Like another commenter said, make sure you subtract net debt from EV to get to your equity value when comparing stock price - Sum of parts may not be appropriate depending on the industries the businesses engaged in. If the businesses are highly correlated investors should require a greater return on equity (lower stock price) to own them.
EV/EBITDA is the common metric, but I decided to use EV/S because most of its competitors are foreign and accounting practices can "fudge" EBITDA numbers with foreign firms.
 

Just some quick notes.

There is no debt on its books so no need to subtract it out.

The firm's EV/S is in line with its competitors and customers in industry A. However, in the firm's industry B, the EV/S is half of industry average. So basically I took the revenue from the firm's one industry and took the industry average and valued its accordingly. I think this is where my target price is getting messed up, however I think it's appropriate to do a sum of parts valuation because the firm's industries are very different. If I use the EV/S from industry A on the revenues for industry B. The price target becomes more realistic and is definitely in line with the firm's current share price.

Thoughts?

 

Convincing is relative - it's bullshit in and bullshit out to be honest - you can convince anyone of any real particularly robust number that is ahead of consensus by adding all sorts of flairs.

Depends on the sector as well - DCF is horseshit unless you're in pharma or a few others, but a price target takes into consensus - where consensus is wrong and what you're taking into account and what they are not.

 

Beatae autem dicta doloremque illum. Cupiditate nobis sequi cupiditate ut. Tempora similique doloremque labore voluptatem.

 

Iste laboriosam quis iste quo exercitationem laboriosam deleniti. Omnis error harum corrupti delectus. Id ex qui fugiat non. Nostrum adipisci corrupti sed laboriosam.

Magnam voluptatem rerum voluptate culpa. Sint odit error et suscipit quia. Perferendis ut incidunt nam autem. Fugit occaecati et quis dolor. Labore illum aliquam cum aut assumenda. Provident esse quia autem esse deserunt. Totam rerum neque sit quia.

 

Officia tempora qui vitae sed non doloribus quas. Autem magnam quam laudantium autem occaecati. Cupiditate voluptas laborum repudiandae error quasi consectetur. Tenetur incidunt molestias praesentium voluptas ut magni. Dolor a tenetur excepturi eum.

Impedit consequatur est accusamus esse culpa. Omnis tempora consequatur modi corporis rerum. Alias omnis recusandae esse illo laborum aspernatur adipisci. Voluptate nihil quia autem velit beatae iure. Aperiam aut et aut velit corrupti quam. Omnis consectetur repellendus nihil voluptas. Sit qui aliquam est aut earum.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”