Below isour homework assignment and I need major help in what to do to create this spreadsheet can anyone help me?
Using the resources available on the Internet build a spreadsheet to calculate the intrinsic value of United Technologies Corp. (UTX) stock using at least a 3-stage (i.e. 3 different near term growth patterns ending with a constant growth assumption) Dividend Discount Model. Make sure you state all of the assumptions used to generate this value. You must alsoshow all of your work. Make sure you demonstrate all of the techniques discussed in class for estimating each of the assumed variables. (i.e. 4 methods for estimating required return 2 methods for estimating terminal growth.) In doing so you will generate at least 8 price estimates. Remember that your goal is to identify an appropriate price range for the stock. How does your value compare to the actual price? What are some of the reasons for any discrepancy? [Hint donotuse the H-model]