natres - Enter the marginal cost per unit of extracting the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
OPTION WORKSHEET: NATURAL RESOURCE OPTIONS VALUING A NATURAL RESOURCE OPTION This spreadsheet calculates the value of a natural resource option. Assumptions 1. All the assumptions underlying the Black-Scholes model apply 2. The estimated reserves of the natural resource are known. The user has to input the following variables 1. Present value of estimated reserves, net of royalties and marginal costs. 2. Variance in the price of the natural resource. 3. Present value of the cost of developing the natural resource. 4. Riskless interest rate that corresponds to relinquishment period. 5. Length of the relinquishment period on resource reserves. 6. Expected annual after-tax cashflow from resource after it is developed. Inputs relating the underlying asset Enter the estimated reserves of the natural resource = 100000 (in units) Enter the current price of the natural resource, per unit = $22.50 (in currency)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Enter the marginal cost per unit of extracting the natural resource = $10.00 (In currency) Enter the standard deviation in the price of the natural resource (ln) = 30.00% (in %) Enter the estimated annual after-tax cashflow after developing resourc $50,000 (in currency) Inputs relating to the option Enter the present value of the cost of developing the resource option = $1,000,000 (in currency) Enter when the rights to resource will be relinquished 10 (in years) General Inputs Enter the riskless rate that corresponds to the option lifetime = 8.00% (in %) VALUING A LONG TERM OPTION/WARRANT Stock Price= $1,250,000 T.Bond rate= 8.00% Strike Price= $1,000,000 Variance= 0.09 Expiration (in years) = 10 Annualized dividend yield= 4.00% d1 = 1.1311926262 N(d1) = 0.8710129876 d2 = 0.1825093281 N(d2) = 0.5724084827 Value of the natural resource option = $472,622...
View Full Document

Ask a homework question - tutors are online