our target company is Hyatt, please compare it to 4 or 5 competitors companies.and follow the instructions in the assignment description that i uploaded and the exel sheet will be the template that you have to fill from their financials for 3 years.
following last week lecture on the assignment, please add the following information:
1) you have been provided with a list of the sources you have to use for the assignment (10-K , 8-K, 10-K). If you use another source or you perform ANY CALCULATION that is not in the specified source or not IMMEDIATELY RECOGNIZABLE in those sources, you MUST include it in an assignment annex or appendix (at the end of the word format is fine). You need to specify what you have done (the calculation for example or the different source).
2) the stock price MUST be calculated as the year average.
3) Adjusted income statement, calculation of fully diluted share outstanding (the value needs to be included in the selected market data section but not calculated in the dedicated section of the template), prior stub, current stub, estimated growth rate, NFY, NFY+1 and notes MUST be left blank.
4) the implied equity value, enterprise value and stock price of the TARGET company need to be extracted from the comparable companies benchmark analysis and not directly through the calculation of the selected market data section in the template. This has been explained during the lecture and is explained in the assignment structure on blackboard as well. Direct calculation of equity value and enterprise value (through the selected market data section in the excel template) must be performed JUST for the comparable companies.Remember that our task is to evaluate the target company by using a sample of comparable companies.