| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PMT function question
I have a question regarding the PMT funtion. Example: loan amount = 10000,
Annual % rate is 7.5%, term is 5 years, payments per year is 12. The regular function would be: PMT(%/12, 5*12,-10000) How do you set this up using daily interest instead of monthly interest with a monthly payment. Or, is the PMT function the correct function to use?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Function Question | Excel Worksheet Functions | |||
| IF function question | Excel Worksheet Functions | |||
| FUNCTION QUESTION | Excel Discussion (Misc queries) | |||
| IF function Question | Excel Worksheet Functions | |||
| Function question | Excel Discussion (Misc queries) | |||
Threaded Mode
