Exercise One: An equity researcher at Fiterman Capital estimates the following dividends, and stock price for Nike stock shown in the table below. Given the aforementioned information, and a required return of 7.25%, (a) use a dividend discount model to compute the intrinsic value for this stock, (b) use a Data Table to graph the relation between required return, and intrinsic value for this stock, (c) if the market price is $45.75 per share, what is your recommendation to your trading desk? Time Dividend 1 3.25 2 3.36 3 3.45 4 3.54 5 3.64 6 3.76 6 44.75