The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
University
| Teaching Since: | Apr 2017 |
| Last Sign in: | 438 Weeks Ago, 1 Day Ago |
| Questions Answered: | 9562 |
| Tutorials Posted: | 9559 |
bachelor in business administration
Polytechnic State University Sanluis
Jan-2006 - Nov-2010
CPA
Polytechnic State University
Jan-2012 - Nov-2016
Professor
Harvard Square Academy (HS2)
Mar-2012 - Present
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 you 9 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 (one year after the last gift)?
Suggestion: Do this problem 2 ways, as shown below: a) take each amount and calculate its future value in year 10 (as illustrated in cells C7:C16) and then sum them; b) use Excel’s FV function, 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 1).

-----------