please help, everything is given

i Data Table Selected balance sheet data 2015 Cash 2018 3,300 $ 500 7,400 Marketable securities. Accounts receivable, net..... 4,100 2,200 Inventory Total current assets. 6,300 17,500 6,800 2017 3,400 $ 600 6,800 4,300 15,100 7,100 22,200 2,600 5,600 9,700 2,065 2016 4,800 300 4,900 $ 2,500 12,500 7,600 20,100 2,100 4,900 8,800 6,580 Long-term assets Total assets Accounts payable Short-term notes payable 2,500 24,300 3,400 6,800 11.900 505 Total current liabilities Total long-term liabilities Print Done Data i Data Table 015 Sele Casi Marl Acco 100 Invel 200 Total Furniture industry averages Current ratio.. Quick ratio .... Days' inventory outstanding Days' sales outstanding Days' payable outstanding.... Debt ratio Times-interest-earned ratio ...... Gross margin percentage Operating income percentage Long Total Acca Shop 1.0 60.8 44.6 50.6 68% 19.6 58% 500 Total 22% Total Print Done Selected income statement data 2015 37,600 sales). Net sales revenue (assume all sales are credit Cost of goods sold .. 2018 40,100 $ 21,200 800 No 2017 2016 39,200 $ 38,500 $ 17,390 14,830 13,700 14,100 505 S610 1,179 1,244 . Operating expenses Interest expense Income taxes Print Done Selected data from Trenton Furniture, Inc., follows. Click the icon to view selected balance sheet data) Click the icon to view selected income statement data) Industry averages have been gathered for several mos (Click the icon to view the ratios. Read the requirements Requirement 1. Perform a trend analysis on Trenton's sales revenue, inventory, and receivables over the past tvee years, using 2015 in each of these areas favorable or unfavorable for the company Begin by calculating the trend analysis found the ratios to the nearest Whole percent XS) Net sales revenue Inventory Accounts receivable, net Is the trend in each of these areas favorable or unfavorable for the The trend percentage nel receivabless than the Inc in inventory indicat The trend percentage The trend percentages for sales revenue is which is V trend payment ability, and d) profitability Requirement 2. Using the industry averages as benchmarks, analyze Trenton's performance over the past three years in the following a liquidity, b) umover, coverall de a. Start by analyzing the liquidity ratios: the current ratio and the quick ratio. Select the formula and enter the amounts to calculate the current ratios for the years 2016 through 2018. Round the ratio to two decimal places, XXX) 2018 H che con lo view selected income woment data) Selected data from Trenton Furniture, Ine follows o pe icon to view selected balance sheet data) Industry everages have been thered for several ratios (Click the conto vow the mos) Read the requirements a dijumover, cover de payment and protety Requirement 2. Using the industry average as benchmarks, analye Trenton's performance over the past three years in the following r Start by analyzing the liquidity ratios: the current rate and the quick ratio Select the formula and enter the amount to calculate the current ratios for the years 2018 tough 2018. Round the most two decal s , X.XX) u sed cash and chequ e ochodo d ST homem Mond then details for the year 2018 rough 2018 A Neut, se ne formanden for the amounts to calore two decimal places, XXX) 2018 2017 2016 o m landing D cada inventory Select the founder em ore year 2018 2018 ro Deve r y butanding (0) ore year 2016 2018. Round the the formula and r emote cache correct m Selected data from Trenton Furniture, Inc., follows. Click the icon to view selected balance sheet data.) (Click the icon to view selected income statement data.) Industry averages have been gathered for several ratios. (Click the icon to view the ratios.) Read the requirements Select the formula and enter the amounts to calculate days' sales outanding (DSO) for the years 2016 through 2018. (Use a 365-day year, Round the D Days' sales outstanding (DSO) 2018 2017 2016 Select the formula and enter the amounts to calculate the accounts payable turnover for the years 2016 through 2018. (Round the ratios to two decimal Accounts payable turnover 2018 2017 2016 Select the formula and enter the amounts to calculate days' payables outanding (DPO) for the years 2016 through 2018. (Use a 365-day year. Round the - Days' payables outstanding (DPO) 2018 2017 2016 Choose from any list or enter any number in the input fields and then continue to the next question Selected data from Trenton Fumiture, Inc., follows. Click the icon to view selected balance sheet data.) (Click the icon to view selected income statement data.) Industry averages have been gathered for several ratios. (Click the icon to view the ratios.) Read the requirements Select the formula and enter the amounts to calculate the cash conversion cycle (in days) for the years 2016 through 2018. (Enter all amounts to o Cash conversion cycle 2018 2017 2016 c. Analyze the ability to pay long-term debt: debt ratio and times-interest-eared ratio. Select the formula and enter the amounts to calculate the debt ratios for the years 2016 through 2018. (Enter the ratios in decimal form (not as per Debt ratio 2018 2017 2016 Select the formula and enter the amounts to calculate the times-interest-eamed ratios for the years 2016 through 2018. (Round the ratios to oned Times-interest-earned ratio 2018 2017 Choose from any list or enter any number in the input fields and then continue to the next question Click the icon to view selected income statement data.) Selected data from Trenton Furniture, Inc., follows. Click the icon to view selected balance sheet data.) Industry averages have been gathered for several ratios. (Click the icon to view the ratios.) Read the requirements d. Analyze the profitability ratios: gross margin percentage and operating income percentage. Select the formula and enter the amounts to calculate the gross margin (gross profit) percentages for the years 2016 through 2018. (Round the ratiost Gross margin% 2018 2017 2016 Select the formula and enter the amounts to calculate the operating income percentage percentages for the years 2016 through 2018. (Round the rati Operating income % 2018 2017 2016 Selected data from Tronton Furniture, Inc., follows. (Click the icon to view selected balance sheet datn.) (Click the loon to view selected income statement data. Industry averages have been gathered for several ratios. (Click the icon to view the ratios.) Read the requirements Now, using the industry averages as benchmarks, analyze Trenton's performance over the past three years. Overall, Trenton's performance over the past three years looks and compare favorably to the industry averages. Most all the ralios showed over the three years. Trenton's performance over the past three years are due to: Select all that apply.) remains consistent A Improved interest coverage B. Decreased cash flow C. Improved accounts receivable tumover D. Increasing debt ratio E Declining earings OF Payment of accounts payable is getting faster G. Increasing long-term labilities BH Operating income percentages are decreasing CLDecreasing gross margin D J inability to collect accounts receivable OK Buildup of inventories Requirement 3. Evaluate Trenton's quality of earnings. Are there any red flags in your analysis? Explain Choose from any list or enter any number in the input fields and then continue to the next question, Requirement 3. Evaluate Trenton's quality of earnings. Are there any red flags in your analysis? Explain. First, select the formula and enter the amounts to calculate the net income percentage ratios for years 2016 through 2018. (Round the ratios to one-tenth percent, XX%) Net income % 2018 2017 2016 Refer to the quality of earnings ratios you calculated in Requirements 2 and 3 and evaluate Trenton's quality of earnings. Are there any red flags in your analysis? Explain All the ratios are Quality of earings is Industry averages have been gathered for several ratios. (Click the icon to view the ratios.) Read the requirements E. Declining earnings DF Payment of accounts payable is getting faster G. Increasing long-term liabilities H. Operating income percentages are decreasing Ol Decreasing gross margin J. Inability to collect accounts receivable K. Buildup of inventories Requirement 3. Evaluate Trenton's quality of earnings. Are there any red flags in your analysis? Explain. First, select the formula and enter the amounts to calculate the net income percentage ratios for years 2016 throug = Net income % 2018 2017 2016 declining. improving. III Refer to the quali stable, you calculated in Requirements 2 and 3 and evaluate Trenton's quality of ear All the ratios are Quality of eamings is Choose from any list or enter any number in the input fields and then continue to the next