2. Your generous grandmother has just announced that she's opened a savings account for you with a deposit of $10,000. Moreover, she intends to make nine more similar gifts, at the end of this year, next year, etc. If the savings account pays 8% interest, how much will you have accumulated at the end of 10 years (1 year after the last gift)? Suggestion: Do this problem two ways, as shown below: (a) take each amount and calculate its future value in year 10 (as illustrated in cells C4C13) and then sum them; (b) use Excel's FV func. tion, noting that here the amounts come at the beginning of the year (you'll need to enter "1" in the Type option as described in Section 2.1). 8.00% Future value In year 10 21.580 25 341.$B$ 1 10-M) Gift 10.000 10 000 10,000 10,000 10,000 10.000 10,000 10,000 10.000 10.000 15 Total (summing C4 C13) Save and Click Save and submit to save and submit Chick Save All Answers to save all anners fun_4300.zip D 013350672 ppt 2 causes of delicits.doc HW - docx Syllabus internatio...doc De 9 e here to search w 1.wpunj.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_7320218.course_id=_122345_1&content_id=2152096_1&ste Question Completion Status: deposit of STU0W. Moreover, the intends to make hinc more similar girts, at the end of this year, next year, etc. If the savings account pays 8% interest, how much will you have accumulated at the end of 10 years (1 year after the last gift)? Suggestion: Do this problem two ways, as shown below: (a) take each amount and calculate its future value in year 10 (as illustrated in cells C4:C13) and then sum them; (b) use Excel's FV func- tion, noting that here the amounts come at the beginning of the year (you'll need to enter "l"in the Type option as described in Section 2.1). A B D 1 Interest rate 8.00% Year Future value Giftin year 10 10.000 21,589.25