# Interest calculation

#### N Prakash

##### Active Member
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

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### N Prakash

##### Active Member
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

##### Active Member
Re: Interest calculation silly question.

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

Replies
4
Views
819
Replies
1
Views
343
Replies
12
Views
555
Replies
3
Views
301
Replies
6
Views
2K

1,191,420
Messages
5,986,464
Members
440,031
Latest member
davidvillegasr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back