Question: EXCEL FORMULAS PLEASE Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard

EXCEL FORMULAS PLEASE

Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion

Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard deviation Section a.. Proportion of A Proportion of B Portfolio average return Portfolio standard Section b. Min-variance portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard Company A Company B stock stock 10% 0.0800 28.28% 15% 0.1600 40.00% 0.00350 0.03094 B6/(B4*C4) 0.9 0.11-B10 10.50%

Step by Step Solution

★★★★★

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Certainly Lets break this down step by step Section a 1 Portfolio Proportions Proportion of A 09 90 ... 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

Students Have Also Explored These Related Finance Questions!

Jays Appliances sells micro-fridges according to the monthly demand distribution shown in the table at the top of the next page. Simulate 6 years of demand and compare theoretical and simulated...

Maureen Marcy is designing the layout for a new business in town, The Collegiate Spa. From visiting spas in neighboring towns, she has compiled the following data on movement between spa activities....

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

A fluid is flowing through a circular pipe of diameter D = 0.06 m and length L = 6 m. The mean velocity at the inlet is um = 0.001 m/s. The properties of the fluid are = 769 x 10-6 Ns/m, v = 0.773 x...

Consider the following statistics for a portfolio composed of shares of Companies A and B: a. Suggest a portfolio combination that improves return while maintaining the same level of risk. b....

Two Irish shares, AIB and Ryanair, have the following characteristics: Percentage in AIB 0.4 Percentage in RYANAIR 0.6 AIB Ryanair average 9.55% 8.25% variance 6.74% 14.43% standard deviation 25.96%...

Portfolio Company A and Company B average return of A 0.000641896 average return of B 0.000701279 variance 0.000935161 variance 0.000396354 standard deviation 0.030580402 standard deviation...

can I have it solved in formulas step by step please with the formulas and not in excel. thank you Question#2 Abigail Grace has a $800,000 fully invested original portfolio. She subsequently inherits...

1.0% Pg9 The following table contains annual returns for the stocks of Home Depot (HD) and Lowe's (LOW). The returns are calculated using end-of-year prices (adjusted for divi- dends and stock...

Consider a Poisson regression Y = Po(e). If n=10 and 1) Find the estimated variance of 2) Find the p-value for the test Ho: 0= 2 Xi = 3+ 10 6i n and i=1 XiYi = 1551

Consider the rotation operator. i(J.n)o U = exp which rotates about an axis through an angle 9. If we rotate about z-axis by an angle, then US,U (S is.x-component of spin angular momentum of spin-...

Include a picture for each problem. Find the area of the region between x + y 2 = 6 and x + y = 0 . Explain how you decided which variable should be the variable of integration. ( Do the integral by...

What is acid rain? Why is it called a rain? How do the acids form in the atmosphere? What are the adverse effects of acid rain on the environment?

How does energy conversion affect the environment? What are the primary chemicals that pollute the air? What is the primary source of these pollutants? 280C What is smog? What does it consist of? How...

Information from the unadjusted trial balance of Jumbo's on December 31, 2014, the end of the annual accounting period, is as follows: Required 1. Copy the unadjusted trial balance on a work sheet...

London Companys Forest City Plant produces precast ingots for industrial use. Anne-Marie Gosnell, who was recently appointed general manager of the Forest City Plant, has just been handed the plants...

Happy Valley Pet Products uses a standard costing system that applies overhead to products based on standard direct labour-hours allowed for actual output of the period. During the recent year, the...

Which of the following is nor a risk associated with a global strategy?Multiple ChoiceConcemrasing an activity in a single location makes the rest of the firm dependent on that location.A firm with...

Multiple Choices 1. Which of the following businesses is the least likely to be operated as a partnership? a. Accounting firms b. Doctors offices c. Lawyers offices d. Steel foundry 2. Which of the...

Assume stock XYZ does not pay dividends and has a market value of $98 per share. There is a 60-percent chance that the stock will trade for $130 in one year, and a 40-percent chance that it will...

Describe the relationship between the debt ratio and firm value when we consider the existence of bankruptcy costs. How do you view the agency costs when bankruptcy occurs?

Calculate the missing values

In addition to the basic trade discount of 20%, an outboard engine manufacturer gives a boat dealer an additional discount of 12.5% for providing follow-up warranty service, and a 5% discount for...

An invoice for $2365.00 has terms 2/10, n/30. The amount credited on a payment made within the discount period was $1365.00. What was the amount of the payment?