Question

Melissa is trying to value the stock of Generic Utility Inc., which is clearly not growing at all. Generic declared and paid a $5 dividend last year. The required rate of return for utility stock is 11%, but Melissa is unsure about the financial reporting integrity of Generic's finance team. She decides to add an extra 1% "credibility" risk premium to the required return as part of her valuation analysis.

a. What is the value of Generic's stock, assuming that the financials are trustworthy?

b. What is the value of Generic's stock, assuming that Melissa includes the extra 1% "credibility" risk premium?

c. What is the difference between the values found in parts a and b, and how might one interpret that difference?

Please provide an explanation in Excel.