Michael S. Patinella, P.L.L.C.

Certified Public Accountants

 

 

PERSONAL OPTION PROFILE REPORT - SAMPLE

I. ESO Portfolio Value for Sally Sample

This section summarizes your current option holdings in BUD and is divided into 3 sections, each of which look at the current value of your stock option portfolio in a slightly different way.  The three valuation methods are: 1) In-the-money value, 2) Cash-out value, and 3) Black-Scholes value and its related time value.

In-The-Money Value

The table below shows the gross value (before tax) you would realize from exercising and selling your options, or the difference between the current “fair market value” (FMV) per share (the current stock price) and your exercise price times the number of options.  This amount is called the “in the money” (ITM) value or “intrinsic” value.  The table shows this value for both vested and unvested options.  You cannot realize the value from your unvested options until they vest.

Current FMV

$51.03

 

Vested

Unvested

Total

Grant ID

Option
Type

Expiration Date

Strike
Price

# of
Options

ITM Value

# of
Options

ITM  Value

# of
Options

ITM

ISO1

ISO

02/15/05

$11.03

14,330

573,200

0

0

14,330

573,200

ISO2

ISO

02/16/06

$12.73

14,750

564,925

0

0

14,750

564,925

ISO3

ISO

01/15/08

$29.18

13,410

293,009

1,590

34,742

15,000

327,750

NQ1

NQSO

01/15/08

$29.18

12,352

269,891

12,352

269,891

24,704

539,782

NQ2

NQSO

03/05/09

$36.43

5,935

86,651

17,805

259,953

23,740

346,604

NQ3

NQSO

06/01/12

$52.15

0

0

17,500

0

17,500

0

Grand Total

 

 

60,777

1,787,676

49,247

564,586

110,024

2,352,261

Cash-Out Value of Vested Options

The table below estimates what you can realize from your vested options at the given FMV.  The “Potential Tax” column is determined from your estimated marginal income tax rate shown in Appendix A.  Your “cash-out” value for each vested grant is determined by subtracting your potential tax burden from your ITM value.  The cash-out value for any vested Incentive Stock Options (ISOs) is computed as if they are sold at the time of exercise.

Current FMV

$51.03

Vested

Grant ID

Option
Type

Expiration Date

Strike
Price

# of
Options

ITM Value

Potential Tax

Cash out Value, Vested

ISO1

ISO

02/15/05

$11.03

14,330

573,200

229,280

343,920

ISO2

ISO

02/16/06

$12.73

14,750

564,925

225,970

338,955

ISO3

ISO

01/15/08

$29.18

13,410

293,009

117,203

175,805

NQ1

NQSO

01/15/08

$29.18

12,352

269,891

107,956

161,935

NQ2

NQSO

03/05/09

$36.43

5,935

86,651

34,660

51,991

NQ3

NQSO

06/01/12

$52.15

0

0

0

0

Grand Total

 

 

60,777

1,787,676

715,070

1,072,605

Black-Scholes / Time Value of All Options

The Black-Scholes value (BSV) is the most widely used formula for determining the price of market traded stock options.  Even though this formula was not designed specifically for employee stock options, Black-Scholes is still a valuable tool for illustrating the value of your ESOs. In order to understand the workings of this formula, let’s look at the key elements of a stock option and their importance in establishing the price or value of the option.

bullet

The expiration date: An option with a long time to expiration is more valuable than one with a short time. This is because there is a longer time for the stock price to increase.

bullet

The strike price: The relationship between the strike price (the price at which you can exercise the option) and the price of the stock is the critical element here. The higher the current stock price is relative to the strike price, the less Time Value (for leverage) remains in the option.

bullet

The volatility of the stock: An option on a stock whose price is highly volatile (fluctuates substantially) will be priced higher than an option with low volatility. This is because there is greater upside potential within a given time frame for a volatile stock.

