View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bmac bmac is offline
external usenet poster
 
Posts: 30
Default amortization schedule / Mortgage payments

I would like Excel to calculate the remaing balance based on the current
month. For example if I am making my 26th payment on my $200,000 mortgage,
and assuming i have made every payment on time and minimum payment only, what
is my balance as of this month.