Employee stock purchase discount versus cash · Calculation guide

Calculate advantage over keeping cash.

Calculation guide

The discount applies to the entered plan reference price. Assume fractional shares, immediate sale at the entered market price and no fees or tax.

adv = cash*market/(reference*(1-discount/100))-cash; purchase = reference*(1-discount/100); shares = cash/purchase

Inputs

Cash available

Example entry 9000 (in the selected currency).

Plan reference price per share

Example entry 100 (in the selected currency). Minimum 0.0001.

Purchase discount

Example entry 10 %. Allowed range 0.0 to 99.99.

Sale price per share

Example entry 105 (in the selected currency).

Worked example

InputValue
Cash available9,000
Plan reference price per share100
Purchase discount10%
Sale price per share105
ResultValue
Advantage over keeping cash1,500
Discounted purchase price90
Shares purchased100

Calculation steps

Advantage over keeping cash = (((Cash available × Sale price per share) ÷ (Plan reference price per share × (1 − (Purchase discount ÷ 100)))) − Cash available)

(((9,000 × 105) ÷ (100 × (1 − (10 ÷ 100)))) − 9,000) = 1,500

Discounted purchase price = (Plan reference price per share × (1 − (Purchase discount ÷ 100)))

(100 × (1 − (10 ÷ 100))) = 90

Shares purchased = (Cash available ÷ Discounted purchase price)

(9,000 ÷ 90) = 100

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Cash available9,0009,900Advantage over keeping cash1,5001,650
Plan reference price per share100110Advantage over keeping cash1,500545.454545
Purchase discount10%11%Advantage over keeping cash1,5001,617.977528
Sale price per share105116Advantage over keeping cash1,5002,600
Employee stock purchase discount versus cash →