Exact month to see when I break even

1. Exact month to see when I break even

Hi everyone,

I am trying to determine the exact month I will break even, given a set of revenue, discounts (cost) and the net revenue.

I can determine the first month my cashflow becomes positive with the formula:

=INDEX(\$B\$1:\$U\$1,MATCH(TRUE,\$B13:\$U13>0,0))

However, I want to know when my business become profitable considering accumulated costs in previous months.

2. Re: Exact month to see when I break even

try below formula
=AGGREGATE(15,6,B1:U1/(SUBTOTAL(9,OFFSET(B13,,,1,COLUMN(B13:U13)-COLUMN(B13)+1))>=0),1)
Formula:
`Please Login or Register  to view this content.`

3. Re: Exact month to see when I break even

Thank you samba_ravi, it worked perfectly.

Do you mind explaining your solution, I desire to understand what each function does

Originally Posted by samba_ravi
try below formula
=AGGREGATE(15,6,B1:U1/(SUBTOTAL(9,OFFSET(B13,,,1,COLUMN(B13:U13)-COLUMN(B13)+1))>=0),1)
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1