How to calculate interest for current month only
 

i have to calculate interest for the remaining balance for current month
only, not sure what formulla will work

How to calculate interest for current month only
 

check this
http://office.microsoft.com/en-us/ex...091451033.aspx


On Nov 6, 10:46*pm, ksadiq wrote:
i have to calculate interest for the remaining balance for current month
only, not sure what formulla will work

How to calculate interest for current month only
 

I calculate the interest portion of my monthly mortgage payment as
(current balance) * (annual interest rate) / 12.

"ksadiq" wrote:

i have to calculate interest for the remaining balance for current month
only, not sure what formulla will work