Dec 06 2021 01:35 PM
I get a #NUM! error when using the formula: NPER(E17/12,M17,D17,0).
E17=14.15% M17=-123.15 D7=16,643.43
When these values are used for calculating in a Amortization Table (a different spreadsheet in the same Excel workbook of the above formula) or a TVM Calculator, the results equals 110.8 periods.
Please help me understand what is the reason for this outcome.
Thanx,
daccs221
Dec 06 2021 02:15 PM
The payment is far too small for this interest rate.
The monthly interest part alone is E17/12*D17 = 196.25. So the payment cannot be less than that.
Dec 06 2021 07:20 PM
Dec 07 2021 03:31 AM
Please check again - there is no way this could work.
Could you attach a sample workbook that shows otherwise?
Dec 13 2021 02:27 PM
Dec 13 2021 02:32 PM