Even options that are “under-water” will have a Black-Scholes value, because there is a possibility that the stock price will rise above the strike price of the option prior to its expiration.  For options that are “in-the-money”, the Black-Scholes value will usually exceed the ITM value because the upside potential is greater than the downside risk.  The difference between the Black-Scholes value and the ITM value is referred to as the “time value” of the option.  The time value is a measure of the benefit expected, on average, from holding the option until maturity rather than exercising it now.  It has the following characteristics:

bullet

The time value decreases as the expiration date approaches.

bullet

The time value decreases as the in-the-money amount increases.

bullet

The time value is higher for stocks with higher volatility.

Time value is an important metric in determining when to exercise options.  This is because, as the time value decreases, so does the value of holding the option.  In-the-money options with a low time value may be good candidates for diversification.  The table below calculates the Black-Scholes values and time values for your stock options assuming a volatility of: 32.0%

Current FMV

$51.03

 

Vested

Unvested

Total

Grant ID

Option
Type

Expiration Date

Strike
Price

Time value

BSV

Time Value

BSV

Time value

BSV

ISO1

ISO

02/15/05

$11.03

7,327

580,527

0

0

7,327

580,527

ISO2

ISO

02/16/06

$12.73

14,947

579,872

0

0

14,947

579,872

ISO3

ISO

01/15/08

$29.18

76,594

369,603

9,082

43,823

85,676

413,426

NQ1

NQSO

01/15/08

$29.18

70,551

340,443

70,551

340,443

141,103

680,885

NQ2

NQSO

03/05/09

$36.43

60,798

147,449

182,395

442,348

243,194

589,798

NQ3

NQSO

06/01/12

$52.15

0

0

404,725

404,725

404,725

404,725

Grand Total

 

 

230,219

2,017,895

666,754

1,231,339

896,972

3,249,234

II. Investment Risk/Reward for Sally Sample

The day an option is granted, and up until it vests, you may watch changes in its In The Money (ITM) value and Black-Scholes value (BSV) with great interest, but you have no exercise decisions to make.  This all changes, however, when the option vests and it is “in the money”.   Since you can now realize or lose the ITM value, you are truly at risk by this amount.  Thus, it becomes much more important to actively manage your option portfolio when you have vested options that are “in the money”.

The following table shows the ITM value, the BSV, and cash-out values of both your vested and unvested options for hypothetical stock prices that are illustrated in 20% increments above and below the current fair market value (FMV).    The row without an increment shows the current FMV.  The Incremental Change is the percent that each value calculation is above or below the prior level.  This quantifies the risk/reward leverage inherent in your option portfolio.  Note that this risk/reward information is solely related to the options without regard to your overall net worth and the importance that the options hold for meeting your financial goals.  

 

 

Based on Current Portfolio of Vested and Unvested Options

Potential Future Stock Price

Incremental Change

ITM Value

Incremental Change

Black- Scholes Value

Incremental Change

Cash-out value

Incremental Change

$20.90

-20.0%

$261,945

-36.7%

$607,383

-38.3%

$157,167

-36.7%

$26.13

-20.0%

$414,033

-44.2%

$984,768

-35.2%

$248,420

-44.2%

$32.66

-20.0%

$742,095

-47.3%

$1,520,711

-32.7%

$445,257

-47.3%

$40.82

-20.0%

$1,407,591

-40.2%

$2,258,640

-30.5%

$844,555

-40.2%

$51.03

 

$2,352,261

 

$3,249,234

 

$1,411,357

 

$61.24

20.0%

$3,456,006

46.9%

$4,285,228

31.9%

$2,073,604

46.9%

$73.48

20.0%

$4,802,700

39.0%

$5,562,569

29.8%

$2,881,620

39.0%

$88.18

20.0%

$6,420,053

33.7%

$7,126,387

28.1%

$3,852,032

33.7%

$105.82

20.0%

$8,360,876

30.2%

$9,027,006

26.7%

$5,016,526

30.2%

$126.98

20.0%

$10,688,984

27.8%

$11,325,617

25.5%

