# Helping with formula which calculate payment term

1. ## Helping with formula which calculate payment term

Hi Guys,

Example: I have 3 years contract worth £3000 first payment will be paid in first year however the rest on the end of the contract. The problem with that is first payment will be paid like that: 93% of 75% what does mean by that is the supplier will agreed with us they will pay us 75% of the 100% but because of the risk the will pay 93% of our 75% the rest will be paid on the end of our contract which is our 25% + 7%.
I can calculate it manually but it is time consuming if I have 50 contracts a day. I need one formula which calculate for me everything right now  Register To Reply

2. ## Re: Helping with formula which calculate payment term

Hi, maybe in E1:
=D3*75%*93%
and in J1:
=D1-E1  Register To Reply

3. ## Re: Helping with formula which calculate payment term

Hi,

Thanks for that, yes this is easy formula which I am currently using, I was thinking something more advanced such as one formula to each column, in your example I have to each year calculate separately I wish to create one formula which calculate me everything in one time.  Register To Reply