Question: Will someone show me how to solve this in Execl. Not writen out. thanks Calculating the expected return on a portfolio, given the share in

Will someone show me how to solve this in Execl. Not writen out. thanks

Calculating the expected return on a portfolio, given the share in the risk-free asset, the T-bill rate, and the market risk premium 65% T-bills What is the expected return and beta on a portfolio tha 35% market portfolio and If the risk free rate is 0.4% and the market risk premium is 8.1% T-bills Market portfolio Shares 65% 35% Return Risk Premium Beta 0.4% 0 0 8.1% 1 E(Rp)= Portfolio beta=

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Kingfisher Inc. purchased a piece of real estate in early 2017 for $4,000,000. The company initially allocated the purchase price 40% to land, 50% to building, and 10% to fixtures. Sub-sequently,...

1) A project has a net present value of zero. Given this information: A) the project has a zero percent rate of return. B) the project requires no initial cash investment. C) the project has no cash...

THIS QUESTION IS DUE IN EXACTLY 1 HOUR AND 45 MINUTES. I WILL PAY EXTRA 10 DOLLARS IN TIP IF SOMEONE TYPES THE EXACT ANSWER REQUESTED. PLEASE RESPOND TO THE EACH AND EVERY QUESTION IN A TOTAL OF 3-4...

I need question one answered. Attached are documents from the chapter to help add in the question. A 1 D E F Final Examination FINC 5880 3 5 6 7 8 9 10 11 C Question 6. (15 points) Your portfolio is...

Hey i need you help with my Portfolio final report. i get some of them and want you to finish it, i will upload the professor sample report, and half of my work, plus the week 4 and week 5 report...

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

Consider the two (excess return) index-model regression results for stocks A and B. The risk-free rate over the period was 6%, and the markets average return was 14%. Performance is measured using an...

I need help on 2b and 2c ECON 163: Economics of Investments University of California, Merced Professor Jason Lee Problem Set #8 Due in class Tuesday, May 5th [100 Possible Points] You may work in...

ECON 163: Economics of Investments University of California, Merced Professor Jason Lee Problem Set #8 Due in class Tuesday, May 5th [100 Possible Points] You may work in small groups [2 to 3...

5. return Of 10.03 percent, how much money will you invest in Stock X7 In Stock Y Calculating Expected Return [LO1] Based on the following information, calcu- late the expected return: Probability of...

You can solve just part b!! Thanks (a) In a market in which the Arbitrage Pricing Theory (APT) model holds, the expected return is given by E[Ri]=0+1bi,1+2bi,2++nbi,n [3 marks] i. Define all the...

----------------determines what needs to be done, who will do it, how long audition will take, and how much it will cost. a). Planning b). Controlling c). Implementation d). Work analysis

In the Generalized Assignment Problem (GAP), we have a set of machines and a set of tasks. The machines need to perform the tasks, while each task has to be performed by exactly one machine. Machine...

Use the binomial theorem to find the first three terms in each of these expansions. a (1+x)10 b (1+2x)* c (1-3x) d (3+2x) e (3-x) f g (5-x2) h (4x-5y)10.

The individual financial statements for Gibson Company and Keller Company for the year ending December 31, 2011, follow. Gibson acquired a 60 percent interest in Keller on January 1, 2010, in...

The direct labor budget of Yuvwell Corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours: The company's variable manufacturing overhead rate...

Rosie Dry Cleaning was started on January 1, 2016. It experienced the following events during its first two years of operation: Events Affecting 2016 1. Provided $45,000 of cleaning services on...

The accounts receivable balance for Renue Spa at December 31, 2015, was $61,000. Also on that date, the balance in the Allowance for Doubtful Accounts was $3,750. During 2016, $2,100 of accounts...

Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $95, and $135, respectively. The production...

1 What components / points would you suggest in an initial marketing strategy for this new ACO? How are these suggestions different, and what is the intended outcome?

Discuss the unique training and development needs of employees working in international locations.

Explain how labour relations practices differ around the world.

Describe the types of organizational forms used by companies with international operations.