$6,413,391

27.8%

Depending on the details of your options, a 20% change in your company’s stock price can result in a significantly higher percentage gain or loss in your option portfolio.  This is due to the leverage in the options.  Also worth noting is the fact that, generally speaking, as the FMV of the stock rises further above the strike prices of your various option holdings, the relative percentage change of the option portfolio grows increasingly similar to the percentage change in the stock value.  This trend represents the declining leverage of the option portfolio as the cost of exercising becomes a smaller percentage of the value of the stock.

III. Personal Risk/Reward for Sally Sample

Freedom Fund Analysis

Now that you have a better understanding of the value of your options and the risk/reward inherent in them, our focus turns to the role your options play in achieving your financial goals.  Financial freedom is achieved when you have secured, in a low risk investment portfolio, the amount of money required to meet the needs of you and your family.  We refer to this as your Freedom Fund Goal.  If your Freedom Fund Goal is already secured, then you can afford to take more risk with your options (like holding them until expiration).  On the other hand, if your Freedom Fund Goal is not secured, and particularly if you are approaching retirement, you may want to secure the intrinsic value of your options. 

Based on input you have provided, the following chart shows the status of your Freedom Fund in relation to your company stock and option holdings.  The two horizontal lines are respectively your Freedom Fund Goal and the Value of your Diversified Portfolio (VDP).  For this analysis, your VDP value does not change as a function of your company stock price, although one would expect that there would be some correlation in the real world between your company’s stock price and the value of your diversified portfolio.  The line titled “VDP + Vested Holdings” adds the “cash out” value of your held company shares and vested options to the Value of your Diversified Portfolio.  This line is plotted against various prices of your company stock both above and below the current price, which is denoted by the vertical line.  The line titled “VDP + Vested + Unvested Holdings” plots incremental cash-out value of unvested options and restricted stock at various prices of the company stock.

From this analysis, your Freedom Fund Goal has not yet been met even if all of your options were vested and you were to diversify them at the current fair market value of the stock.

Concentrated Position Analysis

Even if your Freedom Fund Goal has been reached, you may still be at risk if your total portfolio is highly concentrated in company stock and options.  The chart below shows the asset allocation of the Value of your Diversified Portfolio, the cash-out values of your vested and unvested options and restricted stock, and the cash-out value of your BUD stock holdings.   The relationship between your cash-out values and the Value of your Diversified Portfolio represents the degree to which your wealth is concentrated in your company stock.  If you are in a highly concentrated position, declines in your company’s stock price can have a devastating impact on your total wealth. 

Value at Risk Analysis

In an attempt to further identify and convey the risk in your company stock and option position, we have adopted the Value at Risk (VaR) methodology used by many financial institutions to determine their exposure to negative economic events.  VaR is computed using the same volatility used in the Black-Scholes calculations.  Using this methodology, under normal market conditions there is a 5% chance that you could lose $794,316 or more of the total in-the-money value of your company stock and vested options of  $4,214,663 during the next 30 days.  Please pay close attention to the phrasing “under normal conditions” and “or more”.  VaR methodology generally cannot provide an estimate for the size of losses in those scenarios where the VaR threshold is exceeded.  It is possible that you could lose the entire cash-out value of your vested, in-the-money options and stock.

IV. Portfolio Monitoring for Sally Sample

Your options have a number of moving parts that can change rapidly and dramatically affect the value of your holdings.  These variables include: your company’s stock price, your Freedom Fund status, future vesting events, expiration events, and key ratios.  Consequently, it is critically important that we monitor these factors so you can take action on a timely basis.   This section reviews the various factors that we will monitor and discusses the tracking criteria that you can use.

The Stock Price 

The price of your stock is only one of several key factors that need to be monitored on an ongoing basis.  There are a variety of ways that we can watch your stock price.  You can choose a lower limit, an upper limit or a price range.  The key here is to establish a target price or range that is linked to your goals and causes you to take action.

Freedom Fund Percentage 

