Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the information of the last 61 monthly prices on the websites, I calculated the monthly returns for each of the assets of IBM.

Based on the information of the last 61 monthly prices on the websites,

I calculated the monthly returns for each of the assets of IBM.

Please look at the 2 attached files.

1. Did I calculate correctly?

2. Is this formula correct?

Formula

Monthly Return = (Closing Price on Last Day of Month / Closing Price on Last Day of Previous Month) - 1

3. Am I using this formula correctly to get the monthly returns?

image text in transcribedimage text in transcribedimage text in transcribed
A 24 2 monthly returns for each of the assets. 25 Dates Close Monthly Returns 26 1-May-23 127.26 0.67% 27 1-Apr-23 126.41 -3.57% 28 1-Mar-23 131.09 1.38% 29 1-Feb-23 129.3 -4.03% 30 1-Jan-23 134.73 -4.37% 31 1-Dec-22 140.89 -5.38% 32 1-Nov-22 148.9 7.67% 33 1-Oct-22 138.29 16.40% 34 1-Sep-22 118.81 -7.50% 35 1-Aug-22 128.45 -1.79% 36 1-Jul-22 130.79 -7.37% 37 1-Jun-22 141.19 1.69% 38 1-May-22 138.84 5.01% 39 1-Apr-22 132.21 1.68% 40 1-Mar-22 130.02 6.13% 41 1-Feb-22 122.51 -8.28% 42 1-Jan-22 133.57 -0.07%\fyahoo! finance Search for news, symbols or companies Q Sign in Mail Currency in USD & Download Date Open High Low Close* Adj Close** Volume May 19, 2023 126.79 128.29 126.55 127.26 127.26 4,303,702 May 09, 2023 1.66 Dividend yahoo!finance May 01, 2023 126.35 128.29 120.55 127.26 125.55 59,846,400 NEW: EXPERIENCE OUR Apr 01, 2023 130.97 132.61 124.56 126.41 124.71 83,679,400 BEST CHARTS YET. Mar 01, 2023 128.90 131.48 121.71 131.09 129.33 138,239,000 Explore new charts Feb 09, 2023 1.65 Dividend Feb 01, 2023 134.49 137.39 128.86 129.30 126.01 76,080,200 People Also Watch Jan 01, 2023 141.10 147.18 132.98 134.73 131.30 105,575,000 Symbol Last Price Change % Change CSCO 49.13 +0.93 Dec 01, 2022 +1.93% 149.98 153.21 137.20 140.89 137.31 86,424,100 Cisco Systems, Inc. Nov 09, 2022 1.65 Dividend INTC 29.93 +0.25 +0.84% Intel Corporation Nov 01, 2022 138.25 150.46 133.97 148.90 143.40 93,661,300 ORCL 102.84 +0.50 +0.49% Oracle Corporation Oct 01, 2022 120.16 138.86 115.55 138.29 133.19 113,478,200 JNJ 158.91 +0.43 +0.27%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analytical Corporate Valuation Fundamental Analysis, Asset Pricing, And Company Valuation

Authors: Pasquale De Luca

1st Edition

331993550X, 9783319935508

More Books

Students also viewed these Accounting questions

Question

Why is interest in portable benefits in health care increasing?

Answered: 1 week ago