Assignment

In this exercise, it will require selection of 3 firms within each utilities sector or electricity industry analyzed to invest $10,000,000 of a special portfolio into both stocks and bonds evenly. The objective of the portfolio is to produce superior returns to those of the S&P 500 over the next 12 months. Therefore, given the economic environment, the sector sensitivity and performance expected, 3 firms will need to be selected per industry that will outperform their sector. Requirements In order to meet all the requirements for the financial analysis exercise #3, you are required to complete the following tasks:

• Select stocks and bonds to purchase based on sector and industry analysis

• Use 3 methods to calculate relative value of stocks: dividend discount, Gordon model and P/E or other approved method.

• Obtain the consensus earnings forecast for the firms

• Explain how this will affect the expected future price

• Obtain a consensus interest rate forecast

• How will this effect bond prices?

• How will this affect the roll down the yield curve?

Attachment:- Spreadsheet.rar