Concept explainers
(a)
To determine:
To set the spreadsheet and to calculate the 26 week moving average of the index
Introduction:
For a stock price, the moving average is the average stock price over a certain given time interval. This interval however gets updated with time. In case of a 50 day moving average, the average price is tracked over the prior 50 days.
Answer to Problem 25PS
The 26 week moving average of the index is calculated and is presented in the explanation.
Explanation of Solution
Given Information:
Value of the index in the same period beginning should be kept as 100 and For each week it is updated by multiplying the level of previous week by (1+
The data was downloaded from the given website.
The weekly returns are converted to weekly index values. Here 100 is used as the base for the week before the first week of the set of data. From this, the 26 week moving average of S&P 500 is calculated.
| Week | S&P rate |
| 2013.01 | 1.64 |
| 2013.02 | 0.17 |
| 2013.03 | -0.82 |
| 2013.04 | 0.85 |
| 2013.05 | 0.59 |
| 2013.06 | -0.21 |
| 2013.07 | 0.12 |
| 2013.08 | 1.19 |
| 2013.09 | -3.27 |
| 2013.1 | -1.00 |
| 2013.11 | -0.03 |
| 2013.12 | 3.25 |
| 2013.13 | -0.23 |
| 2013.14 | -0.47 |
| 2013.15 | 0.47 |
| 2013.16 | -2.97 |
| 2013.17 | -0.91 |
| 2013.18 | 0.07 |
| 2013.19 | -0.20 |
| 2013.2 | 2.77 |
| 2013.21 | 0.11 |
| 2013.22 | 1.21 |
| 2013.23 | -0.27 |
| 2013.24 | 0.19 |
| 2013.25 | -0.85 |
| 2013.26 | -1.02 |
| 2013.27 | -0.92 |
| 2013.28 | -1.57 |
| 2013.29 | 1.72 |
| 2013.3 | -3.60 |
| 2013.31 | 0.32 |
| 2013.32 | 3.07 |
| 2013.33 | 0.88 |
| 2013.34 | 0.59 |
| 2013.35 | 0.85 |
| 2013.36 | 0.50 |
| 2013.37 | -1.49 |
| 2013.38 | 1.96 |
| 2013.39 | -1.00 |
| 2013.4 | -1.11 |
| 2013.41 | -1.13 |
| 2013.42 | 2.91 |
| 2013.43 | 3.61 |
| 2013.44 | 1.29 |
| 2013.45 | -0.86 |
| 2013.46 | 0.79 |
| 2013.47 | 0.76 |
| 2013.48 | 0.06 |
| 2013.49 | 0.57 |
| 2013.5 | 1.11 |
| 2013.51 | 0.08 |
| 2013.52 | -2.01 |
| 2014.01 | -0.17 |
| 2014.02 | -1.24 |
| 2014.03 | 0.56 |
| 2014.04 | 2.38 |
| 2014.05 | 0.45 |
| 2014.06 | -0.32 |
| 2014.07 | 0.87 |
| 2014.08 | 1.07 |
| 2014.09 | -1.91 |
| 2014.1 | -1.15 |
| 2014.11 | -1.18 |
| 2014.12 | 0.25 |
| 2014.13 | 0.48 |
| 2014.14 | -3.26 |
| 2014.15 | 1.24 |
| 2014.16 | 0.16 |
| 2014.17 | 1.15 |
| 2014.18 | -1.17 |
| 2014.19 | 2.93 |
| 2014.2 | 0.96 |
| 2014.21 | -0.09 |
| 2014.22 | 0.05 |
| 2014.23 | 1.37 |
| 2014.24 | -1.96 |
| 2014.25 | 0.46 |
| 2014.26 | 1.49 |
| 2014.27 | 1.26 |
| 2014.28 | 0.57 |
| 2014.29 | 0.16 |
| 2014.3 | -0.69 |
| 2014.31 | 0.14 |
| 2014.32 | -0.47 |
| 2014.33 | -1.39 |
| 2014.34 | 1.24 |
| 2014.35 | 1.91 |
| 2014.36 | -0.46 |
| 2014.37 | -1.67 |
| 2014.38 | 1.32 |
| 2014.39 | -2.79 |
| 2014.4 | -0.78 |
| 2014.41 | -0.45 |
| 2014.42 | 1.41 |
| 2014.43 | 1.93 |
| 2014.44 | 1.35 |
| 2014.45 | 1.10 |
| 2014.46 | 1.60 |
| 2014.47 | -0.22 |
| 2014.48 | -0.41 |
| 2014.49 | 0.55 |
| 2014.5 | 0.31 |
| 2014.51 | -1.77 |
| 2014.52 | 3.15 |
| 2015.01 | 0.19 |
| 2015.02 | -2.10 |
| 2015.03 | 2.04 |
| 2015.04 | -1.76 |
| 2015.05 | 0.29 |
| 2015.06 | 1.72 |
| 2015.07 | 0.47 |
| 2015.08 | -0.50 |
| 2015.09 | -0.13 |
| 2015.1 | 1.99 |
| 2015.11 | -0.32 |
| 2015.12 | -0.29 |
| 2015.13 | -0.23 |
| 2015.14 | -0.64 |
| 2015.15 | 1.90 |
| 2015.16 | 0.24 |
| 2015.17 | 0.80 |
| 2015.18 | -2.48 |
| 2015.19 | -1.66 |
| 2015.2 | 1.01 |
| 2015.21 | 0.48 |
| 2015.22 | -2.83 |
| 2015.23 | -0.12 |
| 2015.24 | -0.17 |
| 2015.25 | 2.29 |
| 2015.26 | -0.53 |
| 2015.27 | -2.44 |
| 2015.28 | 0.34 |
| 2015.29 | 3.25 |
| 2015.3 | 0.17 |
| 2015.31 | -0.93 |
| 2015.32 | 2.89 |
| 2015.33 | -0.67 |
| 2015.34 | 1.23 |
| 2015.35 | -0.86 |
| 2015.36 | 1.73 |
| 2015.37 | -0.38 |
| 2015.38 | 1.61 |
| 2015.39 | 1.08 |
| 2015.4 | 1.20 |
| 2015.41 | 0.15 |
| 2015.42 | 0.78 |
| 2015.43 | -1.00 |
| 2015.44 | 1.25 |
| 2015.45 | 1.58 |
| 2015.46 | -0.05 |
| 2015.47 | -0.09 |
| 2015.48 | 0.85 |
| 2015.49 | 0.65 |
| 2015.5 | -1.11 |
| 2015.51 | 0.62 |
| 2015.52 | -0.76 |
| 2016.01 | 1.92 |
| 2016.02 | -0.29 |
| 2016.03 | -0.48 |
| 2016.04 | 1.88 |
| 2016.05 | -0.60 |
| 2016.06 | 1.24 |
| 2016.07 | -0.29 |
| 2016.08 | -4.57 |
| 2016.09 | 1.52 |
| 2016.1 | -1.21 |
| 2016.11 | 3.51 |
| 2016.12 | -0.97 |
| 2016.13 | 1.58 |
| 2016.14 | 0.74 |
| 2016.15 | 2.27 |
| 2016.16 | 0.61 |
| 2016.17 | 0.93 |
| 2016.18 | -0.03 |
| 2016.19 | 1.16 |
| 2016.2 | -0.61 |
| 2016.21 | 1.57 |
| 2016.22 | -1.97 |
| 2016.23 | 1.78 |
| 2016.24 | -1.64 |
| 2016.25 | -0.08 |
| 2016.26 | 1.70 |
| 2016.27 | 1.22 |
| 2016.28 | -0.87 |
| 2016.29 | -5.46 |
| 2016.3 | -0.90 |
| 2016.31 | 0.63 |
| 2016.32 | 0.00 |
| 2016.33 | 2.51 |
| 2016.34 | -0.50 |
| 2016.35 | -1.03 |
| 2016.36 | 1.94 |
| 2016.37 | 2.55 |
| 2016.38 | 0.40 |
| 2016.39 | 2.14 |
| 2016.4 | 0.31 |
| 2016.41 | -4.26 |
| 2016.42 | 2.63 |
| 2016.43 | -1.57 |
| 2016.44 | -4.01 |
| 2016.45 | 0.45 |
| 2016.46 | -1.14 |
| 2016.47 | 3.15 |
| 2016.48 | 1.52 |
| 2016.49 | -2.48 |
| 2016.5 | 1.18 |
| 2016.51 | -0.56 |
| 2016.52 | -4.06 |
| 2017.01 | -0.82 |
| 2017.02 | -5.77 |
| 2017.03 | 0.75 |
| 2017.04 | 4.91 |
| 2017.05 | -4.67 |
| 2017.06 | 1.56 |
| 2017.07 | 0.35 |
| 2017.08 | -1.32 |
| 2017.09 | -3.08 |
| 2017.1 | -0.07 |
| 2017.11 | 2.41 |
| 2017.12 | -0.43 |
| 2017.13 | 4.09 |
| 2017.14 | -2.56 |
| 2017.15 | 3.82 |
| 2017.16 | 0.81 |
| 2017.17 | 1.37 |
| 2017.18 | -1.85 |
| 2017.19 | 2.70 |
| 2017.2 | -3.52 |
| 2017.21 | 1.96 |
| 2017.22 | -2.89 |
| 2017.23 | -0.11 |
| 2017.24 | -2.87 |
| 2017.25 | -3.08 |
| 2017.26 | -0.96 |
| 2017.27 | -1.95 |
| 2017.28 | 1.72 |
| 2017.29 | -0.40 |
| 2017.3 | 0.55 |
| 2017.31 | 2.54 |
| 2017.32 | 0.62 |
| 2017.33 | -0.40 |
| 2017.34 | -0.66 |
| 2017.35 | -3.40 |
| 2017.36 | 1.35 |
| 2017.37 | -0.99 |
| 2017.38 | -2.63 |
| 2017.39 | -8.70 |
| 2017.4 | -19.79 |
| 2017.41 | 5.33 |
| 2017.42 | -6.63 |
| 2017.43 | 11.25 |
| 2017.44 | -3.07 |
| 2017.45 | -7.71 |
| 2017.46 | -8.19 |
| 2017.47 | 13.29 |
| 2017.48 | -2.39 |
| 2017.49 | 1.20 |
| 2017.5 | -0.09 |
| 2017.51 | -1.17 |
| 2017.52 | 6.66 |
The graph shows the 26 week moving average with the help of average of index prices over 5 year period.
(b)
To determine:
To determine the instances where the moving average is crossed from below and the number of week after which the index increases following a cross-through.
Introduction:
For a stock price, the moving average is the average stock price over a certain given time interval. This interval however gets updated with time. In case of a 50 day moving average, the average price is tracked over the prior 50 days.
Answer to Problem 25PS
As per the data, 15 times the index moves below the moving average.
Explanation of Solution
Given Information:
The data is available in the given website.
From the data it is clear that there are 15 instances when the S&P index goes below the moving average. It is seen that 8 times the index goes up in weeks succeeding the cross-through. The index diminishes 7 times in weeks following a cross-through.
(c)
To determine:
To determine the instances where the index crosses through the moving average from above and the number of weeks in which the index increases following a cross-through and decreases following the cross-through.
Introduction:
For a stock price, the moving average is the average stock price over a certain given time interval. This interval however gets updated with time. In case of a 50 day moving average, the average price is tracked over the prior 50 days.
Answer to Problem 25PS
As per the data, 16 times the index moves below the moving average.
Explanation of Solution
Given Information:
The data is available in the given website.
From the data it is clear that there are 16 instances when the S&P index goes above the moving average. It is seen that 10 times the index goes up in weeks succeeding the cross-through. The index diminishes 6 times in weeks following a cross-through.
(d)
To determine:
To determine how well the moving average rule functions in identifying the selling or buying opportunities.
Introduction:
For a stock price, the moving average is the average stock price over a certain given time interval. This interval however gets updated with time. In case of a 50 day moving average, the average price is tracked over the prior 50 days.
Answer to Problem 25PS
This data does not help in predicting the sell or buy opportunities.
Explanation of Solution
Given Information:
The data is available in the given website.
The data which is available and the related calculations that are made do not help in obtaining the rule of relative strength which is needed to identify the buy or sell opportunities. So, this rule will not be applicable in this scenario.
Want to see more full solutions like this?
Chapter 9 Solutions
ESSENTIALS OF INVESTMENTS>LL<+CONNECT
- Which of the following would be expected to hold its value best during a time of inflation? A certificate of deposit. A corporate bond. A house.arrow_forwardWhat is a budget? A spending plan showing sources and uses of income. A limit on spending that cannot be exceeded. The amount of money that a credit card will let youarrow_forwardThe Pan American Bottling Co. is considering the purchase of a new machine that would increase the speed of bottling and save money. The net cost of this machine is $60,000. The annual cash flows have the following projections: Year 1 ........... 2 ........... 3 ........... 4 ........... 5 ........... Cash Flow $23,000 26,000 29,000 15,000 8,000 a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine? I need to see the work. I can't use Excel to solve the problem. Excel doesn't help me solve Part a.arrow_forward
- Pat and Chris have identical interest-bearing bank accounts that pay them $15 interest per year. Pat leaves the $15 in the account each year, while Chris takes the $15 home to a jar and never spends any of it. After five years, who has more money? Pat. Chris. They both have the same amount. Don’t knowarrow_forwardAssume a firm has earnings before depreciation and taxes of $200,000 and no depreciation. It is in a 25 percent tax bracket. a. Compute its cash flow using the following format: Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ b. Compute the cash flow for the company if depreciation is $200,000. Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ c. How large a cash flow benefit did the depreciation provide?arrow_forwardAssume a $40,000 investment and the following cash flows for two alternatives. Year Investment X Investment Y 1 $6,000 $15,000 2 8,000 20,000 3 9,000 10,000 4 17,000 — 5 20,000 — Which of the alternatives would you select under the payback method?arrow_forward
- The Short-Line Railroad is considering a $140,000 investment in either of two companies. The cashflows are as follows:Year Electric Co. Water Works1.................. $85,000 $30,0002.................. 25,000 25,0003.................. 30,000 85,0004–10............ 10,000 10,000a. Using the payback method, what will the decision be?b. Using the Net Present Value method, which is the better project? The discount rate is 10%.arrow_forwardWhat is corporate finance explain its important?arrow_forwardWhat is corporate finance? can you explain more?arrow_forward
- General accounting problem.arrow_forwardWhat do you know about corporate finance? tell me about thisarrow_forwardWhich of the following is the primary function of insurance? Making risk disappear. Pooling and sharing risk among the insured. Making someone else pay for an accident or loss. Don’t know.arrow_forward
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education