Question: Use an Excel Sheet to answer the question 2:16 the actual percentage increase? Prove your answer 4) Mr. Wildman has given you $1000 for being


Use an Excel Sheet to answer the question
2:16 the actual percentage increase? Prove your answer 4) Mr. Wildman has given you $1000 for being his favorite student. You decide to invest it in an account that earns 6% interest every year a) Create a two column table in Excel - the first column for years and the second for amount of money in the account. Start the year column with year 0. Start the amount of money in account column with the $1000. Use formulas for each column. Drag the columns out enough to answer the following questions How money will be in the account after 10 years? After 20 years? After 25 years? How long will it take for the amount of money in the account to double b) Now suppose you start with $2000 instead of $1000 with the same interest rate per year. Create a two column table in Excel (use another sheet) - the first column for years and the second for the amount of money in the 2:17 04. ULTTUUTTUI Fury account. Use formulas for each column. How long will it take for the amount of money to double? What does this say about the initial value of money in the account and time it takes to double? c) Now suppose you have $2000 but invest at 12% per year instead of 6% per year Create a two column table in Excel (use a third sheet) - the first column for years and the second for amount of money in the account. Use formulas for each column. Drag the columns out enough to answer the following questions i) How money will be in the account after 10 years? After 20 years? After 25 years? j) How long will it take for the amount of money in the account to double
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
