Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Mw petroleum corporation case solution

29/11/2021 Client: muhammad11 Deadline: 2 Day

Case Notes on MW Petroleum Corporation (A)

Why Should We Care About Real Options?

Ignoring real options in a project often leads to an underestimation of the true project value. Because real options are not explicitly linked to cash flows, they may seem difficult to identify. Here are some typical examples of real options.

· The option to expand an existing investment project.

· Research and development (R&D) is an example of a growth option.

· The option to delay an investment project.

· The option to abandon a project that has already been undertaken.

From the above examples, we find that real options reflect the flexibility inherent in any capital investment process, which is often ignored by the DCF analysis because flexibility is hard to quantify in terms of cash flows. Fortunately, the breakthrough in option pricing theory provides us with the tools to find the value of these real options.

Types of Reserves

MW Petroleum’s estimated reserves can be classified into four major categories:

· proved developed reserves

· proved undeveloped reserves

· probable reserves

· possible reserves

Exhibits 3 through 6 tell us the production and cash flow projections for each of the four types of reserves.

Risk-adjusted Discount Rate (RADR)

For valuation purposes, we need an estimate of MW's WACC to discount cash flows. Unfortunately, the case does not provide many details. This presents a very realistic problem that is often faced when attempting to do analysis in the real world. For example, because MW is a subsidiary of Amoco, its (market) equity value is not available. We do not have a clear idea about the debt and equity mix of MW either. However, we do have the following information:

The average asset (unlevered) beta for Oil companies = 0.64 (footnote b of Exhibit 2).

Given this information, we can use the CAPM to calculate the cost of equity for MW.

· Cost of equity = risk-free rate + beta * market risk premium

For the risk-free rate, we can use the 1990 year-end 30-year US government bond yield given in the MW case in Exhibit 10. We choose the 30-year bond because the time horizon of the cash flows given in the case is 15 years, which is longer than 10 years. Remember, projects in this industry are long-term and, therefore, call for a longer-term Treasury yield to proxy for the risk-free rate.

To determine the market risk premium, we can rely on a report that is maintained by the Stern School of Business at New York University. This report maintains historic annual returns on stock, T-bonds, and T-bills from 1928 – Current. The report also maintains the historic market-risk premium, starting in 1960. To be consistent with our risk-free rate, we want to use the historical market-risk premium for 1990 in the following report:

· http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histretSP.html

Next we assume that Miller Equilibrium holds. This implies:

· The WACC, which is the risk-adjusted discount rate for discounting free cash flows, is the sum of the after-corporate-tax yield on taxable risk-free debt and a risk premium.

· The risk premium is the product of the asset beta (relative to the market portfolio of equity securities) and the market risk premium.

· The market risk premium is measured relative to the after-corporate-tax yield on taxable risk-free debt.

If taxes are zero, the WACC is independent of capital structure. Therefore, WACC = cost of equity.

Identifying the Real Options

Your first task is to identify the real options associated with these reserves. The fundamental characteristic of an option is that the option-holder has the RIGHT but not the obligation to do something (such as buy a stock or invest in a project). Clearly the proved developed reserves of MW are assets-in-place rather than options. One way to verify this is to look at the capital expenditure in Exhibit 3, which is relatively small even in the early years compared with the cash from operations.

On the other hand, for proved but undeveloped reserves, the capital expenditure (shown in Exhibit 4) in the first two years are much larger than the cash from operations, which suggests that the proved undeveloped reserves should be treated as real options. In addition, on the fourth page of this case, the case writer states that “MW could leave these (proved but undeveloped) reserves undeveloped while retaining the RIGHT to develop them later.” This clearly indicates that the proved undeveloped reserves should be valued using the option approach. Therefore, the following discussion will focus on MW’s proved undeveloped reserves and you will extend the analysis to the remaining types of reserves that represent real options.

Valuing the Options

Before we can apply the Black-Scholes model, we need to map project characteristics to parameters for the Black-Scholes model.

A. Exercise Price (X)

