Create payoff table using emv to maximize profit

Assignment Help Financial Management

Reference no: EM131994072

A local energy provider offers a landowner $180,000 for the exploration rights to natural gas on a certain site and the option for future development. This option, if exercised, is worth an additional $1,800,000 to the landowner, but this will occur only if natural gas is discovered during the exploration phase. The landowner, believing that the energy company’s interest in the site is a good indication that gas is present, is tempted to develop the field herself. To do so, she must contract with local experts in natural gas exploration and development. The initial cost for such a contract is $300,000, which is lost forever if no gas is found on the site. If gas is discovered, however, the landowner expects to earn a net profit of $6,000,000. The landowner estimates the probability of finding gas on this site to be 60%. (Show your work via excel)

1. Instead of a precision tree, create a payoff table using EMV to maximize profit.

2. Perform a sensitivity analysis on the optimal decision, letting each of the inputs vary one at a time plus or minus 25% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?

Reference no: EM131994072

Questions Cloud

Calculate the price of american put option : calculate the price of an American put option that expires in three years and has an exercise price of TL45.

According to the international fisher effect : The spot rate for the British pound is $1.55. According to the international Fisher effect (IFE), what is new level of the British pound?

Tax operating income to determine economic value added : In the EVA equation, the _____ is subtracted from the after-tax operating income to determine the economic value added.?

Which set of cash flows is worth more now : Which set of Cash Flows is worth more now? Compute the Present Value of each of these options if you expect interest rate to be 2% annually for next 10 year.

Create payoff table using emv to maximize profit : Instead of a precision tree, create a payoff table using EMV to maximize profit.

A debt is said to be selling at par when : Revenue bonds are used to. A debt is said to be selling at par when.

Investor would be most likely to purchase zero coupon bonds : Which of the following types of investor would be most likely to purchase zero coupon bonds??

Weighted-average number of shares outstanding : Compute the weighted-average number of shares outstanding if the 48,900 shares were issued for cash.

Current financial status during financial planning process : A financial planner analyzes and evaluates a client’s current financial status during the financial planning process

User Account

All Pages