FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please EXPLAIN please can you help me with excell formulaa thank u so much in advance Given the following information, calculate the expected return and

please EXPLAIN please can you help me with excell formulaa thank u so much in advance

image text in transcribed

Given the following information, calculate the expected return and standard deviation for a portfolio that has 25% invested in Summit Materials (SUM), 35% invested in Vulcan Materials (VMC) and the remaining allocation in CEMEX (CX) stock. (75 POINTS) State of Economy Boom Recession Probability of State of Economy 80.0% 20.0% Rate of Return if State Occurs SUM VMC CX 19.0% 23.0% 18.5% 2.0% -1.5% 2.5%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Personal Finance

Authors: Vickie L Bajtelsmit

2nd Edition

111959247X, 9781119592471

More Books

Students also viewed these Finance questions

Question

★★★★★
a. What is the process standard deviation () for the distribution of candy cane lengths? b. Is the manufacturing process capable of producing candy canes within the specified tolerance range? Compute...

Answered: 1 week ago

Question

★★★★★
Write the general formula for cost-plus pricing, and briefly explain its use?

Answered: 1 week ago

Question

★★★★★
=+1. For each of the following, show how you would code dummy (or indicator) variables to include in a regression model.

Answered: 1 week ago

Question

★★★★★
The following assignment is based on assignment 8 in Chapter 17. Use the assignment memo, statutory law, and case law from that assignment. The memo is due in seven days, and there is a five-page...

Answered: 1 week ago

Question

★★★★★
Compare these 2 business entities: C-Corp and LLC (partnership), on the following aspects: Responsibility for liability Taxation at entity level Taxation at individual owner level Treatment of Owner...

Answered: 1 week ago

Question

★★★★★
Using the substitution u = cosec x, or otherwise, find the exact value of cot3 x dx. (8 marks) 47

Answered: 1 week ago

Question

★★★★★
Suppose we have a credit score distribution that follows a normal distribution with a mean of 705 and standard deviation of 39. A person is randomly selected. Compute the probability that this person...

Answered: 1 week ago

Question

★★★★★
83. A baseball team of ten young teenagers is visiting town for a tournament today. Two of the players have swollen parotid (salivary) glands with cough and fever. You are called to evaluate and...

Answered: 1 week ago

Question

★★★★★
At the end of each of the last 14 years, Vanessa deposited $450 into an account that earned 8% compounded annually. a) What balance does she have in her account today? b) How much would there be in...

Answered: 1 week ago

Question

★★★★★
Question 19 (1 point) Saved Jim and Joanne are having a heated negotiation and Jim shouts at Joanne, "what the hell do you want?" Joanne takes a step back and responds to Jim in a calm voice, "how do...

Answered: 1 week ago

Question

★★★★★
Owning or leasing a warehouse can impact an operation's environmental sustainability. If a business chooses to lease, it can avoid the adverse environmental effects of new development. On the other...

Answered: 1 week ago

Question

★★★★★
15. Ask yourself the following questions: What do you want to remember from your everyday experiences? These are the experiences that fill most of your life. They may take 9099% of your time. What do...

Answered: 1 week ago

Question

★★★★★
What reward will you give yourself when you achieve this?

Answered: 1 week ago

Question

★★★★★
11. Now consider the different goals you have for your life in the future. See these goals in relation to your core values and your roles. How do goals affect your roles and your values? Development...

Answered: 1 week ago

Previous Question Next Question