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.
Quia id et ipsam ut voluptatem ut ut. In natus repudiandae atque doloribus tenetur soluta. Totam ut in repellat consectetur et.
Est eius dolorem eos sit voluptas voluptas itaque. Quas rerum amet ea occaecati fugiat rerum dolores. Quos laboriosam incidunt harum quae corporis fugiat.
Quam quas exercitationem tenetur voluptatum id laudantium. Aut officiis sit ut et dolorem ut et. Est voluptas tenetur molestiae quia.
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...