calculating settlement discount
deborahcarpenter
Registered Posts: 161 Dedicated contributor 🦉
i have been told my answer is incorrect on this question but i cant see where i am going wrong. Could someone please look at my calculations and tell me where i am going wrong.
' a business is considering offering settlement discount terms of 2% for payment within 14 days. The average normal settlement period is 30 days. '
I have calculated
2/100-2 x 365/30-14 x 100 = 46.55
I have been told the answer should be 26.6%. Where does that come from?
Thanks in advance
' a business is considering offering settlement discount terms of 2% for payment within 14 days. The average normal settlement period is 30 days. '
I have calculated
2/100-2 x 365/30-14 x 100 = 46.55
I have been told the answer should be 26.6%. Where does that come from?
Thanks in advance
0
Comments
-
Whoever told you that 26.6% is the annual percentage rate when you allow a 2% discount for customers who pay within 14 days compared to 30 days has misled you.
Before I go on and show you how to find the correct rate, please can you check that I have understood the question you have posed?
Customers are allowed to pay 2% less than the invoice value provided they pay within 14 days (rather than within 30 days).
If I have understood the question correctly then there are 3 sums to do.- Find out what 2% is as a % of the amount that the customer will actually pay.
- Find out how many days earlier you will receive the money, and how ,many periods of this earlier payment are in a year.
- Then say 1+the percentage rate and index this to the power of the number of periods and then deduct 1, and convert to a %.
- 2/98 = 0.020408
- 30-14 = 16 and 365/16 = 22.8125
- 1+0.020408 = 1.020408 ^22.8125 = 1.585459 and -1 = 0.585459 and x 100 = 58.55%
Here is a narrative explanation.
Step 1 finds the % you allow out of the amount you will receive
Step 2 finds how many periods there are in a year
Step 3 compounds the % you allow (in this case for 16 days) so you can see how much this is equivalent to for a whole year.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Thanks for your reply Sandy. I have just re read the question and it wants the annual cost of the discount with the figures i have given you.
Does this make any difference?
and how do you work out the power of?0 -
deborahcarpenter wrote: »i have been told my answer is incorrect on this question but i cant see where i am going wrong. Could someone please look at my calculations and tell me where i am going wrong.
' a business is considering offering settlement discount terms of 2% for payment within 14 days. The average normal settlement period is 30 days. '
I have calculated
2/100-2 x 365/30-14 x 100 = 46.55
I have been told the answer should be 26.6%. Where does that come from?
Thanks in advance
Hi Deborah,
I think we could look at this question quite simply. Let suppose the question was rephrased another way - for example - lets say that a company will lend you X amount of money at an interest rate of 2% per month? What would be the APR for this monthly rate. This is effectively what we are doing except that we have turned it around by saying what is the APR on a 2% monthly discounted rate. The 14 days and the 30 days are irrelevant and not needed in order to calculate the answer.
APR for 2% monthly rate of interest is therefore calculated as:
(1+2/100)^12 - 1 = 26.8%
Not sure why they got 26.6 instead of 26.8 because this is what my calculator is giving me. But I am pretty certain that this is how you calculate it.0 -
Thanks for your reply Sandy. I have just re read the question and it wants the annual cost of the discount with the figures i have given you.
Does this make any difference?
and how do you work out the power of?
The power of button is not on all calculators.
it looks different from one to another, my casio fx-83ES has x with a square in the same place as you'd expect the 2 in a "squared" or "cubed" expression.
Others have the ^ rather like key boards have ^ above the 6.
I checked with AAT over the style of questions that can be asked on this topic. In the past, the compound method I showed had become the correct approach.
I now gather that the questions will add "compound" to questions that need to be answered in this way.
The other method is called "simple interest" and uses the method you showed.
So you need to be able to use both.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Simple interest approach using your figures
I haven't added much to your original calculation
Customers are allowed to pay 2% less than the invoice value provided they pay within 14 days (rather than within 30 days).
If I have understood the question correctly then there are 3 sums to do.
1. Find out what 2% is as a % of the amount that the customer will actually pay.
2. Find out how many days earlier you will receive the money, and how ,many periods of this earlier payment are in a year.
3. Then say the percentage rate multiply by the number of periods
1. 2/98 = 0.020408
2. 30-14 = 16 and 365/16 = 22.8125
3. 0.020408 x 22.8125 = 46.55%
Here is a narrative explanation.
Step 1 finds the % you allow out of the amount you will receive
Step 2 finds how many periods there are in a year
Step 3 mulitplies the % you allow (in this case for 16 days) so you can see how much this is equivalent to for a whole year.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
As you may be aware there are two assessments for Credit Management and Debt Control; Principles of credit management control (Part 1); and Credit management and debt control (Part 2).
I have copied out this question from Part 1.
A company's terms of payment are 28 days. It is offering a discount of 5% for payment within 14 days. Customer A owes £1,000.
Calculate the amount A will pay if they take advantage of the discount and also the simple annual interest rate of the discount.- £950 137.22%
- £950 37.22%
- £950 130.36%
- £950 30.36%
Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
I have ammended the question for the compound type question
A company's terms of payment are 28 days. It is offering a discount of 5% for payment within 14 days. Customer A owes £1,000.
Calculate the amount A will pay if they take advantage of the discount and also the compound annual interest rate of the discount.- £950 137.22%
- £950 180.87%
- £950 280.87%
- £950 380.87%
Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Another example
https://www.aat.org.uk/servlet/file/CMGT_CRMC_Study_Support_Unit_15_OCMC_Simulation_D2014.pdf?ITEM_ENT_ID=108467&download=1
Look at task 5 of the D2014 skills testSandy
sandy@sandyhood.com
www.sandyhood.com0 -
thanks for all your replys guys. I think i understand it now. i have just had to do a supplementary task from my September simulation and this was one of the questions.
also had to say what the difference was between public and private sector cash balances.
Hopefully i have done enough to pass this unit now.
Thanks again.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership