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:
Table-1:
| Plant | Beta Coefficient | % of Concordia’s Income |
| South Town | 0.85 | 55% |
| North Town | 0.90 | 20% |
| East Town | 1.25 | 15% |
| West Town | 1.60 | 10% |
You have also gathered some information about the market and found that the 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:
Table-2:
| Probability | Return |
| 0.15 | 8% |
| 0.2 | 9% |
| 0.5 | 10% |
| 0.1 | 11% |
| 0.05 | 12% |
Questions:
- What is the Beta coefficient for Concordia? Explain your answers.
- What is Concordia’s required rate of return on any new investments? Explain your answers.
- What is the equation for the (SML)? Show the equation and graph the equation on a graph. Explain what the SML is telling you, and the implications for the firm.
- Suppose Concordia has the opportunity to purchase an additional plant. The cost of the new plant will be $200 million and have a beta coefficient of 1.60. If the new plant is expected to return 12%, should Concordia make the investment? Explain your answers and justify your calculations.
Present your analysis of the assigned problems in Excel format. in the same