Calculation of change in sales for target

Assignment Help Managerial Accounting
Reference no: EM13775467

Using the Consolidated Statement of Income (may also be called Statement of Earnings or Statement of Operations) of a publicly traded company of your choosing, answer the following questions. o What are the Sales (also called Net Sales, Net Revenue, or Operating Revenue) for the most recent three years? This is normally the largest number. o What are the Net Incomes (also called Net Earnings) for the most recent three years? o How well do you think this company is operating? Explain your answer. The audited Income Statement will have only three years of data. Post the name of your selected company and the link to the statement with your answer.

The chosen company is Target Corporation which is one of the largest retailer and chain stores in the world. It's one of those giant retailer having predominant presence in North America. It has currently more than 2000 stores.It is listed in the NYSE.

Reasons for selecting this company.

Target Corporation is recently in news for its decision to raise the minimum wage rate to $9 per hour and thus match the efforts made by other retail behemoths like Walmart and TJX. However very recently Targets Canada operations were not performing as per market expectations and there are reports in the market that the firm would close all the 133 stores in Canada in 2015-16.

The financial highlights for the firm for the last three years as follows:

In $ millions

 

Net Sales

Net Profit

2014

72,618

2449

2013

71,279

2694

2012

71,960

3315

Net Profit Ratio calculates the net profit in % terms earned by the firm after deducting all the expenses and operating expenses. Different industries have different benchmark for  this ratio. A higher Net margin indicates lower operating expense and higher efficiency and productivity.(J R MONGA).

The net margin % of the Target Inc. is calculated as follows:

 

Net profit Margin

2014

2449/72,618 = 3.37%

2013

2694/71,279 = 3.77%

2012

3315/71960 = 4.60%

The Net margin of Target was pretty decent in 2012 at 4.6% when compared to an industry wide ratio of 4.5-5% in this industry. But since then the margin has nosedived instead of improving. Both 2013 and 2014 has seen absolute and % decrease in profit numbers. Profit percentage has reduced to 3.77% in 2013 and 3.37% in 2014. This indicates towards increase in operating expenses for the firm and some of the stores not doing well. Particularly the firm has done very badly in its Canadian operations. That's the primary reason the firm has decided to shut down its Canadian operations and close all the 130 odd stores in the next 2 years.

Calculation of change in sales for Target

 

Net Sales

Change in sales

2014

72,618

1.88%

2013

71,279

- .9463%

2012

71,960

 

If I look at the above figures I see a pattern. Although this pattern is small - the sales has almost gone down in 2013 by 1% approx. and then increased or recovered by 1.88% in 2014. When the 2014 value is compared to that of 2012, the sales has only increased very marginally and at the same time there is a larger gap in the profit margin. This indicates that between 2012 and 2014, the sales of the firm has grown (albeit a small margin of $658mn) but the profits for the firm has gone down by an amount of $866mn. This is an indication that there is a supply chain issue at the operative level and costs have risen.

Reference no: EM13775467

Questions Cloud

Legal and ethical basis for advance directives : Advance Directives-research and discuss the legal and ethical basis for Advance Directives such as the Living Will and Durable Power of Attorney for healthcare. Why are these documents so valuable in healthcare situations?
Paraphrase forgetful surfer in volcano essay in third person : Paraphrase the Forgetful Surfer in Volcano essay in the third person. Professional surfer Ditch Dent met his lover Tiny Wando in the Kook Islands while shooting his surfing video.
Write paper on judicial activism : Write a 2-3 page, APA style paper on judicial activism. Present the arguments on both sides of the question as to whether judges should interpret or simply apply the Constitution
Create a profile of the typical individual who commits : In many cities throughout the United States, the prevalence of hate crimes has increased. You have been asked to provide your insight into this and recommend ways to decrease the occurrence of these types of crimes.
Calculation of change in sales for target : The chosen company is Target Corporation which is one of the largest retailer and chain stores in the world. It's one of those giant retailer having predominant presence in North America - Calculation of change in sales for Target
Confidentiality association with the emr : What disadvantages with regard to confidentiality are associated with the EMR?
How does pornography affect the average us citizen : How does pornography affect the average U.S. citizen? Should our government protect us from being exposed to pornography? If so, why and in what ways? If not, why not
What four noteworthy activities have brought attention : What four noteworthy activities have brought attention to the problem of domestic violence
Display structure of the i_model table : Display structure of the i_model table. Display all the information stored in the i_model table belonging to car group ‘A4'.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Sharpe corporation projected sales

Make a cash budget for Sharpe covering the first seven months of 2004. Sharpe has $200,000 in notes payable due in July that must be repaid or renegotiated for an extension. Will the firm have ample cash to repay the notes?

  Budgetary slack and management short-term orientation

Van de Stede - budgetary slack and management short-term orientation and balanced score card, Just-in-time (JIT) inventory management, Total quality management (TQM)

  Calculate the npv of the new machine

Calculate the NPV of the new machine and explain why it should be accepted or rejected. the companyplans to raise and invest £20,000,000

  Prepare a 2015 budgeted operating statement

Analyze the presidents three options concerning the parcel business and comment on the strengths and weaknesses of each option and give a recommendation.

  Though most medium and large companies have implemented hrm

though most medium and large companies have implemented hrm systems and sophisticated payroll like the one described in

  Calculating internal rate of return

Calculate the net present value, go to the Function Wizard. The function you are going to use is in the function category of FINANCIAL and is NPV and calculating Internal Rate of Return

  Advantages and disadvantages of job order costing

What would be some particular examples of advantages and disadvantages of job order costing?

  Determining firm cost of equity

Your firm has a debt-equity ratio of .40. Your cost of equity is 12% and your after-tax cost of debt is 6%. What will your cost of equity be if the target capital structure becomes a 50/50 mix of debt and equity?

  Evaluate annual rate of return

Total yards used for production were 3,960. How much is the total materials variance and evaluate annual rate of return expected on this machine

  Draw a scatter diagram of boutique catering

Draw a scatter diagram of Boutique Catering's Number of meals prepared and administrative costs for the year and the relevant range has been identified as between 200 and 800 meals prepared. Mark the range on the scatter graph. Do you think this ..

  What amount of the yyy production costs is avoidable

What is the minimum acceptable price of this one-time-only special order and what other items should Tamworth Cabinets consider before accepting this one-time-only special order?

  Adjusted cash balance per bank agreed with the cash balance

The adjusted cash balance per bank agreed with the cash balance per books at November 30 - The December bank statement showed the following checks and deposits

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd