You purchased 500 shares of The New Century Fund at NAV of $23.56 last year. The fund distributed $4.35 in dividends at the end of the year and the current NAV is $21.78. What is the adjusted closing price of your purchase?   Please show how to solve in excel

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter2: Descriptive Statistics
Section: Chapter Questions
Problem 17P: Suppose that you initially invested 10,000 in the Stivers mutual fund and 5,000 in the Trippi mutual...
icon
Related questions
Question

You purchased 500 shares of The New Century Fund at NAV of $23.56 last year. The fund distributed $4.35 in dividends at the end of the year and the current NAV is $21.78. What is the adjusted closing price of your purchase?

 

Please show how to solve in excel

 

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Mutual Funds
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning