Formuning om Update Top up-to-date with security updat e s and improvements. Choose Check for Updates A B C D E F 2 Complete the adjusting entries and trial balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the letters for cross reference, or you will not be able to foot across in excel) Here are two helpful excel youtube videos to help you with the excel portion of the product: https://www.youtube.com/watch?v=Dq4khluLb6Q https://www.youtube.com/watch?v=1naWCWIS14 For examples of adjusting entries, please see pages 137-139 remember to show a description for each of the entries 11 Complete a classified balance sheet For an example of a completed classified balance sheet, please see page 12 & 142 Be sure to place your and underlines in the proper places 14 15 Complete a statement of retained earnings 16 For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) Be sure to place your $ and underlines in the proper places 19 Complete an income statement (single step) For an example of a completed income statement, please see page 17 & 142 Be sure to place your and underlines in the proper places 22 23 24. Remember which financial statement must be done first to get the proper numbers Hint see page 26 6 142 for help on how the statements are interconnected slock ^ Trial Balance Project View Home Insert .XO Copy Page Layout Ariel Formulas Data 11 . AA Review = 9. Wrap Text Date - Merge & Center. $ . % ) Office Update To keep up-to-date with security updates, fees, and improvements, choose Check for Updates x fx AA Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year End December 2017 PEPERIENZERRRRRRRRRRRRR T worksheet Balance she come Statement State of Rut Earn General $ . % Home Insert Page Layout Formulas Data Review View Xcut Arial - 11 - A- A = = = = Wrap Text Copy Paste BIU Merge & Center Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, ; v ft D E F G Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2017 TB worksheet Balance Sheet Income Statement State of Ret Earn instructions Ready Gus's Gone Fishing Expeditions Balance Sheet December 31, 2017 Assets Current assets REPRENORRRRRRRRRRR 599 300 Llabilities and Equity Current Bannes TB worksheet Balance Sheet Income Statement State of Ret Earn Instructions Ready 5 Xfx Gu's Gone Fishing Expeditions Trial Balance Worksheet December 31, 2017 Adiustments Adjusted T Balance Unadivsted Trial Balance restments in stocks and bonds TI Accumulated depreciation TI IIIIIIIIIIIIII Swansea 20 Acordes IIIIII TB worksheetBalance Sheet Income Statement State of Ret Earn Instructions Ready esc The premium for the ne w s on October 1, 2017 for $5.280 and posted to pres 79 The ofice supplies were counted on 12-31-17 and had a balance of 5445 w 1 The h ares of $125 per day and we have of $750 a day B2 The last povoad was on Friday Dec 2017 for ending Tuesday December 26, 2017 83 Aswameha everyone wants work well for this problem. Sunderwent work days s Derecho or 2017 12 00 87 The w omer down 123119 The 2018 res estales were in 2017 for amount of 4.200 The 2017 50 2015 The 2017 50 This is not for g e SESEBB och TB worksheet Balance Sheet income Statement State of Ret Earn instructions Ready esc w A A- - - wrap " A BIV . Mergea cum $ % ) Conditional Format Orice Update To keep up-to-date with l e ss and improvements, choo Check for Updates H I L F G Qur's Gone Fishing Expeditions Teal Balance Worksheet December 31, 2017 Adjustments Adjusted Trial Balance Unadjusted Tris Balance income Samant Statement of Ret Earnings Balance Sheet 120 11 Investments in stocks and bonds 17250 15 000 30.000 125,000 10 Accumulated depreciation 17 Accounts payable 18 Saares payable 19 Accrued payroll taxes 20 Accrued as the 21 Uneamed revenue - Customer downpayment 22 Notes payable - line of credit 23 Long term loans payable 5.000 28 S oupes 29 Payrolles 30 Employee benefits 31 Rent expense 32 Advertising expense 33 Insurance expense 34 Omice supues expense 35 Gas Fuel & worksheet Balance Sheet o n Statement MacBook Pro SDFGHJ B control option command Trial Balance Project Insert X Page Layout A Formulas . . . Review - Home . Paste Om 075 Data A A View - A Test were center S. % ) Condicional Format Update To keep up to date with security and proven choose Check for Updates 77 The annual premium for the insurance policy was paid on October 1, 2017 for $6.280 and posted to prepaid insurance 79 The office supplies were counted on 12-31.17 and had a balance of $445 81 The Sales & adminstrative staff have salaries of $325 per day and the guides have salaries of $750 a day 82 The last payroll paid was on Friday December 29, 2017 for period ending Tuesday December 26, 2017 83 Assume that everyone works asix day work week for this problem. Sundays are not work days 65 Depreciation for 2017 is $20 300 87 The actual customer downpayments of 12-31-17 are $9 850 89 The 2016 real estate taxes were paid in 2017 for the amount of $4,200. The 2017 real estate taxes will be 90 paid in 2018. The 2017 real estate taxes are expected to be 5% more than 2016 93 This information is not for adjusting entries balance sheet only 95 Current portion of long-term debit $5.500 how much they have to pay for the coming year 5500 and 29500 35000 on balance sheets gats broken into current and noncurrent abilities ce we | s | 0 | F | G | H e s, and improvements, choose Check for Updates U A30 - W x Liabilities and Equity X f AB H D E F G Gus's Gone Fishing Expeditions Balance Sheet December 31, 2017 Assets Current assets Long-term investments Plant assets TR Sheet incomu m ut MacBook Pro % 5 6 R QwE 1 Asolol caps lock z command Home neert Page Layout Til Balance Project Formulas Data Review View - copy Forma Wie Text Custom Om Update T w ithout aites and out drome choose Check for 130 f D E F G H Liabilities and Equity Current liabilities Long-term liabilities Stockholders Equity 7 lock zxcvlon 11 - AA o copy Once Update Too wth and chochor Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2017 . om de to o u r dates and improvements, choose Check for Updates Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year Ended December 31, 2017 AsololH 11. AA- * = - $ ) Condioral Format e with security and Once Update To t 135 XF movements, choose Check for Updates A B C G H I J K 2 Complete the adjusting entries and trial balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the letters for cross reference, or you will not be able to foot across in excel) Here are two helpful excel youtube videos to help you with the excel portion of the product: https://www.youtube.com/watch?v=Dq4khIULb6Q https://www.youtube.com/watch?v=1naWCWS14 For examples of adjusting entries, please see pages 137-139 remember to show a description for each of the entries 11 Complete a classified balance sheet For an example of a completed classified balance sheet, please see page 12 & 142 Be sure to place your $ and underlines in the proper places 15 Complete a statement of retained earnings For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) Be sure to place your $ and underlines in the proper places 19 Complete an income statement (single step) For an example of a completed income statement, please see page 17 & 142 Be sure to place your $ and underlines in the proper places N 24 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 WERTYU lock z | xcvb N ontrol option command Formuning om Update Top up-to-date with security updat e s and improvements. Choose Check for Updates A B C D E F 2 Complete the adjusting entries and trial balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the letters for cross reference, or you will not be able to foot across in excel) Here are two helpful excel youtube videos to help you with the excel portion of the product: https://www.youtube.com/watch?v=Dq4khluLb6Q https://www.youtube.com/watch?v=1naWCWIS14 For examples of adjusting entries, please see pages 137-139 remember to show a description for each of the entries 11 Complete a classified balance sheet For an example of a completed classified balance sheet, please see page 12 & 142 Be sure to place your and underlines in the proper places 14 15 Complete a statement of retained earnings 16 For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) Be sure to place your $ and underlines in the proper places 19 Complete an income statement (single step) For an example of a completed income statement, please see page 17 & 142 Be sure to place your and underlines in the proper places 22 23 24. Remember which financial statement must be done first to get the proper numbers Hint see page 26 6 142 for help on how the statements are interconnected slock ^ Trial Balance Project View Home Insert .XO Copy Page Layout Ariel Formulas Data 11 . AA Review = 9. Wrap Text Date - Merge & Center. $ . % ) Office Update To keep up-to-date with security updates, fees, and improvements, choose Check for Updates x fx AA Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year End December 2017 PEPERIENZERRRRRRRRRRRRR T worksheet Balance she come Statement State of Rut Earn General $ . % Home Insert Page Layout Formulas Data Review View Xcut Arial - 11 - A- A = = = = Wrap Text Copy Paste BIU Merge & Center Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, ; v ft D E F G Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2017 TB worksheet Balance Sheet Income Statement State of Ret Earn instructions Ready Gus's Gone Fishing Expeditions Balance Sheet December 31, 2017 Assets Current assets REPRENORRRRRRRRRRR 599 300 Llabilities and Equity Current Bannes TB worksheet Balance Sheet Income Statement State of Ret Earn Instructions Ready 5 Xfx Gu's Gone Fishing Expeditions Trial Balance Worksheet December 31, 2017 Adiustments Adjusted T Balance Unadivsted Trial Balance restments in stocks and bonds TI Accumulated depreciation TI IIIIIIIIIIIIII Swansea 20 Acordes IIIIII TB worksheetBalance Sheet Income Statement State of Ret Earn Instructions Ready esc The premium for the ne w s on October 1, 2017 for $5.280 and posted to pres 79 The ofice supplies were counted on 12-31-17 and had a balance of 5445 w 1 The h ares of $125 per day and we have of $750 a day B2 The last povoad was on Friday Dec 2017 for ending Tuesday December 26, 2017 83 Aswameha everyone wants work well for this problem. Sunderwent work days s Derecho or 2017 12 00 87 The w omer down 123119 The 2018 res estales were in 2017 for amount of 4.200 The 2017 50 2015 The 2017 50 This is not for g e SESEBB och TB worksheet Balance Sheet income Statement State of Ret Earn instructions Ready esc w A A- - - wrap " A BIV . Mergea cum $ % ) Conditional Format Orice Update To keep up-to-date with l e ss and improvements, choo Check for Updates H I L F G Qur's Gone Fishing Expeditions Teal Balance Worksheet December 31, 2017 Adjustments Adjusted Trial Balance Unadjusted Tris Balance income Samant Statement of Ret Earnings Balance Sheet 120 11 Investments in stocks and bonds 17250 15 000 30.000 125,000 10 Accumulated depreciation 17 Accounts payable 18 Saares payable 19 Accrued payroll taxes 20 Accrued as the 21 Uneamed revenue - Customer downpayment 22 Notes payable - line of credit 23 Long term loans payable 5.000 28 S oupes 29 Payrolles 30 Employee benefits 31 Rent expense 32 Advertising expense 33 Insurance expense 34 Omice supues expense 35 Gas Fuel & worksheet Balance Sheet o n Statement MacBook Pro SDFGHJ B control option command Trial Balance Project Insert X Page Layout A Formulas . . . Review - Home . Paste Om 075 Data A A View - A Test were center S. % ) Condicional Format Update To keep up to date with security and proven choose Check for Updates 77 The annual premium for the insurance policy was paid on October 1, 2017 for $6.280 and posted to prepaid insurance 79 The office supplies were counted on 12-31.17 and had a balance of $445 81 The Sales & adminstrative staff have salaries of $325 per day and the guides have salaries of $750 a day 82 The last payroll paid was on Friday December 29, 2017 for period ending Tuesday December 26, 2017 83 Assume that everyone works asix day work week for this problem. Sundays are not work days 65 Depreciation for 2017 is $20 300 87 The actual customer downpayments of 12-31-17 are $9 850 89 The 2016 real estate taxes were paid in 2017 for the amount of $4,200. The 2017 real estate taxes will be 90 paid in 2018. The 2017 real estate taxes are expected to be 5% more than 2016 93 This information is not for adjusting entries balance sheet only 95 Current portion of long-term debit $5.500 how much they have to pay for the coming year 5500 and 29500 35000 on balance sheets gats broken into current and noncurrent abilities ce we | s | 0 | F | G | H e s, and improvements, choose Check for Updates U A30 - W x Liabilities and Equity X f AB H D E F G Gus's Gone Fishing Expeditions Balance Sheet December 31, 2017 Assets Current assets Long-term investments Plant assets TR Sheet incomu m ut MacBook Pro % 5 6 R QwE 1 Asolol caps lock z command Home neert Page Layout Til Balance Project Formulas Data Review View - copy Forma Wie Text Custom Om Update T w ithout aites and out drome choose Check for 130 f D E F G H Liabilities and Equity Current liabilities Long-term liabilities Stockholders Equity 7 lock zxcvlon 11 - AA o copy Once Update Too wth and chochor Gus's Gone Fishing Expeditions Income Statement For the Year Ended December 31, 2017 . om de to o u r dates and improvements, choose Check for Updates Gus's Gone Fishing Expeditions Statement of Retained Earnings For the Year Ended December 31, 2017 AsololH 11. AA- * = - $ ) Condioral Format e with security and Once Update To t 135 XF movements, choose Check for Updates A B C G H I J K 2 Complete the adjusting entries and trial balance worksheet For an example of a completed trial balance worksheet, please see Exhibit 3.18 (Do not put the letters for cross reference, or you will not be able to foot across in excel) Here are two helpful excel youtube videos to help you with the excel portion of the product: https://www.youtube.com/watch?v=Dq4khIULb6Q https://www.youtube.com/watch?v=1naWCWS14 For examples of adjusting entries, please see pages 137-139 remember to show a description for each of the entries 11 Complete a classified balance sheet For an example of a completed classified balance sheet, please see page 12 & 142 Be sure to place your $ and underlines in the proper places 15 Complete a statement of retained earnings For an example of a completed Statement of Retained Earnings, please see page 22 & 142 (Ignore Less: Other) Be sure to place your $ and underlines in the proper places 19 Complete an income statement (single step) For an example of a completed income statement, please see page 17 & 142 Be sure to place your $ and underlines in the proper places N 24 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 WERTYU lock z | xcvb N ontrol option command