Your Freedom Fund Percentage is another important value to monitor because it indicates where you currently stand in achieving your overall financial goal.  This percentage is calculated by dividing your Total Cash-Out Value plus the Value of your Diversified Portfolio by your Freedom Fund Goal.  As an example, you may want to set this percentage at greater than or equal to 90% to alert you of the proximity of your goal.  Similarly, if your Freedom Fund Percentage is already at 125%, you may want to set this trigger at 110% so timely action can be taken to secure your Freedom Fund should the company stock price drop.

The ratio of your Total Cash-Out Value plus the Value of your Diversified Portfolio of $3,990,707 to your Freedom Fund Goal of $5,086,131 is currently: 78.46%

Future Vesting 

For planning purposes, it is useful to know when your unvested options or restricted stock will vest giving you the opportunity to exercise and/or sell.  You may want to set a trigger to alert you in advance (e.g. 30 days) of vesting events so you can consider timely action.  The table below shows vesting by month through the end of next year and annually thereafter. 

Current FMV

$51.03

Based on current FMV

Vesting Period

# of
Options

ITM  Value

Potential Tax

Cash out Value, Unvested

2005

17,201

256,338

102,535

153,803

2006

15,611

221,597

88,639

132,958

2007

9,435

86,651

34,660

51,991

2008

3,500

0

0

0

2009

3,500

0

0

0

Expiration Dates

Expiration dates are one of the most critical events to monitor.  As expiration approaches, the leverage of your option declines and your planning alternatives diminish substantially.   If you wait until the last minute and your stock declines before you take action, you may lose the opportunity for substantial wealth accumulation.  It may be wise to consider a phased diversification strategy several years prior to expiration.  The expiration dates for your grants are listed in the first section of this report.

Key Monitoring Ratios:

bullet

Time Value / Value at Risk: This ration shows the Time Value divided by the Value at Risk remaining for each vested grant. As we have seen, the time value of an option decreases over its term, while the value at risk increases if the stock price rises. Therefore, the lower the TV/VaR percentage, the more compelling is the argument for diversifying the option. While the value of this ration could theroretically be infinitely large, it is small values that are of interest. Therefore, a 1000% ceiling has been placed on this ratio.

bullet

Time Value / Black-Scholes Value: This ration shows the Time Value divided by Black-Scholes value for each vested grant. As your options approach expiration, or as the stock price increases (if the option is or becomes in the money) this percentage will decrease. This ration can be used to help you determine when the value of holding the option is low compared to exercising and selling. Like the TV/VaR ration, the lower the TV/BSV percentabe, the more compelling the argument for taking action.

Grant ID

Option
Type

Expiration Date

Strike
Price

Time value

VaR

Time Value / VaR

BSV

Time Value / BSV

ISO1

ISO

02/15/05

$11.03

7,327

105,066

6.97%

580,527

1.26%

ISO2

ISO

02/16/06

$12.73

14,947

108,145

13.82%

579,872

2.58%

ISO3

ISO

01/15/08

$29.18

76,594

98,321

77.90%

369,603

20.72%

NQ1

NQSO

01/15/08

$29.18

70,551

90,564

77.90%

340,443

20.72%

NQ2

NQSO

03/05/09

$36.43

60,798

43,515

139.72%

147,449

41.23%

NQ3

NQSO

06/01/12

$52.15

0

0

0.00%

0

0.00%

Grand Total

 

 

230,219

445,611

 

2,017,895

 

Key Ratio Considerations

Your planning horizon and risk profile need to be taken into consideration when reviewing your key monitoring ratios.  Upcoming cash flow needs are a good indicator of ones planning horizon and risk profile.  The more time you have before you need to fund major expenses such as retirement or college, the longer you can wait prior to taking action on your stock options.  The table below shows some general rules of thumb for how to interpret your key rations. 

Planning Horizon / Risk Profile

TV/ VaR Ratio

TV / BSV Ratio

Short / Conservative

Less than150%

