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
Brief about the project/file:
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
Bookmarks