# Real Options Valuation Worksheet

## Overview
Real Options Valuation applies financial options theory to real investments, recognizing that management flexibility and the ability to adapt decisions based on new information creates value. This worksheet helps identify, structure, and value real options in strategic investments.

## Investment Overview

### Project Description
**Project Name:** _________________________
**Investment Type:** _________________________
**Total Investment Required:** $_____________
**Investment Timeline:** _________________________

**Strategic Objectives:**
1. _________________________________________________________________
2. _________________________________________________________________
3. _________________________________________________________________

### Traditional NPV Analysis
**Base Case Assumptions:**
- Initial investment: $_____________
- Annual cash flows: $_____________
- Project life: _____ years
- Discount rate: _____%
- Terminal value: $_____________

**Traditional NPV:** $_____________
**Traditional Decision:** Accept/Reject

## Real Options Identification

### Types of Real Options Present
Check all that apply and describe:

**Option to Defer (Timing Option)**
- [ ] Can delay investment decision
- Deferral period: _____ months/years
- Value of waiting: _________________________
- Information gained by waiting: _________________________

**Option to Expand**
- [ ] Can increase scale if successful
- Expansion cost: $_____________
- Expansion potential: ____×  current scale
- Expansion trigger: _________________________

**Option to Contract/Scale Down**
- [ ] Can reduce scale if needed
- Contraction savings: $_____________
- Minimum viable scale: _________________________
- Contraction trigger: _________________________

**Option to Abandon/Exit**
- [ ] Can exit and recover value
- Salvage value: $_____________
- Exit costs: $_____________
- Exit triggers: _________________________

**Option to Switch**
- [ ] Can change inputs/outputs/processes
- Switching cost: $_____________
- Alternative uses: _________________________
- Flexibility value: _________________________

**Growth Options**
- [ ] Creates future opportunities
- Follow-on investments: _________________________
- Platform value: _________________________
- Strategic positioning: _________________________

**Compound Options**
- [ ] Options on options
- Stages: _________________________
- Dependencies: _________________________

## Option Valuation Parameters

### Key Variables
**For Each Identified Option:**

**Option 1: _________________**
- Current value of underlying asset (S): $_____________
- Exercise price (X): $_____________
- Time to expiration (T): _____ years
- Risk-free rate (r): _____%
- Volatility (σ): _____%

**Option 2: _________________**
- Current value of underlying asset (S): $_____________
- Exercise price (X): $_____________
- Time to expiration (T): _____ years
- Risk-free rate (r): _____%
- Volatility (σ): _____%

### Uncertainty Analysis
**Sources of Uncertainty:**
| Uncertainty Source | Impact on Value | Volatility Estimate | Data Source |
|-------------------|-----------------|-------------------|-------------|
| Market demand | High/Med/Low | % | |
| Technology | High/Med/Low | % | |
| Competition | High/Med/Low | % | |
| Regulation | High/Med/Low | % | |
| Input costs | High/Med/Low | % | |

**Combined Volatility Calculation:**
Method used: _________________________
Overall project volatility: _____%

## Option Valuation Methods

### Black-Scholes Model
**For European-style options:**

Option Value = S×N(d₁) - X×e^(-rT)×N(d₂)

Where:
- d₁ = [ln(S/X) + (r + σ²/2)T] / (σ√T)
- d₂ = d₁ - σ√T

**Calculations:**
| Option | S | X | T | r | σ | d₁ | d₂ | N(d₁) | N(d₂) | Value |
|--------|---|---|---|---|---|----|----|-------|-------|-------|
| | $ | $ | | % | % | | | | | $ |
| | $ | $ | | % | % | | | | | $ |

### Binomial Model
**For American-style options or complex options:**

**Model Parameters:**
- Number of periods: _____
- Up movement (u): _____
- Down movement (d): _____
- Risk-neutral probability (p): _____

**Decision Tree:** 
[Create a visual representation of the binomial tree]

Period 0 → Period 1 → Period 2 → ... → Period N
Value: $____ 

### Monte Carlo Simulation
**For complex, path-dependent options:**

**Simulation Parameters:**
- Number of simulations: _____
- Time steps: _____
- Random variables: _________________________

**Results:**
- Mean option value: $_____________
- Standard deviation: $_____________
- 95% confidence interval: $_______ to $_______

## Strategic Option Analysis

