Analyzing Financial Data

The provided content appears to be a collection of dates, numbers, and mathematical operations performed on those numbers. The numbers seem to represent some type of financial or economic data, possibly related to stock prices or investments. There are also dates ranging from May 28th, 2018, to December 24th, 2018, which may indicate the time period during which these calculations were performed.

Running Head: Financial Analysis
FINANCIAL ANALYSIS

Financial Analysis 2
Table of Contents
1. Formulation of a mini case of a hypothetical company...............................................................3
2. Analysis of Ford Motor Company and Tesla, Inc.......................................................................8
a. Betas of Ford Motor Company and Tesla Inc..........................................................................8
b. Calculation of return of stock...................................................................................................8
c. Calculation of the risk of stocks...............................................................................................9
d. Comparison between Ford Motor Company and Tesla, Inc..................................................10
e. Calculation and Comparison between Ford Motor Company and Tesla, Inc........................10
Reference List................................................................................................................................16
Appendices....................................................................................................................................18
Appendix 1.................................................................................................................................18
Appendix 2.................................................................................................................................21

Financial Analysis 3
1. Formulation of a mini case of a hypothetical company
Elliott Fashion Private Limited is a garment manufacturing company which is located in
Australia. The company is highly capable of manufacturing high quality fashion garments by
using top-notch fabric and ultra-modern designs. The company uses to manufactured and retail
its products in the domestic market of Australia. It is famous for fast-fashion clothing items for
women, teenagers, men, and children. Within Australia, Elliott Fashion Private Limited sells its
products through ten retail outlets and two factory outlets that are solely operated by it. Besides
this, the company also retails its clothing items through supermarkets and retail chains. The
company is very much committed to deliver standard quality clothing items at an affordable
price without compromising with the quality and style of the products. It is aimed to expand its
garment business in and around the major cities of Australia and for long-term it is intended to
enter into some of the flourishing markets in Asia like India, Singapore, and China. The
company's stocks are valued at a satisfactorily due to its steady growth in terms of profit
generation and increasing goodwill.
The company has raised finance by issuing shares as well as bonds. For meeting annual
finance need, it uses to reinvest its profit it uses to retain every year after making required
payments to its shareholders and creditors. The stocks of Elliott Fashion are upwards moving
which ROA and EPS of the company stand stronger and upwards moving compared to some
same line companies. Current valuation of the company’s stocks makes potential investors to
invest in the company. The company has issued some bonds for raising external finance
and valued them by determining the faire value of those bonds. Cost of capital of Elliot is low
due to the presence of a number of market opportunities for the company, less inflation and less
business risks. Furthermore, the growth seeking investment policy, suitable capital structure
policy and well-maintained dividend policy of Elliot Fashion help it to make its cost of capital
less than some of its competitor companies. In future, the company has a plan to expand its
business by entering into new business venture and by opening a new business unit. In order to
do so, Elliot Fashion is expected to use capital budgeting techniques.

Financial Analysis 4
Questions and Answer on the following topics:
Stock Valuation
Question 1
What is the reason behind valuing stock?
Answer: In order to predict the future price of shares or potential market price of shares
stock valuation is done. It aimed to help the investors make their decision to make an investment
in a company through purchasing that company's shares.
Question 2
How stock valuation is done?
Answer: For calculating stock valuation current intrinsic value of a company’s stock is
multiplied by that company's projected EPS (earnings per share).
Question 3
What are the methods of stock valuation?
Answer: There are two types of stock valuation method such as absolute method and
relative method. The absolute method of stock valuation includes two types of valuation methods
such as the DDM (dividend discount model) and DCF (discounted cash flow model). On the
other side, relative stock valuation is done by calculating the major financial ratios of the same
line companies. Relative stock valuation stands as comparative analysis of companies on the
basis of their financial ratios like ROA (Return on Assets), EPS (earnings per share) and more
(corporatefinanceinstitute.com, 2019).
Bond valuation
Question 1

