A B E F G 1 Date Open High Low Close Adj Close Volume 2 1/1/1985 247.1 278.9 245.8 278.7 278.7 1.78E+09 3 2/1/1985 277.9 289.3 277.9 284.2 284.2 1.74E+09 4567 3/1/1985 285.1 287.8 275.6 279.2 279.2 1.61E+09 4/1/1985 279.5 284.8 276.2 280.6 280.6 1.51E+09 5/1/1985 280.5 294.8 278.8 290.8 290.8 1.67E+09 6/1/1985 291.4 296.2 286.7 296.2 296.2 1.58E+09 00 8 7/1/1985 295.9 307.9 295.5 301.3 301.3 1.77E+09 9 8/1/1985 302.6 304.6 295.1 297.7 297.7 1.64E+09 10 9/1/1985 297.3 297.7 279.5 280.3 280.3 1.33E+09 11 10/1/1985 280.6 292.8 276.6 292.5 292.5 1.86E+09 12 11/1/1985 293 314 292.5 314 314 1.84E+09 13 12/1/1985 313.9 325.6 312.3 324.9 324.9 2.21E+09 14 1/1/1986 325 335.8 322.1 335.8 335.8 2.41E+09 15 2/1/1986 336.1 359.8 335.8 359.5 359.5 2.35E+09 16 3/1/1986 360 374.7 359.1 374.7 374.7 2.6E+09 17 4/1/1986 375.8 393 368 383.2 383.2 2.81E+09 18 5/1/1986 383.2 400.4 381.5 400.2 400.2 2.41E+09 19 6/1/1986 400.7 405.5 391.8 405.5 405.5 2.57E+09 20 7/1/1986 407 411.3 369.1 371.4 371.4 2.41E+09 21 8/1/1986 372.5 383.2 364.4 382.9 382.9 2.1E+09 22 9/1/1986 382.8 384 342.3 350.7 350.7 2.2E+09 23 10/1/1986 352.5 361.6 351.2 360.8 360.8 2.15E+09 24 11/1/1986 361 362.5 349.1 359.6 359.6 2.07E+09 25 12/1/1986 357.4 364.7 347 348.8 348.8 2.61E+09 26 1/1/1987 351.3 396.2 348.8 392.1 392.1 3.18E+09 27 2/1/1987 393 8 125 392 125 125 3.035+09
A B E F G 1 Date Open High Low Close Adj Close Volume 2 1/1/1985 247.1 278.9 245.8 278.7 278.7 1.78E+09 3 2/1/1985 277.9 289.3 277.9 284.2 284.2 1.74E+09 4567 3/1/1985 285.1 287.8 275.6 279.2 279.2 1.61E+09 4/1/1985 279.5 284.8 276.2 280.6 280.6 1.51E+09 5/1/1985 280.5 294.8 278.8 290.8 290.8 1.67E+09 6/1/1985 291.4 296.2 286.7 296.2 296.2 1.58E+09 00 8 7/1/1985 295.9 307.9 295.5 301.3 301.3 1.77E+09 9 8/1/1985 302.6 304.6 295.1 297.7 297.7 1.64E+09 10 9/1/1985 297.3 297.7 279.5 280.3 280.3 1.33E+09 11 10/1/1985 280.6 292.8 276.6 292.5 292.5 1.86E+09 12 11/1/1985 293 314 292.5 314 314 1.84E+09 13 12/1/1985 313.9 325.6 312.3 324.9 324.9 2.21E+09 14 1/1/1986 325 335.8 322.1 335.8 335.8 2.41E+09 15 2/1/1986 336.1 359.8 335.8 359.5 359.5 2.35E+09 16 3/1/1986 360 374.7 359.1 374.7 374.7 2.6E+09 17 4/1/1986 375.8 393 368 383.2 383.2 2.81E+09 18 5/1/1986 383.2 400.4 381.5 400.2 400.2 2.41E+09 19 6/1/1986 400.7 405.5 391.8 405.5 405.5 2.57E+09 20 7/1/1986 407 411.3 369.1 371.4 371.4 2.41E+09 21 8/1/1986 372.5 383.2 364.4 382.9 382.9 2.1E+09 22 9/1/1986 382.8 384 342.3 350.7 350.7 2.2E+09 23 10/1/1986 352.5 361.6 351.2 360.8 360.8 2.15E+09 24 11/1/1986 361 362.5 349.1 359.6 359.6 2.07E+09 25 12/1/1986 357.4 364.7 347 348.8 348.8 2.61E+09 26 1/1/1987 351.3 396.2 348.8 392.1 392.1 3.18E+09 27 2/1/1987 393 8 125 392 125 125 3.035+09
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
3. Excel Question. Download the monthly NASDAQ prices (1985-2023) from Brightspace.
What is the simple arithmetic average return over this period?
What would have been your annualized HPR if you invested (reinvesting the proceeds)
over this period?
Disregard the question above because I cant attach the entire excel file but i will attach a screenshot. Please just tell me and explain to me which column do i use to find the arithmetic average return for this period and also how to calculate the annualized HPR over this period. I am just confused which column and which numbers to use.
Transcribed Image Text:A
B
E
F
G
1 Date
Open High
Low
Close Adj Close Volume
2
1/1/1985
247.1
278.9
245.8
278.7
278.7 1.78E+09
3 2/1/1985
277.9
289.3
277.9
284.2
284.2 1.74E+09
4567
3/1/1985
285.1
287.8
275.6
279.2
279.2 1.61E+09
4/1/1985
279.5
284.8
276.2
280.6
280.6 1.51E+09
5/1/1985
280.5
294.8
278.8
290.8
290.8 1.67E+09
6/1/1985
291.4
296.2
286.7
296.2
296.2 1.58E+09
00
8
7/1/1985
295.9
307.9
295.5
301.3
301.3 1.77E+09
9
8/1/1985
302.6
304.6
295.1
297.7
297.7 1.64E+09
10
9/1/1985
297.3
297.7
279.5
280.3
280.3 1.33E+09
11 10/1/1985
280.6
292.8
276.6
292.5
292.5 1.86E+09
12 11/1/1985
293
314
292.5
314
314 1.84E+09
13 12/1/1985
313.9
325.6
312.3
324.9
324.9 2.21E+09
14 1/1/1986
325
335.8
322.1
335.8
335.8 2.41E+09
15 2/1/1986
336.1
359.8
335.8
359.5
359.5 2.35E+09
16
3/1/1986
360
374.7
359.1
374.7
374.7 2.6E+09
17 4/1/1986
375.8
393
368
383.2
383.2 2.81E+09
18 5/1/1986
383.2
400.4
381.5
400.2
400.2 2.41E+09
19 6/1/1986
400.7
405.5
391.8
405.5
405.5 2.57E+09
20 7/1/1986
407
411.3
369.1
371.4
371.4 2.41E+09
21 8/1/1986
372.5
383.2
364.4
382.9
382.9 2.1E+09
22 9/1/1986
382.8
384
342.3
350.7
350.7 2.2E+09
23 10/1/1986
352.5
361.6
351.2
360.8
360.8 2.15E+09
24 11/1/1986
361
362.5
349.1
359.6
359.6 2.07E+09
25 12/1/1986
357.4
364.7
347
348.8
348.8 2.61E+09
26 1/1/1987
351.3
396.2
348.8
392.1
392.1 3.18E+09
27 2/1/1987
393 8
125
392
125
125 3.035+09
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education