Data Provided Date Closing Market Index Value Closing Price for PG Closing Price for F 1/2/2017 2278.87 91.07 12.53 1/3/2017 2363.64 89.85 11.64 1/4/2017 2362.72 87.33 11.47 1/5/2017 2384.20 88.09 11.12 1/6/2017 2411.80 87.15 11.19 1/7/2017 2423.41 90.82 11.22 1/8/2017 2470.30 92.27 11.03 1/9/2017 2471.65 90.98 11.97 1/10/2017 2519.36 86.34 12.27 1/11/2017 2575.26 89.99 12.52 1/12/2017 2647.58 91.88 12.49 1/1/2018 2673.61 86.34 10.97 1/2/2018 2823.81 78.52 10.61 1/3/2018 2713.83 79.28 11.08 1/4/2018 2640.87 72.34 11.24 1/5/2018 2648.05 73.17 11.55 1/6/2018 2705.27 78.06 11.07 1/7/2018 2718.37 80.88 10.04 1/8/2018 2816.29 82.95 9.48 1/9/2018 2901.52 83.23 9.25 1/10/2018 2913.98 88.68 9.55 1/11/2018 2711.74 94.51 9.41 1/12/2018 2760.17 91.92 7.65 1/1/2019 2506.85 96.47 8.80 1/2/2019 2704.10 98.55 8.77 1/3/2019 2784.49 104.05 8.78 1/4/2019 2834.40 106.48 10.45 1/5/2019 2945.83 102.91 9.52 1/6/2019 2752.06 109.65 10.23 1/7/2019 2941.76 118.04 9.53 1/8/2019 2980.38 120.23 9.17 1/9/2019 2926.46 124.38 9.16 1/10/2019 2976.74 124.51 8.59 1/11/2019 3037.56 122.06 9.06 1/12/2019 3140.98 124.90 9.30 1/1/2020 3230.78 124.62 8.82 Use the Data above to calculate: (1). The monthly Return for PG (2). The monthly Return for F (3). The monthly Market Return Date Closing Price for PG Monthly Return for PG Closing Price for F Monthly Return for F Closing Market Index Value Monthly Market Return 1/2/2017 91.07 12.53 2278.87 1/3/2017 89.85 11.64 2363.64 1/4/2017 87.33 11.47 2362.72 1/5/2017 88.09 11.12 2384.20 1/6/2017 87.15 11.19 2411.80 1/7/2017 90.82 11.22 2423.41 1/8/2017 92.27 11.03 2470.30 1/9/2017 90.98 11.97 2471.65 1/10/2017 86.34 12.27 2519.36 1/11/2017 89.99 12.52 2575.26 1/12/2017 91.88 12.49 2647.58 1/1/2018 86.34 10.97 2673.61 1/2/2018 78.52 10.61 2823.81 1/3/2018 79.28 11.08 2713.83 1/4/2018 72.34 11.24 2640.87 1/5/2018 73.17 11.55 2648.05 1/6/2018 78.06 11.07 2705.27 1/7/2018 80.88 10.04 2718.37 1/8/2018 82.95 9.48 2816.29 1/9/2018 83.23 9.25 2901.52 1/10/2018 88.68 9.55 2913.98 1/11/2018 94.51 9.41 2711.74 1/12/2018 91.92 7.65 2760.17 1/1/2019 96.47 8.80 2506.85 1/2/2019 98.55 8.77 2704.10 1/3/2019 104.05 8.78 2784.49 1/4/2019 106.48 10.45 2834.40 1/5/2019 102.91 9.52 2945.83 1/6/2019 109.65 10.23 2752.06 1/7/2019 118.04 9.53 2941.76 1/8/2019 120.23 9.17 2980.38 1/9/2019 124.38 9.16 2926.46 1/10/2019 124.51 8.59 2976.74 1/11/2019 122.06 9.06 3037.56 1/12/2019 124.90 9.30 3140.98 1/1/2020 124.62 8.82 3230.78
Data Provided Date Closing Market Index Value Closing Price for PG Closing Price for F 1/2/2017 2278.87 91.07 12.53 1/3/2017 2363.64 89.85 11.64 1/4/2017 2362.72 87.33 11.47 1/5/2017 2384.20 88.09 11.12 1/6/2017 2411.80 87.15 11.19 1/7/2017 2423.41 90.82 11.22 1/8/2017 2470.30 92.27 11.03 1/9/2017 2471.65 90.98 11.97 1/10/2017 2519.36 86.34 12.27 1/11/2017 2575.26 89.99 12.52 1/12/2017 2647.58 91.88 12.49 1/1/2018 2673.61 86.34 10.97 1/2/2018 2823.81 78.52 10.61 1/3/2018 2713.83 79.28 11.08 1/4/2018 2640.87 72.34 11.24 1/5/2018 2648.05 73.17 11.55 1/6/2018 2705.27 78.06 11.07 1/7/2018 2718.37 80.88 10.04 1/8/2018 2816.29 82.95 9.48 1/9/2018 2901.52 83.23 9.25 1/10/2018 2913.98 88.68 9.55 1/11/2018 2711.74 94.51 9.41 1/12/2018 2760.17 91.92 7.65 1/1/2019 2506.85 96.47 8.80 1/2/2019 2704.10 98.55 8.77 1/3/2019 2784.49 104.05 8.78 1/4/2019 2834.40 106.48 10.45 1/5/2019 2945.83 102.91 9.52 1/6/2019 2752.06 109.65 10.23 1/7/2019 2941.76 118.04 9.53 1/8/2019 2980.38 120.23 9.17 1/9/2019 2926.46 124.38 9.16 1/10/2019 2976.74 124.51 8.59 1/11/2019 3037.56 122.06 9.06 1/12/2019 3140.98 124.90 9.30 1/1/2020 3230.78 124.62 8.82 Use the Data above to calculate: (1). The monthly Return for PG (2). The monthly Return for F (3). The monthly Market Return Date Closing Price for PG Monthly Return for PG Closing Price for F Monthly Return for F Closing Market Index Value Monthly Market Return 1/2/2017 91.07 12.53 2278.87 1/3/2017 89.85 11.64 2363.64 1/4/2017 87.33 11.47 2362.72 1/5/2017 88.09 11.12 2384.20 1/6/2017 87.15 11.19 2411.80 1/7/2017 90.82 11.22 2423.41 1/8/2017 92.27 11.03 2470.30 1/9/2017 90.98 11.97 2471.65 1/10/2017 86.34 12.27 2519.36 1/11/2017 89.99 12.52 2575.26 1/12/2017 91.88 12.49 2647.58 1/1/2018 86.34 10.97 2673.61 1/2/2018 78.52 10.61 2823.81 1/3/2018 79.28 11.08 2713.83 1/4/2018 72.34 11.24 2640.87 1/5/2018 73.17 11.55 2648.05 1/6/2018 78.06 11.07 2705.27 1/7/2018 80.88 10.04 2718.37 1/8/2018 82.95 9.48 2816.29 1/9/2018 83.23 9.25 2901.52 1/10/2018 88.68 9.55 2913.98 1/11/2018 94.51 9.41 2711.74 1/12/2018 91.92 7.65 2760.17 1/1/2019 96.47 8.80 2506.85 1/2/2019 98.55 8.77 2704.10 1/3/2019 104.05 8.78 2784.49 1/4/2019 106.48 10.45 2834.40 1/5/2019 102.91 9.52 2945.83 1/6/2019 109.65 10.23 2752.06 1/7/2019 118.04 9.53 2941.76 1/8/2019 120.23 9.17 2980.38 1/9/2019 124.38 9.16 2926.46 1/10/2019 124.51 8.59 2976.74 1/11/2019 122.06 9.06 3037.56 1/12/2019 124.90 9.30 3140.98 1/1/2020 124.62 8.82 3230.78
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
100%
Data Provided
Date | Closing Market Index Value | Closing Price for PG | Closing Price for F |
1/2/2017 | 2278.87 | 91.07 | 12.53 |
1/3/2017 | 2363.64 | 89.85 | 11.64 |
1/4/2017 | 2362.72 | 87.33 | 11.47 |
1/5/2017 | 2384.20 | 88.09 | 11.12 |
1/6/2017 | 2411.80 | 87.15 | 11.19 |
1/7/2017 | 2423.41 | 90.82 | 11.22 |
1/8/2017 | 2470.30 | 92.27 | 11.03 |
1/9/2017 | 2471.65 | 90.98 | 11.97 |
1/10/2017 | 2519.36 | 86.34 | 12.27 |
1/11/2017 | 2575.26 | 89.99 | 12.52 |
1/12/2017 | 2647.58 | 91.88 | 12.49 |
1/1/2018 | 2673.61 | 86.34 | 10.97 |
1/2/2018 | 2823.81 | 78.52 | 10.61 |
1/3/2018 | 2713.83 | 79.28 | 11.08 |
1/4/2018 | 2640.87 | 72.34 | 11.24 |
1/5/2018 | 2648.05 | 73.17 | 11.55 |
1/6/2018 | 2705.27 | 78.06 | 11.07 |
1/7/2018 | 2718.37 | 80.88 | 10.04 |
1/8/2018 | 2816.29 | 82.95 | 9.48 |
1/9/2018 | 2901.52 | 83.23 | 9.25 |
1/10/2018 | 2913.98 | 88.68 | 9.55 |
1/11/2018 | 2711.74 | 94.51 | 9.41 |
1/12/2018 | 2760.17 | 91.92 | 7.65 |
1/1/2019 | 2506.85 | 96.47 | 8.80 |
1/2/2019 | 2704.10 | 98.55 | 8.77 |
1/3/2019 | 2784.49 | 104.05 | 8.78 |
1/4/2019 | 2834.40 | 106.48 | 10.45 |
1/5/2019 | 2945.83 | 102.91 | 9.52 |
1/6/2019 | 2752.06 | 109.65 | 10.23 |
1/7/2019 | 2941.76 | 118.04 | 9.53 |
1/8/2019 | 2980.38 | 120.23 | 9.17 |
1/9/2019 | 2926.46 | 124.38 | 9.16 |
1/10/2019 | 2976.74 | 124.51 | 8.59 |
1/11/2019 | 3037.56 | 122.06 | 9.06 |
1/12/2019 | 3140.98 | 124.90 | 9.30 |
1/1/2020 | 3230.78 | 124.62 | 8.82 |
Use the Data above to calculate:
(1). The monthly Return for PG
(2). The monthly Return for F
(3). The monthly Market Return
Date | Closing Price for PG | Monthly Return for PG | Closing Price for F | Monthly Return for F | Closing Market Index Value | Monthly Market Return |
1/2/2017 | 91.07 | 12.53 | 2278.87 | |||
1/3/2017 | 89.85 | 11.64 | 2363.64 | |||
1/4/2017 | 87.33 | 11.47 | 2362.72 | |||
1/5/2017 | 88.09 | 11.12 | 2384.20 | |||
1/6/2017 | 87.15 | 11.19 | 2411.80 | |||
1/7/2017 | 90.82 | 11.22 | 2423.41 | |||
1/8/2017 | 92.27 | 11.03 | 2470.30 | |||
1/9/2017 | 90.98 | 11.97 | 2471.65 | |||
1/10/2017 | 86.34 | 12.27 | 2519.36 | |||
1/11/2017 | 89.99 | 12.52 | 2575.26 | |||
1/12/2017 | 91.88 | 12.49 | 2647.58 | |||
1/1/2018 | 86.34 | 10.97 | 2673.61 | |||
1/2/2018 | 78.52 | 10.61 | 2823.81 | |||
1/3/2018 | 79.28 | 11.08 | 2713.83 | |||
1/4/2018 | 72.34 | 11.24 | 2640.87 | |||
1/5/2018 | 73.17 | 11.55 | 2648.05 | |||
1/6/2018 | 78.06 | 11.07 | 2705.27 | |||
1/7/2018 | 80.88 | 10.04 | 2718.37 | |||
1/8/2018 | 82.95 | 9.48 | 2816.29 | |||
1/9/2018 | 83.23 | 9.25 | 2901.52 | |||
1/10/2018 | 88.68 | 9.55 | 2913.98 | |||
1/11/2018 | 94.51 | 9.41 | 2711.74 | |||
1/12/2018 | 91.92 | 7.65 | 2760.17 | |||
1/1/2019 | 96.47 | 8.80 | 2506.85 | |||
1/2/2019 | 98.55 | 8.77 | 2704.10 | |||
1/3/2019 | 104.05 | 8.78 | 2784.49 | |||
1/4/2019 | 106.48 | 10.45 | 2834.40 | |||
1/5/2019 | 102.91 | 9.52 | 2945.83 | |||
1/6/2019 | 109.65 | 10.23 | 2752.06 | |||
1/7/2019 | 118.04 | 9.53 | 2941.76 | |||
1/8/2019 | 120.23 | 9.17 | 2980.38 | |||
1/9/2019 | 124.38 | 9.16 | 2926.46 | |||
1/10/2019 | 124.51 | 8.59 | 2976.74 | |||
1/11/2019 | 122.06 | 9.06 | 3037.56 | |||
1/12/2019 | 124.90 | 9.30 | 3140.98 | |||
1/1/2020 | 124.62 | 8.82 | 3230.78 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
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