(Note: You can do this problem only if you have access to a computerbased electronic spreadsheet, such as Excel, or to a database software package, such as Access.)

Problem Data

Cycleocity, Inc. is a wholesaler of bicycles and bicycle parts. It sells on credit terms of net 30 days. As of June 30, 20XX, its subsidiary ledger of customer balances reflects the following details:

Using the computer electronic spreadsheet or database software indicated by your instructor, prepare an accounts receivable aging report as of June 30, 20XX. Observe the following specific requirements:

a. In addition to a report heading, the report should contain column headings for: Customer name Total balance

Current balance and past-due balance, with supporting columns for 1 to 30 days, 31 to 60 days, 61 to 90 days, over 90 days

Continue to post