Max Toedtemeier (FrenchyMaxwell)

FrenchyMaxwell Member since 2018 7 posts
Posted: November 20, 2019
Last activity: November 20, 2019
Posted: 20 Nov 2019 11:28 EST
Last activity: 20 Nov 2019 11:28 EST

Pega Financial cumprinc calc is calculating a different value than excel's cumprinc

We use @(Pega-DecisionEngine:Financial).cumprinc to calculate a balloon payment.

We are getting report from our users that the balloon payment on a loan is not adding up correctly. To get this value we use the following inputs:

Param.ModifiedInterestRateCurrent = 5.75/1200 = 0.004791667
Param.ModifiedTermRemaining = 480
Param.ModifiedBalancePrinicpalCurrent = 77070.33
Param.StartPeriod = 1
Param.TermsToMaturity = 329

With these values we get a cumulative principle of 33003.78 out of pega.

With these values we get a cumulative principle of 33213.93 out of excel.
=CUMPRINC(0.004791667, 480, 77070.33, 1, 329, 1)

Has anyone seen this behavior and have a fix for it?

Enterprise Application Development Dev/Designer Studio
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.