Question: please attach the excel file Compute for the portfolio risk using the following given: weight AUB weight Bank of Commerce correlation coefficient Union Bank 12/24/2021

please attach the excel file please attach the excel file Compute for the portfolio risk using the

Compute for the portfolio risk using the following given: weight AUB weight Bank of Commerce correlation coefficient Union Bank 12/24/2021 12/23/2021 12/22/2021 12/21/2021 12/20/2021 X1 NAVPU 595.360143 598.689654 591.693834 595.695153 599.952801 Mean Return 0.70 0.30 0.26 X1 Return X1- Variance STD DEV (X1-)^2 Bank of Commer 12/28/2021 12/27/2021 12/26/2021 12/25/2021 12/24/2021 X1 NAVPU 0.747786 0.744087 0.744151 0.744181 0.744212 Mean Return X1 Return X1- Variance STD DEV (X1-)^2

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!

I need help with my part 1 and part 2.can you finished ,thank u FINA 415-15S PART 2 (VBA) # Worksheet Name 1 A 2 B Description Programing user defined function (30 marks) Subroutine to generate after...

I need help with part,can you help me finish it?thank u FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description...

Problem 3 (A Real Data Application). Recall in the simple linear regression model in Module 3, I gave a real data example using the Nobel-winning Capital Asset Pricing Model (CAPM). In that example,...

3 Inventory Holding Costs, actuals , December 4,009 units; $3759 - January -6,450 units; $6554 - February - 2,200 units; $2347, 3 Current Inventory Level (month of March) - 4000 units - Month 2 Jun...

ADC Auto Corporation is developing a new type of hybrid car. This car will generate sales over the next 10 years. Included is a static NPV model for the project. Inspect the model to better...

please work with this project by using excel sheet, please attach the excel file to the answers thank you so much. The Great American Mill satisfies all demand with either its own woven fabric or...

The following is the estimation results for a multiple linear regression model: Y = 0 + 1 X 1 + 2 X 2 + SUMMARY OUTPUT Regression Statistics R-Square 0.677 Standard Error of Regression ( S ) 803.190...

please attach an EXCEL file Create a table in Excel and solve for the following: 1. What percentage of students had an overall grade above 80%? 2. How many students had a grade of 5+ or higher? In...

Jacks Construction Co. (JCC) has 80,000 bonds outstanding that are currently selling at par (face) value. Bonds with similar characteristics are currently yielding 8.5%. The company also has 4...

Q.4 One important source of person needs assessment information is the potential trainees own opinions about their developmental needs. What are the advantages and disadvantages of relying on such...

Repeat Problem 10.14 (a), assuming that the population variances from untreated and treated steel plates are not equal. Compare these results with those of Problem 10.14 (a).

The painting technique associated with Minimalism that used masking tape to achieve crisp, clean edges was known asGroup of answer choicesglazing,pin - striping,hard - edge

Bramble Corporation, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost $215,619 and have an estimated useful life of 15 years. It will be sold for...

=+ a. A change in consumer preferences increases the saving rate.

=+ c. Better birth-control methods reduce the rate of population growth.

=+ d. A one-time, permanent improvement in technology increases the amount of output that can be produced from any given amount of capital and labor.