Suppose you are interested in evaluating ABC company's financial performance during 2019 and 2020. Use the information provided on the excel sheet to answer the following questions, 1. Prepare the company's Balance sheet and Income Statement during 2019 and 2020. (3 marks) 2. Prepare the company's cash flow statement for the year 2020. (2 marks) 3. Calculate the financial ratios for the company in 2019 and 2020. (2 marks) Note: Purchases were %70 of the cost of goods sold in both years. Dede Carte Quick rutin Reperty con period Am IN Durati There are Grupa Operating primar Nut HOA HOE 4. Analyze the company's overall financial situation from a time series viewpoint. (2 marks) 5. Compile the Proforma Income statement for the year 2020 using percent of sales method. (1 mark) TAN ..., V....... 1..., . Information for the year 2019 Marketable Securities Accounts Receivable Inventory Number of shares outstanding Other current assets Propert, Plant and equipment Machinery A..., Furniture Vehicles Paid in capital in excess of par value Par value of stock Notes payable T....... Accounts payable Long term loan Short term loan Dividends 1.4..... Cash Accumulated depreciation Sales Depreciation expense Selling expense Cost of goods sold Research and development expense General and administrative expense Interest expense Tax rate Utilities expense Beginning balance of retained earnings Information for the year 2020 Marketable Securities Accounts Receivable Inventory Number of shares outstanding Other current assets Propert, Plant and equipment Machinery Furniture Vehicles Paid in capital in excess of par value Par value of stock Notes payable Accounts payable Long term loan Short term loan Dividends Cash Accumulated depreciation Sales Depreciation expense Selling expense Cost of goods sold Research and development expense General and administrative expense Interest expense Tax rate Utilities expense Beginning balance of retained earnings 1 ..., V....... 4.. , LO...... ...... : TO Suppose you are interested in evaluating ABC company's financial performance during 2019 and 2020. Use the information provided on the excel sheet to answer the following questions, 1. Prepare the company's Balance sheet and Income Statement during 2019 and 2020. (3 marks) 2. Prepare the company's cash flow statement for the year 2020. (2 marks) 3. Calculate the financial ratios for the company in 2019 and 2020. (2 marks) Note: Purchases were %70 of the cost of goods sold in both years. Dede Carte Quick rutin Reperty con period Am IN Durati There are Grupa Operating primar Nut HOA HOE 4. Analyze the company's overall financial situation from a time series viewpoint. (2 marks) 5. Compile the Proforma Income statement for the year 2020 using percent of sales method. (1 mark) TAN ..., V....... 1..., . Information for the year 2019 Marketable Securities Accounts Receivable Inventory Number of shares outstanding Other current assets Propert, Plant and equipment Machinery A..., Furniture Vehicles Paid in capital in excess of par value Par value of stock Notes payable T....... Accounts payable Long term loan Short term loan Dividends 1.4..... Cash Accumulated depreciation Sales Depreciation expense Selling expense Cost of goods sold Research and development expense General and administrative expense Interest expense Tax rate Utilities expense Beginning balance of retained earnings Information for the year 2020 Marketable Securities Accounts Receivable Inventory Number of shares outstanding Other current assets Propert, Plant and equipment Machinery Furniture Vehicles Paid in capital in excess of par value Par value of stock Notes payable Accounts payable Long term loan Short term loan Dividends Cash Accumulated depreciation Sales Depreciation expense Selling expense Cost of goods sold Research and development expense General and administrative expense Interest expense Tax rate Utilities expense Beginning balance of retained earnings 1 ..., V....... 4.. , LO...... ...... : TO
