How to Calculate New Cohort of Loans every N Month?

maddude

New Member
Joined
Nov 3, 2005
Messages
11
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

Thank you in advance
 

Excel Facts

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

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top