IPO case

We are working on Jetblue in this case, Writer only need to respond the Third part on the assignment which is Valuation Process. No need to do first two part. I will upload the instruction, relative data and class course handout in file. This case need to work on word and spreadsheet. Let me know if you need extra pages to done on this and any other question during the processing on this case. Valuation Process (most important part of the assignment) 1. Build a full dynamic, integrated model with sensitivity analysis. 2. Justify your choice of model and key assumptions 3. Do you feel that the IPO price was the proper price for your company's shares? a. To fully answer this question, work through a fully dynamic spreadsheet that incorporate a mix of absolute and/or relative valuation methods to arrive at a fair value for the stock. Some information that you are accustomed to having for prior valuation work (i.e. historical stock prices to find your company's beta relative to an index) will not be available, so you will have to improvise and find alternative ways of finding proxies for important elements. b. Be sure to correctly label and identify all assumptions and inputs utilized for the calculations and be comfortable in explaining why those are the case. c. Great analyses will not only entail one scenario but account for a range of possibilities, such as a bear, expected and bull case to help suggest potential upside or downside relating to the potential investment. Preferred language style > Simple (Easy vocabulary, simple grammar constructions) Activate Windows                                                                                                                  

Sample Solution