Gus's Gone Fishing Expeditions Trial Balance Project. PLEASE HELP
hope these are better. they are screenshots instead of photos
Winter Custom LINU Delete BI P A Merge & Center $% Conditional Format Cell Formatting as Table Styles Format Sort & Fier Find a Select X . B C . L M N D G Gus's Gone Fishing Expeditions Trial Balance Worksheet December 31, 2019 Adjustments Adjusted Trial Balance Debit Credit Debt Credit Income Samant Credit Statement of Reaming Dabit Credit Balance Sheet Debut Credit Unadusted Trial Balance Debat Credit 8.650 6.980 10 6300 5500 17250 15,000 30.000 95.000 125.000 54 770 8.500 Account Cash Accounts receivable ce supplies 9 Prepaid in 10 Nos receivable 11 Crvestments in socks and bonds 12 Pastureland held for ture expansion 13 Land 14 Buildings 15 18 Accumulated depreciation payable 18 Salaries ayati 19 Acorved peres 20 Accrued real estates 21 Ureamed revenue customer downpayments 22 Nos payable line of credit 23 Long Term loans payable 24 Commen och 25 Retained emings 26 Dividends 28 Balansense 20 Payroll taxes Employee benefits 31 Renterpan 32 Advertisingepens 4880 525 1678 5000 35 000 50.000 6760 20,000 502.000 332.500 2015 31225 6.800 3.200 34 Once supplements 35 Gas, full 36 Repairs and maintenance pense 225 2.765 38 Uspense 30 Deprecationement 40 Travels 42 Total 43 Net income A4 5200 500 755,115 755,115 TBS worksheet Dance Sheet State of cam Income Statement Closing Entries MacBook Pro esc B FH A Home Insert Draw Page Layout Formulas Data Review View Tell me D Arial v 11 - A A Wrap Test Custom Insert Paste 28 OEM Delete w B IU A O Merge & Center $% 9 Conditional Format Cell Formatting as Table Styles Sort & Format ER fix B C D G H L M N 1.125 4.400 2825 2,765 5200 600 755,115 755,115 Debit Credit A 33 Insurance expense 34 Once supplies expense 35 Gas, Fuel & Oil 36 Repairs and maintenance expense 37 Real estate taxes 38 Unisex 39 Depreciation-coulement 40 Travel expense 41 rest expense 42 Totals 43 Net income 44 45 Ending retained samings 40 47 48 Adjusting Entries 49 50 51 52 53 54 55 56 57 58 59 60 81 62 63 64 65 66 67 68 89 70 74 72 73 74 75 Instructions TB worksheet Balance Sheet State of Rel Income Statement Closing Entries MacBook Pro Arial v AA 29 Wrap Text Custom Insert BIU A Marge A Center S Delete $% Conditional Format Cell Formatting as Table Styles It Form XV for B D F H J K 56 57 58 59 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 78 77 The annual premium for the insurance policy was paid on August 1, 2019 for $6,300 and posted to prepaid insurance 78 79 The office supplies were counted on 12-31.10 and had a balance of $550 RO 81 The sales & administrative staff have salaries of $350 per day and the guides have salaries of $725 a day 82 The last payroll paid was on Monday December 30, 2019 for period ending Wednesday December 25, 2019 83 Assume that everyone works a six day work week for this problem. Sundays are not work days 84 85 Depreciation for 2019 is $22.800 86 87 The actual customer downpayment of at 12-31-19 are $9,850. 88 89 The 2018 real estate taxes were paid in 2019 for the amount of $5,600. The 2019 real estate taxes will be so paid in 2020. The 2019 real estate taxes are expected to be 5% more than 2018 91 92 93 This information is not for adjusting entries. balance sheet only 94 95 Current portion of long term det $5.500 how much they have to pay for the coming yen 96 97 35000 on balance sheets gets broken into current and noncurrent liabies 90 Instructions TB worksheet Balance Sheet State of Re Em Income Statement Closing Entries MacBook Pro HUILE UL FOLLOW ULU Inser Arial 11 2 Wrap Text General DNE Paste B IU EE Merge & Center $% -0% Conditional Format Cell Formatting as Table Styles Form H35 |-- B D E . N 0 O R S Complete the adjusting entries and trw balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the boners for cross reference, or you will not be able to foot across in excel Here are two hopul excel youtube videos to help you with the excel portion of the product https://www.youtube.com/watch?v=DokhuLb60 https://www.youtube.comwatchvinalWCWSM 8 For examples of adusting entries, please see pages 137-139 9 remember to show a description for each of the entries 10 remember how the accounts should be entered to show debits and credits 12 Complete a classified balance sheet 13 For an example of a completed class Ted balance sheet, please see page 12 & 142 Be sure to place your 5 and underines in the proper places 15 16 Complete a statement of retained earnings For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) 18 Be sure to place your $ and underlines in the proper places 19 20 Complete an Income statement (single step) 21 For an example of a completed income statement, please see page 17 & 142 22 Be sure to place your $ and underlines in the proper places 23 24 25 Remember which financial statement must be done first to get the proper numbers Hint see page 26 & 142 for help on how the statements are interconnected 27 29 Complete the necessary closing entries for year end 30 For examples of closing entries, please see Cornerstone 3.7 remember to show a description for each of the entries 32 remember how the accounts should be errored to show debits and credits 33 34 35 36 37 38 19 40 41 44 45 45 Instructions TB worksheet Balance Sheet State of Ret Earn Income Statement Closing Entries + L N P Gus's Gone Fishing Expeditions Balance Sheet December 31, 2019 5 Assets Current assets 7 8 9 10 11 12 13 14 15 16 17 18 Long-term investments 19 Plane assets 21 22 23 24 25 25 27 28 29 30 31 32 33 34 35 36 Liabilities and Equity Current liabilities 38 39 40 42 43 Long-term liabilities 44 45 Stockholders Equity 49 50 51 52 Instructions TB worksheet Balance Sheet State of Ret Earn Income Statement Closing Entries A4 D E F G Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year Ended December 31, 2019 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 31 34 35 36 37 38 39 40 42 43 44 45 46 47 Formatting E31 AB K M N 0 C D Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2019 2 3 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 36 36 37 38 39 40 41 42 43 44 45 Merge & Center Conditional Formal Formatting as Table F44 F G H K L M N Deba Credit A Closing Entries 2 3 Fees Earned Income Summary 5 Close Revenue accounts 6 7 Income Summary B Salaries expense 9 Payrol taxes 10 Employee benefits 11 Rent expense 12 Advertising expense 13 Insurance expense 14 Ofice supplies expense 15 Gas, Fuel & OR 16 Repairs and maintenance expense 17 Real estate taxes 18 Us expense 19 Depreciation equipment 20 Travel expense 21 Interest expense 22 Close Expense accounts 23 24 Income Summary 25 Retained Earrings 28 Close Income Summary 27 28 Retained Earnings 29 Dividends 30 Close Dividends 31 32 34 35 36 37 38 39 40 41 42 43 45 46 Instructions TB Worksheet Balance Sheet State of Ret Eam Income Statement Closin Entries Autore BU Trial Balance Project - Seed to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 11 Custom A A a. Au y. O. 4 E $% 25 FI es Cardio For Cell Formatges obre les A H M o P Q R 9 BU on Fire Expo Tria Bolonce w MTB D De Stret Eng Det D DER C 120 5.000 1 PRE 10 11 12 Pond 13 10 15 E 14 B 1 RECORD 95.000 4.77 19 20 Ft 21 14.780 23 42.680 25 Red 20 D 27 28 ES 31 12 ce Mhes 26 31225 13 17 More De 600 02 4 IN Autore Trial Balance Project - Seed to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial Custom 11 A A AA Y O Delete EE Morge & Cart S% Sant FAS Cerden Forum Call for Tobieles EB A F C D M M N QR u 40 g 4 50 91 S2 S SP 12 91 61 Ne att det lopment, Decame in when I 2016 Sep 2017 The 2019 te 22. The 2018 sedadla berean 2018 EISE: WO Em To wordt Con ON Autore Tral Balance Project - Saved to my Mee Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 11 Gane - A A A PINS Coronel For Call Farming Trees MOS A C Q K N 0 PO R T U V V 2 A Completing entries and worksheet For encargo of a completed he worksheets 315 De no puede trofee or you were bote to the Here are cutest the portion of the Profit Www ye.com www youtube.com For examples of acting entries.reise seg 137.139 Forever o show description for each of the enties Ferrer How to write sur terred to Sondres For or are acord casifed benesest peast 1262 Be sure to be your orders in the replace Carreframe For a target code tored Earros, sep228142 ore ) Be sure tope you and underlines in the proper places Come on hoonestamos Bee you sondes noce Formarea condone. Press 17412 Remember in fronciertos de refrotto the proper runters M19 20 2 tow to removed Correctory of your For more persona Ferrero Show contact for 0 4 41 TB Wors Autore BEU Til Balance Project Home insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial A A 28-0. 4 Delete Morge & Co S% 25 Sant Cerca per Call formatie Tore you FINS BE A3 12/01/2019 T w Y 2 A A GP Asses Login Last and Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Arial - 11 A Y. O S% 25 Cerca per Call formatives Delete For Sant FAS BE A4 A c F K M N 0 P Q R. T FER Best Red Ering GB Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Arial 11 A Custom O. 4 Delete Morge & Co $% 25 SE Cerca per Call Formatines Tobie styles E31 AB F H K M N O P R A T U V W OF Express For the Year Ended December 11.2019 1 Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial A A a. Au General $% 28-04 25 Delete Form San Cerca per Call formatie Tore you FAS BE 744 A F a M O Q 9 T U V W C D E OLCrede F Em 8 cupere 99 Er 1 12 A 13 100 160. FOOL 14 Pro 17Pool 10 18 Deprecated: 20 por 21. 24 ore 25 28 Chosen RE IN Winter Custom LINU Delete BI P A Merge & Center $% Conditional Format Cell Formatting as Table Styles Format Sort & Fier Find a Select X . B C . L M N D G Gus's Gone Fishing Expeditions Trial Balance Worksheet December 31, 2019 Adjustments Adjusted Trial Balance Debit Credit Debt Credit Income Samant Credit Statement of Reaming Dabit Credit Balance Sheet Debut Credit Unadusted Trial Balance Debat Credit 8.650 6.980 10 6300 5500 17250 15,000 30.000 95.000 125.000 54 770 8.500 Account Cash Accounts receivable ce supplies 9 Prepaid in 10 Nos receivable 11 Crvestments in socks and bonds 12 Pastureland held for ture expansion 13 Land 14 Buildings 15 18 Accumulated depreciation payable 18 Salaries ayati 19 Acorved peres 20 Accrued real estates 21 Ureamed revenue customer downpayments 22 Nos payable line of credit 23 Long Term loans payable 24 Commen och 25 Retained emings 26 Dividends 28 Balansense 20 Payroll taxes Employee benefits 31 Renterpan 32 Advertisingepens 4880 525 1678 5000 35 000 50.000 6760 20,000 502.000 332.500 2015 31225 6.800 3.200 34 Once supplements 35 Gas, full 36 Repairs and maintenance pense 225 2.765 38 Uspense 30 Deprecationement 40 Travels 42 Total 43 Net income A4 5200 500 755,115 755,115 TBS worksheet Dance Sheet State of cam Income Statement Closing Entries MacBook Pro esc B FH A Home Insert Draw Page Layout Formulas Data Review View Tell me D Arial v 11 - A A Wrap Test Custom Insert Paste 28 OEM Delete w B IU A O Merge & Center $% 9 Conditional Format Cell Formatting as Table Styles Sort & Format ER fix B C D G H L M N 1.125 4.400 2825 2,765 5200 600 755,115 755,115 Debit Credit A 33 Insurance expense 34 Once supplies expense 35 Gas, Fuel & Oil 36 Repairs and maintenance expense 37 Real estate taxes 38 Unisex 39 Depreciation-coulement 40 Travel expense 41 rest expense 42 Totals 43 Net income 44 45 Ending retained samings 40 47 48 Adjusting Entries 49 50 51 52 53 54 55 56 57 58 59 60 81 62 63 64 65 66 67 68 89 70 74 72 73 74 75 Instructions TB worksheet Balance Sheet State of Rel Income Statement Closing Entries MacBook Pro Arial v AA 29 Wrap Text Custom Insert BIU A Marge A Center S Delete $% Conditional Format Cell Formatting as Table Styles It Form XV for B D F H J K 56 57 58 59 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 78 77 The annual premium for the insurance policy was paid on August 1, 2019 for $6,300 and posted to prepaid insurance 78 79 The office supplies were counted on 12-31.10 and had a balance of $550 RO 81 The sales & administrative staff have salaries of $350 per day and the guides have salaries of $725 a day 82 The last payroll paid was on Monday December 30, 2019 for period ending Wednesday December 25, 2019 83 Assume that everyone works a six day work week for this problem. Sundays are not work days 84 85 Depreciation for 2019 is $22.800 86 87 The actual customer downpayment of at 12-31-19 are $9,850. 88 89 The 2018 real estate taxes were paid in 2019 for the amount of $5,600. The 2019 real estate taxes will be so paid in 2020. The 2019 real estate taxes are expected to be 5% more than 2018 91 92 93 This information is not for adjusting entries. balance sheet only 94 95 Current portion of long term det $5.500 how much they have to pay for the coming yen 96 97 35000 on balance sheets gets broken into current and noncurrent liabies 90 Instructions TB worksheet Balance Sheet State of Re Em Income Statement Closing Entries MacBook Pro HUILE UL FOLLOW ULU Inser Arial 11 2 Wrap Text General DNE Paste B IU EE Merge & Center $% -0% Conditional Format Cell Formatting as Table Styles Form H35 |-- B D E . N 0 O R S Complete the adjusting entries and trw balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the boners for cross reference, or you will not be able to foot across in excel Here are two hopul excel youtube videos to help you with the excel portion of the product https://www.youtube.com/watch?v=DokhuLb60 https://www.youtube.comwatchvinalWCWSM 8 For examples of adusting entries, please see pages 137-139 9 remember to show a description for each of the entries 10 remember how the accounts should be entered to show debits and credits 12 Complete a classified balance sheet 13 For an example of a completed class Ted balance sheet, please see page 12 & 142 Be sure to place your 5 and underines in the proper places 15 16 Complete a statement of retained earnings For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) 18 Be sure to place your $ and underlines in the proper places 19 20 Complete an Income statement (single step) 21 For an example of a completed income statement, please see page 17 & 142 22 Be sure to place your $ and underlines in the proper places 23 24 25 Remember which financial statement must be done first to get the proper numbers Hint see page 26 & 142 for help on how the statements are interconnected 27 29 Complete the necessary closing entries for year end 30 For examples of closing entries, please see Cornerstone 3.7 remember to show a description for each of the entries 32 remember how the accounts should be errored to show debits and credits 33 34 35 36 37 38 19 40 41 44 45 45 Instructions TB worksheet Balance Sheet State of Ret Earn Income Statement Closing Entries + L N P Gus's Gone Fishing Expeditions Balance Sheet December 31, 2019 5 Assets Current assets 7 8 9 10 11 12 13 14 15 16 17 18 Long-term investments 19 Plane assets 21 22 23 24 25 25 27 28 29 30 31 32 33 34 35 36 Liabilities and Equity Current liabilities 38 39 40 42 43 Long-term liabilities 44 45 Stockholders Equity 49 50 51 52 Instructions TB worksheet Balance Sheet State of Ret Earn Income Statement Closing Entries A4 D E F G Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year Ended December 31, 2019 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 31 34 35 36 37 38 39 40 42 43 44 45 46 47 Formatting E31 AB K M N 0 C D Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2019 2 3 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 36 36 37 38 39 40 41 42 43 44 45 Merge & Center Conditional Formal Formatting as Table F44 F G H K L M N Deba Credit A Closing Entries 2 3 Fees Earned Income Summary 5 Close Revenue accounts 6 7 Income Summary B Salaries expense 9 Payrol taxes 10 Employee benefits 11 Rent expense 12 Advertising expense 13 Insurance expense 14 Ofice supplies expense 15 Gas, Fuel & OR 16 Repairs and maintenance expense 17 Real estate taxes 18 Us expense 19 Depreciation equipment 20 Travel expense 21 Interest expense 22 Close Expense accounts 23 24 Income Summary 25 Retained Earrings 28 Close Income Summary 27 28 Retained Earnings 29 Dividends 30 Close Dividends 31 32 34 35 36 37 38 39 40 41 42 43 45 46 Instructions TB Worksheet Balance Sheet State of Ret Eam Income Statement Closin Entries Autore BU Trial Balance Project - Seed to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 11 Custom A A a. Au y. O. 4 E $% 25 FI es Cardio For Cell Formatges obre les A H M o P Q R 9 BU on Fire Expo Tria Bolonce w MTB D De Stret Eng Det D DER C 120 5.000 1 PRE 10 11 12 Pond 13 10 15 E 14 B 1 RECORD 95.000 4.77 19 20 Ft 21 14.780 23 42.680 25 Red 20 D 27 28 ES 31 12 ce Mhes 26 31225 13 17 More De 600 02 4 IN Autore Trial Balance Project - Seed to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial Custom 11 A A AA Y O Delete EE Morge & Cart S% Sant FAS Cerden Forum Call for Tobieles EB A F C D M M N QR u 40 g 4 50 91 S2 S SP 12 91 61 Ne att det lopment, Decame in when I 2016 Sep 2017 The 2019 te 22. The 2018 sedadla berean 2018 EISE: WO Em To wordt Con ON Autore Tral Balance Project - Saved to my Mee Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 11 Gane - A A A PINS Coronel For Call Farming Trees MOS A C Q K N 0 PO R T U V V 2 A Completing entries and worksheet For encargo of a completed he worksheets 315 De no puede trofee or you were bote to the Here are cutest the portion of the Profit Www ye.com www youtube.com For examples of acting entries.reise seg 137.139 Forever o show description for each of the enties Ferrer How to write sur terred to Sondres For or are acord casifed benesest peast 1262 Be sure to be your orders in the replace Carreframe For a target code tored Earros, sep228142 ore ) Be sure tope you and underlines in the proper places Come on hoonestamos Bee you sondes noce Formarea condone. Press 17412 Remember in fronciertos de refrotto the proper runters M19 20 2 tow to removed Correctory of your For more persona Ferrero Show contact for 0 4 41 TB Wors Autore BEU Til Balance Project Home insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial A A 28-0. 4 Delete Morge & Co S% 25 Sant Cerca per Call formatie Tore you FINS BE A3 12/01/2019 T w Y 2 A A GP Asses Login Last and Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Arial - 11 A Y. O S% 25 Cerca per Call formatives Delete For Sant FAS BE A4 A c F K M N 0 P Q R. T FER Best Red Ering GB Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Arial 11 A Custom O. 4 Delete Morge & Co $% 25 SE Cerca per Call Formatines Tobie styles E31 AB F H K M N O P R A T U V W OF Express For the Year Ended December 11.2019 1 Autore Til Balance Project Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial A A a. Au General $% 28-04 25 Delete Form San Cerca per Call formatie Tore you FAS BE 744 A F a M O Q 9 T U V W C D E OLCrede F Em 8 cupere 99 Er 1 12 A 13 100 160. FOOL 14 Pro 17Pool 10 18 Deprecated: 20 por 21. 24 ore 25 28 Chosen RE IN
