Type the Excel formula for the profit per share of a covered call — shares bought at 48, the 50 call written for 3.20 — with the expiry share price in B1.
Type the Excel formula for the profit per share of a covered call — shares bought at 48, the 50 call written for 3.20 — with the expiry share price in B1.
Answer
=(MIN(B1,50)-48)+3.20
B1 = 58 → 5.20 (capped); B1 = 42 → −2.80. MIN caps the share at the strike because above it the shares are called away.
Authored fresh — no source on disk works a combination; CDCC clears fixed-income repos and customised OTC equity options; CDOR ceased 28 June 2024, the live floating index is CORRA (verified-facts §2.9 J14, CONFIRMED 2026-09-17); original company and figures