S. No. A B 1 Years C D Investment amount Price per share No. of mutual fund shares 2 2018 3 2019 4 2020 5 2021 3250 32 =B2/C2 3250 40 =B3/C3 3250 37 =B4/C4 3250 39 =B5/C5 6 7 a) Total amount invested =SUM(B2:B5) 8 b) Total number of mutual fund shares =SUM(D2:D5) 9 c) Average cost of each mutual fund share=(C2+C3+C4+C5)/4

Chemistry: The Molecular Science
5th Edition
ISBN:9781285199047
Author:John W. Moore, Conrad L. Stanitski
Publisher:John W. Moore, Conrad L. Stanitski
Chapter13: The Chemistry Of Solutes And Solutions
Section13.7: Colligative Properties Of Solutions
Problem 13.16E: Suppose that you are closing a cabin in the north woods for the winter and you do not want the water...
icon
Related questions
Question
None
S. No.
A
B
1
Years
C
D
Investment amount Price per share No. of mutual fund shares
2
2018
3
2019
4 2020
5 2021
3250
32
=B2/C2
3250
40
=B3/C3
3250
37
=B4/C4
3250
39
=B5/C5
6
7
a) Total amount invested
=SUM(B2:B5)
8
b) Total number of mutual fund shares
=SUM(D2:D5)
9
c) Average cost of each mutual fund share=(C2+C3+C4+C5)/4
Transcribed Image Text:S. No. A B 1 Years C D Investment amount Price per share No. of mutual fund shares 2 2018 3 2019 4 2020 5 2021 3250 32 =B2/C2 3250 40 =B3/C3 3250 37 =B4/C4 3250 39 =B5/C5 6 7 a) Total amount invested =SUM(B2:B5) 8 b) Total number of mutual fund shares =SUM(D2:D5) 9 c) Average cost of each mutual fund share=(C2+C3+C4+C5)/4
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Chemistry: The Molecular Science
Chemistry: The Molecular Science
Chemistry
ISBN:
9781285199047
Author:
John W. Moore, Conrad L. Stanitski
Publisher:
Cengage Learning
Organic And Biological Chemistry
Organic And Biological Chemistry
Chemistry
ISBN:
9781305081079
Author:
STOKER, H. Stephen (howard Stephen)
Publisher:
Cengage Learning,
General, Organic, and Biological Chemistry
General, Organic, and Biological Chemistry
Chemistry
ISBN:
9781285853918
Author:
H. Stephen Stoker
Publisher:
Cengage Learning