Between the commasbin the formula in cell j5, enter another formula using the PV function. Use defined cell names for the rate,nper, and pmt, arguments as follows: rate divide the rate by 12 to use the monthly interest rate subtract the byear value in h5 from the term and then multiply the results by 12 to specify the number of months remaining to pay off the loan
