1. Complete a vertical and horizontal analysis on the tabs labeled Balance Sheet and Income Statement, use...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for your vertical analysis.
2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios."
Transcribed Image Text:
Consolidated Balance Sheets (USD $) Feb. 01, 2015 Vertical Analysis Feb. 01, 2014 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at cost Less Accumulated Depreciation and Amortization 38,513 39,064 15,793 15,716 Net Property and Equipment 22,720 23,348 Goodwill 1,353 1,289 Other Assets 571 602 Total Assets 39,946 40,518 Current Liabilities: Short-Term Debt 290 Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable 5,807 5,797 1,391 1428 434 396 Deferred Revenue 1468 1,337 Income Taxes Payable Current Installments of Long-Term Debt 35 12 38 33 Other Accrued Expenses 1,806 11,269 1,746 Total Current Liabilities 10,749 Long-Term Debt, excluding current installments 16,869 14,691 Other Long-Term Liabilities 1,844 2,042 Deferred Income Taxes 642 514 Total Liabilitices 30,624 27,996 STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.768 billion shares at February 1, 2015 and 1.761 billion shares at February 2, 2014; outstanding: 1.307 billion shares at February 1, 2015 and 1.380 billion shares at February 2, 2014 88 88 Paid-In Capital Retained Earnings Accumulated Other Comprehensive (Loss) 8,885 8,402 26,995 23,180 -452 46 Income Treasury Stock, at cost, 461 million shares at February 1, 2015 and 381 million shares at February 2, 2014 -26,194 -19,194 9,322 Total Stockholderså€TM Equity Total Liabilities and Stockholders' Equity 12,522 $39,946 $40,518 Consolidated Balance Sheets (USD $) Feb. 01, 2015 Vertical Analysis Feb. 01, 2014 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at cost Less Accumulated Depreciation and Amortization 38,513 39,064 15,793 15,716 Net Property and Equipment 22,720 23,348 Goodwill 1,353 1,289 Other Assets 571 602 Total Assets 39,946 40,518 Current Liabilities: Short-Term Debt 290 Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable 5,807 5,797 1,391 1428 434 396 Deferred Revenue 1468 1,337 Income Taxes Payable Current Installments of Long-Term Debt 35 12 38 33 Other Accrued Expenses 1,806 11,269 1,746 Total Current Liabilities 10,749 Long-Term Debt, excluding current installments 16,869 14,691 Other Long-Term Liabilities 1,844 2,042 Deferred Income Taxes 642 514 Total Liabilitices 30,624 27,996 STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.768 billion shares at February 1, 2015 and 1.761 billion shares at February 2, 2014; outstanding: 1.307 billion shares at February 1, 2015 and 1.380 billion shares at February 2, 2014 88 88 Paid-In Capital Retained Earnings Accumulated Other Comprehensive (Loss) 8,885 8,402 26,995 23,180 -452 46 Income Treasury Stock, at cost, 461 million shares at February 1, 2015 and 381 million shares at February 2, 2014 -26,194 -19,194 9,322 Total Stockholderså€TM Equity Total Liabilities and Stockholders' Equity 12,522 $39,946 $40,518
Expert Answer:
Related Book For
Financial Accounting Tools for Business Decision Making
ISBN: 978-1118644942
6th Canadian edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine
Posted Date:
Students also viewed these general management questions
-
The partially complete 2012 balance sheet and income statement for Challenge Industries are given below, followed by selected ratio values for the firm based on its completed 2012 financial...
-
The 2012 comparative balance sheet and income statement of Rolling Hills, Inc., follow: Additionally, Rolling Hills purchased land of $23,600 by financing it 100% with long-term notes payable during...
-
The 2012 comparative balance sheet and income statement of Appleton Group, Inc., follow. Appleton had no noncash investing and financing transactions during 2012. Requirement 1. Prepare the...
-
What is Norway's global health issues and how can they be combated? explain
-
Consider the repricing model. a. What are some of its weaknesses? b. How have large banks solved the problem of choosing the optimal time period for repricing?
-
The DEF Ltd started to construct a factory on 1 April 2020; it incurred $40 million and $100 million on 1 April 2020 and 1 October 2020 respectively on the construction. construction would be...
-
One of the first U.S. major industries to be regulated was the railroads. Farmers and manufacturers depended on railroads to get their products to market, and often there was only one railroad...
-
Using the same data found in Exercise 6.22, assume the company uses the FIFO method. Required: Prepare a schedule of equivalent units, and compute the unit cost for the month of December. In Exercise...
-
Lessons Revenue Expenses: Instructor wages TipTop Flight School Flexible Budget Performance Report For the Month Ended July 31 Actual Results 180 $ 41,290 10,645 Aircraft depreciation 6,840 Fuel...
-
Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to...
-
Match the Characteristics of Life to the Proper Description. Match the characteristics of life to the proper description. 1. 2. 3. 4. Description Change in position of the body or of a body part;...
-
What methods can be used when conducting annual compliance checks in the workplace to ensure that documents and practices are meeting the company's obligations.
-
In international business is legal compliance with the laws of each separate nation its best strategy to keep out of trouble?
-
How can leaders ensure compliance with relevant laws and ethical standards while promoting fairness and impartiality in conflict resolution processes ?
-
1 Explain five ecosystem services on which you rely. 2. Explain the idea of moral extensionism, and give an example. 3. What is the "green revolution," and why was it important? 4. State and explain...
-
what is the scope of compliance requirements that may relate to an employer's role in the mental health sector?
-
1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: A 1 Chapter 3: Applying Excel 2 34 Data Sales B $ 80,000 5 in Variable costs: 69 869 Cost of...
-
Differentiate. y = ln(3x + 1) ln(5x + 1)
-
Akshay Limited uses the average cost method in a perpetual inventory system. Fill in the missing amounts for items [1] to [13] in the following perpetual inventory schedule. (Use unrounded numbers in...
-
Under the direct method, why is depreciation expense not reported in the operating activities section?
-
Why and how is depreciation and amortization expense reported in the operating activities section of a statement of cash flows prepared using the indirect method?
-
State two basic differences between the net present value and the internal rate of return models that often lead to differences in the evaluation of competing investment proposals.
-
Using the equations and tables in Appendix 124A of this chapter, determine the answers to each of the following independent situations: a. The future value in two years of \($7,500\) invested today...
-
Kailey James Company is evaluating a capital expenditure proposal that requires an initial investment of \($14,900\), has predicted cash inflows of \($4,000\) per year for 12 years, and has no...
Study smarter with the SolutionInn App