Forecasting and Risk Modelling Report: Wells Fargo Stock Analysis

This report presents an analysis of Wells Fargo stock using the Autoregressive Integrated Moving Average (ARMA) model for time series prediction. The study, conducted using Eviews software, examines historical data from the Bloomberg database to forecast stock prices and assess investment opportunities. The report provides an overview of Wells Fargo, including its business operations, earnings, and stock performance, along with a literature review of relevant forecasting techniques. It explores the use of ARMA models for short-term stock price prediction and discusses the process of testing for stationarity, identifying model parameters, and forecasting. The report also investigates the application of an EGARCH model and provides an out-of-sample forecasting analysis. Ultimately, the research aims to evaluate the stock's potential for value investing and guide future investment decisions based on the model's predictive capabilities. The report concludes with insights on the stock's performance and its suitability for value investors.

0
Running head: FORECASTING AND RISK MODELLING
Forecasting and risk modelling
Name of the student
Name of the university
Student ID
Author note

1
FORECASTING AND RISK MODELLING
Executive summary
In the finance and economics study, stock prediction is an essential factor for the interest
of the researchers and to make various predictive models. In this research paper the
Autoregrassive integrated moving average, ARMA model has been incorporated for the time
series prediction. This paper also represents the predictive model for the stock price expectation
by using the ARMA method. For this Eviews software is used to analyse the data. The stock has
been selected that is Wells fargo listed in NYSE, Newyork Stock Exchange. Data is extracted
from the Bloomberg database. The consequence that are so obtained from ARMA model, which
has a robust and potential prediction in a short term basis is so favaorable with the existing
mechanism.

2
FORECASTING AND RISK MODELLING
Table of Contents
Introduction......................................................................................................................................3
Overview of the stock......................................................................................................................4
Business keep stagecoach rolling....................................................................................................4
Wells fargo earnings........................................................................................................................4
Stock analysis of Wells Fargo.........................................................................................................5
A boosts in WFC stock....................................................................................................................6
Rating of Wells Fargo stock............................................................................................................7
Reason of decreasing:......................................................................................................................7
Recovery from the current crisis scenario.......................................................................................7
Welss Fargo- Value invest stock?....................................................................................................8
PE ratio............................................................................................................................................8
Bottom line....................................................................................................................................10
Literature review............................................................................................................................11
Testing and ensuring stationary.....................................................................................................12
Identification of p and q.................................................................................................................13
Estimation and Forecasting............................................................................................................13
Optimal ARMA with a stationary error term................................................................................15
Optimal ARMA with EGARCH model.........................................................................................16

3
FORECASTING AND RISK MODELLING
Out of sample forecasting..............................................................................................................18
Fitted values...................................................................................................................................20
Conclusion:....................................................................................................................................21
Reference.......................................................................................................................................22

4
FORECASTING AND RISK MODELLING
Introduction
This paper study about a stock listed on New York Stock Exchange (NYSE), Wells
Fargo. The primary goals of this paper is to investigate the possible investment oppertunitiers,
logically worth of the takis risk and benefits and make an educated investment position. A
critical analysation of understanding the risk and opportunities for high return which is offered in
the investment opportunity through the effortless research and analysis. The derive knowledge
from this paper is to guide the future selection and implimentation of intelligent investment.
A 10 years daily data has been used for the investment purpose this investments tested
several researched and also help in understanding of the stock market in general. Through this
study experience identify and anticipates the market trends and influenced the future investment
decision.
This paper also analyse the statistical analysis of time series, auto regressive moving
average, ARMA model (Isufi et al 2016), it provides a report of a weekly stochastic process in
terms of two polynomials, one for the autoregression (Efendi, Arbaiy and Deris 2018) and
another for the moving average. Generally it is reported in this paper that can be done from two
perspectives: statistical and artificial intelligence techniques (Raedt et al 2016). It is also known
to a robust and efficient “financial time series” allows to forecast short term prediction than the
most popular ANN techniques. In this paper a short term stock price prediction process
(Rounaghi and Zadeh 2016) has been presented by ARMA model. By refering this reserach
paper an investor must evaluate a short term prediction that leads an investment decision making.

