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:
Thank you in advance
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:
Month | 1 | 2 | 3 | 4 |
---|---|---|---|---|
New Users | 10 | 20 | 30 | 40 |
New Loans | 1000 | 2000 | 3000 | 4000 |
Recurring Loans | 1000 |
Thank you in advance