I need efficiency ratio from this balance sheet along with an explanation and analysis of the data.

This assignment has two parts. 1. Your first posting should accomplish two things. .First, calculate two financial ratios for each of the past two fiscal years. (In other words, you'l calculate a total of four ratios: one ratio for each of the two years ended 3/3/18 and 2/25/17, then a second ratio for the same two years.) Your two ratios should be selected from among the liquidity and efficiency, solvency, and profitability ratios summarized on page 736 of the textbook; for this assignment, you should ignore the market prospects ratios. Forfull credit, be sure to show all calculations. Second, analyze the data you've calculated in the first part. How do you assess the financial ratios in the two years, and the trend that they reveal? Is it a favorable or an unfavorable indicator? What insights do your calculations give you into Bed Bath & Beyond's financial condition? Your analysis should total approximately 2 to 4 sentences. Consolidated Selected Financial Data (in thousands, except per share and selected operating data) Fiscal Year Ended) March 3, 2018(2) February 25, 20173) February 27, 2016 February 28, 2015 March 1, 2014 Statement of Earnings Data Net sales Gross profit Operating profit Net earnings Net earnings per share Diluted Dividends declared per share(6) Selected Operating Data Number of stores open (at period end) Total square feet of store space (at period end) Percentage (decrease) increase in comparable sales(4) Comparable sales (in 000's)(4) Balance Sheet Data (at period end) Working capital Total assets Long-term sale/leaseback and capital lease obligations Long-term debts) Shareholders' equity(67) $12,349,301 $12,215,757 $12,103,887 $11,881,176 $11,503,963 4,443,015 4,576,350 4,620,310 4,619,7794,565,582 1,614,587 957,4741,022,290 4.79 761,321 424,858 1,414,903 1,554,2931, 685,108 841,489 3.04 S 0.60 $ 4.58 $ 0.50 $ 5.10 S 5.07 S 1,496 43,681,000 43,619,000 43,274,000 43,041,000 42,619,000 1,552 1,546 1,530 1,513 (0.6%) 1.0% 2.4% 2.4% $11,813,092 $11,701,042 $11,722,973 $11,517,454 $10,660,573 $ 1,805,393 $ 1,559,400 $ 1,757,282 $ 1,933,647 $ 1,752,639 7,040,806 6,822,655 6,487,6776,749,665 6,356,033 108,046 106,948 1,492,078 1,491,603 1,491,137 1,490,672 105,614 107,136 109,274 $ 2,888,628 $ 2,719,277$ 2,559,540 $ 2,743,190 $ 3,941,287