This is between United, American, and Delta. Excel formulas are needed.

Explore Yahoo dot com to find and quote the following given data:

i) Within United, American, and Delta "Statistics" ===>"Dividends", what is its amount of "Trailing Annual Dividend Rate"? This amount is for the dividend actually paid (i.e., without any prediction) during the past 12 months up to today, thus it should be used to measure the most-current-year dividend, D0, in the dividend growth model DGM formula.

ii) Within United, American, and Delta 's "Analysts"==>"Growth Estimates", what is its United, American, and Delta "Next 5-year per annum" amount? This shall be used as the long-term future growth rate, g , in the dividend growth model formula. Use these web-provided data in a) and b) as inputs, and do the following calculations. Question

B1: Assume that the market expects the United, American, and Delta long-term stock return is given as R = 15.00% per year based on its risk. Use the dividend growth model (DGM) formula to compute CAT stock's fair price P0. And, does this calculation outcome make sense to you? (In other words, in case R < g, expected return < projected future growth, will the DGM formula still lead to sensible answers?) Question

B2: Let's assume that today's most-current-day "at close" stock price (see United, American, and Delta s "Summary") is fair, then use this observed price as P0 in the DGM formula. But the long-term required (expected) stock return R is not yet given, you can try to figure it out. With these web findings of P0, D0 and g amounts being used as inputs to solve the DGM equation, what shall be United, American, and Delta stock's corresponding required return, R?

Question B3: Let's look at how those practitioners (e.g., Wall Street analysts) think of the potential of United, American, and Delta stock. Via United, American, and Delta 's "Summary", find and compare the actual "at-close" price amount as of today with the "1y Target est" price amount. Are Wall Street analysts claiming that the United, American, and Delta stock price still has considerable room to rise within the forthcoming year?