Homework Help is Here – Start Your Trial Now!
Business
Accounting
Using the attached financial statements attached, ratios need to be calculated for all boxes that are greyed out.  Please provide details of how these ratios are calculated.

Using the attached financial statements attached, ratios need to be calculated for all boxes that are greyed out.  Please provide details of how these ratios are calculated.

Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 74E
See similar textbooks
icon
Related questions
Question
100%

Using the attached financial statements attached, ratios need to be calculated for all boxes that are greyed out.  Please provide details of how these ratios are calculated.  

Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Use the 2018 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal places. FY 2018 FY 2017 ASSETS Cash and cash equivalents 1,556 2,643 Inventory Other current assets 9,497 8,597 1,466 1,300 Total current assets 12,519 12,540 Property and equipment Land 6,064 6,095 Buildings and equipment Fixtures and equipment 29,240 28,131 5,912 5,623 Computer hardware and software 2,544 2,645 Construction-in-progress 460 440 Accumulated depreciation Property and equipment, net Operating Lease Assets (18,687) (18,398) 25,533 24 24,536 1,965 1,884 Other noncurrent assets 1,273 1,343 TOTAL ASSETS 41,290 100.00% $ 40,303 100.00% LIABILITIES Accounts payable Accrued and other current liabilities 9,761 8,677 4,201 4,094 Current portion of long-term debt and other borrowings Total current liabilities 1,052 281 15,014 13,052 Long-term debt and other borrowings Noncurrent operating lease Iliabilities 11,117 10,223 $4 2,004 1,924 Deferred income taxes 972 693 Other noncurrent liabilities 1,780 1,866 Total noncurrent liabilities 14,979 $4 15,600 Total liabilities $4 29,993 28,652 SHAREHOLDERS' INVESTMENT Common stock 43 45 Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' investment 6,042 5,858 6,495 (747) 11,651 6,017 (805) 11,297 2$ TOTAL LIABILITIES & SHAREHOLDERS' INVESTMENT 2$ 41,290 100.00% $ 40,303 100.00%
Transcribed Image Text:Vertical Analysis - Balance Sheets Target Corporation INSTRUCTIONS: Use the 2018 Annual report for both years' figures. Complete all greyed boxes. Ratios should be carried to 2 decimal places. FY 2018 FY 2017 ASSETS Cash and cash equivalents 1,556 2,643 Inventory Other current assets 9,497 8,597 1,466 1,300 Total current assets 12,519 12,540 Property and equipment Land 6,064 6,095 Buildings and equipment Fixtures and equipment 29,240 28,131 5,912 5,623 Computer hardware and software 2,544 2,645 Construction-in-progress 460 440 Accumulated depreciation Property and equipment, net Operating Lease Assets (18,687) (18,398) 25,533 24 24,536 1,965 1,884 Other noncurrent assets 1,273 1,343 TOTAL ASSETS 41,290 100.00% $ 40,303 100.00% LIABILITIES Accounts payable Accrued and other current liabilities 9,761 8,677 4,201 4,094 Current portion of long-term debt and other borrowings Total current liabilities 1,052 281 15,014 13,052 Long-term debt and other borrowings Noncurrent operating lease Iliabilities 11,117 10,223 $4 2,004 1,924 Deferred income taxes 972 693 Other noncurrent liabilities 1,780 1,866 Total noncurrent liabilities 14,979 $4 15,600 Total liabilities $4 29,993 28,652 SHAREHOLDERS' INVESTMENT Common stock 43 45 Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' investment 6,042 5,858 6,495 (747) 11,651 6,017 (805) 11,297 2$ TOTAL LIABILITIES & SHAREHOLDERS' INVESTMENT 2$ 41,290 100.00% $ 40,303 100.00%
Calculate the ratios for the following Financial statements. Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Use the 2018 Annual report for both years' information. Complete all greyed boxes. Ratios should be carried to 2 decimal places. FY 2018 % FY 2017 % Sales (add both revenue figures) Cost of sales Gross margin 75,356 100.00% 72,714 100.00% 53,299 51,125 $22,057 $21,589 15,140 Selling, general, and administr ative expenses Depreciation and amortization Operating Income Net interest expense 15,723 2,224 2,225 $ 4,110 $ 4,224 461 653 Net other (income)/ expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax earnings/(loss) (27) (59) $ 3,676 $ 3,630 746 722 $ 2,930 $ 2,908 $ 2,937 2,914
Transcribed Image Text:Calculate the ratios for the following Financial statements. Vertical Analysis - Income Statement Target Corporation INSTRUCTIONS: Use the 2018 Annual report for both years' information. Complete all greyed boxes. Ratios should be carried to 2 decimal places. FY 2018 % FY 2017 % Sales (add both revenue figures) Cost of sales Gross margin 75,356 100.00% 72,714 100.00% 53,299 51,125 $22,057 $21,589 15,140 Selling, general, and administr ative expenses Depreciation and amortization Operating Income Net interest expense 15,723 2,224 2,225 $ 4,110 $ 4,224 461 653 Net other (income)/ expense Earnings from continuing operations before income taxes Provision for income taxes Net earnings from continuing operations Discontinued operations, net of tax earnings/(loss) (27) (59) $ 3,676 $ 3,630 746 722 $ 2,930 $ 2,908 $ 2,937 2,914
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
SEE MORE TEXTBOOKS