Select a publicly traded company as well as one of their competitors within the same industry and gather the latest two years of their financial statements.Prepare a horizontal analysis, vertical analysis, common-sized statement, and the following ratios: current ratio, cash ratio, acid-test ratio, inventory turnover ratio, days sales in inventory ratio, days sales in receivables, and the gross profit percentage (if you feel that additional ratios will support your findings in relation to the overall financial state of the company feel free to include them in your analysis).

My team is doing walmart vs target

I NEED TO MAKE A COMMON SIZED INCOME STATEMENT AND BALANCE SHEET.

Target 2019 and 2019 Ratio Analysis 1. Current ratio 1292 1407 2. Cash ratio 0.1779 3. Acid-test ratio 4. Inventory turnover ratio 5. Days' sales in receivable Days' sales in receivable - 365 / Account receivable turnover ratio 365/81 -4.5day 2018 365/784.7days 6. Gross profit percentage formula Gross profit percentage formula Gross profit/ sales revenue 20897/78112 -26.73 2018 19833 / 73356 - 26.3% All values in USD Millions Walmart 2019 and 2019 Ratio Analysis 1. Current ratio Current Asset Current liability Current ratio 2019 61806 77790 2018 61897 77477 0.80 2. Cash ratio 2019 9465 2018 7756 Cash & cash equivalent Current liability 77790 77477 0.10 Current ratio 0.12 3. Acid-test ratio 2019 9465 2018 7756 Cash and cash equivalent Short-term investment 0 6283 Current receivable Total current Liability Acid-test ratio 6284 77790 77477 20.3% 18.13 Walmart Inc. Comparative Year-End Income Statement** Vertical Analysis 2018 2019 514,405 385,301 129,104 % of Total 100.0% 74.9% 25.1% 499,909 373,396 126,513 % of Total 100.0% 74.7% 25.3% 105,947 23,157 20.6% 4.5% 105,310 21,203 21.1% 4.2% Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Selling, General & Admin Expenses Operating Income Other Income & Expenses: Interest Expense Misc. Income & Expenses Total Other Income & Expenses Income Before Income Taxes Minority Interest Expense Income Tax Expense Net Income 2,395 9,302 11,6971 11,460 509 4,281 6,670 0.5% 1.8% 2.3% 2.2% 0.1% 0.8% 1.3% 2,331 3,749 6,080 15,123 661 4,600 9,862 0.5% 0.7% 1.2% 3.0% 0.1% 0.9% 2.0% *All values in USD Millions. **Fiscal year is February-January. Target Comparative Year-End Income Statement** Vertical Analysis 2019 75,356 55,523 19,833 % of Total 100.0% 73.7% 26.3% 2018 72,714 53,350 19,364 % of Total 100.0% 73.4% 26.6% 15,723 4,1101 20.9% 5.5% 15,140 4,224 20.8% 5.8% Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Selling, General, Admin Expenses Operating Income Other Income & Expenses: Interest Expense Misc. Income & Expenses Total Other Income & Expenses Income Before Income Taxes Income Tax Expense Net Income 459 -25 434 3,676 746 2,930 0.6% 0.0% 0.6% 4.9% 1.0% 3.9% 539 55 594 3,630 722 2,908 0.7% 0.1% 0.8% 5.0% 1.0%) 4.0%) *All values in USD Millions. **Fiscal year is February-January. Target 2019 and 2019 Ratio Analysis 1. Current ratio 1292 1407 2. Cash ratio 0.1779 3. Acid-test ratio 4. Inventory turnover ratio 5. Days' sales in receivable Days' sales in receivable - 365 / Account receivable turnover ratio 365/81 -4.5day 2018 365/784.7days 6. Gross profit percentage formula Gross profit percentage formula Gross profit/ sales revenue 20897/78112 -26.73 2018 19833 / 73356 - 26.3% All values in USD Millions Walmart 2019 and 2019 Ratio Analysis 1. Current ratio Current Asset Current liability Current ratio 2019 61806 77790 2018 61897 77477 0.80 2. Cash ratio 2019 9465 2018 7756 Cash & cash equivalent Current liability 77790 77477 0.10 Current ratio 0.12 3. Acid-test ratio 2019 9465 2018 7756 Cash and cash equivalent Short-term investment 0 6283 Current receivable Total current Liability Acid-test ratio 6284 77790 77477 20.3% 18.13 Walmart Inc. Comparative Year-End Income Statement** Vertical Analysis 2018 2019 514,405 385,301 129,104 % of Total 100.0% 74.9% 25.1% 499,909 373,396 126,513 % of Total 100.0% 74.7% 25.3% 105,947 23,157 20.6% 4.5% 105,310 21,203 21.1% 4.2% Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Selling, General & Admin Expenses Operating Income Other Income & Expenses: Interest Expense Misc. Income & Expenses Total Other Income & Expenses Income Before Income Taxes Minority Interest Expense Income Tax Expense Net Income 2,395 9,302 11,6971 11,460 509 4,281 6,670 0.5% 1.8% 2.3% 2.2% 0.1% 0.8% 1.3% 2,331 3,749 6,080 15,123 661 4,600 9,862 0.5% 0.7% 1.2% 3.0% 0.1% 0.9% 2.0% *All values in USD Millions. **Fiscal year is February-January. Target Comparative Year-End Income Statement** Vertical Analysis 2019 75,356 55,523 19,833 % of Total 100.0% 73.7% 26.3% 2018 72,714 53,350 19,364 % of Total 100.0% 73.4% 26.6% 15,723 4,1101 20.9% 5.5% 15,140 4,224 20.8% 5.8% Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Selling, General, Admin Expenses Operating Income Other Income & Expenses: Interest Expense Misc. Income & Expenses Total Other Income & Expenses Income Before Income Taxes Income Tax Expense Net Income 459 -25 434 3,676 746 2,930 0.6% 0.0% 0.6% 4.9% 1.0% 3.9% 539 55 594 3,630 722 2,908 0.7% 0.1% 0.8% 5.0% 1.0%) 4.0%) *All values in USD Millions. **Fiscal year is February-January