Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PMT function
I can't ever seem to get the payment function to calculate properly. I am
entering an $80,000 loan with and interest rate of 8% payable over 5 years. This is the formula I am entering =PMT(0.6667,60,80000). The result I am getting is ($53,336.00). The answer should be a montly payment of $1,622. My eyes are crossed - what am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PMT function
You should use
=PMT(0.006667,60,80000) the first parameter is rate/period so in this case it should be 0.08/12 or 8%/12 "Brent" wrote: I can't ever seem to get the payment function to calculate properly. I am entering an $80,000 loan with and interest rate of 8% payable over 5 years. This is the formula I am entering =PMT(0.6667,60,80000). The result I am getting is ($53,336.00). The answer should be a montly payment of $1,622. My eyes are crossed - what am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PMT function
On Feb 10, 8:58*pm, Brent wrote:
I can't ever seem to get the payment function to calculate properly. I am entering an $80,000 loan with and interest rate of 8% payable over 5 years. This is the formula I am entering =PMT(0.6667,60,80000). The result I am getting is ($53,336.00). The answer should be a montly payment of $1,622. My eyes are crossed - what am I doing wrong? Two things. First, let Excel do the math for you. Instead of 0.6667, which is wrong, or even 0.006667, use 8%/12. Second, if you want a positive result, there are two ways. =-pmt(8%/12,60,80000) =pmt(8%/12,60,-80000) Finally, if your monthly payment is truly rounded to an even dollar amount, you should do that explicitly: =round(pmt(8%/12,60,-80000),0) If you simply format the cell with zero decimal places, that will not affect the actual value on the cell, approximately $1,622.11. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |