Financial Math on Spreadsheet and Calculator Version 4

Excel uses Nper. Example: for a five year car loan with monthly payments, Nper = 60 P/YR Periods per Year (we will assume that time is “sliced” into equal length periods) Example: for a five year car loan with monthly payments, P/YR = 12 PMT Amount of periodic payment Example: for a $279.89 monthly car loan payment, PMT = 279.89 ................
................