26 Aging of AR

docx

School

Wisconsin Indianhead Technical College *

*We aren’t endorsed by this school

Course

22894

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by DoctorRaccoon2667

Report
Principles of Finance Accounts Receivable Management Aging of Accounts Receivable 28/28 Name: _________Alissa Mack____________________ 1. An aging of accounts receivable report is a summary of all amounts due. It tells you at a glance: Which client owes you money How much money they owe How much of their account balances are past due This report should be created monthly. Please create an accounts receivable aging report based on the following customer information and assuming today is March 13. Terms are 2 10 net 30. Please remember, customers who don’t pay in 30 days will be charged interest. Customer Invoice Date Amount Due Days In the Pen Co. March 10 $1,000 3 Technocolor Co. March 7 $4,000 6 Crayola Co. Feb 9 $1,500 32 In the Pen Co. Feb 5 $1,000 36 Technocolor Co. Jan 31 $500 41 Dutiful Co. Jan 2 $2,000 70 Sing Co. Jan 1 $2,000 71 Crayola Co. Dec 30 $1,500 73 In the Pen Co. Dec 28 $1,000 75 Technocolor Co. Dec 27 $500 76 Dutiful Co. Dec 5 $3,000 98 Sing Co. Dec 4 $2,000 99 1
Assignment: Complete the accounts receivable aging report below listing the customer with the largest outstanding balance first on the report : 11pts Aging of Accounts Receivable Collegiate Accounting Services 1900 College Drive Rice Lake, WI 54868 March 13, 200X Customer Total Due 0-30 Current 31-60 Days 61-90 Days 91-120 Days % Not Current Dutiful 5,000 2,000 3,000 100% Technocolor 5,000 4,000 500 500 20% Sing 4,000 2,000 2,000 100% Crayola 3,000 1,500 1,500 100% In The Pen 3,000 1,000 1,000 1,000 66.67% Column Totals 20,000 5,000 3,000 7,000 5,000 75% % of Total 100% 25% 15% 35% 25% 2
Questions 5 pts : 2. How does this aging of accounts receivable report help you spot problem accounts? It shows you by customer how much they owe and how much is late and within what days its late. 3. List below any customer whose entire account balance is over 60 days past due? Dutiful and Sing 4. What concerns would you have with customers whose account is over 60 days old? That they aren’t going to pay us. 5. Explain why Collegiate Accounting Services may want to stop extending credit to some of their customers If they stop lending credit to customers it will get the customers to pay. 6. Describe three ways Collegiate Accounting Services can try to get their past due customers to pay faster or to pay their outstanding amounts due Contact the customers by phone Charge an interest fee for being late Send the customers to collections 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7. Swenson Electric Company sells on terms of “net 30”. Given the following information on its receivables, complete the aging of accounts schedule below as of September 1, showing the percentage of accounts that are current, 1 to 30 days past due, 31 to 60 days past due, 61 to 90 days past due, and over 90 days past due. (Assume 30 days in each month) Account Number Invoice Date Amount Due Days 1311 August 15 $1315 17 1773 July 14 721 49 1217 July 25 677 38 1319 August 14 1711 18 1814 April 10 325 144 1713 August 5 917 27 1443 May 8 493 116 1144 June 28 211 65 1972 May 5 755 119 1011 April 21 377 133 1619 August 28 1550 4 1322 August 13 275 19 1173 March 5 675 180 1856 August 12 695 20 1317 June 10 720 83 Fill in the table below for this problem 12 pts Current 1-30 Past Due 31-60 Past Due 61-90 Past Due 90+ Past Due Total 0-30 31-60 61-90 91-120 120+ $6,463 $1,398 $931 $1,248 $1,377 $11,417 56.61% 12.24% 8.15% 10.93% 12.06% 100% 8. Give your opinion on the following: Should you allow any customers to take discounts past the discount period (i.e. terms 2/10 n 30 and customer takes discount but pays on day 27)? 2 pts No, I would not let them take the discount after the discount date. It is a discount period for a reason, you have an expected amount of discounts if you allowed them to get a discount after the period you’d be going over your expected amount of discounts. 4