Financial Analysis 5
What is bond valuation?
Answer: Bond valuation refers to a technique by using which a specific bond’s
theoretical fair value is determined. Bond valuation uses to include the calculation of
present values of the future interest payment attached to a bond, and the value of a bond upon
maturity which is known as par value or face value of a bond.
Question 2
What is the reason behind bond valuation?
Answer: Bond valuation is done for determining the accurate PV (present value) of a
bind and for making an informed decision regarding investment.
Question 3
What are the steps of bond valuation?
Answer:
Step 1: Making an estimation of the expected cash flows.
Step 2: Determination of the appropriate rate of interest which is required to be used for
discounting the expected cash flows.
Step 3: Calculation of the PV (present value) of the expected cash flows (computed in
step -1) by using the interest rate calculated in step – 2 (efinancemanagement.com, 2019).
Cost of capital
Question 1
What stands as the cost of capital for an organisation?
Answer: Cost of capital is comprised of the cost of equity and cost of debt both that are
used by a company for financing its business. Cost of capital of a company depends on the

Financial Analysis 6
financing type a company chooses for financing its business. It refers to an opportunity
cost attached with a particular investment. Cost of capital is a rate of return which could be
earned by an investor if he/she makes the same amount of investment in another investment
option that includes equal risk.
Question 2
Why the cost of capital matters?
Answer: Cost of capital is a vital component in the task of valuing a business. It is often
used as the discount rate for calculating the fair value of the cash flows an investment delivers. It
helps investors to gauge the risk of investing in a company’s shares and it is necessary to
calculate for making decisions on capital budgeting. It helps to frame an appropriate credit policy
and to evaluate investment options. Furthermore, cost of capital is also played a vital role in
designing an optimum capital structure for a company (businessjargons.com, 2019).
Capital Budgeting
Question 1
What is capital budgeting?
Answer: Capital budgeting refers to a process by applying which a company uses to
determine and evaluate the potential investments or large expenses required to incur for a
proposed investment. These investments and expenditures include large capital projects such as
investing in one or more long-term venture(s), constructing a new office building or plant or
installation of any heavy machineries for new plat or existing production plant and more. Capital
budgeting is also called investment appraisal by using which a company compares between two
or more investment options and then select one out of them which it found more profitable than
the other options.
Question 2

Financial Analysis 7
What are the benefits of capital budgeting?
Answer: Capital budgeting decisions help a company to evaluate a proposed project by
considering the expected outcome (monetary in form) of the project. It also helps to evaluate
expenditure related decisions which are involved in the current outflow of funds, to understand
risk and efforts, let the company control its expenditure and abstain a company from under and
over-investment.
Question 3
What are some of the commonly applied capital budgeting techniques?
Answer: Capital budgeting methods are sub-divided into two segments such as
traditional method and modern or discounting method. Under the traditional method, capital
budgeting is done by calculating the payback period, accounting rate of return, and post-payback
period. On the other hand, modern or discounting method of capital budgeting includes
calculation of net present value (NPV), internal rate of return (IRR) and profitability index.

Financial Analysis 8
2. Analysis of Ford Motor Company and Tesla, Inc.
a. Betas of Ford Motor Company and Tesla Inc.
Betas (3 years monthly) of the above stated two companies are -
Ford Motor Company = 0.97 (finance.yahoo.com, 2019)
Tesla, Inc. = 0.03
Interpretation of Beta values
Beta stands as a measure of a company’s stock’s systematic risk or volatility compared to
the prevailing unsystematic risk in the entire market from where the company belongs. Beta
value is used to calculate the ERR (expected rate of return) of an asset under CAPM (capital
asset pricing model) and calculated the expected market return in relation to the asset.
The Beta value of Ford Motor Company, it is required to state that the stock of the
company does not swing more than the market over time and due to this, its Beta stands less than
1.0. It also represents that Ford’s stock(s) is less volatile in comparison to the market that means
investing in Ford is less risky than investing in other companies.
Similarly, the beta value of Tesla, Inc represents that the volatility of its stock is
extremely less in comparison to Ford’s stock as it stands at 0.03 and is very much more better
option for investors to invest in (finance.yahoo.com, 2019).
b. Calculation of return of stock
Formula to be used -
Here,

