HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES

  • Thread starter Thread starter manas123
  • Start date Start date
M

manas123

Help me please,

I want to calculate interest accured between two dates
data i have
start date (1st jan 2005)
End date or maturity date (1st jan 2007)
amount invested( $1000)
interest rate 10% per annum
Componuded semiannualy
how can we calculate witouht any fractional error if we follow 30/360 day
counting covention .
 
First, calculate future value, as in:
=fv(10%/2,(2007-2005)*2,0,-1000)
=1215.15

Therefore, interest is $215.15

Regards,
Fred.
 
manas123 said:
I want to calculate interest accured between two dates
data i have
start date (1st jan 2005)
End date or maturity date (1st jan 2007)
amount invested( $1000)
interest rate 10% per annum
Componuded semiannualy
Click to expand...

If your data is in A1:A4 (A1 = start date; A4 = annual interest rate):

=FV(A4/2, DATEDIF(A1,A2,"m")/2, 0, -A3) - A3

That formula assumes that start and end dates are the same day of the month.
Caveat emptor when the day of the month is 31, or the start or end date is
Feb and the day of the month is 29 or larger.

how can we calculate witouht any fractional error if we follow
30/360 day counting covention.
Click to expand...

That sounds suspiciously like the example in the ACCINTR help page.

Are you asking for help using ACCINTR? If so, what specifically don't you
understand?

Note: With bonds, the first semi-annual interest payment is not always 6
months after the "start date" (i.e. when you purchased the bond). So
technically, you need one more piece of data.


----- original message -----
 
Errata....
=FV(A4/2, DATEDIF(A1,A2,"m")/2, 0, -A3) - A3
Click to expand...

That should be:

=FV(A4/2, DATEDIF(A1,A2,"m")/6, 0, -A3) - A3


And said:
That sounds suspiciously like the example in the ACCINTR help page.
Click to expand...

Misdirection!


----- original message -----
 
Back
Top