If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES
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 . |
#2
|
|||
|
|||
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES
First, calculate future value, as in:
=fv(10%/2,(2007-2005)*2,0,-1000) =1215.15 Therefore, interest is $215.15 Regards, Fred. "manas123" wrote in message ... 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 . |
#3
|
|||
|
|||
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES
"manas123" wrote:
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 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. 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 ----- "manas123" wrote in message ... 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 . |
#4
|
|||
|
|||
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES
Errata....
I wrote: =FV(A4/2, DATEDIF(A1,A2,"m")/2, 0, -A3) - A3 That should be: =FV(A4/2, DATEDIF(A1,A2,"m")/6, 0, -A3) - A3 And I wrote: That sounds suspiciously like the example in the ACCINTR help page. Misdirection! ----- original message ----- "Joe User" joeu2004 wrote in message ... "manas123" wrote: 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 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. 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 ----- "manas123" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|