联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp

您当前位置:首页 >> OS作业OS作业

日期:2024-04-11 05:48

●    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).

Have 1 slide to discuss the conditions necessary when fitting a linear regression model

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
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。 站长地图

python代写
微信客服:codinghelp