| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What am I doing wrong with PMT function?
If you try =PMT(L57/12,M57*12,-K57) then you will get a pmt of $11,130.69. You were multiplying the # of years by 12 and you were
dividing the interest rate by that number, giving you a bad interest rate. Everything else looks fine, but it doesn't agree with the # you got manually of $14,480.11. I think the 11K answer is correct for the terms you gave. Try testing it again. -- RMC,CPA "Marc" wrote in message .net... I have searched the net and formated the function like all the examples but the payment is way out of line. In cell L57 I have the annual interest rate, in M57 the numbers of years for the loan and K57 is the principal. =PMT(L57/M57*12,M57*12,-K57) The principal is $714,136.63 the rate is 8% and the terms is 7 years but it returns a paymetns of $9,793,873.81. This is what it should be from the online calculators I've used $14,480.11. What am I doing wrong? Marc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup function bringing in wrong info | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
