I am having trouble with a comprehensive project that I am working on. I'm stuck on the statement of shareholders equity and have not gotten any further than that. I would greatly appreciate anyone's help!!

ACUM 120Congresive Problem P Search Savannah Dale C Home Page Layout Formula w View Help Shure 4 A D E G 11 12 11 Use Excel to link of your journal entries and financial statements. Ils will be great practice and it reduces the hood of errors. There is a video available in Blackboard to guide you on using wel and navigating the project so be sure to take advantage of Excel by si formulato calculated groups of numbers DO NOT force my cells to match the freshen yatments in the Accounts or financial statements not supported by legitimate ang ordings will be considered ancient presentation, sufficient in a fine de Use the format bunto del deling and double underling when people. DO NOT put doller signs on every line as it will cost you 14 15 16 12 REQUIREMENTS: Part 1 Post the adjusted Tallince stals to the accounts on the sheet labeled "Account. These numbers will represent your beginning balances 22 Part 2 Record the time before AND them to the accounts. Add or extend lines on any Accounts 25 PartPrepare and celo Gatsby, Inc. using the updated Account Adjusted to check for 25 Part 4 Prepare, in good form, mens onth speedshest in the following order a Mux-Sup Income and prepare a barre chart for a visual representation of expense. Statement of Stockholders Classified Balance Sheet SS 11 Parts Using the financial statements colore the song is on the sofied sheet and briefly 12 or 3 sentences in the ratios Gas 21 Workin dru Tyto > 3 5 6 8 9 O E R T Y O - 7 A S D F G H J L 4 1 Z V B N . Auto AC 221 IntI-SU20 - Comprehensive Problem-Hammon(2) Search Fle Home he Page Layout Formulas Data View Help A D H F 21 22 Part 2 Record the adjusting Jumal entries required for items AND post them to the T-accounts. Add or extend lines on any T-Accounts if necessary. 23 24 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T Accounts. Adjusted T8 check figure $1,277,600 25 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 29 Classified Balance Sheet Total Assets check figure: $871,950 31 Parts Using the financial statements, calculate the following ratios on the specified sheet and briefly (2 or 3 sentences) interpret the ratios for Gatsby, Inc. 28 30 32 33 14 a Working Capital b Current Ratio Quick Ratio Hd Test Debt to tauty Times Interest Earned 16 37 39 Part 6 Record closing journal entries AND post them to the T-accounts 20 Part 7 Prepare a Post Closing Trial Balance using the updated accounts. Total debit check ure 5915950 bedre Adjusting lumal Entries Type here to search le 46 1 + : 2 $ % 2 *3 & 5 6 7 00 9 0 VE W E R T Y U O S D F G AC 321 Inti- SU20 - Comprehensive Problem-Hammon(2) - AutoSave OTT Review Formulas View Home Data Help File Insert Page Layout C25 0 D E G H Credit 40,000 B 2 Unadjusted Trial Balance 3 12/31/XX 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 26 Insurance Expense 15,000 27 Interest Expense 0 26 Rent Expense 24,000 Project Instructions Unadjusted Trial Balance 8,000 160,500 0 0 45,000 150,000 310,000 124,750 381,000 Adjusting Journal Entries T-Accounts Adju Type here to search BI e AutoSave CH AC 321 Int. - SU20 - Comprehensive Problem-Hammon(2) File Home Insert Page Layout Formulas Data Review View Help C25 0 G A D A B 6 Accounts Receivable 236,000 7 Prepaid Insurance 24,000 4,500 8 Supplies 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 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 S1.219.259 $1.219.250 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adu Type here to search hp 62- AC 121 Intsude. CombienHammon P Search Savannah Ddoe 1 Home nuert Page Layout Fonds Da View Help Share E H M D N PREPARE proper form) ADRISTIG JOURNAL ENTRIES HERE D + mation to prepare tigantes following information relates to Gatsby, Inc. as of December 31 of the current year. The company wies the calendar as its annual reporting period and the Accrual Method of Accounting Prepaid and uneared items are recorded as ats and liabilities, respectively. Prepare all necessary adjusting journal entries and post to the accounts De Credit A A Account Wapes pense The company's weekly payroll $1,000 and is paid each Friday for a five day work week. Assume December ist falls on a Monday, but the employees will not be paid their wages until idi, anary Ird. 600 100 Depreciation Depende Accumulated Depre: EU C. Uneamed Revenue Alarm Revenue tighten months earliton luly 1st the company purchased equipment that cost $10,000 its useful 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 On September list of the current year Gatsby, Inc. was paid $45.000 in advance of future installation of alarm system in C 3 new homes. The amount was credited to the neared Revenge Alarms account. Between September 1st and December at alarm system were installed in home completing that job. On October at of the current year the company purchased in policy for the transaction was recorded with a debt to the Prepaid insurance continue expense has not been recorded for November December On December of the current year the company completed an 538.000 job that has been and therefore has been recorded D. Insurance Experte Prepaidance 000 . 10000 Rece Raven Yeart T. 17 A $150,000 og et payable was signed on August of the current years intereste na obnovo this year interest Pestino Type here to search e Ap 10 i 3 $ 4 2 5 6 7 8 9 O ( E 7 R 1 T Y 1 O P S D F G H ? pe V B N M AC 121 14120 - Comprehensive Problem. Hann Searth Savannah Defoe Home sert Page Layout Formula Share Data View 0 A c E righteen months earlier, only the company purchased equipment that counts useful is predicted to be twenty years, at which time the equipment expected to have a salvage/residual value Gatsby Inces the straight line depreciation method. Deprecation has NOT been recorded for this year N Depreciation Expense Accumulated Depre: Equip 19000 C On September ist of the current year Getty, Inc. waspadin advance of future installation of arm systemic 3 new homes. The amount was credited to the Unmarried Revenue Alarm account. Between September 1st and December ist alarm systems were installed in home, completing that job. Uneaed Revenue Alarm Never 15000 D. D 4000 On October 1st of the current year the company po 12 monthnunce policy for $14,000. The transaction was recorded with a debt to the prepardie meesperse has not been recorded for November or December Expense Prepaid in 00 E. On December 30 of the current year the company completed as $18.000 that has not been bleked and therefore has been recorded Acontece Revenue F Intense Interest Payable 3:30 A 5150,000 long term paytle was don Ast ist of the current years eve one with interest rate werstepemot beend for this year Supplies at the beginning of the year had a balance of 300 Suppese were purchased thoughout the year. The current balance in the 4100 Supplies per Supplies 4100 000 H Depreciation on the weeding the right in de method Gatsby is depreciation enthunga yarpened and saved Deproningen i Acum Der Bu 31 3000 Type here to search BE IN & > 2 3 5 4 5 6 7 00 9 O E R T Y U o P 7 S D F J 4 ? pause JcL V B N . ACUM 120Congresive Problem P Search Savannah Dale C Home Page Layout Formula w View Help Shure 4 A D E G 11 12 11 Use Excel to link of your journal entries and financial statements. Ils will be great practice and it reduces the hood of errors. There is a video available in Blackboard to guide you on using wel and navigating the project so be sure to take advantage of Excel by si formulato calculated groups of numbers DO NOT force my cells to match the freshen yatments in the Accounts or financial statements not supported by legitimate ang ordings will be considered ancient presentation, sufficient in a fine de Use the format bunto del deling and double underling when people. DO NOT put doller signs on every line as it will cost you 14 15 16 12 REQUIREMENTS: Part 1 Post the adjusted Tallince stals to the accounts on the sheet labeled "Account. These numbers will represent your beginning balances 22 Part 2 Record the time before AND them to the accounts. Add or extend lines on any Accounts 25 PartPrepare and celo Gatsby, Inc. using the updated Account Adjusted to check for 25 Part 4 Prepare, in good form, mens onth speedshest in the following order a Mux-Sup Income and prepare a barre chart for a visual representation of expense. Statement of Stockholders Classified Balance Sheet SS 11 Parts Using the financial statements colore the song is on the sofied sheet and briefly 12 or 3 sentences in the ratios Gas 21 Workin dru Tyto > 3 5 6 8 9 O E R T Y O - 7 A S D F G H J L 4 1 Z V B N . Auto AC 221 IntI-SU20 - Comprehensive Problem-Hammon(2) Search Fle Home he Page Layout Formulas Data View Help A D H F 21 22 Part 2 Record the adjusting Jumal entries required for items AND post them to the T-accounts. Add or extend lines on any T-Accounts if necessary. 23 24 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T Accounts. Adjusted T8 check figure $1,277,600 25 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 29 Classified Balance Sheet Total Assets check figure: $871,950 31 Parts Using the financial statements, calculate the following ratios on the specified sheet and briefly (2 or 3 sentences) interpret the ratios for Gatsby, Inc. 28 30 32 33 14 a Working Capital b Current Ratio Quick Ratio Hd Test Debt to tauty Times Interest Earned 16 37 39 Part 6 Record closing journal entries AND post them to the T-accounts 20 Part 7 Prepare a Post Closing Trial Balance using the updated accounts. Total debit check ure 5915950 bedre Adjusting lumal Entries Type here to search le 46 1 + : 2 $ % 2 *3 & 5 6 7 00 9 0 VE W E R T Y U O S D F G AC 321 Inti- SU20 - Comprehensive Problem-Hammon(2) - AutoSave OTT Review Formulas View Home Data Help File Insert Page Layout C25 0 D E G H Credit 40,000 B 2 Unadjusted Trial Balance 3 12/31/XX 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 26 Insurance Expense 15,000 27 Interest Expense 0 26 Rent Expense 24,000 Project Instructions Unadjusted Trial Balance 8,000 160,500 0 0 45,000 150,000 310,000 124,750 381,000 Adjusting Journal Entries T-Accounts Adju Type here to search BI e AutoSave CH AC 321 Int. - SU20 - Comprehensive Problem-Hammon(2) File Home Insert Page Layout Formulas Data Review View Help C25 0 G A D A B 6 Accounts Receivable 236,000 7 Prepaid Insurance 24,000 4,500 8 Supplies 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 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 S1.219.259 $1.219.250 Project Instructions Unadjusted Trial Balance Adjusting Journal Entries T-Accounts Adu Type here to search hp 62- AC 121 Intsude. CombienHammon P Search Savannah Ddoe 1 Home nuert Page Layout Fonds Da View Help Share E H M D N PREPARE proper form) ADRISTIG JOURNAL ENTRIES HERE D + mation to prepare tigantes following information relates to Gatsby, Inc. as of December 31 of the current year. The company wies the calendar as its annual reporting period and the Accrual Method of Accounting Prepaid and uneared items are recorded as ats and liabilities, respectively. Prepare all necessary adjusting journal entries and post to the accounts De Credit A A Account Wapes pense The company's weekly payroll $1,000 and is paid each Friday for a five day work week. Assume December ist falls on a Monday, but the employees will not be paid their wages until idi, anary Ird. 600 100 Depreciation Depende Accumulated Depre: EU C. Uneamed Revenue Alarm Revenue tighten months earliton luly 1st the company purchased equipment that cost $10,000 its useful 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 On September list of the current year Gatsby, Inc. was paid $45.000 in advance of future installation of alarm system in C 3 new homes. The amount was credited to the neared Revenge Alarms account. Between September 1st and December at alarm system were installed in home completing that job. On October at of the current year the company purchased in policy for the transaction was recorded with a debt to the Prepaid insurance continue expense has not been recorded for November December On December of the current year the company completed an 538.000 job that has been and therefore has been recorded D. Insurance Experte Prepaidance 000 . 10000 Rece Raven Yeart T. 17 A $150,000 og et payable was signed on August of the current years intereste na obnovo this year interest Pestino Type here to search e Ap 10 i 3 $ 4 2 5 6 7 8 9 O ( E 7 R 1 T Y 1 O P S D F G H ? pe V B N M AC 121 14120 - Comprehensive Problem. Hann Searth Savannah Defoe Home sert Page Layout Formula Share Data View 0 A c E righteen months earlier, only the company purchased equipment that counts useful is predicted to be twenty years, at which time the equipment expected to have a salvage/residual value Gatsby Inces the straight line depreciation method. Deprecation has NOT been recorded for this year N Depreciation Expense Accumulated Depre: Equip 19000 C On September ist of the current year Getty, Inc. waspadin advance of future installation of arm systemic 3 new homes. The amount was credited to the Unmarried Revenue Alarm account. Between September 1st and December ist alarm systems were installed in home, completing that job. Uneaed Revenue Alarm Never 15000 D. D 4000 On October 1st of the current year the company po 12 monthnunce policy for $14,000. The transaction was recorded with a debt to the prepardie meesperse has not been recorded for November or December Expense Prepaid in 00 E. On December 30 of the current year the company completed as $18.000 that has not been bleked and therefore has been recorded Acontece Revenue F Intense Interest Payable 3:30 A 5150,000 long term paytle was don Ast ist of the current years eve one with interest rate werstepemot beend for this year Supplies at the beginning of the year had a balance of 300 Suppese were purchased thoughout the year. The current balance in the 4100 Supplies per Supplies 4100 000 H Depreciation on the weeding the right in de method Gatsby is depreciation enthunga yarpened and saved Deproningen i Acum Der Bu 31 3000 Type here to search BE IN & > 2 3 5 4 5 6 7 00 9 O E R T Y U o P 7 S D F J 4 ? pause JcL V B N