Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need a function to calculate a mortgage payment
Does anyone have a function to calculate a amortized mtg payment. I tried to
use the pmt function, and it came out all wrong. Have tried many different iterations of the numbers, and they still do not come out to be same as my Loan Officer Point software indicates the answer should be. I need to put this function calulation in an excel spreadsheet. Thanks |
#2
|
|||
|
|||
need a function to calculate a mortgage payment
Thing to keep in mind with functions like PMT. Cash outflows have a negative sign ;cash inflows have a positive sign. As such, the result of a typical PMT formula will give you a negative number...and that is okay. So, if you have a mortgage payment on a 30 year $100,000 loan at 5% interest, you could calculate the payment as follows: =PMT(0.05/12,30*12,100000) NOTE - The 12's are to make everything calculated monthly instead of yearly. The answer is $536.82 per month. If that still seems off, then it could be because the Loan programs wants the payment due at the beginning of the month instead of the end of the month. If that is the case, try the formula like this: =PMT(0.05/12,30*12,100000,0,1)...the 1 at the end tells Excel the payment will be made at the beginning of the month instead of the end (and as such, slightly less interest). Hope that helps! -- Lotus123 ------------------------------------------------------------------------ Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611 View this thread: http://www.excelforum.com/showthread...hreadid=482696 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Can you change the PMT function tio calculate off of 365 days? | Excel Worksheet Functions | |||
How to calculate PMT function | Excel Worksheet Functions |