+ Reply to Thread
Results 1 to 3 of 3

Helping with formula which calculate payment term

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    glasgow
    MS-Off Ver
    Excel 2003
    Posts
    41

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Helping with formula which calculate payment term

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

  3. #3
    Registered User
    Join Date
    02-15-2014
    Location
    glasgow
    MS-Off Ver
    Excel 2003
    Posts
    41

    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.

+ 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. supplier payment term-formula
    By jowii307 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2014, 08:46 AM
  2. [SOLVED] workday formula automatic update term of payment
    By pakian in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 03:13 AM
  3. Replies: 3
    Last Post: 07-29-2013, 11:31 AM
  4. PMT with balloon payment at the end of term
    By Aland2929 in forum Excel General
    Replies: 4
    Last Post: 04-06-2013, 07:16 PM
  5. Need Formula To Calculate Payment And Interest
    By travelersway in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-19-2005, 05:47 PM

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