Question

ted has been dollar cost averaging in a mutual fund by investing $1500 at the beginning...

ted has been dollar cost averaging in a mutual fund by investing $1500 at the beginning of everg quarter for the past 5 years. he has been earning an average annual compound return of 9% compiunded quarterly on this investment. how much is the fund worth today?

Homework Answers

Answer #1

Formula sheet

A B C D E F G H
2
3 Calculation of Present Value of the fund:
4
5 Amount Deposited Each Quarter 1500
6 Number of Quarters(n) =5*4 years
7 Quarterly Interest rate (i) =9%/4
8
9 Present value of annuity =Annuity Amount*Present Value factor of annuity
10 =$1500*(P/A,2.25%,20)
11
12 (P/A,2.25%,20) =PV(D7,D6,-1,0) =PV(D7,D6,-1,0)
13
14 Present value of annuity =$1500*(P/A,2.25%,20)
15 =$1500*15.96
16 =D12*D5 =D12*D5
17
18 Hence Present Value of the fund is =D16
19
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An investment of $5,610 made five years ago in a stock mutual fund that earned an...
An investment of $5,610 made five years ago in a stock mutual fund that earned an annual compound return of 6.8% during the initial three years, followed by an annual compound return of 4% over the most recent two years would be worth how much today? Note: Please round your answer to the nearest dollar. For example, if the calculated value of the investment today is 1,234.78 enter it as: 1235 or 1,235.
Julian has been investing $1500 at the beginning of every six months for a long time...
Julian has been investing $1500 at the beginning of every six months for a long time and earning 11% compounded semiannually. His investments have now accumulated to $766,715. How long ago did he make the first $1500 payment?
You have invested in a particular mutual fund in the past. The fund has a 2%...
You have invested in a particular mutual fund in the past. The fund has a 2% front-end load and an expense ratio of 0.9%. The fund also has annual 12b-1 fees of 0.5%. Fund assets have returned on average 12% per year over the life of the fund. If you invest $10,000 in this fund, what total dollar amount would your investment be worth if you planned to hold the fund for 4 years? Assume the fund has the same...
You have invested in a particular mutual fund in the past. The fund has a 2%...
You have invested in a particular mutual fund in the past. The fund has a 2% front-end load and an expense ratio of 0.9%. The fund also has annual 12b-1 fees of 0.5%. Fund assets have returned on average 12% per year over the life of the fund. If you invest $10,000 in this fund, what total dollar amount would your investment be worth if you planned to hold the fund for 4 years? Assume the fund has the same...
Ted, a mutual fund manager, has a $40 million portfolio with a beta of 1.00. The...
Ted, a mutual fund manager, has a $40 million portfolio with a beta of 1.00. The risk-free rate is 4.25%, and the market risk premium is 7.00%. Ted expects to receive an additional $60 million, which she plans to invest in additional stocks. After investing the additional funds, she wants the fund's required and expected return to be 13.00%. What must the average beta of the new stocks be to achieve the target required rate of return? *Show the formula...
Eight Years ago, Larry invested 6000 into a mutual fund which Compounds continuously. Today, Larry's mutual...
Eight Years ago, Larry invested 6000 into a mutual fund which Compounds continuously. Today, Larry's mutual fund is worth 8500. What is the annual rate of return, stated as a percentage for Larry's investment? Show all work.
An investor has ​$60000 to invest in a CD and a mutual fund. The CD yields...
An investor has ​$60000 to invest in a CD and a mutual fund. The CD yields 7​% and the mutual fund yields 5​%. The mutual fund requires a minimum investment of ​$9 000​, and the investor requires that at least twice as much should be invested in CDs as in the mutual fund. How much should be invested in CDs and how much in the mutual fund to maximize the​ return? What is the maximum​ return? To maximize​ income, the...
Your mutual fund has just sent you its annual performance review. In it, you are told...
Your mutual fund has just sent you its annual performance review. In it, you are told that the returns for the past 3 years were: a loss of 20% three years ago, a 10% gain two years ago, and a 25% gain last year. The opening remark in the review says you will be glad to know your fund has provided an average return of 5% over the past three years. Suppose you initially invested $1,000 three years ago. If...
Peter's retirement fund has an accumulated amount of $40,000. If it has been earning interest at...
Peter's retirement fund has an accumulated amount of $40,000. If it has been earning interest at 3.92% compounded monthly for the past 19 years, calculate the size of the equal payments that he deposited at the beginning of every 3 months.
QUESTION 6 Bob has been investing $5,500 in stock at the end of every year for...
QUESTION 6 Bob has been investing $5,500 in stock at the end of every year for the past 13 years. If the account is currently worth $125,700, what was his annual return on this investment? 10.21% 8.93% 8.25% 8.49% 9.93% QUESTION 5 Fancy Cat Products has a project that will cost $260,500 today and will generate monthly cash flows of $5,485 for the next 70 months. What is the rate of return of this project when expressed as an APR?...