Hi everyone,

I have a question that I'm hoping someone can help me with. I know it may sound simple, but here it is:

I have to create an auto loan model for a new business, and each year I have to assume the business picks up new customers who sign on to auto loans.

For example, from 2014-2019, the business takes on 100 new auto loan customers each year. New customers only come online once each year, and it doesn't have to be in the same month each year.

I created a simple auto loan amortization schedule that I want to link each year's new customers too, but I don't know the best way to "layer" in each year's new customers without creating some massive formula.

I'm desperately looking for a formula or a way to layer in each year's new customers while still keeping the revenue coming in from the previous year's new customers (average auto loan payoff is assumed to be five years).

Can someone please help?

Thank you.