need a spread sheet that uses different % for different amounts,clients and time.

[lemmytl]

Hi,
I have a basic understanding how to use excel but what i need is this (i will keep it as simple as i can),
I have about 40 clients and i receive a fixed amount for them which is spread over a period of 8-18 months.

I receive a slightly different amount for each one.

The payments are made monthly with a different Percentage of the whole payment made each month ( For example 15% at start, 10% for the next 5 months then 5% for the next 5 months and 10% at the end).

I will have different clients starting and finishing in different months so need to be able to use a end month.

I would like to be able to see the total monthly income against a monthly target (+ or -).

I would like to be able to put the total income from each client at the start and let excel do the above.

I am happy to have a few different sheets and or use Pivot tables, but would like the results in one area and be able to add new clients as i go.

Is this Possible.
Thanks for your help.

[FDibbins]

Hi and welcome to the forum

Have you made a start on this yet (at least, what you think it should look like)?

Perhaps put something together (manually is ok) showing what you have and what you thing it should look like

[lemmytl]

Hi,
the attached screenshot gives a rough idea of what i am looking to do i need to understand how to put in calculations for the % and how excel can do this for me. In simple terms please as i only have a basic understanding.
Thanks
Screenshot 2014-06-28 11.58.51.png