i just need help on #4. preparing income statement, retained earnings statement, and the balance sheet.

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 O 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 During 2020, the following events occ available at the end of 2020 is as follows: 1) On January 8, received checks howing events occurred in the company. Additional information on account made in December 2019 atter discount period has lapsed received checks, $20.000 from Kent and $15.000 from Montana, for sales 2) paid cash $125,000 to Hermann for merchandise purchased last year after 3) TO 4) On January 15, paid cash $125,00 discount period has lapsed On January 18, received checks, $34,590 ary 18, received checks. $34.590 for outstanding note receivable and associated interest of $410. On January 25, paid off the utilities bill of $12.000 and income tax of 13,000, payable of 6,500 January 26, purchased merchandise on account from Charles $90.000 and Georgia 120,000. Terms 3/10, 1/30, F.O.B. destination On February 4, send checks to Charles for 90.000 less 2% cash discount, and to Georgia for $120,000 less 3% cash discount 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. 6) 7) 8) 9) On February 15, issued credit of $6,000 to Franklin for the merchandise returned. On February 20, received payment in full from Franklin and Thompson before discount period has 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 sun purchased during the year. 14) On June 5, declared cash dividends totaling $30,000. 15) 16) On June 30, paid cash dividends totaling $30,000 to stockholders. On July 1, issued a note of $250,000 to bank (one year, annual interest rate 5% for 17) On July 15, the company CEO paid $80,000 from her savings bank account to pure car for personal use. 18) On August 1, issued common stock 3,000 shares, $10 par, in exchange of a land 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, n/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,n/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. After physical counting, the company decided that the ending inventory was $60,000. 2) 3) 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. A5 X for Trial balnce - 3 Particulars Debit Creadit 441,730.00 78,866.00 410.00 2,930.00 11,134.00 65,000.00 18,000.00 12,000.00