FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If we want to calculate the portfolio's return in Cell K9, what function can we enter? M average retumdev PFE 0.0002 0.020116 XOM 0.002162303 0.02

image text in transcribed
If we want to calculate the portfolio's return in Cell K9, what function can we enter? M average retumdev PFE 0.0002 0.020116 XOM 0.002162303 0.02 HD 0.001156128 0.02748 Spy 0.00076897 0.020305 TLT 0.000774721 0.013667 GLD 0.000367329 0.011617 Total weight Portfolio return Portfolio stev Sharpe OL IL EL A B E a H 1 Date PFE XOM HD SPY TLT GED Iwk T.bills 2 10/29/2019 0.0240411 0.00291 0.01123 0.0001 0.000656 0.00277 4,4306-OS 3 10/30/2019 0.007006224 0.01052 0.008969 0.003067 0.01454 0.00549 4.4106E-OS 4 10/31/2019 0.0028585 0.00022 0.00203 0.00266 0.01149 crg99 4.161105 5 11/1/2019 0.000521109 0.030043 0.011766 0.002264 0.00008 0.00093 0.00001125 6 11/4/2019 0.009377657 0.029741 0.0102 0.00001 -0.01316 0.00258 0.00004175 7 11/5/2019 -0.014662195 0.019513 0.01158 -0.00111 -0.01125 -0.0161 4.2167E-05 8 11/6/2019 0.003468667 0.02189 0.007795 0.000328 0.006052 0.00129 1.2083EOS 11/7/2019 0.00912254 0.021262 -0.00157 0.003517 -0.01812 0.01552 4.2167E-60 11/8/2019 0.00379285 0.01899 0.0004 0.00266 0.00210.00616 4.1944E05 11/11/2019 0.00323881 0.00608 -0.00147 -0.00191 0.000007 0.0024 4.2003-05 11/12/2019 0.001083148 0.01379 0.005695 0.002105 0.00159 0.0027 4.258-05 11/12/2019 -0.01000324 0.00022 0.007202 0.000324 0.000 0.000024.26396-05 10/14/2020 -0.001084038 0.00205 -0.01126 -0.00628 0.002267 0.00301 2.777-06 243 10/15/2020 -0.00110255 0.00075 0.001567 -0.00124 0.00173 0.001646 2.06 244 10/16/2030 0.03830329 -0,01016 0.000117 0.0006 -0.00278 0.00147 0.0000025 245 10/19/2020 -0.003952622 0.01994 0.01365 0.0152 0.00378 0.000505 0.0000025 246 10/20/2020 0,001200979 0.008378 0.000142 0.004006 0.00952 0,004021 2.6389-06 247 10/21/2020 0,010336249 -0.01602 -0.00535 -0.00169 -0.00345 0.007531 0.000005 248 10/22/2020 0.00943996 0.051267 0.01172 0.00545 -0.0101 -0.0098 2.3611-06 249 10/2a/2000 0.000037403 0.0200 0.00 0.003395 0.006113 0.00106 2.10566.00 250 10/26/2000 -0.0062099 -0.02371 0.0259 -0.01818 0.009300 -0.0005 2.2222-06 251 10/27/2020 0.014108651 -0.01454 0.010108 -0.0005 0.004452 0.001733 0.0000025 252 average retum 0.000399998 0.00216 0.001156 0.000757 0.000775 0.000967 1.6143E-OS 253stdev 0.020836353 0.030692 0.02743 0.020805 0.013667 0.011617 O-MMULT(M2M7 TRANSPOSEK2:7 O=MMULT(M2:M7.K2K7) O SUMIK2:7 -M2*K2+M3-K3-M4K4M5*K5M6K6+M7K

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

Venture capital and the finance of innovation

Venture capital and the finance of innovation

Authors: Andrew Metrick

2nd Edition

9781118137888, 470454709, 1118137884, 978-0470454701

More Books

Students also viewed these Finance questions

Question

Choose one of the groups discussed in the section Meeting Individual, Family, and Societal Needs and discuss their resource management needs (explain what they have or do not have and what they need).

Answered: 1 week ago

Question

★★★★★
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals....

Answered: 1 week ago

Question

★★★★★
If we want to calculate the portfolio's return in Cell K9, what function can we enter? M average retumdev PFE 0.0002 0.020116 XOM 0.002162303 0.02 HD 0.001156128 0.02748 Spy 0.00076897 0.020305 TLT...

Answered: 1 week ago

Question

★★★★★
Senior executives typically handle strategic planning decisions. Select one: O True OFalse

Answered: 1 week ago

Question

★★★★★
3) Employee A does the finishing work on 40% of the output at a clothing factory, employee B does 35%, and employee C 25%. Of the items finished by employee A, 10% are defective; 20% of the items...

Answered: 1 week ago

Question

★★★★★
10. Draw the profit/ loss graph for the following option strategies: a) Buy a put with 3 EURO premium and 70 EURO exercise prices b) How to write a call with 2 EURO premium and 50 EURO exercise prices

Answered: 1 week ago

Question

★★★★★
A firm has two $1,000, mutually exclusive investment alternatives with the following cash inflows. The cost of capital is 6 percent. Year Cash Inflow A B 1 $175 $1,100 2 175 - 3 175 - 4 175 - 5 175 -...

Answered: 1 week ago

Question

★★★★★
Butler Capital Partners and Autodistribution What is your assessment of Autodistribution's chances for pan-European expansion? If Autodistribution were publicly traded, what would you calculate the...

Answered: 1 week ago

Question

★★★★★
Scenario: You are a social work intern placed at a high school. You receive a referral to meet with a 15-year-old female student named Abby. The referral was made by Abby's homeroom teacher, who has...

Answered: 1 week ago

Question

★★★★★
Mr. Smiths lackadaisical attitude and callous behavior at the workplace warrants stern punitive action and could impact his promotion.

Answered: 1 week ago

Question

★★★★★
The next time you write something, check your average sentence length in a 100-word passage, and if your sentences average more than 16 to 20 words, see whether you can break up some of the sentences.

Answered: 1 week ago

Question

★★★★★
Dont pay more than you have to; you can get our new fragrance for a price of just $50.

Answered: 1 week ago

Previous Question Next Question