Based on the transactions, create a trial balance. Given the chart of accounts with some balances as of Feb. 28th.
1. 2. 3. 4. 5. 6. Billy Bob's Bikes Transactions March 1: Billy Bob purchased a building for $573,696 using $33,696 cash and then borrowing the rest from the bank. The loan from the bank will be paid off over the next 15 years (1/15 of the principal will be paid off at the end of each year). The loan carries an interest rate of 7.72% Interest accrued will be paid off at the end of every year. The building has an expected life of 24 years and will be depreciated using the straight-line method. March 1: Billy Bob paid in advance for a 10-month insurance policy, which will begin today. He paid $6,660 cash for the policy. March 2: Billy Bob purchased 14 bikes from Paul's Choppers. Each bike cost $6,300 and the credit terms are 3/10, 1/30 (Note: Bikes are considered Inventory) March 2: Paul's Choppers paid FedEx $5,083 cash to ship the bikes to Billy Bob March 3: Billy Bob hires Biker Betty for promotional purposes. He estimates her salary to be $12/hour. She will probably work 10 hours this month. March 5: Billy Bob sold & bikes to Bikes R' Us for $7,850 each with credit terms of 2/10, 1/30. The total cost of the bikes was figured out to be $50,400 7. March 6: Billy Bob paid UPS 54,516 cash to ship the bikes to Bikes R' Us. March 8: Stockholder's invest $175,075 into the company in exchange for Billy Bob's Bikes common stock. March 10: Billy Bob paid off the balance due from Paul's Choppers. 10. March 12: Billy Bob purchased 16 more bikes from Paul's Choppers. Each bike cost $6,225 and the credit terms are 1/20, 1/60 11. March 12: Billy Bob paid UPS S7,177 cash to ship the bikes he bought from Paul's Choppers. 12. March 14: Bikes R' Us paid their balance off for the bikes they purchased. 13. March 15: Billy Bob bought a Bike Making Machine for S407,100 using S47,100 cash and then borrowing the rest from the bank. The loan will be paid off over the next 3 years (1/3 of the principal will be paid at the end of each year). The loan carries an interest rate of 8.68 percent. Interest accrued will be paid off at the end of every year. The Bike Making Machine has an expected life of 11.5 years and will be depreciated using the straight-line method. 14. March 16: Billy Bob sold 9 bikes to Biker's Bargains for $7.900 each with credit terms of 2/10 EOM, 1/45. The cost of the bikes was determined to be $59,509. 15. March 16: Biker's Bargains paid FedEx $4,283 to have the bikes shipped to them. 16. March 18: Billy Bob purchased $3,099 worth of supplies from Olga's Office Supplies paying cash. 8. 9. 17. March 19: Billy Bob's pay period ends and he now owes his employees $5,304 in salaries. These salaries will be paid on March 25th. 18. March 20: Billy Bob returned 4 of the bikes he bought from Paul's Choppers. They credited $24,900 to his account. 19. March 21: Billy Bob's Bikes paid cash dividends of $5,555. 20. March 22: Billy Bob purchased 12 bikes from Carly's Cars. Each bike cost $5,999 and the credit terms are 2/10 EOM, n/90. 21. March 22: Billy Bob paid UPS $6,782 to have the bikes shipped to him. 22. March 23: Biker's Bargains returned two of the bikes they bought on March 16th because parts were falling off them. The cost of the bikes to Billy Bob was figured out to be $13,224. 23. March 25: Billy Bob paid his employees the $5,304 in salaries owed. 24. March 27: Billy Bob sells 18 bikes to Biker Chick's Chop Shop for $7,995 each with credit terms of 3/10, 1/30. The cost of the bikes was determined to be $114,611. 25. March 27: Billy Bob paid FedEx $6,521 to ship the bikes to Biker Chick's Chop Shop. 26. March 28: Biker's Bargains paid their balance off for the bikes they purchased. 27. March 29: Billy Bob paid a utilities bill in the amount of $1,894. 28. March 30: Billy Bob paid off the balance due from Paul's Choppers. Credit ner Account Title 4:18 PM Debit 1. Mar Building 5573,646.00 Cash $ 33.696.00 Bank loan payable $540,000.00 2 1-Mar Prepaid Insurance 5 6.660.00 Cash S6,660.00 3 2-Mar Inventory S 8.200.00 Accounts Payable S88.200.00 4 2.Mar No journal entry required s 5 3-Mar No journal entry required s S-Mar Accounts Receivable $ 62,800.00 Sales Revenue 562.500,00 6.b. 5. Mar Cost of Goods Sold S 50,400.00 Inventory $50,400,00 7 6-Mar Delivery Expense $ 4,516.00 Cash 54.516.00 8 8-Mar Cash $175.075.00 Common Stock $175,075.00 9 10- Mar Accounts Payable S 8.200.00 Inventory ( 88,200 x 3%) $ 2,646.00 Cash S $5.354.00 10 12-Mar Inventory $ 99,600.00 Accounts Payable 599.600.00 11 12. Mar Inventory $ 7.177.00 Cash $ 7.177.00 12 14. Mar Cash 5 61,544.00 Sales Discounts S 1.256.00 Accounts Receivable $ 62,00.00 13 15-Mar Bike Making Machine S407,100.00 Cash 5 47.100.00 Bank Loan Payable $360,000.00 16-Mar Accounts Receivable $ 71,100.00 Sales Revenue $ 71,100.00 14b 16-Mar Cost of Goods Sold $ 59,509.00 Inventory $ 59.509.00 15 16-Mar No journal entry required 16 18. Mar Supplies S 3.099.00 Cash $ 3,099.00 17 19. Mar Salaries $5,304.00 Salaries Payable $ 5.104.00 IR 20-Mar Purchase Retum S 34.900.00 Inventory $ 24,900.00 19 21- Mar Dividend S 5.555.00 Cash 55,555.00 20 22 Mar Inventory S 71.988.00 Accounts Payable 5 71.988.00 22. Marlentory $ 6,782.00 Cash 56,282.00 22 23-Mar Sales Retur S 13.224.00 Accounts Receivable $ 13.224.00 23 25-Mar Salaries Payable $5,304.00 Cash S 5.304.00 24 27-Mar Accounts Receivable $143.910.00 Sales Revenue $143.910.00 25 27-Mar Delivery Expense S 6,521.00 Cash $ 6.521.00 26 28-Mar Cash S 57.276.00 Accounts Receivable (71100-13224) S 57,876.00 27 29. Mar Utilities $ 1.894.00 Cash 5.194.00 28 30-Mar Accounts Payable 5 73,704.00 Cash (62251699-24900) $ 73,704.00
