Question

In: Finance

Company Name Google Ticker Symbol GOOGL Market Cap Closing Price 42760 858.45 42761 856.98 42762 845.03...

Company Name Google
Ticker Symbol GOOGL
Market Cap
Closing Price
42760 858.45
42761 856.98
42762 845.03
42765 823.83
42766 820.19
42767 815.24
42768 818.26
42769 820.13
42772 821.62
42773 829.23
42774 829.88
42775 830.06
42776 834.85
42779 838.96
42780 840.03
42781 837.32
42782 842.17
42783 846.55
42787 849.27
42788 851.36
42789 851
42790 847.81
42793 849.67
42794 844.93
42795 856.75
42796 849.85
42797 849.08
42800 847.27
42801 851.15
42802 853.64
42803 857.84
42804 861.4
42807 864.58
42808 865.91
42809 868.39
42810 870
42811 872.37
42814 867.91
42815 850.14
42816 849.8
42817 839.65
42818 835.14
42821 838.51
42822 840.63
42823 849.87
42824 849.48
42825 847.8
42828 856.75
42829 852.57
42830 848.91
42831 845.1
42832 842.1
42835 841.7
42836 839.88
42837 841.46
42838 840.18
42842 855.13
42843 853.99
42844 856.51
42845 860.08
42846 858.95
Dividend 0
Return 0.5
HPR 0.000582
STDEVA 0.0069721
Volatility 0.1106789
.1weight*hpr of each stock 0.0000582

Need to understand the excel formula to be used for calculating the above highlighted.(Answers are provided)

Solutions

Expert Solution

Dividend = 0.

There is no formula to be applied here as no divideds are announced.

Return = Final Price (21-Apr-17) - Initial Price (25-Jan-17) = 858.95 - 858.45 = 0.50

Holding Period Return (HPR) = (Final Price + Dividends - Initial Price) / Initial Price

= ( 858.95 + 0 - 858.45) / 858.45 = 0.000582

STDEVA: For calculating standard deviation you need to calculate returns first. Returns = (Final price / Initial price) - 1.

After intraday returns are calculated use STDEVA function and select all the returns as its values (input). It would give you 0.006972.

Volatility: Volatility is Annualized volatility which is calculated by converting daily standard deviation into an annualized figure. There are 252 trading days per year, on average.


Use the formula "=SQRT(252)*Standard deviaiton" to convert the standard deviation for this period to annualized historical volatility. This will give you 0.110679.

.1weight*hpr of each stock:

Fornula = 0.10 x HPR = 0.10 x 0.000582 = 0.0000582

jeff jeffy answered 3 years ago
Next > < Previous

Related Solutions

CEO Name Stock Ticker (Example Apple's ticker on the NASDAQ is AAPL) Current stock price. 52...
CEO Name Stock Ticker (Example Apple's ticker on the NASDAQ is AAPL) Current stock price. 52 week range Number of shares outstanding Market Capitalization Tell me why you are interested in this company and if you had an opportunity, would you buy their stock? Why or Why not? Upload text responses. Make sure you copy the questions as well so I know what you are responding to.
The Walt Disney Company is listed as Ticker Symbol “DIS” on the New York Stock Exchange....
The Walt Disney Company is listed as Ticker Symbol “DIS” on the New York Stock Exchange. The Industry is listed under Consumer Services. Summarize in no more than 350 words the most frequently found long-term assets and long-term liabilities, as well as any unique assets or liabilities that were not common among the companies.
The Walt Disney Company is listed as Ticker Symbol “DIS” on the New York Stock Exchange....
The Walt Disney Company is listed as Ticker Symbol “DIS” on the New York Stock Exchange. The Industry is listed under Consumer Services. Determine what the company's policy is related to long-lived assets, goodwill, and other intangible assets. Identify what the company says about its annual goodwill impairment testing. Identify whether the company has any deferred tax assets and liabilities, and summarize what the company says about these items in the 10-K. Identify the disclosures related to long-term debt, leases,...
company name : Whole Food Market ( search for info on google ) answer : its...
company name : Whole Food Market ( search for info on google ) answer : its not a narrative text use course concept course fundamentls of management quest : discuss the organization of work ( delegation of authority and responsability , centralization or decentralization , etc... ) prepare the swot analysis ( 4 of each ) and do you believe employees are motivated ? why or why not ? what are the motivational theories applied under current circumstances of covid...
1) Find a company whose ticker symbol contains your initials. (For example if your initials are:...
1) Find a company whose ticker symbol contains your initials. (For example if your initials are: BK, then Bank of New York Mellon (BK) or Barnes and Noble (BKS) or Ambac Financial Group (ABK) would satisfy this requirement). If you cannot find any company with your initials, then use one of your initials (you choose which) twice. So if your initial are: SV, choose a company with either 2 S’s or 2 V’s in the ticker. If there is still...
For Kl and lithium phosphate give the cation name and symbol, anion name and symbol, and...
For Kl and lithium phosphate give the cation name and symbol, anion name and symbol, and chemical formula. Which is an impossible ectron configuration? 1s22s2 1s32s22p4 1s22s22p4 1s22s22p43s1 1s22s22p43s2
Enter the ticker symbol for the stock or ETF that best fits the investment thesis described....
Enter the ticker symbol for the stock or ETF that best fits the investment thesis described. Ticker Investment Thesis You especially like the growth prospects for China. You like the idea of bonds selling at a discount to par. You have a bearish outlook for biotech stocks. After Amazon’s great holiday season, you like the prospects for shipping a lot of goods. You think aging baby boomers will need a lot more meds. You think housing construction is about to...
1) Choose five stocks—any five stocks you find interesting. List the company, the ticker symbol, and...
1) Choose five stocks—any five stocks you find interesting. List the company, the ticker symbol, and the percentage of your total portfolio that this stock makes up. 2) Find and report the beta for each of the stocks in your portfolio. Discuss what the beta of each stock means for that company. 3) Calculate the portfolio beta and discuss what it means. Based on the betas of each stock, which stocks might you choose to invest more heavily in and...
​As the CFO of Dragon Airways (ticker symbol: DRAG) you decide to sell 100,000 shares in...
​As the CFO of Dragon Airways (ticker symbol: DRAG) you decide to sell 100,000 shares in a ​secondary offering to raise additional capital for an expansion. Your shares currently trade ​at $100/share and have a beta of 1.25. It will take several weeks to complete the ​registration process through the SEC and you are concerned that the overall stock market ​will fall in the interim. So you decide to hedge the stock sale by selling short the shares of ​another...
Stock Options Worksheet - Pfizer Identify the stock and its ticker symbol that you are using...
Stock Options Worksheet - Pfizer Identify the stock and its ticker symbol that you are using in this assignment. Provide its last traded price. Company Name Ticker Symbol Last Traded Price Obtain one of each for Call Option quotes and Put Option quotes. The TWO quotes must meet the following two criteria: The strike price is approximately equal to the stock’s last traded price you wrote down earlier on your note paper. The expiry date is in three to six...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT