• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

In what month will we earn a profit?

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.
 
Hi, infinitedrifter!

Last week I read at topic about commisions, upfront payments and so on. This is the topic link, just in case:

http://chandoo.org/forums/topic/desperate-help-needed-in-sliding-scale-sales-commission-chart-workbook

Regards!
 
Back
Top