View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default 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