2017 | 2018 | Getting better or getting worse | 2018 Industry average | Good or Bad compare to Industry average 2018 | |||
Profit margin = net income/sales | 105000/1100000 | 9.55% | 98700/1155000 | 8.55% | Getting Worse | 8.00% | good |
current ratio = current assets /current liabilities | 245000/140000 | 1.75 | 251350/161000 | 1.56 | Getting Worse | 1.9 | Bad |
quick ratio = quick assets/current liabilities | 165000/140000 | 1.18 | 163350/161000 | 1.01 | Getting Worse | 1.12 | Bad |
quick assets = total current assets-inventory | 245000-80000 | 165000 | 251350-88000 | 163350 | |||
return on assets =net income/average total assets | 105000/595000 | 17.65% | 98700/608675 | 16.22% | Getting Worse | 15% | Good |
average total asset = (beginning balance+year end balance)/2 | 595000 | (595000+622350)/2 | 608675 | ||||
debt to asset ratio = total of liabilities/toatal assets | 290000/595000 | 0.49 | 316000/622350 | 0.51 | Getting Worse | 0.55 | Good |
receivable turnover ratio = sales/average accounts receivables | 1100000/110000 | 10 | 1155000/110550 | 10.45 | Getting better | 18 | Bad |
average accounts receivables = (beginning balance+year end balance)/2 | 110000 | (110000+111100)/2 | 110550 | ||||
average collection period = 360/receivable turnover ratio | 360/10 | 36 | 360/10.45 | 34.46 | Getting better | 21.2 | Bad |
Inventory turnover ratio = cost of sales/average inventory | 325000/80000 | 4.06 | 351000/84000 | 4.18 | Getting better | 8.25 | bad |
average inventory = (beginning balance+year end balance)/2 | 80000 | 80000 | (80000+88000)/2 | 84000 | |||
return on equity = net income/average total equity | 105000/305000 | 34.43% | 98700/305675 | 32.29% | Getting Worse | 25% | Good |
average total equity = (beginning balance+year end balance)/2 | 305000 | 305000 | (305000+306350) | 305675 | |||
Times interest earned = EBIT/Interest expense | 200000/25000 | 8 | 194500/30000 | 6.48 | Getting Worse | 8.15 | bad |
U Format BUSI 320 Comprehensive Problem 1 Summer 1 2Use the following Information to answer the...
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...
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...
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...
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 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...
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...
E ry es. Save inkedi. St Auto inkedi. inkedi A B D 1 BUSI 320 Comprehensive Problem 1 Version FALL 2 Use the following information to answer the questions below: 3 note: all sales are credit sales 4 5 Income Stmt info: 2019 2020 6 Sales S 800,000 $ 880,000 7 less Cost of Goods Sold: 220,000 240,000 8 Gross Profit 580,000 640,000 9 Operating Expenses 480,000 505,000 10 Earnings before Interest & Taxes 100,000 135,000 11 Interest exp 25,000...
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 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...
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...