Need help finding ratio for 2021 and 2020
Consolidated Balance Sheets - USD ($)$ in Millions Dec. 31, 2021 Dec. 31,2020 Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Operating leases Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term lease liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01 par value: Authorized shares - 500; Issued and outstanding shares - none Common stock, \$0.01 par value: Authorized shares - 5,000; Issued shares - 527 and 532; Outstanding \begin{tabular}{|r|r|} \hline$36,220 & $42,122 \\ \hline 59,829 & 42,274 \\ \hline 32,640 & 23,795 \\ \hline 32,891 & 24,542 \\ \hline 161,580 & 132,733 \\ \hline 160,281 & 113,114 \\ \hline 56,082 & 37,553 \\ \hline 15,371 & 15,017 \\ \hline 27,235 & 22,778 \\ \hline 420,549 & 321,195 \\ \hline \end{tabular} shares 503 and 509 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity \begin{tabular}{|r|r|} \hline 78,664 & 72,539 \\ \hline 51,775 & 44,138 \\ \hline 11,827 & 9,708 \\ \hline 142,266 & 126,385 \\ \hline 67,651 & 52,573 \\ \hline 48,744 & 31,816 \\ \hline 23,643 & 17,017 \\ \hline \end{tabular} Consolidated Statements Of Operations - USD (\$) shares in Millions, \$ in Millions Total net sales \begin{tabular}{|l|r|} \hline 12 Months Ended \\ \hline Dec. 31,2020 & Dec. 31,2019 \\ \hline$386,064 & $280,522 \\ \hline \end{tabular} Operating expenses: Cost of sales Fulfillment Technology and content Marketing General and administrative Other operating expense (income), net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity-method investment activity, net of tax \begin{tabular}{|r|r|r|} \hline 272,344 & 233,307 & 165,536 \\ \hline 75,111 & 58,517 & 40,232 \\ \hline 56,052 & 42,740 & 35,931 \\ \hline 32,551 & 22,008 & 18,878 \\ \hline 8,823 & 6,668 & 5,203 \\ \hline 62 & (75) & 201 \\ \hline 444,943 & 363,165 & 265,981 \\ \hline 24,879 & 22,899 & 14,541 \\ \hline 448 & 555 & 832 \\ \hline(1,809) & (1,647) & (1,600) \\ \hline 14,633 & 2,371 & 203 \\ \hline 13,272 & 1,279 & (565) \\ \hline 38,151 & 24,178 & 13,976 \\ \hline(4,791) & (2,863) & (2,374) \\ \hline 4 & 16 & (14) \\ \hline$33,364 & $21,331 & $11,588 \\ \hline$65.96 & $42.64 & $23.46 \\ \hline$64.81 & $41.83 & $23.01 \\ \hline \end{tabular} Net income Basic earnings per share (in dollars per share) Diluted earnings per share (in dollars per share) Weighted-average shares used in computation of earnings per share: Basic (in shares) Diluted (in shares) Net product sales Total net sales Net service sales Total net sales \begin{tabular}{l|l|l|} $228,035 & $170,149 & $120,114 \end{tabular} Current Ratio Current Assets/Current liabilities All numbers in the ratio calculations must be linked to the financial statement tabs. No numbers can be hard coded in the formula. For example, the current ratio would look something like this: =Balance Sheet B5/Balance Sheet B16 where B5 is current assets and B16 is current liabilities. All ratios must be computed for two years. - Net Profit Margin = Net Income / Revenues - Gross Profit Margin = (Net Sales Revenue Cost of Goods Sold) / Net Sales Revenue - ROE= Net Income/Average Common Stockholders' Equity - Current Ratio = Current Assets / Current Liabilities - Days to Collect =365 / Receivables Turnover - Receivables Turnover = Sales or Revenue / Average Receivables - Days to Sell =365 / Inventory Turnover - Inventory Turnover = Cost of Goods Sold / Average Inventory - Debt to Assets = Total Liabilities / Total Assets *These ratios require an average calculation. To calculate the prior year average for your comparison, you will have to find the prior year 10K (scroll until you find it on the SEC website)
