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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Medical Sciences
1.2K views

What is the main challenge most fish face when using their swim bladders? How are both...

General Management
1.2K views

The biggest international cross-over in recent years was Gangnam Style, whose popularity was driven by YouTube...

Physics
1.2K views

A standing wave is generated in a string so that 3 loops are present. The...

Calculus
1.2K views

204 Find dy dr if y e6x 2r

Calculus
1.2K views

K Determine whether the following statements are true and give an explanation or counterexample Assume...

Accounting
1.2K views

In addition to cash payments Electric Entertainments pay a loyalty fee for games and movies...

Accounting
1.2K views

The following transactions occurred during the 2020 fiscal year for the City of Evergreen. For...

Accounting
1.2K views

Which of the following would be classified as an investing activity on the statement of...

Accounting
1.2K views

Chocolate Bars, Inc (CB), manufactures creamy deluxe chocolate candy bars. The firm has developed three...

Accounting
1.2K views

PLEASE IGNORE ALL NUMBERS IN THE BOXES PART A PART B PART C...

Accounting
1.2K views

@heck my Won 2 Problem 07-03 (algo) 10 points Suppose the own price elasticity of...

Finance
1.2K views

For the following treasury bill bought in 2007, find (a) the price of the T-bill,...