Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $64,900 $405,000 Cost of goods sold 44,000 300,000 Selling and administrative expenses 14,000 75,000 Interest expense 650 1,800 Other income (expense) (70 ) (380 ) Income tax expense 1,300 6,500 Net income $ 4,880 $ 21,320 Balance Sheet Data (End of Year) Current assets $16,000 $45,000 Noncurrent assets 25,000 120,000 Total assets $41,000 $165,000 Current liabilities $10,000 $54,000 Long-term debt 16,800 43,000 Total stockholders’ equity 14,200 68,000 Total liabilities and stockholders’ equity $41,000 $165,000 Beginning-of-Year Balances Total assets $43,000 $162,000 Total stockholders’ equity 12,500 64,000 Current liabilities 10,000 54,000 Total liabilities 30,500 98,000 Other Data Average net accounts receivable $7,400 $3,800 Average inventory 6,800 32,800 Net cash provided by operating activities 5,500 25,500 Capital expenditures 1,600 11,500 Dividends 450 3,500 (a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)Ratio TargetWal-Mart(1) Current ratio Enter a number:1 Enter a number:1(2) Accounts receivable turnover Enter a numbertimes Enter a numbertimes(3) Average collection period Enter a numberdays Enter a numberdays(4) Inventory turnover Enter a numbertimes Enter a numbertimes(5) Days in inventory Enter a numberdays Enter a numberdays(6) Profit margin Enter percentages% Enter percentages%(7) Asset turnover Enter a numbertimes Enter a numbertimes(8) Return on assets Enter percentages% Enter percentages%(9) Return on common stockholders’ equity Enter percentages% Enter percentages%(10) Debt to assets ratio Enter percentages% Enter percentages%(11) Times interest earned Enter a numbertimes Enter a numbertimes(12) Free cash flow

Answers

Answer 1
Answer:

Answer:

                     Target Wal-Mart

CURRENT RATIO  1,60   0,83  

PROFIT MARGIN 7,52% 5,26%

ASSETS TURNOVER TIMES  1,55   2,48  

TIMES INTEREST EARNED RATIO  10,51   16,46  

LONG TERM DEBT RATIO 40,98% 26,06%

TOTAL DEBT/ASSETS RATIO 44,40% 26,61%

RETURN ON ASSETS 11,62% 13,04%

RETURN ON EQUITY 36,55% 32,30%

DAYS IN INVENTORY  56,41   39,91  

INVENTORY TURNOVER  6,47   9,15  

AVERAGE COLLECTION  41,62   3,42  

ACC REC. TURNOVER  8,77   106,58  

FREE CASH FLOW  3,900   14,000  

Explanation:


Related Questions

A small office building produces NOI of $8,995 per year. We intend to buy the property, if the price is right, and hold it for four years. At that time (EOY 4) we believe we can sell the property for $197,000. If we require an 8% ROA, what is the most we should pay now for this investment?A. The NPV is negative, so reject the investment.B. The NPV is positive, so invest.C. The NPV is greater than the NOI, so invest.D. The GPI is greater than the NOI, so invest.E. The NPV is greater than the OPX, so invest.
Suppose that the national economy is experiencing a recession with an estimated recessionary gap of $10 billion. Congress is considering the use of fiscal policy to ease the recession, and due to current political sentiments, it has determined that the maximum spending increase the government is willing to support is $3 billion. The government wants to make up the remainder of the recessionary gap using tax cuts. If a spending increase of $3 billion is approved and the MPC is 0.6, by how much will taxes need to be reduced to close the remainder of the recessionary gap
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes):Income Statement Balance Sheet Sales $38,000 Assets $27,300 Debt $6,700Costs 32,600 Equity 20,600Net income $5,400 Total $27,300 Total $27,300The company has predicted a sales increase of 20 percent. Assume the company pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not.a. Prepare the pro forma statements.b. Determine the external financing needed.
The Work-in-Process inventory account of a manufacturing firm shows a balance of $3,980 at the end of an accounting period. The job cost sheets of two uncompleted jobs show charges of $660 and $460 for materials, and charges of $560 and $740 for direct labor. From this information, it appears that the company is using a predetermined overhead rate, as a percentage of direct labor costs, of:
Primara Corporation has a standard cost system in which it applies overhead to products based on the standard direct labor-hours allowed for the actual output of the period. Data concerning the most recent year appear below: Total budgeted fixed overhead cost for the year $ 250,000 Actual fixed overhead cost for the year $ 254,000 Budgeted direct labor-hours (denominator level of activity) 25,000 Actual direct labor-hours 27,000 Standard direct labor-hours allowed for the actual output 26,000 Required: 1. Compute the fixed portion of the predetermined overhead rate for the year. (Round Fixed portion of the predetermined overhead rate to 2 decimal places.) 2. Compute the fixed overhead budget variance and volume variance. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.). Input all amounts as positive values.)

