Discount Calculation Worksheet
Translated by
ScribdTranslationsDiscount Calculation Worksheet
Translated by
ScribdTranslationsWORKSHEET
Simple Discount
Below are 6 problems that you must solve upon completion through
The CamScanner application must upload the resolution to the platform.
A person will discount a promissory note, with a maturity value of Q325,000.00 at a bank.
which charges 19% annual bank discount. How much time before its maturity?
You must perform the operation if you wish to receive Q300,000? R/ n = 148 days
Data Formula
S = 325,000.00 n= Db
Db = 25,000.00 S * d
d = 0.19 Solution
P = 300,000.00 n= 25,000.00
325,000.00 * 0.19
n= 0.40485830
n= 148 days
A document with a maturity value of Q82,500.00 will be discounted in 225 days.
What will be the amount of the discount? a) At a 10% annual simple bank discount and
b) Al 10% anual de descuento racional simple.R/ Db = 5,085.62 y Dr =4,852.94
Bank Discount
Data Formula Solution
S = 82,500.00 Db=S n d Db = 82,500.00 * (225/365) * 0.10
n = 225/365 Db = 5,085.62
d 0.10
Rational Discount
Data Formula Solution
S = 82,500.00 Dr =S 1- 1 Dr = 82,500.00 1 - 1
n = 225/360 1 + n i 1 + (225/360) 0.10
d 0.10
Dr = 82,500.00 1 - 0.941176471
Dr = 4,852.94
A promissory note with a nominal value of Q135,200.00, earns 17% annual simple interest.
exactly expires in 160 days deadline. It will be negotiated when there are 85 days left until its
maturity at a simple rational discount rate of 19% How much will be received for the
documento?R/ Valor del pagaré al vencimiento S=145,275.18; valor del Dr = 6,237.39;
valor a recibir = 139,037.79
Amount (promissory note)
Data Formula Solution
P = 135,200.00 S = P(1+n*i) S = 135,200*(1+(160/365)*0.17)
n = 160/365 S= 145,275.18
i = 0.17
S = ?
Solution
Dr 1 - 1
1 + (85/360) 0.19
Dr = 1 - 0.957065001
Dr = 6,237.39
Amount to receive 145,275.18 - 6,237.39 = 139,037.79
A person has a promissory note issued on July 15 of this year, the nominal value is
Q56,000.00; devenga el 13% anual de interés simple ordinario y vence el 1 de noviembre
del mismo año, el 21 de agosto necesita financiamiento y recurre a negociar el documento
at 14% annual bank discount. How much will he receive for the document? R/ Value of
pagaré al vencimiento S=58,204.22; valor del Db = 1,607.39; valor a recibir = 56,596.83
Amount (promissory note)
Data Ordinary Mr.
P = 56,000.00 01/11/2020
n = 109/360 15/07/2020 109 días
i = 0.13
S = ?
S = P(1 + n * i)
S =56,000*(1+(109/360)*0.13)
S= 58,204.22
Bank Discount.
M. Exactly
01/11/2020
21/08/2020 72 days
Data Formula Solution
S = 58,204.22 Db = S n d Db = 58,204.22 * 72/365 0.14
n = 72/365 Db = 58,204.22 * 0.197260274 * 0.14
d = 0.14 Db = 1,607.39
VL = 58,204.22 - 1,607.39 = 56,596.83
Another formula
Formula
Net worth
VL = S 1 - n d
VL = 58,204.22 1 - (72/365) * 0.14
VL = 58,204.22 * 0.972383562
VL= 56,596.83
On July 31, a billing is made for furniture and equipment on credit for the amount of Q185,000.00, with the
the following payment options 14%/Cash, 12/30, 9/60 and 90 days net, the question is:
What is the best option from a financial point of view?
Condition % Value Net Discount Value
Alternative
Payment Discount Invoice (I) (P)
1 Counted 14% 185,000.00 25,900.00 159,100.00
2 30 days 12% 185,000.00 22,200.00 162,800.00
3 60 days 9% 185,000.00 16,650.00 168,350.00
4 90 days 0% 185,000.00 0.00 185,000.00
i = I / Pn
i = 25,900 / 159,100*(90/360) i= 0.6511628
i = 22,200 / 162,800 * (60/360) i= 0.818181818
i = 16,650 / 168,350 * (30/360) i= 1.186813187
A batch of merchandise was purchased through catalog offers valued at
Q47,775.50. The selling company granted the following discounts on the purchase.
10% for being cash payment, 6% for being a 'A' customer, and 3.5% for being a bulk purchase of
Q.30,000.00, The manager of the purchasing company requests you to determine:
The net amount to pay R/ 39,003.44
b) El valor del descuento único y b) 8,772.06; c) 0.18361
c) La tasa de descuento único aplicada. ; b) 8,772.06; c) 0.18361
Indirect Method
Valor Factura % Descuento Valor Descuento Valor a Pagar
47,775.50 10% 4,777.55 42,997.95
42,997.95 6% 2,579.88 40,418.07
40,418.07 3.5% 1,414.63 39,003.44a)
8,772.06b)
18.361% c)
Direct Method
a) Net amount to be paid
Formula VN = P[ (1-d1) (1-d2) (1-d3) … (1-dn) ]
SolutionVN = 47,775.50 [ (1-0.10) (1-0.06) (1-0.035) ) ]
VN= 47,775.50 [ 0.90 * 0.94 * 0.965
VN= 47,775.50 [ 0.81639 ]
VN=39,003.44
b) Amount of the discount
FormulaI = P * Du
Solution I= 47,775.50 * 0.18361
I= 8,772.06
c) Single discount rate
Formula Du = 1 - [ (1-d1) (1-d2) (1-d3) … (1-dn) ]
Solution Du= # - (1-0.10) (1-0.06) (1-0.035)
You = - ( 0.90 * 0.94 * 0.965
You = - ( 0.81639 )
You 0.18361
You 18.361%