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 slm methodretained earning balancemanufacturing overhead formula examplethe term receivables includes allhow to calculate present value of lease paymentsbad debt expense allowance methodbasic bookkeeping templatewhat is stockholders equity in accountingbooking depreciationhow to calculate accrued expensesdouble declining balance method calculatoraccumulated depreciation fixed assetgeneral ledger account balancesaccrued income entryprepaid insurance journal entry exampledouble entry records for depreciationinventory accounting basicseom discounthow to prepare a vertical analysisaccounting liquidity ratioswhat is payback methoddeclining perpetuity formulaaccounting journal entries transactionaccrual to cash conversion worksheetadjusting entry definitioncompute cost of goods manufacturedgeneral ledger chart of accounts templatemulti step income statementswip journal entryhow to record income tax expense with a journal entrybookkeeping templatescash receipt sample worddouble declining balance exceljournal entry for bills receivablecalculating gross profit ratiohow to figure inventory turnoveraccounting accrued expensesjournal entry for outstanding salaryprofit vs markupunearned revenuecashbook templatejournal entry for return of capitalaccounts receivables factoringpercentage of completion method of accountingjournal entries of accounts payableinterest calculator reducing balance methodimprest checkwip balance sheetexcel profit marginfob plant definitionfuture annuity calculatoraccruals and prepaymentfifo method calculatordebits in accountingdebit memo journal entrydebtors ledger exampleamortizing bond premiumbalancing accounts receivablethe present value of a lump sum future amountdefine installment paymentprepaid revenue journal entrydepreciation calculator straight line methodhow to write a voucher for paymentdummies guide to bookkeepingexcel npv exampleincome statement multiple stepfixed liabilities examplesdifference between p&l and balance sheetallowance for bad debt accountaccounting receivable processjournal entry for accrued wagesreversing entries definitionaccrued expenses income statementsuspense account is which type of accounthow to calculate bond discount