Less than 50%

Medium / Moderate

Less than 100%

Less than 30%

Long / Aggressive

Less than 50%

Less than 10%

Next Steps for Sally Sample

Your Personal Option Profile has hopefully helped you to better understand the value and dynamics of your employee stock option portfolio.  Your next steps will involve a series of decisions regarding exercising your vested options and diversifying your held shares.  These decisions involve judgments on the risk and reward characteristics of options and the importance of your option wealth to your overall financial goals.  For your options that are currently in the money and vested, every day that you do not exercise represents an implicit decision on your part.  Some reasons to exercise prior to expiration include:

bullet

Locking in profit by exercising, selling and investing the proceeds in a vehicle that guarantees return of principal, such as CD’s.

bullet

Improving your risk/return profile by exercising, selling and investing the proceeds in a diversified portfolio of stocks. It is important to remember that your salary and career are already tied to your company, so a highly concentrated position in your company stock and options is risky.

bullet

Capturing the total return of your company’s stock by exercising just before a dividend payment date and keeping the stock.  All else being equal, the price of a stock drops by close to the dividend amount each time a dividend is paid, so it can make sense to exercise early if your company’s stock has a high dividend yield.

bullet

Starting the clock ticking on owning the stock so that you can be taxed upon sale at the long-term capital gains rate rather than the ordinary income rate.

bullet

Changing your employment status.  If you think you may lose your job soon, you may well want to place less value on the Time Value of your in-the-money vested options and the Black-Scholes Value of your unvested options.  If you are contemplating leaving voluntarily you should consider the TV of your vested options and the BSV of your unvested options that you would be giving up by doing so.

I would be pleased to assist you to understand and analyze the many complex issues involved in making informed decisions regarding your employee stock options.  To get us started I would like to propose the following plan of action:

  1. Development of an “Option Policy Statement”.  This statement will document a variety of decisions regarding your employee stock option portfolio and will serve to identify your goals and the criteria by which we will monitor your stock options. 

  2. Working together to monitor your option portfolio using the criteria established in your “Option Policy Statement”.

  3. Evaluation of alternative exercise and sell scenarios to aid you in establishing an option diversification strategy.

  4. When you decide to take action, we will perform detailed analysis of exercise and/or sales alternatives to assist you in selecting the approach that best meets your cash flow objectives.

  5. We will meet or talk periodically to review and update your “Option Policy Statement” and diversification strategy to reflect changing circumstances.

Disclosures

Your Personal Option Profile is based on input you have provided.  This analysis has been created from your assumptions (Appendix A) and grant data (Appendix B).  You are responsible for the accuracy of this report and you should not base your decisions solely on this analysis.

This report is for illustration purposes only.  Nothing contained in your Personal Option Profile should be construed as investment recommendations or advice.  The financial calculations provided herein are to help you understand the value, risk and potential of your stock option portfolio. 

Past performance of your stock is no guarantee of future results.  The values and risks illustrated in your Personal Option Profile in no way represents a guarantee that the portfolio will produce a particular result.

The Black-Scholes values (BSV) and the time values were calculated using an estimated volatility for BUD to illustrate its potential value.  There is no guarantee that this valuation methodology accurately illustrates the value of your employee stock options.  Any estimate of the future volatility of a stock price is quite uncertain.  In addition, there are some inherent limitations when using BSV to calculate the value of employee stock options.  Specifically, BSV makes the following assumptions, which may not be appropriate for employee stock options and may indicate a need to adjust the calculated BSV:

  1. The options are marketable (employee stock options are typically non-transferable and never marketable).

  2. The options are “European” which is to say they are only exercisable on the date of expiration.  Employee stock options are typically “American” style (exercisable any time up to and including the day of expiration, which actually increases the value somewhat). 

  3. Most employee stock options are subject to vesting schedules, limiting the option holder’s control of the option.  Hence, the value of an unvested option may need to be discounted due to the employee losing the ITMV of the option, if any, if the employee leaves the company before the option vests.

Because of these limitations, the BSV may overstate the actual value of the employee stock option.  To adjust for this over-valuation, it may be appropriate to consider discounting the BSV to reflect the restrictions inherent to employee stock options.

Appendix A:  Summary of Assumptions

Client Information

 

 

Rate Estimates

 

 

Company stock holdings

 

Client Name

Sally Sample

 

Total Fed. / State income tax rate

40.0%

 

Number of owned shares

47,560

"Financial Freedom" number

$5,086,131

 

Total Fed. / State cap gains rate

20.0%

 

Cost basis of owned shares

$560,813

Current value of diversified portfolio

$864,350

 

'Risk-free' rate of return

3.50%

 

Number of restricted shares

 

 

 

 

 

 

 

Cum purch. price of restricted shares

 

Alert me if, when the report is run, the …

 

Lower limit

Upper limit

Enabled?

 

 

 

Company stock price is

between

$45.00

$60.00

TRUE

 

Issuing corporation

 

Percent of Freedom Fund already secured is

>=

90.00

 

TRUE

 

Ticker symbol

BUD

Time Value / Black-Scholes ratio is

<=

 

25.00

TRUE

 

Current price

$51.03

Time Value / Value at Risk ratio is

<=

 

100.00

TRUE

 

Per share dividend

$0.00

Any options will vest

in the next

90

days

TRUE

 

Estimated Volatility

32.00%

Any grant will expire

in the next

180

days

TRUE

 

 

 

Appendix B:  Grant Summary

Grant ID

Type

Date of Grant

Strike Price

Expiration Date

Number of options

Vesting date

Number of options

ISO1

ISO

02/15/95

$11.03

02/15/05

14,330

N/A

N/A

ISO2

ISO

02/16/96

$12.73

02/16/06

14,750

N/A

N/A

ISO3

ISO

01/15/98

$29.18

01/15/08

13,410

N/A

N/A

ISO3

ISO

01/15/98

$29.18

01/15/08

0

01/15/05

1590

NQ1

NQSO

01/15/98

$29.18

01/15/08

12,352

N/A

N/A

NQ1

NQSO

01/15/98

$29.18

01/15/08

0

01/15/05

6176

NQ1

NQSO

01/15/98

$29.18

01/15/08

0

01/15/06

6176

NQ2

NQSO

03/05/99

$36.43

03/05/09

5,935

N/A

N/A

NQ2

NQSO

03/05/99

$36.43

03/05/09

0

03/05/05

5935

NQ2

NQSO

03/05/99

$36.43

03/05/09

0

03/05/06

5935

NQ2

NQSO

03/05/99

$36.43

03/05/09

0

03/05/07

5935

NQ3

NQSO

06/01/02

$52.15

06/01/12

 

N/A

N/A

NQ3

NQSO

06/01/02

$52.15

06/01/12

0

06/01/05

3500

NQ3

NQSO

06/01/02

$52.15

06/01/12

0

06/01/06

3500

NQ3

NQSO

06/01/02

$52.15

06/01/12

0

06/01/07

3500

NQ3

NQSO

06/01/02

$52.15

06/01/12

0

06/01/08

3500

NQ3

NQSO

06/01/02

$52.15

06/01/12

0

06/01/09

3500

Contact Information

Electronic mail
 
  Mike Patinella, CPA

mike at patinella dot com

(substitute"@" for "at" and "." for "dot" and remove spaces)

 

The e-mail address is presented in this fashion to help prevent phishing.
Office

Michael S. Patinella, P.L.L.C.

7025 N. Scottsdale Road

Suite 115

Scottsdale,AZ 85253

Phone: (480) 663-6012

Fax: (480) 361-6204

Located one block northof Indian Bend Road on the East side of Scottsdale Road.

view map

 

This website was created by nFLEXion Consulting Services, LLC USA
Copyright © 2001-2010 Michael S. Patinella, P.L.L.C.
Last modified: November 19, 2010