See attachments – need to complete excel spreadsheet (with formulas in the file) and answer the following questions from the word document. I attache

See attachments – need to complete excel spreadsheet (with formulas in the file) and answer the following questions from the word document.
I attached the two 10-k excel spreadsheets from both Walmart & Target to work from. 
I also attached excel samples showing the formulas if needed 

Case 1 – Ratio Analysis

A. Go to the end of chapter 1 in text, to “ongoing project”

· 1. Select two companies in the same or similar industries

· 2. Go to SEC Edgar and find their most recent 10K (or the company’s website under “Investor Relations”, SEC Filings and search “annual” filings

· 3. Download an Excel version of the 10K

· 4. Find the financial statements and address the following questions:

· a. What standards do the companies follow

· b. Date of the statements and who are the auditors

· c. Prepare “common sized” income and balance sheets

· d. What are the trends in each companies’ financial statements

· e. Compare the common sized financial statements – which company do you believe is performing better and why

B. Go to the end of chapter 4 in the text. For the financial statements downloaded in part A:

1. Compute the ROE for all three years presented for each company.

2. Compute the ROA and RNOA. Compute the profit margin and asset turnover ratio; as well as the net operating profit margin and net operating asset turnover ratio.

3. Review the results and compare the two companies.

a. Which company is performing better (and why)?

b. Which company is trending more favorably?

4. Review the balance sheet and calculate the quick ratio, current ratio, debt ratio and debt to equity ratio.

a. Discuss the trends in liquidity and solvency for the two companies

b. Which company is most liquid?

c. Which company is most solvent?

,

item 2 properties

Item 2. Properties
Stores as of January 30, 2021 Stores Retail Sq. Ft. (in thousands) Stores as of January 30, 2021 Stores Retail Sq. Ft. (in thousands)
Alabama 22 3,132 Montana 7 777
Alaska 3 504 Nebraska 14 2,005
Arizona 46 6,080 Nevada 18 2,262
Arkansas 9 1,165 New Hampshire 9 1,148
California 307 36,968 New Jersey 47 5,992
Colorado 42 6,244 New Mexico 10 1,185
Connecticut 21 2,731 New York 87 10,289
Delaware 3 440 North Carolina 51 6,540
District of Columbia 5 342 North Dakota 4 554
Florida 126 17,142 Ohio 64 7,829
Georgia 50 6,814 Oklahoma 15 2,167
Hawaii 7 1,111 Oregon 20 2,312
Idaho 6 664 Pennsylvania 75 9,094
Illinois 99 12,131 Rhode Island 4 517
Indiana 32 4,185 South Carolina 19 2,359
Iowa 21 2,859 South Dakota 5 580
Kansas 17 2,385 Tennessee 30 3,816
Kentucky 14 1,571 Texas 153 21,029
Louisiana 15 2,120 Utah 14 1,950
Maine 5 630 Vermont 1 60
Maryland 40 4,960 Virginia 60 7,754
Massachusetts 49 5,506 Washington 40 4,424
Michigan 53 6,286 West Virginia 6 755
Minnesota 73 10,315 Wisconsin 36 4,427
Mississippi 6 743 Wyoming 2 187
Missouri 35 4,608
Total 1,897 241,648

item 2 properties-1

Stores and Distribution Centers as of January 30, 2021 Stores Distribution Centers (a)
Owned 1,526 34
Leased 214 10
Owned buildings on leased land 157 —
Total 1,897 44

item 4a executive officers

Item 4A. Executive Officers
Name Title and Business Experience Age
Katie M. Boylan Executive Vice President and Chief Communications Officer since February 2021. Senior Vice President and Chief Communications Officer from January 2019 to February 2021. Senior Vice President, Communications from June 2017 to January 2019. Vice President, Communications from December 2015 to June 2017. 44
Brian C. Cornell Chairman of the Board and Chief Executive Officer since August 2014. 62
Michael J. Fiddelke Executive Vice President and Chief Financial Officer since November 2019. Senior Vice President, Operations from August 2018 to October 2019. Senior Vice President, Merchandising Capabilities from March 2017 to August 2018. Senior Vice President, Financial Planning & Analysis from July 2015 to March 2017. 44
Rick H. Gomez Executive Vice President and Chief Food and Beverage Officer since February 2021. Executive Vice President and Chief Marketing, Digital & Strategy Officer from December 2019 to February 2021. Executive Vice President and Chief Marketing & Digital Officer from January 2019 to December 2019. Executive Vice President and Chief Marketing Officer from January 2017 to January 2019. Senior Vice President, Brand and Category Marketing from April 2013 to January 2017. 51
A. Christina Hennington Executive Vice President and Chief Growth Officer since February 2021. Executive Vice President and Chief Merchandising Officer, Hardlines, Essentials and Capabilities from January 2020 to February 2021. Senior Vice President, Group Merchandise Manager, Essentials, Beauty, Hardlines and Services from January 2019 to January 2020. Senior Vice President, Merchandising Essentials, Beauty and Wellness from April 2017 to January 2019. Senior Vice President, Merchandising Transformation and Operations from August 2015 to April 2017. 46
Melissa K. Kremer Executive Vice President and Chief Human Resources Officer since January 2019. Senior Vice President, Talent and Organizational Effectiveness from October 2017 to January 2019. Vice President, Human Resources, Merchandising, Strategy & Innovation, from September 2015 to October 2017. 43
Don H. Liu Executive Vice President, Chief Legal & Risk Officer and Corporate Secretary since October 2017. Executive Vice President, Chief Legal Officer and Corporate Secretary from August 2016 to September 2017. Executive Vice President, General Counsel and Corporate Secretary of Xerox Corporation from July 2014 to August 2016. 59
Michael E. McNamara Executive Vice President and Chief Information Officer since January 2019. Executive Vice President and Chief Information & Digital Officer from September 2016 to January 2019. Executive Vice President and Chief Information Officer from June 2015 to September 2016. 56
John J. Mulligan Executive Vice President and Chief Operating Officer since September 2015. 55
Jill K. Sando Executive Vice President and Chief Merchandising Officer since February 2021. Executive Vice President and Chief Merchandising Officer, Style and Owned Brands from January 2020 to February 2021. Senior Vice President, Group Merchandise Manager, Apparel & Accessories and Home from January 2019 to January 2020. Senior Vice President, Home from May 2014 to January 2019. 52
Mark J. Schindele Executive Vice President and Chief Stores Officer since January 2020. Senior Vice President, Target Properties from January 2015 to January 2020. 52
Cara A. Sylvester Executive Vice President and Chief Marketing & Digital Officer since February 2021 . Senior Vice President, Home from March 2019 to February 2021. Vice President, Beauty & Dermstore from June 2017 to March 2019. From March 2014 to June 2017, Ms. Sylvester held different leadership positions in Housewares. 43
Laysha L. Ward Executive Vice President and Chief External Engagement Officer since January 2017. Executive Vice President and Chief Corporate Social Responsibility Officer from December 2014 to January 2017. 53

item 4a executive officers-1

Fiscal Years Ended
January 30, 2016 January 28, 2017 February 3, 2018 February 2, 2019 February 1, 2020 January 30, 2021
Target $ 100.00 $ 90.84 $ 108.44 $ 109.33 $ 175.54 $ 292.98
S&P 500 Index 100.00 120.87 148.47 148.38 180.37 211.48
Current Peer Group 100.00 111.09 159.84 166.68 201.97 280.21
Previous Peer Group 100.00 111.11 160.34 167.11 202.85 283.29

item 4a executive officers-2

Earnings Per Share From Continuing Operations Percent Change
2020 2019 2018 2020/2019 2019/2018
GAAP diluted earnings per share $ 8.64 $ 6.34 $ 5.50 36.3% 15.4%
Adjustments 0.78 0.05 (0.10)
Adjusted diluted earnings per share $ 9.42 $ 6.39 $ 5.39 47.4% 18.4%

analysis of results of ope

Analysis of Results of Operations
Summary of Operating Income Percent Change
(dollars in millions) 2020 2019 2018 2020/2019 2019/2018
Sales $ 92,400 $ 77,130 $ 74,433 19.8% 3.6%
Other revenue 1,161 982 923 18.20 6.30
Total revenue 93,561 78,112 75,356 19.80 3.70
Cost of sales 66,177 54,864 53,299 20.60 2.90
SG&A expenses 18,615 16,233 15,723 14.70 3.20
Depreciation and amortization (exclusive of depreciation included in cost of sales) 2,230 2,357 2,224 (5.40) 6.00
Operating income $ 6,539 $ 4,658 $ 4,110 40.4% 13.3%

analysis of results of ope-1

Rate Analysis 2020 2019 2018
Gross margin rate 28.4% 28.9% 28.4%
SG&A expense rate 19.90 20.80 20.90
Depreciation and amortization (exclusive of depreciation included in cost of sales) expense rate 2.40 3.00 3.00
Operating income margin rate 7.00 6.00 5.50

sales

Sales
Comparable Sales 2020 2019 2018
Comparable sales change 19.3% 3.4% 5.0%
Drivers of change in comparable sales
Number of transactions 3.70 2.70 5.00
Average transaction amount 15.00 0.70 0.10

sales-1

Contribution to Comparable Sales Change 2020 2019 2018
Stores originated channel comparable sales change 7.2% 1.4% 3.2%
Contribution from digitally originated sales to comparable sales 12.10 1.90 1.80
Total comparable sales change 19.3% 3.4% 5.0%

sales-2

Sales by Channel 2020 2019 2018
Stores originated 82.1% 91.2% 92.9%
Digitally originated 17.90 8.80 7.10
Total 100% 100% 100%

sales-3

Sales by Product Category 2020 2019 2018
Apparel and accessories 16% 19% 18%
Beauty and household essentials 26 27 26
Food and beverage 20 19 20
Hardlines 18 16 17
Home furnishings and décor 20 19 19
Total 100% 100% 100%

sales-4

RedCard Penetration 2020 2019 2018
Target Debit Card 12.3% 12.6% 13.0%
Target Credit Cards 9.20 10.70 10.90
Total RedCard Penetration 21.5% 23.3% 23.8%

store data

Store Data
Change in Number of Stores 2020 2019
Beginning store count 1,868 1,844
Opened 30 26
Closed (1) (2)
Ending store count 1,897 1,868

store data-1

Number of Stores and Retail Square Feet Number of Stores Retail Square Feet (a)
January 30, 2021 February 1, 2020 January 30, 2021 February 1, 2020
170,000 or more sq. ft. 273 272 48,798 48,619
50,000 to 169,999 sq. ft. 1,509 1,505 189,508 189,227
49,999 or less sq. ft. 115 91 3,342 2,670
Total 1,897 1,868 241,648 240,516

reconciliation of nongaap

Reconciliation of Non-GAAP Financial Measures to GAAP Measures
Reconciliation of Non-GAAP Adjusted EPS 2020 2019 2018
(millions, except per share data) Pretax Net of Tax Per Share Amounts Pretax Net of Tax Per Share Amounts Pretax Net of Tax Per Share Amounts
GAAP diluted earnings per share from continuing operations $ 8.64 $ 6.34 $ 5.50
Adjustments
Loss on debt extinguishment $ 512 $ 379 $ 0.75 $ 10 $ 8 $ 0.01 $— $— $—
Loss on investment (a) 19 14 0.03 41 31 0.06 — — —
Tax Act (b) — — — — — — — (36) (0.07)
Other (c) 28 20 0.04 (17) (13) (0.02) — — —
Other income tax matters (d) — (21) (0.04) — — — — (18) (0.03)
Adjusted diluted earnings per share from continuing operations $ 9.42 $ 6.39 $ 5.39

d

<td

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

(d)
EBIT and EBITDA Percent Change
(dollars in millions) 2020 2019 2018 2020/2019 2019/2018
Net earnings from continuing operations $ 4,368 $ 3,269 $ 2,930 33.6% 11.6%
+ Provision for income taxes 1,178 921 746 27.90 23.40
+ Net interest expense