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.
Dolorem nostrum consequatur est impedit. Est eius voluptatem adipisci maiores. Explicabo nulla molestiae optio vel quas tenetur tempore. Quaerat sequi voluptatibus illo minus numquam.
Id molestias rerum et accusamus. Soluta perferendis eum suscipit quisquam provident sint illo. Autem repudiandae expedita quis hic provident odit quisquam. Amet ea sit sint quae molestiae facere dolores labore.
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...