Calculating the trailing 12 month growth rate
Author: Tobey
Creation Date: 12/10/2009 11:57 AM
profile picture

Tobey

#1
How can I calculate the annual trailing 12 months EPS growth rate?

CODE:
Please log in to see this code.

gives me the growth rate for the last quarter year

CODE:
Please log in to see this code.

gives me the growth rate for the last facial year

But I’d like to compare the last 4 quarters to the 4 quarters before them to keep the annual growth rate as up to date as possible.

I will appreciate any help you can give me!

Thanks
Tobey
profile picture

bompus

#2
I'd be interested in this as well.. anyone?
profile picture

Cone

#3
CODE:
Please log in to see this code.
profile picture

superticker

#4
Hold on a minute.
CODE:
Please log in to see this code.
... is the effective "change" over one quarter. Wouldn't that be quarter growth over TTM (Trailing Twelve Months)?

This is more about semantics, but in my mind, to get annual growth, one needs to contrast the most recent TTM to the previous TTM like the Fidelity website does. I appreciate the original question is asking not to do that, but then we are looking at quarter growth changes instead of annual changes--which is okay if we call it "quarter growth (TTM)".

Off topic, but my actual interest is computing a Trailing PEG Ratio = (PE ratio / annual %EPS growth). But in order to do that, I "think" I need 8 quarters. I'm not sure if taking the quarter growth (TTM) and multiplying by four is going to work. But again, it's about semantics; some may say that's reasonable. Too many choices.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).