Financial Analysis 9
P0 = Initial price of stock
P1 = Ending price of stock
D = Dividend
For the calculated figure of stick return of Ford Motor Company, Refer to Appendix 1
For the calculated figure of stick return of Tesla, Inc., Refer to Appendix 2
c. Calculation of the risk of stocks
Assumptions: 20 shares to be purchased by investing USD500
For,
Ford Motor Company (for the last week of 2018)
Stock price dropped by USD 0.67
The loss or risk attached to stock due to the fall in stock price = (20*0.67) = USD13.4
Paid USD500 for purchasing 20 stocks (shares), i.e. the risk of stocks = USD (13.4/500) = 0.027
Tesla, Inc. (for the last week of 2018)
Stock price dropped by USD 28.13
The loss or risk attached to stock due to the fall in stock price = (20*28.13) = USD562.60
Paid USD500 for purchasing 20 stocks (shares), i.e. the risk of stocks = USD (562.60/500) =
1.12

Financial Analysis 10
d. Comparison between Ford Motor Company and Tesla, Inc.
According to the above stated calculations of the total stock return of Ford Motor
Company and Tesla, Inc. for during the financial year 2018, it is very often to mention that Ford
Motor Company is a better option to invest in. The reasons that make Ford Motor Company a
better company to invest in compared to Tesla, Inc. are its less risky stocks, better stock return,
and less volatility in stock price than Tesla, Inc. Overall, Ford Motor Company stands as a better
option to invest for the potential investors.
e. Calculation and Comparison between Ford Motor Company and Tesla, Inc.
Calculation of Ratio analysis
Ford Motor Company
Profitability Ratios
Year Net Profit
($) Revenue ($) Net Profit
Margin
2018 3,677,000 160,338,000 2.29
2017 7,731,000 156,776,000 4.93
2016 4,589,000 151,800,000 3.02
Year Gross Profit
($) Revenue ($) Gross Profit
Margin
2018 14,879,000 160,338,000 9.28
2017 16,558,000 156,776,000 10.56
2016 16,867,000 151,800,000 11.11
Year Net
Income
Total Assets
($)
Return on
Assets

Financial Analysis 11
($) (ROA)
2018 3,677,000 256,540,000 1.43
2017 7,731,000 258,496,000 2.99
2016 4,589,000 237,951,000 1.93
Year Net Income
($)
Shareholder'
s Equity ($)
Return on
Equity (ROE)
2018 3,677,000 35,932,000 10.23
2017 7,731,000 35,578,000 21.73
2016 4,589,000 29,170,000 15.73
Liquidity Ratios
Year Current
Assets ($)
Current
Liabilities
($)
Current Ratio
2018 114,649,000 95,569,000 1.12
2017 116,801,000 94,600,000 1.23
2016 108,461,000 90,281,000 1.20
Year Current
Assets ($)
Inventories
($)
Current
Liabilities
($)
Current
Assets -
Inventorie
s
Quick
Ratio
2018 114,649,000 11,220,000 95,569,000 103429000 1.08
2017 116,801,000 11,176,000 94,600,000 105625000 1.12
2016 108,461,000 8,898,000 90,281,000 99,563,000 1.10
Debt Ratio

