Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am attaching an Excel file to this assignment. The file contains daily adjusted closing prices for four securities: (1) S&P 500, (2) Apple Inc.

I am attaching an Excel file to this assignment. The file contains daily adjusted closing prices for four securities: (1) S&P 500, (2) Apple Inc. (AAPL), Microsoft Corp. (MSFT), and Tesla Inc (TSLA). These adjusted prices already incorporate any potential income component source of return, such as dividends paid.

Use the attached file to perform the following calculations and answer the following questions.

  1. Calculate the daily HPRs and HPYs, and the daily value of a Cummulative Wealth Index (CWI), for each of the securities, assuming an investment of USD 1 at the beginning of the period.
  2. What are the daily average and geometric mean if the HPYs (returns) for each of the securities?
  3. What is the YTD (whole period) HPR and HPY for each of the securities?
  4. Calculate the variance and the standard deviation for the returns (HPYs) for each of the securities.
  5. Estimate the Coefficient of Variation of the daily returns for each of the securities under analysis. During this period, which was the best investment assuming that you want to minimize risk and maximize return? In your answer, you are assuming that you cannot combine any of the securities provided. In other words, you must invest all your money in one of the securities.

DateSP500 Adj CloseAPPL Adj CloseMSFT Adj CloseTSLA Adj Close1/2/203257.850098298.292145159.352386430.260011/3/203234.850098295.39212157.368179443.010011/6/203246.280029297.74588157.774948451.5400091/7/203237.179932296.345581156.336395469.0599981/8/203253.050049301.11264158.826569492.1400151/9/203274.699951307.508545160.810776481.3399961/10/203265.350098308.203705160.066711478.1499941/13/203288.129883314.7883161.991394524.8599851/14/203283.149902310.537628160.850479537.9199831/15/203289.290039309.206818161.892197518.51/16/203316.810059313.080078164.858597513.489991/17/203329.620117316.546204165.781265510.51/21/203320.790039314.401001165.185989547.2000121/22/203321.75315.523285164.392303569.5599981/23/203325.540039317.042786165.404251572.2000121/24/203295.469971316.129059163.737518564.8200071/27/203243.629883306.833191160.999283558.020021/28/203276.23999315.513306164.154221566.9000241/29/203273.399902322.117737166.713821580.989991/30/203283.659912321.65097171.416428640.8099981/31/203225.52002307.389374168.886551650.5700072/3/203248.919922306.545197173.0038157802/4/203297.590088316.665344178.698502887.0599982/5/203334.689941319.247589178.48024734.7000122/6/203345.780029322.981781182.180817748.9600222/7/203327.709961318.591583182.438751748.0700072/10/203352.090088320.104767187.210785771.2800292/11/203357.75318.173462182.984406774.3800052/12/203379.449951325.729401183.252274767.2899782/13/203373.939941323.409851182.2601788042/14/203380.159912323.489502183.887222800.0300292/18/203370.290039317.566223185.752396858.4000242/19/203386.149902322.165466186.309494917.4199832/20/203373.22998318.860352183.46431899.4099732/21/203337.75311.642975177.664529012/24/203225.889893296.839783170.004425833.7899782/25/203128.209961286.785187167.199051799.9099732/26/203116.389893291.334656169.288147778.7999882/27/202978.76001272.290649157.3602916792/28/202954.219971272.131348161.170441667.989993/2/203090.22998297.466949171.894577743.6199953/3/203003.370117288.019653163.657486745.510013/4/203130.120117301.379303169.666183749.53/5/203023.939941291.603455165.408371724.5399783/6/202972.370117287.730957160.732742703.479983/9/202746.560059264.973694149.8394626083/10/202882.22998284.057526160.08609645.3300173/11/202741.379883274.192047152.833878634.229983/12/202480.639893247.114319138.339371560.5499883/13/202711.02002276.720642158.006912546.6199953/16/202386.129883241.121384134.718231445.0700073/17/202529.189941251.723511145.810471430.2000123/18/202398.100098245.561325139.672424361.2200013/19/202409.389893243.67981141.970474427.6400153/20/202304.919922228.209671136.638245427.5299993/23/202237.399902223.361542135.275345434.2900093/24/202447.330078245.770386147.5712895053/25/202475.560059244.416489146.15863539.253/26/202630.070068257.278442155.301025528.1599733/27/202541.469971246.626511148.924225514.3599853/30/202626.649902253.664734159.399673502.1300053/31/202584.590088253.147079156.8927315244/1/202470.5239.827225151.321747481.5599984/2/202526.899902243.829147154.455414454.4700014/3/202488.649902240.324966153.032837480.010014/6/202663.679932261.290314164.413544516.239994/7/202659.409912258.263977162.642776545.4500124/8/202749.97998264.874146164.274277548.8400274/9/202789.820068266.785492164.2842255734/13/202761.629883272.021881164.652313650.9500124/14/202846.060059285.759827172.799866709.8900154/15/202783.360107283.151611170.989304729.8300174/16/202799.550049285.401459176.122543745.2100224/17/202874.560059281.528931177.674484753.8900154/20/202823.159912275.685303174.152817746.3599854/21/202736.560059267.163788166.950348686.7199714/22/202799.310059274.859039172.620804732.1099854/23/202797.800049273.793854170.531677705.6300054/24/202836.73999281.698181173.645462725.1500244/27/202878.47998281.897278173.148056798.754/28/202863.389893277.327881168.930023769.1199954/29/202939.51001286.436798176.510529800.510014/30/202912.429932292.479492178.281311781.8800055/1/202830.709961287.770752173.665375701.3200075/4/202842.73999291.842377177.913223761.1900025/5/202868.439941296.222595179.823273768.2100225/6/202848.419922299.278778181.594055782.5800175/7/202881.189941302.374786182.648575780.0399785/8/202929.800049309.571838183.722946819.4199835/11/202930.189941314.443054185.772293811.2899785/12/202870.120117310.849548181.564194809.4099735/13/202820307.096283178.818512790.9600225/14/202852.5308.98291179.594467803.3300175/15/202863.699951307.156189182.210846799.1699835/18/202953.909912314.393127183.951767813.6300055/19/202922.939941312.576447182.678406808.010015/20/202971.610107318.655487185.21228815.5599985/21/202948.51001316.279755182.987656827.5999765/22/202955.449951318.316101183.067459816.8800055/26/202991.77002316.159973181.132156818.8699955/27/203036.129883317.537476181.371567820.229985/28/203029.72998317.677216180.962555805.8099985/29/203044.310059317.367798182.808098356/1/203055.72998321.270752182.389114898.0999766/2/203080.820068322.758057184.464096881.5599986/3/203122.870117324.534851184.91301882.9600226/4/203112.350098321.739899182.478882864.3800056/5/203193.929932330.903381186.748566885.6599736/8/203232.389893332.859833187.905777949.9199836/9/203207.179932343.37088189.3423940.6699836/10/203190.139893352.204956196.3653261025.0500496/11/203002.100098335.295441185.820816972.8400276/12/203041.310059338.190216187.287277935.2800296/15/203066.590088342.372681188.484375990.9000246/16/203124.73999351.44632193.10321982.1300056/17/203113.48999350.957214193.771591991.7899786/18/203115.340088351.096985195.8465881003.9600226/19/203097.73999349.090576194.6793981000.9000246/22/203117.860107358.224121200.086334994.3200076/23/203131.290039365.870331201.4230961001.7800296/24/203050.330078359.411987197.362915960.8499766/25/203083.76001364.18338199.856873985.979986/26/203009.050049352.993561195.856552959.739996/29/203053.23999361.128876197.9614721009.3499766/30/203100.290039364.143433203.0192261079.8100597/1/203115.860107363.454681204.206361119.6300057/2/203130.01001363.454681205.7626041208.6600347/6/203179.719971373.177155210.1918951371.5799567/7/203145.320068372.019257207.7478031389.8599857/8/203169.939941380.683624212.3167721365.8800057/9/203152.050049382.320679213.8031771394.2800297/10/203185.040039382.989471213.1547391544.6500247/13/203155.219971381.222656206.5706631497.0600597/14/203197.52002387.531281207.847581516.8000497/15/203226.560059390.196472207.5383151546.010017/16/203215.570068385.395111203.4282531500.6400157/17/203224.72998384.616516202.3907621500.8399667/20/203251.840088392.721924211.08973716437/21/203257.300049387.301697208.2465971568.3599857/22/203276.02002388.38974211.2393651592.3299567/23/203235.659912370.711609202.0515751513.0699467/24/203215.629883369.793243200.81457514177/27/203239.409912378.557434203.3584291539.5999767/28/203218.439941372.338684201.5328371476.489997/29/203258.439941379.4758203.5679171499.1099857/30/203246.219971384.067535203.4082951487.489997/31/203271.120117424.275024204.515611430.760018/3/203294.610107434.965759216.01780714858/4/203306.51001437.870514212.7756514878/5/203327.77002439.457642212.4264981485.020028/6/203349.159912454.790009215.8282781489.5799568/7/203351.280029444.450012211.9676061452.7099618/10/203360.469971450.910004207.7478031418.5699468/11/203333.689941437.5202.8895571374.3900158/12/203380.350098452.040009208.6855471554.760018/13/203373.429932460.040009208.19671616218/14/203372.850098459.630005208.396241650.7099618/17/203381.98999458.429993209.7729191835.6400158/18/203389.780029462.25210.9799961887.0899668/19/203374.850098462.829987209.6999971878.5300298/20/203385.51001473.100006214.5800022001.8299568/21/203397.159912497.480011213.0200042049.97998

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

Financial Management Theory And Practice

Authors: Eugene Brigham, Michael Ehrhardt, Jerome Gessaroli, Richard Nason

3rd Canadian Edition

017658305X, 978-0176583057

More Books

Students also viewed these Finance questions

Question

What are the four temperament types included in Pavlovs system?

Answered: 1 week ago