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
-
Fuel prices have been very volatile during the last five years. What factors have contributed to this volatility? Why is it such a special challenge to supply chains? How can it be fixed?
-
Should the financial statements of Pension Trust Funds be included in the basic financial statements issued by a governmental unit? Explain.
-
The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest...
-
Refer to Cornerstone Exercise 9.1. Guillermos Oil and Lube Company provided the following information for the production of oil changes during the month of June: Actual number of oil changes...
-
Baron Corporation has a target capital structure of 6 5 percent common stock, 1 0 percent preferred stock, and 2 5 percent debt. Its cost of equity is 1 3 percent, the cost of preferred stock is 6...
-
You are assigned to the December 31, 2013, audit of Sea Gull Airframes, Inc. The company designs and manufactures aircraft superstructures and airframe components. You observed the physical inventory...
-
Scott Smith has decided to start his own business. He plans to find an attractive opportunity and start an e-commerce company. As a new entrepreneur fresh out of college, he needs to recognize a...
-
Identify the slope and y-intercept from an equation of a line and relate a graph to the equation Use the graph to find the slope and y-intercept of the given line. Compare the values to the equation...
-
How does an operating budget work to discipline a firm's management? What are the elements of a budget? How are budgets constructed? What is "Variance Analysis" and how is it used?
-
Given the fundamental value placed on leading with purpose, briefly describe five different leadership functions/situations (e.g., evaluating the school budget, student discipline, teacher...
-
On January 1st, the One Star Capital pension fund bought 1,000 US T-Bills that each had a $1,000 par value. One Star held them for exactly 150 days until they matured. If they paid $993.79 for each...
-
1.Explain why it is important to follow work health and safety procedures when working with ethernet optical transmission systems.
-
21 The random variable X has a normal distribution with mean 4.5. It is given that P(X>5.5) 0.0465 (see diagram). 4.5 5.5 0.0465 (i) Find the standard deviation of X. (ii) Find the probability that a...
-
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?
-
The individual recognized as the father of scientific management is: A. Fayol. B. Weber. C. Taylor. D. Ouchi.
-
Traditional management theory was designed to provide control and structure to which types of organizations? A. Hospitals. B. Scientific laboratories. C. Manufacturing industry. D. Institutions of...
-
In complexity science, the movement of an organization as it changes from one attractor or mission statement to another is known as: A. Leverage. B. Bifurcation. C. Chaos. D. Order.
Study smarter with the SolutionInn App