Using the tables below, conduct a complete to analysis of the Brit Company for the years 2018 and 2019. You should developments that you uncover when comparing ratios from 2010 and 2019 the la t est and mos. Paighaghan particulary pour require Bartlet Company Income Statements Bartlett Company Balance Sheets Bartit Company Statement of Retained Earrings Pound to predecimal places) 2018 2016 Round to the decimal places.) Quick Round to the decimal places) Inventory tumover Round to the decimal places.) Average collection period Round to three decimal places.) Total assetto m ind s and then continue to the next question Using the tables below. conduct a complete to analysis of the Bartlett Company for the year 2018 and 2014You should s developments that you uncover when comparing ratios from 2018 and 2019 he 's quity activity, debit and prot o Highlight any pro pove or negative Bartlett Company income Statements Barte Company Balance Sheets Bartlett Company Statement of Retained Earnings Debt ratio (Round to three decimal places) 2019 Debequity ratio Pound love decimal places.) 2019 2018 Times interesteamed Round to three decimal places.) Gross profit margin Round to three decimal places.) 2018 Operating profit margin (Hound to three decimal places) 2010 2018 Enter any number in the edit holds and then continue to the next question Using the below conduct a compe n so e Bare company for the year 2015 and 2019. You should them t o and pr o p erty poor meget Bare company income Sweets Bartel Company Balance Sheets Bartiet Company Statement of Rendang Gross profit margin (Round to the decimal places.) 2019 Operating profit margin (Round to three decimal places) Net profit margin (Round to three decimal places) Helium on totalasses (ROA) Round to three decimal places) 2019 Retum onu ORE) cover when comparing from 2018 and 2019 Highlight any particularly powtive or negative developments that you coi her Data Table (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Income Statements (5000) For the Years Ended December 31 2019 2018 Sales revenue $3,074 $2,580 Less: Cost of goods sold 2,088 1,710 Gross profits $986 5870 Less: Operating expenses Selling expense $100 $105 General and administrative expenses 194 181 Other operating expenses 37 Depreciation expense 224 Total operating expense $569 Operating profits $417 Less: Interest expense 101 94 Net profits before taxes $316 $229 Less: Taxes 66 Net profits after taxes $226 $163 Less: Preferred stock dividends 10 Earnings available for common stockholders $216 $153 37 238 $547 5322 90 10 Earnings per share (EPS) Dividend per share (DPS) $2.83 $1.29 $2.01 $0.75 Print Done coli Data Table 2,088 $986 1,7TU $870 $100 194 37 $105 181 37 Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Other operating expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders 224 $547 $323 94 $569 $417 101 $316 90 $226 10 $216 Earnings per share (EPS) Dividend per share (DPS) $2.83 $1.29 $2.01 $0.75 Calculated by dividing the earnings available for common stockholders by the number of shares of common stock outstanding: 76,262 in 2019 and 76,244 in 2018. Earnings per share in 2019: $216,000 + 76,262 = $2.83; in 2018: $153,000 + 76,244 $2.01. Calculated by dividing the dollar amount of dividends paid to common stockholders by the number of common stock outstanding. Dividends per share in 2019: $98,000 + 76,262 = $1.29; in 2018: $57,183 + 76,244 = $0.75. Print Done * Data Table (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Balance Sheets (5000) 2018 $288 Assets Cash Marketable securities Accounts receivable Inventories Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets December 31 2019 $370 66 502 285 $1,223 $2.079 1,862 361 366 302 $1,007 $1.913 1,691 320 277 319 100 $4,679 2.295 $2,384 $3,607 97 $4,340 2,053 $2.287 $3.294 $383 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 par, 2,000 shares authorized and issued Common stock: $2.50 par, 100,000 shares authorized, shares issued and outstanding in 165 $630 1,028 $1,658 $200 193 $265 100 110 $475 993 $1,468 $200 193 Print Done 1 of 1 (0 complete) i Data Table 2 502 285 366 302 $1.223 $2,079 Marketable securities Accounts receivable Inventories Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets 1.882 $1,007 $1.913 1,691 320 319 361 277 100 $4,679 2.295 $2,384 $3,607 $4,340 2,053 $2.287 $3294 $383 5265 82 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) Total liabilities Preferred stock: cumulative 5%, $100 por 2,000 shares authorized and issued Common stock: $2.50 par, 100,000 shares authorized, shares issued and outstanding in 2019: 76,262; in 2018: 76,244 Paid-in capital in excess of par on common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 165 $630 1,028 $1,658 100 110 $475 993 $1,468 $200 193 $200 193 427 1,129 $1,949 $3,607 422 1,011 $1,826 $3 294 Print Done plete ratio analysis of the Bartlett Company for the years 2018 and 2019. You should assess the firm's liquidity, activity, debt, and profitabilty ratios. Highli comparing ratios from 2018 and 2019. ents tained Earnings Data Table 119 19 (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Statement of Retained Earnings (5000) for the Year Ended December 31, 2019 Retained earnings balance (January 1, 2019) $1,011 Plus: Net profits after taxes (for 2019) 226 Less: Cash dividends (paid during 2019) Preferred stock Common stock Total dividends paid $108 Retained earnings balance (December 31, 2019) $1,129 Print Done 20 ative developments that you uncover when comparing ratios from 2018 and 2019. then continue to the next