Funa F G H Fund 2 Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type value Rate Factor Your mutual fund grows from $1200 to $1500 in 1 year. 25% b.) Year Amount 0 $ a.) What is the annual growth rate? Answer in cell C4 and format to 0 decimal places. What is the annual growth factor? Answer in format as a number to 2 decimal places. 1,200.00 1,500.00 1 $ b.) Create a table of values in cells D11-019 expressing the amour through year 10, assuming this constant growth rate, using the ide formula" from the chapter. Format as currency to 2 decimal places 000 c.) Graph this table from part b as a scatterplot in cells 014:V28 a exponential trendline with the equation displayed. Add axis labels title. The axis labels and graph title should be chosen from the list: a. Year b. Amount c. Mutual Fund Growth Decimal d.) What is that Decimal % b. Amount 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 places. Input Year: e) Output 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 parta. Format as currency to 2 decimal places. f.) The is changing by per f.) Interpret the annual growth rate from part a in cells D32, 34, and 036 by filling in the following sentence. __ is changing by i per Input Year: Output Amount: 8.) Given the input cell for years, create an output in cell 039 for the value of your mutual fund using the initial value and continuous growth rate from part Format as currency. Note: To raise e to a power, use the EXP function. h.) The is changing continuously by h.) Interpret the continuous growth rate in cells 144, 145, and Das by filling in the following sentence. The is changing continuously by per ber Instructions Questions Ready Funa F G H Fund 2 Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type value Rate Factor Your mutual fund grows from $1200 to $1500 in 1 year. 25% b.) Year Amount 0 $ a.) What is the annual growth rate? Answer in cell C4 and format to 0 decimal places. What is the annual growth factor? Answer in format as a number to 2 decimal places. 1,200.00 1,500.00 1 $ b.) Create a table of values in cells D11-019 expressing the amour through year 10, assuming this constant growth rate, using the ide formula" from the chapter. Format as currency to 2 decimal places 000 c.) Graph this table from part b as a scatterplot in cells 014:V28 a exponential trendline with the equation displayed. Add axis labels title. The axis labels and graph title should be chosen from the list: a. Year b. Amount c. Mutual Fund Growth Decimal d.) What is that Decimal % b. Amount 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 places. Input Year: e) Output 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 parta. Format as currency to 2 decimal places. f.) The is changing by per f.) Interpret the annual growth rate from part a in cells D32, 34, and 036 by filling in the following sentence. __ is changing by i per Input Year: Output Amount: 8.) Given the input cell for years, create an output in cell 039 for the value of your mutual fund using the initial value and continuous growth rate from part Format as currency. Note: To raise e to a power, use the EXP function. h.) The is changing continuously by h.) Interpret the continuous growth rate in cells 144, 145, and Das by filling in the following sentence. The is changing continuously by per ber Instructions Questions Ready