● Introduction: 1 slide.
	
	o In this slide, give some information on the industry and three companies you
	selected and explain why you selected these, why you think these three companies represent the industry
	●    Use Excel to display quarterly data and trends for sales and profits (net income and EBITDA for 16 quarters) for the three companies.
	o Talk about the general trends in the sector. Note and explain any deviations from these patterns.
	o Your charts should be self-explanatory
	●    Identify and compile two datasets (data other than company financial data) that you think help explain trends in the industry.
	o If you were looking at airline travel, you could analyze data sets such as: cost
	index of flight fuel, average price per mile traveled, infrastructure investments in airports, etc.
	o Develop and test a regression model to help explain industry trends.
. You might need to collect some more data on total industry revenues and/or profits over time.
	
. I am looking for a strong and thoughtful analytical approach. It is always a good thing if your model has strong statistical significance, but in this case, it is more important that your model demonstrates a solid understanding of industry drivers and dynamics.
	
	.     In addition to fundamental drivers, consider other variables to include,
	such as trend variables or dummies for seasonality (if you have a seasonal time series).
	o 2 - 3 slides.
	●    Of the three companies you are analyzing, choose one for a more in-depth treatment.
	o Develop a predictive model (regression model).
	o Have 1 slide to discuss the conditions necessary when fitting a linear regression model
	o Use scenario manager to develop three different scenarios for the next quarterly revenue and profit numbers.
	.     Explain the assumptions underlying your scenarios. Try to come up with scenarios that are rooted in real challenges and opportunities facing the company.
	o 2 - 3 slides.
	●    Summarize your analysis and layout the implications for management and the industry.
	o 1 - 2 slides.
	o 1 slide for sources and references.
	o If necessary, include more detailed analyses or models in a data appendix.
	
	
	
	
版权所有:留学生编程辅导网 2020 All Rights Reserved 联系方式:QQ:99515681  微信:codinghelp 电子信箱:99515681@qq.com  
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。