could someone pleaseeeeee help

these are the tabs in fhe excel spreadsheet: unadjusted trail balance, adjusting journal entries, T-accounts, adjusted trial balance, income statement, statement shareholders' equity, balance sheet, financial ratios, closing journal entries, and post closing trial balance

thank you so much!!!!!

5 Use Excel to link all of your journal entries and financial statements. This will be great practice and it reduces the likelihood of urton. There is a video calable in Blackboard to pude you on uning barcel and navigating the project Also be sure to take advantage of Excel by wing formulas to calculate/sum groups of number * Not force any cells to match check figures pen. Any adiutments in the T-Acounts of financial statements not supported by legitimate adjusting or dowling entries will be considered financial statement misrepresentation, sufficient to result in a falling trade Use the format button to add dollar in underlining and double underlining when appropriate DO NOT put dollarly on every time as it will cost you points 1 5 7 23 51.750 28 REQUIREMENTS: e Part 1 Post the Unadjusted Trial Balance total to the Accounts on the sheet labeled "Accounts. These numbers will represent your beginning balances 2 Part 2 Record the adjusting journal entries required for items AND po them to the account Add or extend les on any Accounts if a Porn Prepare an adjusted Trul Balance for Gatsby, Inc. wing the updated Accounts Naunted lehede Miguel 26 Part Prepare, in good form, financial statements on each specified sheet in the following onder 27 . M-Step Income Statement and prepare a bar AND a luchart for a visual representation of expert Statement of stockholders uity 29 Cel Balance Sheet S. 1 Parts With the financial statements, calculate the following than on the specified here and trat (20) enerom) interpret the ration for Gatsby, in He wure to compare them to the industry averages which are siwn on the specified sheet Working Capital h Current Ratio Quick Ratio (Auld Test d Debt tot Times interest Earned 32 30 14 10 37 Part 6 Hecord colournal entre AND post them to the account 40 Part 7 Prepare a Post-Closing Trial Balance using the updated -accounts Total debt check SE350 E A D E 2 Unadjusted Trial Balance 3 12/31/XX 4 Debit Credit 5 Cash 121,550 6 Accounts Receivable 236,000 7 Prepaid Insurance 24,000 8 Supplies 4,500 9 Inventory 85,000 10 Land 75,000 11 Building 200,000 12 Accumlated Depreciation Building 40,000 13 Equipment 160,000 14 Accumlated Depreciation Equipment 8,000 15 Accounts Payable 160,500 16 Interest Payable 0 17 Wages Payable 0 18 Unearned Revenue -Alarm Systems 45,000 19 Long-Term Bank Note Payable 150,000 20 Common Stock 310,000 21 Retained Earnings 124,750 22 Dividends 7,000 23 Revenue 381,000 24 Cost of the Goods Sold 146,000 0 25 Depreciation Expense 26 Insurance Expense 15,000 0 27 Interest Expense 28 Rent Expense 54,000 0 29 Supplies Expense 30 Utilities Expense 23,300 31 Wage Expense 67,900 S1219.250 S4239.250 32 Totals 33 34 35 36 37 38 39 40 41 42 43 Project Instructions Unadjusted Trial Balance Adjusting Journal B c D G H K 1 The company's weekly payroll is $3,000 and is paid each Friday for a five-day work week. Assume December 31st falls on a Monday, but the employees will not be paid their wages until Friday, January 3rd. 2 Eighteen months earlier, on July 1st the company purchased equipment that cost $160,000. Its useful life is predicted to be twenty years, at which time the equipment is expected to have a zero salvage/residual value. Gatsby, Inc. uses the straight-line depreciation method. Deprecation has NOT been recorded for this year. 3 On September 1st of the current year Gatsby, Inc. was paid $45,000 in advance of future Installation of alarm systems in 3 new homes. The amount was credited to the Unearned Revenue - Alarms account. Between September 1st and December 31st alarm systems were installed in 1 home, completing that job. on October 1st of the current year the company purchased a 12-month insurance policy for $24,000. The transaction was recorded with a debit to the Prepaid Insurance account. Insurance expense has not been recorded for November nor December 5 On December 30 of the current year the company completed an $38,000 job that has not been billed/Invoiced and therefore has not been recorded. A$150,000 long-term note payable was signed on September 1st of the current year. It is a five-year note with a 6% interest rate. Interest expense as not been accrued for this year. 6 7 Supplies at the beginning of the current year had a balance of $ 300. Supplies valued at $4,200 were purchased thoughout the year. The current balance in the account is $400. 3 8 0 1 Depreciation on the building is calculated using the straight-line depreciation method. Gatsby estimates depreciation on the building over a 25 year period and a zero salvage/residual value 2 3 34 35 36 37 38 39 40 41 42 43 T-Accounts Adjusting Journal Entries Project Instructions Unadjusted Trial Balance A D G . M O Land LIABILITIES Accounts Payable Unearned RevAlarms EQUITY Common Stock Building Interest Payable Long-Term Note Payable Retained Earnings Accum Depre-Building Wagos Payable Dividends 2 ASSETS 3 Cash 4 5 6 7 8 9 Accounts Receivable 10 11 12 13 Prepaid Insurance 14 15 16 17 18 Supplies 19 20 21 22 Inventory 23 24 25 26 27 28 REVENUE 29 Revenue 30 31 32 33 Equipment Accum Depre-Equipment EXPENSES Cost of the Goods Sold Depreciation Expense Rent Expense Utilities Expense 35 Insurance Expense Interest Expense Supelles pente Wapense 37 38 39 40 41 12 T-Accounts Income Adjusted Trial Balance Project Instructions Unadjusted Trial Balance Adjusting Joumal Entries Che check for dates. 1 X D F H Calculate the besededancial ratlos HERE d INDUSTRY AVERAGES bor marion Cirrent 2.31 Olck Idd Ratio 201 Debt to quity Ratio 0.25 Time interest Erned 30 m IN THIS ANA U the INDUSTRY AVERAGE on theetta compare the fram the atlasyow computed and briefly in your dings