Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with the spreadsheet Revenues 2019.00 2018.00 Net sales $ 210400.00 175400.00 Other revenues 8900.00 6300.00 Net Margin 19.82 % 18.761 ITotal revenues 219300.00

Need help with the spreadsheet

image text in transcribed
Revenues 2019.00 2018.00 Net sales $ 210400.00 175400.00 Other revenues 8900.00 6300.00 Net Margin 19.82 % 18.761 ITotal revenues 219300.00 181700.00 RO 16.02 % 12.64 Expenses Return on Equity 31.34 % 24.73. Cost of goods sold 125600.00 102800.00 Earnings per share Selling expenses 20100.00 18100.00 price earnings ratio times General and administrative expense: 9800.00 8800.00 book value Income before tax and interest 63800.00 52000.00 Interest expense 2300.00 2300.00 interest earned 27.74 Times 3.10! Income tax expense 19800.00 16800.00 working capital 94300.00 67200.001 2 177600.00 148800.00 current ratio 2.71 1.961 Net income $ 41700.00 32900.00 quick (acid-test) ratio 0.82 0.58 Assets AR turnover 52.56 Time 63.05- Current assets Inventory Turnover 274.62 Times 335.53 Cash $ 5700.00 7400.00 Debt to Equity Ratio 75.57 124.70i Marketable securities 3000.00 3000.00 Debt to assets ratio 43.04 % 56.00 iAccounts receivable 36200.00 30300.00 44900.00 Inventories 101200.00 94500.00 Average total assets 260250.00 Prepaid expenses 3200.00 2200.00 AVG total sharehold 133050.00 Total current assets 149300.00 137400.00 average AR 30300.00 Plant and equipment (net) 106400.00 106400.00 Average Inventory 94500.00 Intangibles 21000.00 0.00 NET SALE/AR 6.94 5.79 !Total assets $ 276700.00 243800.00 Liabilities and Stockholders' Equity COG/AVG IN 1.33 1.09 Liabilities 274.62 Current liabilities Accounts payable $ 38000.00 54600.00 Other 17000.00 15600.00 Total current liabilities 55000.00 70200.00 Bonds payable 64100.00 65100.00 Total liabilities 119100.00 135300.00 Stockholders' equity Common stock (48,000 shares) 113900.00 113900.00 Retained earnings 43700.00 (5,400 'Total stockholders equity 157600.00 108500.00 Total liabilities and stockholders' $ 276700.00 243800.00 Market Price 4.83 5.03

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

Survey Of Accounting

Authors: Carl S. Warren, Amanda Farmer

9th Edition

0357132599, 978-0357132593

More Books

Students also viewed these Accounting questions

Question

Describe the steps used to make location decisions.

Answered: 1 week ago

Question

5. Give some examples of hidden knowledge.

Answered: 1 week ago