Earnings estimates are indeed available quarterly, and as such you can
calculate a forward P/E for any given time, assuming you have the
estimates for the next four quarters and the stock's price.
For the sake of time and practicality, I'm providing both the Q1 2003
and Q2 2003 estimates for a single point in time - December 31, 2002.
Again, for sake of practicality, I'm just providing the P/Es for
certain periods. I've provided five forward P/Es for each company,
based on the closing prices at the end of five quarters. For instance,
the forward P/E as of December 2002 represents the monthly price
divided by the sum of the estimates for the first four quarters of
2003. The P/E as of March 2003 represents the monthly price divided by
the sum of the estimates for the last three quarters of 2003 and the
first quarter of 2004.
Q1 03 Q2 03 Forward P/E
Est. Est. 12/02 3/03 6/03 9/03 12/03
Ace $0.94 $1.01 7.1 6.8 7.8 7.2 8.3
AIG $0.93 $0.97 14.6 12.4 13.5 13.6 14.9
Chubb $1.21 $1.26 9.9 9.2 12.3 11.8 11.2
Hartford$1.13 $1.16 9.6 7.3 9.6 9.2 10.0
MBIA $1.16 $1.16 9.2 8.6 10.7 11.2 11.5
Partner Re$1.70 $1.62 8.1 11.0 7.9 7.2 7.7
Everest Re$1.58 $1.67 8.1 8.0 8.8 8.3 7.9
St. Paul$0.85 $0.90 9.1 8.5 9.1 8.7 8.9
XL $1.88 $1.86 9.6 8.5 9.6 8.5 8.4
V |
Request for Answer Clarification by
bassist695-ga
on
03 Feb 2005 08:29 PST
Great answer!
Could you tell me your sources, or is that proprietary information? I
only ask because this data is a subset for an overall project, and if
I am asked what my sources were (aside from Google Answers), I'd like
to have an answer.
Thanks,
Mike
|
Clarification of Answer by
vercingatorix-ga
on
03 Feb 2005 09:12 PST
The source for the historical estimates is proprietary. However,
anyone with the estimates can calculate the P/Es usind nothing more
than historical pricing data from Yahoo!
V
P.S. Thanks for the tip and the kind words.
|
Request for Answer Clarification by
bassist695-ga
on
03 Feb 2005 14:54 PST
I know it's possibly too late, but I requested the forward P/E for
2004 as well as 2003 and did not realize until now that I only have
the forward P/E through 2003.
If you could post the data I'd appreciate it.
Thanks.
|
Clarification of Answer by
vercingatorix-ga
on
04 Feb 2005 05:42 PST
Sorry about the lack of data. I was thinking about 2004 estimates, not
the valuation. Here is the complete schedule of forward P/Es, based on
stock prices at the end of the quarter. I have no quarterly earnings
estimates for Everest RE in 2005, and as such I don't have forward
P/Es for Everest in 2004.
Forward P/E
Dec-02 Mar-03 Jun-03 Sep-03 Dec-03 Mar-04 Jun-04 Sep-04 Dec-04
Ace 7.1 6.8 7.8 7.2 8.3 10.4 9.9 7.1 7.3
AIG 14.6 12.4 13.5 13.6 14.9 15.7 15.1 13.4 12.4
Chubb 9.9 9.2 12.3 11.8 11.2 10.3 10.0 9.4 10.0
Hartford9.6 7.3 9.6 9.2 10.0 10.4 10.2 8.9 9.5
MBIA 9.2 8.6 10.7 11.2 11.5 11.6 10.5 10.4 10.8
Partner Re8.1 11.0 7.9 7.2 7.7 8.1 7.9 6.4 7.3
Everest Re8.1 8.0 8.8 8.3 7.9 NA NA NA NA
St. Paul9.1 8.5 9.1 8.7 8.9 15.7 9.5 7.0 7.9
XL 9.6 8.5 9.6 8.5 8.4 10.8 10.3 7.4 7.6
V
|
Request for Answer Clarification by
bassist695-ga
on
04 Feb 2005 06:25 PST
Great, much appreciated!
|
Clarification of Answer by
vercingatorix-ga
on
10 Feb 2005 07:32 PST
Any time.
V
|