### Decision Tree Mapping
**Key Decision Points:**
| Decision Point | Timing | Options Available | Information Available | Value Impact |
|----------------|--------|-------------------|---------------------|--------------|
| | | | | $ |
| | | | | $ |
| | | | | $ |

### Option Interdependencies
**How Options Interact:**
- Option A enables Option B: _________________________
- Option C excludes Option D: _________________________
- Compound effects: _________________________

### Competitive Considerations
**First-Mover Advantages:**
- Market preemption value: $_____________
- Learning curve benefits: $_____________
- Brand establishment: $_____________

**Competitive Response Options:**
- If competitor enters: _________________________
- If technology shifts: _________________________
- If regulation changes: _________________________

## Expanded NPV Calculation

### Static NPV vs. Expanded NPV
**Traditional Static NPV:** $_____________

**Real Option Values:**
- Deferral option: $_____________
- Expansion option: $_____________
- Abandonment option: $_____________
- Switching option: $_____________
- Other options: $_____________
- **Total Option Value:** $_____________

**Expanded NPV = Static NPV + Total Option Value**
**Expanded NPV:** $_____________

### Investment Decision
**Based on Expanded NPV:**
- [ ] Proceed immediately
- [ ] Defer investment
- [ ] Invest in stages
- [ ] Modify project scope
- [ ] Reject project

## Implementation Strategy

### Optimal Exercise Strategy
**For Each Option:**
| Option | Exercise Trigger | Monitoring Metric | Review Frequency | Responsible Party |
|--------|-----------------|-------------------|------------------|------------------|
| | | | | |
| | | | | |
| | | | | |

### Stage-Gate Approach
**Investment Stages:**
| Stage | Investment | Gate Criteria | Options Created | Options Exercised |
|-------|------------|---------------|-----------------|-------------------|
| 1 | $ | | | |
| 2 | $ | | | |
| 3 | $ | | | |

### Flexibility Preservation
**Actions to Maintain Options:**
1. _________________________________________________________________
2. _________________________________________________________________
3. _________________________________________________________________

**Actions That Destroy Options:**
1. _________________________________________________________________
2. _________________________________________________________________

## Risk Management

### Option Greeks Analysis
**Sensitivities:**
| Option | Delta (∂V/∂S) | Gamma (∂²V/∂S²) | Theta (∂V/∂t) | Vega (∂V/∂σ) | Rho (∂V/∂r) |
|--------|---------------|------------------|----------------|---------------|--------------|
| | | | | | |
| | | | | | |

### Scenario Analysis
**Best Case Scenario:**
- Assumptions: _________________________
- Option values: $_____________
- Optimal strategy: _________________________

**Base Case Scenario:**
- Assumptions: _________________________
- Option values: $_____________
- Optimal strategy: _________________________

**Worst Case Scenario:**
- Assumptions: _________________________
- Option values: $_____________
- Optimal strategy: _________________________

## Monitoring and Control

### Key Indicators to Track
| Indicator | Current Value | Threshold | Action if Exceeded |
|-----------|---------------|-----------|-------------------|
| Market size | | | |
| Competition | | | |
| Technology | | | |
| Costs | | | |

### Review Process
**Regular Reviews:**
- Frequency: Monthly/Quarterly
- Participants: _________________________
- Decision authority: _________________________

**Option Revaluation Triggers:**
- [ ] Market shift > ____%
- [ ] Technology breakthrough
- [ ] Regulatory change
- [ ] Competitive action
- [ ] Cost change > ____%

## Communication Framework

### Stakeholder Communication
**Explaining Real Options Value:**
- Board/Investors: Focus on value creation and risk management
- Management: Focus on decision flexibility
- Project teams: Focus on milestone management

### Reporting Format
**Real Options Dashboard:**
- Current option values
- Exercise recommendations
- Key metrics tracking
- Scenario probabilities

## Example Application

**Project:** New Technology Platform Development
**Traditional NPV:** -$5M (would reject)

**Real Options Identified:**
1. Expansion option if market grows (value: $8M)
2. Abandonment option after Phase 1 (value: $3M)
3. Switching option to alternative technology (value: $2M)

**Expanded NPV:** -$5M + $13M = $8M (accept with staged approach)

**Strategy:** 
- Invest $10M in Phase 1
- Preserve expansion and switching options
- Decision point at 18 months based on market response

---
*Date Completed:* _____________
*Analyst:* _____________
*Next Review:* _____________