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

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 2.1C

See similar textbooks

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.

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

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here