| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek on PMT function give different answer than a mortgage ca
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Goal Seek | Excel Worksheet Functions | |||
| Sum Function sometimes displays incorrect answer | Excel Worksheet Functions | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
| Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions | |||
Threaded Mode
