ESSENTIALS OF INVESTMENTS - CONNECT ACCE
ESSENTIALS OF INVESTMENTS - CONNECT ACCE
11th Edition
ISBN: 9781266077951
Author: Bodie
Publisher: INTER MCG
bartleby

Concept explainers

Question
Book Icon
Chapter 9, Problem 25PS
Summary Introduction

(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.

Expert Solution
Check Mark

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+rate of return over previous week)

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.

ESSENTIALS OF INVESTMENTS - CONNECT ACCE, Chapter 9, Problem 25PS

Summary Introduction

(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.

Expert Solution
Check Mark

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.

Summary Introduction

(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.

Expert Solution
Check Mark

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.

Summary Introduction

(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.

Expert Solution
Check Mark

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Answer it
QUESTION #1: A) What is the Net Operating Profit After Tax (NOPAT) for 2024?B) What is the Operating Cash Flow for 2024?  C) What is the Free Cash Flow for 2024?  Note: Marketable securities are non-operating current assets, and short-term debt (bank loan) is a non-operating current liability. Both of these items are excluded from the calculation of net operating working capital. D) If the stock trades for $85 per share at the end of 2024, and there are 315,000 shares outstanding, what is the MVA in 2024?  E) Given that the firm’s WACC is 14%, what is the EVA during 2024?  F) Create common size income statement and balance sheet for 2024, 2023 and 2022.  G) Using 2022 as the base year, create income statement and balance sheet percentage change analysis for 2024 and 2023.   QUESTION #2: In addition to the AAA Ltd. financial statements in Problem One, you are given more information as follows.   Sales are forecast to increase by 80% in 2025.   Short-term Debt, Long-term Debt, and Common…
Brightwoodę Furniture provides the following financial data for a given enod: Sales Less Variable E Contribwaon Margin Less Fixed Expenses et Income - Aount ($) Per Unit ($) 150,000 3 L96,000 13 10 35,000 25,000 a. What is the company's CM ratio? b. If quarterly sales increase by $5,200 and there is no change in fixed expenses, by how much would you expect quarterly net operating income to increase?
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author: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 Professor
Publisher:McGraw-Hill Education