Question: Please answer in Excel and show steps: Dennis has been dollar cost averaging in a mutual fund by investing $1,000 at the beginning of every

Please answer in Excel and show steps: Dennis has been dollar cost averaging in a mutual fund by investing $1,000 at the beginning of every quarter for the past 5 years. He has been earning an average annual compound rate of return of 11% compounded quarterly. What is the value of the fund today?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Case 1. Calculate the present value of $10,000 to be received in exactly 10 years, assuming an annual interest rate of 9% .\ Case 2. Calculate the future value of $10,000 invested for 10 years,...

Case 3 . Dennis has been dollar cost averaging in a mutual fund by investing $ 1 , 0 0 0 at the beginning of every quarter for the past 5 years. He has been earning an average annual compound return...

The Mutual Fund Concept: A mutual fund is a type of financial services organization that receives money from a pool of shareholders and then invests those funds in a portfolio of securities. The...

Financial planning questions 1. Betty earns $100,000 working as a part-time lawyer in New Orleans. The company provides a matching contribution in the 401(k) plan of 50% up to a maximum contribution...

no excel please Marge has been dollar cost averaging in a mutual fund by investing 1,500 at the end of every quarter for the past 4 years. She has been earning an average annual compound return of...

1) Maggie wants to withdraw $1,200 at the beginning of each month for the next 5 years. She expects to earn 10% compounded monthly on her investments. What lump sum should Maggie deposit today? N= I=...

Rafael has been dollar cost averaging in a mutual fund by investing $ 1 , 5 0 0 at the beginning of every quarter for the past 5 years. He has been earning an average annual compound return of 9 %...

O $38,208.04 O$38,737.18 $39,274.91 1 p QUESTION 29 Michael has been dollar cost averaging in a mutual fund by investing $2,100 at the beginning of every quarter for the past 7 years. He earns an...

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

Q4. What evolutions on fees charged by traditional mutual funds have been seen from 1975 to 2019? When did Exchange-Traded Funds (ETF) become available as an alternative to (index) mutual funds...

A bank is planning to perform efficiency analysis to learn which branch offices are efficient and how to operation of inefficient units can be improved. All the six units performed 10000 transactions...

Find the most recent summary of the survey of economic forecasters in the Wall Street Journal (June 2018).What are the predictions for changes in real GDP and its major components, inflation, and...

When a corporation s shares are owned by a few individuals

A random sample of 43 biology students in a science program are selected for a study. Of those selected, only 27 passed the mid term exam. At the 5% significance level, is there sufficient evidence...

(Appendices) Ken, age 52, works only part-time and has no health insurance. The cartilage in both his knees is severely eroded from osteoarthritis, which causes severe pain during his daily...

(Appendices) Select a commonly used product, such as gasoline or milk, and track the prices of this product over a 20-year period by creating a line graph. Explain price increases and decreases based...

(Appendices) Search magazines, newspapers, and the Internet for advertisements. Collect or print out ads that offer the following: (a) something for nothing, (b) bonus for early reply, (c) offers of...