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

05/11/2020 Client: arwaabdullah Deadline: 7 Days

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.

_1152592064.unknown

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:

Quality Homework Helper
Instant Assignments
Buy Coursework Help
Essay Writing Help
Online Assignment Help
Finance Homework Help
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Hey, I can write about your given topic according to the provided requirements. I have a few more questions to ask as if there is any specific instructions or deadline issue. I have already completed more than 250 academic papers, articles, and technical articles. I can provide you samples. I believe my capabilities would be perfect for your project. I can finish this job within the necessary interval. I have four years of experience in this field. If you want to give me the project I had be very happy to discuss this further and get started for you as soon as possible.

$55 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

Hi dear, I am ready to do your homework in a reasonable price.

$55 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 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

Risk Modeling - Barry chi and holly chen net worth - 3sin 2x cos 2x 0 - What is bavarian sausage inc s operating cash flow - Six Sigma Green Belt Project and Exams - Spelling bee year 5 - Assignment 1 cryptography - Business model and competitive strategy of ikea in india pdf - Need 600+ words with no plagiarism and 2+ scholarly references in APA 7 format - Research paper - Biopsychology - What are text connectives - What is the difference between amylose and amylopectin - Madison park signature belmont 8 piece charmeuse comforter set - 60101 chemistry and materials science - Part time fee grant - Peterborough regional college jobs - Primary Source Board - 8500: Discussion 1-2 - Government INtervention Analysis - Clearances seamus heaney analysis - Of mice and men past questions - Dq response. - Persuasive techniques in advertising worksheet - How to write electronic configuration of chromium - Ethics of the milgram experiment - Ma rainey trust no man - Chichester university campus map - Cat it14g loader specs - Accuracy and precision ppt - Why do many theorists doubt that genres exist at all - Final project - Lightweight ICO Whitepaper / Practical Connection Assignment - Both sarekat islam and the thakins began their protests against colonialism over issues of - Issa learning experience answers - 5 - la rutina de silvia fill in the blanks with the appropriate choices from the cues. - Veltri corporation is working on its direct - Air enters a cm diameter pipe - The crucible gcse revision - A data set will always have exactly one mode - Inanimate environment service marketing - America's most overrated product the bachelor's degree summary - Justification defenses crj101 - Team managment dis 5 - How to design a website using notepad - Assassin's creed origins the tax master underground entrance - Analysing the Accounting Information - Csec english sba reflection sample - Rewards of factors of production - Bed bath and beyond target market - Routh hurwitz criterion example - A lifestyle bloggers guide - Business law questions and answers book pdf - Health communications - Family nursing research theory and practice friedman pdf - Fama french three factor model excel - Breaking night liz murray sparknotes - What questions do historians ask - Advantages and disadvantages of internal fertilization - Egg drop project with straws and tape only - Infotech in a global summary - Psychology nature vs nurture assignment - Week 3 Discussion - Managing change is an integral part of - American Nurse Association Code of Ethics - The _____ of 2002 incorporates the "comply or else" approach to corporate governance. - Subject and predicate rap song - Difference between sensory memory and sensory register - Formula of manganese iv oxide - For my mind misgives - Tjx leave of absence - Why is alliteration used in persuasive writing - Soler theory health and social care - Similarities and differences of motivating operations and discriminative stimuli - Curtin oasis log in - A rain gutter is formed by bending up the sides - Life cycle of stars ppt - Apprenticeshipsinfo qld gov au - Identifying Relationships Between Variables - Think critically facione 2016 pdf - Dso and dpo formula - How to calculate semester average - Main bearing failure analysis - Audition scripts for teens - Validity of secondary sources - Microbiology essay questions and answers - Difference between validation and verification in simulation - Uncle doug output transformer - The one indispensable element of a crime is the - Australian steel section properties - En 46111 crankshaft rotation socket - Dr tan knee pain - Sime darby industrial academy - Ib biology syllabus outline - How to critique an article psychology - Mr jason harvey spinal surgeon - Square root of 36 simplified - Psa professional practice standards - How to get invoice from taobao - Which one of the following statements concerning the balance sheet is correct? - Biology lab 5 report