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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!