O 1 A MAM 12 Pro Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse) O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.7 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30% Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse). O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.71 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30% Prepare the common size, and common-base year for O'Leary Industrial Supply's Statement of Financial Position using the spreadsheets below Use 3 decimal places 2019 Common-size Statement of Financial Position O'Leary Industrial Supply Balance Sheets as at December 31 2017 2018 Current assets Cash 11,500 24,700 Marketable securities 7.000 7.000 Accounts receivable 297,300 361,800 Inventories 289,900 330,000 prepaid expenses 5,500 800 Total current assets 611,200 724,300 Net plant and equipment 184,300 172.900 Goodwill 30,600 28,200 Total assets 826,100 925,400 Current liabilities Accounts payable 209.700 196,700 Line of credit 169,000 202,000 Accruals 14,400 23,700 Total current liabilities 393,100 422,400 Long-term debt 141,000 181,600 Total debt 534,100 604.000 Equity Common shares 14,000 14,000 Retained earnings 278,000 307,400 Total equity 292.000 321,400 Total liabilities and equity 826,100 925,400 14,900 7,000 410,800 256,600 5,200 694,500 162,000 25,400 881,900 145,900 254,000 3,700 403,600 225,800 629.400 14,000 238,500 252,500 881,900 2018 2019 24,700 7,000 361,800 330,000 800 724,300 172,900 28,200 925,400 14,900 7.000 410,800 256,600 5,200 694,500 162,000 25,400 881,900 Common-base year Statement of Financial Position 2017 Current assets Cash 11.500 Marketable securities 7.000 Accounts receivable 297,300 Inventories 289,900 prepaid expenses 5,500 Total current assets 611,200 Net plant and equipment 184,300 Goodwill 30,600 Total assets 826,100 Current liabilities Accounts payable 209,700 Line of credit 169,000 Accruals 14,400 Total current liabilities 393,100 Long-term debt 141,000 Total debt 534,100 Equity Common shares 14,000 Retained earnings 278,000 Total equity 292,000 Total liabilities and equity 826,100 196,700 202,000 23,700 422,400 181,600 604,000 145,900 254,000 3,700 403,600 225,800 629,400 14,000 307,400 321,400 925,400 14,000 238,500 252,500 881,900 Prepare the common-size, and common-base year of the Statement of Comprehensive Income for O'Leary Industrial Supply using the spreadsheets below. Common-size Income Statement O'Leary Industrial Supply Income Statement for the years ended December 31 2017 2018 1,542,700 1,841,300 1,174,800 1,397,400 367.900 443,900 2019 1,605,100 1,258,900 346,200 Sales Cost of goods Sold Gross Margin Operating expenses Administrative expenses Selling expense amortization Total oper. Expenses Operating income (-) Interest expenses Earnings before tax Income taxes Net Income 187,900 106,300 16,000 310,200 57,700 50,100 7,600 2,200 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122,100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1.100 Common-base year Income Statement 2017 1,542,700 1,174,800 367,900 2018 1,841,300 1,397,400 443,900 2019 1,605,100 1,258.900 346,200 Sales Cost of goods Sold Gross Margin Operating expenses Administrative expenses Selling expense amortization Total oper. Expenses Operating income (-) Interest expenses Earnings before tax Income taxes Net Income 187,900 106,300 16,000 310,200 57,700 50,700 7,600 2,200 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122,100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1,100 Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse). O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.71 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30% O 1 A MAM 12 Pro Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse) O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.7 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30% Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse). O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.71 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30% Prepare the common size, and common-base year for O'Leary Industrial Supply's Statement of Financial Position using the spreadsheets below Use 3 decimal places 2019 Common-size Statement of Financial Position O'Leary Industrial Supply Balance Sheets as at December 31 2017 2018 Current assets Cash 11,500 24,700 Marketable securities 7.000 7.000 Accounts receivable 297,300 361,800 Inventories 289,900 330,000 prepaid expenses 5,500 800 Total current assets 611,200 724,300 Net plant and equipment 184,300 172.900 Goodwill 30,600 28,200 Total assets 826,100 925,400 Current liabilities Accounts payable 209.700 196,700 Line of credit 169,000 202,000 Accruals 14,400 23,700 Total current liabilities 393,100 422,400 Long-term debt 141,000 181,600 Total debt 534,100 604.000 Equity Common shares 14,000 14,000 Retained earnings 278,000 307,400 Total equity 292.000 321,400 Total liabilities and equity 826,100 925,400 14,900 7,000 410,800 256,600 5,200 694,500 162,000 25,400 881,900 145,900 254,000 3,700 403,600 225,800 629.400 14,000 238,500 252,500 881,900 2018 2019 24,700 7,000 361,800 330,000 800 724,300 172,900 28,200 925,400 14,900 7.000 410,800 256,600 5,200 694,500 162,000 25,400 881,900 Common-base year Statement of Financial Position 2017 Current assets Cash 11.500 Marketable securities 7.000 Accounts receivable 297,300 Inventories 289,900 prepaid expenses 5,500 Total current assets 611,200 Net plant and equipment 184,300 Goodwill 30,600 Total assets 826,100 Current liabilities Accounts payable 209,700 Line of credit 169,000 Accruals 14,400 Total current liabilities 393,100 Long-term debt 141,000 Total debt 534,100 Equity Common shares 14,000 Retained earnings 278,000 Total equity 292,000 Total liabilities and equity 826,100 196,700 202,000 23,700 422,400 181,600 604,000 145,900 254,000 3,700 403,600 225,800 629,400 14,000 307,400 321,400 925,400 14,000 238,500 252,500 881,900 Prepare the common-size, and common-base year of the Statement of Comprehensive Income for O'Leary Industrial Supply using the spreadsheets below. Common-size Income Statement O'Leary Industrial Supply Income Statement for the years ended December 31 2017 2018 1,542,700 1,841,300 1,174,800 1,397,400 367.900 443,900 2019 1,605,100 1,258,900 346,200 Sales Cost of goods Sold Gross Margin Operating expenses Administrative expenses Selling expense amortization Total oper. Expenses Operating income (-) Interest expenses Earnings before tax Income taxes Net Income 187,900 106,300 16,000 310,200 57,700 50,100 7,600 2,200 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122,100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1.100 Common-base year Income Statement 2017 1,542,700 1,174,800 367,900 2018 1,841,300 1,397,400 443,900 2019 1,605,100 1,258.900 346,200 Sales Cost of goods Sold Gross Margin Operating expenses Administrative expenses Selling expense amortization Total oper. Expenses Operating income (-) Interest expenses Earnings before tax Income taxes Net Income 187,900 106,300 16,000 310,200 57,700 50,700 7,600 2,200 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122,100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1,100 Calculate the ratios indicated below for O'Leary Industrial Supply and make the comparison of the company's performance with the industry's and also the comparison of the company's performance in the most recent year with the previous years. For the comparison, use the sign + (if the company's performance is better), and - (if it is worse). O'Leary Industrial Supply Industry average ratios 2019 Comparison with the industry Comparison with itself 2017 2018 2019 1.6 1.1 85.1 58.4 8 1.71 Liquidity 1 Current ratio 2 Quick ratio Asset Management 3 Average age of inventory (days) 4 Days' sales in receivable 5 Fixed asset turnover 6 Total asset turnover Financial Leverage 7 Debt ratio 8 Debt/equity ratio 9 times interest earned Profitability 10 Gross profit margin 11 Operating profit (EBIT) 12 Profit margin 13 Return on assets 14 Return on equity 58.50% 41.30% 4.36 times times times times 25.80% 9.90% 5.80% 8.10% 20.30%