In: Accounting
In the spring of 2019, Patrick Egbunonu retired as the tennis pro of the Cataraqui Tennis Club, an exclusive indoor/outdoor club in Kingston, Ontario. A special committee of the board of directors was formed to find a replacement for the combined job of tennis pro and owner of the pro shop and bar lounge. Nine candidates had applied for the position, but the board’s first choice was John “The Racquet” Conrad. His qualifications and experience were excellent, and the committee believed his reputation as the two-time Canadian amateur tennis champion would enhance the status and prestige of the club.
After learning of the job offer, Conrad accepted immediately. He was excited about the opportunity to invest his hard-earned savings into a business he knew and loved. On July 1, 2019, Conrad incorporated the pro shop and bar lounge area and deposited $100,000 into the corporation’s bank account in exchange for common shares. Also, on that day, Conrad purchased an inventory of racquets, balls, clothes, shoes, and accessories (i.e. the pro shop inventory) valued at $16,340, liquor inventory valued at $13,660, $11,000 worth of fixtures and $4,000 of glassware. The business was to receive all sales from the pro shop and bar lounge and would pay part-time help to sell goods and serve drinks. The business uses a perpetual inventory system.
Conrad was an immediate success. He was readily accepted by all the members and was regarded as an asset to the club. Much of his time was spent instructing individuals while the better players anxiously awaited an opportunity to strike up a match with Conrad. Given his busy schedule, Conrad did not keep a close watch on his accounting records. He did, however, attempt to keep an accurate cash record and decided not to worry about the rest until fiscal year-end.
On June 30, 2020, Conrad began to examine his records and notes. His cash records revealed the following:
Receipts | |
Pro shop sales | $53,700 |
Match fees | 22,650 |
Instruction (lesson) fees | 45,600 |
Liquor sales | 64,550 |
Other revenue | 3,050 |
Total | $189,550 |
Cash Records Continued:
Payments | |
Rent of pro shop and lounge1 | $19,500 |
New lounge fixtures (purchased June 1, 2020) | 8,400 |
Pro shop goods for resale2 | 26,650 |
Liquor for resale3 | 14,400 |
Shop assistant wages | 24,000 |
Wait staff wages | 27,500 |
John Conrad’s salary | 52,000 |
Total | $172,450 |
1 Conrad was required to pay rent to the club in the amount of $1,500 per month for use of the space.
2 Does not include payment made on July 1, 2019, for initial pro shop inventory
3 Does not include payment made on July 1, 2019, for initial liquor inventory
Conrad was sure his bank account was correct, but he did not know what else he should record. He went to Michelle Paquin, a local chartered professional accountant (CPA) and club member, to ask for help.
Paquin began by examining the chequebook, invoices, and other records Conrad had accumulated in a shoe box. She found two outstanding bills: one for additional lounge fixtures of $4,200 (purchased on June 1, 2020) and a $2,000 invoice for the purchase of pro shop goods for resale (purchased on June 18, 2020), due in 30 days. (These items are not included in the above payments list)
On June 30, 2020, Conrad had 11 racquets in the shop, waiting to be restrung. Although he had done no work on the racquets and had not collected any money from customers, his normal rate for restringing was $175 per racquet, including materials.
The members purchased liquor “chit books” or vouchers in the pro shop for use in the bar lounge. Although the chit book cash receipts of $64,550 were noted, $650 of the chits had not been used as of June 30. These amounts could be carried over to the following year.
The fixtures purchased on July 1, 2019, had an estimated useful life of five years, whereas the new fixtures would last an estimated eight years. Due to frequent breakage, glassware had a much shorter useful life of two years. These assets would be depreciated using the straight-line method with no residual value.
During the year, Conrad instructed 606 sets of lessons for $100 per set. He had also played 155 matches with members, charging $150 per match. Conrad had not yet received payment for four of those matches. Davis felt that the social pressures among the club’s memberships would ensure full payment for all debts owed.
On June 30, 2020, Davis helped Conrad take a physical inventory count and found that there was $17,880 worth of pro shop inventory and $11,920 worth of liquor inventory.
Income taxes are calculated at a rate of 30 per cent of net income before tax.
REQUIRED:
1. Journalize all transactions and year-end adjusting entries for the year ending June 30, 2020. Explanations and dates are not required, but please show calculations where applicable and leave two lines between each journal entry. You can number each journal entry instead of dating them – just to keep it simple!
Organize your entries as follows (as a suggestion): • Transactions that occurred during the year (number these as T1, T2, etc....) • Year-end adjusting entries (number these as YE1, YE2, etc...)
2. Post the entries from requirement (1) to the applicable General Ledger accounts.
3. Prepare a worksheet to verify the accuracy of the net income. Check figure: net income before tax should be $35,419. Do not forget to record the income tax expense and income tax payable @ 30% of this amount, thereby resulting in a net income after tax in the amount of $24,793.
4. Prepare an income statement and a statement of retained earnings for the year ended June 30, 2020.
5. Prepare a classified balance sheet as at June 30, 2020.
6. Journalize and post the year-end closing entries to the applicable General Ledger accounts. Explanations and dates are not required, but please show calculations where applicable and leave two lines between each journal entry. You can number each journal entry instead of dating them – just to keep it simple! Organize your entries as follows (as a suggestion): • Closing entries (number these as C1, C2, etc...)
S.No | Particulars | Dr (in $) | Cr (in $) |
1 | Bank A/C …Dr | 1,00,000 | |
To Equity Share Capital A/C | 1,00,000 | ||
2 | Invetory (Sports Equipments) A/C …dr | 16,340 | |
Invetory (Alcohol) A/C …dr | 13,660 | ||
Fixtures A/C | 11,000 | ||
Inventory (Glassware) A/C | 4,000 | ||
To Bank A/C | 45,000 | ||
3 | Bank A/C …Dr | 1,86,500 | |
To Shop Sales A/C | 53,700 | ||
To Match Fee A/C | 22,650 | ||
To Lessons Fee A/C | 45,600 | ||
To Liquor Sales A/C | 64,550 | ||
4 | Bank A/C …dr | 3,050 | |
To Miscellaneous Income A/C | 3,050 | ||
5 | Rent A/C …Dr | 19,500 | |
Fixtures A/C …Dr | 8,400 | ||
Shop Resales A/C …Dr | 26,650 | ||
Liquor Resales A/C …Dr | 14,400 | ||
Shop Assistant Wages A/C …Dr | 24,000 | ||
Wait Staff Wages A/C …Dr | 27,500 | ||
John's Salary A/X …Dr | 52,000 | ||
To Bank A/C | 1,72,450 | ||
YE1 | Fixtures A/C …Dr | 4,200 | |
Shop Resale A/C …Dr | 2,000 | ||
To Outstanding Expenses | 6,200 | ||
YE2 | Advance Rent A/C …Dr | 1,500 | |
To Rent A/C | 1,500 | ||
YE3 | Depreciation A/C …Dr | 5,250 | |
To Old fixtures A/C | 2,200 | ||
To New fixtures A/C | 1,050 | ||
To Glassware A/C | 2,000 | ||
YE4 | Debtors A/C …Dr | 21,000 | |
To Match Fee A/C | 600 | ||
To Lessons Fee A/C | 15,000 | ||
YE5 | Income Tax A/C …Dr | 10,626 | |
To Bank A/C | 10,626 |
Note:
It is asumed there is no reasonable certainity towards earning income on rewiring of racquets, hence no entry has been made.
No entry for $650 made on unearned chit pads.
Depreciation on new fixtures has been calculated for accounted and accounted fixtures ($8,400 and $4,200)