I am doing research on a company and wanted to compare current valuations with historical valuations. I have limited resources (yahoo, google, WSJ, TD AMTD, etc.) and I want to specifically know how to calculate EV/EBITDA for the past 4 years. How do I calculate what EV was in 2005,06,07, etc. Also, how do I calculate P/E for those years as well - and when I look at P/E for those years I assume I am still calculating forward P/E? I appreciate any help. Thanks.
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 6d | |
| +32 | How the heck do you learn all of this stuff? | 10 | 1d | |
| +28 | My experience on the sell side | 20 | 2w | |
| +28 | Getting Frustrated | 10 | 4w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 2d | |
| +17 | Am i fairly compensated? | 9 | 3d | |
| +14 | Data Science to PM | 8 | 1w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +12 | ER - Remote Jobs? | 8 | 6d | |
| Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
1) Enterprise value = market cap + net debt + minority interest Market cap = number of shares outstanding * share price Net debt = debt - cash 2) PE ratio = shareprice / earnings per share
You can find all the required information as stated above in the company's financial statements on its website (investor relations, historical annual reports / financial statements). Maybe you have to use another source for historical share prices.
Good luck.
Yes I understand the calculation of current EV and P/E etc. What I need to know is how to do it for prior years. What share price do I use is probably what I want to know.
Also, when I calculate EV/EBITDA for 2005 and what the P/E was in 2005, do I use 2006 EBITDA and Earnings with 2005 price and EV? And for EV for 2005 do I use debt and cash at the end of 2004?
For prior years, you have to look at historical annual reports of the company. For example 2005, you have to take 2005 EBITDA and 2005 EV. With respect to the share price, you can take the average or you choose a particular date. Furthermore,it is better to use semi annual reports.
take the share price as of the valuation date that you want. use yahoo finance for historical prices but make sure you use the unadjusted share price. take the EBITDA or earnings from that most recent 10K/10Q PRIOR to the valuation date (to be even more technically correct, make sure that the 10K/10Q was filed prior to the valuation date). also make sure that you use the share count as of the valuation date (actually, most recent to the valuation date), which you can get from that same 10K/10Q.
you can only do trailing multiples. you will not be able to do historical forward multiples because you do not have a source for historical projections.
I assume I can't take 2006 earnings and EBITDA for 2005 forward multiples?
Aut qui maiores error consequuntur id. Est facere expedita facilis ex cum. Laborum enim debitis id magnam aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...