The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 4 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Suppose selected financial data of Target and Wal-Mart for 2014 are presented here (in millions).
| Â | Â |
Target |
 |
Wal-Mart |
||
| Â | Â |
Income Statement Data for Year |
||||
| Net sales | Â |
$65,732 |
 |  |
$416,322 |
 |
| Cost of goods sold | Â |
44,929 |
 |  |
304,545 |
 |
| Selling and administrative expenses | Â |
14,209 |
 |  |
76,803 |
 |
| Interest expense | Â |
730 |
 |  |
1,934 |
 |
| Other income (expense) | Â |
(84 |
) |
 |
(409 |
) |
| Income tax expense | Â |
1,377 |
 |  |
6,782 |
 |
| Net income | Â |
$ 4,403 |
 |  |
$ 25,849 |
 |
| Â | Â | Â | Â | Â | Â | Â |
| Â | Â |
Balance Sheet Data |
||||
| Current assets | Â |
$18,132 |
 |  |
$48,246 |
 |
| Noncurrent assets | Â |
27,356 |
 |  |
120,791 |
 |
| Total assets | Â |
$45,488 |
 |  |
$169,037 |
 |
| Current liabilities | Â |
$11,375 |
 |  |
$55,646 |
 |
| Long-term debt | Â |
16,899 |
 |  |
43,293 |
 |
| Total stockholdersAc€?c equity |  |
17,214 |
 |  |
70,098 |
 |
| Total liabilities and stockholdersAc€?c equity |  |
$45,488 |
 |  |
$169,037 |
 |
| Â | Â | Â | Â | Â | Â | Â |
| Â | Â |
Beginning-of-Year Balances |
||||
| Total assets | Â |
$44,915 |
 |  |
$164,068 |
 |
| Total stockholdersAc€?c equity |  |
12,696 |
 |  |
65,730 |
 |
| Current liabilities | Â |
10,251 |
 |  |
57,922 |
 |
| Total liabilities | Â |
32,219 |
 |  |
98,338 |
 |
| Â | Â | Â | Â | Â | Â | Â |
| Â | Â |
Other Data |
||||
| Average net accounts receivable | Â |
$7,401 |
 |  |
$3,994 |
 |
| Average inventory | Â |
7,168 |
 |  |
33,681 |
 |
| Net cash provided by operating activities | Â |
5,791 |
 |  |
27,161 |
 |
| Capital expenditures | Â |
1,766 |
 |  |
12,169 |
 |
| Dividends | Â |
460 |
 |  |
3,931 |
 |
(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.)
| Â | Â | Â | Â |
Target |
 |
Wal-Mart |
||
| (1) | Â | Current ratio. | Â |
|
:1 | Â |
|
:1 |
| (2) | Â | Accounts receivable turnover. | Â |
|
times | Â |
|
times |
| (3) | Â | Average collection period. | Â |
|
days | Â |
|
days |
| (4) | Â | Inventory turnover. | Â |
|
times | Â |
|
times |
| (5) | Â | Days in inventory. | Â |
|
days | Â |
|
days |
| (6) | Â | Profit margin. | Â |
|
% | Â |
|
% |
| (7) | Â | Asset turnover. | Â |
|
times | Â |
|
times |
| (8) | Â | Return on assets. | Â |
|
% | Â |
|
% |
| (9) |  | Return on common stockholdersAc€?c equity. |  |
|
% | Â |
|
% |
| (10) | Â | Debt to assets ratio. | Â |
|
% | Â |
|
% |
| (11) | Â | Times interest earned. | Â |
|
times | Â |
|
times |
| (12) | Â | Current cash debt coverage. | Â |
|
times | Â |
|
times |
| (13) | Â | Cash debt coverage. | Â |
|
times | Â |
|
times |
| (14) | Â | Free cash flow. | Â |
$ |
 |  |
$ |
|
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll