I need help completing this spreadsheet. I have attached the t.docx

This preview shows page 2 - 5 out of 14 pages.

I need help completing this spreadsheet. I have attached thetemplate, case, and notes on the case study. Formulas must beused in the spreadsheet. I also need an analysis of the spreadsheet.mw__petroleum_notes.docCase 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 ReservesMW Petroleum’s estimated reserves can be classified into four major categories:· proved developed reserves
· proved undeveloped reserves· probable reserves· possible reservesExhibits 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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture