Definition and How to Handle an Adjustment Letter

Definition and How to Handle an Adjustment Letter An adjustment letter or a claim adjustment letter is a written response from a representative of a business or agency to a customers claim letter. It explains how a problem with a product or service may (or may not) be resolved. How to Handle the Response If your business has received a claim letter from a customer, youll want to handle your response diplomatically and with the proper  you attitude  to quickly and effectively repair or prevent any damage to your reputation. Even if the complaint cant be resolved exactly as the customer wishes or you have to give bad news, you want to still take a positive, professional tone.   Andrea B. Geffner illustrates further: An  adjustment letter  should begin with a positive statement, expressing sympathy and understanding. Near the start, it should let the reader know what is being done, and this news, good or bad, should be followed by an explanation. The letter should end with another positive statement, reaffirming the companys good intentions and the value of its products, but  never  referring to the original problem.Whether or not your company is at fault, even the most belligerent claim should be answered politely. An adjustment letter should  not  be negative or suspicious; it must  never  accuse the customer or grant any adjustment grudgingly. Remember, your companys image and goodwill are at stake when you respond even to unjustified claims.​ (How to Write  Better  Business Letters, 4th ed. Barrons, 2007) Be careful to never promise something your company cant deliver (or a deadline you cant meet), or that will only compound the problem. Convey to your customer that you do have his or her interest in mind, and keep the door open to keep their business and for better success in the future. Even as times change, some things remain true. Good business advice hasnt changed in the last 100 years, as evident from advice given by O.C. Gallagher and L.B. Moulton in Practical Business English, from 1918:   Any showing of ill-feeling or anger in your adjustment letter will defeat its purpose. Indifference toward the customers complaint or delay in answering it is likewise fatal to further business relations. The you, not the I, attitude will put the offended customer in good humor, and open the way for a pleasant settlement of the complaint. An adjustment letter characterized by the  you attitude  becomes a sales letter. Dealing With Internet Complaints The same type of advice also applies to dealing with complaints or poor reviews levied against businesses on the internet or via social media. You still need to be diplomatic in your response. Speed in diffusing a complaint is of the essence- but not hastiness. Remember that anything you type in an electronic message or post can be copied and forwarded for the world to see, and its really difficult to completely delete something after posting it online or hitting send.Have someone proofread it and check for cultural sensitivity or other potential pitfalls before putting it out there.Cut to the chase- keep the public-facing text short and to the point.  Always have a cool head when responding to criticism online or else the problem can spiral. Any text online affects your brand and reputation. A successful resolution to a complaint or claim also has the ability to spread far and wide, though likely not as fast or widely as a poor review or complaint, unfortunately.   Sources Gerald J. Alred, Charles T. Brusaw, and Walter E. Oliu, The Business Writers Handbook, 10th ed. Macmillan, 2011. Philip C. Kolin, Successful Writing at Work, 9th ed. Wadsworth Publishing, 2009.

Debate Critiques Essay Example | Topics and Well Written Essays - 500 words

Debate Critiques - Essay Example For instance, the advantages of ethical obligations such as rise in market share, increase in market value, higher sales improved sales, lower employee turnover, and cost control are all explained with sufficient data obtained from previous researches. Furthermore, this presentation entices sufficient thought in the reader’s mind about possible negative impact of multinational corporations, which is also explained in this presentation. Another scoring point in Team A’s presentation is that it explains the potential negative impact of absence of ethical obligations by explaining what kind of impact multinational companies can have on the economy, country, and environment if they did not have any ethical obligations towards these entities. The main strengths of presentation by Team B include its succinctness and reader-friendly approach. This presentation highlights the most important points related to the kind of ethical obligations that multinational corporations have. Further, it highlights the ethical considerations multinational companies have kinds of impact ethical obligations can have such as employment practices, workplace conditions, environmental impact, local customs, and ethics. However, this presentation does not provide any information related to experimental evidences. Another weakness in Team B’s presentation is in its flow and presentation of information, which could have been better as it covered almost same information as Team A, but without any experimental evidence. Although information here is not irrelevant, the relevance of information presented is not established. Lack of support from experimental evidence presents this as a weaker presentation. The main strengths of Team A’s presentation include its presentation style, logic, and flow, and link to experimental evidence. Every point made in this presentation has been clearly explained and

A view of Essay Example | Topics and Well Written Essays - 1000 words

A view of - Essay Example It turns out that the country is geographically located in the Western Pacific Ocean and is a sovereign state of South East Asia. Its closest neighboring countries are China, Borneo, and Indonesia. I asked Tine how she has been enjoying her stay in her new home so far. She mentioned to me that although she loves the cold climate in the country, it sometimes make her long for the tropical weather in the Philippines. It seems that they have only 3 types of weather in the country hot, wet, and cold. The hot weather is felt almost the whole year round except during the so called Ber months when the cold winter air from China blows down to their area. While we partook of the Filipino snack, I could not help but mention to her that she did not look like a typical Filipino to me. Tine is relatively light skin toned with Latina features. She giggled a bit and thanked me for the compliment. She explained that the dark skinned Filipino is a myth perpetrated by their colonizers centuries ago. The Spaniards who were the first to colonize the country referred to them as Indios meaning â€Å"dark skinned† and the image seems to have stuck. I asked Tine to describe a typical Filipino to me then. She said that was next to impossible because of the diluted blood of the Filipinos. Tine herself has a mix of Filipino-Spanish-Chinese blood in her. While Don, her husband is of American-Filipino descent. She told me that there are no pure blooded Filipinos anymore. They have inter married with other nationalities so many times that one would be hard pressed to describe a typical Filipino look. It is because of their colonization by the Spaniards, Americans, and Japanese that their customs and traditions have also become a hybrid of two or three various cultures that create a totally unique Filipino culture and customs. She used the Maskara Festival in one of their provinces as an example of the hybrid custom and tradition in the country. Their culture and

Civil engineering Essay Example | Topics and Well Written Essays - 500 words - 2

Civil engineering - Essay Example All the facilities and infrastructures that we use in our everyday activities are works of civil engineers and therefore the discipline can be regarded as one of the oldest profession (Agrawal and Dill, 76-82). The field of civil engineering has been improving over the years. The improvement has been possible first due to the development of technology and through building innovatively on the previous works. As the field develops, it has been focusing attention on solving the present challenges in the lives of men. I have chosen civil engineering because it gives me a chance to join the group of innovators and developers who design and build the best and most significant features in the world. Being an engineer has always been my dream throughout school. I always enjoyed as buildings grew from a bare ground, and roads and highways traversed a previously wild area. This always made me feel the urge to be part of the development. In high school, I was keen to notice excellence in physics and mathematics was the way to achieving my dream. The main aspect of the discipline that interests me most is the innovativeness that is encouraged in civil engineering. Different from architecture, in civil engineering there is more that drawing of designs. There is the actual touch of the work and appreciation of results. Civil engineers are capable of assessing the needs of the population better and implement solutions through designing and building of what the population needs. Besides this, civil engineering will allow me to travel to many places and meet many different kinds of people and cultures which has always been my hobby. One of the grand challenges in engineering today is the restoration and improvement of urban infrastructure. Urban transport and other fundamental life supporting systems are facing a challenge related to the increasing urban population. Moreover, the infrastructure in many cities is slowly aging and failing as a result. It is

Online Car Rental System Tourism Essay

Online Car Rental System Tourism Essay People travel from one place to another for many reasons, some due to their jobs or business and few for holidays and vacations. As a traveller they cannot own a car in every place or country they go, they always prefer other options like public transports, cabs, busses, trains and rent cars or bikes. Getting a car on rent has become very famous due to the cost as it is much cheaper than using cabs for a whole day and because it is much more secure and convenient. Keeping this in the mind Researcher has decided to develop an online car rental system, by using online car rental system a traveller can book the car. As the name of the system suggest, this system will be an online car rental system. This system will not only help the travellers to select the car of their chose but they can also compare the different models of car available and different type. They can compare prices, models and brands. They can select if they want that the car should be delivered to their door step with additional charges or they will pick up the car from the nearest store. They can select the car according to their requirement and budget. Problem statement and Literature review à ¢Ã¢â€š ¬Ã‚ ¢ Expensive rent for travellers As stated by Flowers, J and Levere, J. (2008) due to rise in drivers fees and taxes such as state and local surcharges applied on airports, the rent of the cars can increase at an average of 25 per cent. Due to rise in Tax, the travellers have to pay up to 25% of tax when the booking or renting a car from the airports. Even if the traveller pays the higher price they have to go with the cars which are available at that point of time in the car rental office. It can be expensive cars or even luxury cars which are not in budged of every person. To overcome this problem the Online Car Rental System will help the traveller to book the car even before they have arrived. So that they do not have to pay extra airport charges and get any car which is in their budget and which suits them and their requirements. à ¢Ã¢â€š ¬Ã‚ ¢ Returning the car remotely According to Yang, Y., (2008), difficulty is in uncertainty of length time of the person who have taken the car on rent and which referred location he wants to return the car. Sometimes a person takes a car on rent, but it is not sure when will the person return the car and will the person be able to come to the same location to return the car or not, in this situation that person have to pay more if he delay to return the car on time. This online car rental system will provide an online service where the person can increase the time limits and predefined the location person will be dropping the car or he want the car to be taken from. à ¢Ã¢â€š ¬Ã‚ ¢ Cannot reserve specific car model According to Korstanje, M. E., (2011), Due to limitation in operations creates problem for renter to reserve specific model. Reservations are not given on the basis of model but group. Due to operation limitation in the area like airports, this problem causes issue like in which the renters are not able to get what they actually want and they have to go for the car which is available in the store even if it is not what they are willing to have. This online system will help traveller to do online booking in which he can select which car he prefer with the facility of comparing with other car on the basis of type and price so that he can makes best decision. à ¢Ã¢â€š ¬Ã‚ ¢ No time for customers feedback As said by Meyer, C., and Schwager, A., (2007), Due to many transactions by individual customers which are monitored by the company they does not get time to take feedback from them regarding the service provided. When a customer comes to an office for renting a car, due to having many customers the staff member of the company does not get chance to ask customers regarding their services because of which their problems are not rectified. To rectify these issues the online car rental system will have an online feedback service after each customer have done with their transaction at the time of logout. The system will ask for a feedback from the customer. à ¢Ã¢â€š ¬Ã‚ ¢ Time wasting As said by Ahlstrom, C., Kircher, K., et al., (2012), Due to a single mistake of the airport rental service it take hours to get cars on rent. When there is a problem in the airport rental service it can take hours to get the car on rent which is actually wasting the time of the renter. In online car rental system the reservation will be done before traveller arrived at the airport so that when the traveller arrives at the airport the car will be ready to be taken. à ¢Ã¢â€š ¬Ã‚ ¢ Change car on each route As said by Asconavieta, P.H.S. (2011) car rental companies usually work on the regional basis because of which traveller have to change car on every route. Due to shortage of area coverage as the car taken for the company should return to the same location makes the traveller to keep changing the car even if they go from one state to another. They have to come back to the same location. So when they go to different state they have to change their car. To rectify this problem the online car rental system will have an option of selecting the area the customers want to return the car. So In the country like Emirates or Maldives where the area is short, the car can be taken from one state to another state without any problems. à ¢Ã¢â€š ¬Ã‚ ¢ Improper scheduling for proper car utilisation As stated by Minodora, 2009, improper scheduling in car rental companies causes the company unable to utilise their car and even increase work time for renter to get car. Due to improper scheduling in the car rental companies the car spend more time in the companys car lot or customers have to wait until the car is not returned. Using online car rental system the scheduling will be done online by the customer itself as the car which they select they have to put the time they will return. If in case they fail to return or inform the pickup point extra charges will be charged to them. à ¢Ã¢â€š ¬Ã‚ ¢ Return car on the same agency location According to Goldbarg, M., Asconavieta, P. and Goldbarg, E., (2012), car rented from a company can only be returned to the agency of the same company. If a renter take a car from a company he or she have to return it to the same agency of the same company but if the person is new in the region it will not be possible for him to do that it will be wasting of time in searching for the agency. In the online car rental system the renter can select whether he wants to retune the car or he wants the car to be taken from where he is , it can be hotel, airport, mall or any other location he can predefined the location online and the car will be picked up from him. à ¢Ã¢â€š ¬Ã‚ ¢ Insufficient revenue Lin-in, H., and Tao, Q. (2011) described that car renting companies in certain areas unable to get sufficient revenue for growth. This issue is due to concentrating on a limited region because the rate of sale increases based on the area of the company it is located in if the company is limited to its area only. In online car rental system there will be no boundaries, the company can concentrate on any location and get revenue from any part of the area or even country if the country is not in a bigger size like Emirates or Maldives. à ¢Ã¢â€š ¬Ã‚ ¢ Rejection due to short time frame According to Guerriero, F., Olivito, F. (2011) in order to increase the revenue, company with limited car does not rent the car for a day or few hours. Because of limited area of work company does not give their cars for short period of time to increase their revenue which make it difficult for the traveller to search car renting company after he have reached to the unknown country or location. As the online car rental system allows traveller to book the cars online. A person does not really have to go through all this type of issues as a person will be getting the car as soon as he or she arrives. Research Aims Objectives 4.1 Aims To create an online system, that will allow travellers to easily rent a car. It will also allow user to select the car according to their requirement and compare it with other options of cars. Make it easy for a traveler to return the car on remote locations. Solving the manual scheduling problem as every transaction will be done online. 4.2 Objectives Is to create a reliable web base online system on which user can access using internet from anywhere. To use software tools in implementation, this will help in implementing features for easy access. Allow system users to participate in the early stages of development so the outcome will be user oriented. Research Questions There are two categories in which the researcher has classified the questions. 5.1 Domain research Questions How the system will help in car scheduling? How the system will affect the operation of the renting company? How the proposed system is different from existing systems? How to integrate online payments by credit cards? 5.2 Technical research question Which scripting language can be used for the proposed system? Which data base system can be used for the proposed system? How the different feature can be implemented into the system? Which web authoring software can suits best of the system? Research Design 6.1 Domain Research The research in domain research will be conducted from literature source like journal, eBooks, white papers and library books. Furthermore research will be done by using online resources such as IEEE Xplore, Google Scholar and my Athens. 6.2 Technical research Mainly Web resources such as eBooks and journal will be used in conducting technical research. Research Plan Personal Reflection 7.1 Facts finding Methods The fact finding method which the researcher will use is questionnaire and interview fact find methods. Questionnaires are objective and will reach too many respondents which will provide researcher with sufficient information for accurate analysis. On the other hand the interview method will allow the researcher to get deep understanding about the topic area. 7.2 Limitations Like every system have some limitation, in order to collect data and questionnaire from traveller during the development will be difficult and their participation is not possible so this matter can be overcome by using social networks and other web application to take questionnaire before or in the early stages of the system development

Thou Shalt not Trample on the Constitution :: essays research papers fc

Thou Shalt not Trample on the Constitution. Congress shall make no law respecting an establishment of religion, or prohibiting the free exercise thereof; or abridging the freedom of speech, or of the press; or the right of the people peaceably to assemble, and to petition the government for a redress of grievances. This is the first amendment to the Constitution. In essence this states that the government will not become involved or sponsor any religion. There is a reason our founding fathers added this amendment to the Constitution. Any time a government becomes involved with religion or visa versa, Disaster happens. If you want evidence of this look at the history of Europe for the past 700 years and see what chaos has arisen when religion and the state intertwine. Yet we do not seem to be learning from the past. Congress on June 17, 1999, passed a law that slaps the First Amendment in the face. That law allowed for the states to choose to post the Ten Commandments in public schools and other government buildings. The law that was proposed by Rep. Bob Barr (R-GA), Rep. Robert Alderholt (R-Al), and Rep. Henry Hyde (R-IL). The bill was created in response to the Columbine shootings that took place April 20, 1999. The bill was swept through the house at a time when the country was in shock over the shootings. There were several reasons why the house felt the need to pass such a bill. Rep. Alderhold believed that it is an important step to promote morality, and an end of children killing children. (Leavitt) Rep. Hyde believes that the amendment should â€Å"slow the flood of toxic waste into the minds of our children.† (Webster) Rep. Barr went as far to say that if â€Å"Columbine had the Ten Commandments posted that the massacre of April 20th would not have occurred.†(Webster) Thes e are the arguments for the Ten Commandments to be posted in public schools. These are the best reasons our elected representatives could come up with to slap the First Amendment in the face. Is it really as Rep. Alderholt said â€Å"We have the freedom of religion, not freedom from religion†? (Leavitt) According to the Supreme Court The honorable Alderholt is wrong. In 1980 the Supreme Court ruled that a similar Kentucky law, which required all classrooms to post a copy of the Decalogue, was unconstitutional. The oppositions' arguments against this law are enormous.

