For part 4 it asks for us to create an adjusted trial balance however, my numbers (Credit/Debit) do not match and I am not sure where I am going wrong... Any help would be appreciated!
Required information Great Adventures Problem AP3-1 (The following information applies to the questions displayed below.) Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering, and trail running. In the long run, they plan to sell outdoor gear and develop a ropes course for outdoor enthusiasts. On July 1, 2021, Tony and Suzie organize their new company as a corporation, Great Adventures Inc. The articles of incorporation state that the corporation will sell 39,000 shares of common stock for $1 each. Each share of stock represents a unit of ownership. Tony and Suzie will act as co-presidents of the company. The following transactions occur from July 1 through December 31. Jul. 1 Sell $19,500 of common stock to Suzie. Jul. 1 Sell $19,500 of common stock to Tony. Jul. 1 Purchase a one-year insurance policy for $5,400 ($450 per month) to cover injuries to participants during outdoor clinics. Jul. 2 Pay legal fees of $1,800 associated with incorporation. Jul. 4 Purchase office supplies of $1,400 on account. Jul. 7 Pay for advertising of $300 to a local newspaper for an upcoming mountain biking clinic to be held on July 15. Attendees will be charged $60 on the day of the clinic. Jul. 8 Purchase 10 mountain bikes, paying $12,600 cash. Jul. 15 On the day of the clinic, Great Adventures receives cash of $3,000 from 50 bikers. Tony conducts the mountain biking clinic. Jul. 22 Because of the success of the first mountain biking clinic, Tony holds another mountain biking clinic and the company receives $3,500. Jul. 24 Pay $800 to a local radio station for advertising to appear immediately. A kayaking clinic will be held on August 10, and attendees can pay $110 in advance or $160 on the day of the clinic. Jul. 30 Great Adventures receives cash of $6,600 in advance from 60 kayakers for the upcoming kayak clinic. Aug. 1 Great Adventures obtains a $31,000 low-interest loan for the company from the city council, which has recently passed an initiative encouraging business development related to outdoor activities. The loan is due in three years, and 6% annual interest is due each year on July 31. Aug. The company purchases 14 kayaks, paying $19,500 cash. Aug. 10 Twenty additional kayakers pay $3,200 ($160 each), in addition to the $6,600 that was paid in advance on July 30, on the day of the clinic. Tony conducts the first kayak clinic. Aug. 17 Tony conducts a second kayak clinic, and the company receives $10,800 cash. Aug. 24 Office supplies of $1,400 purchased on July 4 are paid in full. Sep. 1 To provide better storage of mountain bikes and kayaks when not in use, the company rents a storage shed for one year, paying $2,760 ($230 per month) in advance. Sep. 21 Tony conducts a rock-climbing clinic. The company receives $13, 200 cash. Oct. 17 Tony conducts an orienteering clinic. Participants practice how to understand a topographical map, read an altimeter, use a compass, and orient through heavily wooded areas. The company receives $18,900 cash. Dec. 1 Tony decides to hold the company's first adventure race on December 15. Four-person teams will race from checkpoint to checkpoint using a combination of mountain biking, kayaking, orienteering, trail running, and rock-climbing skills. The first team in each category to complete all checkpoints in order wins. The entry fee for each team is $540. Dec. 5 To help organize and promote the race, Tony hires his college roommate, Victor. Victor will be paid $30 in salary for each team that competes in the race. His salary will be paid after the race. Dec. 8 The company pays $1,300 to purchase a permit from a state park where the race will be held. The amount is recorded as a miscellaneous expense. Dec. 12 The company purchases racing supplies for $2,500 on account due in 30 days. Supplies include trophies for the top-finishing teams in each category, promotional shirts, snack foods and drinks for participants, and field markers to prepare the racecourse. Dec. 15 The company receives $21,600 cash from a total of forty teams, and the race is held. Dec. 16 The company pays Victor's salary of $1,200. Dec. 31 The company pays a dividend of $3,400 ($1,700 to Tony and $1,700 to Suzie). Dec. 31 Using his personal money, Tony purchases a diamond ring for $5,100. Tony surprises Suzie by proposing that they get married. Suzie accepts and they get married! The following information relates to year-end adjusting entries as of December 31, 2021. a. Depreciation of the mountain bikes purchased on July 8 and kayaks purchased on August 4 totals $7,500. b. Six months' of the one-year insurance policy purchased on July 1 has expired. c. Four months of the one-year rental agreement purchased on September 1 has expired. d. Of the $1,400 of office supplies purchased on July 4, $200 remains. e. Interest expense on the $31,000 loan obtained from the city council on August 1 should be recorded. f. Of the $2,500 of racing supplies purchased on December 12, $190 remains. g. Suzie calculates that the company owes $13,100 in income taxes.
4. Prepare an adjusted trial balance as of December 31, 2021. Credit 200 GREAT ADVENTURES, Inc. Adjusted Trial Balance December 31, 2021 Accounts Debit Cash $ 100,340 Prepaid Insurance 2,700 Prepaid Rent 1,840 Supplies (Office) Supplies (Racing) 190 Equipment (Bikes) 12,600 Equipment (Kayaks) 19,500 Accumulated Depreciation Accounts Payable Income Tax Payable Interest Payable Notes Payable Common Stock Dividends 3,400 Service Revenue (Clinic) Service Revenue (Racing) Advertising Expense 1,100 Depreciation Expense 7,500 Income Tax Expense 13,100 Insurance Expense 2,700 Interest Expense 775 Legal Fees Expense 1,800 Miscellaneous Expense 1,300 Rent Expense 920 Salries Expense 1,200 Supplies Expense (Office) 1,200 Supplies Expense (Racing) 2,310 Totals $ 174,675 7,500 2,500 13,100 775 31,000 39,000 55,700 21,600 $ 171,175