AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem- Hammon(2) View Home Insert Draw Page Layout Formulas Data Review Insert WE DX Delete Format Calibri (Body) 11AA 29 29 General G Paste BIU E EE $% % Conditional Format Cell Formatting as Table Styles Print_Are 4 * fx comprehensive Project Information: A 1 Comprehensive Project information: 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 4 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. 50 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 12 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. 16 18 19 REQUIREMENTS: 20 Part 1 Post the Uradjusted Tral Balance totals to the T-Accounts on the sheet labeled "T-Accounts." These numbers will represent your beginning balances 2 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 4 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T-Accounts Adjusted T check figure $1,277,500 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: 27 . Multi-Step Income Statement and prepare a bar or ple chart for a visual representation of expenses. 28 b Statement of Stockholders' Equity ccassified Balance Sheet Total Assets check figure: S871.950 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Comma Style Statement Average: 1028500 Count: 50 30 Statement Share Sum: 3085.500 AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem-Hammon (2) Home Insert Draw Page Layout Formulas Data Review View Inser Delet Paste Form Calibri (Body) 11 - A A == 29 General BIVA $ % ) 8-98 Conditional Format Cell Formatting as Table Styles Inot Print_Aresxfx Comprehensive Project Information: 22 A 8 D E G Use omat Urg, wiceman og when appropriate. Nu put a gre un everywhere must you on pro 7 Dul 16 18 23 $1,277,600 19 REQUIREMENTS: 20 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 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 to check figures 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: 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 $871,950 31 Ports Unlng the financial statements, calculate the following ratios on the specified sheet and briefly 12 or 3 sentences) interpret the ratlos for Gatsby, Inc. 27 28 29 JU 32 33 34 . Working Capital b Current Ratio Quick Ratio (Acid Test) d Debt to Equity e Times Interest Earned 36 37 38 39 Part 6 Record closing journal entries AND post them to the T-accounts. 40 Part 7 Prepare a Post-Closing Trial Balance using the updated T-accounts Total debit check figure $935,950 41 44 45 46 47 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement Sta Average: 1028500 Count: 50 Sume AutoSave OFF Home Insert Draw Page Layout Formulas Data RE 11 = A A Calibri (Body) BIU Paste fx 4500 inot C8 220 w A D Dur pro 2 Credit 40,000 1 Gatsby, Inc. Unadjusted Trial Balance 3 12/31/ 4 Debit 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 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 20 Common Stock 21 Retained Earnings 22 Dividends 7,000 23 Revenue 24 Cost of the Goods Sold 132,500 25 Depreciation Expense 0 26 Insurance Expense 15,000 27 Interest Expense 0 28 Rent Expense 24,000 29 Supplies Expense 0 30 Utilities Expense 9,700 31 Wage Expense 125,000 32 Totals $1.219.250 33 34 35 36 37 8,000 160,500 0 0 45,000 150,000 310,000 124,750 381,000 $1.219,259 Project Instructions Unadjusted Trial Balance Adju: AutoSave AC 321 IntI-SU20 - Comprehensive Problem-Hammon(2) Home Insert Draw Page Layout Formulas Data Review View v Ine Calibri (Body) 11 == A General IL DE Paste BIV a. Av $ % Conditional Format Cell Formatting as Table Styles Fa 19 1 K M N O P PREPARE (in proper form) ADJUSTING JOURNAL ENTRIES HERE B D H Information to prepare adjusting journal entries The following information relates to Gatsby, Inc. as of December 31 of the current year. The company uses the calendar year as its annual reporting period and the Accrual Method of Accounting. Prepaid and unearned items are recorded as assets and liabilities, respectively. Prepare all necessary adjusting journal entries and post to the T-accounts. Account Debit Credil A. A. 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. B. B. 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. c c. 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. D. D 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 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. L F. F. A$150,000 long term note payable was signed on August 1st of the current year. It is a five year note with a6% interest rate. Interest expense as not been accrued for this year. G. G. 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. H. H. 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 nero salvape/residual value Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement AC 321 Int 1 - SU20 - Comprehensive Problem-Hammon(2) Home Data Review View AutoSave OFF BESU Insert Draw Page Layout Formulas X Calibri (Body) v 11 - A A BIU A E Number Paste IMI Conditional Format Formatting as Table M12 B c D E F H M N 0 2 ASSETS 3 Cash 4 LIABILITIES Accounts Payable EQUITY Common Stock Land Unearned Rev.Alarms Building Interest Payable Long-Term Note Payable Retained Earnings 6 7 8 9 Accounts Receivable 10 11 12 13 Prepaid Insurance Accum Depre. Building Wages Payable Dividends 15 16 17 18 Supplies 19 20 21 22 Inventory 23 FEE Equipment Accum Depre. Equipment 25 26 27 28 REVENUE 29 Revenue 30 31 EXPENSES Cost of the Goods Sold Depreciation Expense Rent Expense Utilities Expense 32 34 35 36 37 38 Insurance Expense Interest Expense Supplies Expense Wages Expense Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income AutoSave OFF Home Insert Draw Page Layout Formulas Data Review 11 ' ' y Calibri (Body) BIU Paste GA- lili Jul E25 A XV fx E F G H B D 1 Prepare the Adjusted Trail Balance on this sheet. 2 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 29 30 31 32 33 34 35 36 37 Project Instructions Unadjusted Trial Balance Adjusting Jour AutoSave OFF Home Insert Draw Page Layout Formulas Data 11 A = Calibri (Body) BIU Paste a.A Lili L9 fx E F G A B 1 Prepare the Statement of Shareholders' Equity HERE 2 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 29 30 31 32 33 34 35 36 37 Project Instructions Unadjusted Trial Balance AutoSave OFF Home Insert Draw Page Layout Formu Calibri (Body) 11 A Paste BIU v L15 x fx D E B 1 Prepare a CLASSIFIED Balance Sheet HERE 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 35 36 37 Project Instructions Unadjusted Trial B AutoSave AC 321 IntI-SU20 - Comprehensive Problem-Hammon(2) -me v aste Cell Insert Draw Page Layout Formulas Data Review View Calibri (Body) v 11 A = General LG BIU MA $ % ) Conditional Format Formatting as Table Styles fx Prepare a MULTI-STEP Income Statement HERE B c E F H L M. Prepare a MULTI-STEP Income Statement HERE Prepare a Bar Chart AND a Pie Chart showing a visual representation of expenses HERE. N O Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement al Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 A ab IM!!! v = = ||| % Paste u BIU v v A Number L15 x & fx A B 1 Prepare a CLASSIFIED Balance Sheet HERE 2 D E F H - 3 4 5 is 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Financial Ratios Statement Shareholders' Equity Balance Wheet Select destination and press ENTER or choose Paste Help with Chegg Study Help Test Prep Thinkful tace Closing CHIC GEEKS rmat 3 75% Sun Jun 21 8:01:23 PM a Tools Data Window Help AutoSave O RESU Insert Draw Page Layout Formulas AC 321 Int 1 - SU20 - Comprehensive Problem- Hammon(2) Q Home Data Review View Share Comm Calibri (Body) v 11 29 % Conditional Formatting Format as Table Cell Styles 4 Paste lu BIU A Number Cells Editing ideas Sensitivity 111 E F B D 1 Calculate the five specified inancial ratios HERE 2 H INDUSTRY AVERAGES for comparison Current Ratio 2.51 Quick Acid Ratio 2.0:1 Debt to Equity Ratio 0.75 Times interest Carned 20 times IN THIS AREA:Use the INDUSTRY AVERAGES Even on this sheet to compare the results from the ratios you computed and briefly discuss your findings 4 5 6 7 w vis 9 10 11 12 13 7 14 15 16 17 1 19 20 21 22 24 26 28 29 30 31 32 ormat Tools Data Window Help AutoSave OF BESS Home Insert Draw Page Layout Formulas AC 321 Int 1 - SU20 - Comprehensive Problem Data Review View Calibri (Body 11 A A % Conditional Formatas Cell Styles Paste olu B IV A Number K15 x x E F H . 1 B D 1 Prepare necessary closing journal entries HERE 2 3 4 5 w 7 9 10 11 12 13 714 m 15 16 17 18 19 20 21 22 23 ne 24 25 26 27 28 29 30 31 33 34 EG 3 Cloying Journal Enter Statement Shareholders' Equity Balance Sheet Financial Ratios Select destination and press ENTER or choose Paste Test Prep Thinkful Help with Chegg CHIC GREKS 3 AC 321 IntI-SU20 - Comprehensive Problem-Hamme ormat Tools Data Window Help AutoSave OFF BESU Home Insert Draw Page Layout Formulas Calibri (Body) 11 ' ' Data Review View EE % Conditional Formatti Format as Table Cell Styles lu Paste Number J6 x fx D E F G H - B 1 Prepare the Post-Closing Trial Balance HERE 2 3 4 w is 5 6 7 8 9 10 12 13 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Statement Shareholders' Equity Balance Sheet Financial Ratios Closing Journal Entries Select destination and press ENTER or choose Paste Study Help Test Prep Thinkful Help with Chegg 12 : = AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem- Hammon(2) View Home Insert Draw Page Layout Formulas Data Review Insert WE DX Delete Format Calibri (Body) 11AA 29 29 General G Paste BIU E EE $% % Conditional Format Cell Formatting as Table Styles Print_Are 4 * fx comprehensive Project Information: A 1 Comprehensive Project information: 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 4 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. 50 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 12 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. 16 18 19 REQUIREMENTS: 20 Part 1 Post the Uradjusted Tral Balance totals to the T-Accounts on the sheet labeled "T-Accounts." These numbers will represent your beginning balances 2 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 4 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T-Accounts Adjusted T check figure $1,277,500 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: 27 . Multi-Step Income Statement and prepare a bar or ple chart for a visual representation of expenses. 28 b Statement of Stockholders' Equity ccassified Balance Sheet Total Assets check figure: S871.950 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Comma Style Statement Average: 1028500 Count: 50 30 Statement Share Sum: 3085.500 AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem-Hammon (2) Home Insert Draw Page Layout Formulas Data Review View Inser Delet Paste Form Calibri (Body) 11 - A A == 29 General BIVA $ % ) 8-98 Conditional Format Cell Formatting as Table Styles Inot Print_Aresxfx Comprehensive Project Information: 22 A 8 D E G Use omat Urg, wiceman og when appropriate. Nu put a gre un everywhere must you on pro 7 Dul 16 18 23 $1,277,600 19 REQUIREMENTS: 20 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 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 to check figures 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: 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 $871,950 31 Ports Unlng the financial statements, calculate the following ratios on the specified sheet and briefly 12 or 3 sentences) interpret the ratlos for Gatsby, Inc. 27 28 29 JU 32 33 34 . Working Capital b Current Ratio Quick Ratio (Acid Test) d Debt to Equity e Times Interest Earned 36 37 38 39 Part 6 Record closing journal entries AND post them to the T-accounts. 40 Part 7 Prepare a Post-Closing Trial Balance using the updated T-accounts Total debit check figure $935,950 41 44 45 46 47 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement Sta Average: 1028500 Count: 50 Sume AutoSave OFF Home Insert Draw Page Layout Formulas Data RE 11 = A A Calibri (Body) BIU Paste fx 4500 inot C8 220 w A D Dur pro 2 Credit 40,000 1 Gatsby, Inc. Unadjusted Trial Balance 3 12/31/ 4 Debit 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 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 20 Common Stock 21 Retained Earnings 22 Dividends 7,000 23 Revenue 24 Cost of the Goods Sold 132,500 25 Depreciation Expense 0 26 Insurance Expense 15,000 27 Interest Expense 0 28 Rent Expense 24,000 29 Supplies Expense 0 30 Utilities Expense 9,700 31 Wage Expense 125,000 32 Totals $1.219.250 33 34 35 36 37 8,000 160,500 0 0 45,000 150,000 310,000 124,750 381,000 $1.219,259 Project Instructions Unadjusted Trial Balance Adju: AutoSave AC 321 IntI-SU20 - Comprehensive Problem-Hammon(2) Home Insert Draw Page Layout Formulas Data Review View v Ine Calibri (Body) 11 == A General IL DE Paste BIV a. Av $ % Conditional Format Cell Formatting as Table Styles Fa 19 1 K M N O P PREPARE (in proper form) ADJUSTING JOURNAL ENTRIES HERE B D H Information to prepare adjusting journal entries The following information relates to Gatsby, Inc. as of December 31 of the current year. The company uses the calendar year as its annual reporting period and the Accrual Method of Accounting. Prepaid and unearned items are recorded as assets and liabilities, respectively. Prepare all necessary adjusting journal entries and post to the T-accounts. Account Debit Credil A. A. 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. B. B. 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. c c. 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. D. D 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 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. L F. F. A$150,000 long term note payable was signed on August 1st of the current year. It is a five year note with a6% interest rate. Interest expense as not been accrued for this year. G. G. 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. H. H. 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 nero salvape/residual value Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement AC 321 Int 1 - SU20 - Comprehensive Problem-Hammon(2) Home Data Review View AutoSave OFF BESU Insert Draw Page Layout Formulas X Calibri (Body) v 11 - A A BIU A E Number Paste IMI Conditional Format Formatting as Table M12 B c D E F H M N 0 2 ASSETS 3 Cash 4 LIABILITIES Accounts Payable EQUITY Common Stock Land Unearned Rev.Alarms Building Interest Payable Long-Term Note Payable Retained Earnings 6 7 8 9 Accounts Receivable 10 11 12 13 Prepaid Insurance Accum Depre. Building Wages Payable Dividends 15 16 17 18 Supplies 19 20 21 22 Inventory 23 FEE Equipment Accum Depre. Equipment 25 26 27 28 REVENUE 29 Revenue 30 31 EXPENSES Cost of the Goods Sold Depreciation Expense Rent Expense Utilities Expense 32 34 35 36 37 38 Insurance Expense Interest Expense Supplies Expense Wages Expense Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income AutoSave OFF Home Insert Draw Page Layout Formulas Data Review 11 ' ' y Calibri (Body) BIU Paste GA- lili Jul E25 A XV fx E F G H B D 1 Prepare the Adjusted Trail Balance on this sheet. 2 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 29 30 31 32 33 34 35 36 37 Project Instructions Unadjusted Trial Balance Adjusting Jour AutoSave OFF Home Insert Draw Page Layout Formulas Data 11 A = Calibri (Body) BIU Paste a.A Lili L9 fx E F G A B 1 Prepare the Statement of Shareholders' Equity HERE 2 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 29 30 31 32 33 34 35 36 37 Project Instructions Unadjusted Trial Balance AutoSave OFF Home Insert Draw Page Layout Formu Calibri (Body) 11 A Paste BIU v L15 x fx D E B 1 Prepare a CLASSIFIED Balance Sheet HERE 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 35 36 37 Project Instructions Unadjusted Trial B AutoSave AC 321 IntI-SU20 - Comprehensive Problem-Hammon(2) -me v aste Cell Insert Draw Page Layout Formulas Data Review View Calibri (Body) v 11 A = General LG BIU MA $ % ) Conditional Format Formatting as Table Styles fx Prepare a MULTI-STEP Income Statement HERE B c E F H L M. Prepare a MULTI-STEP Income Statement HERE Prepare a Bar Chart AND a Pie Chart showing a visual representation of expenses HERE. N O Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adjusted Trial Balance Income Statement al Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 A ab IM!!! v = = ||| % Paste u BIU v v A Number L15 x & fx A B 1 Prepare a CLASSIFIED Balance Sheet HERE 2 D E F H - 3 4 5 is 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Financial Ratios Statement Shareholders' Equity Balance Wheet Select destination and press ENTER or choose Paste Help with Chegg Study Help Test Prep Thinkful tace Closing CHIC GEEKS rmat 3 75% Sun Jun 21 8:01:23 PM a Tools Data Window Help AutoSave O RESU Insert Draw Page Layout Formulas AC 321 Int 1 - SU20 - Comprehensive Problem- Hammon(2) Q Home Data Review View Share Comm Calibri (Body) v 11 29 % Conditional Formatting Format as Table Cell Styles 4 Paste lu BIU A Number Cells Editing ideas Sensitivity 111 E F B D 1 Calculate the five specified inancial ratios HERE 2 H INDUSTRY AVERAGES for comparison Current Ratio 2.51 Quick Acid Ratio 2.0:1 Debt to Equity Ratio 0.75 Times interest Carned 20 times IN THIS AREA:Use the INDUSTRY AVERAGES Even on this sheet to compare the results from the ratios you computed and briefly discuss your findings 4 5 6 7 w vis 9 10 11 12 13 7 14 15 16 17 1 19 20 21 22 24 26 28 29 30 31 32 ormat Tools Data Window Help AutoSave OF BESS Home Insert Draw Page Layout Formulas AC 321 Int 1 - SU20 - Comprehensive Problem Data Review View Calibri (Body 11 A A % Conditional Formatas Cell Styles Paste olu B IV A Number K15 x x E F H . 1 B D 1 Prepare necessary closing journal entries HERE 2 3 4 5 w 7 9 10 11 12 13 714 m 15 16 17 18 19 20 21 22 23 ne 24 25 26 27 28 29 30 31 33 34 EG 3 Cloying Journal Enter Statement Shareholders' Equity Balance Sheet Financial Ratios Select destination and press ENTER or choose Paste Test Prep Thinkful Help with Chegg CHIC GREKS 3 AC 321 IntI-SU20 - Comprehensive Problem-Hamme ormat Tools Data Window Help AutoSave OFF BESU Home Insert Draw Page Layout Formulas Calibri (Body) 11 ' ' Data Review View EE % Conditional Formatti Format as Table Cell Styles lu Paste Number J6 x fx D E F G H - B 1 Prepare the Post-Closing Trial Balance HERE 2 3 4 w is 5 6 7 8 9 10 12 13 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Statement Shareholders' Equity Balance Sheet Financial Ratios Closing Journal Entries Select destination and press ENTER or choose Paste Study Help Test Prep Thinkful Help with Chegg 12 : =