21 File Home Insert Draw Page Layout Stock Template1-Excel Formulas Data Review From Text/CsV LO Recent Sources View Help Tell me what you wamt to do Quenes 8& Connections From Web Existing Connections Clear et Properties From Table/Range Refresh g Reapply ta Edit Links Filter Advanced All Ted to Get & Transform Data Columns Queries & Connections Sort & Filter 4 X F G H A B roblem 2 You expect a stock to pay dividends of 50.75, S0.88, $1.45, S2.10 and $3.12 over the next 5 years. You w first dividend exactly 1 year from now. You expect the stock to sell for a price of $42.95 five years from now. receive the 3 2 $3.12 1 $2.10 $1.45 $0.88 $0.75 $42.95 Dividend Expected price 5 years from now: 15% Find the price today