Assignment 2: The Capital Asset Pricing Model
You are considering an investment in Concordia Utilities and have some questions regarding the income generating abilities of the company.
Concordia Utilities has 4 plants in four states and they all operate as separate entities. All four plants are financed by Concordia and have no holdings of their own but operate as if they were separate companies. You have gathered some information about the company’s plants as follows:
% of Concordia’s Income
You have also gathered some information about the market and found that the risk-free rate of interest is 3% and that the company adds a market risk premium of 4% to all investments. The possible market returns and their probabilities are found in Table-2:
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.
ByWednesday January 25 2017deliver your assignment to theM2: Assignment 2 Dropbox.
Create the file with the following name:LastnameFirstInitial_M2A2.Excel.xls.
Assignment 2 Grading Criteria
Correctly calculated the beta coefficient for the company and explained its meaning and significance to the firm.
Correctly calculated the Concordia’s required rate of return on any new investments and explained the significance of this number to the investing activities of the firm.
Correctly determined the function for the SML and plotted this function graphically.
Explained the significance of the SML in terms of the information it provides and the significance to the firm and in terms of future investments.
Correctly evaluated the new investment and made a recommendation as to whether the investment should go forward explaining the rationale.
Used correct spelling grammar and punctuation and followed APA style guidelines.
Microsoft Excel Tutorials:
Excel 2007 Tutorial