# Calculate Income for each month based on commissions for a fixed period

1. ## Calculate Income for each month based on commissions for a fixed period

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).

2. ## Re: Calculate Income for each month based on commissions for a fixed period

a sample spreadsheet will help to illustrate what yo are trying to achieve.

please attach a sample spreadsheet by following the instructions in the yellow banner above your first post

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