please do it as shown in pictures. this is very difficult and if you change it, it will only make it harder.

Please use the attached Excel spreadsheet and complete each of the tabs shown at the bottom On the first tab is the starting information and the transactions that need to be recorded. The second tab is where you should put the journal entries to record the transactions On the third tab is the T accounts and trial balance for you to post your journal entries On the fourth tab is where you should put the financial statements and answer the question Balance Sheet for end of 2019 Assels Accounts Receivable (net of allow ance of 237.884 Liabilities \begin{tabular}{lr} Accounts Pauable & 94.552 \\ \hline Uneamed Revenue & 45.200 \\ Interest Pauable & 2.100 \\ Salaries Pauable & 6.600 \\ \hline Total CurrentLiabilities & 148.452 \end{tabular} Long Term Debt 246,100 Total Liabilities 394,552 CapitalStock Fetained Earnings 100.00078.807 Total Liabilities and Stockholders 573.359 Transactions for lanuarn of 2020 1/3/1900 Paid interest payable plus $3,000 tow ard long term debt 11212020 Paid salaries payable 1/312020 Purchased inventory (500 units at $46) on credit 14/2020 Paid shipping on inventory of 1250 16120led Purchased supplies on ereditfor $850 1912020 Peceived \$2,500 from customers for products to deliver in March 1/1012020 Sold 600 units on credit with a sales price of $105 (assume perpetual LIFC) 1/1512020 Purchased inventory (7010 units at \$47) 1/2012020 Paid $41,600 on a oo ounts payable 1121/2020 Collected $121,350 in ash from oushomers inpayment for earlier sales 12212020 whote off acoounts receivable for $615 12512020 Sold 200 units on sredit with a sales price of $105 (still perpetual LIFD) 12612020 Paid wages to emplouees for work done in danuary \$s1,000 12612020 Feceived urlity bill for 47,200 for utilities used in danuary that will be paid in February 11312020 Delivered 1000 units of product to customers that they paid 10 , 000 tor in 2019 (unearned revenue) 1 |l|z120 Courted supplies and found $1,240 remaining 1312020 Enployees worked and earred $4,700 in danuary that will not be paid until February 13 1202]) Iricrest at 12% per year on the long term debt (new balancel has not been paid 113121200 The prepaid insurance will last, 4 morith s into 2020 before a new policy will be required 1131/2120 The allowance for bad debrs is estimated at 4% of total accounts receivable 1812020 A count of inweritory showed that 50 units were damaged such that they are workless and will be thrown away Income Statement For January 2020 Balance Sheet as of January 31, 2020 How manv units and at what cost are in inventory to start February? Statement of Equity for January 2020