# Combining information from the S&P reports and some estimate

Combining information from the S&P reports and some estimated data, the following calender-year data, on a per-share basis, are provided: YEARPRICERANGELOW HIGHEARNINGSDIVIDENDSBOOKVALUE(D/E)100(%)ANNUALAVG. P/EROE=E/BOOKTR%1999$26.5 — $35.3$4.56$1.72$25.9837.77.017.6%200028.3 — 37.05.021.9529.1538.86.217.3200123.5 — 34.35.142.2032.1142.85.816.0200227.8 — 35.04.472.2030.867.7200329.0 — 47.85.732.3030.306.8200436.6 — 53.5 6.752.4039.8520056.752.6044.00A. Calculate the D/E, ROE, and TR for 2002, 2003, and 2004. (Use the average of the low and high prices for calculate TRs). B. Show that from 2000 through 2004 the per annum growth rate in dividends was 6.9 percent and for earnings was 8.2 percent. C. Using the current price of $47, with estimated earnings for 2005 of $6.75, show that the P/E would be evaluated as 6.96. D. On the basis of the annual average P/E ratios shown above and your estimate in Problem C, assume an expected P/E of 7. If an investor expected the earnings of GF for 2005 to be $7.50, show that the intrinsic value would be $52.50. Please send the formulas that were used for each and type out the actual calculations. This is required for the whole assignment. (I need to be able to write out the work on paper! Thanks!)