Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. how to find covariance of a two security portfolio

How to find Covariance of a two security portfolio (excel) to use in covarianve calculation...

90.2K

Verified Solution

Question

Finance

How to find Covariance of a two security portfolio (excel) to use in covarianve calculation of market
I need to find the market beta of a target portfolio. In order to do that I need to do =covariance(target portfolio excess returns, market excess returns) / variance(market excess returns)
The problem is I have two secruites in the portfolio. So how do I go about the 'target portfolio excess returns' numbers

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1 A 6 foot tall mirror is leaned against a wall at an angle A...

Geometry
Q

4 The number of typos per page of a certain book has a Poisson distribution...

Basic Math
Q

The Downtown Parking Authority of Tampa, Florida, reported the following information for a sample of 220...

Statistics
Q

how the sequence of eruption of permanent dentition plays a role in the establishment of a...

Medical Sciences
Q

How do you calculate the factor of safety for a worm in a worm gear drive?...

Mechanical Engineering
Q

what regulations apply to assisted-living

General Management
Q

The Central Limit Theorer K An engineer is goin distributed weights Click here to view...

Statistics
Q

On the date of 1/1/2019, the construction company leased a machine from the Arab Company...

Accounting
Q

Paid? 1-6. If statistical mean value of the gravitational acceleration in some experiement is 9.7...

Accounting
Q

Marin Inc, a greeting eard comoary, had the following thatments prepared us af Dercenber at,2025....

Accounting
Q

Please, I need answer for this question. Thank youuuu Equipment that...

Accounting
Q

1.what is capital budgeting explain its needs and importance 2.what are the stages...

Accounting