Cost of Trade Credit Calculator

The cost of trade credit calculator can be used to calculate the annualized cost of offering early payment discounts to customers or alternatively of not taking early payment discounts from suppliers.

Cost of Trade Credit Formula

The calculator uses the cost of trade credit formula based on a 365 day year as shown below:

Cost of trade credit =(1 + d /(1 – d)) (365 / (Normal days – Discount days)) – 1
Where
d = Early payment discount percentage
Normal days = Normal credit terms offered
Discount days = Days in which discount can be taken

The formula is based on the effective annual rate (EAR) formula which calculates the rate of interest for a year based on a nominal interest rate compounded a number of times a year.

Cost of Trade Credit Calculator Formula

As an example of the use of the calculator, suppose a business offers 2/10 net 30 terms to customers which means a 2% discount (d) is allowed if the customer pays within 10 days (discount days) otherwise full payment is due within 30 days (normal days). If the customer takes the discount then the amount less the discount is paid 20 days early, but a cost equal to the discount is incurred.

The cost of trade credit can then be calculated using the formula as follows:

d = 2%
Normal days = 30
Discount days = 10
Cost of trade credit = (1 + d /(1 - d)) (365 / (Normal days - Discount days)) - 1
Cost of trade credit = (1 + 2% /(1 - 2%)) ^(365 / (30 - 10)) - 1
Cost of trade credit = 44.59%

In this example, the cost of having the use of the funds for an additional 20 days is equivalent to an annualized cost of trade credit of 44.59%. This means that if the business is able to borrow the funds at less than 44.59% it should do so rather than offer the early payment discount.

A similar calculation can be carried out to determine whether or not to take a discount offered by a supplier. In this case if the business does not take the discount and pay early, then it has the use of the funds for a further 20 days, however, this is done at the cost of not taking the discount of 2%. Using the same formula the cost of not taking the discount will be the same as in the example above 44.59%. If the business can borrow at a rate less then this then it should do so and take the early payment discount.

cost of trade credit calculator v 1.0
Cost of Trade Credit Calculator Preview

Using the Cost of Trade Credit Calculator

The Excel cost of trade credit calculator, available for download below, is used to compute the annualized cost of either offering an early payment discount to customers or not taking an early payment discount from suppliers. The calculator is used as follows:

  1. Enter the normal days. The normal days is the normal credit terms in which an invoice is due for payment. For example, if the terms are 2/10 net 30, the normal days would be entered as 30.
  2. Enter the discount days. The discount days is the number of days in which payment must be made to get the early payment discount. For example, if the terms are 2/10 net 30, the discount days would be entered as 10.
  3. Enter the early payment discount. The early payment discount is the discount offered for early payment of the invoice. For example, if the terms are 2/10 net 30, the early payment discount would be entered as 2%. The cost of trade credit calculator calculates the annualized cost of trade credit based on a 365 day year.

Cost of Trade Credit Calculator Download

The cost of trade credit spreadsheet is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this cost of trade credit calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a cost of trade credit calculator that you might use when considering how to calculate the annualized cost of trade credit. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this cost of trade credit calculator, please let us know and we will try to fix it.
Cost of Trade Credit Calculator November 6th, 2016Team

You May Also Like


Related pages


depreciation reducing balance methodallowance method for bad debtsoperating cash flow formula excelwarranty journal entriesmarkup on cost formulasoyd depreciationaccounting post closing trial balanceprofitability ratios accountingaging accounts receivablefbo shippingvouchered invoicestwo column cash bookdeferral accountingwhat is the formula for contribution marginimprest amount meaningvoucher book formatfixed asset turnover interpretationnpv of annuity formulareserve accounting entriesannuity pv tabledupont analysis equationdouble declining formulaprofitability ratios examplesaccounts receivable spreadsheetcos bookkeepingcheque exampleshow to calculate total fixed cost formulaaccounting for unrealized gains and losses on investmentsdouble entry bookkeeping practice questionshow to do closing entries in accountingexcel pmt functionpresent value lump sum tablegearing ratio calculationhow to find doubling timefob destination vs fob originperpetuities calculatorpurchasing price varianceexcel annuity calculationhow to calculate aging of accounts receivablejournal entries in tallyexample of a cashbookpetty cash fund accountingaverage days sales in receivablespmt mortgagepresent value of a perpetuityincome summary journal entryfuture value of annuity chartformula for annuitygaap vacation accrualcost volume profit formulasaccounting for zero coupon bondsgeneral ledger accounts exampledebtors on balance sheetoutstanding cheques bank reconciliationcalculating net realizable valueimplicit calculatorstraight line depreciation calculatorannuity table future valueactivity ratios formulasbookkeeping sampleaccounts receivable reconciliation examplestock valuation calculatordeferred taxes on cash flow statementmarkup percentage calculationhow do you calculate markup percentagewhere are adjusting entries recordedhow to record unearned revenuehow to solve for variable costwhat is a lifo reservefifo method formulatax effect accounting journal entriescost formula managerial accountingreducing balance method equationdefinition of sundry expenses