Which month does breakeven occur?

[Hunter Childress]

Using the attached example, I am trying to create an excel formula where from year 0 to year 5 for each line, I want to know what month number does the accumulative dollars hit breakeven?

For example, on line 7, I know breakeven is between month 36 and 48 but I want to know exactly which month number.

Thank you!

 

[p45cal]

Test in H7:

=FORECAST.LINEAR(-B7,$C$6:$G$6,LET(s,C7:G7,k,SEQUENCE(,COLUMNS(s)),SUBTOTAL(9,OFFSET(s,,,,k))))

and copy down. It uses linear interpolation but the growth might not be linear, so may not be accurate.

 

[Hunter Childress]

Wicked formula! How did you learn how to use those functions? It's close enough!