Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Financial Analysis Report for McCumber Energy

1. Use the scenario below to answer the questions.

2. Use MS Excel or the BA II plus calculator for calculations. Use MS Excel spreadsheets for charts and to summarize your data

3. Submit your report in either Word or MS Excel format. If using Word, attach supporting Excel documents to the D2L assignment tool.

Find the following Betas for the companies listed below:

Assuming a risk free rate (Rf) of 2% and the Return from the market (Rm) of 6.5% calculated the expected return of each company based on the Capital Asset Pricing Model.

 Company Stock Symbol Beta Expected Return TD Bank TD-T Royal Bank RY-T Canadian Tire Corporation CTC.A-T Suncor Energy SU-T Sierra Wireless SW-T Twitter TWTR-N Facebook FB-Q Microsoft MSFT-Q Apple AAPL-Q Amazon AMZN-Q Alphabet Inc. (Google) GOOGL-Q Starbucks SBUX-Q

Re-order your list from the lowest beta to the highest and compare their expected return.

a. Comment on your results.  (Hint: Look at the grouping of the companies, and the value of betas from 0 to 0.5, from 0.5 to 1, from 1 to 1.25 and 1.25 and up)

b. What does the value of beta tell us about a company? What does the value of beta and CAPM tell us about the risk in investing in a company?

Given the following information for McCumber Energy:

Debt – 7,000 with 6% yield to maturity, the bonds make semi-annual payments.

Preferred shares – 15,000 shares paying a dividend of \$3.65 per preferred shares outstanding currently selling at \$72 per share

Common shares - 300,000 common shares outstanding, selling at \$55 per share.

McCumber Corporate Tax Rate: 35%

Table 1 - Market data:

 Year Risk free rate (Rf) Return from the market (Rm) Beta 2016 1.81 12.3 1.20 2015 1.75 15.5 1.5 2014 1.70 35.2 1.42 2013 1.80 (33.1) 1.33 2012 1.92 9.83 1.4 2011 1.87 17.2 1.5 2010 1.88 24.1 1.45 2009 1.90 14.5 1.2 2008 1.85 (10.2) 1.6 2007 1.77 8.3 1.25

a. Calculate the average Risk free rate (Rf), Return from the market (Rm) and beta (β) from data collected in the last ten years in Table 1.

b. Calculate the cost of debt, cost of preferred shares and cost of common shares.  Note: Use CAPM for the cost of common shares using your averages for Rf, Rmand Beta

c. Calculate the weighted average cost of capital (WACC) for McCumber Energy.

Calculate the weighting of each company from your portfolio based on the market value in the investment in each of the four “FANG”.

Using a risk-free return of 2% and a stock market return of 6%, calculate the following:

a. Weightings of each company on your portfolio (3 marks)

b. Find the betas from each company using (3 marks)

c. Expected return from each company based on CAPM  (4 marks)

Present your financial data in a table similar to Table 1 on the following page.

 Company Stock Symbol Price per share Number of shares Market value of Holdings Weights Beta Expected Return Facebook FB-Q 50 Amazon AMZN-Q 50 Netflix NFLX-Q 50 Alphabet GOOGL-Q 50