A quick Calc formula needed..

[Droolinggimp]

Not being the best with spreadsheets, I can do a basic budget etc. I am needing a bit of help. I now have a new job and it's paid weekly as apposed to my other job of 4 weekly. I get paid by the hour and not salary any more so my weekly wages will be different each week.

I am currently paying child maintenance and have given them my new details (£ per hour, frequency of pay etc) but they will base any payments on my contracted hours of 40 p/w and I know for sure I will go over these hours but not pay more in the CSA payments until the review in 12 months time when they adjust the payments for the coming year. I am wanting to save up the difference each week/month to clear it once the review comes into effect so I can pay off the arrears and not have larger payments for the following year.

Anyway... In Open office calc (spreadsheet) I am looking to arrive at a figure that I bring home.

Here goes.

A*.15=B
A-B=C
C*.15=how much I have to pay yearly

A - gross salary
B - how much I WOULD pay for single child
C - is how much I have to pay child at reduced rate due to having child living with me.

I hope that is clear.

In the words of the CSA. They take 15% of my gross and arrive at that figure, that is what I paid for my (no contact) child. Now I have another they take 15% of the Gross figure that has already had the first 15% taken off. So I will pay less for the first child if that makes sense..

Anyway.. The formula above is what I need as I will be amending is on a weekly basis on my budget..

Cheers in advance

 

[Greboth]

Assuming I followed you correctly, surely the easiest way is to deduct all CSA payments in one go. Two 15% amounts deducted seperately is equivalent to 27.75%, or otherway round you will keep 72.25% of your gross salary after CSA deductions.

Edit: So using your lettering: A*0.2775=how much you will have to pay yearly.

If you want to specifically know the amounts you have paid to the CSA then
Column A = Gross salary
Column B =A*0.15 (amount you pay for child 1)
Column C = (A-B)*0.15 (amount you pay for child 2)
Column D = A-B-C (gives you your net salary)

Edit2: Obviously that only gives you the amount you should pay per child. If, as your post makes out, you will pay a fixed amount to CSA for the year but then at the end of the year pay any extra owing. From the figures from above you could deducted the actual CSA deductions or your actual net pay which will give you the difference between what you are paying and will have to pay.

 

[Droolinggimp]

Hmmm not quite right I don't think. Maybe my wording not sure

Example:

wage 20,000
15% deducted is 17,000 (3000 taken off)
17,000 with another 15% deducted is 14450 (2550 taken off)

That 2550 is what will pay yearly. I then divide it by 52 and that's what I will pay in CSA payments weekly. If I earn more per week I will put the difference away to pay next year.

I just need a formula that when I put in my wage eg 350 it will show up with these % Knocked off and show me the amount I should pay in either the same cell or another.

Edit: Looking at your example it does look like it works but not giving me the same results ???

 

[Droolinggimp]

I think you think I am paying for two children.. No just one. Having another with me now reduces the CSA payments. Thats why they take another 15% off my income so the 15% I pay to the other child is taken off my gross AFTER its been reduced by 15% so the payment is smaller..

The CSA take 15% of gross to pay child (not in my care). Now I have one of my own (in my care) they make my Gross 15% smaller (so I dont' have to pay more) and then take 15% of the lowered gross to pay for child one.

 

[Greboth]

Ok I think understand, you originally paid £3000 a year (15%) but now as you have a child living with you, you will only pay £2550 (15% of your Gross minus 15%).

So the one from my post should work however as you don't seem to need to know the 15% reduction amount before the 15% for the CSA you could put it in one cell.

Column A: Gross salary
Column B: =(A*0.85)*0.15 (which will give you the amount you should be paying in CSA)

If you wanted you could add
Column C: =B-(2550/52) (which will give you the difference between the amount you should be paying and amount you are paying)

 

[Droolinggimp]

Cheers. I was wanting pretty much that sum so I don't need to see the first deduction. After faffing myself my sum is like yours but yours is smaller.

Thanks for your help anyway..