Cumulative interest calculation

xzhan252
New Contributor

Cumulative interest calculation

Hi,

 

I need to calculate total loan interest for each month, and every loan was originated in different month. See below example, five loans were originated in different months and amount, and they have same interest % for each life period( i.e. loan x period 1 interest % is 1.058%, loan y period 1 interest % is also 1.058%)

 

Loan amount, origination month and interest % for each period are input. Any idea if I can just have "Loan total interest" line item in a module to do all the cal from line 1 to line 5?

xzhan252_0-1626716772979.png

Thanks

Jay

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarkWarren
Expert

Re: Cumulative interest calculation

To follow up from Rob, when coming from Excel its important to think about how to transition to multi-dimensionality, like here where you have 5 lines in Excel with calculations on each line. In Anaplan we can have one calculation applied to a list of 5 items instead.
here's a couple of short courses, the first one here is what Rob has described to use for your cumulative interest:
Understanding Top Level - Anaplan Community
Manually Adding and Organizing Lists - Anaplan Community

View solution in original post

3 REPLIES 3
ashish.banka
Super Contributor

Re: Cumulative interest calculation

rob_marshall
Moderator

Re: Cumulative interest calculation

@xzhan252 

 

Are Lines 1 through 5 the loans?  And if so, is that a list?  If yes to both of those, can't you just put a top level on the Loan list where it will aggregate every the loans by month for you?

 

Rob

MarkWarren
Expert

Re: Cumulative interest calculation

To follow up from Rob, when coming from Excel its important to think about how to transition to multi-dimensionality, like here where you have 5 lines in Excel with calculations on each line. In Anaplan we can have one calculation applied to a list of 5 items instead.
here's a couple of short courses, the first one here is what Rob has described to use for your cumulative interest:
Understanding Top Level - Anaplan Community
Manually Adding and Organizing Lists - Anaplan Community

View solution in original post