KO

AAPL

WMT

SO

MCD

12a. One-year target price

$52.32

12b. Annual dividend expected in dollars

12c. Current price of stock (money invested)

(put current price of stock as a negative number)

12d. Total dollars received if stock sold after one year

(Add one-year target price and annual dividend expected in dollars)

12e. Internal rate of return (IRR) expected

(Use 13c and 13d as "Values" in IRR function)

12f. Which company has the highest expected IRR, and which company has the lowest expected IRR?

12g. How could you use this analysis to make an investment decision?