Question

In: Accounting

Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...

Common-Size Balance Sheets

Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014.
(Round your answers to one decimal place.)


($ millions)
January 31,
2015
February 1,
2014
Assets
Cash and cash equivalents $2,210 $670
Inventory 8,790 8,278
Other current assets 3,087 2,625
Total current assets 14,087 11,573
Property and equipment, net 25,958 26,412
Other noncurrent assets 1,359 6,568
Total assets $41,404 $44,553
Liabilities and shareholders’ investment
Accounts payable $7,759 $7,335
Accrued and other current liabilities 3,886 4,299
Current portion of long-term debt and notes payable 91 1,143
Total current liabilities 11,736 12,777
Long-term debt 12,705 11,429
Deferred income taxes 1,321 1,349
Other noncurrent liabilities 1,645 2,767
Total shareholders’ investment 13,997 16,231
Total liabilities and shareholders’ investment $41,404 $44,553
TARGET CORPORATION
Common-Size Balance Sheets
2015 2014

Cash and cash equivalents Answer% Answer%
Inventory Answer% Answer%
Other current assets Answer% Answer%
Total current assets Answer% Answer%
Property and equipment, net Answer% Answer%
Other noncurrent assets Answer% Answer%
Total assets Answer% Answer%

Accounts payable Answer% Answer%
Accrued and other current liabilities Answer% Answer%
Current portion of long-term debt and notes payable Answer% Answer%
Total current liabilities Answer% Answer%
Long-term debt Answer% Answer%
Deferred income taxes Answer% Answer%
Other noncurrent liabilities Answer% Answer%
Total shareholders’ investment Answer% Answer%
Total liabilities and shareholders’ investment Answer% Answer%

Solutions

Expert Solution

Under common size balance sheet, amounts of each item in assets side of the balance sheet is shown as a percentage of total assets and total assets is assumed to be equal to 100%. Similarly, amounts of each item in liabilities and stockholders' equity side of the balance sheet is shown as a percentage of total liabilities and stockholders' equity which is assumed to be equal to 100%.

For example, cash and cash equivalent of 2015 is 5.3% (i.e. $2,210/$41,404) of total assets of 2015.  

TARGET CORPORATION
Common-Size Balance Sheets
2015 2014
Cash and cash equivalents 5.3% 1.5%
Inventory 21.2% 18.6%
Other current assets 7.5% 5.9%
Total current assets 34.0% 26.0%
Property and equipment, net 62.7% 59.3%
Other noncurrent assets 3.3% 14.7%
Total assets 100% 100%
Accounts payable 18.7% 16.5%
Accrued and other current liabilities 9.4% 9.6%
Current portion of long-term debt and notes payable 0.2% 2.6%
Total current liabilities 28.3% 28.7%
Long-term debt 30.7% 25.7%
Deferred income taxes 3.2% 3.0%
Other noncurrent liabilities 4.0% 6.2%
Total shareholders’ investment 33.8% 36.4%
Total liabilities and shareholders’ investment 100% 100%

Related Solutions

Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February...
Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February 3, 2018 and January 28, 2017. ($ millions) February 3, 2018 January 28, 2017 Assets Cash and cash equivalents $2,643 $2,512 Inventory 8,657 8,309 Other current assets 1,264 1,169 Total current assets 12,564 11,990 Property and equipment, net 25,018 24,658 Other noncurrent assets 1,417 783 Total assets $38,999 $37,431 Liabilities and shareholders’ investment Accounts payable $8,677 $7,252 Accrued and other current liabilities 4,254 3,737...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the base year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to 2 decimal places (e.g., 32.16) and common-base-year answers to 4 decimal places (e.g., 32.1616).) JARROW CORPORATION 2013 Common-size 2014 Common-size Common-base year Assets   Current assets     Cash $8,964 % $10,904 %     Accounts receivable 22,353 % 24,837 %     Inventory 38,722 % 43,697 %         Total $70,039 % $79,438...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each company. Review each company's percentage of total assets. Are these companies operating with similar philosophies or in similar industries? What appears to be the major difference in financing for these two companies? Account Balance Sheet Company 1 Balance. Sheet Company 2 Current Assets Cash $5,377 $299 Investments $4,146 $354 Accts. Rec. $8,100 $221 Inventory $5,372 $494 Total Current $22,995 $1,368 Long Inv. $84 $307...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for the recent three years 2011-2013 (including all subtotals and totals and round to 2 numbers after the decimal). Analyze three major components based on the common-size balance sheets and the trends of those components over the three years. Analyze two major components based on the common-size income statements and the trends of those components over the three years. Use 10.00% as a threshold.
To create a common size balance sheet ____________ all items on the balance sheet by ____________....
To create a common size balance sheet ____________ all items on the balance sheet by ____________. 1. multiply; owners equity 2. multiply; total assets 3. divide; owners equity 4. divide; total assets 5. multiply; debt
A common size balance sheet expresses the balance sheet items as a percentage of total assets....
A common size balance sheet expresses the balance sheet items as a percentage of total assets. Select one: True False
Which of the following statements is INCORRECT? Select one: a. A Common-size balance sheet is a...
Which of the following statements is INCORRECT? Select one: a. A Common-size balance sheet is a balance sheet with each line item expressed as % of total assets. b. Managers need to understand financial statement analysis to understand investment, financing, operating, and reporting decisions. c. The ratios that you calculate when conducting ratio analysis are defined by the FASB. d. Trend statements help you examine patterns of financial statement line items over time. How do you interpret “Days inventory held”?...
A common size balance sheet or common size income statement expresses everything in percentages rather than...
A common size balance sheet or common size income statement expresses everything in percentages rather than in numbers. Your manager has just asked you why you need to spend the time and money to have your analyst create both a common size and a regular balance sheet and income statement. How would you respond to her?
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 500 1.5 % Accounts receivable 6,000 18.2 Inventory 9,450 28.7 Total current assets $ 15,950 48.4 % Net property, plant, and equipment 16,980 51.6 Total assets $ 32,930 100.0 % Accounts payable $ 7,240 22.0 % Short-term notes 6,750 20.5 Total current liabilities $ 13,990 42.5 % Long-term liabilities 6,990 21.2 Total liabilities $ 20,980 63.7 % Total common shareholders’...
Chapter 2 material: Which accounts on Target’s balance sheet are accrual-type accounts? Which accounts on Target’s...
Chapter 2 material: Which accounts on Target’s balance sheet are accrual-type accounts? Which accounts on Target’s balance sheet are deferral-type accounts? Compare Target’s 2015 net earnings (the year ended January 30, 2016) to its 2015 cash provided by operating activities. Which is larger? First, compare Target’s 2014 net income to its 2015 net income. Next, compare Target’s 2014 cash provided by operating activities to its 2015 cash provided by operating activities. Which changed the most from 2014 to 2015, net...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT