Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i) Complete Financial Ratios for 2018 and 2019? ii) Assessment of the financial performance 2018 vs. 2019? FINANCIAL RATIOS Liquidity Ratios Current Current Asset Current

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

i) Complete Financial Ratios for 2018 and 2019?

ii) Assessment of the financial performance 2018 vs. 2019?

FINANCIAL RATIOS Liquidity Ratios Current Current Asset Current Liabilities Quick (Acid-test) Current Asset - Inventory Current Liability Activity Ratios Inventory turnover COGS Inventory Average Collection Period Account Receivables Sales/365 Average Payment Period Account Payables Purchases/365 Leverage Ratio Debt Ratio Total Liabilities Total Assets Debt-to-Equity Total Liabilities Common Stock Value Time Interest Earned EBIT Interest expenses Profitability Ratio Gross Profit Margin (Sales - COGS) Sales Operating Profit Margin Operating Profit Sales Net Profit Margin Earning Available for Common Stock Holder (NPAT) Sales Earnings Per Share (EPS) Earnings Available for CS Number of CS Outstanding Return on Asset Earning Available for CS Total Assets Return on Equity Earning Available for CS Number CS Outstanding Market Ratio Price - Earning Ratio Market Price of CS EPS Book Value Per Share Total Value of CS Number of CS Outstanding Market Book Ratio Market Price of CS Book Value Per Share Bartlett Company Income Statement ('000) 2019 $ 3,074 2,088 $ 986 2018 $ 2,567 1,711 $ 856 Sales revenue 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 $ 100 194 35 239 $ 568 $ 418 $ 108 187 35 223 $ 553 $ 303 Less: Interest expense 93 91 Net profits before taxes Less: Taxes Net profits after taxes $ 325 94 $ 231 $ 212 64 $ 148 Less: Preferred stock dividends 10 10 $ 221 $ 138 Earnings available for common stockholders Earnings per share (EPS)" Dividend per share (DPS) Total operating expense Operating profits $ 2.90 $ 1.29 $ 568 $ 1.81 $ 0.75 $ 553 $ 418 $ 303 Bartlett Company Balance Sheet ('000) Assets Cash Marketable securities Accounts receivable Inventories Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) 2019 $ 363 68 503 289 $ 1,223 $ 2,072 1,866 358 275 2018 $ 288 51 365 300 $ 1,004 $ 1,903 1,693 316 314 96 98 $ 4,669 $ 4,322 Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets 2,295 $ 2,374 $ 3,597 2,056 $ 2,266 $ 3.270 Liabilities and Stockholders' Equity Accounts payable $ 382 $ 270 99 79 159 $ 620 114 $ 483 1,023 967 $ 1,643 $ 1,450 $ 200 $ 200 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 191 191 428 417 1,135 $ 1,954 1,012 $ 1,820 $ 3,597 $ 3,270 Statement of Retained Earning as of 31 December 2019 $1,012 231 Retained earnings balance (January 1, 2019) Plus: Net profits after taxes (for 2019) Less: Cash dividends (paid during 2019) Preferred stock Common stock Total dividends paid Retained earnings balance (December 31, 2019) 10 98 $ 108 $1,135 FINANCIAL RATIOS Liquidity Ratios Current Current Asset Current Liabilities Quick (Acid-test) Current Asset - Inventory Current Liability Activity Ratios Inventory turnover COGS Inventory Average Collection Period Account Receivables Sales/365 Average Payment Period Account Payables Purchases/365 Leverage Ratio Debt Ratio Total Liabilities Total Assets Debt-to-Equity Total Liabilities Common Stock Value Time Interest Earned EBIT Interest expenses Profitability Ratio Gross Profit Margin (Sales - COGS) Sales Operating Profit Margin Operating Profit Sales Net Profit Margin Earning Available for Common Stock Holder (NPAT) Sales Earnings Per Share (EPS) Earnings Available for CS Number of CS Outstanding Return on Asset Earning Available for CS Total Assets Return on Equity Earning Available for CS Number CS Outstanding Market Ratio Price - Earning Ratio Market Price of CS EPS Book Value Per Share Total Value of CS Number of CS Outstanding Market Book Ratio Market Price of CS Book Value Per Share Bartlett Company Income Statement ('000) 2019 $ 3,074 2,088 $ 986 2018 $ 2,567 1,711 $ 856 Sales revenue 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 $ 100 194 35 239 $ 568 $ 418 $ 108 187 35 223 $ 553 $ 303 Less: Interest expense 93 91 Net profits before taxes Less: Taxes Net profits after taxes $ 325 94 $ 231 $ 212 64 $ 148 Less: Preferred stock dividends 10 10 $ 221 $ 138 Earnings available for common stockholders Earnings per share (EPS)" Dividend per share (DPS) Total operating expense Operating profits $ 2.90 $ 1.29 $ 568 $ 1.81 $ 0.75 $ 553 $ 418 $ 303 Bartlett Company Balance Sheet ('000) Assets Cash Marketable securities Accounts receivable Inventories Total current assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other (includes financial leases) 2019 $ 363 68 503 289 $ 1,223 $ 2,072 1,866 358 275 2018 $ 288 51 365 300 $ 1,004 $ 1,903 1,693 316 314 96 98 $ 4,669 $ 4,322 Total gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets 2,295 $ 2,374 $ 3,597 2,056 $ 2,266 $ 3.270 Liabilities and Stockholders' Equity Accounts payable $ 382 $ 270 99 79 159 $ 620 114 $ 483 1,023 967 $ 1,643 $ 1,450 $ 200 $ 200 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 191 191 428 417 1,135 $ 1,954 1,012 $ 1,820 $ 3,597 $ 3,270 Statement of Retained Earning as of 31 December 2019 $1,012 231 Retained earnings balance (January 1, 2019) Plus: Net profits after taxes (for 2019) Less: Cash dividends (paid during 2019) Preferred stock Common stock Total dividends paid Retained earnings balance (December 31, 2019) 10 98 $ 108 $1,135

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

Financial Reporting And Statement Analysis A Strategic Approach

Authors: Clyde P. Stickney, Paul Brown, James M. Wahlen

5th Edition

032418638X, 978-0324186383

More Books

Students also viewed these Finance questions

Question

Describe the selection process.

Answered: 1 week ago

Question

Describe performance management.

Answered: 1 week ago

Question

Explain the importance of preliminary screening.

Answered: 1 week ago