1) Current Ratio = Current Assets / Current Liabilities.
Target = $18,424 / $11,327 = 1.63 : 1
Wal-mart = $48,331 / $55,561 = 0.87 : 1
2) Accounts Receivables Turnover = Net Sales / Account Receivables
Taregt = $65,357 / $7,525 = 8.68 OR 8.7 times
Wal-mart = $408,214 / $4,025 = 101.41 OR 101.4 times
3) Average Collection Period = 365 / Account sreceivables turnover ratio
Target = 365 / 8.7 = 41.95 OR 41.9 days
Wal-mart = 365 / 101.4 = 3.6 days
4) Inventory Turnover = Cost of goods sold / Average Inventory
Target = $45,583 / $6,942 = 6.56 OR 6.6 times
Wal-mart = $304,657 / $33,836 = 9.0 times OR 9 times
5) Days in Inventory = 365 / Inventory Turnover
Target = 365 / 6.6 = 55.3 days
Wal-mart = 365 / 9 = 40.55 OR 40.5 days (40.6 if rounded up)
6) Profit Margin =( Net Income / Net sales ) * 100
Target = ($2,488 / $65,357) * 100 = 3.8%
Wal-mart = ($14,335 / $408,214) * 100 = 3.5%
7) Asset Turonver = Net Sales / Average Total Assets
AverageTotal Assets = (Begining Assets + Ending Assets) / 2
Target : Average Total Assets = ($44,106 + $44,533) / 2 = $44,319.5
Asset Turnover = $65,357 / $44,319.5 = 1.47 OR 1.5 times
Wal-mart : Average Total Assets = ($163,429 + $170,706) / 2 = $167,067.5
Asset Turnover = $408,214 / $167,067.5 = 2.44 OR 2.4 Times
8) Return on Assets = Net Income / Average Assets
Target = ($2,488 / $44,319.5) * 100 = 5.6%
Wal-mart = ($14,335 / $167,067.5) * 100 = 8.58 OR 8.6%
9) Return on common stockholder's equity = Net Income / Average Shareholder's Equity
Average Shareholder's Equity = (Begining shareholder's equity + Ending shareholder's equity) / 2
Target; Average Shareholder's Equity = ($13,712 + $15,347) / 2 = $14,529.5
Return on common stockholder's equity = ($2,488 / $14,529.5) * 100 = 17.1%
Wal-mart : Average shareholder's equity = ($65,682 + $71,056) / 2 = $68,369
Return on common stockholder's equity = ($14,335 / $68,369) * 100 = 20.96 OR 21% (20.9 rounded down)
10) Debt to Assets Ratio = AverageTotal Debt /Average Total Assets
Average Total Debt = (Begining Total Liabilities + Ending Total Liabilities) / 2
Target : Average Total Debt = [$30,394 + ($11,327 + $17,859)] / 2 = $29,790
Debt to assets ratio = ($29,790 / $44,319.5) * 100 = 67%
Wal-mart ; Average Total Debt = [$97,747 + ($55,561 + $44,089)] / 2 = $98,698.5
Debt to assets ratio = ($98,698.5 / $167,067.5) * 100 = 59%
[NOTE: Average Total Assets is calcualted in asset turnover (number 7) and is taken from there only]
11) Times Interest Earned = Earnings Before Interest and Tax (EBIT) / Interest Expense
EBIT = Net Income + Interest + Tax
Target : EBIT = $2,488 + $707 + $1,384 = $4,579
Times Interest Earned = $4,579 / $707 = 6.47 OR 6.5 times
Wal-mart; EBIT = $14,335 + $2,065 + $7,139 = $23,539
Times Interest Earned = $23,539 / $2,065 = 11.4 times
12) Free Cash Flow = Net Cash Provided by Operating Activities - Capital Expenditure - Dividends
Target = $5,881 - $1,729 - $496 = $3,656 millions
Wal-mart = $26,249 - $12,184 - $4,217 = $9,848 millions
[NOTE: Change in Working Capital is not considered as begining current assets are not given]
{No intermediate calculations are rounded off , just the final answers are rounded off as instructions were given . Any confusion do not hesitate to comment I will help you out, Do like,Thank You:) }
3 Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions)....
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2.488 $ 14,335 Net income Current assets Noncurrent assets Total assets Current liabilities Balance Sheet Data (End of Year) $18.424 $48.331 26.109 122.375 $44,533...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7.139 $ 2,488 $ 14,335 Balance...
Problem 18-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in Millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7.139 $ 2,488 $ 14,335 Balance...
Problem 18-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2,488 $ 14,335 Net income Current assets Noncurrent assets Total assets Current liabilities Balance Sheet Data (End of Year) $18,424 $48,331...
only need 5-12
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2,488 $ 14,335 Net income Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $18,424 $48,331 26,109 122,375 $44,533...
Problem 18-05A b (Essay) Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7,139 $ 2,488 $ 14,335 Net income Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $18,424 $48,331 26,109...
Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $66,700 $409,000 46,000 306,000 14,700 76,000 650 1,800 (95) (420) 1,400 7,200 $3,855 $17,580 Net income Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $19,000 $48,000 25,600 120,000 $44,600 $168,000...
* Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Stores, Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Wal-Mart Target Corporation Inc. Income Statement Data for Year $66,300 $411,000 44,000 305,000 14,300 77,000 660 1,900 (80) (420) 1,500 7,200 $5,760 $19,480 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and...
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Wal-Mart Target Income Statement Data for Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $66,900 45,000 15,000 $419,000 309,000 80,000 1,900 (80) 1,500 (390) 6,700 4,620 21,010 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders" equity Total liabilities and stockholders $17,000...