ntroduction: For this Project we will be looking at Financial Data from Walmart and Target

from $2019-2021.$ We will use Financial Ratios from Chapter $12$ to look at performance over

these years. These years will cov Target Corp TGT

in wie value your raedtacks. Lot us icnow what you think. Wal$-$Mart Stores Inc WMT Target Corp TGTer the pre$-$Covid period, $2019,$ the $$Big Impact$$ year, $2020,$ and

the $$New Normal$$ year, $2021.$ We will also look at how each company responded to the

pandemic, as well as looking to see if the pandemic had an impact on the financial ratios. When

working in the Excel workbook, the pages are locked except for the yellow and green cells where

data or formulas need to be entered. Yellow cells will turn green when the correct answer is

entered.

Part $1$ will focus on reading the Financial Statements and Identifying the data and numbers we

need to complete part $2$ and $3.$

Step $1$: Download all the files in the folder.

Step $2$: Using the $2020$ report for Walmart, fill in the numbers for $2020$ and $2019$ in the Walmart

Numbers Tab.

Note $1$: Walmart$$s Fiscal year ends on January $31$st$.$ For this project, $2019$ will refer to the fiscal

year that ends January $31$st$,2020,$ and so on$.$

Note $2$: We will use Total Revenues, Interest, Net, Provisions for Income Tax, and Consolidated

Net Income for the select income statement accounts.

Note $3$: Gross profit is not listed, you will have to calculate it yourself.

Note $4$: On the Balance sheet, Total Liabilities are not listed, you will have to calculate them by

adding all the long$-$term liabilities to the current liabilities.

Note $5$: The shares outstanding are listed on page $57,(5$ on the file$)$ of the $10-$k report. Look for

the column for Common Stock Shares and the Bolded Balance Rows.

Step $3$: Using the $2020$ report for Target, fill in the numbers for $2020$ and $2019$ in the Target

Numbers Tab.

Note $1$: Just like Walmart, Target ends its fiscal year at the end of January or Beginning of

February. One the Income statement, they list $2020$ as the first years listed. This will match up

the balance sheet at Balance on January $30,2021.$ Sorry that this is a bit confusing.

Note $2$: We will use Total Revenues, Net Interest Expense, Provisions for Income Tax, and Net

Earnings for the select income statement accounts.

Note $3$: Gross profit is not listed, you will have to calculate it yourself.

Note $4$: Target does not do sales on account, so there are no accounts receivable.

Note $5$: One the Balance sheet, Total Liabilities are not listed, you will have to calculate them by

adding current liabilities with total noncurrent liabilities.

Note $5$: Share outstanding are listed at the bottom of the Balance sheet. Type them as presented,

excel will convert them into Millions for the calculations.

Step $4$: Repeat Step $2$ and $3$ for $2021$ reports.

Step $5$: Rename the Excel File as $$Financial Project$-$ Excel$-$ Last Name$$ and upload to the drop

box by the due date. Each Numbers tab is worth $15$ points.