Credit Discount Spreadsheet Calculator

ADVERTISEMENT

TRADE CREDIT DISCOUNT CALCULATOR
Discount (Percentage)
1%
2%
3%
4%
5%
6%
7%
8%
9%
10%
$1
0.99
0.98
0.97
0.96
0.95
0.94
0.93
0.92
0.91
0.90
$2
1.98
1.96
1.94
1.92
1.90
1.88
1.86
1.84
1.82
1.80
$3
2.97
2.94
2.91
2.88
2.85
2.82
2.79
2.76
2.73
2.70
$4
3.96
3.92
3.88
3.84
3.80
3.76
3.72
3.68
3.64
3.60
$5
4.95
4.90
4.85
4.80
4.75
4.70
4.65
4.60
4.55
4.50
$6
5.94
5.88
5.82
5.76
5.70
5.64
5.58
5.52
5.46
5.40
$7
6.93
6.86
6.79
6.72
6.65
6.58
6.51
6.44
6.37
6.30
$8
7.92
7.84
7.76
7.68
7.60
7.52
7.44
7.36
7.28
7.20
$9
8.91
8.82
8.73
8.64
8.55
8.46
8.37
8.28
8.19
8.10
$10
9.90
9.80
9.70
9.60
9.50
9.40
9.30
9.20
9.10
9.00
$20
19.80
19.60
19.40
19.20
19.00
18.80
18.60
18.40
18.20
18.00
$30
29.70
29.40
29.10
28.80
28.50
28.20
27.90
27.60
27.30
27.00
$40
39.60
39.20
38.80
38.40
38.00
37.60
37.20
36.80
36.40
36.00
$50
49.50
49.00
48.50
48.00
47.50
47.00
46.50
46.00
45.50
45.00
$60
59.40
58.80
58.20
57.60
57.00
56.40
55.80
55.20
54.60
54.00
$70
69.30
68.60
67.90
67.20
66.50
65.80
65.10
64.40
63.70
63.00
$80
79.20
78.40
77.60
76.80
76.00
75.20
74.40
73.60
72.80
72.00
$90
89.10
88.20
87.30
86.40
85.50
84.60
83.70
82.80
81.90
81.00
$100
99.00
98.00
97.00
96.00
95.00
94.00
93.00
92.00
91.00
90.00
$200
198.00
196.00
194.00
192.00
190.00
188.00
186.00
184.00
182.00
180.00
$233
230.67
228.34
226.01
223.68
221.35
219.02
216.69
214.36
212.03
209.70
$400
396.00
392.00
388.00
384.00
380.00
376.00
372.00
368.00
364.00
360.00
$500
495.00
490.00
485.00
480.00
475.00
470.00
465.00
460.00
455.00
450.00
$600
594.00
588.00
582.00
576.00
570.00
564.00
558.00
552.00
546.00
540.00
$700
693.00
686.00
679.00
672.00
665.00
658.00
651.00
644.00
637.00
630.00
$800
792.00
784.00
776.00
768.00
760.00
752.00
744.00
736.00
728.00
720.00
$900
891.00
882.00
873.00
864.00
855.00
846.00
837.00
828.00
819.00
810.00
$1,000
990.00
980.00
970.00
960.00
950.00
940.00
930.00
920.00
910.00
900.00
$2,000
1980.00
1960.00
1940.00
1920.00
1900.00
1880.00
1860.00
1840.00
1820.00
1800.00
$3,000
2970.00
2940.00
2910.00
2880.00
2850.00
2820.00
2790.00
2760.00
2730.00
2700.00
$4,000
3960.00
3920.00
3880.00
3840.00
3800.00
3760.00
3720.00
3680.00
3640.00
3600.00
$5,000
4950.00
4900.00
4850.00
4800.00
4750.00
4700.00
4650.00
4600.00
4550.00
4500.00
$6,000
5940.00
5880.00
5820.00
5760.00
5700.00
5640.00
5580.00
5520.00
5460.00
5400.00
$7,000
6930.00
6860.00
6790.00
6720.00
6650.00
6580.00
6510.00
6440.00
6370.00
6300.00
$8,000
7920.00
7840.00
7760.00
7680.00
7600.00
7520.00
7440.00
7360.00
7280.00
7200.00
$9,000
8910.00
8820.00
8730.00
8640.00
8550.00
8460.00
8370.00
8280.00
8190.00
8100.00
$10,000
9900.00
9800.00
9700.00
9600.00
9500.00
9400.00
9300.00
9200.00
9100.00
9000.00
$20,000
19800.00
19600.00
19400.00
19200.00
19000.00
18800.00
18600.00
18400.00
18200.00
18000.00
$30,000
29700.00
29400.00
29100.00
28800.00
28500.00
28200.00
27900.00
27600.00
27300.00
27000.00
$40,000
39600.00
39200.00
38800.00
38400.00
38000.00
37600.00
37200.00
36800.00
36400.00
36000.00
$50,000
49500.00
49000.00
48500.00
48000.00
47500.00
47000.00
46500.00
46000.00
45500.00
45000.00
$60,000
59400.00
58800.00
58200.00
57600.00
57000.00
56400.00
55800.00
55200.00
54600.00
54000.00
$70,000
69300.00
68600.00
67900.00
67200.00
66500.00
65800.00
65100.00
64400.00
63700.00
63000.00
$80,000
79200.00
78400.00
77600.00
76800.00
76000.00
75200.00
74400.00
73600.00
72800.00
72000.00
$90,000
89100.00
88200.00
87300.00
86400.00
85500.00
84600.00
83700.00
82800.00
81900.00
81000.00
$100,000
99000.00
98000.00
97000.00
96000.00
95000.00
94000.00
93000.00
92000.00
91000.00
90000.00
Use this chart to calculate your trade credit discount. Read down the left column to find the total
amount due and across the top row to find the discount rate. Your discounted payment amount is
where the two intersect. Combine totals for amounts not listed: a 2% discount on $150 is equal to 2%
on $100 (98.00) plus 2% on $50 (49.00) for a total discounted amount of $147.

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Financial
Go