Question

In: Finance

Go to finance.yahoo 1.  and Type in Search Finance box: General Motors… and see that while you...

Go to finance.yahoo

1.  and Type in Search Finance box: General Motors… and see that while you do the typing Yahoo provides you with a list of suggested companies with similar names… Please note that the same company may be listed in different stock exchanges and countries with the same or similar names. Please select from the list General Motors Company listed in NYSE with the ticker symbol of GM.

3.    Once you have the information on GM, please make a note of GM’s beta coefficient.

4.    Do the same for Boeing, Amazon, Exxon-Mobil Corporation, Expedia, and GE.

5.    For all 6 companies, you looked at above, make a table showing the name, ticker symbol, beta coefficient, where is it traded, stock price, and the EPS. Date your table as the information you obtained is time-specific.

6.    Explain each company's risk position using their beta coefficients with one line. Which one is the riskiest and which one is the least risky?

7.    How is it possible that we can talk about the risk without standard deviation information for the companies?

8.    Make a portfolio assuming you have $80,000 and decided to invest $20,000 on General Motors, $30,000 on Amazon, $10,000 on Boeing, $7,500 on Exxon Mobil, $2,500 on Expedia, and the rest on GE. Compute the portfolio beta.

9.    Assume that, one month later, you sold your GM stocks with a 10% gain. Assume also that you allocated the proceeds from the sale on GE and Expedia equally. What is the new portfolio beta?

Solutions

Expert Solution

SOLUTION:-

Table with required Content

S

No

Company Name Symbol Traded at Stock price EPS Beta PE Ratio Date

Time

(IST)

1 General Moters GM NYSE 34.43 6.47 1.65 5.33 7/Jun/17 12:40 Pm
2 Mc Donalds MCD NYSE 151.23 5.66 0.79 26.7 7/Jun/17 12:40 Pm
3 Apple Inc AAPL NASDAQ 154.45 8.52 1.43 18.12 7/Jun/17 12:40 Pm
4 Exxon Mobile Inc XOM NYSE 81.21 2.4 0.65 33.88 7/Jun/17 12:40 Pm
5 Expedia Incorporation EXPE NASDAQ 146.87 1.97 1.04 74.55 7/Jun/17 12:40 Pm
6 TravelZoo Inc TZOO NASDAQ 10.4 0.53 1.47 19.55 7/Jun/17 12:40 Pm

Total Risk will be considered as sigma, which contains both systematic risk & Un systematic risk

Systematic risk is the risk of market & considered as beta and which can not be eliminated through diversification strategy

Unsystematic risk is company specific & can be eliminated or reduced through diversification strategy

Beta of 1.65 for General Motors is the systematic risk of General Motors is 1.65 times of the market

In the given list of companies, General Motors is risky company as it having highest bete value (1.65)

Computation of portfolio beta

portfolio beta is the weighted average beta of all stocks in that portfolio.

Portfolio beta = (W1*beta1) + (W2*beta2) +..........+(Wn*Beta n)

where W1,W2.......Wn are the weights of n stocks in the portfolio

Beta1, Beta2,.......Beta n are the beta factors of n stocks respectively.

Portfolio beta in Situation1

Company Name Amount Invested Weights Beta Weighted Beta
General Motors 20000 0.25 1.65 0.41
Mc Donalds 10000 0.13 0.79 0.10
Apple Incorporation 30000 0.38 1.43 0.54
Exxon Mobile corporation 7500 0.09 0.65 0.06
Expedia Incorporation 2500 0.03 1.04 0.03
TravelZoo Incorporation 10000 0.13 1.47 0.18
Total 80000 1.00 1.32

Portfolio beta = 1.32

Situation 2
Company Name Amount Invested Weights Beta Weighted beta
General Motors 0 0 1.65 0
Mc Donalds 10000 0.12 0.79 0.10
Apple Incorporation 30000 0.37 1.43 0.52
Exxon mobile corporation 7500 0.09 0.65 0.06
Expedia Incorporation 13500 0.16 1.04 0.17
Travel Zoo Incorporation 21000 0.26 1.47 0.38
Total 82000 1.00 1.23

Portfolio beta = 1.23

Sales proveeds of General motors = 20000*110%=22000

Half (11000) invested in expedia Incorporation & Half (11000) invested in Travelzoo Incorporation

THANK YOU, if any queries please leave your valuable comment on comment box.........

