Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed better? Please show steps in Excel Year Stivers Trippi 1 11,000 5,600 2 12,000 6,300 3 13,000 6,900 4 14,000 7,600 5 15,000 8,500 6 16,000 9,200 7 17,000 9,900 8 18,000 10,600

Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed better? Please show steps in Excel Year Stivers Trippi 1 11,000 5,600 2 12,000 6,300 3 13,000 6,900 4 14,000 7,600 5 15,000 8,500 6 16,000 9,200 7 17,000 9,900 8 18,000 10,600

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

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?
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 -
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 2004 you invested $l0,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed better? Year Stivers Trippi 2004 11,000 5,600 2005 12,000 6,300 2006 13,000 6,900 2007 14,000 7,600 2008 15,000 8,500 2009 16,000 9,200 2010 17,000 9,900 2011 18,000 10,600
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 Mean annual return (to 3 decimals) Which mutual fund performed better? $15,000 $16,100 $17,000 $18,000 Compute the mean annual return for the Stivers mutual fund and for the Trippi mutual fund. Do not round intermediate calculations. Stivers Trippi The Trippi mutual fund V ✔ 7.847 % 9.977 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 % $10,500 $11,900 $12,900 $13,900 Hint(s) $5,700 $6,300 $7,000 $7,600 $8,600 $9,200 $9,900 $10,600 Check
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. Mean annual return (to 3 decimals) % Year Year 1 $10,700 Year 2 $11,900 Year 3 $12,900 Year 4 $13,900 Year 5 $15,000 Year 6 $16,000 Year 7 $17,100 Year 8 $18,100 Compute the mean annual return for the Stivers mutual fund and for the Trippi mutual fund. Do not round intermediate calculations. Stivers Trippi % Stivers Trippi $5,600 $6,400 $7,000 $7,600 $8,600 $9,300 $9,900 $10,700
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. Mean annual return (to 3 decimals) 7.847 Which mutual fund performed better? The Trippi mutual fund % 9.977 Year Year 1 Year 2 Year 3 $12,900 Year 4 $13,900 Year 5 $15,000 Year 6 $16,100 Year 7 $17,000 Year 8 $18,000 Compute the mean annual return for the Stivers mutual fund and for the Trippi mutual fund. Do not round intermediate calculations. Stivers Trippi % Stivers $10,500 $11,900 Trippi $5,700 $6,300 $7,000 $7,600 $8,600 $9,200 $9,900 $10,600
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 %
Analyze the following three years of data relating to the MoMoney Mutual Fund, . It should report the amount of dividend income and capital gains distributed to the shareholders, along with any other changes in the fund's net asset value (b = 0.5). (Click the icon here ☐ in order to copy the contents of the data table below into a spreadsheet.) 2019 2018 NAV (beginning of period) ? ? 2017 $35.56 Net investment income 0.64 0.74 0.56 Net gains on securities 5.48 4.52 - 3.41 Dividends from net investment income 0.64 0.56 Distributions from realized gains 1.61 1.96 0.51 1.44 a. What is the total income from the investment operations? b. What are the total distributions from the investment operations? a. The total income from investment operations in 2019 is $ The total income from investment operations in 2018 is $ (Round to the nearest cent.) (Round to the nearest cent.) (Round to the nearest cent.) The total income from investment operations in 2017 is $ b. The total distributions from…
For the same two funds discussed in Q2 the ending wealth after five years was $1.2438 per dollar invested at the beginning for the Equity Income Fund, and $1.0492 per dollar invested at the beginning for Personal Strategy Fund. What were the annual average total returns for each fund for this five-year period?
An investor purchases a mutual fund share for $100.2. The fund pays dividends of $2.2, distributes a capital gain of $1.1, and charges a fee of $3 when the fund is sold one year later for $95.3. What is the net rate of return from this investment? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16))
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