Financial Analysis 12
Year
Total
Liabilities
($)
Shareholder'
s Equity ($)
Debt to
Equity
2018 220,474,000 35,932,000 6.14
2017 222,792,000 35,578,000 6.26
2016 208,668,000 29,170,000 7.15
Tesla, Inc
Profitability Ratios
Year Net Profit
($) Revenue ($) Net Profit
Margin
2018 -976,091 21,461,268 -4.55
2017 -1,961,400 11,758,751 -16.68
2016 -674,914 7,000,132 -9.64
Year Gross Profit
($) Revenue ($) Gross Profit
Margin
2018 4,042,021 21,461,268 18.83
2017 2,222,487 11,758,751 18.90
2016 1,599,257 7,000,132 22.85
Year
Net
Income
($)
Total Assets
($)
Return on
Assets
(ROA)
2018 -976,091 29,739,614 -3.28
2017 - 28,655,372 -6.84

Financial Analysis 13
1,961,400
2016 -674,914 22,664,076 -2.98
Year Net Income
($)
Shareholder'
s Equity ($)
Return on
Equity (ROE)
2018 -976,091 4,923,243 -19.83
2017 -1,961,400 4,237,242 -46.29
2016 -674,914 4,752,911 -14.20
Liquidity Ratios
Year Current
Assets ($)
Current
Liabilities
($)
Current Ratio
2018 8,306,308 9,992,136 0.83
2017 6,570,520 7,674,740 0.86
2016 6,259,796 5,835,789 1.07
Year Current
Assets ($)
Inventories
($)
Current
Liabilities
($)
Current
Assets -
Inventorie
s
Quick
Ratio
2018 8,306,308 3,113,446 9,992,136 5192862 0.52
2017 6,570,520 2,263,537 7,674,740 4306983 0.56
2016 6,259,796 2,067,454 5,835,789 4,192,342 0.72

Financial Analysis 14
Debt Ratio
Year
Total
Liabilities
($)
Shareholder'
s Equity ($)
Debt to
Equity
2018 23,426,010 4,923,243 4.76
2017 23,023,050 4,237,242 5.43
2016 16,758,951 4,752,911 3.53
Interpretation to ratios calculated above
Profitability ratios like net profit margin ratio, gross profit margin ratio, ROA and ROE
denotes a company’s profitability or financial health (Heikal, Khaddafi & Ummah, 2014). These
ratios help to assess the ability of a company to earn profit relative to its annual revenue, assets,
operating costs, and shareholders' equity over a specific period of time (Babalola & Abiola,
2013).
Liquidity ratios (current ratio and quick ratio) are the financial metrics that help to
determine the ability of a company to pay off its current financial obligations arises due to debt
without raising any kind of external finance. These ratios indicate whether a company has
sufficient current assets to meet its current liabilities or not (Ehiedu, 2014).
Debt ratio like Debt-to-Equity ratio is used for determining the overall financial risk a
company, as well as its shareholders, uses to face (Kamar, 2017).
Comparison between financial performance of Ford Motor Company and Tesla, Inc.
As per the net profit margin, ROA and ROE ratio, Ford Motor Company is performing
far better than Tesla, Inc as all these three ratios of Ford stand higher than Tesla. The gross profit
margin ratio of Tesla Inc is better than Ford but due to its huge operating cost, it has faced net

Financial Analysis 15
loss for each of the past three financial years which led it to face negative net profit margin,
ROA and ROE ratio. In terms of liquidity position, Ford is again better than Tesla as for the past
three financial years Ford is seen to have current and quick ration more than 1 whereas for Tesla
it stand less than 1 expect for 2016. The liquidity ratios reflect that Ford is much stronger than
Tesla in meeting its current financial obligations by utilizing its current assets (Delen, Kuzey &
Uyar, 2013). Debt to equity ratio of Ford stands higher than Tesla which indicates that Ford is
incapable of generating enough cash for satisfying its obligations arise from debt. On the other
hand, low D/E ratio of Tesla is less than Ford but it does not support Tesla’s positive financial
performance as it has failed to generate positive profit from business during the past three
financial years (Pratama & Erawati, 2014). Overall, Ford Motor Company is much better option
to invest as its financial performance is much stronger than Tesla in almost every financial aspect
(Xu et al. 2014).

