I need help with Part 6 (closing journal entries) and Part 7 (post closing trial balance)

3:02 PM Thu Feb 27 4796% AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review View 8 Q o Calibri (Body) 12 B U Home B ^ A = 1 EE tx 19 2 3 4 All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to model. Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below. Please be aware, points are allocated for the use of Excel (see rubric). Click on the tabs at the bottom of the bottom to familiarize yourself with the project. Check figures are provided for 3 key items to help ensure you are on the correct track 6 7 & 10 EXCEL NOTES: *Use Excel to link all of your journal entries and financial statements. This will be great practice and it reduces the likelihood of errors. There is a video available in Blackboard to guide you on using Excel and navigating the project. * Also be sure to take advantage of Excel by using formulas to calculate/sum groups of numbers. * DO NOT force any cells to match check figures given. Any adjustments in the T-Accounts or financial statements not supported by legitimate adjusting or closing entries will be considered financial statement misrepresentation, sufficient to result in a failing grade. *Use the format button to add dollar signs, underlining and double underlining when appropriate. DO NOT put dollar signs on every line as it will cost you points. REQUIREMENTS: Part 1 Post the Unadjusted Trial Balance totals to the T-Accounts on the sheet labeled "T-Accounts." These numbers will represent your beginning balances. 22 Part 2 Record the adjusting journal entries required for items AND post them to the T-accounts. Add or extend lines on any T-Accounts if necessary. 24 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T Accounts Adjusted TB check figure: $1,279,200 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: a Multi-Step Income Statement and prepare a bar or ple chart for a visual representation of expenses. b Statement of Stockholders' Equity Classified Balance Sheet Total Assets check figure: $850,750 31 Part 5 Using the financial statements, calculate the 5 following ratios on the specified sheet and briefly ( 2 or 3 sentences) interpret the ratios for Gatsby, Inc. a Working Capital b Current Ratio C Quick Ratio (Acid Test d Debt to Equity e Times Interest Earned 29 Part 6 Record closing journal entries AND post them to the T-accounts. Part 7 Prepare a Post-Closing Trial Balance using the updated T-accounts. 40 Total debit check figure: $924,750 Project Instructions Unadjusted Trial Bal... Adjusting Journal En.. T-Accounts Adjusted Trial Balance Income Statement Statement Shar + 3:02 PM Thu Feb 27 4796% 8 Q o Home UB AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review A = 1 View A Calibri (Body) 11 B tz a m ] Y ES D E F G H I J K L M N O Credit 40,000 8,000 160,500 B C Gatsby, Inc. Unadjusted Trial Balance 12/31/XX Debit 5 Cash 121,550 6 Accounts Receivable 236,000 7 Prepaid Insurance 24,000 & Supplies 4,500 9 Inventory 85,000 10 Land 75,000 11 Building 200,000 12 Accumlated Depreciation Building 13 Equipment 160,000 14 Accumlated Depreciation- Equipment 15 Accounts Payable 16 Interest Payable 17 Wages Payable 18 Unearned Revenue - Alarm Systems 19 Long-Term Bank Note Payable zo Common Stock 21 Retained Earnings 22 Dividends 7,000 23 Revenue 24 Cost of the Goods Sold 132,500 25 Depreciation Expense 26 Insurance Expense 15,000 27 Interest Expense 28 Rent Expense 24,000 29 Supplies Expense 30 Utilities Expense 9,700 31 Wage Expense 125,000 32 Totals $1.219.250 45,000 150,000 310,000 124,750 381,000 $1.219.250 34 Project Instructions Unadjusted Trial Bal... Adjusting Journal En... T-Accounts Adjusted Trial Balance income Statement Statement Share + 3:44 PM Sat Feb 29 AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review A E T E Home 11 B 1 CB View Calibri (Body) M EX GOZ Y S v x J K L M N O Cash Gatsby Inc Adjusted Trial Balance December 31, XXXX For the Period Ending 7 Accounts Debit Credit 121550 9 Accounts Receivable 265000 10 Prepaid Insurance 18000 11 Supplies 200 12 Inventory 85000 13 Land 75000 14 Building 200000 15 Accum Depreciation - Building 50000 16 Equipment 160000 17 Accum Depreciation - Equipment 24000 18 Accounts Payable 160500 19 Interest Payable 3750 20 Wages Payable 1200 21 Unearned Revenue - Alarm Systems 1500D 22 Long Term Bank Note Payable 150000 23 Comman Stock 310000 24 Retained Earnings 124750 25 Dividends 7000 26 Revenue 440000 27 Cost of Goods Sold 132500 28 Depreciation Expense 2600 29 Insurance Expense 21000 30 Interest Expense 3750 31 Rent Expense 24000 32 Supplies Expense 4300 33 Utlities Expense 9700 34 Wages Expense 126200 35 Totals $ 1,255,800.00 $ 1,279,200.00 Project Instructions Unadjusted Trial Bal... Adjusting Journal En... T-Accounts Adjusted Trial Balance Income Statement Statement Shar + Abc 123) The They B I U 96% 3:03 PM Thu Feb 27