c. Ratios. The following Ratios MUST BE CALCULATED and PRESENTED for Amazon and Apple for the year 2022 and 2021. Current Ratio, Inventory Turnover, Gross Profit Percentage, AR Turnover, and Debt to equity Ratio. d. Based on the ratios calculated Part C, please answer the following questions. i. Based on the Ratios for each company, which company had the higher Gross Profit Percentage in 2021 and 2022? How many days does it take for Apple and Amazon to sell through their inventory in 2022? Which company had the riskier debt-to-equity ratio in 2021 and 2022? Which company has the "best" current ratio in 2021 and 2022? Which company is collecting their accounts receivable (net receivables) faster in 2022? ii. iii. iv. for Apple? And for Amazon? V.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 2 & A & D & c & D & E & F & G & H & 1 \\ \hline 1 & Amaroncem, he, Data & Ame rear: & & & & \multicolumn{4}{|c|}{ Herleontal Analyh } \\ \hline 2 & 4 & 2020 & 2021 & 2022 & & & & 2021 & 2027 \\ \hline 3 & Tolul hevenus: & 186.064000 & 469.822 .000 & 513,9n3.000 & & Total lievenue & & 21.70x & 940x \\ \hline 4 & Cent of Rommue & 134.544 .900 & 403,507,000 & 446,343,000 & & Cost ef Revenue & & 20.514 & 10.925 \\ \hline 5 & Gresu Profit & 51,500,000 & 46,315,000 & 67,640,000 & & Gross Prodit & & 2377s & 200x \\ \hline 6 & Oberatine byense & 72.01000 & 41416,000 & 55.792,000 & & Operating Gopense & & 44.83s & \\ \hline y & Operating income & 27,490,000 & 24,270,000 & 12,241,000 & & Opdratine Income. & & 1.63N & 5077x \\ \hline a & & 1,092,000 & 1,161,000 & 1,374.000 & & Net Non Operating Interest inceme fopmie. & & 24.61x & 125x \\ \hline 9 & Other lincome fopense & 2371000 & 14,631,000 & 16.906,000 & & Other income Erpenie. & & 517172 & 214.45x \\ \hline 10 & Fritar hiceme & 24,176,000 & 38,151,000 & $2936.000 & & Preaxinceme & & 57.79x & 11556k \\ \hline 11 & Tar Provision & 3,217,000 & 4,791,000 & .3 .217 .000 & & Fan Provisien. & & 24a93x & .167.15x \\ \hline 12 & Lamines trom fquity intersat Net of far & 16,000 & 4,000 & 3,000 & & faning from fquaty infernt Net of Tar & & 75.00x & 175.00x \\ \hline 13 & Nit income & 21,331,000 & 3,364000 & +2,722,000 & & Net income & & 56.41x & +10016x \\ \hline \end{tabular} c. Ratios. The following Ratios MUST BE CALCULATED and PRESENTED for Amazon and Apple for the year 2022 and 2021. Current Ratio, Inventory Turnover, Gross Profit Percentage, AR Turnover, and Debt to equity Ratio (3 points each =15 points). d. Based on the ratios calculated Part C, please answer the following questions. ( 3 point each =15 points) i. Based on the Ratios for each company, which company had the higher Gross Profit Percentage in 2021 and 2022? ii. How many days does it take for Apple and Amazon to sell through their inventory in 2022 ? iii. Which company had the riskier debt-to-equity ratio in 2021 and 2022? (Please refer to Financial Statement Analysis Notes) iv. Which company has the "best" current ratio in 2021 and 2022? (Please refer to Financial Statement Analysis Notes) v. Which company is collecting their accounts receivable (net receivables) faster in 2022 ? \begin{tabular}{|c|c|c|c|} \hline Apple line. (AAPLJ Dats & Bue Year & & \\ \hline & 2020 & 2021 & \\ \hline Docal Renmue. & 274,515,009 & 355,817,000 & 324,328,000 \\ \hline Cont of themon & 165,559000 & 212981,000 & 23545000 \\ \hline Cros Froft: & 104056,000 & 152336000 & 170,72,000 \\ \hline Opertipg frpenst & 38,668,000 & 43,417,000 & 51,145,000 \\ \hline Coerutine lincome. & 66.238000 & 108949000 & 119,437,000 \\ \hline Net Non Cunating interint inceme Erpense & 890,000 & 198000 & .106 .000 \\ \hline Other thcome fapense & 803.000 & 238.000 & .334 .000 \\ \hline Preatincone & 67.091,000 & 109.207,000 & 119,101,000 \\ \hline Fan brovises: & 3,510,000 & 14,527,000 & 19.300,000 \\ \hline Net income & 57,411.000 & 54.580 .000 & 99,501,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Hertusntal Analvils } \\ \hline= & 2021 & 2027 \\ \hline Fotat Revmice. & 33263 & \\ \hline Cost or livenue & 25.6s & 4965 \\ \hline GreapreAt. & 45.67 & 11.76x \\ \hline Gperutinc Copmie & 13.50s & 15.998 \\ \hline Operatipt inconte & 64365 & 9.5315 \\ \hline & & 45334 \\ \hline Oater inceone Expenie & 07078 & 279.46x \\ \hline Dretar incoine & 62.77 & .906s \\ \hline Tormprovilen & 30075 & 32.165 \\ \hline Net income & 64.925 & 543 \\ \hline \end{tabular} Note: Apple's fucal vear endr in September 2 1. Which company had the higher increase in total revenue from 2021 to 2022? AMNON 2. Which company had the higher increase in net income from 2021 to 2022 ? APPUE 3. In 2022, for every dollar of revenue, Amazon bas a profit of 2. For every dollar of revenue, Apple has a profit of \begin{tabular}{|l|ll|} \hline hint sen Vertid mens for \\ \hline Amazon & S & (0.005) \\ \hline Apple & 5 & 0.253 \\ \hline \end{tabular} 4. Cost of Revenue (COCS) is what percentage of total revenue for the year 2022 for Amazon? And for Apple? hint See Vetral Aumbis for both sampanin \begin{tabular}{|l|r|} \hline Amaron & 86.84x \\ \hline Apple & 56.69% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 2 & A & D & c & D & E & F & G & H & 1 \\ \hline 1 & Amaroncem, he, Data & Ame rear: & & & & \multicolumn{4}{|c|}{ Herleontal Analyh } \\ \hline 2 & 4 & 2020 & 2021 & 2022 & & & & 2021 & 2027 \\ \hline 3 & Tolul hevenus: & 186.064000 & 469.822 .000 & 513,9n3.000 & & Total lievenue & & 21.70x & 940x \\ \hline 4 & Cent of Rommue & 134.544 .900 & 403,507,000 & 446,343,000 & & Cost ef Revenue & & 20.514 & 10.925 \\ \hline 5 & Gresu Profit & 51,500,000 & 46,315,000 & 67,640,000 & & Gross Prodit & & 2377s & 200x \\ \hline 6 & Oberatine byense & 72.01000 & 41416,000 & 55.792,000 & & Operating Gopense & & 44.83s & \\ \hline y & Operating income & 27,490,000 & 24,270,000 & 12,241,000 & & Opdratine Income. & & 1.63N & 5077x \\ \hline a & & 1,092,000 & 1,161,000 & 1,374.000 & & Net Non Operating Interest inceme fopmie. & & 24.61x & 125x \\ \hline 9 & Other lincome fopense & 2371000 & 14,631,000 & 16.906,000 & & Other income Erpenie. & & 517172 & 214.45x \\ \hline 10 & Fritar hiceme & 24,176,000 & 38,151,000 & $2936.000 & & Preaxinceme & & 57.79x & 11556k \\ \hline 11 & Tar Provision & 3,217,000 & 4,791,000 & .3 .217 .000 & & Fan Provisien. & & 24a93x & .167.15x \\ \hline 12 & Lamines trom fquity intersat Net of far & 16,000 & 4,000 & 3,000 & & faning from fquaty infernt Net of Tar & & 75.00x & 175.00x \\ \hline 13 & Nit income & 21,331,000 & 3,364000 & +2,722,000 & & Net income & & 56.41x & +10016x \\ \hline \end{tabular} c. Ratios. The following Ratios MUST BE CALCULATED and PRESENTED for Amazon and Apple for the year 2022 and 2021. Current Ratio, Inventory Turnover, Gross Profit Percentage, AR Turnover, and Debt to equity Ratio (3 points each =15 points). d. Based on the ratios calculated Part C, please answer the following questions. ( 3 point each =15 points) i. Based on the Ratios for each company, which company had the higher Gross Profit Percentage in 2021 and 2022? ii. How many days does it take for Apple and Amazon to sell through their inventory in 2022 ? iii. Which company had the riskier debt-to-equity ratio in 2021 and 2022? (Please refer to Financial Statement Analysis Notes) iv. Which company has the "best" current ratio in 2021 and 2022? (Please refer to Financial Statement Analysis Notes) v. Which company is collecting their accounts receivable (net receivables) faster in 2022 ? \begin{tabular}{|c|c|c|c|} \hline Apple line. (AAPLJ Dats & Bue Year & & \\ \hline & 2020 & 2021 & \\ \hline Docal Renmue. & 274,515,009 & 355,817,000 & 324,328,000 \\ \hline Cont of themon & 165,559000 & 212981,000 & 23545000 \\ \hline Cros Froft: & 104056,000 & 152336000 & 170,72,000 \\ \hline Opertipg frpenst & 38,668,000 & 43,417,000 & 51,145,000 \\ \hline Coerutine lincome. & 66.238000 & 108949000 & 119,437,000 \\ \hline Net Non Cunating interint inceme Erpense & 890,000 & 198000 & .106 .000 \\ \hline Other thcome fapense & 803.000 & 238.000 & .334 .000 \\ \hline Preatincone & 67.091,000 & 109.207,000 & 119,101,000 \\ \hline Fan brovises: & 3,510,000 & 14,527,000 & 19.300,000 \\ \hline Net income & 57,411.000 & 54.580 .000 & 99,501,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Hertusntal Analvils } \\ \hline= & 2021 & 2027 \\ \hline Fotat Revmice. & 33263 & \\ \hline Cost or livenue & 25.6s & 4965 \\ \hline GreapreAt. & 45.67 & 11.76x \\ \hline Gperutinc Copmie & 13.50s & 15.998 \\ \hline Operatipt inconte & 64365 & 9.5315 \\ \hline & & 45334 \\ \hline Oater inceone Expenie & 07078 & 279.46x \\ \hline Dretar incoine & 62.77 & .906s \\ \hline Tormprovilen & 30075 & 32.165 \\ \hline Net income & 64.925 & 543 \\ \hline \end{tabular} Note: Apple's fucal vear endr in September 2 1. Which company had the higher increase in total revenue from 2021 to 2022? AMNON 2. Which company had the higher increase in net income from 2021 to 2022 ? APPUE 3. In 2022, for every dollar of revenue, Amazon bas a profit of 2. For every dollar of revenue, Apple has a profit of \begin{tabular}{|l|ll|} \hline hint sen Vertid mens for \\ \hline Amazon & S & (0.005) \\ \hline Apple & 5 & 0.253 \\ \hline \end{tabular} 4. Cost of Revenue (COCS) is what percentage of total revenue for the year 2022 for Amazon? And for Apple? hint See Vetral Aumbis for both sampanin \begin{tabular}{|l|r|} \hline Amaron & 86.84x \\ \hline Apple & 56.69% \\ \hline \end{tabular}