Financial Analysis 16
Reference List
Babalola, Y. A., & Abiola, F. R. (2013). Financial ratio analysis of firms: A tool for decision
making. International journal of management sciences, 1(4), 132-137.
Businessjargons.com. (2019). Cost of Capital. Retrieved on 15th January from
https://businessjargons.com/cost-of-capital.html
Corporatefinanceinstitute.com. (2019). What is stock valuation? Retrieved on 15th January from
https://corporatefinanceinstitute.com/resources/knowledge/trading-investing/stock-
valuation/
Delen, D., Kuzey, C., & Uyar, A. (2013). Measuring firm performance using financial ratios: A
decision tree approach. Expert Systems with Applications, 40(10), 3970-3983.
Efinancemanagement.com. (2019). Bond Valuation. Retrieved on 15th January from
https://efinancemanagement.com/investment-decisions/bond-valuation
Ehiedu, V. C. (2014). The impact of liquidity on profitability of some selected companies: the
financial statement analysis (FSA) approach. Research Journal of Finance and
Accounting, 5(5), 81-90.
Finance.yahoo.com. (2019). Ford Motor Company (F). Retrieved on 15th January from
https://finance.yahoo.com/quote/F/balance-sheet?p=F
Finance.yahoo.com. (2019). Tesla, Inc. (TSLA). Retrieved on 15th January from
https://finance.yahoo.com/quote/TSLA/financials?p=TSLA
Heikal, M., Khaddafi, M., & Ummah, A. (2014). Influence analysis of return on assets (ROA),
return on equity (ROE), net profit margin (NPM), debt to equity ratio (DER), and current
ratio (CR), against corporate profit growth in automotive in Indonesia Stock
Exchange. International Journal of Academic Research in Business and Social
Sciences, 4(12), 101.
Kamar, K. (2017). Analysis of The Effect of Return on Equity (ROE) and Debt to Equity Ratio
(DER) on Stock Price on Cement Industry Listed in Indonesia Stock Exchange (IDX) in
The Year of 2011-2015. IOSR Journal Of Business and Management, 19(5), 66-76.

Financial Analysis 17
Pratama, A., & Erawati, T. (2014). Pengaruh current ratio, debt to equity ratio, return on equity,
net profit margin dan earning per share terhadap harga saham (study kasus pada
Perusahaan Manufaktur yang terdaftar di Bursa Efek Indonesia periode 2008-
2011). Jurnal akuntansi, 2(1), 1-10.
Xu, W., Xiao, Z., Dang, X., Yang, D., & Yang, X. (2014). Financial ratio selection for business
failure prediction using soft set theory. Knowledge-Based Systems, 63, 59-67.

Financial Analysis 18
Appendices
Appendix 1
Date Open High Low Close
Adj
Close Volume
Stock
Return
12/25/2017 null null null null null null
(P0 - P1)
+ D
{(P0 - P1) +
D} / P0
1/1/2018 12.52 13.22 12.5 13.2
11.83928
9 134139000 -0.53 -
0.042332268
1/8/2018 13.21 13.29 12.96 13.23
11.86619
7 203591000 0.13 0.00984103
1/15/2018 13.31 13.48 11.91 12
10.76299
1 302662400 1.46 0.109691961
1/22/2018 12.02 12.09 11.44 11.65 10.44907 335366200 0.52 0.043261231
1/29/2018 11.42 11.47 10.62 10.71 9.605968 278491900 0.86 0.07530648
2/5/2018 10.78 11.04 10.19 10.53 9.567714 450831200 0.4 0.037105751
2/12/2018 10.67 10.82 10.5 10.61 9.640402 183047800 0.21 0.01968135
2/19/2018 10.58 10.75 10.55 10.7 9.722178 110852000 0.03 0.002835539
2/26/2018 10.74 10.99 10.14 10.4 9.449594 248314500 0.49 0.045623836
3/5/2018 10.31 10.73 10.3 10.73 9.749436 158679200 -0.27 -
0.026188167
3/12/2018 10.69 11.44 10.68 11.15
10.13105
4 298572500 -0.31 -
0.028999065
3/19/2018 11.15 11.19 10.51 10.56 9.594972 238518100 0.74 0.066367713
3/26/2018 10.74 11.13 10.68 11.08
10.06745
1 175130500 -0.19 -
0.017690875
4/2/2018 11.06 11.38 10.7 11.18
10.15831
3 191632900 0.03 0.002712477
4/9/2018 11.25 11.55 11.2 11.28 10.24917 194318500 0.12 0.010666667

