Question

? X Undervalued/Overvalued Stock - Excel FORMULAS DATA REVIEW - Sign In PAGE LAYOUT VIEW OSSA FILE HOME INSERT Calibri Paste B I U- Clipboard Font E2 - 11 - A A -A Alignment Number Cells Editing Conditional Format as Cell Formatting Table - Styles Styles A B A manager believes his firm will earn a 16.50 percent return next year. His firm has a beta of .64, the expected return on the market is 14.40 percent, and the risk-free rate is 5.40 percent. Compute the return the firm should earn given its level of risk. Determine whether the manager is saying the firm is undervalued or overvalued. Expected return next year Firm beta Expected return on the market Risk-free rate 16.50% 0.64 14.40% 5.40% Compute the expected return and determine whether the manager is saying the firm is undervalued or overvalued. (Do not round intermediate calculations and round your answers to 2 decimal places.) Risk appropriate level of return Undervalued, overvalued, or fairly valued ... Sheet1 ...

SHOW THE FORMULAS

Answer 1

Risk Appropriate Level of Return = Rf + β(Rm- Rf)  

Where Rf is the risk free rate of return

Rm is the market Return

Risk Appropriate Level of Return = 5.40% + 0.64(14.4% - 5.40%)

= 11.16%

Risk Appropriate Level of Return is 11.16%

Firm is Under-Valued because Risk Appropriate level of Return < Expected Return

NOTE: The answer to your question has been given below/above. If there is any query regarding the answer, please ask in the comment section. If you find the answer helpful, do upvote. Help us help you.