5
FORECASTING AND RISK MODELLING
Overview of the stock
Wells fargo and Company is an american and multinational financial services
organizations, which having the headquarter in San Fransisco, in the context of full market
capitalization, Wells fargo is the fourth largest bank. It is listed on the New York Stock
exchange.
There are several reasons to choose this stock-
Business keep stagecoach rolling
In case of community banking (Lux and Greene 2015), it serves the consumers and the
small enterprises, savings account and as well as credit and debit cards.
Wells fargo earnings
In the fourth quarter, Well Fargo received 60 cents per share or 93 cents when leagal
costs are excluded. It has dropped 23% year on year as per the next revealing data. Therefor the
stock has managed to post revenue of 19.9 dollar, which was better than the expected $19.81
billion.
A revenue fell around 8% of the community banking, that is all about to &10.52 biolion
which is driven by the lower interest income. Wholesale banking revenue droped 5% to 6.56
billion dollar. Wealth and investment management (Hastings and Mitchell 2020) revenue grew
3% to 4.07 billion dollar.

6
FORECASTING AND RISK MODELLING
Stock analysis of Wells Fargo
It has been projected more than 47% of its value for the Wells fargo stock in 2020. As per
the analysis of Market Smith, it shows a stock gapped down in the following weak Q4 results, it
has again shown a plunging during this month after a hard trading and it has been sinking like a
stone.
For the recent times the big bank stocks are facing a massive trouble, outperforming the
S&P 500 index over the long run, in case of Wells Fargo stocks it has tendency of slow motion
or laggard, but in a long run it will be a leading stock (Drakopoulou 2016).
Recently WFC stock has IBD Composite Rating of 16. The measuring tool has shown
that Wells fargo earnings are better than the performance of its stock market. A Can Slim
investing system is required for 25% quarterly growth.

7
FORECASTING AND RISK MODELLING
In the recent reaserch, the several analyst has expected that the Wells fargo stock has
been sink 12% in 2020, but it will show growth around 12% in 2021. It will be moving up from
its lower base.
A boosts in WFC stock
In the mid 2019, Timothy Solan was stepped down after struggleing to make a clean
image of bank. Solan was replaced on an interim basis by the general counsel, C. Allen Parker. It
can be seen that A new CEO can revive a struggeling company. As per Martinez who ranks the
Wells Fargo as neutral, it is more needs to be done to assure there is a more than a short term
price boost. Moreover such improvement will not happen overnight it takes a long time.
Rating of Wells Fargo stock
As per the CFRA research, recommend the WFC stocks as hold, the target price is 42 but
it will move slight down because of its plunging.

8
FORECASTING AND RISK MODELLING
Due the speared of corona virus in all over the world as decleared by The World Health
Organization in the end of January besides of all other stocks WFC stock has lost 36 percent of
its value (Yan et al 2020).
Reason of decreasing:
It has fallen because the situation on the ground has changed. It has a sizable loan
portfolio of around $399 billion in the community loans and the commercial loan is 456 billion
dollar. In the year 2019, the commercial bank and the community bank both are generated 72%
of the banks revenue, which implies that the banks is heavily dependent on the segments. On the
other view, it can expect that the business could suffer a loss due to accumulated effect of less
consumer demand, disruption of supply chain and the global economic slowdown (Hall 2016).
Recovery from the current crisis scenario
Knocking the mind that, although the WFC stock has fallen 36% this time but it is lower
as compared to 2008 recession, it was around 65%. The research assures and expect, once the
economic scenario is getting improved the WFC stock will show better by 25%. This will be
marked at empirical recovery of 46 dollar. This stock was gained a global momentum before the
coronavirus outbreak.
Welss Fargo- Value invest stock?
This study can use some methods to evaluate whether the WFC stocks can be value
investing or not.

9
FORECASTING AND RISK MODELLING
PE ratio
Often the value investors looks at the price earning ratio (PE ratio) (Arkan 2016). It
simply can describes that how much an investors are wish to pay for each dollar of earnings in a
given stock. In this line Wells Fargo has twelve months PE ratio of 9.84 as you can see in the
chart below.
This level is actually compares with the market, as the PE ratio of the S&P 500 is 17.8. if
we concentrate the PE of Wells Fargo, we can see the current PE stands on the mid point over
the past five years.

10
FORECASTING AND RISK MODELLING
Apperently the selection of WFC might be a good option for the value investors (Otuteye
and Siddiquee 2015). There are also other factors to be considered before investing in this stock.
It had an impact of its current consensus as the current quarter consensus estimates has decreased
3.3% in the past two months, on the other hand the full year estimation was 4.4% approximately.
The below mentioned chart shows the consensus estimation trend and recent price action for the
stock:

11
FORECASTING AND RISK MODELLING
Though the bearish trend is shown but we can except an in line performance in the near term
future.
Bottom line
Wells fargo stocks is an impacable selection for the value investors. Though on the
ranking basis it is hard to get too excited about this company, however over the two years, the
industry has performed not very well, therefore the value stockholder can wait. A favourable
industry factor can boost up this stock and once it will happen the stock will fly straightway.