Financial Analysis 19
4
4/16/2018 11.36 11.48 10.78 10.82 9.831212 204020400 0.69 0.060739437
4/23/2018 10.84 11.56 10.83 11.49
10.58005
4 225970300 -0.5 -
0.046125461
4/30/2018 11.53 11.73 10.97 11.36
10.46035
1 240371700 0.32 0.027753686
5/7/2018 11.36 11.44 11.02 11.19
10.30381
3 148857900 0.32 0.028169014
5/14/2018 11.23 11.48 11.06 11.33
10.43272
6 128464700 0.05 0.00445236
5/21/2018 11.42 11.65 11.33 11.51
10.59847
1 130506300 0.06 0.00525394
5/28/2018 11.6 11.77 11.36 11.71
10.78263
2 153848300 0.04 0.003448276
6/4/2018 11.74 12.15 11.68 12.1
11.14174
7 162974500 -0.21 -
0.017887564
6/11/2018 12.1 12.15 11.8 11.88 10.93917 201050000 0.37 0.030578512
6/18/2018 11.82 12.05 11.62 11.65
10.72738
4 174756300 0.32 0.027072758
6/25/2018 11.63 11.67 11.03 11.07
10.19331
7 188526500 0.71 0.061049011
7/2/2018 11.02 11.15 10.91 11.06 10.18411 112092800 0.11 0.009981851
7/9/2018 11.1 11.26 10.91 10.98
10.11044
4 138765100 0.27 0.024324324
7/16/2018 10.95 10.97 10.51 10.56 9.723706 202001100 0.54 0.049315068
7/23/2018 10.56 10.74 9.84 9.93 9.272141 324806800 0.78 0.073863636
7/30/2018 9.96 10.11 9.82 10.04 9.374852 184274600 0.07 0.007028112
8/6/2018 10 10.1 9.72 9.74 9.094728 147656900 0.41 0.041
8/13/2018 9.74 9.75 9.35 9.55 8.917316 202107000 0.34 0.034907598
8/20/2018 9.56 9.9 9.56 9.68 9.038703 152361900 0.03 0.003138075

Financial Analysis 20
8/27/2018 9.75 10.09 9.4 9.48 8.851953 245915400 0.42 0.043076923
9/3/2018 9.53 9.58 9.25 9.27 8.655866 179422000 0.41 0.043022036
9/10/2018 9.31 9.49 9.22 9.45 8.823939 142359100 0.01 0.001074114
9/17/2018 9.44 9.94 9.43 9.85 9.19744 247514300 -0.26 -
0.027542373
9/24/2018 9.78 9.85 9.09 9.25 8.63719 234433800 0.68 0.069529652
10/1/2018 9.43 9.44 9.09 9.12 8.515802 209536000 0.46 0.048780488
10/8/2018 9.1 9.31 8.55 8.64 8.067602 281598000 0.61 0.067032967
10/15/2018 8.67 8.89 8.19 8.5 7.936877 245250600 0.32 0.036908881
10/22/2018 8.38 9.06 8.17 8.98 8.385077 345180900 -0.45 -
0.053699284
10/29/2018 9.36 9.67 9.17 9.38 8.915917 327137800 0.13 0.013888889
11/5/2018 9.38 9.8 9.27 9.38 8.915917 227564000 0.15 0.015991471
11/12/2018 9.38 9.67 8.98 9.05 8.602244 227845400 0.48 0.051172708
11/19/2018 9.02 9.36 8.96 9.13 8.678287 130855900 0.04 0.00443459
11/26/2018 9.23 9.53 9.17 9.41 8.944433 179264200 -0.03 -
0.003250271
12/3/2018 9.71 9.85 8.8 8.82 8.383623 220097300 1.04 0.107106076
12/10/2018 8.83 8.85 8.38 8.52 8.098467 209210600 0.46 0.05209513
12/17/2018 8.48 8.72 8.04 8.05 7.651721 274474300 0.58 0.068396226
12/24/2018 8.01 8.04 7.41 7.81 7.423594 194664200 0.35 0.043695381

