Couldn't able to calculate interest on capital

A's Interest = Rs. 1123.97 Or Say Rs. 1124

B's Interest = Rs. 786.57 Or Say Rs. 787

Originally posted by : Kunal Pansari

A's Interest = Rs. 1123.97 Or Say Rs. 1124

B's Interest = Rs. 786.57 Or Say Rs. 787

 

Please show me the calculation how you solved it?

Dear

You can calculate in Excel by usuig a Table as follows:

   A         B         C       D    E     F       G

 E = 31sr March year end

F = E (-) A

G =  C  * D *F/365

excel will do the work if we give proper combination