Hasbro, Inc securities exchange data analysis Assignments | Custom Essay Help

The final project is designed to provide you with hands-on strategic analysis experience. You have chosen a company to investigate and gathered at least 6 years of historical sales data for the company you have select by now. You have analyzed the data and now you will decide the forecasting techniques you will perform to forecast 8 quarter or 24 months of sales forecast. You have learned a number of forecasting techniques throughout this course. You as a group of two students must use at least two separate methods. One of you will use an appropriate extrapolation method (Moving average, exponential smoothing, Holt’s or Winter’s) and the other of you will use a casual regression method. You will communicate your results in a paper and report your findings in Excel work file and discuss findings of other papers in a discussion. First, I want to give you an example of Excel output that meets my expectation. You now see on the screen, one sample Excel output: -First Tab is composed of the data. You have the dates in column A and the sales data in Columns B. First Tab is titled as “Basic Data”. -Second Tab is composed three columns. You have the data as used for your extrapolation method with dates in column A, the sales data in column B, and the predicted values for that method in Column C. This tab is titled as “Extrapolation Model”. -On the third tab, you will have all the data used in in the regression model with dates in column A and the sales data in column B. The next columns of Tab 3 should have all the independent variables used in regression model. Following these columns, you should have a column with values predicted by the regression analysis. This tab is titled as “Regression Model”. -The fourth and final tab should have the dates in column A, the original sales data in column B, the predicted values from extrapolation forecast in column C and the predicted values from your regression model in column D. The predicted values will extend 8 quarters (or 24 months) beyond the actual historic values. This tab is titled as “Final Forecast”. Second, I want to briefly explain requirements for the paper. The paper should be 8–10 pages in length, including tables and figures, and must include only the following eight parts: 1. Title Page: You will include company name, your name, and an appropriate “Table of Contents”. I expect you to list page numbers for each section. 2. Section 1 – Introduction: You will answer the following questions for this section: o Why did you select this topic? o How would this forecast be useful? o To whom would it be useful? The length of this section should be maximum 1 page. 3. Section 2 – This part is literature review: You will present information about the company and industry. This section is not about forecasting methods. The length of this section should be maximum 1 to 2 pages. 4. Section 3 – This part is managerial overview of methods used: You will answer the following questions for this part. o Why did you select these forecasting methods? o Explain why you believe the technique you have chosen is appropriate to forecast your data. The length of this section should be maximum 1 to 2 pages. 5. Section 4 – This part will be composed of application of forecasting methods and results. You will answer the following questions: o What are the forecast results of these methods? o Which method performs better? o How did you evaluate the forecasting methods? Basically, in this part, you will present your forecast results and explain the methods you used to evaluate your forecast results. The length of this section should be maximum 2 to 4 pages. 6. Section 5 – This section concludes the paper and talks about the limitations of the paper. The length of this section should be maximum 1 page. 7. Section 6 – References: You will cite 6 to 8 references related to the company selected. 8. Appendix: You will include one or more appendices containing appropriate graphics and a complete professional listing of data with appropriate citations. All graphs in the appendix must be referenced in the body of your paper along with the page on which each graph can be found. The paper should be typed, single-spaced, and presented in 14-point Times New Roman font. Third, I want to explain briefly the discussion. I will post all papers that are submitted on the discussion board titled “Project”. You are required to read, reflect on, and respond to at least one project paper. You will post your contribution to the topic “Projects” on the Discussion Board. Your contribution to the discussion about papers should be clear, complete, and accurate. In your reflection on the paper, you should cover at least two of the following: • Offer an additional method or variable(s) to include in a forecasting technique to predict sales. You will explain your reasons for the new method or variable you propose. • Suggest ways in which a forecasting technique could be more clearly expressed. • Identify passages where you think the writer misinterpreted, or incorrectly applied, a concept. • Offer your assessment of the forecast results, and explain why you agree or disagree with the prediction.

Instructions
In Week 2, your instructor divided the class into pairs. By the end of Week 3, your group selected the company to investigate. By the end of Week 4, the company selection was finalized. In Weeks 5 and 6, you should have analyzed the data and performed the required forecasts.
This week, your group will forecast monthly or quarterly sales (in units or dollars) for your chosen company. As a group, you will write a paper about your findings.
Paper Requirements
Prepare a two-year (8 quarter or 24 month) forecast of the series. As a group, you must use two separate methods. One student will use an appropriate extrapolation method, which is usually an exponential smoothing method. The other student will use a causal regression model. You will present your results in a paper that should be analytically accurate and should clearly communicate your process to your manager.
The paper should be 8–10 pages in length, including tables and figures, and must include only these sections:
Title Page: Include company name, your name, and an appropriate “Table of Contents” (listing page numbers for the following sections).
Section 1 – Introduction: Why did you select this topic? How would this forecast be useful? To whom would it be useful? (1 page)
Section 2 – Literature Review: Present information about the company and industry. This section is not about forecasting methods (1 or 2 pages).
Section 3 – Managerial Overview of Methods Used: Why did you select these forecasting methods? Explain why you believe the technique you have chosen is appropriate to forecast your data (1 or 2 pages).
Section 4 – Application of Forecasting Methods and Results: What are the forecast results of these methods? Which method performs better? How did you evaluate the forecasting methods? Present your forecast results and explain the methods you used to evaluate your forecast results (2 to 4 pages).
Section 5 – Conclusions and Limitations: (1 page)
Section 6 – References: Cite 6 to 8 references related to the company selected (1 page).
Appendix: Include one or more appendices containing appropriate graphics and a complete professional listing of data with appropriate citations. All graphs in the appendix must be referenced in the body of your paper along with the page on which each graph can be found.
The paper should be typed, single-spaced, and presented in 14-point Times New Roman font.
Excel File Requirements
When you submit your paper, you must also submit an Excel file including your data and analysis.
Tab 1 – Basic Data: Show the dates in column A and the sales data in column B.
Tab 2 – Extrapolation Model: Show the data you used for your extrapolation method with the dates in column A, the sales data in column B, and the predicted values for that method in column C.
Tab 3 – Regression Model: Show all the data used in the regression model with dates in column A and the sales data in column B. The next columns in Tab 3 should include all the independent variables used in your regression model. Following these columns, you should add a column containing the values predicted by the regression analysis.
Tab 4 – Final Forecasts: The fourth and final tab should have the dates in column A, the original sales data in column B, the predicted values from your extrapolation forecast in column C, and the predicted values from your regression model in column D. The predicted values will extend 8 quarters (or 24 months) beyond the actual historic values.
Discussion
You are required to read, reflect on, and respond to at least one project paper. You will post your contribution to the topic “Projects” on the Discussion Board. Your contribution to the discussion about papers should be clear, complete, and accurate. In your reflection on the paper, you should cover at least two of the following:
• Offer an additional method or variable(s) to include in a forecasting technique to predict sales. Please explain your reasons for the new method or variable you propose.
• Suggest ways in which a forecasting technique could be more clearly expressed.
• Identify passages where you think the writer misinterpreted, or incorrectly applied, a concept.
• Offer your assessment of the forecast results, and explain why you agree or disagree with the prediction.
Recommended Information Sources
Research Insight (RI): This database from Standard & Poor’s offers up to 20 years and up to 48 quarters of historical financial information on public U.S. and Canadian companies.
SEC’s EDGAR Database: The Securities Exchange Commission (SEC) maintains a database of SEC filings by public companies. The 10-K reports contain much of the same information found in annual reports and will be the most useful for this assignment.
Yahoo! Finance Company and Fund Index: This offers company profiles, financial information, and links to a range of resources.
Mergent Online and Factiva: These data sets offer company-level financial information. You can access the Mergent Online data set through the Texas Wesleyan Library.
Documentation
You should document print and online information sources. There is no universal formatting style for online sources, but you can use this example as a guideline:
Example: Author. (Year). Title, Type of medium
Submission
• Submit your paper in a Word document.
• Present your data and analysis in an Excel file.

Don't use plagiarized sources. Get Your Custom Essay on
Hasbro, Inc securities exchange data analysis Assignments | Custom Essay Help
Just from $13/Page
Order Essay
Acme Writers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.