Thread: [Solved] PMT Formula
View Single Post
 
Old 03-04-2011, 02:41 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi,

I assume you should be using an interest rate of 8% per annum not 8 (which would be 800%)?
Code:
=PMT(8%,10,1000,0,1)
8% per annum interest rate, 10 payments, start amount 1000, final amount 0, paying at the start of each period.

Result, each payment is = -£137.99
Last edited by Colin Legg; 03-04-2011 at 06:05 AM.
Reply With Quote