I am now having to reproduce the EXCEL PMT function
in RPG. Maybe someone has already done this?
Anyway, I've been given a formula to code and an
EXCEL spreadsheet to control my results.
Which I've coded like this :
MonthlyRate = interestRate /12;
MonthlyPayment = ( LoanAmount / MonthlyRate ) * ( 1 - ( 1 +
MonthlyRate ) ** ( -1 * numberOfPayments ));