Attached is a 6 weeks tracking of 3 portfolio of stocks. I want to know: How to
Fantastic news! We've Found the answer you've been seeking!
Question:
Attached is a 6 weeks tracking of 3 portfolio of stocks.
I want to know:
How to calculate the ROI for each stock and portfolio and their values?
How to calculate and what the Rate of Return, Expected rate of return, Variance, Standard deviation, and Market Beta for each stock and portfolio is?
Transcribed Image Text:
1 TOTAL SHARES 100 100 100 100 400 100 100 100 100 400 100 100 100 100 400 1,200 NAME OF SECURITY Microsoft Bank of America PayPal Oneok Jack Henry & Associates, Inc Q2 Holding, Inc. Fidelity National Information Services, Inc. Diebold Nixdorf, Incorporated Ares Captial Corporation Tennant Company Upland Software, Inc IEC Electronics Corp. S&P 500 Dow DIVIDEN PRICE PRICE PRICE WEEK #4 WEEK #5 D PRICE PRICE PRICE TICKER WEEK #1 PAYOUT WEEK #2 WEEK #3 WEEK #6 PRICE SYMBOL 03/19/21 RATIO 03/26/21 04/01/21 04/09/21 04/16/21 04/23/21 WEEK #7 MSFT $230.35 31.15% $236.48 $242.35 $255.85 $260.74 $261.15 BAC $38.53 58.94% $38.68 $39.49 $39.18 PYPL $241.28 N/A $241.03 $247.54 $266.03 OKE $48.46 263.38% $51.18 $51.35 $39.99 $39.15 $266.77 $269.87 $50.92 $51.60 $50.60 JKHY QTWO FIS DBD ARCC TNC UPLD IEC $148.13 44.22% $106.89 N/A $141.74 560.00% $14.15 0.00% $18.26 140.35% $80.01 49.17% $48.63 N/A $12.89 N/A $3,913.10 $32,627.97 $155.19 $154.59 $102.65 $103.10 $102.90 $105.44 $146.42 $144.05 $149.93 $152.62 $14.02 $14.19 $13.72 $13.95 $155.72 $158.84 $169.59 $103.83 $153.01 $14.14 $19.62 $19.56 $18.68 $18.93 $19.35 $80.98 $80.65 $81.19 $80.79 $81.12 $47.98 $47.78 $46.22 $50.69 $50.24 $11.96 $11.89 $12.04 $11.96 $12.15 $3,974.54 $4,019.87 $4,128.80 $4,185.47 $4,180.17 $33,072.88 $33,153.21 $33,800.60 $34,200.67 $34,043.49 EXPECTED ENDING PRICE on Week #6 Est. Inflation of 2.5% $236.11 $39.49 $247.31 $49.67 $151.83 $109.56 $145.280 $14.50 $18.72 $82.01) $49.85 $13.21 1 TOTAL SHARES 100 100 100 100 400 100 100 100 100 400 100 100 100 100 400 1,200 NAME OF SECURITY Microsoft Bank of America PayPal Oneok Jack Henry & Associates, Inc Q2 Holding, Inc. Fidelity National Information Services, Inc. Diebold Nixdorf, Incorporated Ares Captial Corporation Tennant Company Upland Software, Inc IEC Electronics Corp. S&P 500 Dow DIVIDEN PRICE PRICE PRICE WEEK #4 WEEK #5 D PRICE PRICE PRICE TICKER WEEK #1 PAYOUT WEEK #2 WEEK #3 WEEK #6 PRICE SYMBOL 03/19/21 RATIO 03/26/21 04/01/21 04/09/21 04/16/21 04/23/21 WEEK #7 MSFT $230.35 31.15% $236.48 $242.35 $255.85 $260.74 $261.15 BAC $38.53 58.94% $38.68 $39.49 $39.18 PYPL $241.28 N/A $241.03 $247.54 $266.03 OKE $48.46 263.38% $51.18 $51.35 $39.99 $39.15 $266.77 $269.87 $50.92 $51.60 $50.60 JKHY QTWO FIS DBD ARCC TNC UPLD IEC $148.13 44.22% $106.89 N/A $141.74 560.00% $14.15 0.00% $18.26 140.35% $80.01 49.17% $48.63 N/A $12.89 N/A $3,913.10 $32,627.97 $155.19 $154.59 $102.65 $103.10 $102.90 $105.44 $146.42 $144.05 $149.93 $152.62 $14.02 $14.19 $13.72 $13.95 $155.72 $158.84 $169.59 $103.83 $153.01 $14.14 $19.62 $19.56 $18.68 $18.93 $19.35 $80.98 $80.65 $81.19 $80.79 $81.12 $47.98 $47.78 $46.22 $50.69 $50.24 $11.96 $11.89 $12.04 $11.96 $12.15 $3,974.54 $4,019.87 $4,128.80 $4,185.47 $4,180.17 $33,072.88 $33,153.21 $33,800.60 $34,200.67 $34,043.49 EXPECTED ENDING PRICE on Week #6 Est. Inflation of 2.5% $236.11 $39.49 $247.31 $49.67 $151.83 $109.56 $145.280 $14.50 $18.72 $82.01) $49.85 $13.21
Expert Answer:
Answer rating: 100% (QA)
ROI Return on Investment This can be be calculated for each stock by subtracting the initial price from the ending price and then dividing that by the initial price Then multiply by 100 to express the ... View the full answer
Related Book For
Cornerstones of Managerial Accounting
ISBN: 978-0324660135
3rd Edition
Authors: Mowen, Hansen, Heitger
Posted Date:
Students also viewed these finance questions
-
A thin sheet of aluminum is subjected to a complex stamping operation. Prior to stamping, a circle of 0.345 in diameter was etched onto the sheet's surface. After stamping, the circle had changed...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Identify and then briefly explain the eight general audit procedures used to gather evidence. Next, please provide an example for each of the eight procedures?
-
In Section 4.4.1, we note that the values of the coefficient of friction can be much higher than unity. Explain why.
-
If you are a bank, the customer asks you the exchange rate of USD /CNY, you replied: 6.4565 / 89.please answer the questions: (1) What exchange rate will be used when the customer buy dollar? (2)...
-
You design a new type of absorber that has a number of slanted plates with falling films on each plate and gas flowing counter to the liquid. In the laboratory, the new system works well. Its high...
-
NPV and Modified ACRS In the previous problem, suppose the fixed asset actually falls into the three-year MACRS class. All the other facts are the same. What is the projects year 1 net cash flow now,...
-
It is a 2000 word essay, can you please advise me on the layout to this answer and what info to include? Thanks! It should only have an introduction, main body and conclusion. The question is : 'The...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
Case study Figure 1. demonstrates Phaseouts of ozone-depleting substances since 1987 of the Antarctic ozone hole. Explain the data on the graphics. What is the trend? What changes you see before and...
-
An article in the San Jose Mercury News stated that students in the California state university system take 4.5 years, on average, to finish their undergraduate degrees. Suppose you believe that the...
-
From generation to generation, the mean age when smokers first start to smoke varies. However, the standard deviation of that age remains constant of around 2.1 years. A survey of 40 smokers of this...
-
In 1955, Life Magazine reported that the 25 year-old mother of three worked, on average, an 80 hour week. Recently, many groups have been studying whether or not the women's movement has, in fact,...
-
The mean age of De Anza College students in a previous term was 26.6 years old. An instructor thinks the mean age for online students is older than 26.6. She randomly surveys 56 online students and...
-
If the tolerance is reduced by half, how would this affect the minimum sample size?
-
What myths does body language expert, Joe Navarro, debunk about body language? How does Navarro assess an individual? What sort of behavior is he looking for? Give at least two (2) examples.
-
Determine whether the lines are parallel, perpendicular, or neither. 2x + 3y = -12, 2y - 3x = 8
-
Multiple-Choice Questions 1. The key difference between residual income and economic value added is that EVA a. Uses the actual cost of capital for the company rather than a minimum required cost of...
-
Explain why the fixed overhead spending variance is usually very small.
-
What is underapplied overhead? When Cost of Goods Sold is adjusted for underapplied overhead, will the cost increase or decrease? Why?
-
Graham Corporation used the following data to evaluate its current Kin operating system. The company sells items for \($10\) each and used a budgeted selling price of \($10\) per unit. a. Prepare the...
-
Selected data for Miller Company, which operates three departments, follow: During the year, the companys fixed expenses included the following: Assume that the property tax rate is the same for both...
-
Johnson Company has two sources of funds: long term debt and equity capital. Johnson Company has profit centers in the following locations with the following net incomes and total assets: a....
Study smarter with the SolutionInn App