Continious standard interest calculation

[N Prakash]

Hi,

I have one sill qusetion, but I am not getting the desired answer. Can any body help me in giving the formulae to get the expected results.

I have a period from 07/14/2011 to 07/13/2013 (730 days) to claucalte interest on continious compounding using standard method (360 days in a year). As per my calculation in excel I am getting 36.66

(A4=250, B4=7%, A3=730 days)

=ROUND(($A$4*(1+$B$4)^($A$3/360)-$A$4),2)


My expected value as per my other application calculation is 36.45


Can any body help me in arriving this expected result, can I get a formulae for the same,

Regards,
Prakash

 

[AlphaFrog]

I admittedly have little knowledge of financial calculations.

I calculate a value of 38.12 using this formula...
=ROUND(($A$4*(1+$B$4/360)^($A$3)-$A$4),2)

Or this...
=FV(B4/360,A3,0,-A4)-A4

Results confirmed by this daily interest rate calculator

 

[Fazza]

Continuous interest info, http://www.bondtutor.com/btchp1/topic4/topic4.htm

=A4*EXP(B4*A3/360)-A4

Returns 38.13 for me.

Answer is 36.45 when I change the period to 700 days...