variable interest rate calculation
[Excel 2003]
I want to calculate compound, variable interest on an account consisting of
multiple deposits of irregular amounts and and irregular deposit dates.
It would be best if it could calculate on actual calendar dates, not just
30-day months/360 days. Also, it would be best if interest could be
compounded daily, rather than any larger period.
Does anyone happen to know a way to program this or a site that I might
purchase it from?
Thanks.
|