# How to Calculate New Cohort of Loans every N Month?

##### New Member
Hi all, seek your kind assistance on automating the following in row C where I want to simulate a loanbook and calculate the total amount of recurring loans (fixed value) from each new cohort of users from each month, where new users from each month will take a loan every 4 months (Paid back on month 3 and takes a new loan on month 4).

Question: How can I copy or automate the values or loan cycles from the New Loans in Month 1 to Month 4 and to subsequent months. Meaning calculating the total for all the new cohorts that is taking recurring loans every 4 months?

Note: as the new user cohort will grow every month - thus the total recurring loans can come from various cohort that takes up the same amount of loan every 4 months.

Example table:

Month1234
New Users10203040
New Loans1000200030004000
Recurring Loans1000

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Replies
5
Views
168
Replies
4
Views
695
Replies
0
Views
620
Replies
1
Views
170
Replies
2
Views
308

1,181,680
Messages
5,931,385
Members
436,788
Latest member
er19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back