Question
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.
- 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.
- What are the daily average and geometric mean if the HPYs (returns) for each of the securities?
- What is the YTD (whole period) HPR and HPY for each of the securities?
- Calculate the variance and the standard deviation for the returns (HPYs) for each of the securities.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started