Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I complete the Border-Multiplied Covariance matrix using excel? Covariance Matrix COST WMT NFLX WFC AAPL DAL GM KGC COST 0.0029788 WMT 0.001535409 0.00275967

image text in transcribedHow do I complete the Border-Multiplied Covariance matrix using excel?

Covariance Matrix COST WMT NFLX WFC AAPL DAL GM KGC COST 0.0029788 WMT 0.001535409 0.00275967 NFLX 0.001391567 0.0010314 0.010967726 WFC 0.00058232 0.00088953 0.000267952 0.007850295 AAPL 0.001985772 0.00128441 0.002553446 0.001208245 0.00710059 DAL 0.000697636 0.00049382 -0.00037748 0.006209854 0.00186505 0.01102706 GM 0.001012181 0.00105115 0.001443389 0.004151166 0.00231797 0.005273822 0.009708045 KGC 0.001317887 0.00147089 0.000953946 -0.00024342 0.00166331 -0.00178923 0.000317854 0.718193774 Border-Multiplied Covariance Matrix s Portfolio wetghts COST WMT NFLX WFC AAPL DAL GM KGC 5 5 27 3 COST WMT NFLX WFC AAPL DAL GM KGC 0.0000 . 1 2 3 0 0 0 0 0 0 0 0 Covariance Matrix COST WMT NFLX WFC AAPL DAL GM KGC COST 0.0029788 WMT 0.001535409 0.00275967 NFLX 0.001391567 0.0010314 0.010967726 WFC 0.00058232 0.00088953 0.000267952 0.007850295 AAPL 0.001985772 0.00128441 0.002553446 0.001208245 0.00710059 DAL 0.000697636 0.00049382 -0.00037748 0.006209854 0.00186505 0.01102706 GM 0.001012181 0.00105115 0.001443389 0.004151166 0.00231797 0.005273822 0.009708045 KGC 0.001317887 0.00147089 0.000953946 -0.00024342 0.00166331 -0.00178923 0.000317854 0.718193774 Border-Multiplied Covariance Matrix s Portfolio wetghts COST WMT NFLX WFC AAPL DAL GM KGC 5 5 27 3 COST WMT NFLX WFC AAPL DAL GM KGC 0.0000 . 1 2 3 0 0 0 0 0 0 0 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Modeling Financial Time Series With S PLUS

Authors: Eric Zivot, Jiahui Wang

2nd Edition

0387279652, 0387323481, 9780387279657, 9780387323480

More Books

Students also viewed these Finance questions