+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    03-14-2022
    Location
    Canada
    MS-Off Ver
    Google Sheets
    Posts
    2

    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. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    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
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use different formulas to calculate commissions based on customer name.
    By jambog in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2021, 05:44 PM
  2. [SOLVED] Calculate the portion of a planned number during a period, based on another time period
    By BryGuy81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2017, 01:29 PM
  3. Formula to calculate sales commissions based on % discounted
    By Doug S in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2015, 06:42 PM
  4. [SOLVED] Need formula to calculate commissions for employees based on the month earned on 2 sheets
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 12:09 AM
  5. [SOLVED] calculate pay checks per month, to get monthly income value for that month.
    By tladd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2012, 09:51 PM
  6. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  7. [SOLVED] How can I calculate commissions that are not percentage based?
    By Sean in forum Excel General
    Replies: 3
    Last Post: 03-31-2006, 03:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1