Question

Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2017 2018 less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000 1,100,000 424,000 676,000 365,750 310,250 25,500 284,750 113,900 400,000 600,000 350,000 250,000 225,000 90,000 Net Income S 135,000 170,850 12/31/18 30,000 51,000 125,000 131,250 200,000 212,250 300,000 S315,000 500,000 527,250 12/31/17 Balance Sheet info: Cash Accounts Receivable Inventory Total Current Asset:s 25,000 S 50,000$ 1Fixed Assets (Net) Total Assets Current Liabilities Long Term Liabilities 110,000121,000 180,000188,000 290,000$ 309,000 6 Total Liabilities Stockholders Equity 210,000S 218,250 8 Total Liab & Equity: $500,000 527,250
Compute each of the following ratios for 2017 and 2018 and indicate whether each ratio was getting better or worse from 2017 to 2018 and was good or bad compared to the Industry Avg in 2018 (round all numbers to 2 digits past the decimal place) Good or Bad Getting Bett er or 2018 compared Getting Industry to Industry Avg 2018 Worse? Avg 6 Profit Margin 7Current Ratio 1.90 0.66 Quick Ratio 9Return on Assets 0 Debt to Assets 1 Receivables turnover .50 18.00 15.50 9.25 0.55 11.15 2Avg. collection period 3 Inventory Turnover 4 Return on Equity Times Interest Earned Assume a 360 day year 8 Inventory Turnover can be computed 2 different ways. Use the formula listed in the text 9 (the one the text indicates many credit reporting agencies generally use) 0
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Name of ratio Formula 2017 2018 Industry average Good/Bad analysis
Profit margin Net profit/Sales 13.5% 15.53% 11% It is increasing in 2018 and it is better than industry average
Current ratio Current assets/current liabilities 1.81 1.75 1.90 It is decreasing in 2018 and worse than industry average.
Quick ratio (Cash+Receivables)/current liabilities .68 .67 .66 It is almost same in both the years and industry average.
Return on asset Net income/Total assets 27% 32% 28% It is increasing in 2018 and it's better than industry average.
Debt/Asset Total liabilities/Total assets .58 .58 .50 It is almost same in both the years but worse than industry average, lower ratio is good.
Add a comment
Know the answer?
Add Answer to:
Use the following information to answer the questions below: note: all sales are credit sales Income...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • FILL IN THE BLANKS Use the following information to answer the questions on page 2 below...

    FILL IN THE BLANKS Use the following information to answer the questions on page 2 below Note: all sales are credit sales Income Stmt info: 2017 2018 less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income Sales 1,000,000 $1,100,000 424,000 676,000 365,750 310,250 25,500 284,750 113,900 170,850 400,000 600,000 350,000 250,000 25,000 225,000 90,000 135,000 $ 12/31/ Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets...

  • Use the following information to answer the question below: note all sales are credit sales. Compute...

    Use the following information to answer the question below: note all sales are credit sales. Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the industry Avg. 2019 (round all numbers to 2 digits past the decimal place). Income Stmt info: 2018 2019 Sales $ 1,000,000 $ 1,050,000 less Cost of Goods Sold: - 400,000 _ 432.000 Gross...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below:...

    BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2018 Sales $ 1,000,000 less Cost of Goods Sold: 400.000 Gross Profit 600,000 Operating Expenses 350,000 Earnings before Interest & Taxes 250,000 Interest exp - 20.000 earnings before Taxes 230,000 Taxes 69.000 Net Income $ 161,000 2019 $ 1,050,000 432.000 618,000 365,750 252,250 20.400 231,850 69.555 $ 162,295 Balance Sheet info: Cash Accounts Receivable Inventory...

  • L M N BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer...

    L M N BUSI 320 Comprehensive Problem 1 Spring 2020 Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit 2018 1,000,000 $ 400,000 600,000 2019 1,050,000 432,000 618,000 Compute each of the following ratios for 2018 and 2019 and indicate whether each ratio was getting "better" or "worse" from 2018 to 2019 and was "good" or "bad" compared to the Industry Avg...

  • U Format BUSI 320 Comprehensive Problem 1 Summer 1 2Use the following Information to answer the...

    U Format BUSI 320 Comprehensive Problem 1 Summer 1 2Use the following Information to answer the questions below 3note: all sales are credit sales Income Stmt info: 2018 Sales S less Cost of Goods Sold: 1,100,000 1,155,000 Gross Profit 775,000 804,000 Operating Expenses 575,000 609,500 10 Earnings before Interest & Taxes Interest exp earnings before Taxes 175,000 164,500 13 Taxes 14 Net income S 98,700 15 16 Balance Sheet info: 12/31/17 12/31/18 55,000 S 17 Cash 52,250 18 Accounts Receivable...

  • 1 TE22 DE DE &a...EEEEEEEEE Income Stmt info: 2018 2017 Sales $ 900,000 $ 990,000 less...

    1 TE22 DE DE &a...EEEEEEEEE Income Stmt info: 2018 2017 Sales $ 900,000 $ 990,000 less Cost of Goods Sold: 325,000 346,125 Gross Profit 575,000 643,875 Operating Expenses 450,000 477,000 Earnings before Interest & Taxes 125,000 166,875 Interest exp 25,000 31,000 earnings before Taxes 100,000 135,875 Taxes 40,000 54,350 Net Income $ 60,000 $ 81,525 12/31/2018 63,600 89,600 Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) Total Assets 12/31/2017 60,000 80,000 110,000 250,000 300,000 550,000...

  • Please provide step by step explanation for answer. BUSI 320 Comprehensive Problem 1 Version FALL Use...

    Please provide step by step explanation for answer. BUSI 320 Comprehensive Problem 1 Version FALL Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 2019 800,000 $ 220.000 580,000 480.000 100,000 25,000 75,000 25.000 50,000 $ 2020 880,000 240.000 640,000 505.000 135,000 25.000 110,000 30.000 80,000...

  • g 3. Given the balance sheet and income state for Simmons Maintenaethet Simmons & Professional Studies...

    g 3. Given the balance sheet and income state for Simmons Maintenaethet Simmons & Professional Studies ratios that are also shown for the industry average. For each ratio,indica is better or worse than the industry average. For inventory turn cost of goods sold. Company, compute the use sales rather than SIMMONS MAINTENANCE COMPANY Assets Cash Acets. Receivable Inventory Current Assets Net Fixed Assets Liabilities S 15,000 Accounts Payable S 21,000 22,000 Notes Payable 20,000 30,000 Accrued Expenses 67,000 Current Liabilities...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT