USE EXCEL AND SHOW EXCE FORMULAS.

Explore finance.yahoo.com to find and quote the following given data: Within CAT's "Summary", what is its "dividend" amount (the one in dollars, not the one in % yield)? This shall be used as the most-current dividend, D_0, in the dividend growth model DGM formula. Within CAT's "Analysts" Implies "Growth Estimates", what is its CAT's "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 data quotes as inputs and do the following calculations. Assume that the market expects the CAT 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 P_0. And, does this calculation outcome make sense to you? (In other words, if R