Important: The financial calculations should be completed for 2021 only. Annual reports provide several prior years information so investors and creditors can spot trends from year to year. You will not use 2018 or 2019 information for any of your calculations. You need 2020 for all ratios that require an average. For example: (end of year 2020 + end of year 2021) / 2 = average All ratios should include the numerators and denominators in columns F and I, and answers in columns G and J. Do NOT add zeros. Use the numbers provided. Show your work!
. Write the ratio components in column D. For Example, Profit Margin is Net Income / Net Sales Sales is another term for Revenue For Target, use Sales. For Walmart, use Net Sales 2. Calculate the Financial Ratios for Target and Walmart for Fiscal Year ending January 2021. Write numerators and denominators in columns F & I, and answers in columns G & J. SHOW ALL WORK! Round your answers to two decimal places. Follow the answer format in the chapter. For example; $, % or decimal 3. On the worksheet columns G & J, highlight which ratio is the best when comparing the two corporations. For most financial ratios, the higher result is better except when debt is in the numerator. Use the following data in addition to the financial statements: Target market price of $181.17 and Walmart market price of $140.49 Target weighted-average number of outstanding common shares is 500.6 in millions Walmart weighted-average number of outstanding common shares is 2831 in millions All financial numbers are in millions. Use the numbers provided. DO NOT add zeros. 4. Which stock would you purchase? Why? Write three complete paragraphs, addressing the strengths and weaknesses of each company and your reasons for purchasing Target or Walmart stock.
FNAMCAL STATEUENTS Consolidated Statements of Financial Position FINANCIAL STATEMENTS Consolidated Statements of Operations Walmart Inc. Conenlidated Ralames Showte Walmart Inc. Student's Full Name: Calculate ratios then highilight mith color which ratio ACG2071 Principle of Managerial Accounting is best. Which company has the best Pront Margin, etc? Ratios for year-end 2021 data: In this column. winte the components. Snow the pumerstor and denomlingor in colursua F B I Ratio Categories Proflibability. Net income in each sales dolar. Preflesility. Gross Margin in each sales dolar Profieability Overall preftabity of assets Proflability. Profitablity of owner invesment Profitabitity Net income per comm on share Anilyzing StockiMarket Prospects Market value relative to esininge Liquidity Abity to pay currert lebities elivency. Debt yerwus sguly franeing. Turnover afficiency Turnover afficlency. Emosecy of AR ootectiont Tumover atficiency. that are measured in the ratio. Itave. Target . Walmart EHicency of astets in producing saies 1. Write the ratio components in column D. For Example. Pront Margin is "Net Income / Net Sales" Sales is another term for Revenue For Tarpet, use Sales. For Walmart, use Net Sales 2. Calculate the Financial Ratios for Target and Walmart for Fiscal Year ending January 2021. Write numerators and denominators in columns F 8I, and answers in columns O&J. SHOW ALL. WORKI Round your answers to two decimai places. Follow the answer format in the chapter. For example: 5 , \% or decimal 3. On the worksheet columns G&d, highlight which ratio is the best' when comparing the two corporations. For most financial ratios, the higher result is better except when debt is in the numerator. Use the following data in addition to the financial statements: Target market prico of $181.17 and Walmart market price of $140.49 Target weighted-zverage number of outstanding common shares is 500.6 in militions. Walmart weighted-average number of outstanding common shares is 2831 in millions All financial numbers are in millions. Use the numbers provided, DO NOT add zeros. 4. Which stock would you purchase? Why? Write three complete paragraphs, addressing the strengths and weaknesses of each company and your reasons for purchasing Target or Walmart stock. Please rend instruction page for additional information. FNAMCAL STATEUENTS Consolidated Statements of Financial Position FINANCIAL STATEMENTS Consolidated Statements of Operations Walmart Inc. Conenlidated Ralames Showte Walmart Inc. Student's Full Name: Calculate ratios then highilight mith color which ratio ACG2071 Principle of Managerial Accounting is best. Which company has the best Pront Margin, etc? Ratios for year-end 2021 data: In this column. winte the components. Snow the pumerstor and denomlingor in colursua F B I Ratio Categories Proflibability. Net income in each sales dolar. Preflesility. Gross Margin in each sales dolar Profieability Overall preftabity of assets Proflability. Profitablity of owner invesment Profitabitity Net income per comm on share Anilyzing StockiMarket Prospects Market value relative to esininge Liquidity Abity to pay currert lebities elivency. Debt yerwus sguly franeing. Turnover afficiency Turnover afficlency. Emosecy of AR ootectiont Tumover atficiency. that are measured in the ratio. Itave. Target . Walmart EHicency of astets in producing saies 1. Write the ratio components in column D. For Example. Pront Margin is "Net Income / Net Sales" Sales is another term for Revenue For Tarpet, use Sales. For Walmart, use Net Sales 2. Calculate the Financial Ratios for Target and Walmart for Fiscal Year ending January 2021. Write numerators and denominators in columns F 8I, and answers in columns O&J. SHOW ALL. WORKI Round your answers to two decimai places. Follow the answer format in the chapter. For example: 5 , \% or decimal 3. On the worksheet columns G&d, highlight which ratio is the best' when comparing the two corporations. For most financial ratios, the higher result is better except when debt is in the numerator. Use the following data in addition to the financial statements: Target market prico of $181.17 and Walmart market price of $140.49 Target weighted-zverage number of outstanding common shares is 500.6 in militions. Walmart weighted-average number of outstanding common shares is 2831 in millions All financial numbers are in millions. Use the numbers provided, DO NOT add zeros. 4. Which stock would you purchase? Why? Write three complete paragraphs, addressing the strengths and weaknesses of each company and your reasons for purchasing Target or Walmart stock. Please rend instruction page for additional information
