this is a multipart question, there are a few questions like this posted on chegg but the balance sheet values are different.

i need a journal, an adjusted trial balance, income statement, statement of equity, and balance sheet for this excel project.

AutoSave OFF g Financial Statement Project ACCT 1(1) (1) View Tell me Home Insert Draw Page Layout Formulas Data Review X lo Calibrl (Body) 11 - A A Wrap Text General IM Paste BIU Merge & Center $ %, & $8 Conditional Format Cell Formatting as Table Styles 133 P A C D G 1 M N 11. Make adjusting entries in the journal founding to the nearest deltarusing the information below 2 Aphical count of inventory revealed 5440,020,00 of inventory Aphical count of supplies revealed $7232.00 of supplies Depreciation for the year was $24.005 5 The balance in prepaid rent represents an amount paid Dec. 1st for one year 6 Even though the nutes receivable we'l dut until April 30 2021 they will include interest. The Dec. 31 Balance represents a month note originating on Nov. 1st 2020 7 Dec. 31.8 Thursday and $11,000 of salaries for five day workweek arepald every Friday 2.Onthedested page make an Adjusted Traced the Create Financial Statements for 2020 note withdrawals of 550,000 were taken cartier in the year) Anwer the questions 10 How would the tranciat statements de different reach the eners are independent) 11 abilities 12 Wehaved counting incoming inventory$1,700 13 Wehod potten to record depreciation 14 We had forgotten to upplies The booster had thought the $40,000 we received 12.4 was for post wint of vices to be performed in January 16 The book per wint were that the note payable indute interest to be paid maturity calculated on the verge balance 17 trecord the amount the vity would change and indicate the direction of change with or so that sportive number would indicate toh by that runtin angive number indicates it is too lon by that amount 10 wat be differential of these were happened in 10307 20 21 22 23 culty 1 35 20 21 2 39 10 31 17 youw 11 14 35 H4 1 38 Qee BOB Instruction & Info 1-1.20 Balance Sheet 12-31-20 Unadjusted Trial Bal Journal 12-31-20 Adjusted Trial Bal 2020 Income Statement 12-31 OFF - AutoSave Page Layout Formulas Data Review Vie Insert Draw me == ad Calibri (Body) ' 14 === Paste BI UOA X fx 1/1/2020 B D E Mom & Pop Balance Sheet 1/1/20 $44,559.00 $4,690.00 $4,258.00 $459,871.00 $2,000.00 $88,331.00 $252,845.00 $5,000.00 $56,000.00 $42,000.00 -$157,000.00 $198,845.00 $802.554.00 Current assets Cash Accounts receivable 7 Office Supplies 8 Inventory 9 Prepaid rent 10 Notes Rec 11 Fixed assets 12 Building 13 Furniture 14 Equipment 15 Land 16 Less Total Accum. Depr 17 Total assets 18 Current liabilities 19 Salaries Payable 20 Accounts payable 21 Long term liabilities 22 Notes Payable 23 Total Liabilities 24 Owner's Equity 25 Total Liabilities and Equity 26 22 28 29 30 31 32 33 34 35 36 37 Instructions & Info Ready $3,000.00 $88,437.00 $456,286.00 $547,723.00 $254.831.00 $802,554.00 1-1-20 Balance Sheet 12-31-20 Unadjusted Trial Bal B D E F 1 2 DR Mom & Pop UNADJUSTED TRIAL BALANCE 3 12/31/20 4 Cash 5 Accounts receivable 6 Office Supplies 7 Inventory 8 Pre-paid rent 9 Building 10 Accumulated Depreciation 11 Furniture 12 Equipment 13 Notes Rec 14 Land 15 Salaries Payable 16 Accounts payable 17 Notes Payable 18 Owner's Equity 19 Sales Revenue 20 COGS 21 Salaries Expense 22 Rent Expense 23 24 25 CR $6,255.00 $1,258.00 $11,487.00 $441,742.00 $4,000.00 $252,845.00 $157,000.00 $9,000.00 $62,000.00 $81,612.00 $42,000.00 $5,000.00 $83,125.00 $440,035.00 $204,831.00 $163,208.00 $81,000.00 $42,000.00 $18,000.00 $1,053,199.00 $1,053,199.00 NNN