Open calculator ↗

Stock collar exchange ratio at closing · Calculation guide

Model a fixed-value collar. Inside the band the exchange ratio floats.

Calculation guide

Outside, fix the ratio at the nearest boundary; actual consideration then varies with price.

Closing exchange ratio = Target value per share / min(Buyer price ceiling,max(Buyer price floor,Closing buyer price)). Value delivered per target share = Closing buyer price × Closing exchange ratio

Inputs

Target value per share

Example entry 50 (in the selected currency).

Closing buyer price

Example entry 40 (in the selected currency).

Buyer price floor

Example entry 35 (in the selected currency).

Buyer price ceiling

Example entry 45 (in the selected currency).

Worked example

InputValue
Target value per share50
Closing buyer price40
Buyer price floor35
Buyer price ceiling45
ResultValue
Closing exchange ratio1.25
Value delivered per target share50

Calculation steps

Closing exchange ratio = (Target value per share ÷ min(Buyer price ceiling, max(Buyer price floor, Closing buyer price)))

(50 ÷ min(45, max(35, 40))) = 1.25

Value delivered per target share = (Closing buyer price × Closing exchange ratio)

(40 × 1.25) = 50

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Target value per share5055Closing exchange ratio1.251.375
Closing buyer price4044Closing exchange ratio1.251.136364
Stock collar exchange ratio at closing →

Sources