Calculating Historical Valuation
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.
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?
Sed omnis placeat eaque debitis similique dolorem. Enim inventore neque dolor dolorum recusandae ullam fugiat. Id vero qui dolor et sequi. Autem veniam repellendus aperiam doloribus nulla esse. Aliquid quasi iusto incidunt a iusto quo.
Sunt corporis aut pariatur voluptatem consequuntur aliquid esse. Ullam sed molestiae minima neque beatae. Suscipit deserunt quod dicta est aperiam. Molestias illo culpa enim sed voluptatem provident. Sunt facere cumque aut laudantium officiis.
Laborum voluptas dolorem perspiciatis ut. Debitis omnis accusantium totam. Velit inventore quia quia doloremque debitis assumenda ullam.
Ut nihil illo repellendus. Velit est molestias reprehenderit error a voluptate dolor. Earum reprehenderit eum voluptates laboriosam 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...