PROJECT #2: Relative and Private Equity Valuations 1. First Safe Interstate Bank is a small, regional bank that is trading at a price to book (equity) ratio of 1.50. The bank is in stable growth,...

Please review attached doc. Need one word doc for the analysis. one excel spreadsheet calculations with graph. Please show your work. Thanks


PROJECT #2: Relative and Private Equity Valuations 1. First Safe Interstate Bank is a small, regional bank that is trading at a price to book (equity) ratio of 1.50. The bank is in stable growth, with earnings and dividends expected to grow 3% a year in perpetuity. The stock has a beta of 1, the risk-free rate is 5% and the equity risk premium is 4%. a. Assuming that the market has priced this stock correctly, estimate the expected return on equity for the bank. ( 2 points) b. Now assume that as a result of the banking crisis of the last few weeks, you expect the regulatory authorities to raise capital requirements immediately for banks by 20%. (Banks will need 20% more book equity to deliver the same net income). Also, assume that the equity risk premium has risen to 6%. If the stable growth rate remains 3%, estimate the new price to book equity ratio for First Safe Interstate Bank. (20 points) 2. You have been asked to analyze three technology companies and have been provided with the following information on the companies: If you assume that the three companies have the same expected growth rate in net income and share the same return on equity and cost of equity, which of the three companies would you consider the cheapest? Explain why. (20 points) 3. You are reviewing the valuation of Vulcan Enterprises, a private business. The analyst has estimated a value of $ 2.0 million for the company, which is in stable growth and expected to grow 3% a year in perpetuity. The firm has no debt outstanding and is expected to generate an after-tax operating income of $300,000 next year; the return on capital is anticipated to be 15%. The analyst valued the company for a private-to-private transaction, and the cost of equity he estimated is correct, given that setting. (He used a total beta to estimate the cost of equity, a risk-free rate of 4%, and an equity risk premium of 5%). However, the buyer is a publicly-traded firm with diversified investors. The average R-squared across publicly traded companies in this business is 25%. Estimate the correct value of Vulcan Enterprises for sale to a public buyer. (40 points)