Interest calculation

[N Prakash]

Hello,

I am getting following out put when I use amount 1000 ROI 10% number of days 364 using method 31/365,6 =99.69(Actual/Actual) in one of the systems, but in Excel calculation I am getting 99.73. How to get the same value of 99.69 using method Actual/Actual (31/365,6)

Regards,
Prakash

 

[N Prakash]

Re: Interest calculation a silly question

I think my question was not clear and may a silly question. I am reformating the same now

When I do the first calculation I get correct amount in Excel. But the second one I am not able to get the expected value of 99.96. Can any body help me how to get the value in excel calculation


1000****** 10%******* 365******** 100*** **Actual/365 method
1000****** 10%******* 365******** 99.96* Actual/365,6 method

 

[N Prakash]

Re: Interest calculation silly question.

Thank you Guys, I was bit confused, I got the result.