can you help me create the tables for the following: Income statement, stockholders equity, balance sheet and adjusted trial balance! thats all i need help on!

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 30,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 through December 31 Jul. Sell $15,000 of common stock to Suste Jl. 1 Sell 515,000 of common stock to Tony. Jul I Purchase a one-year insurance policy for 54,6805390 per month) to cover injuries to participants during outdoor clinice Jul 2Pay legal fees of $1.600 sociated with incorporation. Jul. Purchase office supplies of $1,700 cc. Jul. 7 Pay for advertising of $220 to a local newspaper for an upcoming mountain biking clinic to be held on July 15. Attendees will be charged 560 on the day of the elinie, Jul. Purebase 10 mountain bikes, paying $19.200 cash Jl. 15 on the day of the elinie, Crest Adventures receives each of $4,200 ron 70 bikers. Tony conduct the mountain biking elinie Jul 22 Because of the success of the first mountain biking elinie, Tony holds another mountain biking elinie and the company receives 54,200 Jul 24 ay 1690 to 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 9160 on the day of the cline. Jul 30 Great Adventures receives cash of $5,500 in advance from 50 kayakers for the upcoming kayak elinie. As 1 Great Adventures obtain a $32,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 annual interest is due each year on July The company purchases 14 kayake, paying $11,000 cash No. 10 Twenty additional kayakare pay $3,200 $160 each), in addition to the $5,500 that was paid in advance on July 10, on the day of the elinie. Tony conducta the first kayak elinie. g. 17 Tony conduets second kayak elinie, and the company receives $11,000 cash g. 24 orice supplies of $1.700 purchased on July are paid in full. Sep. I to provide better storage of mountain bikes and kayake when not in use, the company tets storage shed for one year paying $2.80 (5240 per month) in advance. Sep 21 Toby conducts & rock-bing olinic. The company receive 513,300 cash. Oct. 13 any conduct an orienteering clinic. Participants practice how to understand a topographical map. read an inter, compass, and orient through heavily wooded areas. The company receive $19.500 cash Dec. 1 tony decides to hold the company's first adventure race on December 15. Your person will race from checkpoint to checkpointing combination of mountain bikin kayaking, orienteeris, trail running and robing skills. The first team in each category to complete all checkpointe oder wie They tea for each to Dec. 5 To help organize and promote the ruce, Tony hire his college miate, Victor. Vietor will be paid 156 in salary for each tes that compete in the race. walary will be paid after the race Deo The company pay $1,000 to purchase permit from state park where the race will be held. The Dec. 12 the company purchases racing supplies for $2,100 Count due in 30 days. Supplies include trophies for the top-listing teams in heategory, promotional shit, sa foods and drinks for participants, and told markere to prepare the racecore. Dec. 15 The company receives $21.500 cash from a total of torty tem, and the received Dec. 16 The company payu Victor's salary of $2,000. Dec. 91 The company we dividend of 13,500 51.250 to Tony 51.750 total) Dec 31 in his personal me. Tony purchases diame ting for $1.505. Tony surprise by peopoint that they got married couple 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 and kayaks purchased on August 4 totais 57600 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 has expired d. or the 51700 of office supplies purchased on July 4, 5310 remains e interest expense on the $32,000 loan obtained from the city council on August 1 should be recorded or the $2.900 of racing supplies purchased on December 12, 5300 remains Suzie calculates that the company owes $13,400 in income taxes 4. Prepare an adjusted trial balance as of December 31, 2021. Credit GREAT ADVENTURES, Inc. Adjusted Trial Balance December 31, 2021 Accounts Debit Cash Prepaid Insurance Prepaid Rent Supplies (Office) Supplies (Racing) Equipment (Bikes) Equipment (Kayaks) Accumulated Depreciation Accounts Payable Income Tax Payable Interest Payable Notes Payable Common Stock Dividends Service Revenue (Clinic) Service Revenue (Racing) Advertising Expense Depreciation Expense Income Tax Expense Insurance Expense Interest Expense Legal Fees Expense Miscellaneous Expense Rent Expense Sairies Expense Supplies Expense (Office) Supplies Expense (Racing) Totals $ $ 5. For the period July 1 to December 31, 2021, prepare an income statement, statement of stockholders' equity and classified balance sheet. Complete this question by entering your answers in the tabs below. Income Stmt of Statement Stockholders Balance Sheet Equity Prepare a classified balance sheet as of December 31, 2021. (Amounts to be deducted should be indicated by a minus sign) GREAT ADVENTURES, Inc. Balance Sheet December 31, 2021 Assets Liabilities Current Assets Current Liabilities: Accounts Payable Interest Payable Cash Prepaid Insurance Prepaid Rent Supplies (Office) Supplies (Racing) 0 Total Current Assets Long-term assets Equipment (Bikes) Equipment (Kayaks) Accumulated Depreciation Total Current Liabilities Notes Payable Total Liabilities Stockholders' Equity Common Stock Retained Earrings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 0 Total Assets $ 0 $ (Stmt of Stockholders Equity Great Adventures Problem AP3-1 Part 5 5. For the period July 1 to December 31, 2021, prepare an income statement, statement of stockholders' equity and classified balan sheet Complete this question by entering your answers in the tabs below. Income Stmt of Statement Stockholders Balance Sheet Equity For the period July 1 to December 31, 2021, prepare a statement of stockholders' equity. All account balances on July 1 were zero, REAT ADVENTURES, Inc. Statement of Stockholders' Equity For the Period Ended December 31, 2021 Common Stock Retained Earninge Total Stockholders Equity Great Adventures Problem AP3-1 Part 5 5. For the period July 1 to December 31, 2021, prepare an income statement, statement of stockholders' equity and classified balance sheet Complete this question by entering your answers in the tabs below. Income Statement Stmt of Stockholders Balance Sheet Equity For the period July 1 to December 31, 2021. prepare an income statement GREAT ADVENTURES, Inc. Income Statement December 31, 2021 Revenues: Total Revenues Expenses: Total Expense 0 0 Stent of Stockholders Equity >