how to calculate excess returns in excel.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

INV2 4a

Can you help me learn how to calculate excess returns in excel. I attached my document to look at. Or maybe provide me a reference page to read from.

oh i can't attach an excel but i put a picture of some of the data.

Date
lopen
High
Low
Close
Adj Close Volume
2012-01-01
51.2
54.85
51.12
51.53 33.28894 46277100
2012-02-01
51.94
54.53
50.6
53.35 34.46467 59101600
2012-03-01
53.75
57.17
52.26
55.88 36.09909 61317800
2012-04-01
55.61
56.27
53.79
54.8 35.74941 35876200
2012-05-01
54.86
54.89
50.26
52.97 34.55558 41925100
2012-06-01
52.3
53.57
50.55
52.74 34.40553 39957200
2012-07-01
53.06
54.03
50.51
52.35 34.50916 43754700
2012-08-01
52.5
53.65
51.25
52.25 34.44324 43968300
2012-09-01
52.25
55
51.92
53.92 35.54411 49454600
Transcribed Image Text:Date lopen High Low Close Adj Close Volume 2012-01-01 51.2 54.85 51.12 51.53 33.28894 46277100 2012-02-01 51.94 54.53 50.6 53.35 34.46467 59101600 2012-03-01 53.75 57.17 52.26 55.88 36.09909 61317800 2012-04-01 55.61 56.27 53.79 54.8 35.74941 35876200 2012-05-01 54.86 54.89 50.26 52.97 34.55558 41925100 2012-06-01 52.3 53.57 50.55 52.74 34.40553 39957200 2012-07-01 53.06 54.03 50.51 52.35 34.50916 43754700 2012-08-01 52.5 53.65 51.25 52.25 34.44324 43968300 2012-09-01 52.25 55 51.92 53.92 35.54411 49454600
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education