| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of payments remaining
I need a formula to calculate the number of payments remaining on a loan
based on constant interest, constant payments and a known balance. I am trying to use the NPER function but it doesn't give the right answer if I change the interest rate. How many payments do I have left on $16,000, with 5% interest, and $250 a month payment? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
| Deduct until last positive number remaining | Excel Discussion (Misc queries) | |||
| Getting remaining entries | Excel Discussion (Misc queries) | |||
| How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
| Points remaining formula | Excel Worksheet Functions | |||
Threaded Mode
