ACCT 2023PROJECT 1 Amazing Company began operations on January 1, 2015 and is now in its fourth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2019 appears below, along with prior year balance sheet data and some additional transaction data for 2018. AMAZING COMPANY Adjusted Tral Balance 12/31/15 7 8 Account Tide $ 2019 Adjusted Trial Balance Debit Credit 120,000 55.000 5.000 46000 63,000 10 11 12 13 11 15 16 $ 59.000 2018 Post Closing Trbal Balance Debt Crede 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 5 Accounts Recevable Prepaid insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Sales Payable Sales Tax Payable Nota Payable-long Tem Common Stock 510 par Retained Caming Dividends Sales Revenue Cost of Goods Sold Rent Expense Salas peni Insurance Expertise Legal Fees Depreciation Expense interest Expense income Tax Expense 11 19 20 21 21,000 12,200 2,600 2.000 11,000 260,000 28.600 10,000 240,000 27 20 30 132,600 20,000 36,000 11,300 9.200 5,000 1,800 32 3.000 $ 377.400 M 35 36 37 377.4005 250,200 250,200 5 39 LO Transaction Data for 2019 Note, these transactions were included in the trial balance numbers above) Cash paid for purchase of office equiment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable-longhem Payment on Long Tam Debt Cash payment of dividends Cashret romance of 10.000 hans of common stock 6,000 10,000 38,000 10,000 30.000 45 19 99983333 35 16 Requirements Bee theettabs at bottom. Use each sheet for the following requirements) ET Use cells in completing these murementYou must formulas and function, ce references and professional formatie 1. Using examples from your textbook or online research prepare the Panama Pajama Company multi-pincoere statement for the year ended December 31, 2019. Include the US at the Also include a vertical analysis column at the right and performa vertical analysis of the income statement. Use percentage format with 1 decimal place) 2. Prepare the Panama Pajama Company balance sheet for December 31, 2019. Include a vertical analysis column at the right 31 and perform avertical analysis of the balance sheet. (Use the percentage format with 1 decimal place) 3. Prepare the Panama Pajama Company statement of cash flows for the year ended December 31, 2019. Use the indirect method. Your textbook has examples of this 31 4. Complete the analysis of the financial statements as directed on the Analysis sheet. Une percentage format where propriate with 2 decimal places 5. Cameltothe analys of the investment options between this company and couvratio diven). Also we the chart from the attached article, and any other source to analyze the impact of using 35 52 AMAZING COMPANY Income Statement Year Ended December 21 2019 Vert Analysis 6 2 9 10 12 11 14 15 A D E AMAZING COMPANY Balance Sheet December 31, 2019 Vert Analysis 5 G 7 B 9 10 11 A4 JK D E F AMAZING COMPANY Set of Cash Flow Yeard December 31, 2019 10 11 23 13 Use the information srovided in the intructions and the financial statements you have created in the previous requirements, perform the following analysis 5 Requirements: Current Radio Debt-to Equity RO Working Capital CRO Reument 1. Come these ratio found wanalar fontos percentage or Most Gross Profit Inventory Tur Days Sales in remory Accounts Receivable Days Sales in Turnover Beatles 2018 Total Rate of Return Rate of Return on Asset Turner Stockholders Earnings Per Total Arts Rate Equity Share 2013 SHE 30 ke/ Earnings 11000 Dividende Duidend Payout Dividers 20 15 m. sedan emph the com 18 is the 10 cment and long term 30 11 in randy 22 2 Bus 14 samosted hove 15 weer 10 motory 12 Betti 10. in your way 29 10 11 urtado the computed here te the con tot receive Rufer your You have just received a large annual boot work, and have decided to investit in Mecks for your retirement. You have been analyse deres stocks and have narrowed your choice to two posibilities. You can either invest Amating Company or in EU, Euratios wegen below 3 ratios you may use to determine which stock to invest in and make a choice Defend your section without sing the cond part of yours is to read the article attached to the ainment On 117.120, there is a chart that summaries some of the differerembet GAN S.panthe general smarties and differences and du how interest expert would be present on the State of Cashows. Includes your devision any differences between GAAP and I would that mpact your investment decision above? Your answer will be graded on analysis, logic and writings Curre Babe 00 War Canal Or 140 y ay in Green un www Pent R Art Yw Star Aset Old 1 10 ACCT 2023PROJECT 1 Amazing Company began operations on January 1, 2015 and is now in its fourth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2019 appears below, along with prior year balance sheet data and some additional transaction data for 2018. AMAZING COMPANY Adjusted Tral Balance 12/31/15 7 8 Account Tide $ 2019 Adjusted Trial Balance Debit Credit 120,000 55.000 5.000 46000 63,000 10 11 12 13 11 15 16 $ 59.000 2018 Post Closing Trbal Balance Debt Crede 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 5 Accounts Recevable Prepaid insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Sales Payable Sales Tax Payable Nota Payable-long Tem Common Stock 510 par Retained Caming Dividends Sales Revenue Cost of Goods Sold Rent Expense Salas peni Insurance Expertise Legal Fees Depreciation Expense interest Expense income Tax Expense 11 19 20 21 21,000 12,200 2,600 2.000 11,000 260,000 28.600 10,000 240,000 27 20 30 132,600 20,000 36,000 11,300 9.200 5,000 1,800 32 3.000 $ 377.400 M 35 36 37 377.4005 250,200 250,200 5 39 LO Transaction Data for 2019 Note, these transactions were included in the trial balance numbers above) Cash paid for purchase of office equiment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable-longhem Payment on Long Tam Debt Cash payment of dividends Cashret romance of 10.000 hans of common stock 6,000 10,000 38,000 10,000 30.000 45 19 99983333 35 16 Requirements Bee theettabs at bottom. Use each sheet for the following requirements) ET Use cells in completing these murementYou must formulas and function, ce references and professional formatie 1. Using examples from your textbook or online research prepare the Panama Pajama Company multi-pincoere statement for the year ended December 31, 2019. Include the US at the Also include a vertical analysis column at the right and performa vertical analysis of the income statement. Use percentage format with 1 decimal place) 2. Prepare the Panama Pajama Company balance sheet for December 31, 2019. Include a vertical analysis column at the right 31 and perform avertical analysis of the balance sheet. (Use the percentage format with 1 decimal place) 3. Prepare the Panama Pajama Company statement of cash flows for the year ended December 31, 2019. Use the indirect method. Your textbook has examples of this 31 4. Complete the analysis of the financial statements as directed on the Analysis sheet. Une percentage format where propriate with 2 decimal places 5. Cameltothe analys of the investment options between this company and couvratio diven). Also we the chart from the attached article, and any other source to analyze the impact of using 35 52 AMAZING COMPANY Income Statement Year Ended December 21 2019 Vert Analysis 6 2 9 10 12 11 14 15 A D E AMAZING COMPANY Balance Sheet December 31, 2019 Vert Analysis 5 G 7 B 9 10 11 A4 JK D E F AMAZING COMPANY Set of Cash Flow Yeard December 31, 2019 10 11 23 13 Use the information srovided in the intructions and the financial statements you have created in the previous requirements, perform the following analysis 5 Requirements: Current Radio Debt-to Equity RO Working Capital CRO Reument 1. Come these ratio found wanalar fontos percentage or Most Gross Profit Inventory Tur Days Sales in remory Accounts Receivable Days Sales in Turnover Beatles 2018 Total Rate of Return Rate of Return on Asset Turner Stockholders Earnings Per Total Arts Rate Equity Share 2013 SHE 30 ke/ Earnings 11000 Dividende Duidend Payout Dividers 20 15 m. sedan emph the com 18 is the 10 cment and long term 30 11 in randy 22 2 Bus 14 samosted hove 15 weer 10 motory 12 Betti 10. in your way 29 10 11 urtado the computed here te the con tot receive Rufer your You have just received a large annual boot work, and have decided to investit in Mecks for your retirement. You have been analyse deres stocks and have narrowed your choice to two posibilities. You can either invest Amating Company or in EU, Euratios wegen below 3 ratios you may use to determine which stock to invest in and make a choice Defend your section without sing the cond part of yours is to read the article attached to the ainment On 117.120, there is a chart that summaries some of the differerembet GAN S.panthe general smarties and differences and du how interest expert would be present on the State of Cashows. Includes your devision any differences between GAAP and I would that mpact your investment decision above? Your answer will be graded on analysis, logic and writings Curre Babe 00 War Canal Or 140 y ay in Green un www Pent R Art Yw Star Aset Old 1 10