Your parents have just opened a savings account for you. They plan to make monthly deposits of $1,000 for the next 10 years (120 deposits) where the first deposit starts today. Assume that the account earns 5% annual interest. What will be the value of your saving account after 10 years?

a. Answer this part using both a table method and Execl formula method. Make sure you build a model that looks good in addition to being correct. The graph must be labeled and titled properly.

b. Calculate the value of the saving acount if the monthly deposit ranges from $500 to $1,500 with $100 increments (Use the Data Table!)

c. Draw a graph that plots the value of saving with respect to monthly deposits.

d. Repeat parts a, b, and c if the first deposit of $1,000 starts today and the deposits grow by 0.4% every month. For this part, no need to do a single formula solution. A table method is enough.