Prepare a common-size
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff326825c-a2b9-41da-a23f-48108dea7e37%2F83a1eb2f-f7c0-4e35-a0f1-26b20f8c2f33%2Fatfvwx_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education