Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Please show formulas on Excel. Hilda's Hybrids Hilda's Hubby Government bond Expected return 30.00% 16.25% 10.00% Variance 0.2858 0.1000 Sigma 53.46% 31.62% Covariance of returns

Please show formulas on Excel.

	Hilda's Hybrids	Hilda's Hubby	Government bond
Expected return	30.00%	16.25%	10.00%
Variance	0.2858	0.1000
Sigma	53.46%	31.62%

Covariance of returns	0.0343
Correlation of returns	0.2026	<-- =B7/(B5*C5)

Weight in government bonds	40%
Weight in market portfolio	60%	<-- =1-B37
Expected return
Standard deviation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 3

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

Research In Finance

Authors: John W. Kensinger

1st Edition

0857245414, 978-0857245410

More Books

Students also viewed these Finance questions

Question

=+c. If a significance level of .05 is used for the twoway ANOVA, the interaction effect is significant (just as in general different glues work better with some materials than with others). So now...

Answered: 1 week ago

Question

★★★★★

A pump is required for 10 years at a remote location. The pump can be driven by an electric motor if a power line is extended to the site. Otherwise, a gasoline engine will be used. Use an annual...

Answered: 1 week ago

Question

★★★★★

Please show formulas on Excel. Hilda's Hybrids Hilda's Hubby Government bond Expected return 30.00% 16.25% 10.00% Variance 0.2858 0.1000 Sigma 53.46% 31.62% Covariance of returns 0.0343 Correlation...

Answered: 1 week ago

Question

★★★★★

Question 12 of 70 > HR MIN SEC Submit All Suppose the firm's production function is Q = Ki Li , where the MPK = L and MPL = 2Ki 3Ki 3Li If the rental rate of capital R is $35 and the wage rate W is...

Answered: 1 week ago

Question

★★★★★

Pick and product/service and trace the supply chain requirements from source to consumer. Consider the following: 1. Identify the ingredients: Find out where they are sourced. 2. Show physical...

Answered: 1 week ago

Question

★★★★★

A physician chooses to create different revenue accounts for physical examinations, office visits, and office surgical procedures. What advantage does this have over creating a combined revenue...

Answered: 1 week ago

Question

★★★★★

A FI has a $100 million portfolio of six-year Eurodollar bonds that have an 8 percent coupon. The bonds are trading at par and have a duration of five years. The FI wishes to hedge the portfolio with...

Answered: 1 week ago

Question

★★★★★

AstraZeneca is a British-Swedish multinational pharmaceutical and biotechnology company with its headquarters at the Cambridge Biomedical Campus in Cambridge, England. It wants to manufacture...

Answered: 1 week ago

Question

★★★★★

CS Publishing inc: Foreign exchange rate risk management case study Why is CS Pub changing its business model? what are pros and cons of making these changes?

Answered: 1 week ago

Question

★★★★★

Explain why each of these statements is not an effective way to convey the negative message: (Objective 4) a. I am sorry I must refuse your request. b. Therefore, following company policy seems to be...

Answered: 1 week ago

Question

★★★★★

You have been invited to speak at a campaign kick-off reception for Bob Baffle, a candidate for mayor in your city. Bob is a friend of yours, and you plan to support his candidacy. However, the date...

Answered: 1 week ago

Question

★★★★★

You own Clean Mist Carpets, a company that uses a chemical process for cleaning carpets and removing stains.You do not guarantee success but have a good reputation for stain removal. Mr. and Mrs....

Answered: 1 week ago

Previous Question Next Question