Preview

Time Series Analysis

Powerful Essays
Open Document
Open Document
1874 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Time Series Analysis
This paper is a report on the time-series analysis of continuously compounded returns for Ford and GM for the periods January 2002 till April 2007 using monthly stock prices. This analysis is aimed at estimating the ARIMA model that provides the best forecast for the series. This paper will be divided into 2 sections; the first section showing the Ford analysis and the second the GM analysis.
Section 1: Ford
Figure 1: Time series plot for raw Ford data.

Figure 1 shows a time series plot of the raw Ford stock prices against time. From this plot, a gradual but continuous upward trend can be observed. This trend was disrupted in 2005 when the stock prices experienced a huge rise moving from below 5 to above 25. This rise in stock price by Ford was not sustained as can be seen from the plot; the prices which reached a peak of above 25 fell to a about 10 by the end of 2005 and fell further in 2006 to a level below 5 fluctuations in the stock price existed and in 2007 the prices began to level out.
Raw data is likely to be affected by non-stationarity and this can result in bias in the analysis. For the purpose of this analysis, it is required that the returns be continuously compounded. To achieve this I have taken the log and first difference of the raw data: this also achieves stationarity in the time series data. Figure 2 shows the plot of these new values where Ford is the raw data, l_Ford is the log of the raw data and d_l_Ford is the first difference of the log data.
Figure 2 Using Box and Jenkins approach to estimate the best forecasting model requires 3 steps; identification, estimation and model checking. The aim is to choose a parsimonious model for forecasting. The table 1 below shows the values of the Akaike Criterion, Schwarz Criterion and Hannan-Quinn.
IDENTIFICATION
In this paper the Information Criteria will be used instead of the ACF and PACF. The information criteria include a function of the RSS and some penalty for

You May Also Find These Documents Helpful

  • Satisfactory Essays

    BUSI 405 Research Paper

    • 404 Words
    • 2 Pages

    The best model should be the one with the smallest error. Among these three time-series models, the decomposition with exponential smoothing trend has the smallest MAPE and RMSE for both historical period and holdout period. Therefore, we use this model and the data from January 2001 to October 2011 to perform the ex-ante point and interval forecasts for the next 14 months as shown in table 2 and figure 4.…

    • 404 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    As a result of its first earnings miss in two years, Ford (F, Fortune 500) shares fell more than 12% in midday trading. Still, even with that sell-off, shares are up more than 40% over the course of the past 12 months.…

    • 844 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Lee, C.A, Lee C. J. & Lee, F. C. (2009) “Financial Analysis, Planning and Forecasting. Theory and Application. Second Edition. World Scientific Co. Pte. Ltd. Copyrighted material.…

    • 871 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Ford Motor Company Case

    • 1266 Words
    • 4 Pages

    It is important to note that although Ford holds the highest amount of cash, both Ford’s earnings per share of 5.86 and stock price of $51.38 are lower than General Motors and DaimlerChrysler in 1999. Ford’s higher debt to equity ratio during this period may be the reason that caused the company’s cost of capital to increase and eventually decreasing the stock price.…

    • 1266 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    Altavox Case Study

    • 3482 Words
    • 14 Pages

    Next consider using a simple exponential smoothing model. In your analysis, test two alpha values, .2 and .4. Use the same criteria for evaluating the model as in question 1. Assume that the initial previous forecast for the model using an alpha value of .2 is the past three-week average. For the model using an alpha of .4 assume that the previous forecast is the past five-week average.…

    • 3482 Words
    • 14 Pages
    Better Essays
  • Satisfactory Essays

    time series

    • 254 Words
    • 2 Pages

    It is January 2nd, 2014 and Google Inc. (GOOG) stock is currently trading on the Nasdaq at a price of $1,105.00 US dollars. Using the information provided below, please answer the following questions:…

    • 254 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    [2] Wilson, J. Holton, and Barry Keating. Business forecasting: with forecastX. 6. ed. Boston: McGraw-Hill/Irwin, 2009. Print.…

    • 2282 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Trend Analysis

    • 1705 Words
    • 5 Pages

    In terms of the levels of TCA and PCA, Louie Ltd. employs a conservative financing method with a marketable securities approach in financing its shot-term debt. This tells us that their PCA is financed by long-term debt, such as new equity issued, which we can see that their shareholder equity has increased consistently over the periods. On the other hand, a portion of short-term debt and a portion of market securities, which are Associated Coys, to fund its TCA.…

    • 1705 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Suppose you (or your group) are the manager of a company trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecasts for each given forecasting method and then choose the best one to do the forecasts for the future.…

    • 405 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    The purpose of this report is to examine the external factors affecting Ford Motor Company within the last four years. Dr. John L. Waltman has authorized this report. It is based on secondary sources, mainly gathered through the First Search Periodical Index. Authorized Publication includes Wall Street Journal, Financial Times, New York Times, and sources from the Internet. This report examines and analyzes these three external factors:…

    • 1701 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    tesla

    • 20024 Words
    • 316 Pages

    North America Equity Research 22 September 2014 US Automakers See Attractively Deep Value in GM As We Roll Out 2016 Estimates for US Automakers; Like Ford; Cautious on TSLA We introduce our 2016 estimates and roll-forward valuation for GM and Ford, finding +50% upside in the case of General Motors and +32% in the case of Ford. Our established 2015 price targets increase on newly considered 2016 earnings rather than 2015 in our valuation analysis and on capital structure roll-forward as the firms generate sizable cash flow. 2016 earnings are expected to rise relative to 2015, on industry tailwinds (continued trend toward more normal volumes in Europe, cycling past a period of atypically strong macro headwinds in South America, robust growth in China, and continued cyclical increase in North America even if at a lesser rate) as well as various different self-help initiatives (e.g., as restructurings in Europe, Australia, and elsewhere take further hold, and on cost control efforts in North America). We reiterate our Overweight ratings on both GM and Ford, seeing more value in automaker stocks than in supplier stocks generally, on earnings that are growing almost as quickly as the average supplier over our newly extended forecast window (and at least as structurally improved relative to history) but valuation which is only in line with historical average (Ford) or even significantly below (GM).…

    • 20024 Words
    • 316 Pages
    Powerful Essays
  • Good Essays

    In order to fully answer the research question, I have extended the linear trend line to estimate…

    • 846 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Statitics Time Series

    • 27070 Words
    • 109 Pages

    Business Statistics I: QM 1 Lecture N otes by Stefan W aner (5th printing: 2003) Department of Mathematics, Hofstra University BUSINESS STATISTCS I: QM 001 (5th printing: 2003) LECTURE NOTES BY STEFAN WANER TABLE OF CONTENTS 0. Introduction................................................................................................... 2 1. Describing Data Graphically ......................................................................…

    • 27070 Words
    • 109 Pages
    Good Essays
  • Powerful Essays

    Dsc2008 Assignment

    • 2626 Words
    • 11 Pages

    Fig 1.1 shows a gentle decline in prices from 15 Mar ‘02 to 15 Jan ’09, and an increasing trend afterwards. Irregularities in the overall trend are due to external factors such as the consumer demand for cars and the overall state of the economy.…

    • 2626 Words
    • 11 Pages
    Powerful Essays
  • Satisfactory Essays

    Cyclical Variation – the rise and fall of a time series over periods longer than…

    • 335 Words
    • 4 Pages
    Satisfactory Essays

Related Topics