Question

In: Finance

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance):

(i) Describe and interpret the assumptions related to the problem.

(ii) Apply the appropriate mathematical model to solve the problem.

(iii) Calculate the correct solution to the problem.

A company’s stock had a required return of 11.50% last year, when the risk-free rate was 5.50% and the market risk premium was 4.75%. Now, suppose there is a shift in investor risk aversion, and the market risk premium increases by 2.00%. The risk-free rate and the beta remain unchanged. What is this company’s new required return (round your answer to two decimal places)?

Solutions

Expert Solution

i)

Given information,

Company's stock return last year = 11.50%

Risk free rate = 5.50%

Market risk premium = 4.75%

We have given this information. To calculate required return we have many formulae but here, we have given last year's data.

Risk measure as beta remains constant. It is assumed that given stock return of 11.50% is company's expected rate of return.

ii)

We generally use CAPM model to derive required rate of return. Here the information provided is related to the Capital Asset Pricing Model. Hence, we will use Capital Asset Pricing Model for further calculations. We have provided market risk premium which is difference between market risk and risk free rate. CAPM formula is

Here, Rm - Rf is market risk premium under CAPM.

E(R) indicates expected or required return of stock or bond. Rf is risk free rate of return. indicates Beta of return.

To calculate company's new required rate of return , we have given that market risk premium increases by 2.00%. As per given formula, we need beta of stock which is not given. We can calculate beta by using last year's data as we have given that risk free rate and beta remains unchanged. Hence, we will use Capital Asset Pricing Model to solve this problem.

iii)

CAPM formula is

By using this, we will calculate beta as we have other information of last year.

11.50 = 5.50 + * 4.75

11.50-5.50 = 4.75*

6 = 4.75*

6/4.75 =

1.2632 =

= 1.2632

As we have given that beta and risk free rate remains unchanged for next year, for calculating new required return, risk free rate will be 5.50%, as calculated above 1.2632 and market risk premium increased by 2.00% i.e. new market risk premium is 4.75%+2.00%=6.75%

Therefore new required rate of return is,

E(R) = 5.50 + 1.2632*6.75

= 5.50 + 8.5266

E(R) = 14.03%

Therefore, company's new required rate of return is 14.03%


Related Solutions

Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. PROBLEM: Consider a 10 year bond with face...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (iii) Calculate...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i) Develop...
​Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).13. You are told that if you invest $15,000 per year for10 years (all payments made at the end of each year), you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT