Financial Analysis- for Royal Dutch Shell - 5927 Words

Royal Dutch Shell, Plc. (NYSE: RDS.A) Table of Contents Executive Summary3 Introduction4 Financial Ratio Analysis5 Liquidity6 Asset Management7 Debt Management8 Profitability10 Market Value12 Cash Flow and Growth Analysis14 Capital Structure Estimation16 Weighted Average Cost of Capital17 Cost of Debt17 Cost of Equity - CAPM18 Cost of Equity - DCF19 Cost of Equity - BYPRP19 WACC20 Project Cash Flow Estimation21 Capital Budgeting Analysis23 Sensitivity Analysis24 Scenario Analysis27 Conclusion28 References29 Appendix30 Executive Summary This report analyzes Royal Dutch Shell Plc. (RDS.A on NYSE) financial status, history, market space, and growth opportunities. Royal Dutch Shell Plc.†¦show more content†¦Royal Dutch Shell, Plc. (NYSE: RDS.A) Financial Ratios | Liquidity Ratios | 12/31/2011 | 12/31/2010 | 12/31/2009 | 12/31/2008 | 12/31/2007 | Average | Industry | Comments | Quick Ratio | 0.85 | 0.8 | 0.79 | 0.9 | 0.84 | 0.84 | 1.1 | Healthy | Current Ratio | 1.17 | 1.12 | 1.14 | 1.1 | 1.15 | 1.136 | 1.5 | Healthy | | | | | | | | | | Asset Management | 12/31/2011 | 12/31/2010 | 12/31/2009 | 12/31/2008 | 12/31/2007 | Average | Industry | Comments | Inventory Turnover | 13.6 | 10.84 | 9.77 | 15.56 | 10.84 | 12.12 | 14.9 | OK | Fixed Assets Turnover | 3.29 | 2.76 | 2.34 | 4.28 | 3.51 | 3.24 | 1.3 | Healthy | Total Asset Turnover | 1.45 | 1.23 | 0.99 | 1.66 | 1.41 | 1.35 | 0.6 | Healthy | | | | | | | | | | Debt Management | 12/31/2011 | 12/31/2010 | 12/31/2009 | 12/31/2008 | 12/31/2007 | Averag e | Industry | Comments | Debt Ratio | 17.90% | 22.80% | 20.20% | 15.30% | 12.60% | 17.76% | 51.98% | Healthy | Net Fixed Debt Ratio | 15.10% | 18.70% | 18.30% | 9.70% | 8.90% | 14.14% | 27.38% | Healthy | Debt to Equity Ratio | 21.70% | 29.61% | 25.36% | 18.06% | 14.37% | 21.82% | 42.69% | Healthy | | | | | | | | | | Profitability Ratios | 12/31/2011 | 12/31/2010 | 12/31/2009 | 12/31/2008 | 12/31/2007 | Average | Industry | Comments | Net Profit Margin on Sales | 6.32% | 5.47% | 6.88% | 3.32% |Show MoreRelatedPaper581 Words   |  3 Pagesstructure of Royal Dutch/Shell Group. Does it differ from the equity listings of other companies that you know? These equity listings are different from companies such as BP and Exxon. All subsidiary companies’ shares were held by the Group Holding Companies in the ratio of 60/40 (Royal Dutch/Shell). The corporate structure is outlined in the figure below. Individuals and Institutions Individuals and Institutions Royal Dutch Petroleum Company Netherlands 60% The â€Å"Shell† Transport andRead MoreFinance Shell1286 Words   |  6 PagesThe Case of Royal Dutch and Shell Structure: The Royal Dutch/Shell Group is different because it appears that it is functioning as a single company instead of two separate companies. Yet, they are functioning as two separate companies. The Shell Company in the Netherlands, the Shell Company in the UK and the Shell Petroleum Company in the USA all appear to be maintaining their own identities in their respective countries. The Royal Dutch and Shell Company share equally in the Shell Company inRead MoreSwot Analysis of Oil in Nigeria2736 Words   |  11 Pagesinformation from http://www.researchandmarkets.com/reports/683505/ Nigeria Oil and Gas Exploration and Production Industry Investment Opportunities, Analysis and Forecasts of All Active and Planned Exploration Blocks and Oil and Gas Fields to 2012 Description: Nigeria Oil and Gas Exploration and Production Industry Investment Opportunities, Analysis and Forecasts of All Active and Planned Exploration Blocks and Oil and Gas Fields to 2012 Summary This profile is the essential source for top-levelRead MoreSWOT Analysis of Shell in Nigeria1364 Words   |  5 PagesOverview of Shell and Operations - Shell is a group of energy and petrochemicals companies, which are operating in more than 140 countries and territories. The Royal Dutch/Shell Group, commonly know as Shell, is an amalgam of over 1,700 companies all over the world. 60% of the Group is owned by Royal Dutch of the Netherlands, and 40% is owned by the Shell Transport and Trading Group of Great Britain. These two companies have worked together since 1903. Shell includes companies like Shell PetroleumRead MoreInvesting Analysis for Royal Dutch Shell vs. British Petroleum5483 Words   |  22 PagesINTERNATIONAL FINANCE INVESTING ANALYSIS FOR: ROYAL DUTCH SHELL amp; BP PREPARED BY: ARMI ARFIFI BIN AZMI ATMAN BIN KHAIRULFAZI MOHD NAZRUL BIN AGOS MUHAMMAD AMIRUL MUKMIN BIN NOR HIDAN CONTENTS PREFACE 3 1.0 INTRODUCTION 4 2.0 COMPANY DESCRIPTIONS 6 2.1 SHELL 6 2.2 BP 7 3.0 PROBLEM DEFINITION 8 3.1 Research Problem 8 3.2 Project Objective 9 3.3 Research Question 9 4.0 PEST ANALYSIS 9 5.0 SWOT ANALYSIS 11 6.0 FINANCIAL ANALYSIS 14 6.1 Pyramid Of Key Ratios 14 Read MoreFinancial Accounting Exxon Shell Case1400 Words   |  6 PagesSchool of Business Financial Accounting 30000 Financial Statement Analysis Case Exxon vs. Shell: Understanding the effect of inventory valuation on Financial Statements Designed by: Valeri Nikolaev Objective: Understanding the effect of inventory valuation assumptions on financial statements. Assignment summary: You are taking the role of a security analyst who recently started following the Oil and Gas industry. The analyst has a task to draw a comparison of several financial indicators for twoRead MoreGlobal Success Of The Royal Dutch Shell Company Essay1758 Words   |  8 PagesIntroduction Increased global success of the Royal Dutch Shell Company in the majority of emerging markets highlights the potential for consequent success within the US market. The need for expansion into the North American market remains crucial in facilitating overall business growth within a strong economy characterized by high levels of competition (Szulczyk McCarl, 2010). The decision to invest abroad by a company provides benefits to the company and the host country. However, the foreignRead MoreThe Financial Statement Of Shell Plc1617 Words   |  7 PagesINTRODUCTION This report is aimed to analyze the financial statement of Shell PLC between the years 2013 and 2014. Annual reports are used in order to calculate relevant ratios to measure profitability, liquidity and cash flow of the company. 1. Brief Description of Royal Dutch Shell PLC Royal Dutch Shell PLC engages in the oil and natural gas production. It operates through three segments: Upstream, Downstream. The Upstream segment combines the operating segments Upstream International and UpstreamRead MoreBusiness and Society Final - Group 06.Doc1478 Words   |  6 PagesGroup Assignment - Project Report Case: Shell Oil in Nigeria CLASS: BUS6351 - 2010SU-25535-BUSINESS AND SOCIETY Submitted by: Group 06 Nawazuddin Mohammed Khaja Randy Janssen Olufunto Ogunnowo Ladarien Richardson James Groesbeck Abstract The purpose of this paper is to critically analyze the case â€Å"Shell Oil in Nigeria† presented in our text book â€Å"Business and Society†. Here we discuss the company’s mission statement, their crisisRead MoreRoyal Dutch/Shell, Acquisitions, and Globalization3225 Words   |  13 PagesRoyal Dutch/Shell, Acquisitions and Globalization Question 1: Royal Dutch/Shell Group operates on a global basis, and is well known for continuously striving to look beyond horizons. Using examples from the case study, critically examine the main arguments for and against globalization in the global mining and metals industry in terms of: (a) The threat of new entrants and substitutes in emerging markets, and The oil and natural gas industries are inherently global in nature. This is likewise