Here is financial information for Shamrock, Inc.. Current assets Plant assets (net) Current liabilities Long-term liabilities Common stock, $1 par Retained earnings December 31, 2020 $104,753 435,862 102,242 132,373 128,478 177,522 December 31, 2019 $89,000 382,000 67,000 98,000 114,000 192,000 Prepare a schedule showing a horizontal analysis for 2020, using 2019 as the base year. amount and percentage are a decrease show the numbers as negative, e.g.-55,000,-20% or (55,000), (20%). Round percentages to 1 decimal place, eg. 12.1%) SHAMROCK, INC. Condensed Balance Sheet December 31 Increase or (Decrease) 020 19 Assets Current Assets Plant assets (net) $104,753 $89,000 $ Total assets Liabilities Current Liabilities Long-term liabilities 435,862 382,000 540,615 $471,000 $ $102,242 $67,000$ 132,373 98,000 Total liabilities Stockholders' E Common stock, SI par Retained earnings 234,615 $165,000 $ 128,478 114,000 177,522 192,000 306,000 306,000 Total stockholders equity Total liabilities and stockholders' equity $540,615 $471,000 $ Operating data for Blue Spruce Corp. are presented below. 2020 2019 $720,000 $580,000 439,200 368,300 112,320 75,980 Administrative expenses 57,600 42,340 25,200 24,360 85,680 69,020 Sales revenue Cost of goods sold Selling expenses Income tax expense Net income Prepare a schedule showing a vertical analysis for 2020 and 2019. (Round percentages to 1 decimal place, eg. 1 2.1 %.) BLUE SPRUCE CORP Condensed Income Statement 2020 2019 Amount Percent Amount Percent Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income taxes Income tax expense $720,000 439,200 280,800 112,320 57,600 169,920 110,880 25,200 $ 85,680 % $580,000 % 368,300 % 211,700 % 75,980 % 42.340 % 118,320 % 93,380 % 24.360 % $69,020 Net income The comparative statements of Carla Vista Co. are presented here: Carla Vista Co. Income Statements For the Years Ended December 31 2020 2019 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Other expenses and losses $1,897,540 $1,757,500 1,065,540 1,013,000 832,000 744,500 507,000 486,000 325,000 258,500 22,000 301,000 236,500 75,000 $207,000 $161,500 Interest expense 24,000 Income before income taxes Income tax expense 94,000 Net income Carla Vista Co. Balance Sheets December 31 Assets 2020 2019 Current assets Cash Debt investments (short-term) Accounts receivable Inventory Total current assets $60,100 $64,200 74,000 50,000 124,800 109,800 128,000 117,500 386,900 341,500 659.000 530,300 $1,045,900 $871,800 Plant assets (net) Total assets Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Total current liabilities $167,000 $152,400 45,500 44,000 212,500 196,400 230,000 210,000 442,500 406,400 Bonds payable Total liabilities Stockholders' equity 290,000 300,000 313,400 165,400 603,400 465,400 Total liabilities and stockholders' equity $1,045,900 $871.800 Common stock ($5 par) Retained earnings Total stockholders' equity All sales were on account. Net cash provided by operating activities for 2020 was $251,000. Capital expenditures were $135,000, and cash dividends were $59,000. Compute the following ratios for 2020. (Round free cash flow to O decimal places, e.g. 5,275 and all other answers to 2 decimal places, e.g. 1.83 or 1.83%. Use 365 days for calculation.) (a) Earnings per share (b) Return on common stockholders'equity (c) Return on assets (d) Current ratio e Accounts receivable turnover (f) Average collection period g) Inventory turnover ) Days in inventory () Times interest earned G) Asset turnover (k) Debt to assets ratio (I) Free cash flow times days times days times times Here is financial information for Shamrock, Inc.. Current assets Plant assets (net) Current liabilities Long-term liabilities Common stock, $1 par Retained earnings December 31, 2020 $104,753 435,862 102,242 132,373 128,478 177,522 December 31, 2019 $89,000 382,000 67,000 98,000 114,000 192,000 Prepare a schedule showing a horizontal analysis for 2020, using 2019 as the base year. amount and percentage are a decrease show the numbers as negative, e.g.-55,000,-20% or (55,000), (20%). Round percentages to 1 decimal place, eg. 12.1%) SHAMROCK, INC. Condensed Balance Sheet December 31 Increase or (Decrease) 020 19 Assets Current Assets Plant assets (net) $104,753 $89,000 $ Total assets Liabilities Current Liabilities Long-term liabilities 435,862 382,000 540,615 $471,000 $ $102,242 $67,000$ 132,373 98,000 Total liabilities Stockholders' E Common stock, SI par Retained earnings 234,615 $165,000 $ 128,478 114,000 177,522 192,000 306,000 306,000 Total stockholders equity Total liabilities and stockholders' equity $540,615 $471,000 $ Operating data for Blue Spruce Corp. are presented below. 2020 2019 $720,000 $580,000 439,200 368,300 112,320 75,980 Administrative expenses 57,600 42,340 25,200 24,360 85,680 69,020 Sales revenue Cost of goods sold Selling expenses Income tax expense Net income Prepare a schedule showing a vertical analysis for 2020 and 2019. (Round percentages to 1 decimal place, eg. 1 2.1 %.) BLUE SPRUCE CORP Condensed Income Statement 2020 2019 Amount Percent Amount Percent Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income taxes Income tax expense $720,000 439,200 280,800 112,320 57,600 169,920 110,880 25,200 $ 85,680 % $580,000 % 368,300 % 211,700 % 75,980 % 42.340 % 118,320 % 93,380 % 24.360 % $69,020 Net income The comparative statements of Carla Vista Co. are presented here: Carla Vista Co. Income Statements For the Years Ended December 31 2020 2019 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Other expenses and losses $1,897,540 $1,757,500 1,065,540 1,013,000 832,000 744,500 507,000 486,000 325,000 258,500 22,000 301,000 236,500 75,000 $207,000 $161,500 Interest expense 24,000 Income before income taxes Income tax expense 94,000 Net income Carla Vista Co. Balance Sheets December 31 Assets 2020 2019 Current assets Cash Debt investments (short-term) Accounts receivable Inventory Total current assets $60,100 $64,200 74,000 50,000 124,800 109,800 128,000 117,500 386,900 341,500 659.000 530,300 $1,045,900 $871,800 Plant assets (net) Total assets Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Total current liabilities $167,000 $152,400 45,500 44,000 212,500 196,400 230,000 210,000 442,500 406,400 Bonds payable Total liabilities Stockholders' equity 290,000 300,000 313,400 165,400 603,400 465,400 Total liabilities and stockholders' equity $1,045,900 $871.800 Common stock ($5 par) Retained earnings Total stockholders' equity All sales were on account. Net cash provided by operating activities for 2020 was $251,000. Capital expenditures were $135,000, and cash dividends were $59,000. Compute the following ratios for 2020. (Round free cash flow to O decimal places, e.g. 5,275 and all other answers to 2 decimal places, e.g. 1.83 or 1.83%. Use 365 days for calculation.) (a) Earnings per share (b) Return on common stockholders'equity (c) Return on assets (d) Current ratio e Accounts receivable turnover (f) Average collection period g) Inventory turnover ) Days in inventory () Times interest earned G) Asset turnover (k) Debt to assets ratio (I) Free cash flow times days times days times times