If possible then rate the answer as well


Related Solutions

Go to sec.gov and click on “Filings”; you will see a drop-down box. Click on “Company...
Go to sec.gov and click on “Filings”; you will see a drop-down box. Click on “Company Filings Search.” In the Fast Search box (right side), type in USB to get the SEC filings for U.S. Bancorp. Find the most recently filed 10K (interactive data), and then click on “financial statements.” From here you can open the firm’s Consolidated Balance Sheet and the Consolidated Statement of Income. Notice that you can access 2 to 3 years of data. Compute the following...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements for Starbucks. Access the two most recent income statements and balance sheets that are provided, and prepare horizontal and vertical analyses of both. Income Statement All numbers in thousands Revenue 10/1/2017 10/2/2016 9/27/2015 Total Revenue 22,386,800 21,315,900 19,162,700 Cost of Revenue 9,038,200 8,511,100 7,787,500 Gross Profit 13,348,600 12,804,800 11,375,200 Operating Expenses Research Development - - - Selling General and Administrative 8,440,400 7,970,300 7,130,200 Non...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements for Starbucks. Access the two most recent income statements and balance sheets that are provided, and prepare horizontal and vertical analyses of both. In approximately 250-500 words, summarize the findings from your horizontal and vertical analyses. Submit your assignment in an Excel workbook.
Go to Yahoo! Finance, linked in Resources. Find a stock beginning with the letter 'G' Search...
Go to Yahoo! Finance, linked in Resources. Find a stock beginning with the letter 'G' Search your chosen stock. When you find it, click on the Historical Data tab to access historical stock price. Gather five years of daily adjusted stock price data by selecting the appropriate dates through the Time Period link. Be sure the end date includes days in this course (Sept 28). Click on the Download Data link to save the data to your computer. The file...
Access medline University account. Click on catalog. Using the search box type in the name of...
Access medline University account. Click on catalog. Using the search box type in the name of this module. A. Falls prevention. Tools and strategies _ 20_393882. Create a teaching plan for a patient or coworker,where the learning module you just completed would be appropriate. The teaching plan must include; 1.The importance of the topic being discussed. 2.Risk factors for harm associated with this issue. 3.Strategies to prevent or ensure that appropriate interventions are in place.. Add/Modify the teaching plan to...
Windows 10 Inside Out: In the Search box on the Taskbar, type WordPad and press “Enter”....
Windows 10 Inside Out: In the Search box on the Taskbar, type WordPad and press “Enter”. Type some text into WordPad. A) What keyboard shortcuts would you use to select all of this text and copy it to the Clipboard? (See Table 3-2 on page 103.) B) Go the end of the text in WordPad. What keyboard shortcut would you use to paste what you copied into WordPad? C) What keyboard shortcut would you use to Undo what you just...
To find financial statements, I go to Yahoo! Finance and type in the name of a...
To find financial statements, I go to Yahoo! Finance and type in the name of a company of your choice. Discuss the financial statements of a company of your choice, what they mean in to the company and its shareholders, and how the financial statements relate to each other
The General Motors 3.625% July 2047 bond is priced to yield 15.990% while the Yahoo 3.625%...
The General Motors 3.625% July 2047 bond is priced to yield 15.990% while the Yahoo 3.625% July 2047 bond is priced to yield 19.600%. If the market assumes that there is a 4.315% probability that General Motors will default on the bond then the market also assumes that the probability of default on the Yahoo bond is ________% and the expected yield in this market is _________%
To see internal controls in action, look around you. When you go to the store, see...
To see internal controls in action, look around you. When you go to the store, see what types of internal controls you can identify. At your place of work see if you can identify internal controls that might be in place. After checking out some different places, come up with two internal controls you have observed. It can be at your place of business or when you are a customer (and they don't have to be from the same place)....
Directions Go to the YAHOO! FINANCE  page follow the directions below and answer the questions.       Type...
Directions Go to the YAHOO! FINANCE  page follow the directions below and answer the questions.       Type in XOM in the “Get Quotes" box.       Click on “Profile” and write a one paragraph description of the company’s activities.       Return to the homepage and write down the company’s P/E ratio. Is it relatively low (under 15)?        Click on "Competitors" and compare ExxonMobil to other companies in the industry based on the P/E ratio and the PEG ratio (the P/E ratio...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT