Thread: Mortgage calculation after a large extra payment
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,misc.invest.financial-plan
Dave Dodson
 
Posts: n/a
Default Mortgage calculation after a large extra payment
=-PMT(0.05625/12,360,260000)-0.05625/12*(260000*(1-(1-(1+0.05625/12)^17)/(1-(1+0.05625/12)^360))-25000)

Dave

Reply With QuoteReply With Quote