Calculation of Compounded Interest on a debt
Thank you very much !!
"Gary''s Student" wrote:
With the start date in A1 and the end date in A2 and the amount in A3 and the
APR in A4. In another cell (say Z100):
=((1+A4/365)^(A2-A1)-1)*A3
is the total due, so the total interest is:
Z100-A3
--
Gary''s Student - gsnu200785
"David Brereton" wrote:
HELP please. I have looked through all possible formulae but cannot find one
to suit.
I am trying to find an easy / short way to calculate interest on a debt ,
but compounded on a daily basis.
The info I will have will be :-
1. Amount of debt
2. Start date of debt
3. Date to which interest is to be calculated to
4. Interest rate ( fixed )
How can I create a formulae to calculate this in one swoop ?
|