the activity and prob atio n particularly poste negative Using the below conduct a complete to any of the Bare company for the year 2018 and 2019. You should developments that you uncover when comparing ratios from 2018 and 2019 are Company income Statements Brett Company Balance Sheets FB Bart Company Statement of Retained Earnings Cound to the decimal places) Current (Round to three decimal places) (Round to three decimal places) Inventory tumover Round to the decimal places Average collection period Round to three decimal places) Enter any number in the di fields and then continue to the next question This a 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) December 31 2019 $370 2018 $288 66 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 502 285 $1.223 $2,079 1,862 361 277 100 $4,679 2,295 $2,384 $3,607 366 302 $1.007 $1.913 1,691 320 319 $4,340 2,053 $2,287 $3.294 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 $383 82 165 $630 1,028 $1,658 $200 193 $265 100 110 $475 993 $1,468 $200 193 Print Done Using the tables below. conduct a complete rot analysis of the Bartient company for the years 2018 and 2019. You should assess the firm's d developments that you uncover when comparing ratios from 2018 and 2019 a y and prof i ty party 3 Bartlet Company Income Statements Bartlett Company Balance Sheets Barriott Company Statement of Retained Earings 2018 Debt ratio (Round to three decimal places.) 2018 Debu equity ratio (Round to three decimal places.) Times interest earned (Round to three decimal places.) 2019 2018 Gross profit margin (Round to three decimal places 2019 2018 Operating profit margin Round to three decimal places.) 2019 Enter any number in the edit Melds and then continue to the next question Using the tables below. conduct a complete analysis of the Bartel Company for the year 2015 and 2019. You should developments that you uncover when comparing ratios from 2018 and 2019 the guidity activity debt and prob o s Hight any pa rt pour negative Bartier Company Income Statements Bartient Company Balance Sheets BB Bartlett Company Statement of Retained Earings Gross profit margin Round to three decimal places) Operating profit margin (Round to the decimal places) Net profit margin (Round to the decimal places) 2019 2018 Return on otse (ROA) Round to three decimal places.) 2019 2018 Rotum onu HOLI Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019 (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Balance Sheets (5000) 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 2018 $288 51 366 302 $1,007 $1.913 1,691 320 319 277 97 100 $4.679 2.295 $2,384 $3,607 $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 i Data Table 66 502 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 51 366 302 $1,007 $1,913 1,691 320 285 $1,223 $2,079 1.862 361 277 100 $4,679 2,295 $2,384 $3,607 319 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 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 $200 193 $265 100 110 $475 993 $1,468 $200 193 427 1,129 $1,949 $3,607 422 1,011 $1,826 $3294 Print Done i Data Table X (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 98 Print Done Data Table ok 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 $870 Less: Operating expenses Selling expense $100 $105 General and administrative expenses 194 181 Other operating expenses 37 Depreciation expense 238 224 Total operating expense $569 $547 Operating profits $323 Less: Interest expense 94 Net profits before taxes Less: Taxes Net profits after taxes $226 Less: Preferred stock dividends Earnings available for common stockholders 37 $216 Earnings per share (EPS) Dividend per share (DPS) $2.83 $1.29 $2.01 $0.75 Print Done i Data Table 2,088 $986 1.710 $870 $100 194 37 $105 181 37 224 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 238 $569 $417 101 $316 90 $226 10 $216 $229 66 $163 10 $153 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 the activity and prob atio n particularly poste negative Using the below conduct a complete to any of the Bare company for the year 2018 and 2019. You should developments that you uncover when comparing ratios from 2018 and 2019 are Company income Statements Brett Company Balance Sheets FB Bart Company Statement of Retained Earnings Cound to the decimal places) Current (Round to three decimal places) (Round to three decimal places) Inventory tumover Round to the decimal places Average collection period Round to three decimal places) Enter any number in the di fields and then continue to the next question This a 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) December 31 2019 $370 2018 $288 66 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 502 285 $1.223 $2,079 1,862 361 277 100 $4,679 2,295 $2,384 $3,607 366 302 $1.007 $1.913 1,691 320 319 $4,340 2,053 $2,287 $3.294 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 $383 82 165 $630 1,028 $1,658 $200 193 $265 100 110 $475 993 $1,468 $200 193 Print Done Using the tables below. conduct a complete rot analysis of the Bartient company for the years 2018 and 2019. You should assess the firm's d developments that you uncover when comparing ratios from 2018 and 2019 a y and prof i ty party 3 Bartlet Company Income Statements Bartlett Company Balance Sheets Barriott Company Statement of Retained Earings 2018 Debt ratio (Round to three decimal places.) 2018 Debu equity ratio (Round to three decimal places.) Times interest earned (Round to three decimal places.) 2019 2018 Gross profit margin (Round to three decimal places 2019 2018 Operating profit margin Round to three decimal places.) 2019 Enter any number in the edit Melds and then continue to the next question Using the tables below. conduct a complete analysis of the Bartel Company for the year 2015 and 2019. You should developments that you uncover when comparing ratios from 2018 and 2019 the guidity activity debt and prob o s Hight any pa rt pour negative Bartier Company Income Statements Bartient Company Balance Sheets BB Bartlett Company Statement of Retained Earings Gross profit margin Round to three decimal places) Operating profit margin (Round to the decimal places) Net profit margin (Round to the decimal places) 2019 2018 Return on otse (ROA) Round to three decimal places.) 2019 2018 Rotum onu HOLI Highlight any particularly positive or negative developments that you uncover when comparing ratios from 2018 and 2019 (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Balance Sheets (5000) 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 2018 $288 51 366 302 $1,007 $1.913 1,691 320 319 277 97 100 $4.679 2.295 $2,384 $3,607 $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 i Data Table 66 502 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 51 366 302 $1,007 $1,913 1,691 320 285 $1,223 $2,079 1.862 361 277 100 $4,679 2,295 $2,384 $3,607 319 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 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 $200 193 $265 100 110 $475 993 $1,468 $200 193 427 1,129 $1,949 $3,607 422 1,011 $1,826 $3294 Print Done i Data Table X (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 98 Print Done Data Table ok 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 $870 Less: Operating expenses Selling expense $100 $105 General and administrative expenses 194 181 Other operating expenses 37 Depreciation expense 238 224 Total operating expense $569 $547 Operating profits $323 Less: Interest expense 94 Net profits before taxes Less: Taxes Net profits after taxes $226 Less: Preferred stock dividends Earnings available for common stockholders 37 $216 Earnings per share (EPS) Dividend per share (DPS) $2.83 $1.29 $2.01 $0.75 Print Done i Data Table 2,088 $986 1.710 $870 $100 194 37 $105 181 37 224 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 238 $569 $417 101 $316 90 $226 10 $216 $229 66 $163 10 $153 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
