Question

In: Accounting

Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...

Analysis and Interpretation of Profitability
Balance sheets and income statements for Target Corporation follow.

Income Statement
For Fiscal Years Ended ($ millions) 2006 2005 2004
Sales $ 51,271 $ 45,682 $ 40,928
Credit card revenues 1,349 1,157 1,097
Total revenues 52,620 46,839 42,025
Cost of sales 34,927 31,445 28,389
Selling, general and administrative expenses 11,185 9,797 8,657
Credit card expenses 776 737 722
Depreciation and amortization 1,409 1,259 1,098
Earnings before interest and income taxes 4,323 3,601 3,159
Net interest expense 463 570 556
Earnings before income taxes 3,860 3,031 2,603
Provisions for income taxes 1,452 1,146 984
Net earnings $ 2,408 $ 1,885 $ 1,619
Balance Sheet
($ millions, except footnotes) January 28, 2006 January 29, 2005
Assets
Cash and cash equivalents $ 1,648 $ 2,245
Credit card receivables 5,666 5,069
Inventory 5,838 5,384
Other current assets 1,253 1,224
Total current assets 14,405 13,922
Property and equipment
Land 4,449 3,804
Buildings and improvements 14,174 12,518
Fixtures and equipment 3,219 2,990
Computer hardware and software 2,214 1,998
Construction-in-progress 1,158 962
Accumulated depreciation (6,176) (5,412)
Property and equipment, net 19,038 16,860
Other noncurrent assets 1,552 1,511
Total assets $ 34,995 $ 32,293
Liabilities and shareholders' investment
Accounts payable $ 6,268 $ 5,779
Accrued and other current liabilities 2,567 1,937
Current portion of long-term debt and notes payable 753 504
Total current liabilities 9,588 8,220
Long-term debt 9,119 9,034
Deferred income taxes 851 973
Other noncurrent liabilities 1,232 1,037
Shareholders' investment
Common stock 73 74
Additional paid-in-capital 2,121 1,810
Retained earnings 12,013 11,148
Accumulated other comprehensive income (loss) (2) (3)
Total shareholders' investment 14,205 13,029
Total liabilities and shareholders' equity $ 34,995 $ 32,293


a. Compute ROE for 2006.

Do not round until your final answer. Round answers to two decimal places.

ROE =Answer%

b. Confirm that ROE equals ROE computed using the component measures for profit margin, asset turnover, and financial leverage using: ROE = PM * AT * FL.

   Compute the components of ROE.

   Do not round until your final answer. Round answers to two decimal places.

   PM = Answer%
    AT = Answer
    FL = Answer

c. Compute adjusted ROA. Assume a tax rate of: 38.3%.

Do not round until your final answer. Round your answer to two decimal places.
Adjusted ROA =Answer%

Solutions

Expert Solution

1. Net operating profit after tax is post tax operating profit of the Company before considering interest expense. In the given case operating income after excluding credit card income is 4,323-(1,349-776)=3,750. Tax rate is 38.3%. NOPAT=3,750*(1-0.383)=2,313.75. Credit card income is treated as non-oeprating income.

2. Net Operating asset of 2006=Total assets-Cash-Credit Card Receivale-Total Liabilities

=34,995-1,648-5,666-(6,268+2,567+753+9119+1232)=7,742.

Similarly, compute for 2005.

3. Return on net operating asset (2006) is 2,313.75/7742=29.88%

NOPM%=Operating Profit/Net Sales=3,750/51,271=7.31%

NOAT%=Operating Profit After Tax/ Net Sales=2,313.75/51,271=4.512%

4. Net non operating obligations=deferred income taxes=851.

5. Return of equity=Net Earnings/Shareholders Funds (excluding preferred stock)=2,408/14,205=16.95%

6. ROE>RNOA implies that borrowing yields greater return than cost of debt.


