Question: Given the spreadsheet below, calculate the portfolio beta and the expected return on this two stock portfolio using the CAPM. a.If the weights were 50/50,

Given the spreadsheet below, calculate the beta and the on this two stock using the CAPM.
a. If the weights were 50/50, would this increase or decrease the return?
b. If the market's had been 8% with the 60/40 weights, would this increase or decreased the return?
The Market's Risk Free Rate
Beta for Bateman Industires…………………………………...9%
Beta for Advanced Solar Arrays 1.34……………………….2.50%
Weight for Bateman…………………………………………..0.98
Weigh for Solar Arrays
Portfolio Beta………………………………………………….60%
Expected Return on the

Step by Step Solution

★★★★★

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

650-B-A-I (7406).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

You own a portfolio consisting of the stocks below: The risk- free rate is 3 percent. Also, the expected return on the market portfolio is 11 percent. a. Calculate the expected return of your...

Fill in the spreadsheet below to calculate the portfolio return and risk between Zenon and Dynamics, given the 10 years of annual returns for each stock, and portfolio weights of 50/50. a. How would...

The spreadsheet below has annual returns for three mutual fundsCapital Appreciation, High Return and Total Returnfor 10 years. A market return and a risk-free rate are provided, along with the beta...

Given the spreadsheet below, calculate the portfolio beta and the expected return on this two stock portfolio using the CAPM. a. If the weights were 50/50, would this increase or decrease the...

How do you calculate portfolio return, portfolio beta and the expected return of the portfolio based on the CAPM model for a stock portfolio? FIN3030 Assignment No.2 Your Name here *All assignments...

(Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) a. Calculate the portfolio beta on the basis of the original cost figures. b. Calculate the...

Question 9 ( 2 0 points ) Suppose the market portfolio is equally likely to increase by 3 0 % or decrease by 1 0 % . So there are two states of the world: goes up with probability 0 . 5 and goes down...

Choose three companies in three different industries, go to Yahoo Finance and download the monthly adjusted closing prices of the three companies in your portfolio and the S&P 500 index, for the...

The opportunity cost of a project is 25%. What is the risk free rate of the project if the risk premium is 5% and has a beta of 3%? (5 Marks) FEM Ltd is considering the following investment. The...

FEM Ltd is considering the following investment. The current rate of T-Bills is 15% and the expected return of the market is 24%. Using CAPM, what rate of return should FEM Ltd require for each of...

What is the function of the promoter in the E. coli lac operon? A promoter is a type of DNA sequence that activates or inactivates the expression of the lac operon genes by acting as a protein...

MonkeySuits, Inc. makes costumes for movies and television shows. Jay Tribini, the companys owner, prepared the following estimates for the upcoming year: Manufacturing overhead cost ......$660,000...

hich firm would be most likely to have an investment grade credit rating, all else being equal? Select an answer: a firm with a capital structure of 3 0 % equity, 7 0 % debt a firm with a capital...

Separate customer accounts receivable are called subsidiary accounts. Why does a company create subsidiary accounts?

Consumer services tend to be intangible, and goods tend to be tangible. Use an example to explain how the lack of a physical good in a pure service might affect efforts to promote the service.

Explain some of the different aspects of the customer experience that could be managed to improve customer satisfaction if you were the marketing manager for: ( a ) an airport branch of a rental car...

Is there any difference between a brand name and a trademark? If so, why is this difference important?

Assume a corporation made a one-year loan at 10 percent with receipts of $1,000, the present value is $909.09. This loan is funded with 90-day CDs paying 8 percent. Lets say the date is September 15...

3. Valuing a Zero-Coupon Bond Assume that you require a 14 percent return on a zero-coupon bond with a par value of $1,000 and six years to maturity. What is the price you should be willing to pay...

The target is to separate H 2 gas fCAn you vomplete the table given in the photo and the process through simulation with the information given below feed stream mole fraction composition is H 2 : 0 ....