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.
Please see attached spreadsheet
Bookmarks