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

  Explanation of predetermined overhead rate

Williams Inc. estimated overhead to be $440000 and direct labor hours to be 100,000 for the year. Actual direct labor ended up being 120,000. Actual overhead for the year amounted for $500,000. What is the predetermined overhead rate?

  Indicate whether this overhead is under or over applied

Calculate the predetermined overhead rate for the current year and use this rate to apply overhead to the jobs that are worked during February.

  Allocation of any underapplied or overapplied overhead

Allocation of any underapplied or overapplied overhead for the month is closest to - cost of goods sold at the end of the month on the basis of the overhead applied during the month in those accounts.

  Estimate of the current contribution margins

What is your estimate of the current "contribution margins" for the three products. Show your calculations and explain them and how much higher or lower would the reported net income be under the ABC system than under the present system?

  Prepare the journal entries for this issuance

The selling price of the package is 102. At the time of sale, the market value of the bonds without the warrants is $48 and the market value of the warrants is $20 each. Prepare the journal entries for this issuance.

  Maximize spencers monthly commissions

What client mix will maximize Spencer's monthly commissions, assuming he works 200 hours per month - what are the activity - cost driver rates for the supervision of direct labor, machine maintenance, and facility rent.

  Identify the key factors that hlw should consider

Estimate the effect on sales revenue resulting from the planned change in fee structure for the next financial year, which starts 1 October and ends on 30 September. State any assumptions that you need to make.

  Determing production and direct material purchases

Alder Company budgets an annual basis. The following beginning and ending inventory levels (in units) are planned for the next year. Two units of raw material are required to produce each of finished products.

  Compute the cost per cost driver

Compute the cost per cost driver for each of the three cost centers and use the results from part 1 to allocate costs from each of the three cost centers to both financial planning and tax preparation.

  Write a memo to the manager

Determine whether Dawson Company should drop any game and write a memo to the manager with your recommendation.

  Explain key features of a good process-oriented management

Explain why the management accounting information from the traditional responsibility accounting system fails to provide a greater strategic focus?

  Allocating joint costs

Assign the joint land and improvement costs to the lots using the value basis of allocation and compute the average cost per lot in the Canyon section and in the Hilltop section.

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