In the real options context, the exercise price is equivalent to the expenditures required to acquire the assets. Note that total capital expenditure may include some routine expenditure. These should not be used when calculating X. Only extraordinary expenditure should be included. For proved undeveloped reserves (Exhibit 4), the capital expenditure for the first two years is $17.5 million and $17.7 million, respectively. These are significantly higher than the expenditure for the other years. Hence, the exercise price (X) should be the present value of these two cash flows.

We discount the two cash flows using the risk-free rate (8.24%). The argument here is that the risk associated with the capital expenditure is largely unsystematic (from the CAPM perspective). Note that we use 8.24% to be consistent with the early calculation with regard to the discount rate. Strictly speaking, we should use the one-year and two-year risk-free rates from the yield curve. However, these numbers are not provided by the case.

B. Underlying Asset Value (S)

The underlying asset value is analogous to the role of stock price in the Black-Scholes model. In this case, we can estimate S by discounting the projected net cash flows reported in Exhibit 4. The caveat is that we should exclude the extraordinary capital expenditures already identified with X, but include all other routine capital expenditures. We should use the risk-adjusted discount rate when calculating S.

C. Time to Maturity (T)

Page 4 of the case states that "MW could wait 5-7 years…". Therefore, will need to do a sensitivity analysis, assuming that T ranges from 5 to 7 years.

D. Risk-free Rate (r)

As mentioned above, we have chosen the 30-year government bond yield as the risk-free rate r.

E. Volatility (

image1.wmf
s

)
The volatility of S is clearly linked to the volatility of oil and gas prices in this case. Exhibit 8 shows the annualized volatility in oil and gas prices. The volatilities are very high, ranging from 20% to 60%. In addition, the operating leverage due to fixed costs in the production process tends to amplify the volatility of S. Hence a reasonable assumption is to assume that volatility will range from 30% to 70% (this will be part of the sensitivity analysis).

The final step is to calculate real option values based on the estimates of the five parameters using the Black-Scholes model.

Hint: Instead of using Z-Tables for N(d1) & N(d2), Excel has a function for this, NORMSDIST. Excel is more accurate because it does not round.

Note: A (two-dimensional) sensitivity analysis is needed since both time to maturity (T) and volatility can take multiple values. You will construct a Sensitivity Analysis Table (SAT) that presents an analysis of what is projected to happen to the call option value under the different possible values for time to maturity (T) and volatility. To construct the SAT requires that you use the “What-If Analysis” tool that is located under “Data Tools” on the “Data” tab. You will use the “Data Table” option under “What-If Analysis”. Part of the assignment is learning how to use this tool for sensitivity analysis. Therefore, if you have not used this previously, you will need to research its use.

Required:

1) Read the MW Petroleum Case in order to familiarize yourself with the proposed transaction and the challenges that are faced by Apache with respect to the valuation of MW Petroleum and how that affects the ability to secure financing.

2) You will calculate the real option values for all types of reserves for which you identify real options in the MW Petroleum Case using the Black-Scholes Option Pricing Model (BSOPM) as described above. Adding them together will give you the total option values for MW as a whole. Then, you will compare the DCF value of MW with and without real options (the firm without real options is represented by the Aggregate MW Production and Cash Flow Projection in Exhibit 7). Finally, you will compute the percentage difference between the two. I have put together a MW Petroleum Case Excel spreadsheet template to help guide you.

3) You will draft a brief report on your analysis of the value of MW Petroleum. In your report, you will tie together the opportunities and challenges of the deal with the conclusions of your valuation. How does your valuation affect these opportunities and challenges?

· You will turn in the report as a word document along with the spreadsheet. You will use the following guidelines:

· The report is required to be a minimum of 1 full page and a maximum of 2 full pages EXCLUDING any tables, graphs, or references. If you have any of these, you can use another page(s). You will use Times New Roman (12 pt.) font with ‘multiple’ spacing at 1.15. The ‘before’ and ‘after’ spacing will be set at 0 pt. and margins will be set to ‘normal’.

· If you are unsure about any of these settings, please ask!

ALL work submitted is assumed to be the original work of the student, in the student’s own words, and any material copied from other sources needs to be properly cited and in quotation marks, where appropriate. Please refer to the ‘Academic Integrity Policy’ in the syllabus for further details on plagiarism and penalties for minor and major infractions.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Assignment Solver
Fatimah Syeda
Buy Coursework Help
Math Specialist
Ideas & Innovations
Quick Mentor
Writer Writer Name Offer Chat
Assignment Solver

ONLINE

Assignment Solver

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$28 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$49 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$29 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$22 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$27 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Regatta riverside apartments toowong - Briefly summarize the parable of the sower from mark 4 - Nursing - Fluorine and cesium ionic compound - Ramble rebel collective machine - Who does katniss end up with - 521 If you have not already commented on at least four peer presentations in the discussion board, please do so before Sunday, 11:59 p.m. (Pacific time). - Big joe private peaceful - Legal, Ethical, and Risk Issues in Organizations - Serum1111 - Eth 321 week 5 securities and international regulatory agencies - Mtp kit online legit - What is scholarly research gcu - Biostatics assignment - PP2 - NRS 451-VN-0501 Nursing Leadership - Time signature worksheet and answers - How does a colorimeter measure concentration - Love your sister 5c heart - Cloud computing concepts technology & architecture by thomas erl pdf - Applied Business Analytics_Assessment3 - What 3 digits are in the thousands period - Indian king used rolls royce as dustbin - Eight steps to sound ethical decision making - Max kirsten stop smoking reviews - In the 1830s paris was - Deer hunting map victoria - Crafting and executing strategy in strategic management - Operational Planning - Follow All The Below Points And Also Attached, Need Answers For All The Points Below In APA Format With At Least 500 Words Excluding References, Title And No Plagiarism And Need Plagiarism Report - Decisions by Manager - Behaviour change wheel model - Question - Discussion - The hardy weinberg equation pogil activities for ap biology answers - +91-8890675453 vashikaran specialist IN Kulti - 640 nm to ft lbs - Access control walk through checklist - Cert iv tae rpl - Pelican stores case study answers - Frank and lillian gilbreth developed the principle of - 3 pages nedded - Perin v hayne case - Industrial application of marcet boiler experiment - Operational Planning - Follow all the below, Need in APA format with at least 300 words excluding 3 scholarly peer reviewed references and no plagiarism and need plagiarism report - Paramount clean edge razor - Bugsy malone blousey brown - Commercial invoice template ups - Cisco 857 ios download - Colgate 26 owner's manual - Jetblue airways ipo valuation excel - Words aptly spoken short stories pdf - Len mcauley montana 1948 - The jain worldview holds that a creator - U.S History to 1800s - CMIT 495 WEEK 1 DISCUSSION - The maturity value of a promissory note is - Cultural influences on training and development - Ecology lab answers - Combinations in python - Essential oils are wrung analysis - Kenneth bronson reflection questions - As 3500 part 3 - Art reflection paper - Office 365 dns hosting - Training the receptionist juniper bell read online - Margaret edith quick manning cotton - Jimmy possum leather sofa - Titleist 735 cm pga value - International computer driving license syllabus - Static and dynamic resistance of diode from graph - Cyberbullying and the First Amendment - Literature Review Research Matrix - Construction meeting agenda sample - Wattyl colour chart nz - Clinical robotic surgery association - Student exploration collision theory answer sheet - The lovesong of j alfred prufrock epigraph translation - Describe the strategy for composing persuasive messages - Remember the titans too strong - Retrenching to a narrower diversification base - How to do data interpretation fast - St josephine bakhita mississauga mass times - Carinya classic awning frame - How much is 500 gallons of water - Evidence-Based Project - Soap note template nurse practitioner - Security Architecture and Design - Apple vs samsung case study ppt - Cmit 425 risk assessment paper - 2 pole motor speed 50hz - English 12 - Single phase energy meter diagram - Machine learning - Stephens estate agents hitchin - British gas home appliance insurance - Leadership Applications CRJ-565-MCOL3 - Conflict Managment Dis 2 - Data structures and algorithms in java pdf - Readiness for enhanced hope nursing care plan - Hilux wheel bearing replacement