Answer Happy

Your mutual fund grows from $1200 to $1500 in 1 year. a.) What is the annual growth rate? Answer in cell C4 and format as a percentage to 0 decimal places. What is the annual growth factor? Answer in cell D4 and format as a number to 2 decimal places. b.) Create a table of values in cells D11-D19 expressing the amount in your fund through year 10 , assuming this constant growth rate, using the idea of a "recursive formula" from the chapter. Format as currency to 2 decimal places. c.) Graph this table from part b as a scatterplot in cells 014:V28 and insert an exponential trendline with the equation displayed. Add axis labels and a graph title. The axis labels and graph title should be chosen from the list: a. Year e.) Given the input cell for years, create an output in cell D25 for the value of your mutual fund using the initial value and annual growth factor from part a. Format as currency to 2 decimal places. f.) Interpret the annual growth rate from part a in cells D32, D34, and D36 by filling in the following sentence. The__ is changing by. per_____ (i) Choose your answer from the drop down menu. (Click the cell and choose.) (ii) Make a reference to one of the cells above. (iii) Choose your answer from the drop down menu. (Click the cell and choose.)