Skip to main content
Solved

Financial Functions

  • November 16, 2022
  • 1 reply
  • 567 views
Dominick Gonzalez
Wallflower
Forum|alt.badge.img

Hey Team,

I am working on an Existing Fixed Rate Loan walk-forward build. In the source system, the original fixed monthly payment is calculated by the following: 

 

IF
    Loan Term <> 0
THEN
    PMT(Interest Rate Origination Period / 12, ABS(Loan Term), ABS(LoanAcquisitionActualUPBAmt), 0, 0)
ELSE
    PMT(Interest Rate Origination Period / 12, Loan Term Final, ABS(LoanAcquisitionActualUPBAmt), 0, 0)


Does Pigment have an equivalent function to calculate PMT? (Calculates the monthly amount required to pay back a loan given each payment is equal)

 

Please advise - Thanks!

Best answer by francois

Hi Dominick,

This question has actually been asked in the past! It’s currently under review though @Nathan has found a workaround formula if you want it now.

 

1 reply

francois
Employee
Forum|alt.badge.img+13
  • francoisEmployee
  • Employee
  • 171 replies
  • Answer
  • November 16, 2022

Hi Dominick,

This question has actually been asked in the past! It’s currently under review though @Nathan has found a workaround formula if you want it now.

 

François (Pigment)


Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement