Interest calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I calculate the interest on a princiapl balance from a date in the
past to today's date?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amortization w/ variable interest rate 1
can i run a principal component analysis 1
Interest calculation 14
First row where a cell is zero 1
Calculate Interest Rate 2
CREATING FORMULA FOR CALCULATING ENDING BALANCE WITH PMT AND INTRE 1
Percent constant 1
Lookup table for rates? 4

Back
Top