a.)what is the growth factor how to solve for it? b.) what is the Fund through year 10. d.)what is the continuous growth rate? e.)what is the output value of the mutual fund. using initial value and annual growth factor. f.) what is the annual growth rate. g.) what is the output value of the mutual fund. h.)whats the continuous growth rate?

00 I J M o U Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless directed otherwise, as you will not rece Rate Factor 25% Your mutual fund grows from $1200 to $1500 in 1 year. b.) Year Amount 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 1,200.00 D4 and format as a number to 2 decimal places. ,500.00 b.) Create a table of values in cells D11-D19 expressing the amount in your fund through year 10, assurning 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 b. Ampunt Decimal c. Mutual Fund Growth d.) What is the continuous growth rate? Type your response in cell C22 as a decimal to 4 places, and your response in cell D22 as a percentage to 2 decimal Input Year: places. e.) :put Amount: e.) Given the input cell for years, create an output in cell D27 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.) The is changing by 1.) Interpret the annual growth rate from part a in cells D32, D34, and D36 by per filling in the following sentence. The i is changing by_ per_ill Input Year: Output Amount: g.) Given the input cell for years, create an output in cell D39 for the value of your mutual fund using the initial value and continuous growth rate from part d. Format as currency. Note: To raise e to a power, use the EXP function. h.] The s changing continuously by h.) Interpret the continuous growth rate in cells D44, D46, and D48 by filling in the following sentence