Question: 1) Perform a horizontal analysis and vertical analysis for all the items in the Income Statement and Balance Sheet for the year 2018 to 2020

1) Perform a horizontal analysis and vertical analysis for all the items in the Income Statement and Balance Sheet for the year 2018 to 2020 of Shell and Petronas company. Compare and discuss the results between the years on the trends of important items, such as the: a) Revenue, Gross Profits, Net Income. b) Current Assets, Long term Assets, Current Liabilities, Long Term Liabilities and Equity c) Table out the results for each item according to years. Plot the trend of each item on a graph (All item must be in one graph. Use markers or different colours to differentiate the trend line of each item) d) Discuss on the possible reasons contributing to the trend

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Help me solve this please. Chapter 14 Class Problem #1 Here is the Galloway Corporation data for the current years Account Current year Cash $46,200 A/R $69,000 Mdse, Inventory $67,500 Equipment...

1) Perform a horizontal analysis for all the items in the Income Statement and Balance Sheet for the year 2018 to 2020 of Shell and Petronas company. Compare and discuss the results between the years...

Part 2 Calculations - (30 points) Always use the most current years for ratios, horizontal and vertical analyses 3. Calculate ratios for the companies. The ratios should help you decide about the...

ACG 2011 Project Instructions: Select two companies in the same industry DNKN & SBUX Obtain the most current 10-k Financial Statements for the companies: You need three years of data. Calculations -...

Learning Objectives Excel When you have finished this assignment, you should be able to perform the following actions in Excel: Fill cells by using Auto Fill. Use simple math formulas. Apply number...

in D. revenue omissions. 34. Per the Fraud Examiners Manual, which of the following is true with regards to related-party transactions? A. there is nothing inherently wrong with related...

Orascom Investment maintains the legacy of the region's most successful investor and telecom operator. Its roots go back to Orascom Telecom Holding, which was established in 1997, and then Orascom...

Conduct a Financial Analysis report on LOWE'S and HOME DEPOT: ** see Income Statement, Balance Sheet and Cash Flow for each company bellow and attached ** 1. Compute the following ratios for the last...

How well does Twitter support the class discussion process?

A single-loop circuit consists of a 7.20 resistor, a 12.0 H inductor, and a 3.20 mF capacitor. Initially the capacitor has a charge of 6.20 mC and the current is zero. Calculate the charge on the...

Not use ai solution please and accounting question Summit Enterprises, a closely held corporation, generated $180,000 of income from operations during the year. It also received passive losses of...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

4. Do you have power relative to this person? Why or why not? Do you need or want more power in this case? If yes, then what are some of the ways in which you might increase your influence and power?

1. On balance, do you think networking is best thought of as a way to meet interesting people or a way of using people to get what you want?

2. Assuming that, after his reassignment, John might have become more open to suggestions on his behavior, how might you advise him?