Conduct the following analysis based on data below Horizontal analysis , select
Fantastic news! We've Found the answer you've been seeking!
Question:
Conduct the following analysis based on data below
· Horizontal analysis, select one base year 2015, and calculate dollar change and percentage change.
· Vertical analysis (Common size analysis)
· Trend analysis, select base year 2015 for trend analysis
Transcribed Image Text:
CSL Ltd (CSL.AX) All numbers except for ratios and EPS are in thousands ('000's) Report Date 30/06/2020 30/06/2019 30/06/2018 30/06/2017 30/06/2016 30/06/2015 Income Statement Revenues Cost of Goods Gross Profit General/Admin Expense 9,150,800 8,538,600 7,915,300 6,922,800 6,115,300 5,628,000 3,924,400 3,761,200 3,531,600 3,326,800 3,052,800 2,605,900 5,226,400 4,777,400 4,383,700 3,596,000 3,062,500 3,022,100 1,588,000 1,441,600 1,301,000 1,181,800 1,011,200 760,700 Sales + Marketing Expense Research & Development 921,800 Operating Income 2,716,600 831,800 2,504,000 702,400 645,300 613,800 462,700 2,380,300 1,768,900 1,613,600 1,773,600 Interest Income/Expense 143,800 162,900 99,100 79,100 57,700 59,600 Other Income/Expense Net Tax Expense Net Income 100 470,200 422,400 552,300 2,102,500 1,918,700 1,728,900 352,400 1,337,400 313,500 1,242,400 335,000 1,379,000 Earnings Per Share (Basic) 4.61 4.23 3.81 2.93 2.68 2.91 Earnings Per Share (Diluted) 4.61 4.23 3.81 2.93 2.68 2.91 Weighted Average Shares 455,605 454,028 453,877 456,375 463,117 473,165 Weighted Average Shares (Dilute 455,605 454,028 453,877 456,375 463,117 473,165 Balance Sheet Cash And Equivalents 1,194,400 657,800 814,700 844,500 556,600 556,800 Short-Term Investments 3,300 400 1,600 5,200 600 2,600 Cash And Short-Term Investment 1,197,700 658,200 816,300 849,700 557,200 559,400 Receivables 1,593,300 1,726,300 1,372,100 1,113,500 1,044,300 978,900 Inventory 3,509,500 3,038,800 2,692,800 2,575,800 2,152,000 1,755,600 Other Current Assets 145,700 116,800 Current Assets 6,446,200 5,540,100 112,500 4,993,700 63,100 4,602,100 64,500 3,818,000 45,200 3,339,100 CSL Ltd (CSL.AX) All numbers except for ratios and EPS are in thousands ('000's) Report Date 30/06/2020 30/06/2019 30/06/2018 30/06/2017 30/06/2016 30/06/2015 Income Statement Revenues Cost of Goods Gross Profit General/Admin Expense 9,150,800 8,538,600 7,915,300 6,922,800 6,115,300 5,628,000 3,924,400 3,761,200 3,531,600 3,326,800 3,052,800 2,605,900 5,226,400 4,777,400 4,383,700 3,596,000 3,062,500 3,022,100 1,588,000 1,441,600 1,301,000 1,181,800 1,011,200 760,700 Sales + Marketing Expense Research & Development 921,800 Operating Income 2,716,600 831,800 2,504,000 702,400 645,300 613,800 462,700 2,380,300 1,768,900 1,613,600 1,773,600 Interest Income/Expense 143,800 162,900 99,100 79,100 57,700 59,600 Other Income/Expense Net Tax Expense Net Income 100 470,200 422,400 552,300 2,102,500 1,918,700 1,728,900 352,400 1,337,400 313,500 1,242,400 335,000 1,379,000 Earnings Per Share (Basic) 4.61 4.23 3.81 2.93 2.68 2.91 Earnings Per Share (Diluted) 4.61 4.23 3.81 2.93 2.68 2.91 Weighted Average Shares 455,605 454,028 453,877 456,375 463,117 473,165 Weighted Average Shares (Dilute 455,605 454,028 453,877 456,375 463,117 473,165 Balance Sheet Cash And Equivalents 1,194,400 657,800 814,700 844,500 556,600 556,800 Short-Term Investments 3,300 400 1,600 5,200 600 2,600 Cash And Short-Term Investment 1,197,700 658,200 816,300 849,700 557,200 559,400 Receivables 1,593,300 1,726,300 1,372,100 1,113,500 1,044,300 978,900 Inventory 3,509,500 3,038,800 2,692,800 2,575,800 2,152,000 1,755,600 Other Current Assets 145,700 116,800 Current Assets 6,446,200 5,540,100 112,500 4,993,700 63,100 4,602,100 64,500 3,818,000 45,200 3,339,100
Expert Answer:
Related Book For
Marketing Research An Applied Orientation
ISBN: 978-0136085430
6th edition
Authors: Naresh K Malhotra
Posted Date:
Students also viewed these finance questions
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
The major financial statements of Ten Peaks Coffee Company Inc. from its 2013 annual report are included in Exhibits 1-11A to C. Note that its fiscal year end is December 31, 2013. Required: a. Find...
-
Lopez Company uses a job order cost accounting system that charges overhead to jobs on the basis of direct material cost. At year-end, the Goods in Process Inventory account shows the following. 1....
-
Prepare a vertical analysis for 20X1 and 20X2. Briefly comment on the results of your work.
-
What is the World Bank? What is its role in the world economy?
-
What are some of the technological issues that arise through the use of technology in the function of selection?
-
Given that z is a standard normal random variable, compute the following probabilities. a. P(z 1.0) b. P(z 1) c. P(z 1.5) d. P(2.5 z) e. P( 3 < z 0)
-
Calculate the following showing all the necessary steps: Note: CPP rate to be used in the calculation is 5.95%. Note: Don't forget to deduct pay period exemption\ \ Tanya earns $25.00 per hour. This...
-
Hong Kong Island features steep, hilly terrain, as well as hot and humid weather. Travelling up and down the slopes therefore causes problems; this has led the city authorities to imagine rather...
-
34. If A, G and H be the arithmetic mean, geometric mean and harmonic that: mean respectively of two positive numbers a and b, then prove (i) A GH. When does the equality sign hold? (ii) G = AH.
-
Debate Immigration law must be reformed to provide a reasonable and timely pathway for legal residency. Question 1. Debate how the argument on the top can be true? 2. How does immigration reform can...
-
Teachers can't understand why Student A is doing very poorly in class. They referred the student to a psychologist so that an intelligence or aptitude assessment could be conducted. Surprisingly the...
-
What is sanctuary cities in the immigration law context? Are there any in Virginia? What do you think about this concept? Should it be allowed? If so, why, and on what legal basis? If not, why not?...
-
The Retro Junior Theatre prices movie tickets at $15 per customer. Their variable costs are $8 per customer and their fixed costs are $70,000 per month. The company's relevant range goes up to 38,000...
-
Immigration Law There is always the challenge of achieving a balance between observing human rights on the one hand, against the need to ensure adequate protection of the borders, and the need to...
-
8. Prove that eVI+ rdr < (2e 1)
-
Medi-Exam Health Services, Inc. (MEHS), located in a major metropolitan area, provides annual physical screening examinations, including a routine physical, EKG, and blood and urine tests. MEUS's...
-
Microsoft has developed a new version of its spreadsheet EXCEL but is not sure what the user reaction will be. Design an Internet-based experiment to determine user reaction to the new and the...
-
Analyze the outdoor lifestyle data given in Internet and Computer Exercises 2 of Chapter 15. Do the three groups based on location of residence differ on the importance attached to enjoying nature,...
-
What are the implications of having an arbitrary zero point in an interval scale?
-
To test \(H_{0}: \sigma=50\) versus \(H_{1}: \sigma <50\), a random sample of size \(n=24\) is obtained from a population that is known to be normally distributed. (a) If the sample standard...
-
(a) Determine the critical values for a right-tailed test of a standard population deviation with 18 degrees of freedom at \(\alpha=0.1\) level of significance. (b) Determine the critical values for...
-
In Example 2 from Section 10.3, the quality-control engineer for M\&MMars tested whether the mean weight of fun-size Snickers was 20.1 grams. Suppose that the standard deviation of the weight of the...
Study smarter with the SolutionInn App