Prepare a common-size

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Prepare a common-size balance for the current and past year, for both companies. Use cell referencing to calculate the common size percentages and round to two decimal places. Columns have been set up for you to enter your work. 

and answer questions at the bottom.

Common-Size Balance Sheets
Target Corporation
Assets
Cash and cash equivalents
Inventory
Other current assets
Total current assets
Property and equipment
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 paid-in capital
Retained earnings
Accumulated other comprehensive loss
Total shareholders' investment
Total liabilities and shareholders' investment
Dollar amounts in Millions
Percentages
Jan. 28, 2023 Jan. 29, 2022 Jan. 28, 2023 Jan. 29, 2022
$ 2,229
13,499
2,118
17,846
6,231
34,746
7,439
3,039
2,688
(22,631)
31,512
2,657
1,320
53,335
13,487
5,883
130
19,500
16,009
2,638
2,196
1,760
22,603
38
6,608
5,005
(419)
11,232
$ 53,335
$ 5,911
13,902
1,760
21,573
6,164
32,985
6,407
2,505
1,257
(21,137)
28,181
2,556
1,501
53,811
15,478
6,098
171
21,747
13,549
2,493
1,566
1,629
19,237
39
6,421
6,920
(553)
12,827
$ 53,811
references to e
credit.
#1 Answer the following questions below for the most recent year. Make sure you are referencing specific account and not a total line for A and B.
a. What are the company's 2 largest assets?
b. What are the company's 2 largest liabilities?
c. What percentage of total assets is financed by owners?
d. What percentage of total assets is financed by creditors?
Transcribed Image Text:Common-Size Balance Sheets Target Corporation Assets Cash and cash equivalents Inventory Other current assets Total current assets Property and equipment 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 paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' investment Total liabilities and shareholders' investment Dollar amounts in Millions Percentages Jan. 28, 2023 Jan. 29, 2022 Jan. 28, 2023 Jan. 29, 2022 $ 2,229 13,499 2,118 17,846 6,231 34,746 7,439 3,039 2,688 (22,631) 31,512 2,657 1,320 53,335 13,487 5,883 130 19,500 16,009 2,638 2,196 1,760 22,603 38 6,608 5,005 (419) 11,232 $ 53,335 $ 5,911 13,902 1,760 21,573 6,164 32,985 6,407 2,505 1,257 (21,137) 28,181 2,556 1,501 53,811 15,478 6,098 171 21,747 13,549 2,493 1,566 1,629 19,237 39 6,421 6,920 (553) 12,827 $ 53,811 references to e credit. #1 Answer the following questions below for the most recent year. Make sure you are referencing specific account and not a total line for A and B. a. What are the company's 2 largest assets? b. What are the company's 2 largest liabilities? c. What percentage of total assets is financed by owners? d. What percentage of total assets is financed by creditors?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Analytical Techniques
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education