Evaluate the forecast accuracy of the three methods

Assignment Help Financial Accounting
Reference no: EM131396936

In the pharmaceutical industry select Pfizer, whose common stocks are traded in the US stock markets as your target company. Acquire the company's balance sheet and income statement for the most recent sixteen consecutive quarters.

Directions:

1. Based on the company's consolidated balance sheets and income statements, compile the 16 quarters of selected financial data that you chose for the project. These financial variables are: A ( from consolidated statements of earnings) Sales/revenues, Selling, marketing and administrative expenses, Research expenses, Net Earnings, and B (from consolidated balance sheets) Cash & cash equivalents, Total current assets, Total assets, Total current liabilities, Total liabilities, Total shareholders' equity.

2. Give a concise description of the company in your own words: its history, mission, and future opportunities (3 or 4 paragraphs).

3. Present and describe the sales/revenue data of the company. You may want to use a scatter-gram to display the time patterns of the sales/revenue.

4. Make sales/revenue forecasts for the next two quarters by using the following methods:

a. The Naïve Method

b. Single moving average (let N=4)

c. Single exponential smoothing (let a=0.4)

5. Evaluate the forecast accuracy of the three methods in item 4, by analyzing the magnitudes of errors, i.e. range of errors, MAE (Mean of Absolute Errors), and MSE (Mean of Squared Errors) of each method.

Reference no: EM131396936

Questions Cloud

Find a possible equation for the line : Find a possible equation for the line that is perpendicular to the graph of 5x-3y=15 if the two lines intersect at x=30.
What is the sample size n : Based on a sample of restaurants in a large city, the frequencies are found to be f1 = 5, f2 = 8, f3 = 20, f4 = 32, and f5 = 23. What is the sample size, n? Verify that the sample mean is X¯ = 3.7
Disadvantages of purchasing new packaged software : Discuss your findings as a team, compile them into a report, and submit the report to your instructor.
Find the angles : Two angles are said to be supplementary if their sum is 180 degrees. Suppose you have two supplementary angles such that the second angle is 12 degrees larger than 5 times the measure of the first angle. Find the angles.
Evaluate the forecast accuracy of the three methods : In the pharmaceutical industry select Pfizer, whose common stocks are traded in the US stock markets as your target company. Evaluate the forecast accuracy of the three methods in item 4, by analyzing the magnitudes of errors, i.e. range of errors, ..
Quality of managers and executive coaches : Which of the following is a quality of managers? Executive coaches:
What is the minimum number of participants : Among a sample of 25 participants, what is the minimum number of participants that must be altered to make the sample variance arbitrarily large?
Evaluate the effectiveness of the firms stakeholder in event : Imagine that the company that you researched uses a third-party accounting system. Evaluate the effectiveness of the firm's stakeholder in the event that a third-party accounting system suffers a breach.
How often are the intervals set to take readings : How often are the intervals set to take readings and then evaluate the data? Write a report summarizing your findings, and include a table of links to Web sites that provide additional details.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd