I need help with this long finance problem. I have attached the screenshots containing info and the questions.

Spreadsheet problem 0 Make a spreadsheet of the first 7 lines of Gucci's 'Consolidated Statements of income\" for 2003, 2002 and 2001. Create additional columns to show Gross Prot Margin, Operating Prot Margin and all expenses as a percent of sales. Write 2-3 sentences explaining which expenses contributed to the decrease in operating profit from 2001 to 2003. Calculate the Current Ratio for 2002 and 2003 and explain what the comparison of this ratio between the two years tells you. What, if anything, should you be concerned of as an investor? Calculate the Quick/A cid Test Ratio for 2002 and 2003 and explain what this ratio tells you. Calculate inventory turnover for 2003 and 2002. (use year-end asset balances, rather than average balances.) What does the difference in inventory turnover tell you about the company's performance? A. Calculate the difference in cash and cash equivalents from 2002 to 2003. B. What was the single largest use of that cash? (a cash equivalent would be anything that can be liquidated easily, like marketable securities). M can be used/generated through income statement, assets, loans and moves in shareholder equity. Submit as an Excel spread sheet through canvas with all formulas in place. GUCCI GUCCI GROUP GUCCI GROUP N. V. - Consolidated balance sheets (In thousands of Euro) 2003 2002 Assets Current assets Cash and cash equivalents 1,270,748 2,782,588 Short-term financial assets 380,091 Trade receivables, net 352,525 331,834 Inventories, net 495,655 472,028 Current value of hedge derivatives 70,790 110,559 Other current assets 276,462 326,186 Total current assets 2,846,271 4,023,195 Non-current assets Long-term financial assets 17,446 408,079 Property, plant and equipment, net 941,272 912,497 Goodwill, trademarks, other intangible assets and deferred charges, net 1,976,339 2,110,015 Deferred tax assets 289,996 263,671 Other non-current assets 104,905 63,150 Total non-current assets 3,329,958 3,757,412 Total assets 6,176,229 7,780,607 Liabilities and shareholders' equity Current liabilities Bank overdrafts and short-term loans 423,687 630,534 Trade payables and accrued expenses 473,248 478,479 Tax liabilities and income tax payable 93,968 143,857 Other current liabilities 91,892 119,262 Total current liabilities 1,082,795 1,372,132 Non-current liabilities Long-term financial payables 1,318,292 1,202,411 Pension liabilities and severance indemnities 55,124 50,831 Long-term tax payable and deferred tax liabilities 339,195 381,052 Other long-term liabilities 25,181 38,182 Total non-current liabilities 1,737,792 1,672,476 Total liabilities 2,820,587 3,044,608 Minority interests 41,714 54,566 Shareholders' equity Share capital 106,159 104,688 Contributed surplus 1,478,543 2,790,401 Retained earnings 1,145,388 968,745 Treasury stock, at cost (261,328) (173,274) Accumulated other comprehensive income 670,919 754,119 Net result for the year 174,247 226,754 Shareholders' equity 3,313,928 4,671,433 Total liabilities, minority interests and shareholders' equity 6,176,229 7,780,607 The accompanying notes are an integral part of these consolidated financial statements.GUCCI ciCCI CFCED GUCCI GROUP N.V. - Consolidated statements of income (In thousands of Euro, except per share and share amounts) 2003 2002 2001(*) Net revenues 2,587,390 2,544,286 2,565,116 2 Cost of goods sold 851,984 802,007 773,399 3 Gross profit 1,735,406 1,742,279 1,791,717 4 Selling, general and administrative expenses 1,463,026 1,433,276 1,393,123 5 Restructuring expenses 27,008 3,144 6 Goodwill and trademark amortization 125,575 126,418 130,209 7 Operating profit 119,797 179,441 268,385 Restructuring expenses (750) Financial income, net 11,881 62,796 88,123 Other income (expenses), net 13,695 (1,257) 10,586 Income before income taxes and minority interests 145,373 240,980 367,844 Income tax expense (benefit) (22,115) 19,286 58,679 Net income before minority interests 167,488 221,694 309,165 Minority interests 6,759 5,060 3,370 Net income for the year 174,247 226,754 312,535 Net income per share of common stock - basic 1.75 2.24 3.12 Weighted average number of shares - basic 99,518,957 101,060,751 100,174,358 Net income per share of common stock - diluted 1.73 2.21 3.08 Weighted average number of shares and share equivalents - diluted 100,697,227 102,422,918 101,524,040 (*) The Euro amounts have been calculated from previously published US Dollar amounts in accordance with the criteria disclosed in Note 3 to these consolidated financial statements. The accompanying notes are an integral part of these consolidated financial statements.Company History What is Gucci Group's History? Highlights of the Company's history are as follows: 1921 Company founded by Guccio Gucci in Florence, Italy 1953 Opening of the New York store (beginning of internationalization) 1961 Opening of the London store (first European store outside Italy) 1972 Opening of the first franchise store in Japan 1987-89 Investcorp acquires a 50% interest from members of the Gucci family 1993 Investcorp acquires the remaining 50% interest from Maurizio Gucci 1994 Turnaround begins under CEO Domenico De Sole and Creative Director Tom Ford 1995 October Initial Public Offering on AEX and NYSE at US$ 22 per share 1996 March Secondary Offering at US$ 48 per share 1997 November Acquisition of watch licensee, renamed Gucci Timepieces 1999 January LVMH acquires 34% of Gucci Group shares March Strategic alliance with PPR*, a global player in retail and luxury goods.* November Acquisition of Sergio Rossi (70%)** December Acquisition of Yves Saint Laurent (100%) and YSL Beaute (100%) 2000 May Acquisition of Boucheron (100%) December Partnership with Alexander Mcqueen (51%) ** December Acquisition of Bedat & Co. (85%) 2001 February Acquisition of Bottega Veneta (78.5%) March Acquisition of Di Modolo (100%) April Partnership with Stella Mccartney (50%) ** July Acquisition of Balenciaga (91%) September Settlement agreement among Gucci Group, LVMH and PPR 2004 April PPR successfully offers to purchase minority interests in Gucci Group at US$ 85.52 per share July The public offering launched by PPR is completed. Gucci Group becomes a fully owned company and is delisted from Amsterdam and New York stock exchange. Gucci Group appoints Robert Polet as President, Chief Executive Officer as well as Chairman of the Management board and announces the New Designer leadership. Issue of 39 million new shares at US$ 75 per share to PPR; LVMH holdings in Gucci Group becomes approximately 20% ** In January 2004 Gucci Group's ownership of Sergio Rossi went to 100%. ** * Announcement ata