Showing all work in excel: Calculating Annuity Values. If you deposit $5,000 at the end of each of the next 20 years into an account paying 10.8 percent interest, how much money will you have in the account in 20 years? How much will you have if you make deposits for 40 years?