If the tax on gasoline is increased to provide incentives to curb air pollution, then the tax serves as

Answers

Answer:

A user fee.

Explanation:

These are general fees that are known to be paid by some countries indigenous occupants which tends to commence its reading from the first of January till the 31st of December. They particularly known to be renewable in most cases. User fees confer with a financing mechanism that has two main characteristics: payment is created at the purpose of service use and there's no risk sharing. User fees can entail any combination of drug costs, supply and medical material costs, entrance fees or consultation fees. they're typically obtained each visit to a health service provider, although in some cases follow-up visits for the identical episode of illness is covered by the initial payment.

On March 31, 2017, Alpha Corporation recorded the following factory overhead costs incurred: Factory Manager Salary $7,000 Factory Utilities 2,000 Machinery Deprecation 11,000 Machinery Repairs 2,500 Factory Insurance (prepaid) 1,000 The overhead application rate is based on direct labor hours. The preset formula for overhead application estimated that $21,000 would be incurred, and 10,000 direct labor hours would be worked. During March, 7,100 hours were actually worked on Job Order A-2 and 3,000 hours were actually worked on Job Order A-3. Use this information to prepare the March 31 General Journal entry to record the factory overhead costs. (round any final dollar answers to the nearest whole dollar):

Answers

Answer:

Explanation:

check the file attached for full explanation

If the world relative price lies somewhere between the autarky relative price of Home and the autarky relative price of Foreign, then: _____________ a. Only the country whose government subsidizes its exports will gain.
b. Home but not Foreign will gain from trade.
c. Neither Home nor Foreign will gain from trade.
d. Home and Foreign will both gain from trade.

Answers

When the world relative price lies somewhere between the autarky relative price, D. Home and Foreign will gain from trade.

What is a relative price?

It should be noted that a relative price simply compares the price of a commodity in terms of another.

In this case, when the world relative price lies somewhere between the autarky relative price, both home and foreign will gain from trade.

Learn more about relative price on:

brainly.com/question/24888747

Final answer:

When the world relative price is within the range of the autarky relative prices of Home and Foreign countries, it implies better rates for international trade as compared to the domestic trade for both countries. Thus, both Home and Foreign will benefit from trade.

Explanation:

If the world relative price lies somewhere between the autarky relative price of Home and the autarky relative price of Foreign, then both Home and Foreign will gain from trade. This implies that the global trade price falls within the local prices at which both countries would independently trade goods. Consequently, both countries will benefit because they can now trade at better terms.

Here's how it works: At autarky (a state where a country does not engage in international trade), each country would trade goods domestically at a certain price ratio (the relative price). If the global trade price falls within these domestic relative prices, then both countries can trade internationally at better rates compared to their autarky situation, leading to mutual beneficial trade.

Therefore, the answer to your question is (d) Home and Foreign will both gain from trade.

Learn more about International Trade here:

