# Calculate cumulative repayment for monthly given loan

1. ## Calculate cumulative repayment for monthly given loan

I need to create a function that calculates the monthly collected money (in row 24) from all previous months given loans (row 23), given that Every month (loan) is divided on 4 different plans

1- Every month we are giving customers new loans
2- The next month the customer starts to repay the loan+interest
3- Customers can pay on 4 different plans 1,3,6 &12 months, portions of these plans are in the Assumptions sheet
4- Monthly given (loans - default + interest) calculated in row 23

2. ## Re: Calculate cumulative repayment for monthly given loan

Hello mouradashry and Welcome to Excel Forum.
I feel as if I am missing something however based on my understanding of "a function that calculates the monthly collected money (in row 24) from all previous months given loans (row 23)" I would suggest pasting the following into B24 and dragging across: =SUM(\$B23:B23)
If that does not produce the desired results then I suggest manually placing some expected results in row 24 and unless it is obvious as to how those values are derived include an explanation. Someone may then be able to replicate the manually placed values using formula/code.
Let us know if you have any questions.

There are currently 1 users browsing this thread. (0 members and 1 guests)