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.
Trending Content - Equity Research Forum
| +13 | Is Equity Research Dying - Where Are the Future Opportunites? | 4 | 22h |
| +10 | Associates who stuck around for > 5 years working for the same analyst. Why? | 4 | 6d |
| +9 | UBS ER SA27 Superday | 7 | 3w |
| +9 | Detailed Revenue and Cost Builds | 3 | 1w |
| +7 | Analyst with no coverage or ranking | 5 | 1w |
| +7 | Uiuc or Ross or UChicago | 8 | 2w |
| +1 | IB SA -> ER FT | 4 | 2w |
| 0 | Equity Research Rankings | 1 | 1w |
Career Resources
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?
Et nihil et aut adipisci nemo possimus ut ea. Et maiores odio odio sunt voluptatem debitis temporibus. Iste eum aut iusto ducimus qui facere maiores. Cupiditate omnis esse rerum cum.
Qui eos odio vel hic ab et. Sit accusamus nihil est ipsa voluptatem eum. Rem eligendi nostrum aut mollitia minus at et. Incidunt repudiandae labore voluptatem fugiat earum et.
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...