Make Sure You Bill Them
What a way to start your Monday morning! With dread you face a great stack of envelopes in your in-basket. The first envelope contains an invoice from your major supplier indicating an outstanding balance of $3,600 with terms of 2/10, 1/20, net 30. In the second envelope, an office supplies bill totals $500 with terms of 3/15, net 45 EOM. The third envelope holds yet another invoice from your transportation company indicating an outstanding balance of $21,000 with terms of 2/15, 1/25, net 60 ROG. It also indicates that you have an overdue balance of $4,000 subject to a 3% monthly penalty. Before opening any more envelopes that probably contain still more bills, you pour yourself another cup of coffee and settle down to figuring out how much you need to pay and when.
In the world of business, most purchases are not paid for in cash. Instead, businesses tend to work through an invoicing system in which they send out bills to their clients on a regular basis. In accounting, this means that the purchase is placed into accounts receivables until such time as a cheque arrives and the purchase is converted to cash. Invoices provide detailed transaction information, listing the amount owed and also indicating the terms on which payment is expected. Companies may offer what are known as cash discounts as incentives for early invoice payment. The rationale for these discounts is simple—a sale is not a sale until you have the cash in hand. The longer an invoice remains in accounts receivable, the less likely that it will be paid. Thus, it might turn into bad debt, which the creditor cannot collect at all.
Invoicing is less common in consumer purchases because of the sheer volume of transactions involved and the higher risk of nonpayment. Imagine purchasing items at Walmart and receiving an invoice to pay your bill next month instead of paying cash. It is hard to fathom the number of invoices Walmart would have to distribute monthly. How much would it cost to collect those debts? How many of those invoices would go unpaid? That is why consumer purchases typically do not involve invoicing.
Invoicing does commonly occur at a consumer level on credit card transactions along with many services where the business may not be able to assess the exact amount of the bill at the time of the transaction or until the service is delivered.
Two examples illustrate this point:
- Think of your MasterCard bill. You are able to make purchases, say, from March 9 to April 8. Then on April 9 the company sends out a statement saying you have until April 29 to pay your bill. If you do not, interest and late payment penalties are involved.
- You have a dental visit for a regular cleaning. Before charging you, the dentist’s office needs to determine how much your insurance will cover. It may not find out the answer for a day or two, so it sends you an invoice at a later date once it hears from the insurance company. The invoice terms indicate that payment is due upon receipt and you will incur late penalties if payment is not forthcoming.
This section explores the most common aspects of invoicing, including terms of payments and cash discounts. You will learn to calculate the amount required to pay invoices and how to reduce the outstanding balance of an invoice if a partial payment is received. Additionally, the calculation of late payments and penalties is introduced.
Invoice Terms and Invoice Dating
You must know how to read a business invoice. The figure on the next page provides a sample invoice and highlights the following areas:
- Invoicing Company. The invoice must identify who is sending and issuing the invoice.
- Invoice Date. The date on which the invoice was printed, along with the invoice tracking number (in this case, the order date and shipping date are equivalent to the invoice date). When an invoice is paid, the cheque must reference the invoice number so that the invoicing company can identify which invoice to credit the payment to.
- Transaction Details. The details of the transaction might include number of units, unit prices, and any discounts for which the item is eligible.
- Invoice Total. The total amount owing is indicated, including any taxes or additional charges.
- Terms of Payment. The terms of payment include any cash discounts and due dates. The date of commencement (as discussed below) is determined from this part of the invoice.
- Late Penalty. A penalty, if any, for late payments is indicated on the invoice. Whether or not a company enforces these late penalties is up to the invoice-issuing organization.
Three Dates of Commencement
All invoice terms are affected by what is known as thedate of commencement, which is the first day from which all due dates stated on the invoice will stem. The date of commencement is determined in one of three ways as illustrated below.
Ordinary Invoice Dating.
In ordinary invoice dating, or just invoice dating for short, the date of commencement is the same date as the invoice date. Therefore, if the invoice is printed on March 19, then all terms of payment commence on March 19. This is the default manner in which most companies issue their invoices, so if an invoice does not specify any other date of commencement you can safely assume it is using ordinary dating.
End-of -Month Invoice Dating.
End-of -month invoice dating applies when the terms of payment include the wording “end-of -month” or the abbreviation “EOM” appears after the terms of payment. In end-of -month dating, the date of commencement is the last day of the same month as indicated by the invoice date. Therefore, if the invoice is printed on March 19, then all terms of payment commence on the last day of March, or March 31. Many companies use this method of dating to simplify and standardize all of their due dates, in that if the date of commencement is the same forall invoices, then any terms of payment will also share the same dates.
Receipt-Of-Goods Invoice Dating.
Receipt-of-goods invoice dating applies when the terms of payment include the wording “receipt-of -goods” or the abbreviation “ROG” appears after the terms of payment. In receipt-of -goods dating, the date of commencement is the day on which the customer physically receives the goods. Therefore, if the invoice is printed on March 19 but the goods are not physically received until April 6, then all terms of payment commence on April 6. Companies with long shipping times involved in product distribution or long lead times in production commonly use this method of dating.
Terms of Payment
The most common format for the terms of paying an invoice is shown on the next page and illustrated by an example.
The figure below plots the invoice term of “3/10, net 30” along a time diagram to illustrate the terms of payment. This term is combined with various dates of commencement using the examples from the “Date of Commencement” section.
Note the following observations:
- In all four scenarios, the total length of all bars is the same, since the credit period is 30 days.
- Although all four invoices have the same invoice date of March 19, the date of commencement is modified in the ROG and EOM scenarios, which shift the discount and credit periods into the future. In these cases, any payment before the end of the discount period qualifies for the discount. For example, in the EOM scenario a company could pay its bill early on March 27 and qualify for the 3% cash discount.
You may see invoice terms displayed in several other common formats:
- 3/10, n/30: In this case, the word “net” has been abbreviated to “n/”. This is illustrated in the fourth scenario in the figure.
- 3/10, 2/20, n/30. In this case, multiple cash discounts are being offered, meaning 3% within 10 days from the date of commencement and 2% from the 11th to the 20th day from the date of commencement. This is also illustrated in the fourth scenario of the figure.
- n/30. In this case, no cash discount is offered and only the credit period is identified.
Rules for Invoice Terms
Some common business practices are implemented across most industries. Note that you must always check with the invoicing organization to ensure it is applying these practices.
No Net Figure
If no net figure is stated in the terms of payment, you should assume that the credit period is 20 days after the last discount period. If there are no discount periods, then the credit period is 20 days from the date of commencement. For example, “3/10, 2/15” means that the credit period ends 20 days after the second discount period of 15 days. Hence, the credit period is 35 days after the date of commencement.
No Cash Discount
Not every invoice receives a cash discount. If no terms indicate a cash discount, then the invoicing company seeks full payment only. For example, “n/30” means that no cash discount applies and the credit period ends 30 days from the date of commencement.
Most businesses operate Monday through Friday and are closed on weekends and holidays. As such, any date falling on a nonworking day is moved to the next business day. For example, if an invoice is ordinary dated December 21 and lists a cash discount of 2/10, the end of the discount period falls on January 1. Since this is New Year’s Day, the discount period extends to January 2. In this textbook, you should apply this practice to any of the five known statutory holidays discussed in Chapter 4 (New Year’s Day, Good Friday or Easter Monday in Quebec only, Canada Day, Labour Day, and Christmas Day).
Three Types of Payments
When businesses pay invoices, three situations can occur:
A full payment means that the company wants to pay its invoice in full and reduce its balance owing to zero dollars. This is the most common practice.
A partial payment means that the company wants to lower its balance owing but will not reduce that balance to zero. A company will generally employ this method when it wants to either lower its accounts payable or demonstrate good faith in paying its invoices. Partial payment may also occur if the company wants to take advantage of a cash discount but lacks the funds to clear the invoice in its entirety.
A late payment occurs when the company pays its invoice either in full or partially after the credit period has elapsed. Late payments occur for a variety of reasons, but the most common are either insufficient funds to pay the invoice or a simple administrative oversight.
The rest of this section shows you how to handle each of these types of payments mathematically, and it also explores the implications of cash discounts.
Give It Some Thought
In each of the following cases, determine which term of payment results in the longest credit period extending from the invoice date.
- 2/10, n/30 or 3/15
- 3/15, n/45 or 2/10, 1/20
- 2/10, n/60 or 3/10, n/30 EOM on an invoice dated January 7
- 3/15, n/45 or 2/10, n/35 ROG, or 2/20 EOM on an invoice dated September 22 and goods received on September 29
- 30 days or 35 days
- 45 days or 40 days
- 60 days or 54 days (24 days left in January plus 30 more)
- 45 days or 42 days (7 days until received plus 35) or 48 days (8 left in month plus 40 more
In the opening scenario in this section, the first invoice on your desk was for $3,600 with terms of 2/10, 1/20, net 30. Suppose that invoice was dated March 19. If you wanted to take advantage of the 2% cash discount, when is the last day that payment could be received, and in what amount would you need to write the cheque? In this section, we will look at how to clear an invoice in its entirety.
The good news is that a cash discount is just another type of discount similar to what you encountered in Section 6.1,and you do the calculations using the exact same formula. Apply Formula 6.1 on single discounts, which is reprinted below.
How It Works
Follow these steps when working with payments and invoices:
Step 1: Look for and identify key information such as the invoice date, date of commencement modifiers such as EOM or ROG, terms of payment, late penalty, and the invoice amount.
Step 2: Draw a timeline similar to the figure on the next page. On this timeline, chronologically arrange from left to right the invoice date and amount, the date of commencement, the end of any discount (if any) or credit periods, cash discounts (if any) that are being offered, and penalties (if any).
Step 3: Determine when payments are being made and in what amount. Locate them on the timeline.
Step 4: Apply the correct calculations for the payment, depending on whether the payment is a full payment, partial payment, or late payment.
Let’s continue with the example of the first invoice on your desk. You mail in a cheque to be received by March 29. What amount is the cheque?
Step 1: The invoice amount is L = $3,600, invoice date is March 19, and terms of payment are 2/10, 1/20, net 30.
Step 2: The figure on the next page displays the invoice timeline.
Step 3: Note on the timeline that a payment on March 29 is the last day of the 2% discount period.
Step 4: According to Formula 6.1, the amount to pay is N = $3,600 × (1 – 0.02) = $3,600 × .098 = $3,528. A cheque for $3,528 pays your invoice in full. By taking advantage of the cash discount, you reduce your payment by $72.
Things To Watch Out For
If there is one area of invoicing that causes the most confusion, it is assigning information to the net price and invoice amount variables. These are commonly assigned backwards. Remember these rules so that you always get the correct answer:
- The invoice amount or any reference to the balance owing on an invoice is always a list price.
List Price = Invoice Amount
- The payment of an invoice, whether in full, partial, or late, is always a net price.
Net Price = Payment Amount
Paths To Success
Who cares about 1% or 2% discounts when paying bills? While these percentages may not sound like a lot, remember that these discounts occur over a very short time frame. For example, assume you just received an invoice for $102.04 with terms of 2/10, n/30. When taking advantage of the 2% cash discount, you must pay the bill 20 days early, resulting in a $100 payment. That is a $2.04 savings over the course of 20 days. To understand the significance of that discount, imagine that you had $100 sitting in a savings account at your bank. Your savings account must have a balance of $102.04 twenty days later. This requires your savings account to earn an annual interest rate of 44.56%! Therefore, a 20-day 2% discount is the same thing as earning interest at 44.56%. Outrageously good!
Give It Some Thought
In each of the following cases, determine the cash discount or penalty for which the payment qualifies.
|Question||Invoice Date||Terms of Payment||Payment Received On|
|1.||April 14||2/10, n /30||April 24|
|2.||July 7||3/10, 2/20, n/30 EOM, 1% per month penalty||August 12|
|3.||November 12 (goods received November 28)||2/20 ROG, 2% per month penalty||December 29|
|4.||February 27 (non-leap year)||4/10, 2/15, 1/25 EOM||March 25|
2. 2% discount
3. no discount (0%) or penalty
4. 1% discount
Example 7.4A: Paying Your Bills in Full
You receive an invoice for $35,545.50 dated August 14. The terms of payment are listed as 3/10, 2/20, net 45 EOM. The accounting department is considering paying this debt on one of three days. Determine the full payment required if payment is received by the invoicing company on each of the following dates:
- September 3
- September 19
- September 30
In each case, calculate the full payment (N) after applying any cash discount.
What You Already Know
Step 1: The invoice amount, terms of payment, and any payments are known:
- L = $35,545.50
- Invoice date = August 14
- Terms of payment = 3/10, 2/20, net 45 EOM
- Three payment date options are September 3, September 19, and September 30.
- Steps 2 & 3: The figure below illustrates the timeline for the invoice and identification of payments.
How You Will Get There
Step 4: Calculate the payment required by applying Formula 6.1. As noted on the timeline:
- The first payment option qualifies for d = 3%.
- The second payment option qualifies for d = 2%.
- The third payment option qualifies for d = 0% (no cash discount).
- N = $35,545.50 × (1− 0.03) = $35,545.50 × 0.97 = $34,479.14
- N = $35,545.50 × (1 – 0.02) = $35,545.50 × 0.98 = $34,834.59
- N = $35,545.50 × (1 − 0) = $35,545.50 × 1 = $35,545.50
(Note that since there is no discount in part (c), you could have concluded tha N = L)
If the invoicing company receives payment on September 3, a 3% discount is allowed and $34,479.14 clears the invoice. If the payment is received on September 19, a 2% discount is allowed and $34,834.59 pays it off. Finally, if the payment arrives on September 30, there is no discount so the full invoice amount of $35,545.50 is due.
In the section opener, your third invoice is for $21,000 with terms of 2/15, 1/25, net 60 ROG. After you paid the $3,528 to clear the first invoice, you realize that your company has insufficient funds to take full advantage of the 2% cash discount being offered by the transportation company. Not wanting to lose out entirely, you decide to submit a partial payment of $10,000 before the first discount period elapses. What is the balance remaining on the invoice?
Unless you pay attention to invoicing concepts, it is easy to get confused. Perhaps you think that $10,000 should be removed from the $21,000 invoice total, thereby leaving a balance owing of $11,000. Or maybe you think the payment should receive the discount of 2%, which would be $200. Are you credited with $9,800 off of your balance? Or maybe $10,200 off of your balance? In all of these scenarios, you would be committing a serious mistake and miscalculating your balance owing. Let’s look at the correct way of handling this payment.
Recall that invoice amounts are gross amounts (amounts before discounts), or G, and that payment amounts are net amounts (amounts after discounts), or N. Also recall that an algebraic equation requires all terms to be expressed in the same unit.
In the case of invoice payments, you can think of the balance owing as being in the unit of “pre-discount” and any payment being in the unit of “post-discount.” Therefore, a payment cannot be directly deducted from the invoice balance since it is in the wrong unit. You must convert the payment from a “post-discount” amount into a “pre-discount” amount using a rearranged version of Formula 6.1. You can then deduct it from the invoice total to calculate any balance remaining.
How It Works
Follow the same invoice payment steps even when working with partial payments. Commonly, once you calculate the gross amount of the payment in step 4 you will also have to calculate the new invoice balance by deducting the gross payment amount. Let’s continue working with the $21,000 invoice with terms of 2/15, 1/25, net 60 ROG. Assume the invoice is dated March 19 and the goods are received on April 6. If a $10,000 payment is made on April 21, what balance remains on the invoice?
Step 1: The invoice amount is $21,000, the invoice date is March 19, goods are received on April 6, and the terms of payment are 2/15, 1/25, net 60. A payment of $10,000 is made on April 21.
Step 2: The figure below shows the invoice timeline.
Step 3: The payment of $10,000 on April 21 falls at the end of the first discount period and qualifies for a 2% discount.
Step 4: To credit the invoice, apply the rearranged Formula 6.1:
This means that before any cash discounts, the payment is worth $10,204.08 toward the invoice total. The balance remaining is:
In the case where a payment falls within a cash discount period, the amount credited toward an invoice total is always larger than the actual payment amount. If the payment does not fall within any discount period, then the amount credited toward an invoice total is equal to the actual payment amount (since there is no cash discount).
To help you understand why a partial payment works in this manner, assume an invoice is received in the amount of $103.09 and the customer pays the invoice in full during a 3% cash discount period. What amount is paid? The answer is N = $103.09(100% − 3%) = $100. Therefore, any payment of $100 made during a 3% cash discount period is always equivalent to a pre-discount invoice credit of $103.09. If the balance owing is more than $103.09, that does not change the fact that the $100 payment during the discount period is worth $103.09 toward the invoice balance.
Give It Some Thought
In each of the following situations, determine for the partial payment whether you would credit the invoice for an amount that is larger than, equal to, or less than the partial payment amount.
- An invoice dated April 7 with terms 4/20, 2/20, n/60 EOM. The goods are received on April 9 and a partial payment is made on May 21.
- An invoice dated July 26 with terms 3/30, n/45 ROG. The goods are received on August 2 and a partial payment is made on September 3.
- An invoice dated January 3 with terms 2½/10, 1/20. The goods are received on January 10 and a partial payment is made on January 24.
2. Since the payment does not fall within a discount period, the credited amount is equal to the payment.
3. Since the payment falls within a discount period, the credited amount is larger than the payments
Example 7.4B: Applying Your Partial Payments toward Your Balance Owing
Heri just received an invoice from his supplier, R&B Foods. The invoice totalling $68,435.27 is dated June 5 with terms of 2½/10, 1/25, n/45. Heri sent two partial payments in the amounts of $20,000 and $30,000 that R&B Foods received on June 15 and June 29, respectively. He wants to clear his invoice by making a final payment to be received by R&B Foods on July 18. What is the amount of the final payment?
Determine the amount of the final payment (N) after the first two partial payments are credited toward the invoice total. To credit the two partial payments you must find the list amount before any cash discounts (L) such that the payment can be deducted from the invoice total.
What You Already Know
Step 1: The invoice amount, terms of payment, and payment amounts are known:
- L = $68,435.27 Invoice date = June 5
- Terms of payment = 2½/10, 1/25, n/45
- N1 = $20,000 on June 15
- N2 = $30,000 on June 29
- N3 = ? on July 18
Steps 2 & 3:The figure illustrates the timeline for the invoice and identifies the payments.
How You Will Get There
Step 4: The first two payments are partial. Apply the rearranged Formula 6.1. As noted on the timeline:
- The first partial payment qualifies for d = 2½%.
- The second partial payment qualifies for d = 1%.
- The last payment is a full payment, where d = 0%
(no cash discount).
|Balance Owing = $68,435.27 − $20,512.82 = $47,922.45|
|Balance Owing = $47,922.45 − $30,303.03 = $17,619.42|
|c.||Since there is no cash discount, N3 = L. The balance owing is L = $17,619.42.|
|Therefore, the payment is the same number and N3 = $17,619.42.|
The first two payments receive a credit of $20,512.82 and $30,303.03 toward the invoice total, respectively. This leaves a balance on the invoice of $17,619.42. Since the final payment is made during the credit period, but not within any cash discount period, the final payment is the exact amount of the balance owing and equals $17,619.42.
Late Payment Penalties
Among all of the invoices that you were paying in the section opener, you realize upon opening that third envelope that you somehow missed an invoice last month and failed to pay the $4,000 owing, which is now overdue. In looking at the invoice, you notice that it states on the bottom that late payments are subject to a 3% per month penalty. You urgently want to pay this invoice to maintain good relations with your supplier but wonder in what amount you must issue the cheque?
Why Do Late Penalties Exist?
Suppliers are doing their business customers a favour when they use invoicing to seek payment. In essence, suppliers provide the products to the customer but are not paid for those products up front. This means customers are granted a period during which they “borrow” the products for free without any associated interest costs that are usually tied to borrowing. If the invoice is not paid in full by the time the credit period elapses, then the supplier starts treating any remaining balance like a loan and charges interest, which is called a late payment penalty.
When a payment arrives after the credit period has expired, you need to adjust the balance of the invoice upward to account for the penalty. Continue to use Formula 6.1 on Single Discounts for this calculation. In this unique case, the discount rate represents a penalty. Instead of deducting money from the balance, you add a penalty to the balance. As a result, the late penalty is a negative discount. For example, if the penalty is 3% then d= −3%.
How It Works
Follow the same steps to solve the invoice payment once again when working with late payments. As an example, work with the $4,000 overdue invoice that is subject to a 3% per month late penalty. If the invoice is paid within the first month of being overdue, what payment is made?Step 1: The invoice balance is L = $4,000, and the penalty percent is d= −0.03.
Steps 2 & 3: Since the focus is strictly on the late payment calculation, you do not need a timeline for the discount or credit periods. The late payment occurs within the first month past the expiry of the credit period.Step 4: To determine the new invoice balance, apply Formula 6.1 to calculate N = $4,000 × (1 − (−0.03)) = $4,000 × 1.03 = $4,120. Therefore, to clear the invoice you must issue a cheque in the amount of $4,120. This covers the $4,000 owing along with a late penalty of $120.
Not all invoices have penalties, nor are they always enforced by the supplier. There are many reasons for this:
- Most businesses pay their invoices in a timely manner, which minimizes the need to institute penalties.
- Waiving a penalty maintains good customer relations and reinforces a positive, cooperative business partnership.
- Strict application of late penalties results in difficult situations. For example, if a payment was dropped in the mail on August 13 from your best customer and it arrives one day after the credit period expires on August 15, do you penalize that customer? Is it worth the hassle or the risk of upsetting the customer?
- The application of late penalties generally involves smaller sums of money that incur many administrative costs. The financial gains from applying penalties may be completely wiped out by the administrative expenses incurred.
- Businesses have other means at their disposal for dealing with delinquent accounts. For example, if a customer regularly pays its invoices in an untimely manner, the supplier may just to decide to withdraw the privilege of invoicing and have the customer always pay up front instead.In this textbook, all penalties are strictly and rigidly applied. If a payment is late, the invoice balance has the appropriate late penalty applied.
Things To Watch Out For
When a late penalty is involved, you must resist the temptation to adjust the payment by the penalty percentage. The discussion and calculations in this section focus on adjusting the outstanding invoice balance to figure out the payment required. For example, assume there is a $500 outstanding balance subject to a 2% penalty.
- This means that with the penalty, the invoice total is $510, which determines that a payment of $510 is required.
- If the customer makes a $200 partial payment on this late debt, you cannot apply the partial payment procedure, which would give a credit of $204.08 for the payment, resulting in a balance owing of $295.92. If you make this mistake, you in fact reward the customer for being tardy!
- Nor can you deduct the 2% penalty from the payment and give credit for $200(1 – 0.02) = $196 (resulting in a balance owing of $304) because the 2% penalty applies to the whole invoice amount and not just the partial payment.
- Instead, the $200 payment must be deducted directly from the penalty-adjusted balance of $510. In this case, the customer still owes $310 to clear the invoice.
Paths To Success
An alternative method for applying a late penalty is to treat the penalty like a positive percent change (see Section 3.1). In this case, the penalty is how much you want to increase the balance owing.
Thus, if an invoice for $500 is subject to a 2% penalty, the ∆% = 2% and Old = $500.
The goal is to look for the New balance in Formula 3.1:
Example 7.4C: Whoops! I Missed the Due Date!
You received an invoice dated December 17 in the amount of $53,455.55 with terms of 4/15, 2/30, n/60 ROG, 2.75% penalty per month for late payments. The merchandise is received on January 24. You sent in a partial payment of $40,000
on January 31 with intention to pay the remaining balance before the credit period expired. However, you forgot about the invoice and realized your mistake on March 30, when you submit payment in full for the invoice. What amount is the final payment? (Note: Assume this is not a leap year)
The final payment must cover the invoice balance owing on any remaining balance after the partial payment is
credited and the outstanding balance is penalized as per the late penalty.
What You Already Know
Step 1: The invoice amount, terms of payment, and payment information are known:
- L = $53,455.55
- Invoice date = December 17
- Goods received = January 24
- Terms of payment = 4/15, 2/30, n/60 ROG,
- 2.75% penalty per month for late payments
- N1 = $40,000 on January 31
- N2 = ? on March 30
Steps 2 & 3: The figure below illustrates the timeline for the invoice and identifies the payments.
How You Will Get There
Step 4 (Partial Payment): Credit the partial payment during the discount period (d = 4%) by applying the rearranged Formula 6.1. Step 4 (New Invoice Balance): Deduct the partial payment from the invoice total.
Step 4 (Late Payment): The second payment occurs after the credit period elapses. Therefore the outstanding invoice balance is penalized by d = −0.0275 as per the policy. Apply Formula 6.1. This calculates the outstanding balance including the penalty, which
equals the final payment.
|Step 4||(New Invoice Balance): Balance Owing = $53,455.55 − $41,666.67 = $11,788.88|
|Step 4||(Late Payment): N = $11,788.88 × (1 − (−0.0275))|
|N = $11,788.88 × 1.0275 = $12,113.07.|
The first payment resulted in a $41,666.67 deduction from the invoice. The overdue remaining balance of $11,788.88 has a penalty of $324.19 added to it, resulting in a final clearing payment of $12,113.07
Round all money to two decimals and percentages to four decimals for each of the following exercises. In all questions, assume that the dates indicated are the dates upon which the payment is received.
For questions 1–3, calculate the full payment required on the payment date that reduces the balance on the invoice to zero. Assume this is not a leap year.
|Question||Invoice Amount||Invoice Date||Invoice Terms||Receipt of Goods||Date of Full Payment|
|1.||$136,294.57||January 14||2/10, n/30||January 10||January 22|
|2.||$98,482.75||September 14||3/10, 2/20, 1/30, n/50 EOM||October 3||October 19|
|3.||$48,190.38||February 21||February 27||April 3|
For questions 4–6, calculate the remaining invoice balance after crediting the invoice for the partial payments indicated.
|Question||Invoice Amount||Invoice Date||Invoice Terms||Receipt of Goods||Partial Payments and Dates|
|4.||$57,775.00||June 16||3/15, 1/2/25||June 12||$20,000 on July 2; $15,000 on July 10|
|5.||$1,200,310.75||August 25||3/10, 2/20, 1/30, n/50 EOM||September 2||$500,000 on September 4; $250,000 on September 14|
|6.||$17,481.68||December 3||4/10, 1/30, 1/40, n/60||December 20||$10,000 on January 2|
For questions 7–8, calculate the final payment required on the payment date that reduces the balance of the invoice to zero.
|Question||Invoice Amount||Invoice Date||Invoice Terms||Late Payment Penalty||Receipt of Goods Date||Partial Payment and Dates||Final Payment date|
|7.||$23,694.50||April13||3/15, 2/25, 1/40, n/60||1 1/2% per month||April 18||$10,000 on April 30||June 15|
|8.||$332,053.85||October 4||4/10 EOM||2% per month||October 30||$100,000 on November 5||December 15|
- Hudson’s Bay received an invoice dated July 13 from Nygard International in the amount of $206,731.75. The terms are 2/10, 1/20, n/30. If Nygard receives full payment on August 1, what amount is paid?
- Time Bomb Traders Inc. in Burnaby just received an invoice dated February 17 (of a leap year) from UrbanEars headphones in the amount of $36,448.50 with terms of 1½/15, ½/30, n/45 ROG. The items on the invoice are received on March 3. What amount is the full payment if UrbanEars receives it on March 18?
- Family Foods received an invoice dated July 2 from Kraft Canada in the amount of $13,002.96 with terms of 2/15, 1/30, n/45 EOM and a late penalty of 2% per month. What amount is paid in full if Kraft Canada receives a cheque from Family Foods on August 17?
- An invoice dated November 6 in the amount of $38,993.65 with terms of 2½/10, 1/15 ROG, 2% penalty per month is received by Cargill Limited from Agricore United. The wheat shipment is received on December 2. Cargill Limited made a partial payment of $15,000 on December 10. What amount should Cargill pay to clear its invoice on December 13?
- Yamaha Music received two invoices from the same vendor. The first is for $1,260 dated March 9 with terms 3/10, net 30. The second is for $2,450 dated March 12 with terms 2/10, 1/20, net 30. If a payment of $1,000 is made on March 19, what payment amount on March 31 settles both invoices? (Note: Payments are applied to the earlier invoice first.)
- An invoice is dated July 26 for $5,345.50 with terms of 3¼/10, net 45, 2½% per month penalty. If the invoice is paid on September 10, what payment amount is required to pay the entire balance owing?
- Mohawk College received an invoice dated August 20 from Office Depot for office supplies totalling $10,235.97 with terms of 3¾/15, 1½/30, n/45, EOM, 2¾% per month penalty. The college made three payments of $2,000 dated September 4, September 29, and October 10. What payment on October 25 settles the invoice?
Challenge, Critical Thinking, & Other Applications
- An invoice for $100,000 dated February 2 (of a non–leap year) with terms of 4/10, 3/20, 2/30, 1/40, net 60, ROG, 1¾% per month penalty. The merchandise is received on February 16. If four equal payments are made on February 20, March 17, April 1, and April 20 resulting in full payment of the invoice, calculate the amount of each payment.
- An accounting department receives the following invoices from the same vendor and makes the indicated payments. The vendor always applies payments to the earliest invoices first and its late payment policy stands at 1½% per month for any outstanding balance.
Invoice # Invoice Amount Invoice Date Invoice Terms Receipt of Goods Date 3866 $47,690.11 June 18 July 3 2928 $123,691.82 June 26 21/2/15 , 1/25 July 6 4133 $96,004.21 June 30 2/20, ROG July 7 6767 $16,927.50 July10 2/10, 1/20 July 11 Payment Received by Vendor on Payment Amount July 2 $40,000 July 11 $75,000 July 21 $100,000 July 30 $25,000
Calculate the amount of the final payment on August 17 that reduces the total balance owing to zero.
- John’s Home Hardware was invoiced on May 29 for the following non-taxable items with terms of 2/20, 1/40, 2% per month penalty.
If a partial payment of $20,000 is made on July 7, what payment amount on August 30 reduces the balance owing to zero? What is the total dollar amount of the late penalty?
Item Quantity Unit Price 2″ x 4″ x 8″ framing studs 13,000 $0.96 4″ x 4″ x 8′ fence posts 2,400 $2.87 2″ x 8″ x 16′ wood planks 480 $8.47 1″ x 6″ x 5′ fence boards 8,000 $1.22
- Your company receives a $138,175.00 invoice dated April 12 with terms of 4/10, 3/20, 2/30, 1/40, n/60. Due to the large amount, the accounting department proposes two different ways to pay this invoice, depending on company income and financing alternatives. These plans are listed in the table below.
Payment Date Plan #1 Plan #2 April 21 $35,000 $50,000 May 2 $20,000 $10,000 May 10 $25,000 $50,000 May 13 $30,000 $20,000 June 11 Balance Owing Balance Owing
- Which alternative do you recommend?
- If your recommendation is followed, how much money is saved over the other option?
- You receive an invoice dated July 29 with terms of 3/15, 1¾/30, n/50 EOM, 2% penalty per month. If the payments in the following table are made and you pay the invoice in full, what is the total invoice amount?
Payment Date Payment Amount August 4 $67,000.00 August 28 $83,000.00 September 28 $15,000.00 September 30 $83,297.16
Credit: Adapted from unit 7.4 in Business Math: A Step-by-Step Handbook
- Invoice provided by and courtesy of Kerry Mitchell Pharmacy Ltd. And Shoppers Drug Mart. ↵