Financial Analysis- for Royal Dutch Shell

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 Appendix30Executive Summary This report analyzes Royal Dutch Shell Plc. (RDS. A on NYSE) financial status, history, market space, and growth opportunities. Royal Dutch Shell Plc. (Shell) is one of the world’s largest corporations with annual revenue of $470 billion for fiscal year 2011. When analyzing a company it is vital to ensure all aspects of the firm’s financial standing are stable, this is essential to guarantee its ability to take upon n ew major projects, such as the one being proposed at this time and evaluated in this report.This report intends to evaluate the possibility of Shell undertaking a project that requires a total initial investment of $580 million in fixed assets as wells as operation expenses of $38 million, for a total of $618 million is startup costs. This report illustrates Shell’s financial standing through, ratio analysis, cash flow analysis, and detailed capital budgeting analysis to help calculate Shell’s capacity to accept the proposed project. The life of the project will be eight years and expected to have a growth rate of 8. 5%.The Net Present Value of the project is approximately $284 million and is expected to pay for itself in approximately 4. 74 years according to discounted payback calculations (detailed in report). Introduction Royal Dutch Shell plc operates as an oil, gas and energy company that explores for and extracts hydrocarbons worldwide. Royal Dutch Shell also co nverts natural gas to liquids to provide cleaner-burning fuels; markets and trades natural gas; extracts bitumen from mined oil sands and convert it to synthetic crude oil; and generates electricity from wind energy.In addition, it converts crude oil into a range of refined products, including gasoline, diesel, heating oil, aviation fuel, marine fuel, lubricants, bitumen, sulphur, and liquefied petroleum gas (LPG); and produces and sells petrochemicals for industrial use. The company holds interests in approximately 30 refineries; 1,500 storage tanks and 150 distribution facilities; and fuels retail network of approximately 43,000 service stations under the Shell brand name. Royal Dutch Shell plc also markets its products under the Shell V-Power and Shell FuelSaver brand names.In addition, the company offers lubricants for use in passenger cars, trucks, and coaches, as well as for industrial machinery in manufacturing, mining, power generation, agriculture, and construction industri es. Royal Dutch Shell plc sells fuels, specialty products, and services to commercial customers; offers fuel for approximately 7,000 aircraft every day at 800 airports in 30 countries; offers liquefied petroleum gas and related services to retail, commercial, and industrial customers for cooking, heating, lighting, and transport applications; provides transport, industrial, and heating fuels; and supplies approximately 11,000 tones of itumen products. Royal Dutch Shell plc is headquartered in The Hague, Netherlands and employs roughly 23,000 people worldwide. (Royal Dutch Shell, 2012). Financial Ratio Analysis The following table illustrates Royal Dutch Shell’s financial ratios analysis and will assist in the understanding of the current and (estimated) future status of the organization. The ratios will allow for a general interpretation of the firm’s strength and ability to take on outside projects. The table exemplifies the liquidity, asset management, debt managemen t, profitability, and market value standpoint of the firm.Examining Royal Dutch Shell’s financial ratios presents a positive outlook for the company, in comparison to the industry average Shell is performing exceptionally well. 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. | 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| Ave rage| 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%| 10. 19%| 6. 44%| 6. 50%| Healthy| Basic Earning Power | 16. 12%| 10. 96%| 7. 19%| 18. 00%| 18. 77%| 14. 21%| 6. 80%| Healthy| ROA % (Net)| 9. 26%| 6. 55%| 4. 36%| 9. 50%| 12. 41%| 8. 42%| 10. 15%| Healthy| ROE % (Net)| 19. 47%| 14. 15%| 9. 49%| 20. 86%| 27. 28%| 18. 25%| 14. 24%| Healthy| | | | | | | | | | Market Value Ratios| 12/31/2011| 12/31/2010| 12/31/2009| 12/31/2008| 12/31/2007| Average| Industry| Comments| Price per Earning Ratio| 7. 4%| 10. 14%| 14. 24%| 6. 06%| 8. 32%| 9. 28%| 7. 86| Healthy| Divid end Yield| 4. 60%| 5. 03%| 5. 52%| 5. 89%| 3. 34%| 4. 88%| 4. 76%| Average| Book Value per Share| $ 54. 98 | $ 47. 85 | $ 45. 05 | $ 42. 02 | $ 38. 61 | $ 45. 70| $ 46. 43| Average| Earnings per Share| $ 4. 98 | $ 3. 28 | $ 2. 04 | $ 4. 27 | $ 5. 00 | $ 3. 91| $ 3. 26| Average| Table 1 – Financial Ratio Overview Liquidity 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. | Healthy| Current Ratio| 1. 17| 1. 12| 1. 14| 1. 1| 1. 15| 1. 136| 1. 5| Healthy| Figure 1 –RDS. A Liquidity Ratio Trend The current ratio measures a company's ability to pay short-term debts and other current liabilities by comparing current assets to current liabilities. The ratio illustrates a company's ability to remain solvent. Shell’s five year current ratio average is 1. 13, . 37 below the industry average, and their quick ratio is . 84, . 26 below the industry average. Shells liquidity ratios are both below the industry average and illustrate their healthy status and continued strength for liquidity.Asset Management Ratios 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| | | | | | | | | | Figure 2 –RDS. A Asset Management Ratio Trend Asset Management ratios give an indicator of efficiency (ability to move inventory and generate sales) within a company, particularly ones with tangible goods as compared to its competitors.You can see from figure 2 that in comparison to the industry average Shell is healthy and efficient in their assets and inventory turnover. Figure 2 reflects a spike in Shells inventory turnover in 2008; however this can also be attrib uted to the economic downturn in 2008. Even with the spike Shells average is still on par with the industry and exemplifies a healthy asset management turnover. Debt Management Ratios Debt Management| 12/31/2011| 12/31/2010| 12/31/2009| 12/31/2008| 12/31/2007| Average| Industry| Comments| Debt Ratio| 17. 90%| 22. 80%| 20. 20%| 15. 0%| 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| Times Interest Earned| 41. 54| 36. 49| 39. 78| 33. 38| N/A| 37. 79| 25. 61| Healthy| | | | | | | | | | Figure 3 –RDS. A Debt Management Ratio Trend Royal Dutch Shell’s Debt Management ratios indicate that it has been less aggressive with using debt to finance growth than the majority of its competitors in the Oil & Gas industry.Across the board Shell has a lower debt ratio than their competitors; the resultant effect on earnings would be less volatile than related companies. The debt ratio is a solvency ratio that examines how much of a company's assets are made of liabilities. A debt ratio of 20 percent means that 20 percent of the company is liabilities. A high debt ratio can be negative; this indicates the shareholder equity is low and potential solvency issues. A low debt to equity ratio indicates lower risk, because debt holders have less claims on the company's assets. Overall Royal Dutch Shell is in an excellent Debt Management position.Figure 4 –RDS. A Debt Management Ratio (TIE) Trend Times interest earned or Interest Coverage Ratio is a key metric to determine the credit worthiness of a business. Essentially, the number represents how many times in the last 12 months' EBIT (earnings before interest and taxes) would have covered the past 12 months' interest expenses. Royal Dutch Shell’s times interest earned ratio has a four year average of 37. 79, which is 12. 18 points supe rior than the industry average which rests at 25. 61. This presents Shell in a healthy credit worthiness business. Profitability RatiosProfitability 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%| 10. 19%| 6. 44%| 6. 50%| Healthy| Basic Earning Power Ratio| 16. 12%| 10. 96%| 7. 19%| 18. 00%| 18. 77%| 14. 21%| 6. 80%| Healthy| ROA % (Net)| 9. 26%| 6. 55%| 4. 36%| 9. 50%| 12. 41%| 8. 42%| 10. 15%| Healthy| ROE % (Net)| 19. 47%| 14. 15%| 9. 49%| 20. 86%| 27. 28%| 18. 25%| 14. 24%| Healthy| | | | | | | | | | Figure 5 –RDS. A Profitability Ratio Trend When it comes to profitability, Royal Dutch Shell is on average with its competitors.Net Profit Margin is the net earnings of a company / sales. This profitability ratio compares the percent of net earnings from a company's sales. Royal Dutch Shell’s Net Profit is on par with other companies in the Oil ; Gas industry, w hich means it has an equal ability spend assets on business operations when compared to its competitors. Basic earning power shows the raw earning power of a firm’s assets before taxes and other leverages. This will help the firm understand their return on its assets. Return on Assets or ROA, shows the rate of return (after tax) being earned on all of the firm's assets regardless of financing structure.It is a measure of how efficiently the company is using all stakeholders' assets to earn returns. Royal Dutch Shell has a five year average of 8. 42%, which is 1. 73% lower than the industry average, however still in the healthy zone. Return on equity or ROE is used to measures the rate of return on the money invested by common stock owners and retained by the company from previous profitable years and shows how well a company uses investment funds to generate growth. Royal Dutch Shell’s Return on Equity indicates that it is able to reinvest its earnings more efficiently than the majority of its competitors in the Oil ; Gas industry.Typically, companies that have higher return on equity values are more attractive to investors and can provide for better growth and profitability. Market Value Ratios Market Value Ratios| 12/31/2011| 12/31/2010| 12/31/2009| 12/31/2008| 12/31/2007| Average| Industry| Comments| Price per Earning Ratio| 7. 64%| 10. 14%| 14. 24%| 6. 06%| 8. 32%| 9. 28%| 7. 86%| Healthy| Dividend Yield| 4. 60%| 5. 03%| 5. 52%| 5. 89%| 3. 34%| 4. 88%| 4. 76%| Average| Payout Ratio| 5. 46%| 4. 76%| 8. 41%| 3. 62%| 2. 87%| 5. 02%| 2. 67%| Healthy| Book Value per Share| $ 54. 98 | $ 47. 85 | $ 45. 5 | $ 42. 02 | $ 38. 61 | $ 45. 70| $ 46. 43| Average| Earnings per Share| $ 4. 98 | $ 3. 28 | $ 2. 04 | $ 4. 27 | $ 5. 00 | $ 3. 91| $ 3. 26| Average| Figure 6 –RDS. A Market Value Ratio Trend Earnings per share (EPS) is the amount of income that â€Å"belongs† to each share of common stock. An important tool for investors, EPS is often used in determining the value of a stock. As noted above, Royal Dutch Shell is on average with other firms in its industry. Book value per share has slowly been on a rise over the past 5 years, from $38. 61 in 2007 up to 54. 8 in 2011. Book value is a company's net asset value; a relatively high book value per share in relation to stock price often occurs when a stock is undervalued and might be an attractive buy. Figure 7 –RDS. A Market Value Ratio Trend The price per earnings ratio (PE) is the measure of the share price relative to the annual net income earned by the firm per share. PE ratio shows current investor demand for a company share. A high PE ratio generally indicates increased demand because investors anticipate earnings growth in the future. Royal Dutch Shell has a five year average of 9. 8% PE as compared to the industry average of 7. 86%; Shell is higher by 1. 42%. The dividend yield is the sum of a company's annual dividends per share, divided by the current price per share. When investing in companies an investor should look for a stable and high dividend yield; this can insure an investor a secure a relatively stable cash flow. Royal Dutch Shell's dividend yield is on par with other companies. As indicated by the payout ratio, Royal Dutch Shell’s earnings support the dividend payouts more than others in the same industry group. Cash Flow and Growth AnalysisRoyal Dutch Shell Cash Flow $ Million| 2011| 2010| 2009| 2008| 2007| Cash and Cash Equivalents at January 1| $ 13,444 | $ 9,719 | $ 15,188 | $ 9,656 | $ 9,002 | Net  Cash  from  Operating  Activities| $ 59,393 | $ 42,712 | $ 30,731 | $ 69,787 | $ 53,324 | Net Cash used in Investing Activities| $ (20,443)| $ (21,972)| $ (26,234)| $ (28,915)| $ (14,570)| Net Cash used in Financing Activities| $ (18,131)| $ (1,467)| $ (829)| $ (9,394)| $ (19,393)| Net (Decrease)/increase, Cash & Cash Equivalents| $ (2,152)| $ 3,725 | $ (5,469)| $ 5,532 | $ 654 | Cash & Cash Equivalents a t  December  31| $ 11,292 | $ 13,444 | $ 9,719 | $ 15,188 | $ 9,656 | Figure 8 –RDS. A Cash Flow Trend Information used and interpreted from the Royal Dutch Shell Investors Handbook illustrates that Royal Dutch Shell decreased the amount spent on operations from 2008 to 2009; this can most likely be due to the economic downturn. Conversely, from 2009 to 2011 there has been a steady increase in cash flows for operations.When evaluating charts in figure 9 and 10 you can see that along with a decrease in cash flows from 2008 – 2009 so did Shell have a decrease in revenues, net income and Earnings per share. From 2009 – 2011 all areas show a steady and healthy growth. Growth Analysis| | | | | | Report Date| 12/31/2011| 12/31/2010| 12/31/2009| 12/31/2008| 12/31/2007| Revenue| $ 470,171 | $ 368,056 | $ 278,188 | $ 458,361 | $ 355,782 | Net income for period| $ 31,185 | $ 20,474 | $ 12,718 | $ 26,476 | $ 31,926 | Net earnings per share-diluted| $ 4. 97 | $ 3. 28 | $ 2. 04 | $ 4. 26 | $ 4. 9 | Total assets| $ 345,257 | $ 322,560 | $ 292,181 | $ 282,401 | $ 269,470 | Total stockholders' equity| $ 171,003 | $ 149,780 | $ 138,135 | $ 128,866 | $ 125,968 | Net Cash ; Equivalents Flow| $ 11,300 | $ 13,400 | $ 9,700 | $ 15,200 | $ 9,560 | Figure 9 –RDS. A Growth Analysis Trend Figure 10 –RDS. A Growth Analysis Trend Capital Structure Estimation When performing the Capital Structure Estimation, the assessor can exam how the combination of equity capital and debt capital that a firm uses to finance its assets can have a positive or negative affect on the firm. The capital structure is how a firm finances its overall operations and growth by using different sources of funds. Royal Dutch Shell’s use of debt and ommon stock (Royal Dutch Shell does not issue preferred stock) impacts the open market and, as a result, the firm’s cost of capital is impacted in both constructive and/or destructive ways. RDS. A Market Value Method / Weights| Debt| $ 174,250,000,000. 00 | 27. 71%| Equity| $ 454,619,800,000. 00 | 72. 29%| | | | RDS. A Book Value Method / Weights| Debt| $ 174,250,000,000. 00 | 50. 47%| Equity| $ 171,000,000,000. 00 | 49. 53%| Figure 11 –RDS. A Capital Structure Estimation By examining the Balance Sheet and the numbers in figure 11 you can see that Royal Dutch Shell, based on market value, has a capital structure of 27. 1% debt and 72. 29% equity in the form of common stock totaling a market capitalization of $454 billion. When utilizing the book value, the weighing scale becomes 50. 47% debt and 49. 53% equity with a value of $171 billion. Weighted Average Cost of Capital (WACC) Knowing a firm’s weighted average cost of capital is crucial when considering any new projects. A firm's WACC is the overall required return on the firm as a whole and, as such, it is often used internally by company directors to determine the economic feasibility of expansionary opportunities and mergers. G enerally speaking, a company’s assets are financed by either debt or equity.WACC is the average of the costs of these sources of financing, each of which is weighted by its respective use in the given situation. The weighted average can show how much interest the company has to pay for every dollar it finances. This section of the report will determine Royal Dutch Shell’s weighted average cost of capital. In determining the firm’s factor cost of common equity, the average of three methods will be utilized; Capital Asset Pricing Modem (CAPM), Discounted Cash Flow (DCF), and bond-yield-plus-risk-premium (BYPRP). Calculating the cost of debt (after tax) is figured by using the corporate tax rate and the cost of debt (Kd) which will be based on Royal Dutch Shell’s bond rating. Cost of DebtRoyal Dutch Shell’s after-tax cost of debt is calculated at 2. 30%. The calculation was determined using Shells corporate AA 10 year bond rating market value. RDS. A Cost of Debt| RDS. A 10 year Bond Rating| AA|   | Cost of Debt| 2. 43%|   | Risk Free Rate| 1. 62%|   | After Tax Cost of Debt| 2. 30%| Kd(1-T)| Corporate Tax Rate| 41. 85%|   | Figure 12 –RDS. A Cost of Debt Cost of Equity – CAPM Capital Asset Pricing Model (CAPM) is a model that describes the relationship between risk and expected return and that is used in the pricing of risky securities. The general idea behind CAPM is that investors need to be compensated; this is calculated by the CAPM.The time value of money is represented by the risk-free (rf) rate in the formula and compensates the investors for placing money in investments over a period of time. The other half of the formula represents risk; this is calculated by taking a risk measure (beta) that compares the returns of the asset to the market over a period of time and to the market premium (Rm-rf) or Market risk premium (MRP). Figure 13 illustrates the outcome of the calculations and that Royal Dutch Shell’s CAPM is 10. 01%. RDS. A Cost of Equity CAPM| Formulated by: Rs = Rf + ba * MRP| |   |   | Risk Free Rate (Rf)| 1. 62%| Yahoo Finance U. S. Treasury Bond Rate| Market Risk Premium or (Rm-rf)| 6. 50%| Current Rate November, 2012| Beta (ba)| 1. 29%| E-Trade Financial| CAPM of RDS. A| 10. 01%|   | Cost of Debt (Kd)| 2. 43%|   |After Tax Cost of Debt| 2. 30%|   | Figure 13 –RDS. A Cost of Equity Cost of Equity – DCF The Discounted Cash Flow or DCF method uses future  free  cash flow projections and discounts them to arrive at a present value, which is used to evaluate the potential for investment. Figure 14 illustrates a breakdown of how the discounted cash flow is calculated. The growth rate (g) is the average of three outside estimations. After the calculation is computed, the cost of equity is equal to 11. 83%. RDS. A Cost of Equity DCF| Formulated: Rs = (D1/Po)+g so D1= Do(1+g) so (((Do(1+g)/Po)+g)|   | Rs = (((3. 42(1+6. 42%)/67. 02)+6. 42%)| | Average| E-Trade| Yahoo| Y-Charts| Growth Rate (g)| 6. 42%| 6. 80%| 6. 12%| 6. 35%| Dividend (Do)| 3. 42| Y-Charts| Stock Price (Po)| 67. 02| Current Rate November 2012| Rs = 11. 83%| Figure 14 –RDS. A Cost of Equity Cost of Equity – BYPRP Bond yield plus risk premium method is used to calculate cost of common equity for a firm. Figure 15 shows the calculation, the after tax cost of debt plus bond risk premium rate; which calculates to a cost of equity equal to 8. 80%. RDS. A Cost of Equity BYPRP| | Rs = BY + MRP| | RDS. A After Tax Cost of Debt (BY)| 2. 30%| Shell Investors Handbook| Bond Market Risk Premium (MRP)| 6. 50%| Current Rate November, 2012|   | Rs= 8. 80%|Figure 15 –RDS. A Cost of Equity Weighted Average Cost of Capital – WACC The WACC equation  is the cost of each capital component  multiplied by its proportional weight. To calculate the WACC we first take the average of the CAPM, DCF and BYPRP methods which is calculated in fig ure 16. RDS. A Average Cost of Equity| | CAPM| DCF| BYPRP| Average| Royal Dutch Shell | 10. 01%| 11. 83%| 8. 80%| 10. 21%| Figure 16 –RDS. A Average Cost of Equity Royal Dutch Shell has no preferred stock, thus weight of preferred stock (Wp) is equal to 0%. Figure 17 breaks down the full calculation of the Weighted Average Cost of Capital calculation and the defined values.Using the Weight of Equity and Weight of Debt calculated from the Capital Structure Estimation in figure 11 we can conclude that Royal Dutch Shell’s WACC is equal to 8. 28%. Royal Dutch Shell Plc WACC | WACC formulated: WACC = Ws*Rs + Wd*Rd*(1-Tax Rate) + Wp*Rp. | Ws| 72. 29%| | Weight of Equity (Common Stock)| Wd| 27. 71%| | Weight of Debt| Wp| 0. 00%| | Weight of Preferred Stock| Rd| 2. 30%| | After Tax Cost of Debt| Tax rate| 41. 85%| | Corporate Tax Rate| Rs| 10. 21%| | Cost of Equity (Average)| Rp| 6. 50%| | Market Risk Premium| WACC| 8. 28%| | Weighted Average Cost of Capital| Figure 18  œRDS. A WACC Project Cash Flow Estimation Royal Dutch Shell has been approached with a proposition for a new project. The project will have a life span of eight years.The proposed project requires initial investment of $580 million to construct building and purchase equipment, and $38 million for shipping & installation fee for a total of $618 million is start-up costs. The fixed assets fall in the 7-year MACRS class and has a salvage value of fixed assets at $17 million. It is expected that the new product will sale 2,280,000 units in the first year and has an expected annual growth rate of 8. 5%. The sales price is $275 per unit and the variable cost is $205 per unit in the first year, but they should be adjusted accordingly based on the estimated annualized inflation rate of 2. 3%. The required net operating working capital (NOWC) is 11. 5% of sales.A detailed analysis and calculations for the cash flow estimation and depreciation details must be performed to ensure that Royal Du tch Shell can undertake such a project. Initial Inputs and Parameters for the Proposed Project Start-Up Cost| | $618,000,000 | | | | | | Net Operating WC/Sales| | 11. 5%| | Market value of equipment at Year 8| $17,000,000 | First year sales (in units)| | 2,280,000 | | Tax rate| | | 41. 85%| Sales price per unit| | $275. 00| | WACC| | | 8. 28%| Variable cost per unit| | $205. 00| | Inflation| | | 2. 3%| Non-variable costs| | $0| | Growth in Sales | | | 8. 5%| Figure 19 –RDS. A Project Parameters Depreciation and Amortization Schedule Year| | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total| | | | | | | | | | | | Rate| | 14. 0%| 25. 0%| 17. 0%| 13. 0%| 9. 0%| 9. 0%| 9. 0%| 4. %| 100%| Cost| | $86,520,000 | $154,500,000 | $105,060,000 | $80,340,000 | $55,620,000 | $55,620,000 | $55,620,000 | $24,720,000 | $618,000,000| Total| |   |   |   |   |   |   |   | $0 |   | Figure 20 –RDS. A Depreciation Schedule Figure 20 illustrates the depreciation schedule of eight years, outlined in the project parameters. Project Net Cash Flow Figure 21 –RDS. A Project Estimated Net Cash Flow Capital Budgeting Analysis Capital Budgeting Analysis is a process in which a business determines whether projects or investing in a long-term venture are worth pursuing. Ideally, businesses should pursue all projects and opportunities that enhance shareholder value.However, the amount of capital available at any given time for new projects is limited, capital budgeting analysis will help to determine if a project is feasible or not. Capital budgeting analysis can include net present value (NPV), internal rate of return (IRR), modified internal rate of return, profitability index (PI), payback period and discounted payback. In calculating if this project is possible or not we have determined the following budgeting analysis results in figure 22. RDS. A Budgeting Appraisal Results| Net Present Value (NPV)| $ 284,606,920. 00 | Internal Rate of Return (IRR)| 17. 0%| Modifi ed Internal Rate of Return (MIRR)| 13. 1%| Profitability Index (PI)| 1. 41 | Payback (Years)| 4. 74 | Figure 22 –RDS. A Project Analysis Results RDS. A Payback Calculation | 0| 1| 2| 3| 4| 5| 6| 7| 8|Net Cash Flow| (690,105,000)| 121,087,715 | 158,870,226 | 148,538,663 | 149,691,454 | 152,108,518 | 166,274,191 | 181,997,451 | 362,518,222 | Cumulative CF | (690,105,000)| (569,017,285)| (410,147,060)| (261,608,396)| (111,916,943)| 40,191,576 | 206,465,767 | 388,463,218 | 750,981,440 | Pay Back|   | 1. 00 | 1. 00 | 1. 00 | 1. 00 | 0. 74 | 0. 00 | 0. 00 | 0. 00 | After review of the budgeting analysis results we can conclude that the project should be undertaken. The Profitability Index (PI) is 1. 41, if the PI is greater than 1 than the project should be taken, additionally the net present value is positive, another good sign for accepting the project. The projects Internal Rate of Return (IRR) is 17. 0%, higher than Royal Dutch Shell’s WACC which is 8. 8%, this is an o ptimistic calculation for accepting the project. Finally, payback addresses the projects liquidity, shorter the payback the higher the liquidly and with a current estimation of 4. 74 years, the project is highly recommended. Sensitivity Analysis The Sensitivity Analysis is a modus operandi used to determine how  different values of an independent  variable will impact a particular dependent variable under a given set of assumptions. Within  specific  boundaries, the sensitivity analysis is very useful  when attempting to determine the impact  the actual  outcome of a particular variable will have  if it  differs from what was previously assumed.By creating a  given set of scenarios as, illustrated in figure 23, the analyst can determine how changes in one variable(s) will impact the  target variable. In this particular case the sensitivity analysis will determine how the net present value (NPV) of the proposed project will be affected by the modification of sev eral variables; these variables and the results can be examined in the following figures. The modified variables are sales price, variable costs, units sold, non-variable costs, weighted average cost of capital, corporate tax rate and start-up costs. For the purpose of this analysis the calculations were performed with a 10% and 20% deviation from the base in both a negative and positive trend. RDS. A Project Sensitivity Analysis Calculations Deviation| 1st YEAR UNIT SALES| | % Deviation| WACC| from| Units Sold| NPV| | from|   | NPV| Base Case| | $284,606,920| | Base Case| WACC| $284,606,920 | -20%| 1,824,000| 144,446,239 | | -20%| 6. 6%| 358,280,443 | -10%| 2,052,000| 214,526,580 | | -10%| 7. 5%| 320,454,423 | 0%| 2,280,000| 284,606,920 | | 0%| 8. 3%| 284,606,920 | 10%| 2,508,000| 354,687,261 | | 10%| 9. 1%| 250,612,056 | 20%| 2,736,000| 424,767,602 | | 20%| 9. 9%| 218,353,128 | % Deviation| VARIABLE COST| | % Deviation| SALES PRICE| from| Variable| NPV| | from| Sales| NPV| Base Case| Costs| $284,606,920| | Base Case| Price| $284,606,920| -20%| $164. 00| 723,298,488 | | -20%| $220. 0| (294,245,328)| -10%| 184. 50| 503,952,704 | | -10%| 247. 50| (4,819,204)| 0%| 205. 00| 284,606,920 | | 0%| 275. 00| 284,606,920 | 10%| 225. 50| 65,261,137 | | 10%| 302. 50| 574,033,045 | 20%| 246. 00| (154,084,647)| | 20%| 330. 00| 863,459,169 | % Deviation| NONVARIABLE COST| | % Deviation| TAX RATE| from| Fixed| NPV| | from|   | NPV| Base Case| Costs| $284,606,920| | Base Case| TAX RATE| $284,606,920 | -20%| $0| 284,606,920 | | -20%| 33. 5%| 353,919,217 | -10%| 0| 284,606,920 | | -10%| 37. 7%| 319,304,434 | 0%| 0| 284,606,920 | | 0%| 41. 8%| 284,689,652 | 10%| 0| 284,606,920 | | 10%| 46. 0%| 250,074,869 | 20%| 0| 284,606,920 | | 20%| 50. %| 215,460,087 | % Deviation| START-UP COSTS| from|   | NPV| Base Case| Start-Up Costs  | $284,606,920 | -20%| $ 494,400,000. 00 | 368,892,485 | -10%| $ 556,200,000. 00 | 326,749,703 | 0%| $ 618,000,000. 00 | 284,606,920 | 10%| $ 679,80 0,000. 00 | 242,464,138 | 20%| $ 741,600,000. 00 | 200,321,356 | Figure 23 –RDS. A Project Sensitivity Analysis Calculations Royal Dutch Shell Project Sensitivity Analysis Chart Figure 24 –RDS. A Proposed Project Sensitivity Analysis Chart Deviation| NPV at Different Deviations from Base| from| Sales| Variable|   | Non-variable|   |   |   | Base Case|Price| Cost/Unit| Units Sold| Cost| WACC| Tax Rate| Start-Up Costs| -20%| ($294,245,328)| $723,298,488 | $144,446,239 | $284,606,920 | $358,280,443 | 353,919,217 | 368,892,485 | -10%| (4,819,204)| 503,952,704 | 214,526,580 | 284,606,920 | 320,454,423 | 319,304,434 | 326,749,703 | 0%| 284,606,920 | 284,606,920 | 284,606,920 | 284,606,920 | 284,606,920 | 284,689,652 | 284,606,920 | 10%| 574,033,045 | 65,261,137 | 354,687,261 | 284,606,920 | 250,612,056 | 250,074,869 | 242,464,138 | 20%| 863,459,169 | (154,084,647)| 424,767,602 | 284,606,920 | 218,353,128 | 215,460,087 | 200,321,356 |   | | | | | | |   | Range| $1 ,157,704,497 | $877,383,134 | $280,321,363 | $0 | $139,927,315 | $138,459,130 | $168,571,129 | Figure 25 –RDS. A Proposed Project NPV and Range at Different Deviations from Base Scenario Analysis A scenario analysis is the process of estimating the expected value of a portfolio or project after a given period of time under specific changes in variables of the portfolio's securities or changes in key factors. Commonly, scenario analysis focuses on estimating what a portfolio's value would decrease to  if an unfavorable event would occur.For the proposed project the scenario analysis was conducted assuming a 25% probability for best-case conditions; each of the variables calculated in figure 25 would be 20% better than its base-case value. Conversely, there is a 25% probability of worst-case conditions, with the variables 20% worse than the base; a 50% probability was used for base-case conditions. All figures have been calculated below in figure 26. Scenario| Probability| Sa les Price| Unit Sales| Var Costs| NPV| Squared Deviation times Probability|   | | | | | |   | Best Case| 25%| $330. 00 | 2,736,000 | $164. 00| $1,726,918,338 | 422505172390830000 | Base Case| 50%| $275. 00 | 2,280,000 | $205. 00| $284,606,920 | 10125137435137500 | Worst Case | 25%| $220. 00| 1,824,000| $246. 00| ($588,490,656)| 257759816231319000 |   | | | | | |   | Expected NPV = Sum, Prob. times NPV| | | $426,910,381 |   |   | Standard Deviation | | $830,897,181 |   | | Coefficient of Variation = Std Dev / Expected NPV|   | 1. 95 |   | Figure 26 –RDS. A Proposed Project Scenario Analysis Conclusion In conclusion, after performing a complete analysis on the feasibility of the proposed project, it is determined that it would be beneficial for Royal Dutch Shell, plc to implement the project. The IRR and MIRR are greater than the WACC of 8. 28%, at 17. 0% and 13. 1% respectively. It is currently estimated that the project will pay for itself in approximately 4 . 74 years according to the discounted payback calculations.The Net present value of the project is positive and the profitability index for the project is 1. 41 (greater than 1) it is a positive sign for the project selection. Royal Dutch Shell is currently moving in a positive direction with a healthy financial base. Financial analyses have bestowed Shell with an AA bond rating, which underlines the financial strength of the organization. Based on all the information listed above, it is with my professional opinion after the evaluation within this report that Royal Dutch Shell takes on the project; with the current and estimated futures of Shell it can only add value to the corporation. References E*Trade. 2011, December 31). Royal Dutch Shell Plc RDS. A. Retrieved November 28, 2012, from E*Trade Financials: https://www. etrade. wallst. com/v1/stocks/snapshot/snapshot. asp? YYY220_/UfRI8EalsBAnXarKLCzPko3kjoyjLMbzW9xSdWWCGroVsRTAdKeDJzNAwM5xeMSzfFm9X4tAHc+eI+8pZ9rdHSsGMEaof+37qAzR A17/MKnpCPFTrRrGXhYPAZVsWXkzq5OKgjy67owAqAG5C1fyJ6IzD55l8M8TBKZkWpNM0lH4j7Jb2aXQsoxNw Morningstar, Inc. (2012). Morningstar research. Retrieved November 2012, from http://financials. morningstar. com/ratios/r. html? t=RDSA®ion=GBR& ;amp;culture=en-US Network, Y. -A. (2012). Yahoo! Finance. Retrieved November 28, 2012, from Bond Center: http://finance. yahoo. om/bonds Royal Dutch Shell. (2012). Building an Energy Future: Investors' Handbook. London: Royal Dutch Shell Plc Financials. YCharts Pro Stock Report. (2012). Royal Dutch Shell plc (RDSA). New York: Y Charts. Appendix Royal Dutch Shell Income Statement Billions $ Royal Dutch Shell Balance Sheet Billions $ Royal Dutch Shell Statement of Cash Flow Billions $ ——————————————– [ 1 ]. (YCharts Pro Stock Report, 2012) ] [ 2 ]. [ (YCharts Pro Stock Report, 2012) ] [ 3 ]. [ (YCharts Pro Stock Report, 2012) ] [ 4 ]. [ (YChart s Pro Stock Report, 2012) ] [ 5 ]. [ (YCharts Pro Stock Report, 2012) ] [ 6 ]. [ (YCharts Pro Stock Report, 2012) ] [ 7 ]. [ (YCharts Pro Stock Report, 2012) ] [ 8 ]. [ (Royal Dutch Shell, 2012) ] [ 9 ]. [ (YCharts Pro Stock Report, 2012) ] [ 10 ]. [ (Royal Dutch Shell, 2012) ] [ 11 ]. [ (Royal Dutch Shell, 2012) ] [ 12 ]. [ (Royal Dutch Shell, 2012) ] [ 13 ]. [ (Royal Dutch Shell, 2012) ] [ 14 ]. [ (Royal Dutch Shell, 2012) ] [ 15 ]. [ (Network, 2012) ] [ 16 ]. [ (E*Trade, 2011) ] [ 17 ]. [ (E*Trade, 2011) ]