Please put in excel table and please provide the formula and answer. Thank you

406 Chapter 16 How to Read, Anatyze, and Interpret Financieat Reports LU 16-3a EXTRA PRACTICE QUIZ ITH Prepare a trend analysis from the following sales, assuming a base year of 2015. Roand to the nearest whole percent. Need more practce? Try thds Extra Practice Gula (check tigures to the Interactive Chopter Ogandx). Worked-out Solutions can be lound in Appondix B at end of teat 1. 2018 2017 2016 2015 Sales $25,000 $60,000 $50,000 $70,000 2. Given: Total current assets (CA), $14,000, accounts receivable (AR), S5,500, tocal cur rent liabslities (CL), 59,000, imveatory (Inv), $3,900 met sales, $36,500, total assets, $32,000, net income (NT, $8,000.Calculate a. Current ratio. b. Acid test e. Average day's collection d. Profit margin on sales (round to the nearest hundredth percent). INTERACTIVE CHAPTER ORGANIZER You try it Balance sheet Vertical analysis Current assets $520 52%|Do vertical analysis $ 400 600 ? report (down the column) to a totel figure. Th denominator for o balance sheet is tous $1,000 100% Total assets $1,000 ? Total assets ossets (or total liabilities + owners equityl. for an income statement it is net sales 2016 ,Change! % De herizontal analysis Hortzontal analysis Anolyting comperative financial reports shows rate and amount of change across columns tem by tem. New ine hem amount- Old line item amounyOid line item amout 2017 |2016 Ch Ca $5.cool $4.000 SLOOO 1.29% Calculate net sales Gross sales, $400 Sales returns and alowances, $20 Sales discount $5 $200 gross sales Net sales Gross Sales returns Sales seles and allowonces discounts - 10 sales returns and allowences - 2 sales discounts $188 net saies $50+$100-$20-$130 Beginning inventory+ Net prchases-merchandise sold Ending inventory Costs of meichandse Beginning inventory. $50 goods) soid Calculate cost of Cost of merchandise (goods) sold eeginning Net invemory purchases inventbory Ending Net purchases, $200 Ending inventory, $20 Calculate gross profit Net sales, $400 Gross profit from seles $188- $130 -$58 gress prof from sales Cost of merchandse (goods) sold Net sales- Net sales - Cost of me chandise igoods) Cost of merchandse sold, $250 sold Gross profa feom sales Calculate net income $58 -$28 $30 Gross proft trom saies-OperatingGross profit $210 expenses Net income Gioss profit-Operating expenses Operoting expenses, $180