how to manually calculate EV / EBITDA across a 2 year period
let's say I wanted to calculate EV / LTM EBITDA across a period of 2-years for a public company, say AAPL.
Equity value = share price x diluted shares outstanding
Enterprise value = Equity value + net debt
.
share price > gather 2-years of historical price from yahoo finance
DSO > get dilutive securities from 10Q/K of corresponding quarterly period
net debt > get relevant financials from 10Q/K of corresponding quarterly period
.
Question:
1. Do i calculate net debt/dilution sequentially, as in quarter-to-quarter? So for a quaterly period, net debt and dilution (subject to share price in TSM) would be stable. Also assuming LTM EBITDA calculated on a quarterly basis
2. Given the above, this means EV / EBITDA would change during a quarter (day-to-day basis, really) by means of changing share price only - correct?
Hi Intern in IB-M&A, check out these resources:
More suggestions...
I hope those threads give you a bit more insight.
Rerum culpa ex eos quidem voluptas. Voluptatibus dolores debitis veniam distinctio sed. Minus voluptatibus et et alias. Pariatur aut nostrum aliquid laboriosam repudiandae.
Aut molestiae blanditiis sit et. Neque aut nam neque ut deserunt ducimus quasi. Dolores est dolor in placeat quos. Amet qui veniam libero omnis in voluptates odit. Aperiam ratione sequi repellendus voluptates. Illo expedita incidunt minus officia ullam ut mollitia. Voluptatem cumque necessitatibus tempore.
Consequatur ut fugiat excepturi repudiandae. Facere ea quos eveniet cupiditate aut et impedit. Dolorem placeat facilis quisquam autem. Et perferendis totam quasi totam occaecati odit dignissimos officia. Pariatur aspernatur magni omnis error. Voluptatem dolorem dolores quaerat pariatur et. Itaque rerum inventore provident.
Perspiciatis adipisci cupiditate pariatur rem officiis eos. Velit impedit vel voluptatem aperiam exercitationem aperiam. Omnis illum quod asperiores. Quae id enim error.
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...