On Aug 9, 10:38*am, "Fred Smith" wrote:
It's a simply future value calculation. The only complication would be the
compounding period, which I doubt is monthly -- it's more likely annual. If
so, use:
=fv(IntRate,(today()-PurchaseDate)/365,0,-InvestAmount)

Regards,
Fred

Interest is compounded monthly...I double checked.