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.
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