How do I calculate present value of irregular deposits/withdrawals with interest in excel?

I'm trying to teach my kids to save so I'm giving them the chance to deposit money into a "bank account" that pays interest (that I run). I'd like to create a spreadsheet to track the current value of their accounts. This seems like it would be easy but I'm having trouble figuring it out in excel.

Given a worksheet of deposits and withdrawals on various dates - how do I calculate the current value of the accounts assuming a constant interest rate (interest rate never changes)?

• 1/1/2016 +$10
• 1/4/2016 +$4
• 1/10/2016 -$5
• 1/10/2016 +$2
• etc

Current Value with X% interest rate = ???

Thanks in advance!

Recent Questions...