Excel Model Help (which formulas should I be using?)

[ddp34]

Sample.xlsx

The above file contains a simple model. I need help with making the "monthly income" line dynamic and automatic...so when you change cells B14 to B19, the monthly income changes for each month. I made the first part automatic, but need help with the last part, which is the monthly income. Can anyone help me with which formula(s) I should use. You can see that tried breaking it down towards the bottom, but my professor wants all formulas in one cell to generate the value. Any help is much appreciated. Thanks!

More info:

You have input cells, which defines delay in months before starting 1-6 operating companies, table per month with how many new investors enroll in that month per active operating company, fees that are generated for every investors and number of months after which the fee is collected.

You need to generate formulas to create same values as shown in Output Solution, that shows 0 when operating company is not active, 1 when operating company is active (did this part!), Number of active companies (did this!) and fees that were generated per month (NEED HELP ON THIS!).

Btw, the "multiples" chart is something that I had created to assist me in figuring out the monthly income, but professor said I cannot use that, since I have to put everything in one formula and one cell. So, cant use that in figuring out the monthly income. Can only use what was given.

Thanks again everyone!

[ddp34]

bump bump bump