Interest balance on an account...

M

Marcus Fox

Say I have a loan of $10,000 at 7.9% AER. Interest is charged daily and
compounded, which I can find out by using =(NOMINAL(7.9%,365)/365) which
gives me 0.02083% for the daily interest rate.

How can I write a formula that will automatically display the account
balance (principal plus interest) on any given day in the past or future, or
the present date of the system?

Marcus
 

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

Top