Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please tell me how to calculate returns and excess returns? An example would be appreciated for the first set of data. Alt O

Can someone please tell me how to calculate returns and excess returns? An example would be appreciated for the first set of data.
image text in transcribed
Alt O Books - Excel e Insert Draw Page Layout ViewHelp Formulas Data Review EX D H G Date Open High Low Close Adj Close"Volume 18-Dec 20 1.58 Dividend 1-Dec-20 365.57 378.46 362.03 3788 368 69 1,344,541,500 31-Oct-20 330.2 364.38 327.24 362.06 357,03 1,535,244,300 30-Sep-20 337.69 354.02 322.6 326.54 322 1,629,016, 100 18-Sep-20 1.339 Dividend 31-Aug-20 350.21 358.75 319,8 334 89 328.92 1.814,712,700 31-Jul-20 328.32 3513 327.73 349 31 343.08 1,045,563,300 30 Jun 20 309.57 327.23 309.07 326 52 320.7 1,505,145, 300 19-Jun-20 1.366 Dividend 31-May-20 303.62 323.41 296.74 308.16 301.54 2358,674 500 30-Apr-20 285.31 305.84 272.99 30432 297.59 1.910 460 500 31-Mar-20 247.98 294.88 243.9 290.48 284.05 2 819,312,300 20-Mar-20 1.406 Dividend 1 Mar 20 298.21 313.84 218.26 257.75 25057 5,925,017,600 1-Feb-20 323,35 339.08 285.54 296.26 285.01 2110 214,900 1-Jan-20 323 54 332.95 320,36 321.73 312.77 1,392,003,800 20-Dec-19 1.57 Dividend 1-Dec-19 314.59 3238 307.13 321 86 311.37 1.285,175.800 31-Oct-19 304.92 315.48 304.74 314 31 304,06 1,007,123,500 30-Sep-19 297.74 304.55 284.82 303 33 293.44 1.386 748,300 AMEN ANET SEP 500 Sheeto o Type here to search

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_2

Step: 3

blur-text-image_3

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

The Leverage Space Trading Model

Authors: Ralph Vince

1st Edition

0470455950, 978-0470455951

More Books

Students also viewed these Finance questions