infinitedrifter
New Member
We're paid an upfront annual commission (avg comm/deal) for each client. On month 13, we start to receive a monthly commission (avg comm/deal / 12) for each client. We also have certain costs associated with obtaining each client (Total cost/deal). Each of these is variable & can be changed w/i the spreadsheet.
What I'm trying to develop is a formula that determines the month in which we begin earning a profit on each client (after absorbing losses). Sort of like a break even analysis point but more like a return on investment, but I'm looking for a month rather than number of units sold or price point.
I need to calculate this & show it visually. Any suggestions?
https://docs.google.com/open?id=0B9_U_YkSNyAtTUUyUkdFT0U1M28
Thanks in advance for any help.
What I'm trying to develop is a formula that determines the month in which we begin earning a profit on each client (after absorbing losses). Sort of like a break even analysis point but more like a return on investment, but I'm looking for a month rather than number of units sold or price point.
I need to calculate this & show it visually. Any suggestions?
https://docs.google.com/open?id=0B9_U_YkSNyAtTUUyUkdFT0U1M28
Thanks in advance for any help.