Related Solutions

Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2008 2007 2006 Sales $ 61,471 $ 57,878 $ 51,271 Credit card revenues 1,896 1,612 1,349 Total revenues 63,367 59,490 52,620 Cost of sales 41,895 39,399 34,927 Selling, general and administrative expenses 13,704 12,819 11,185 Credit card expenses 837 707 776 Depreciation and amortization 1,659 1,496 1,409 Earnings before interest and income taxes 5,272 5,069 4,323 Net interest...
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow....
Question text Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2008 2007 2006 Sales $ 61,471 $ 57,878 $ 51,271 Credit card revenues 1,896 1,612 1,349 Total revenues 63,367 59,490 52,620 Cost of sales 41,895 39,399 34,927 Selling, general and administrative expenses 13,704 12,819 11,185 Credit card expenses 837 707 776 Depreciation and amortization 1,659 1,496 1,409 Earnings before interest and income taxes 5,272 5,069 4,323...
Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corporation follow. Costco...
Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) September 2, 2018 Total revenue $141,576 Operating expenses Merchandise costs 123,152 Selling, general and administrative 13,876 Preopening expenses 68 Operating Income 4,480 Other income (expense) Interest expense 159 Interest income and other, net (121) Income before income taxes 4,442 Provision for income taxes 1,263 Net income including noncontrolling interests 3,179 Net income...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2010 2009 2008 Net sales $26,662 $23,123 $25,269 Operating expenses Cost of sales 13,831 12,109 13,379 Selling, general and administrative expenses 5,479 4,907 5,245 Research, development and related expenses 1,434 1,293 1,404 Loss/(gain) from sale of business -- -- 23 Total operating expenses 20,744 18,309 20,051 Operating income 5,918 4,814 5,218 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2012 2011 2010 Net sales $29,904 $ 29,611 $ 226,662 Operating expenses Cost of sales 15,685 15,693 13,831 Selling, general and administrative expenses 6,102 6,170 5,479 Research, development and related expenses 1,634 1,570 1,434 -- -- -- Total operating expenses 23,421 23,433 20,744 Operating income 6,483 6,178 5,918 Interest expenses and income Interest expense 171 186...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2012 2011 2010 Net sales $29,904 $ 29,611 $ 226,662 Operating expenses Cost of sales 15,685 15,693 13,831 Selling, general and administrative expenses 6,102 6,170 5,479 Research, development and related expenses 1,634 1,570 1,434 -- -- -- Total operating expenses 23,421 23,433 20,744 Operating income 6,483 6,178 5,918 Interest expenses and income Interest expense 171 186...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2008 2007 2006 Net sales $25,269 $24,462 $22,923 Operating expenses Cost of sales 13,379 12,735 11,713 Selling, general and administrative expenses 5,245 5,015 5,066 Research, development and related expenses 1,404 1,368 1,522 Loss/(gain) from sale of business 23 (849) (1,074) Total operating expenses 20,051 18,269 17,227 Operating income 5,218 6,193 5,969 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2009 2008 2007 Net sales $23,123 $25,269 $24,462 Operating expenses Cost of sales 12,109 13,379 12,735 Selling, general and administrative expenses 4,907 5,245 5,015 Research, development and related expenses 1,293 1,404 1,368 Loss/(gain) from sale of business -- 23 (849) Total operating expenses 18,309 20,051 18,269 Operating income 4,814 5,218 6,193 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2009 2008 2007 Net sales $23,123 $25,269 $24,462 Operating expenses Cost of sales 12,109 13,379 12,735 Selling, general and administrative expenses 4,907 5,245 5,015 Research, development and related expenses 1,293 1,404 1,368 Loss/(gain) from sale of business -- 23 (849) Total operating expenses 18,309 20,051 18,269 Operating income 4,814 5,218 6,193 Interest expenses and income Interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements...
Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. Consolidated Statements of Income Years ended December 31 ($ millions) 2008 2007 2006 Net sales $25,269 $24,462 $22,923 Operating expenses Cost of sales 13,379 12,735 11,713 Selling, general and administrative expenses 5,245 5,015 5,066 Research, development and related expenses 1,404 1,368 1,522 Loss/(gain) from sale of business 23 (849) (1,074) Total operating expenses 20,051 18,269 17,227 Operating income 5,218 6,193 5,969 Interest expenses and income Interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT