i need help with number 4, preparing the income statement, retained earnings statement, and the balance sheet. this is the information that i have.

Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting to the general ledger and prepare trial balance before adjustment. 3) Making adjusting entries and prepare adjusted trial balance. 4) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet 5) Making closing entries. 6) Put all your work on excel spreadsheet. Each group should submit one completed copy to Assignment tab. The 2019 Balance Sheet of the Victoria Co. is as follows: Victoria Co. Beg Balance Sheet As of December 31, 2019 150,000 125,000 1,000 Cash Notes Receivable Accounts Receivable Less: Allowance for Doubtful A/Cs Inventories Office Supplies Prepaid Insurance Prepaid Rent Total Current Assets Long-term Investments Investments in securities Land for future development Property, Plant, and Equipment Land Buildings Less: Accu. Depreciation Intangible Assets Capitalized Development Costs Goodwill Other Intangible Assets Total Non-Current Assets Total Assets 85,000 Notes Payable 34,590 Accounts Payable 35,000 Unearned Revenue (2,930) Property Tax Payable 65,000 Interest Payable 0 Income Tax Payable 540 Salary and Wages Payable 4,800 Utilities Payable 222,000 Total Current Liabilities Provisions Related to Pensions 180,000 Bonds Payable 60,000 Total Non-Current Liab. Total Liabilities 145,000 Common Stock 800,000 Paid-in-capital - Common Stock (240.000) Preferred Stock Paid-in-capital - Preferred Stock 15,000 Retained Earnings 120,000 Accu. Other Comp. Income 48,000 Less: Treasury Stock 1,128,000 Total Shareholders' Equity 1,350,000 Total Liab, and Total Equity 3,500 13,000 6,500 12.000 311,000 93,100 300,000 393,100 704,100 240,000 96,000 97.000 7,400 210,500 5,000 (10,000) 645.900 1,350,000 curred in the company. Additional information During 2020, the following events occurred in the company. At available at the end of 2020 is as follows: 1) On January 8, received checks, $20 January 8, received checks $20 from Kent and $15.000 from Montana, for sale on account made in December 2010 after discount period has lapsed 2) On January 15, paid cash $125 000 to Hermann for merchandise purchase discount period has lapsed. 3) On January 18, received check on Gordstanding note receivable and associate interest of $410. to Hermann for merchandise purchased last year after 9) On January 25, paid off the utilities bill of $12.00 and income tax of 13,000, and wages payable of 6,500 5) On January 26, purchased merchandise on account from Charles $90,000 and Georgia 120,000. Terms 3/10, 1/30, F.O.B destination b) On February 4, send checks to Charles for 90 000 less 2% cash discount, and to Georgia for $120.000 less 3% cash discount. 7) On February 13. sold merchandise on account to Franklin $110.000 and Thompson $150,000. Terms 2/10, 1/30, F.O.B. shipping point. 8) On February 15, issued credit of $6,000 to Franklin for the merchandise returned 9) On February 20, received payment in full from Franklin and Thompson before discount period nas lapsed. 10) On February 28, the prepaid rent balance was expired. 11) On March 1, paid off notes payable $150,000 (issued in 2019) and associated interest of $7,500 (including $3,500 interest payable on the balance sheet). 12) On March 1, paid rent of $30,000 for one-year term starting from March 1, 2020 13) On April 15, paid $8,000 cash for office supplies. The company expenses all of the supplies purchased during the year. 14) On June 5, declared cash dividends totaling $30,000. 15) On June 30, paid cash dividends totaling $30,000 to stockholders. 16) On July 1, issued a note of $250,000 to bank (one year, annual interest rate 5%) for cash. 17) On July 15, the company CEO paid $80,000 from her savings bank account to purchase a car for personal use. 18) On August 1, issued common stock 3,000 shares, $10 par, in exchange of a land with a fait market value of $80,000. 19) On September 8, paid utilities expense, $12,000. 20) On October 7, sold merchandise to Utah on account $220,000, term 1/10, 1/30, FOB shipping point 21) On October 16, Utah paid off its balance. 22) On November 9, purchased merchandise from Pensacola $60,000, terms 3/10, 1/30 23) On November 12, returned $3.000 of merchandise to Pensacola and received credit. 24) On November 18, paid off the balance to Pensacola. 25) On December 27, 2020, the company paid the 2020 federal income tax of $12.500 and 2020 property tax of $6,600. 26) On December 28, sold merchandise to Kent on account $90,000, term 1/10, 1/30, FOB shipping point 27) On December 29, purchased merchandise from Hermann $160,000, terms 3/10, 1/30. 28) Over the year, daily cash sales were $1,000 on average per day 29) Over the year, sales and office employees earned $120,000 in salaries and wages, of which $15,000 remained as payable at the end of year. 30) Depreciation expense for the year was $80,000. 31) The utilities bill of $18,000 as of December 31, 2020 is due in January 2021 32) The balance of unearned revenues was increased by $12,000 during 2020. 33) Based on its historical data, the bad debts are about 2% of net credit sales (credit sales minus sales discounts and sales returns in the year of 2020). Additional information available at the end of 2020 is as follows: 1) No insurance policy was effective during the year. 2) 3) After physical counting, the company decided that the ending inventory was $60,000 Charles, Georgia, Pensacola, Franklin, Thompson, and Utah had zero balance on account as of Jan 1, 2020 4) The company uses the gross method to record its purchases and sales on credit. 5) The company adopts the periodic inventory system. In order to report the purchase activities the firm used the purchases, purchases discounts, and purchase returns & allowances accounts X group assingment.xlsx + Oper wt Google Sr. Trial balne Particulars Debit Creadit 441.730.00 78.866.00 410.00 2.930.00 8 8 Cash/Bank Notes recivable Account recivable Interest received double debts Bad debts Invetories Prepaid rent Utilities expenses Office supplies Supplies expenses Prepaid insurance Rent Prepaid rents Investment securties Land for future developmer 8 8 . SS8 00000 175.000,00 Building Accumulated depreciation Capital De 15.000.00 12010000 27 Others 28 st C mail.google.com/mail/u/0/?tab=rm1#inbox?projector=1 X + Oper with Goog group assingment.xlsx 250,000.00 160,000.00 12.000.00 Notes Payable Accounts Payable Unearned revenue Property tax payable Interes payable 6,250.00 Interest expense 10.250.00 Income tax payable Income tax 12,500.00 6,600.00 120,000.00 15,000.00 Property tax Salary expense Salary and wages payable Utilities payable Provisions related to pension Bonds Payable Common Stock Common Stock Paid upl Prefered stock 93,100.00 300,000.00 240,000.00 126,000.00 $97.000 7.400.00 180,500.00 Prefered stock paid) Retained earning SSS 5,000.00 Dividend playable Other comprehensive income Treasure stock Revenue sccount 10,000.00 11,000.00 4,800.00 Purchase 430 000.00 Purchase return 3.000.00 18 ea a NXP Insurance 4.800.00 430,000.00 3,000.00 936,000.00 Purchase Purchase renturn Sales Sales return Sales discaunt Purchase discuount Depreciation expense 6.000.00 7.280.00 7.110.00 80,000.00 S 2.765.960.00 $ 2.765,960,00