Calculate the Acid test ratio, the account receivable turnover, the average collection period, the inventory turnover, the average sales, and the operation cycle of the company CAPITAL ONE for 2019.

you can find the financial statement of the company CAPITAL ONE in the following link: https://www.macrotrends.net/stocks/charts/COF/capital-one-financial/financial-statements

I f there is data missing to find the question, search it on google, it is straight forward

B D E H L 1 2 2 3 Net interst income 4 Interest income bank 5 Total interest expense 6 Loan loss provision 7 Net interst income after loan loss provision 8 Non interest income bank 9 Non interest expense bank . 10 Net income before tax 4 11 Provision for income taxes 12 Net income after tax 13 Minority interest 14 Equity in affiliates 15 US GAAP Adjustment 16 Net income before extra ordinary item 17 Total extra ordinary item 18 Net income 10 tot 19 Total adjustment to Net income 20 Income available to common including extra ordinary item 21 Dilution adjustment 22 Dilution Net income 23 24 FAT32 433 33* ******** 31/12/2019 31/12/2018 31/12/2017 23340 22875 22460 28513 27176 25222 5173 4301 2762 6236 5856 7551 7040 12000 17104 17019 14909 care 5253 221 5201 4777 100 - 15483 -14902 -14194 2240 23 6874 7318 5492 1244 2003 4620 1341 1293 1574 5005 5533 6025 3918 0 0 0 0 0 0 0 0 0 5533 6025 3918 4 13 -10 -1936 5546 6015 1982 -354 -305 -278 5179 5720 3640 0.4 0 0 5192 5710 1704 F G Horizontal analysis 31/12/2019 31/12/2018 2.03% 1.85% 4.92% 7.75% 20.27% 55.72% 6.49% -22.45% 0.50% 14.15% 1.00% 8.88% 3.90% 4.99% -6.07% 33.25% 3.71% -17.85% -8.17% 53.78% Vertical analysis 31/12/2019 31/12/2018 31/12/2017 81.86% 84.17% 89.05% 100.00% 100.00% 100.00% 18.14% 15.83% 10.95% 21.87% 21.55% 29.94% ON 59.99% 62.63% 59.11% 40 18.42% 19.14% 18.94% -54.30% -54.84% -56.28% 24.11% 26.93% 21.77% *** 4.70% 4.76% 6.24% 19.41% 22.17% 15.53% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 19.41% 22.17% 15.53% 0.05% -0.04% -7.68% 1940 7 19.45% 22.13% 7.86% -1.24% -1.12% -1.10% 18.16% 21.05% 14.43% 0.00% 0.00% 0.00% 18.21% 21.01% 6.76% -8.17% -230.00% -7.80% 16.07% -9.46% 53.78% -99.48% 203.48% 9.71% 57.14% -9.07% 235.09% B D E H L 1 2 2 3 Net interst income 4 Interest income bank 5 Total interest expense 6 Loan loss provision 7 Net interst income after loan loss provision 8 Non interest income bank 9 Non interest expense bank . 10 Net income before tax 4 11 Provision for income taxes 12 Net income after tax 13 Minority interest 14 Equity in affiliates 15 US GAAP Adjustment 16 Net income before extra ordinary item 17 Total extra ordinary item 18 Net income 10 tot 19 Total adjustment to Net income 20 Income available to common including extra ordinary item 21 Dilution adjustment 22 Dilution Net income 23 24 FAT32 433 33* ******** 31/12/2019 31/12/2018 31/12/2017 23340 22875 22460 28513 27176 25222 5173 4301 2762 6236 5856 7551 7040 12000 17104 17019 14909 care 5253 221 5201 4777 100 - 15483 -14902 -14194 2240 23 6874 7318 5492 1244 2003 4620 1341 1293 1574 5005 5533 6025 3918 0 0 0 0 0 0 0 0 0 5533 6025 3918 4 13 -10 -1936 5546 6015 1982 -354 -305 -278 5179 5720 3640 0.4 0 0 5192 5710 1704 F G Horizontal analysis 31/12/2019 31/12/2018 2.03% 1.85% 4.92% 7.75% 20.27% 55.72% 6.49% -22.45% 0.50% 14.15% 1.00% 8.88% 3.90% 4.99% -6.07% 33.25% 3.71% -17.85% -8.17% 53.78% Vertical analysis 31/12/2019 31/12/2018 31/12/2017 81.86% 84.17% 89.05% 100.00% 100.00% 100.00% 18.14% 15.83% 10.95% 21.87% 21.55% 29.94% ON 59.99% 62.63% 59.11% 40 18.42% 19.14% 18.94% -54.30% -54.84% -56.28% 24.11% 26.93% 21.77% *** 4.70% 4.76% 6.24% 19.41% 22.17% 15.53% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 19.41% 22.17% 15.53% 0.05% -0.04% -7.68% 1940 7 19.45% 22.13% 7.86% -1.24% -1.12% -1.10% 18.16% 21.05% 14.43% 0.00% 0.00% 0.00% 18.21% 21.01% 6.76% -8.17% -230.00% -7.80% 16.07% -9.46% 53.78% -99.48% 203.48% 9.71% 57.14% -9.07% 235.09%