completing multi step income statement
ACET 2021 PROJECTE Amating Company insonlary 1, 2015, and is now in its fourth year of operation. It is a real sales company with awe amount of online The used trial balancest of December 31, 2019 appears below along with prior yaralance sheet data and some additional transaction data for 2018 AMANG COWW Add Trial Balance 12/1/29 7 Account 2013 Adjud Trillante Debit Credit 120.000 55.000 5.000 46,000 2018 Post Closing dance Det Credi 125.600 15,000 6.000 $ 15.00 61.000 59.000 47.000 21.000 30 11 12 13 14 15 16 12 18 20 29 21 22 23 24 ca Accounts Recevable Pred wo One Machinery Tools lented Depreciation CORP sasa we Note Pastor CS 310 Retete Divided 5 2000 12.200 2.600 2,000 31.000 240,000 36.000 16,00 2.700 4.000 12.300 1600 23.600 2.600 10.000 240,000 Contro 1 201 22 23 ant 13729 Le 30 12011 32 31.00 1.100 1000 L300 f M con S403 337400 210.200 2010 L000 Trata20 these were included in the tranche) ce exams Greece Income tamen Balance Sheet ont of Cash Flows Select destination and press ENTER or choose Porta Rocket And PE ce Formatting Use Destination Theme Match Destination Fe $ 4 % 5 & 7 6 8 9 E R T Y U 0 P F I L B. N M . 10.000 240,000 Dividends Sales Revue Cost of Goods Sold ant Series Expense insince pense Legal Fees Depreciation Experte Interest Expense Income Tax Experte 132,6001 20.000 36.000 11,800 9,200 5.000 1,800 000 577.400 $ $ 577,4005 250,200 250, 200 Transaction Dua for 2019 (Note, these transactions were included in the trial balance numbers above Cash pd for purchase of officer $ Cach paid for purchase tools Acquisition of Machinery with Notes Payablete Payment on Long Term Debt Cash payment of dividends Cathrice from Kance of 10.000 shares of common stock + 6,000 30.000 38.000 7 10.000 30.000 Requirements: See sheet tabs at bottom. Use each sheet for the following 7 use Excel in completing these ruments. You must emulas and function, reference, and so forte #8 1. Using examples from your textbook or online research prepare the Panama Pajama Company must income statement for the war ended Oecember 31, 2015 Ind 23 Niso indude a vertical analysis column at the right and perform a wical analysis of the income statement (Use percentage Format with damai place 50 2. Prepare the Panama Pajama Company balance sheet for December 31, 2015. Indude a verticalisco 51 and perform a vertical analysis of the balance sheet. Use the percentage format with a ce 52 3. Prepare the Panama Pema Company statement of cash flows for the year ended December 11, 2019, the induct methot Yese tattoos emale or 4. Complete the analysis of the financial statements as Grected on the Analysis sheet. Use percentage format where anate with 2 comece 54 5. Complete the analys of the investment options between this company and EBU (ratas given. Also use the chart from the anached artido, and any other source to 55 56 57 se 59 60 Instructions Income Statement Balance Sheet Stunt of Cash Flow Analytin Stock Investment Analysis Select destination and press ENTER or choose Paste 25 atting Use Destination Theme Match Destination Fo l & 7 4 5 6 8 9 0 R. 0 Y U T F G H J 17/11/19 Account Title 7 t 8 9 10 11 12 Work 13 5 $ 15 16 17 18 19 20 21 22 Cash Accounts Receivable Prepaid insurance Inventory Office Equipment Machinery Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common stock, 510 por Retained in Dividende Sales Revenue Cost of Good Sold 2019 Adjusted Trace Debit Credit 120.000 55.000 5.000 46,000 63.000 59000 5 21.000 12.200 2,600 2.000 31,000 240.000 28,600 10,000 240.000 132.600 20,000 30.000 11.800 3,200 5,000 1.800 3.000 577,400 57300 2018 Post Closing Trance Debit Credit 125,600 15.000 6,000 15.600 47,000 21.000 16,000 16.00 2,700 4.000 22.100 160,000 m 24 25 WC (M 26 27 Inexpense Deco Expo Interest Income Tax $ 2000 210,200 34 35 36 37 38 6.000 10.000 18.000 40 41 Transaction Data for 2018 Note, these transactions were included in the trial balance number one Cash paid for purchawafaiement $ Cash paid for purchase of tools Acquisition of Machinery with lots Payable-long term Payment on Long Terme Cash payment of ends Cathecept from 10.00 hod 10.000 30.000 e exam 44 Instruction Balance Sheet Point 25 Paste 70 Number -B Format as Table Coll Styles Cells Editing SUM XV fx =instructions! B D G 6 Adjusted Trial Balance 12/31/19 Account Title 10 11 12 5 14 15 16 17 28 19 20 21 22 23 Cash Accounts Receivable Prepaid inwrance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Satarles Payable Sales Tax Payable Nate Payable-long Term Common Stock, $10 por Retained farnings Dividends Sales Revenge Cast of Goods Sold Rent Expense Salaries pense Insurance Expense Lew Tees Depreciation Expert Interar pe Income Tax Expert 2019 Adjusted Trial Balance Debit Credit $ 120,000 55.000 5,000 46,000 63,000 $9,000 $ 21,000 12.200 2,600 2,000 31000 240,000 26,600 10,000 240,000 132,600 20,000 36.000 180 9,200 5.000 1,800 3.000 S 577,400 $ 577.4003 2018 Post-Closing Trial Balance Debit Credit 125,600 35,000 6,000 15,600 47,000 21,000 16,000 16,800 2,700 4,000 22,100 160,000 28,600 cha 24 25 26 27 29 30 11 32 33 34 35 36 37 250,200 250,200 11 39 40 Transaction Data for 2019 Note, the transactions were included in the trial balance numbers above Cash paid for purchase of office equipment IS 6.000 Cash paid for purchase of cools 10,000 Aguilution of Machinery with Notes Pictory.com 38.000 Payment on Long Term Debt 2 Casament of dividends 10 000 Cach recept romance of 10.000 shares of common stock 80,000 Instructions Income talent Balance Sheet Som of Cash Flow Analysis Pont 42 2 exames Stock investment Analysis . ACET 2021 PROJECTE Amating Company insonlary 1, 2015, and is now in its fourth year of operation. It is a real sales company with awe amount of online The used trial balancest of December 31, 2019 appears below along with prior yaralance sheet data and some additional transaction data for 2018 AMANG COWW Add Trial Balance 12/1/29 7 Account 2013 Adjud Trillante Debit Credit 120.000 55.000 5.000 46,000 2018 Post Closing dance Det Credi 125.600 15,000 6.000 $ 15.00 61.000 59.000 47.000 21.000 30 11 12 13 14 15 16 12 18 20 29 21 22 23 24 ca Accounts Recevable Pred wo One Machinery Tools lented Depreciation CORP sasa we Note Pastor CS 310 Retete Divided 5 2000 12.200 2.600 2,000 31.000 240,000 36.000 16,00 2.700 4.000 12.300 1600 23.600 2.600 10.000 240,000 Contro 1 201 22 23 ant 13729 Le 30 12011 32 31.00 1.100 1000 L300 f M con S403 337400 210.200 2010 L000 Trata20 these were included in the tranche) ce exams Greece Income tamen Balance Sheet ont of Cash Flows Select destination and press ENTER or choose Porta Rocket And PE ce Formatting Use Destination Theme Match Destination Fe $ 4 % 5 & 7 6 8 9 E R T Y U 0 P F I L B. N M . 10.000 240,000 Dividends Sales Revue Cost of Goods Sold ant Series Expense insince pense Legal Fees Depreciation Experte Interest Expense Income Tax Experte 132,6001 20.000 36.000 11,800 9,200 5.000 1,800 000 577.400 $ $ 577,4005 250,200 250, 200 Transaction Dua for 2019 (Note, these transactions were included in the trial balance numbers above Cash pd for purchase of officer $ Cach paid for purchase tools Acquisition of Machinery with Notes Payablete Payment on Long Term Debt Cash payment of dividends Cathrice from Kance of 10.000 shares of common stock + 6,000 30.000 38.000 7 10.000 30.000 Requirements: See sheet tabs at bottom. Use each sheet for the following 7 use Excel in completing these ruments. You must emulas and function, reference, and so forte #8 1. Using examples from your textbook or online research prepare the Panama Pajama Company must income statement for the war ended Oecember 31, 2015 Ind 23 Niso indude a vertical analysis column at the right and perform a wical analysis of the income statement (Use percentage Format with damai place 50 2. Prepare the Panama Pajama Company balance sheet for December 31, 2015. Indude a verticalisco 51 and perform a vertical analysis of the balance sheet. Use the percentage format with a ce 52 3. Prepare the Panama Pema Company statement of cash flows for the year ended December 11, 2019, the induct methot Yese tattoos emale or 4. Complete the analysis of the financial statements as Grected on the Analysis sheet. Use percentage format where anate with 2 comece 54 5. Complete the analys of the investment options between this company and EBU (ratas given. Also use the chart from the anached artido, and any other source to 55 56 57 se 59 60 Instructions Income Statement Balance Sheet Stunt of Cash Flow Analytin Stock Investment Analysis Select destination and press ENTER or choose Paste 25 atting Use Destination Theme Match Destination Fo l & 7 4 5 6 8 9 0 R. 0 Y U T F G H J 17/11/19 Account Title 7 t 8 9 10 11 12 Work 13 5 $ 15 16 17 18 19 20 21 22 Cash Accounts Receivable Prepaid insurance Inventory Office Equipment Machinery Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common stock, 510 por Retained in Dividende Sales Revenue Cost of Good Sold 2019 Adjusted Trace Debit Credit 120.000 55.000 5.000 46,000 63.000 59000 5 21.000 12.200 2,600 2.000 31,000 240.000 28,600 10,000 240.000 132.600 20,000 30.000 11.800 3,200 5,000 1.800 3.000 577,400 57300 2018 Post Closing Trance Debit Credit 125,600 15.000 6,000 15.600 47,000 21.000 16,000 16.00 2,700 4.000 22.100 160,000 m 24 25 WC (M 26 27 Inexpense Deco Expo Interest Income Tax $ 2000 210,200 34 35 36 37 38 6.000 10.000 18.000 40 41 Transaction Data for 2018 Note, these transactions were included in the trial balance number one Cash paid for purchawafaiement $ Cash paid for purchase of tools Acquisition of Machinery with lots Payable-long term Payment on Long Terme Cash payment of ends Cathecept from 10.00 hod 10.000 30.000 e exam 44 Instruction Balance Sheet Point 25 Paste 70 Number -B Format as Table Coll Styles Cells Editing SUM XV fx =instructions! B D G 6 Adjusted Trial Balance 12/31/19 Account Title 10 11 12 5 14 15 16 17 28 19 20 21 22 23 Cash Accounts Receivable Prepaid inwrance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Satarles Payable Sales Tax Payable Nate Payable-long Term Common Stock, $10 por Retained farnings Dividends Sales Revenge Cast of Goods Sold Rent Expense Salaries pense Insurance Expense Lew Tees Depreciation Expert Interar pe Income Tax Expert 2019 Adjusted Trial Balance Debit Credit $ 120,000 55.000 5,000 46,000 63,000 $9,000 $ 21,000 12.200 2,600 2,000 31000 240,000 26,600 10,000 240,000 132,600 20,000 36.000 180 9,200 5.000 1,800 3.000 S 577,400 $ 577.4003 2018 Post-Closing Trial Balance Debit Credit 125,600 35,000 6,000 15,600 47,000 21,000 16,000 16,800 2,700 4,000 22,100 160,000 28,600 cha 24 25 26 27 29 30 11 32 33 34 35 36 37 250,200 250,200 11 39 40 Transaction Data for 2019 Note, the transactions were included in the trial balance numbers above Cash paid for purchase of office equipment IS 6.000 Cash paid for purchase of cools 10,000 Aguilution of Machinery with Notes Pictory.com 38.000 Payment on Long Term Debt 2 Casament of dividends 10 000 Cach recept romance of 10.000 shares of common stock 80,000 Instructions Income talent Balance Sheet Som of Cash Flow Analysis Pont 42 2 exames Stock investment Analysis
