Condensed statements of financial position and statement of income data for Pembina Corporation follow:
Question 11 of 12 4720 Condensed statements of financial position and statement of income data for Pembina Corporation follow: 2019 PEMBINA CORPORATION Statement of Financial Position December 31 2021 2020 Assets Current assets Cash $25,200 $20,200 Accounts receivable (net) 54.900 45,000 Inventory 101,000 84,900 Total current assets 181,100 150,100 Long-term investments 54,600 66,900 Property, plant, and equipment (net) 501,900 373,200 Total assets $737,600 $590,200 Liabilities and Shareholders' Equity Liabilities Current liabilities $84,100 $80,700 Non-current liabilities 155,500 85,900 Total liabilities 239,600 166,600 Shareholders' equity Common shares 331,800 299,300 Retained earnings 166,200 124,300 $18,000 47,600 64,100 129,700 44,800 255,700 $430,200 $29,900 19,800 49,700 298,300 82,200 Question 11 of 12 4/20 III 234,600 166,600 49,700 Total abilities Shareholders' equity Common shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 331,800 166,200 498,000 $737,600 299,300 124,300 423,600 $590,200 298,300 82,200 380,500 $430,200 PEMBINA CORPORATION Statement of Income Year Ended December 31 2021 Sales 698,200 Cost of goods sold 448,100 Gross profit 250,100 Operating expenses 151,300 Income from operations 98,800 Interest expense 9,900 Income before income tax 88.900 Income tax expense 17,780 Net income $71,120 2020 447,500 299,400 148,100 84,400 63,700 4,380 59,320 11,864 $47,456 Additional information: Question 11 of 12 4/20 III Additional information: 1. 2. 3. 4. The allowance for doubtful accounts was $4,800 in 2019, $4,600 in 2020, and $5,100 in 2021. All sales were credit sales. Net cash provided by operating activities was $120,100 in 2020 and $101,900 in 2021. Net capital expenditures were $148,100 for 2020 and $181,100 for 2021. (a) Your answer is partially correct. Calculate the following ratios for 2020 and 2021: (Round answers to 1 decimal place, e.g. 5.2:1 or 5.2% or 5.2. Enter negative answers preceeding either - sign, e.g.-45 or in parentheses, e.g. (45).) 2021 2020 22 1.9 1. Current ratio : 1 :1 14.01 9.78 2. Receivables turnover times times 4.8 41 Question 11 of 12 4/20 Calculate the following ratios for 2020 and 2021: (Round answers to 1 decimal place, eg. 5.2:1 or 5.2% or 5.2. Enter negative answers preceeding either - sign, e.g. -45 or in parentheses, e.g. (45).) 2021 2020 22 1.9 1. Current ratio :1 :1 14.01 9.78 2. Receivables turnover times times 4.8 41 3. Inventory turnover times times 0.32 0.28 4. Debt to total assets % % 9.98 14.5 5. Times interest earned times times $ -28000 $ RA -79200 6. Free cash flow 35.8 33.1 7. Gross profit margin 10.2 10.6 8. Profit margin % 1.05 0.88 9. Asset turnover times times 0.10 0.09 10. Return on assets e Textbook and Media
