Write an Excel worksheet that allows the user the ability to input the following information:

• Retirement Value
• Years of Retirement
• Yearly Interest Rate
  

Your worksheet is to then calculate how much montly income the user can expect to receive so that at the end of the Years of Retirement they put in, their Retirement Value will be zero . Test your worksheet with a retirement value of $500,000, years retired of 20, and a yearly interest rate of 4.5%. You will be taking money out at the end of each month.

Problem 2 (Easy)

Modify the worksheet from Problem 1 to include an Amortization table that shows the value of your retirement account at the end of each month. This amortization schedule must zero out at the end of time based on the years of retirement entered by the user.

Problem 3 (Medium)

Rework Problem1 and 2 but have the amount taken out at the beginning of each month.

Problem 4 (Hard)

Write an Excel worksheet that allows the user the ability to enter the following information:

• Credit Card Balance
• Minimum Payment
• Yearly Interest Rate
  

Your worksheet is to compute the number of periods needed to payoff the credit card AND calculate the total amount of interest paid without using any kind of amortization schedule.

Problem 5 (Medium)

A certain type of bacteria increases based on the following model: B(t) = 100e^0.2197t where t is the time in hours. Develop an Excel worksheet that allows the user the ability to find:

• the amount of bacteria at a given time t
  

Using Goal Seek, at what time can we expect there to be 1,000,000 bacteria. Give your answer to two decimal places.

Problem 6 (Easy)

The first few fibonacci numbers are: 1,1,2,3,5,8,... where the first two numbers are always 1,1 and each subsequent number is found by adding the previous two. In one column, I would like you to find the first 12 fibonacci numbers. In another column, I would like you to find the first 12 solutions to the equation: y=x^2 over the interval 1<=x<=12 where x is an integer. Once you have these two columns laid out, show the graph of each set of numbers with all axes properly labeled and a chart title.

Challenge (Hard): You can only use two columns of data to solve Problem 1.

Problem 7 (Hard)

The harmonic mean of a set of numbers is the number of scores N, divided by the reciprocals of each number. As an example, the harmonic mean of 7,8,7,3,6,2 is:

6 / (1/7 + 1/8 + 1/7 + 1/3 + 1/6 + 1/2) = 4.3

Design an Excel worksheet that allows the user the ability to enter up to 10 numbers and prints the harmonic mean of the numbers entered. Note: The user can enter from 1 and 10 different numbers inclusively.

Here is an example:

Harmonic Mean =  4.253165        

Make your worksheet look like the following:

Remember, go through your notes and review all problems we did and didn't do in class.