Value Driver - Last Twelve Months Workout
- 01:29
Value Driver - Last Twelve Months Workout
Glossary
10Q Interim Report LTM Quarterly Report TTMTranscript
This workout asks us to calculate last 12 months EBIT and EBITDA for MayLing Co, for the 12 months ending 31st June-31 So what have we got provided to us? Well we have the 12 months ended December 30 You've then got the old six months ending June-30. And then you've got the newer six months, 30th June-31 We've got an income statement, depreciation, amortization and then I've started my answer underneath here So I'm going to start by getting EBIT and that's just going to be the operating profit And I've got the EBIT for all three columns I want to find EBITDA, so I take my EBIT, add back depreciation and amortization And I've got EBITDA for all three periods Now to try and find LTM EBIT. Well I start by taking the full year of EBIT and I subtract out the oldest six month that I don't want, January to June-30 I then add the newer six months, January to June-31 and that will then give me my LTM EBIT, 414 I need to do exactly the same principle in last 12 months EBITDA I take the full 12 months, subtract out the oldest 6 months and add the newest 6 months Giving me LTM EBITDA of 563