Over a four-year period, Matt Ewing purchased shares in the ClearBridge Large-Cap Value Fund. Use the following information: Year Investment Amount Price per Share 2018 $ 3,250 $ 32 per share 2019 3,250 2020 40 per share 37 per share 2021 3,250 3,250 39 per share a. At the end of four years, what is the total amount invested? b. At the end of four years, what is the total number of mutual fund shares purchased? Note: Round your intermediate calculations and answer to 1 decimal place. c. At the end of four years, what is the average cost for each mutual fund share? Note: Round your intermediate calculations 4 decimal places and answer to 2 decimal places. a. Total amount invested b. Total number of mutual fund shares c. Average cost of each mutual fund share $ 13,000

Over a four-year period, Matt Ewing purchased shares in the ClearBridge Large-Cap Value Fund. Use the following information: Year Investment Amount Price per Share 2018 $ 3,250 $ 32 per share 2019 3,250 2020 40 per share 37 per share 2021 3,250 3,250 39 per share a. At the end of four years, what is the total amount invested? b. At the end of four years, what is the total number of mutual fund shares purchased? Note: Round your intermediate calculations and answer to 1 decimal place. c. At the end of four years, what is the average cost for each mutual fund share? Note: Round your intermediate calculations 4 decimal places and answer to 2 decimal places. a. Total amount invested b. Total number of mutual fund shares c. Average cost of each mutual fund share $ 13,000

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

Chapter3: Data Visualization

Section: Chapter Questions

Problem 6P: The file MutualFunds contains a data set with information for 45 mutual funds that are part of the...

See similar textbooks

Similar questions

The file MutualFunds contains a data set with information for 45 mutual funds that are part of the Morningstar Funds 500. The data set includes the following five variables: Fund Type: The type of fund, labeled DE (Domestic Equity), IE (International Equity), and FI (Fixed Income) Net Asset Value (): The closing price per share Five-Year Average Return (%): The average annual return for the fund over the past five years Expense Ratio (%): The percentage of assets deducted each fiscal year for fund expenses Morningstar Rank: The risk adjusted star rating for each fund; Morningstar ranks go from a low of 1 Star to a high of 5 Stars. a. Prepare a PivotTable that gives the frequency count of the data by Fund Type (rows) and the five-year average annual return (columns). Use classes of 09.99, 1019.99, 2029.99, 3039.99, 4049.99, and 5059.99 for the Five-Year Average Return (%). b. What conclusions can you draw about the fund type and the average return over the past five years?
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
K Compute the total and annual returns on the following investment. Six years after purchasing shares in a mutual fund for $7800, the shares are sold for $11,400. The the total return is %. (Do not round until the final answer. Then round to one decimal place as needed.) The annual return is %. (Do not round until the final answer. Then round to one decimal place as needed.)
K Compute the total and annual returns on the following investment. Sixteen years after purchasing shares in a mutual fund for $6000, the shares are sold for $11,100. The the total return is%. (Do not round until the final answer. Then round to one decimal place as needed.)
over a four-year period, matt purchased shares in the barreau du quebec canadian equity fund. using the following information, answer the following questions. year investment amount price per share 2004 $3,000 $40 per share 2005 $3,000 $50 per share 2006 $3,000 $60 per share 2007 $3,000 $45 per share a at the end of four years, what is the total amount invested? what is the total number of mutual fund shares, and the aqverage cost of each mutual fund shares?
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?
Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5,000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Year Stivers Trippi Year 1 $11,000 $5,600 Year 2 $12,000 $6,400 Year 3 $12,700 $7,000 Year 4 $13,800 $7,600 Year 5 $15,000 $8,600 Year 6 $16,000 $9,300 Year 7 $17,200 $9,900 Year 8 $18,500 $10,700 Compute the mean annual return for the Stivers mutual fund and for the Trippi mutual fund. Do not round intermediate calculations. Stivers Trippi Mean annual return (to 3 decimals) Which mutual fund performed better? Select your answer -
Over a four-year period, LaKeisha Thompson purchased shares in the Oakmark Investor Class Fund. Using dollar cost averaging, calculate the number of shares before completing this problem. (Round your answers to the nearest whole number.) Year Investment Amount Price per Share Number of SharesFebruary 2017 $1,400 $53.00 February 2018 $1,400 $ 34.00 February 2019 $1,400 $47.40 February 2020 $1,400 $55.00 a. At the end of four years, what is the total amount invested? b. At the end of four years, what is the total number of shares purchased? (Round your intermediate calculations and final answer to the nearest whole number.) c. At the end of four years, what is the average cost for each share? (Round
Compute the total and annual returns on the following investment. Nine years after purchasing shares in a mutual fund for $7000 , the shares are sold for $11,400 .
Corporate Fund started the year with a net asset value of $12.50. By year-end, its NAV equaled $12.10. The fund paid year-end distributions of income and capital gains of $1.50. Required: What was the rate of return to an investor in the fund? (Round your answer to 2 decimal places.) Rate of return %
An investor buys shares in a mutual fund for $20. At the end of the year the fund distributes a dividend of $0.53, and after the distribution the net asset value of a share is $24.16. What is the investor's percentage return on the investment? Round your answer to two decimal places. %
Assume that one year ago you bought 100 shares of a mutual fund for $33.75 per share, you received a $0.47 per-share capital gain distribution during the past 12 months, and the market value of the fund is now $41.55. Calculate the percentage of total return for your $3,375 investment. Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Percent of total return %