Question: Using the four excel sheets I have to comment how I found the ratio analysis for liquidity, efficiency, solvency,profitability, and market prospects. What is the

Using the four excel sheets I have to comment how I found the ratio analysis for liquidity, efficiency, solvency,profitability, and market prospects.

What is the three strong aspects of the corporation using the photos provided... These aspects are not necessarily financial in nature; they could refer to the companys competition, product, etc.

Do you believe the corporation will be able to maintain these strengths over the next few years? Why or why not?

In what way might these weaknesses be overcome?

Would you invest in the capital stock of this corporation if you had sufficient funds? To answer this question, assume you made an investment in this company in January 2004. Would your investment have increased or decreased in value? Give specific data, including your ratio analysis.

Using the four excel sheets I have to comment how
Using the four excel sheets I have to comment how
Using the four excel sheets I have to comment how
Using the four excel sheets I have to comment how
Consolidated Statements of Operations - USD ($) shares in Million, 5 in Millions Feb. 03, 2018 72,714 31.125 15,140 2.225 Total revenue Cost of sales Selling general and adminative expenses Depreciation and motiin (exclusive or depreciation included in cost of all) Operating income Netinerest expense Net other income) /expense Farnings from continuing operation before income des Provision for income taxes Net cumnings from continuing operations Discontinued openson, net of tax Net Gamis 12 Months Ended Feb. 02. 2019 75.356 53,299 15,723 2.224 4.110 461 -27 3,676 746 2.930 2019 Common Size 100.00% 70.73% 20.86% 2.95% 5.45% 0.61 0.04% 4.8% 0.9994 3.89% 001% 3.9094 4.224 633 -59 3,630 722 2.90 6 2,914 2018 Common Size 100.00% 70.31% 20.8296 3.06% 5.81% 0.90% 0.08 4.9994 0.999 4.00% 0.01% 40196 Jan 25, 2017 70,271 49.145 14.217 2,043 4,854 991 -88 3,961 1.295 2,666 68 2,734 2,937 S354 0.0 3.35 S 3.12 0.01 532 54,61 0.12 Hasle earning per share Continuing operations in dollars per share) Discontinued pensions (in dollars per share Net earnings per share in dollars per share) Diluted earnings per share Continuine operations in dollar per she Discontinued operations (in dollars per share) Net carnis priare in dollars phare) Weighted average mon shares outstanding Basic in shares) Diluta shares) Antidutive theres (sh) Sales Total revenue Other 35 0.0 S55 3.29 0.01 35.29 SN 0.12 54.69 32.0 5332 0 5468 5503 5776 582.5 0.1 574,433 S 7,780 5 69,414 5923 SUN SNS 10 21 Income Statement - Compon Site $ 15% C4) Sat is Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) Q Search Statements of Operations. USD (5) shares in Million, 5 in Millions Increase (Decrease) 2,642 2.174 583 12 Months Ended Feb. 02, 2019 Feb. 03, 2018 75,356 72,714 53,299 51.125 15,723 15,140 2,224 2.225 4,110 4.224 461 27 -59 3,676 3,630 746 722 2.930 2,908 7 6 2,937 2,914 114 -192 32 46 24 22 1 23 % Change 3.63% 4.25% 3.85% -0.04% -2.70% -29 40% 54.24% 1.27% 3.32% 0.7696 16.6794 0.79% Total revenue Cos of sales Selling general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of Operating income Net interest expiche Net other (income) pense Kaming from continuing operations before income taxes Provision for income taxes Net caring from continuing operations Discontinued operations, et of tax Net coming Basle earnings per share Continuing operations in dollars per share) Discontinued operations in dollars per share) Netcomings per share in dollars per bre) Diluted earnings per share Continuing operations (in dollars per share) Discontinued operations in dollars per share) Net carnings per stare in dollars per share) Weighted average common shares outstanding Banen sats) Dned in stare Awidutive shares in shares) Sales Totalte Jan 28, 2017 5 70,271 49,145 14,217 2,045 4.864 991 -88 3,961 1,295 2,666 68 S 2,734 5.54 0 3.55 532 0 532 0.22 0 0.23 4.14% 0.00 $ 4.61 0.12 4.73 3.50 5.29 0 021 4.58 3.9796 0.00% 4.16% 5.51 3.29 0.22 0.12 S4.69 329 333 -18 547 550 4 -3.33% 3.11% -100.00% -4 577.6 3825 0.1 Other Total rever 74,433 71.780 2,649 569414 928 -0.54% S 857 * 15%C2 Tools Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) Sear 02 28 Consolidated Statements of Finandal Position - USD (5) Sin Millions Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment ng Land Buildings and improvements Fixtures and equipment Computer hardware and software Construction-in-progress Accumulated depreciation Property and equipment, net Operating lease assets Other noncurrent assets Total assets Liabilities and shareholders' Investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Total current liabilities Long-term debt and other borrowings Noncurrent operating lease liabilities Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders Investment Common stock Additional pald-in capital Retained carnings Accumulated other comprchensive loss Total shareholders investment Total liabilities and shareholders' investment 2019 Feb. 02, 2019 2018 Feb. 03, 2018 Common Size Common Size 1,556 3.7796 2,643 6.56% 9,497 23.00% 8,597 21.33% 1,466 3.55% 1,300 3.2396 12,519 30.32% 12,340 31.11% 0.00% 0.00% 6,064 14.699 6,095 15.1296 29,240 70.82% 28,131 69.80% 3,912 14.32% 5,623 13.95% 2,544 6.16% 2,645 6.56% 460 1.11% 440 1.09% (18,687) -45.26% (18,398) 45.65% 25,533 61.84% 24,536 60.8896 1.965 4.76% 1,884 4.67% 1.273 3.08% 1,343 3.33% 41,290 100.00% 40,303 100.00% 0.00% 0.00% 9,761 23.64% 8,677 21.53% 4,20) 10.17% 4,094 10.16% 1,052 2.55% 281 0.70% 15,014 36.36% 13,052 32.38% 10,223 24.76% 11.117 27.58% 2,004 4.85% 1.924 4.77% 972 2.35% 693 1.72% 1.780 4.31% 1.866 4.63% 14,979 36.28% 15,600 38.71% 0.00% 0.00% 43 0.10% 45 0.11% 6,042 14.63% 5,858 14.53% 6,012 14.57% 6,495 16.12% (805) -1.95% (747) -1.85% 11,297 27.36% 11,651 28.91% 41,290 100.00% 40,303 100.00% 10 Refer to Note 2 regarding the adoption of new accounting standards for revenue recogni Income Statement - Common Site Income ne Statement - Horizontal Balance Sheet - Common Size Balance Sheet - Horizontal Tools Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) e % Change Feb, 02, 2019 Increase (Decrease) Feb 03, 2018 2.643 2397 1.556 9,497 1,466 12.319 41.13% 10.4796 12.77 -0.17% 12,340 -0.31% 3.94% 5.14% (1,087) 900 166 (21) 0 (31) 1,109 289 (LOD) 20 (289) 997 81 (70) 987 6,064 29,240 5,912 2,544 460 (18.687) 25,533 1.95 1273 41.290 Coded arments of Financial site - USD Mis AN Cash and equivalent Inventory Other current Total cuma Property and equipment Land Building improvements Fixtures and equipment Computer hardware and so Construction propres Accumuladdepreciation Property and equipment, et Operating Other current assets Toilet Lisbites and shareholders' investment coupable and current is Current portion of term dettandotier bouwing Total current Lang tum debe and other bonowings Net operating a little Defined indexes Dhe noncurrent lines Total Boncurrent liabilities Shareholder investment Common stock Additional paid in Retained rings Accumulated the comprensivo Toalharchaden investment Total inbilities and shareholders en 4,095 23,131 3.823 2.645 440 (18.398) 24,536 1.884 1.343 40,303 4.5594 1.57% 4,06% 430% -5.21% 2.45% 1,084 1 9,761 4.201 1,052 15,014 10.223 2,004 972 1,70 14,979 5,677 4,094 281 13.052 1.117 1.924 693 1.866 15.600 771 1,962 (894) 80 279 186) 12.49% 2,61% 274.38% 15.039 -8.0094 4.16% 40.26% 4,61% (2) 184 43 6.042 6,017 (NOS) 11.297 41.290 (478) 5.SN 6,495 (147) 11.651 40303 (58) (354) 987 4,44% 3.14% -73694 7.76N -3.04% 2.45% Refer to Note 2 regarding the adoption of new accounting standards for revenu Income St-Comt Inco Santa Balance - Commen Sie Balance Sheet - Horizontal LORE Consolidated Statements of Operations - USD ($) shares in Million, 5 in Millions Feb. 03, 2018 72,714 31.125 15,140 2.225 Total revenue Cost of sales Selling general and adminative expenses Depreciation and motiin (exclusive or depreciation included in cost of all) Operating income Netinerest expense Net other income) /expense Farnings from continuing operation before income des Provision for income taxes Net cumnings from continuing operations Discontinued openson, net of tax Net Gamis 12 Months Ended Feb. 02. 2019 75.356 53,299 15,723 2.224 4.110 461 -27 3,676 746 2.930 2019 Common Size 100.00% 70.73% 20.86% 2.95% 5.45% 0.61 0.04% 4.8% 0.9994 3.89% 001% 3.9094 4.224 633 -59 3,630 722 2.90 6 2,914 2018 Common Size 100.00% 70.31% 20.8296 3.06% 5.81% 0.90% 0.08 4.9994 0.999 4.00% 0.01% 40196 Jan 25, 2017 70,271 49.145 14.217 2,043 4,854 991 -88 3,961 1.295 2,666 68 2,734 2,937 S354 0.0 3.35 S 3.12 0.01 532 54,61 0.12 Hasle earning per share Continuing operations in dollars per share) Discontinued pensions (in dollars per share Net earnings per share in dollars per share) Diluted earnings per share Continuine operations in dollar per she Discontinued operations (in dollars per share) Net carnis priare in dollars phare) Weighted average mon shares outstanding Basic in shares) Diluta shares) Antidutive theres (sh) Sales Total revenue Other 35 0.0 S55 3.29 0.01 35.29 SN 0.12 54.69 32.0 5332 0 5468 5503 5776 582.5 0.1 574,433 S 7,780 5 69,414 5923 SUN SNS 10 21 Income Statement - Compon Site $ 15% C4) Sat is Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) Q Search Statements of Operations. USD (5) shares in Million, 5 in Millions Increase (Decrease) 2,642 2.174 583 12 Months Ended Feb. 02, 2019 Feb. 03, 2018 75,356 72,714 53,299 51.125 15,723 15,140 2,224 2.225 4,110 4.224 461 27 -59 3,676 3,630 746 722 2.930 2,908 7 6 2,937 2,914 114 -192 32 46 24 22 1 23 % Change 3.63% 4.25% 3.85% -0.04% -2.70% -29 40% 54.24% 1.27% 3.32% 0.7696 16.6794 0.79% Total revenue Cos of sales Selling general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of Operating income Net interest expiche Net other (income) pense Kaming from continuing operations before income taxes Provision for income taxes Net caring from continuing operations Discontinued operations, et of tax Net coming Basle earnings per share Continuing operations in dollars per share) Discontinued operations in dollars per share) Netcomings per share in dollars per bre) Diluted earnings per share Continuing operations (in dollars per share) Discontinued operations in dollars per share) Net carnings per stare in dollars per share) Weighted average common shares outstanding Banen sats) Dned in stare Awidutive shares in shares) Sales Totalte Jan 28, 2017 5 70,271 49,145 14,217 2,045 4.864 991 -88 3,961 1,295 2,666 68 S 2,734 5.54 0 3.55 532 0 532 0.22 0 0.23 4.14% 0.00 $ 4.61 0.12 4.73 3.50 5.29 0 021 4.58 3.9796 0.00% 4.16% 5.51 3.29 0.22 0.12 S4.69 329 333 -18 547 550 4 -3.33% 3.11% -100.00% -4 577.6 3825 0.1 Other Total rever 74,433 71.780 2,649 569414 928 -0.54% S 857 * 15%C2 Tools Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) Sear 02 28 Consolidated Statements of Finandal Position - USD (5) Sin Millions Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment ng Land Buildings and improvements Fixtures and equipment Computer hardware and software Construction-in-progress Accumulated depreciation Property and equipment, net Operating lease assets Other noncurrent assets Total assets Liabilities and shareholders' Investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Total current liabilities Long-term debt and other borrowings Noncurrent operating lease liabilities Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders Investment Common stock Additional pald-in capital Retained carnings Accumulated other comprchensive loss Total shareholders investment Total liabilities and shareholders' investment 2019 Feb. 02, 2019 2018 Feb. 03, 2018 Common Size Common Size 1,556 3.7796 2,643 6.56% 9,497 23.00% 8,597 21.33% 1,466 3.55% 1,300 3.2396 12,519 30.32% 12,340 31.11% 0.00% 0.00% 6,064 14.699 6,095 15.1296 29,240 70.82% 28,131 69.80% 3,912 14.32% 5,623 13.95% 2,544 6.16% 2,645 6.56% 460 1.11% 440 1.09% (18,687) -45.26% (18,398) 45.65% 25,533 61.84% 24,536 60.8896 1.965 4.76% 1,884 4.67% 1.273 3.08% 1,343 3.33% 41,290 100.00% 40,303 100.00% 0.00% 0.00% 9,761 23.64% 8,677 21.53% 4,20) 10.17% 4,094 10.16% 1,052 2.55% 281 0.70% 15,014 36.36% 13,052 32.38% 10,223 24.76% 11.117 27.58% 2,004 4.85% 1.924 4.77% 972 2.35% 693 1.72% 1.780 4.31% 1.866 4.63% 14,979 36.28% 15,600 38.71% 0.00% 0.00% 43 0.10% 45 0.11% 6,042 14.63% 5,858 14.53% 6,012 14.57% 6,495 16.12% (805) -1.95% (747) -1.85% 11,297 27.36% 11,651 28.91% 41,290 100.00% 40,303 100.00% 10 Refer to Note 2 regarding the adoption of new accounting standards for revenue recogni Income Statement - Common Site Income ne Statement - Horizontal Balance Sheet - Common Size Balance Sheet - Horizontal Tools Window Help chegg.com Target Common Size & Horizontal Analysis-2.xlsx (1 page) e % Change Feb, 02, 2019 Increase (Decrease) Feb 03, 2018 2.643 2397 1.556 9,497 1,466 12.319 41.13% 10.4796 12.77 -0.17% 12,340 -0.31% 3.94% 5.14% (1,087) 900 166 (21) 0 (31) 1,109 289 (LOD) 20 (289) 997 81 (70) 987 6,064 29,240 5,912 2,544 460 (18.687) 25,533 1.95 1273 41.290 Coded arments of Financial site - USD Mis AN Cash and equivalent Inventory Other current Total cuma Property and equipment Land Building improvements Fixtures and equipment Computer hardware and so Construction propres Accumuladdepreciation Property and equipment, et Operating Other current assets Toilet Lisbites and shareholders' investment coupable and current is Current portion of term dettandotier bouwing Total current Lang tum debe and other bonowings Net operating a little Defined indexes Dhe noncurrent lines Total Boncurrent liabilities Shareholder investment Common stock Additional paid in Retained rings Accumulated the comprensivo Toalharchaden investment Total inbilities and shareholders en 4,095 23,131 3.823 2.645 440 (18.398) 24,536 1.884 1.343 40,303 4.5594 1.57% 4,06% 430% -5.21% 2.45% 1,084 1 9,761 4.201 1,052 15,014 10.223 2,004 972 1,70 14,979 5,677 4,094 281 13.052 1.117 1.924 693 1.866 15.600 771 1,962 (894) 80 279 186) 12.49% 2,61% 274.38% 15.039 -8.0094 4.16% 40.26% 4,61% (2) 184 43 6.042 6,017 (NOS) 11.297 41.290 (478) 5.SN 6,495 (147) 11.651 40303 (58) (354) 987 4,44% 3.14% -73694 7.76N -3.04% 2.45% Refer to Note 2 regarding the adoption of new accounting standards for revenu Income St-Comt Inco Santa Balance - Commen Sie Balance Sheet - Horizontal LORE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!