Trying to get a formula or equation to model out the following type of scenario. Sorry for such a noob question but I am stuck!
For Every sale I make a $100 monthly commission every month for 4 months.
I sell 5 products a month.
How much do I make in month 1, month 2....month N?
So for example in month 1 it would be 100X5=500
In Month 2 it would be 1,000 (the $500 from this month's sales + $500 from last month).
Month 3 = $1500
Month 4 = $2000
Month 5 = $2000 (the first months commissions would be expired since it pays out over only 4 months)
The variables that can change are the amount of the commission, number of monthly commissions and the term (for how many months after sale each commission is paid out). Trying to create a model to show how much income in each month (not looking for the cumulative income).
Bookmarks