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
*.1weighthpr 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 1 year 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,...

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

Select WALMART for analysis. Go to the Yahoo! Finance Web site. Enter the stock ticker symbol...

Select WALMART for analysis. Go to the Yahoo! Finance Web site. Enter the stock ticker symbol or name of the company you wish to analyze in the input field next to Get Quotes at the top of the page and click Get Quotes to open the stock's overview/main page. Review the price graph provided on the overview page. Click on 6m or 1y at the bottom of the chart to get prices on the stock for the past 6 months...

Subjects