I just need help with the last four sheets.

AutoSave ON Projest ACCT2 - O Search File Home Insert Page Layout Formulas Data Review View Help Calibri 11 AA X Cut Le Copy Format Painter Wrap Text General DX Paste Merge & Center 2 AU Fill cle $% ! Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format Clipboard 5 Font Alignment Number Cells 27 8 4 A B D E IF G H K L M N 1. Make adjusting entries in the journal (rounding to the nearest dollar) using the information below: A physical count of inventory revealed $440,020.00 of inventory 3 A physical count of supplies revealed $7232.00 of supplies Depreciation for the year was $24,005 The balance in prepaid rent represents an amount paid Dec. 1st for one year Even though the notes receivable aren't due until April 30 2019 they will include 8% interest. The Dec. 31 balance represents a 6 month note originating on Nov. 1st 2018. 7 Dec. 31st is a Thursday and $11,000 of salaries for a five day workweek are paid every Friday, 3 2. On the designated pages, make an Adjusted Trial Balance and then Create Financial Statements for 2018 Additional information needed for cash flow statement (not adjusting entries): Furniture was bought for cash and equipment was bought on credit. No assets were sold. 0 Cash dividends of $50,000 were paid during the year. 11 Use the indirect method for creating the Statement of Cash Flows 12 3. Answer these questions: 3 a. How would the financial statements be different if each of these scenerios are independent): 14 assets liabilities retained earnings 15 We had missed counting incoming inventory of $1,700 1700 1700 16 We had forgotten to record depreciation 17 We had forgotten to count supplies 18 The bookkeeper had thought the $40,000 we received 12-1 was for past services instead of services to be performed in January 40000 40000 19 The bookkeper wasn't aware that the note payable includes 8% interest to be paid at maturity calculated on the average balance) 20 (record how much the assets, liabilities, and retained earnings would change and indicate the direction of change with a tor 21 so that a poitive number would indicate it is too high by that amount and a negative number indicates it is too low by that amount.) 22 41700 40000 b. How would the financial statements be different if all of these scenerios happened in 2018? 1700 23 24 25 26 27 28 29 30 Income Statement 12-11-13 Statement of Reta Instructions & Info 12-31-18 Unadjusted Trial Bal Journal 12-18 Adjusted Tiles 1-1-18 Balance Sheet Read a x Type here to search AutoSave Off 15 Projest ACCT2 - File Home Insert Page Layout Formulas Data Review View Help X Cut La Copy Calibri 11 A ay Wrap Paste BIU v 191 IM Merg Format Painter Clipboard Font Alignment C20 X 88437 A B D E 1 ABC Inc. $45,559.00 $4,690.00 $4,258.00 $459,871.00 $2,000.00 $88,331.00 2 Balance Sheet 3 1/1/2018 4 Current assets 5 Cash 6 Accounts receivable 7 Office Supplies 8 Inventory 9 Pre-paid rent 10 Notes Rec 11 Fixed assets 12 Building $252,845.00 13 (Less Accumulated Depreciation) -$157,000.00 14 Furniture 15 Equipment 16 Land 17 Total assets 18 Current liabilities 19 Salaries Payable 20 Accounts payable 21 Long term liabilities 22 Notes Payable 23 Total Liabilities 24 Capital Stock 25 Retained Earnings 26 Total Liabilities and Shareholder Equity 27 $95,845.00 $5,000.00 $56,000.00 $42,000.00 $803,554.00 $3,000.00 $88,437.00 $456,286.00 $547,723.00 $100,000.00 $155,851.00 $803 554.00 528 Instructions Buinfo 1-1.18 Balance Sheet 12-B- B Uradjusted Trial Bal. Ready Type here to search ON Projest ACCT2 Search Home Insert Formulas Page Layout Data Review View Help Calibri 14 A A 29 as Wrap Text General X Cut s Copy 3 Format Painter V I B U A. A $ % 9 Merge & Center 00 Clipboard Font Alignment Number X N 12/31/18 D E F G A B ABC Inc 1 2 UNADJUSTED UNTRIAL BALANCE 3 12/31/18| 9 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 Capital Stock 19 Retained Earnings 20 Sales Revenue 21 COGS 22 Salaries Expense 23 Rent Expense 24 DR CR $7,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 $100,000.00 $105,831.00 $163,208.00 $81,000.00 $42,000.00 $18,000.00 $1,054, 199.00 $1,054, 199.00 25 26 27 28 Instructions & Info 1.1.18 Balance Sheet 12 31 18 uradjustel Tar Ball Vournal 12-31-18 Adjusted Ready Type here to search OH Projest ACCT2 - Search Home Insert Page Layout Formulas Data Review View Help Calibri 11 - A A = a Wrap Text Custom X Cut LG Copy Format Painter Paste BIU v A Merge & Center $ % 948 - c Fo Clipboard Font N Alignment Number A2 X 12/31/2021 A B D E F G Credits Debits $ 1,722.00 $ 1,722.00 $ 4,255.00 $ 4,255.00 6 $ 24,005.00 1 Date 2 31-Dec cost of goods sold 3 to inventory 4 Supplies expense 5 Supplies Depreciation expense 7 Accumulated Depreciation 8 Rent Expense 9 Prepaid Rent 10 Intrest on notes reciavable 11 Intrest Income 12 Salaries Expense 13 Salaries Payable 14 $ 24,005.00 $ 333.00 $ 333.00 $ 1,088.16 $ 1,088.16 $8,800.00 $ 8,800.00 15 16 17 18 19 20 21 22 23 24 25 26 utoSave Of B Projest ACCT2 - Search File Home Insert Page Layout Formulas Data Review View Help Calibri u ' ' == ab Wrap Text General X Cut LECopy Paste Format Painter BIU a A- Es Merge & Center $ % 9 : Conditional Formatting Clipboard Font Alignment Number L13 X fx G H 1 A 1 Accounts 2 Cash 3 Accounts Receivable 4 Office Supplies 5 Inventory 6 Prepaid Rent 7 Building 8 Accumulated Depreciation 9 furniture 10 Equipment 11 Notes Rec 12 Intrest on Notes Rec 13 Land 14 Salaries Payable 15 Accounts Payable 16 Notes Payble 17 Capital Stock 18 Retained Earningas 19 Sales Revenue 20 Cost of Goods Sold 21 Salaries Expense 22 Rent Expense 23 Supplies Expense 24 Depriciation Expense 25 Intrest Income 26 Totals 27 B D E F Debits Credits Adjusted DR CR $ 7,255.00 $ 7,255.00 $ 1,258.00 $ 1,258.00 $ 11,487.00 $ 7,232.00 $ 441,742.00 $. 440,020.00 $ 4,000.00 $ 3,667.00 S 252,845.00 $ 252,845.00 $ 157,000.00 $ 181,005.00 $ 9,000.00 $ 9,000.00 $ 62,000.00 $ 62,000.00 $ 81,612.00 $ 81,612.00 $ 1,088.00 $ 42,000.00 $ 42,000.00 $ 5,000.00 $ 13,800.00 S 83,125.00 $ 83,125.00 $ 440,035.00 $ 440,035.00 $ 100,000.00 $ 100,000.00 $ 105,831.00 $ 105,831.00 $ 163,208.00 $ 163,208.00 $ 81,000.00 $ 82,722.00 $ 42,000.00 $ 50,800.00 $ 18,000.00 $ 18,333.00 $ 4,255.00 $ 24,005.00 S 1,088.00 $ 1,054,199.00 $ 1,054,199.00 $ 1,088,092.00 $ 1,088,092.00 28 29 Instructions & Info 1-1-18 Balance Sheet 12-31-18 Unadjusted trial Bal Journal 12-31 18 Adjusled Trial Bal. 2018 ind Ready Type here to search MA a AutoSave Off Projest ACCT2 - file Home Insert Page Layout Formulas Data Review View Hel X Cut [Copy Calibri 11 - A A a Wre Paste BIU Format Painter A Mer Clipboard Font Alignment B9 H D A B D 1 2 ABC Inc. Income Statement Year ending 2018 3 4 5 6 7 8 9 10 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 Instructions & Info 1+1 -18 Balance sheet Seda Ball Ready Type here to search AutoSave Of Hb Projest ACCT2 - File Home Insert Page Layout Formulas Data Review View H Calibri 11 A A X Cut L Copy Format Painter PEL BIU Clipboard Font Alignment A4 f A B C D E 1 2 ABC Inc. Statement of Ret Earnings Year ending 2018 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1-1-18 Balance Sheet 18-3-8 Unadjusted Trial Ball Monical Ready 12-31 Type here to search o AutoSave Off Projest ACCT2 - File Home Insert Page Layout Formulas Data Review View X Cut Calibri 12 - A A Copy I U . v THAI Format Painter Clipboard Font Alignmen A4 H X NI A B C D m 1 2 ABC Inc. Balance Sheet 12/31/2018 3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 2-3 i Unadjusted Trial Ball Journal 18-3-8 Adjusted Trial Ba seady Type here to search Ott H Projest ACCT2 - Home Insert Page Layout Formulas Data Review X Cut Calibri 11 A A - Copy B TU A Format Painter Clipboard Font A5 A B D 4 Statement of Cash Flows 5 7 8 10 12 Baca Odonovs 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Journal 12-31-18 Adjusted Trial Bal. 20 Staten Rand Type here to search