Interest calculation

M

missdivine828

How do I calculate the interest on a princiapl balance from a date in the
past to today's date?
 
J

joeu2004

missdivine828 said:
How do I calculate the interest on a princiapl balance from a
date in the past to today's date?
Click to expand...

Compounded daily, I assume. If the principal is in A1, the deposit
date is in A2, and the annual interest rate is in A3, the current
balance is:

=fv(A3/365, today() - A1, 0, -A2)

The total accrued interest is simply that value less the principal,
namely:

=fv(A3/365, today() - A1, 0, -A2) - A2
 
I

Iskus23

Have you subtracted the day in the past from today's date and used that
figure for your calculation? Don't forget that you may need to change your
cell formate to make this work.
 
Top