How do you calculate loan repayment in Excel?
How do you calculate loan repayment in Excel? Here’s how:In Excel, create the labels needed for the structure of the worksheet. … Type =NPER( into the cell where the function should be placed. … Click or type the cell that contains the interest rate, and then type a comma. … Click or type the cell that contains the payment amount, and then type a comma.