12. A mutual fund has been advertising that, had you deposited $250 per month in the fund for the last 10 years, you would now have accumulated $85,000. Assuming that these deposits were made at the beginning of each month for a period of 120 months, calculate the effective annual return fund investors got. Hint: Set up the following spreadsheet and then use Goal Seek. 1 Monthly payment 2 Number of months A B 250 120

12. A mutual fund has been advertising that, had you deposited $250 per month in the fund for the last 10 years, you would now have accumulated $85,000. Assuming that these deposits were made at the beginning of each month for a period of 120 months, calculate the effective annual return fund investors got. Hint: Set up the following spreadsheet and then use Goal Seek. 1 Monthly payment 2 Number of months A B 250 120

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...

See similar textbooks

Similar questions

I NEED TO SOLVE THİS USIİNG EXCEL Suppose you invest into Fund X for 15 months with a monthly interest rate of 8%. Each month you pay $260 calculate the ending value in the red shaded area. 1 Suppose you found the Ending Value. You would like to observe the Ending Value for various monthly payments which are $100, $200, $300, and $400 Create one-way data table to see the annual payments for the interest rates in green shaded area. 2 4 5 INVESTMENTS Years Left 6 Fund X Monthly Payment ($260) Interest Rate Ending Value 15 8% 7 8 (100.00) (200.00) (300.00) (400.00) 10 $ 11 $ 12 $
Please solve it ASPA
You are considering investing $1,000 in an investment fund at the end of every quarter for the next 6 years. The first investment will be made at the end of the coming quarter. The fund is expected to earn an interest rate of 10% p.a., with interest compounded quarterly. At the end of 6 years, the total dollar value in this investment fund will be closest to: Group of answer choices A.$6,388. B. $7,716. C. $32,349. D. $40,000.
Suppose you invest $5,000 into a mutual fund that is expected to earn a rate of return of 7%. The amount of money you will have in 10 years is closest to which of the following? The amount you will have in 25Lyears is closest to which of the following? O 1) $53,500; $802,500 O 2) $2,552.56; $3,257.79 O 3) $9,835.76; $27,137.16 O 4) $3,138; $ 1,311,892 5) None of the answers are correct
Please
You find a mutual fund that offers approximately 6% APR compounded monthly. You will invest enough each month so that you will have $1000 at the end of the year. How much money will you have invested in total after 1 year? O A. $711.32 B. $994.60 O C. $912.86 O D. $972.84
An Active manager of AMF Fund has delivered the following six -monthly returns in the last 5 Years versus the Benchmark NIFTY Calculate the Information Ratio & Interpret the same ? . Also calculate the annualized Information Ratio. ? Period (Semi Annual) Return of Fund % (Rp) NIFTY Return % (Rb) 1 4.5 5.5 2 3.25 3.75 3 7.25 6.5 4 2.45 2.15 5 -1.05 -1.25 6 -0.35 0.25 7 1.15 -2.5 8 5.45 5.75 9 3.9 4.2 10 4.8 -0.1
Suppose that you initially invested $10,000 in the Stivers mutual fund and $5,000 in theTrippi mutual fund. The value of each investment at the end of each subsequent year isprovided in the table:Year Stivers ($) Trippi ($)1 11,000 5,6002 12,000 6,3003 13,000 6,9004 14,000 7,6005 15,000 8,5006 16,000 9,2007 17,000 9,9008 18,000 10,600Which of the two mutual funds performed better over this time period?
What would be your future account value if you invested $175 each month into a growth mutual fund for 20 years? Assume an average annual rate of return of 13 percent. O $212,675.99 O $246,485.08 O $186,476.36 O $198,317.41
A. Joe is the fund manager. His fund begins with $10 million and has the following monthly returns: Month Net inflows ($ million) HPR (%) Compute the arithmetic average monthly return 1 3 2 4% per month 2% per month 3% per month 1% per month 2 5 8 3 0 (4)
Please answer with explanation. I will really upvote. Thanks
An investor wants to select one of the six mutual funds for the coming year. Data showing the percentage annual return for each fund during five typical one year periods are shown here (hence five outcomes): Outcomes Year A Year B Year C Year D Year E Mutual Fund 38.5 24.0 29.6 11.2 -12.1 Large Cap 34.6 25.9 -0.7 51.2 -23.7 Mid Cap 22.4 26.7 4.8 36.9 7.4 Small Cap 48.7 3.5 30.6 78.9 -34.5 Health Sector 26.5 41.9 -30.1 22.2 16.7 Tech Sector 47.8 38.2 2.2 -16.8 95.4 a) Assume the investor is conservative, what is the recommended fund? What are the maximum and minimum returns of your decision? b) Suppose we were given the probabilities of 0.1, 0.2, 0.2, 0.1, and 0.4. Using the expected value table what is the recommended mutual fund? What is the expected return? c) What is the EMV for the fund in part A? How much of an increase can be obtained by following the…