Financial Analysis 21
Appendix 2
Date Open High Low Close
Adj
Close Volume Stock Return
12/25/201
7 null null null null null null
(P0 - P1) +
D
{(P0 - P1) +
D} / P0
1/1/2018 312
325.2
5
305.6
8
316.5
8
316.5
8
2341120
0 -4.579987 -0.014679446
1/8/2018 316
344.8
1 315.5
336.2
2
336.2
2
3278650
0 -20.220001 -0.063987345
1/15/2018
337.5
4 352.3 334.8
350.0
2
350.0
2
2413210
0 -12.47998 -0.036973336
1/22/2018 349.4 360.5
335.7
1
342.8
5
342.8
5
2824300
0 6.549988 0.018746388
1/29/2018
339.8
5
359.6
6
338.2
8
343.7
5
343.7
5
2358140
0 -3.899994 -0.011475633
2/5/2018
337.9
7
348.6
2
294.7
6
310.4
2
310.4
2
3977000
0 27.549988 0.081516075
2/12/2018
316.1
3
343.1
2
306.2
5
335.4
9
335.4
9
2629420
0 -19.359985 -0.06124058
2/19/2018
334.4
7
354.9
9 331.5
352.0
5
352.0
5
2001620
0 -17.579987 -0.052560729
2/26/2018 353.5
359.9
9
322.9
7
335.1
2
335.1
2
2718550
0 18.380005 0.051994356
3/5/2018
332.3
9
337.7
5
321.7
4
327.1
7
327.1
7
2218980
0 5.220002 0.015704449
3/12/2018
328.6
1
347.2
1
319.0
7
321.3
5
321.3
5
3487930
0 7.259979 0.022092996
3/19/2018 316.5
322.4
4
300.4
5
301.5
4
301.5
4
2980170
0 14.959991 0.047266954
3/26/2018 307.3 307.5 248.2 266.1 266.1 5841930 41.209991 0.134086001

Financial Analysis 22
4 9 1 3 3 0
4/2/2018
256.2
6
309.2
8
244.5
9 299.3 299.3
8749650
0 -43.039978 -0.167954329
4/9/2018
300.3
7 309.5
289.2
1
300.3
4
300.3
4
4365850
0 0.029999 9.99E-05
4/16/2018 299
301.0
1
282.5
1
290.2
4
290.2
4
3161470
0 8.76001 0.029297692
4/23/2018
291.2
9
294.4
7 276.5
294.0
8
294.0
8
2331290
0 -2.789978 -0.009578008
4/30/2018
293.6
1
306.8
5
275.2
3
294.0
9
294.0
9
4374570
0 -0.480011 -0.001634859
5/7/2018 297.5
312.9
9
295.1
7
301.0
6
301.0
6
3066680
0 -3.559998 -0.01196638
5/14/2018
303.3
2
304.9
4 274
276.8
2
276.8
2
3415250
0 26.5 0.087366476
5/21/2018
281.3
3
291.4
9
273.4
2
278.8
5
278.8
5
3213330
0 2.479981 0.008815203
5/28/2018
278.5
1
295.0
1
276.1
5
291.8
2
291.8
2
2450040
0 -13.309997 -0.047790013
6/4/2018
294.3
4 330
286.7
4
317.6
6
317.6
6
5211080
0 -23.320008 -0.079228132
6/11/2018
322.5
1
364.6
7 322.5
358.1
7
358.1
7
6683000
0 -35.660003 -0.110570221
6/18/2018 355.4
373.7
3 332
333.6
3
333.6
3
5145200
0 21.769989 0.061254894
6/25/2018
330.1
2
357.0
2 325.8
342.9
5
342.9
5
3760790
0 -12.830017 -0.038864707
7/2/2018
360.0
7
364.7
8
296.2
2 308.9 308.9
5738430
0 51.170013 0.142111289
7/9/2018 311.9 327.6 308 318.8 318.8 3354340 -6.880005 -0.022052006

