i have uploaded the first picture with directions on how to do this problem. if you could please help me and PLEASE SHOW/HOW to do the work needed to complete each row in the last three pictures. thank you so much!

Project #2 Financial Statement Analysis (25 points). Due date: Sunday, November 28, 2021 This assignment involves an analysis of the financial ratios of Apple Inc. You will be required to examine Apple's most recently published financial statements (September 25th, 2021) and (1) calculate the ratios identified below. This will involve calculating the financial ratios for the years ended September 25, 2021 and September 26, 2020. For each ratio you calculate, it is important that you show your workings as written proof of how the ratios were calculated. (2) comment on each of the ratios, indicating whether the 2021 figures were an improvement or not on the 2020 figures. Apple Inc. CONDENSED CONSOLIDATED STATEMENTS OF OPERATIONS (Unaudited) (in millions, except number of shares which are reflected in thousands and per share amounts) Three Months Ende Twelve Months Ented September 25. September 26, September 25. September 26, 2021 2020 2021 2020 Net sales Products 65,083 S 50,149 5 297,3925 220,747 Services 18.277 14549 68.425 53.768 Total net sales 83.360 54.698 365,817 274,515 Cost of sales Products 42,790 35,197 192 266 151,286 Services 5,396 4812 20715 18.273 Total cost of sales 48,186 40.009 212,981 169559 Gross margin 35,174 24,689 152,836 104,956 Operating expenses: Research and development Selling, general and administrative Total operating expenses 5,772 5,616 11,388 4,978 4,936 9.914 21,914 21973 43,887 18.752 19,916 38,668 Operating income Other income/expense), net Income before provision for income taxes Provision for income taxes Net Income 23,786 (538) 23,248 2.697 20,5515 14.775 126 14,901 2.228 12,673 5 108,949 258 109.207 14527 94,680 5 66.288 803 87,091 9680 57,411 S 1.255 1.24 0.74 $ 0.73 $ 5.67 $ 5.61 $ 3.31 3.28 Earnings per share Basic Diluted Shares used in computing earnings per share: Basic Diluted 16.487,121 16,635,097 17.057.622 17.256,521 16.701.272 16,864,919 17.352.119 17,528,214 Net sales by reportable segment: Americas Europe Greater China Japan Rest of Asia Pacific Total net sales 36,820 $ 20,794 14.563 5,991 5.192 83,350 $ 30.698 $ 16,900 7.946 5,023 4131 64,698 5 153,306 $ 89,307 68.366 28,482 26.256 365,817 $ 124.556 68,640 40,308 21,418 19.592 274,515 5 th Net sales by category Phone Mac Pad Wearables, Home and Accessories Services Total net sales 38,868 $ 9,178 8,252 8,785 18.277 83.360 $ 26.444 9,032 6,797 7,876 14549 64 698 191,973 $ 35,190 31,862 38,367 6R 425 365817_$ 137,781 28,622 23.724 30.620 53.268 274,515 $ Apple Inc. CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS (Unaudited) (in millions) Tete Mantha Eaded September 25, September 26, 2021 2020 $ 39,789 $ 50,224 94,680 57,411 11284 7,906 14.774 1147) 11,056 6.829 (215) 1971 110,125 2.6423 13.9031 (8.042 12325 1676 5.299 104,038 6,917 1127) 1,553 19,5881 (4,062) 2081 8.916 80,674 Cash, cash equivalents and restricted cash, beginning balances Operating activities Net income Adjustments to reconcilie net income to cash generated by operating activities Depreciation and amortization Share-based compensation expense Deferred income tax benefit Other Changes in operating assets and liabilities Accounts receivable, net Inventories Vendor non-trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current abilities Cash generated by operating activities Investing activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in comection with business acquisitions, net Other Cash used in investing activities Financing activities: Proceeds from issuance of common stock Payments for taxes related to net share settlement of eculty awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Proceeds from/ Repayments of commercial paper, net Other Cash used in financing activities Decrease in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, ending balances Supplemental cash flow disclosure Cash paid for income taxes, net Cash paid for interest (109.558 59.023 47460 (11085) 33 1952 (14,545) (114,938) 69,918 50,473 17,3091 (1.524) 1909 14.289) 1105 16.5561 (14 467) 185.971 20,393 18.750) 1022 1291 193.353 (3.8603 35,929 $ 880 (3,634) (14,081) 172.358) 16,091 112,629) 1963) (1261 (86.820) 10,435) 39.789 $ $ $ 25,385 $ 2,687 5 9,501 3,002 Evidence of Ratio Calculations: Please show your calculations of the financial ratios of Apple Inc. for year ended September 25, 2021' and September 26, 2020 below. Please submit this sheet. Ratio Year ended Year ended September 25, 2021 September 26, 2020 LIQUIDITY AND EFFICIENCY Current Ratio Acid-Test Ratio Accounts Receivable Turnover Total Asset Turnover SOLVENCY Debt Ratio Debt-to-Equity Ratio PROFITABILITY Profit Margin Ratio Return-on-Total Assets Ratio Gross Profit Ratio a.k.a. Gross Margin Ratio Ratio Year ended Year ended September 25, 2021 September 26, 2020 Return-on- Common Stockholders Equity Ratio Basic Earnings Per Share PROFITABILITY Profit Margin Ratio Return-on-Total Assets Ratio Gross Profit Ratio a.k.a. Gross Margin Ratio Ratio Year ended Year ended September 25, 2021 September 26, 2020 Return-on- Common Stockholders Equity Ratio Basic Earnings Per Share MARKET PROSPECTS Price/Earnings Ratio (Search for common stock price at the date of the financial statements)