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?
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,100 $ 29 per share 2019 3,100 37 per share 2020 3,100 34 per share 2021 3,100 36 per share At the end of four years, what is the total amount invested? At the end of four years, what is the total number of mutual fund shares purchased? At the end of four years, what is the average cost for each mutual fund share?
Over a four-year period, Pat purchased shares in the Barreau du Quebec Canadian Equity Fund as recorded in the table below. Using the information below, provide your solution to the following questions. Year 2018 2019 2020 2021 Investment Amount $8, 100 $8, 100 $8,100 $8, 100 Price per Share $58 per share $43 per share $34 per share $50 per share a. At the end of four years, what is the total amount invested? (Omit the "$" sign in your response.) Total amount invested b. At the end of four years, what is the total number of mutual fund shares purchased? (Round DOWN your intermediate calculations and final answer to the nearest whole share.) Total number of mutual fund shares C. At the end of four years, what is the average cost for each mutual fund share? (Round DOWN your intermediate calculations to the nearest whole share. Round your final answer to 2 decimal places. Omit the "$" sign in your response.) Average cost of each mutual fund share
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. 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.)
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.)
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?
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
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 -
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 .
Compute the total and annual returns on the following investment. Seventeen years after purchasing shares in a mutual fund for $5600, the shares are sold for $11,300. %. 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.)
You purchased 1,000 shares of the New Fund at a price of $32 per share at the beginning of the year. You paid a front- end load of 2%. The securities in which the fund invests increase in value by 11% during the year. The fund's expense ratio is 1%. What is your rate of return on the fund if you sell your shares at the end of the year? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Rate of return This is a numeric cell, so % X