monthly (end of month) payment (PMT) $680.66
Monthly interest rate (RATE) 1.15%
Months to pay off loan (NPER) 48
amount of loan from bank (PV) $25,000.00
The borrower wants to repay the loan in 158 months. using excel what will be the new monthly repayment?
Here is a detailed explanation... View the full answer