Suppose that Hayward Interactive Technologies Inc. just paid a dividend of $1.25 on its common stock. The market requires a return of 8.00% for stocks with similar risk. The company is expected to increase its dividend by a constant 5.00% per year. How much should the stock sell for today (t=0)? Calculate and present your answer in three ways: using the Time Value of Money (TVM) formula on a time line, the constant growth Present Value formula as well as the Net Present Value Excel function. Instructions Provide answers to the following questions using Excel. You must calculate using Excel to receive credit (.e., just the correct answer produced by a calculator is not sufficient). I must be able to see how you calculated your answer in Excel for you to receive credit. Suppose that Hayward Interactive Technologies Inc. just paid a dividend of $1.25 on its common stock. The market requires a return of 8.00% for stocks with similar risk. The company is expected to increase its dividend by a constant 5.00% per year. How much should the stock sell for today (t=0)? Calculate and present your answer in three ways: using the Time Value of Money (TVM) formula on a time line, the constant growth Present Value formula as well as the Net Present Value Excel function. Instructions Provide answers to the following questions using Excel. You must calculate using Excel to receive credit (.e., just the correct answer produced by a calculator is not sufficient). I must be able to see how you calculated your answer in Excel for you to receive credit