Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

find risk free rate and sharpe ratio DUUUUU WUUw Help Stocktrak_Tracker_Fall2020 (4).xls (Compatibility Mode] Insert Page Layout Formulas Data Review View She Arial 10 '

find risk free rate and sharpe ratio
image text in transcribed
image text in transcribed
DUUUUU WUUw Help Stocktrak_Tracker_Fall2020 (4).xls (Compatibility Mode] Insert Page Layout Formulas Data Review View She Arial 10 ' ' % v Conditional Formatting Format as Table Cell Styles B 1 Av Alignment Number Cells Editing scription Required to edit and Save Start your free one month trial of Microsoft 365 or sign in to activate an existing su... Activa H 7.335 34 15:20 30 3830 $0.00 2.1 Market Capitation 34560 1.11 352.766 1.60 405 110 0.28 404.60 081 205 826 DO 563 00 113 30542 131 203 1.35 1651 49 000 105 Company Name Tick PACIEC ETHANOLING PEEX MASTERCARD TESLA TSLA WALMART WUT NIKE NIKE COSTCO COST UP MORGAN JPM APPLE AMAZON NOUS DEPOT CLOROK GLX FEDEX FOX GENERAL MILLS INC CE ALPHABETING GOOG CANADA GOOSE HOLDINGS INDOOS MICROSOFT MISET NESTE CORPORATION NOU 1643 Purchase price free $ 8.54 3405 3 434.90 3 136.51 127.96 345.23 5 5 5 2151 24 278.28 20472 3 27575 59 30 1.75961 3520 5 2232 58.00 Sale Price Sale Proceed Dollar 10,000 5 18.400.00 -871 100003 105 103 351043 35230 5 10 $ 4349 00 S 4333 4340.00 $ 30 S 4.095 305 1425 20 $ 2559.00 5 131.195 2015 69 $ 20,713.95 6. S 22.1425 33 33377155 20 3 2.2800.00 $ 118.00 2390.40 2 78.721.00 5 329.000 10 1 29265 2,52200 20 4,09440 207385 4,1470 S SS 137 s 27015 20.550 SOS 2,084 SOS 60.975 SO 10 3 17,506.10 1.777.213 205 705205 2015 4476403 10 S 300.000 500 AM TO 130 1.09 1077 1978.698 024.263038 097444 1001111 0.37 18147 0.51 48.00 118 400 14 1.1438280 13 216513 15.00 + 19 Home Insert Page Layout Formulas WAJ Lumpatibility Mode] View Data Review X Arial 10 v a. Av % Paste BI U Alignment Number Conditional Formatting Format as Table Cell Styles Subscription Required to edit and Save Start your free one month trial of Microsoft 365 or sign in to activate an e E30 B D E 2 Week of S&P 500 S&P 500 Retums YOUR PORTFOLIO VALUE YOUR PORTFOLIO RETURNS 3 4-Sep-20 357.7 $ 500,000.00 4 11-Sep-20 343.37 -0.040061504 $ 499.870.00 5 18-Sep-20 -0.00026 345.45 0.006057605 $ 502,245.00 0.004751235 25-Sep-20 344.23 -0.003531625 $ 508,764.00 0.012979721 7 2-Oct-20 345.87 0.004764256 $ 512,302.00 0.006954108 8 9-Oct-20 346.85 0.002833435 $ 518,127.00 0.011370246 9 16-Oct-20 343.39 -0.009975494 $ 512,958.43 -0.009975489 10 23-Oct-20 342.65 -0.002154984 $ 511,853.01 -0.002154989 11 30-Oct-20 328.54 -0.047015905 $ 487,787.78 -0.0470159 12 6-Nov-20 350.16 0.07233417 $ 481,432.55 -0.013028678 13 13-Nov-20 355.65 0.015436525 $ 483.498.40 0.004291048 14 15 total -0.13% 3.21% 16 17 18 19 20 21 22 23 NNNN 28

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

Introduction To Derivatives And Risk Management

Authors: Robert Brooks, Don M Chance

9th Edition

1133190197, 978-1133190196

More Books

Students also viewed these Finance questions