Financial Analysis 23
9 8 7 7 0
7/16/2018
311.7
1 325.5
306.2
5
313.5
8
313.5
8
3151660
0 -1.869996 -0.005999153
7/23/2018
301.8
4 310.7
292.5
5
297.1
8
297.1
8
3799290
0 4.660003 0.015438653
7/30/2018 295.9 355
286.1
3
348.1
7
348.1
7
5889190
0 -52.270019 -0.176647584
8/6/2018
345.4
6
387.4
6
339.1
5
355.4
9
355.4
9
9266700
0 -10.029999 -0.02903375
8/13/2018
361.1
3
363.1
9
303.5
3 305.5 305.5
5156050
0 55.630005 0.154044262
8/20/2018 291.7
327.3
2 288.2
322.8
2
322.8
2
4527040
0 -31.119995 -0.106684929
8/27/2018 318
322.4
4
297.7
2
301.6
6
301.6
6
4076760
0 16.339996 0.051383635
9/3/2018
296.9
4
298.1
9
252.2
5
263.2
4
263.2
4
4604400
0 33.700012 0.113490981
9/10/2018
273.2
6
297.3
3 271 295.2 295.2
4657480
0 -21.940002 -0.080289838
9/17/2018
290.0
4
305.9
8 275.5 299.1 299.1
4412990
0 -9.059997 -0.031237059
9/24/2018
298.4
8
314.9
6
260.5
6
264.7
7
264.7
7
5932670
0 33.710022 0.11293896
10/1/2018
305.7
7
316.8
4 260
261.9
5
261.9
5
6927480
0 43.819977 0.143310261
10/8/2018
264.5
2
267.7
6
247.7
7
258.7
8
258.7
8
5371770
0 5.73999 0.021699646
10/15/201
8
259.0
6 282.7 253.5 260 260
3917860
0 -0.940002 -0.003628511
10/22/201 260.6 339.9 252.5 330.9 330.9 9295260 -70.220001 -0.269372422

Financial Analysis 24
8 8 9 0
10/29/201
8
337.4
7 349.2
322.2
6
346.4
1
346.4
1
4704510
0 -8.940003 -0.026491252
11/5/2018 340.5
357.5
8
330.1
4
350.5
1
350.5
1
3415790
0 -10.01001 -0.029397974
11/12/201
8
348.3
7 355.7
330.3
4
354.3
1
354.3
1
2926230
0 -5.940003 -0.017050846
11/19/201
8
356.3
4
366.7
5
325.5
5
325.8
3
325.8
3
2660300
0 30.510009 0.085620501
11/26/201
8 325 351.6 325
350.4
8
350.4
8
2718780
0 -25.480011 -0.078400034
12/3/2018 360
379.4
9
350.7
6
357.9
7
357.9
7
3612210
0 2.029999 0.005638886
12/10/201
8 360
377.8
7
353.1
2
365.7
1
365.7
1
3165280
0 -5.709991 -0.015861086
12/17/201
8 362 365.7
311.8
7
319.7
7
319.7
7
4013690
0 42.230011 0.116657489
12/24/201
8 313.5
336.2
4
294.0
9
333.8
7
333.8
7
3223710
0 -20.369995 -0.064976061