Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the tables below, conduct a complete ratio analysis of the Bartlett Company for the years 2018 developments that you uncover when comparing ratios from

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Using the tables below, conduct a complete ratio analysis of the Bartlett Company for the years 2018 developments that you uncover when comparing ratios from 2018 and 2019. E Bartlett Company Income Statements Bartlett Company Balance Sheets Bartlett Company Statement of Retained Earnings Total asset turnover (Round to three decimal places.) 2019 2018 Debt ratio (Round to three decimal places.) 2019 2018 Debtequity ratio (Round to three decimal places.) 2019 2018 Times interest earned (Round to three decimal places.) 2019 2018 Gross profit margin (Round to three decimal places.) 2019 2018 Enter any number in the edit fields and then continue to the next question Using the tables below. conduct a complete ratio analysis of the Bartlet Company for the years 2018 developments that you uncover when comparing ratios from 2018 and 2019 Bartlett Company Income Statements Barter Company Balance Sheets THE Barten Company Statement of Retained Earnings (Round to three decimal places) 2010 2018 Current (Round to three decimal places) 2019 2013 found to the decimal places) 2013 2018 Inventory turnover (Round is the decimal places) 2019 2018 Average collection period (Round to three complaces) 2009 2018 Total se samo Gross profit margin (Round to three decimal places.) 2019 2018 Operating profit margin (Round to three decimal places.) 2019 2018 Net profit margin (Round to three decimal places.) 2019 2018 Return on total assets (ROA) (Round to three decimal places.) 2019 2018 Return on equity (ROE) (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Bartlett Company Income Statements ($000) For the Years Ended December 31 2019 2018 Sales revenue $3,080 $2,590 Less: Cost of goods sold 2,094 1,707 Gross profits $986 $883 Less: Operating expenses Selling expense $98 $108 General and administrative expenses 194 183 Other operating expenses 40 40 Depreciation expense 243 216 Total operating expense $575 $547 Operating profits $411 $336 Less: Interest expense 102 85 Net profits before taxes $309 $251 Less: Taxes 100 68 Net profits after taxes $209 $183 Less: Preferred stock dividends 0 0 Earnings available for common stockholders $209 $183 Print Done ata Table UUTUUTTORE 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 40 243 $575 $411 102 $309 100 $209 0 $209 40 216 $547 $336 85 $251 68 $183 0 $183 Earnings per share (EPS) Dividend per share (DPS) $2.74 $1.29 $2.40 $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: $209,000 + 76,262 = $2.74; in 2018: $183,000 + 76,244 = $2.40. 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 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 foxtures Vehicles Other (Includes financial teases) Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt (includes financial leases) December 31 2019 $370 65 502 292 $1,229 $2,069 1,862 365 276 100 $4,672 2.293 $2,379 $3,608 2018 $293 51 364 296 $1,004 $1,902 1,691 320 317 96 $4,326 2,059 $2,267 $3,271 $386 75 162 $623 1.250 $275 105 118 $498 1.148 Print Done Total current assets Land and buildings Machinery and equipment Furniture and foxtures Vehicles Other (includes financial leases) Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets $1,229 $2,069 1,862 365 276 100 $4,672 2,293 $2,379 $3,608 $1.004 $1,902 1,691 320 317 96 $4,326 2,059 $2,267 $3,271 Liabilities and Stockholders' Equity Accounts payable Notes payable Accruals Total current abilities Long-term debt (includes financial leases) Total liabilities Preferred stock Common stock $2.50 par, 100,000 shares authorized, shares issued and outstanding in 2019: 70,262, in 2018: 76,244 Pald.in capital in excess of par on common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $386 75 162 $623 1.250 $1,873 $0 193 $275 105 118 $498 1,148 $1,646 SO 193 426 1,116 $1,735 $3,608 417 1,015 $1,625 $3,271 Print Done (Click the icon here in order to copy the contents of the data table below into a spreadshot) Bartlett Company Statement of Retained Earnings ($000) for the Year Ended December 31, 2019 Retained earnings balance (January 1, 2019) $1,015 Plus: Net profits after taxes (for 2019) 209 Less: Cash dividends (paid during 2019) Preferred stock 0 Common stock 98 Total dividends paid $108 Retained earnings balance (December 31, 2019) $1,116 Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Theory Conceptual Issues In A Political And Economic Environment

Authors: Harry I. Wolk, James L. Dodd, John J. Rozycki

7th Edition

1412953456, 978-1412953450

More Books

Students also viewed these Accounting questions

Question

Why is the central limit theorem important?

Answered: 1 week ago

Question

x-3+1, x23 Let f(x) = -*+3, * Answered: 1 week ago

Answered: 1 week ago

Question

Explain how to reward individual and team performance.

Answered: 1 week ago