brainly.com/question/22370644

#SPJ12

Colter Steel has $5,600,000 in assets. Temporary current assets $ 3,200,000 Permanent current assets 1,610,000 Fixed assets 790,000 Total assets $ 5,600,000 Short-term rates are 10 percent. Long-term rates are 15 percent. Earnings before interest and taxes are $1,180,000. The tax rate is 20 percent. If long-term financing is perfectly matched (synchronized) with long-term asset needs, and the same is true of short-term financing, what will earnings after taxes be

Answers

Answer:

The Earnings after taxes will be $400,000

Explanation:

According to the data we have the following Long term financing funds of Permanent current assets = $1,610,000  and Fixed assets = $790,000  so the total of Long term financing funds= $ 2,400,000

Also, we have Termperory current assets = $3,200,000

Therefore, the Long term interest expenses = $2,400,000 * 15%

                                                                          = $360,000

       

                 and the Short term interest expenses = $3,200,000* 10%

                                                                                  = $ 320,000

Hence, Total interest expenses=$360,000+$ 320,000=$680,000

So, Earnings before taxes=Earnings before interest and taxes-Interest expenses=$ 1,180,000- $ 680,000=$500,000

The tax rate is 20 percent, hence, taxes=$500,000*20%=$100,000

Therefore, The Earnings after taxes would be=Earnings before taxes-taxes

                                                                           =$500,000-$100,000

                                                                            =$400,000

On June 1, 2014, Siebens Enterprises loaned $27,000 to Tyler Company for one year at 8 percent interest. Under the terms of the promissory note, Tyler will repay the principal and pay one year's interest on May 31, 2015. Related to this note receivable, what amount of interest income would Siebens report on its 2014 income statement? (Round your final answer to the nearest whole dollar amount.)

Answers

Answer:

$1,260

Explanation:

The computation of amount of interest income is shown below:-

Principal                                    $27,000

Rate of interest                          8%

Interest for 7 month in 2014     $1,260

($27,000 × 8% × 7 ÷ 12)

Interest for 5 months in 2015   $900

( $27,000 × 8% × 5 ÷ 12)

12 months from 1 June 2014  

to 31 may 2015                            12 months

Interest                                         $2,160

($27,000 × 8%)

T will repay the principal and one year interest  

on may 31, 2015

($20,000 + $2,160)                        $22,160

So, Interest income to be reported on its 2014 income statement is $1,260

Trade Mart has recently had lackluster sales. The rate of inventory turnover has? dropped, and the merchandise is gathering dust. At the same time, competition has forced AquariumAquarium's suppliers to lower the prices that Aquarium will pay when it replaces its inventory. It is now December 31, 2016, and the current replacement cost Aquarium's ending inventory is $75,000 below what Aquarium actually paid for the goods, which was $200,000.Before any adjustments at the end of the? period, the Cost of Goods Sold account has a balance of $$820,000.
Requirements:
a. What accounting action should Aquarium take in this situation?
b. Give any journal entry required.
c. At what amount should Aquarium report Inventory on the balance? sheet?
d. At what amount should the company report Cost of Goods Sold on the income? statement?
e. Discuss the accounting principle or concept that is most relevant to this situation.

Answers

Answer:

a. What accounting action should Aquarium take in this situation?

the balance of inventory account should decrease to match the replacement cost.

b. Give any journal entry required.

Dr Cost of goods sold 75,000

    Cr Inventory 75,000

c. At what amount should Aquarium report Inventory on the balance? sheet?

Inventory = $200,000 - $75,000 = $125,000

d. At what amount should the company report Cost of Goods Sold on the income statement?

Cost of goods sold = $820,000 + $75,000 = $895,000

e. Discuss the accounting principle or concept that is most relevant to this situation.

US GAAP states that companies must use the lower of cost or market rule, which means that inventory must be recognized at the lowest cost either original purchase cost or market value.

Other Questions