Hello,
I know this is not directly related to Monday, but I am looking for the complete PMT formula that I need to use for my application development. I do have the PMT function from Excel as a reference, but I cannot seem to achieve the same result using the formulas provided by ChatGPT or found online.
That’s why I’m reaching out to you, hoping that you might know the correct formula and could assist me. Here’s the formula I am currently using:
const rate = (5%(annualRate%) / 100) / 12;
const amountWithMargin = 201,515(amount) * 1.04 (margin 4%);
const rental = (amountWithMargin * rate) / (1 - Math.pow(1 + rate, -36(nb months)));
Thank you in advance for your help.
Best regards,
Delépine Tom