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

Long term effects of Coronavirus on business and society - Chemistry lab - Plop plop fizz fizz lab answers - Oxford scale muscle testing - Discussion: Object Oriented Analysis - Rheem lazer boiling water unit manual - How to spot a witch by adam goodheart worksheet - Joe vitale law of attraction certification - Critical thinking moore and parker pdf - Religion - (2) C++ - Quiz Policy, Legal, Ethics, & Cmplc - Art 2 Discussion Question - Decd learnlink staff portal - Question 509 - How do you calculate horizontal analysis - Asian paints financial statements - The Components of Prokaryotic Transcription - New coke case study - Cohesion tension theory of water transport in plants - Characteristics of a sinusoidal ac waveform - Pictures of camp green lake - 9999 lost fork rd manchester ky 40944 - Segments in triangles worksheet - The corporation movie questions - Left for dead beck weathers summary - A disk with an initial angular velocity - Massachusetts general hospital case study - Products to sums formula - Relationship De-Escalation - eBay Evolves Case Study Essay - Unit 8.1 DB: Do I conform? - University of phoenix math 220 final exam - East calder medical practice - Texas scientific ti 30xb multiview - Free fall lab report introduction - Java magazine 2017 pdf - Email assignment - Bran nue dae context - John d varlaro - What does the term unconformity mean - Electric field mapping lab report answers - Ashworth college medical billing and coding final exam - The american fur company case study - 4.3 5 rolling dice codehs - Shanahan construction company has entered - Questions about the food chain - William ricketts sanctuary opening hours - Gcu discussion questions - 99 georgiana terrace gosford - How to draw free body diagram in mechanics - Enzyme experiment with potato - Physics magnetism practice problems - The australian professional teaching standards - Math project - How does thiobacillus denitrificans help bioremediate groundwater - Hands on networking fundamentals 2nd edition answers - Biopsychosocial spiritual assessment paper example - Ap psychology developmental psychology - Special occasion speech examples outline - Ain t ia woman cicely tyson - Organ leader and decision making - Shrm bock model and its components - Barry fitzgerald mcdonald's net worth - ORG 535 Week 2 Apply HR Decisions - R language - This is our story book review - Discussion# 5 - Genetic counselling msc london - Tinetti balance assessment tool - Interview AnalysisJuly 20th is a very hot day in your community. - Pentagon hexagon octagon list - Ucd timetable 2016 17 - Discussion One - Bad frog brewery case brief - Crisis Intervention - Http web6 seattle gov travelers - Energy flow in ecosystem definition - Density of citric acid in g ml - Principles of Microeconomics - Three stooges stuffing a turkey - Parts of gas meter - Marketing simulation game report - HU 2000 - Advantages of steam power plant - Person centred thinking tools relationship circle - Meiosis review worksheet answer key pdf - Australian competitive grants register - Answer these 5 questions on War is Kind - Clipsal 17 pole switchboard - Example of a very poorly implemented database - How does multitasking confuse the resource availability of project team personnel? - Final Paper/Project SOFTWARE ENGINEERING Salon Management System - Lipton chai latte shortage australia - Contingent logic truth table - Week 2 project illness - Nsw teachers parental leave - Contar 1 contamos 2 - Religious site visit essay - Statistics and Data Analysis