Thread: Goal Seek on PMT function give different answer than a mortgage ca
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Goal Seek on PMT function give different answer than a mortgage ca
Show us the formulas and values you used.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"headly" wrote in message
...
Calculating mortgage payments in Excel using the PMT function, is this
wrong?
When I use the calculator on any mortgage broker site I get a different
answer to a simple question: What amount could I borrow to result in a
$1,000
monthly payment. Excel's goal seek give $190K and others say $160K, why
such
a big discrepency? TIA


Reply With QuoteReply With Quote