For most small to mid-sized private companies, a simple script hits the sweet spot of cost and functionality. Q: Can I use this script for mandatory redemptions (e.g., at death or termination)? A: Yes. Just add a trigger column called redemption_reason and adjust the pricing logic accordingly.
However, managing this manually leads to spreadsheet nightmares, human error, and compliance risks. Simple Facility Of Redemption Script
A: The example above uses integer shares. For fractional shares (common after stock splits), convert all values to floats with round(..., 6) . For most small to mid-sized private companies, a
import csv import datetime def get_fair_market_value_per_share(): # In real life, this could be an API call to a valuation model return 12.50 # Example: $12.50 per share Step 2: Redemption calculator def calculate_redemption(shares, fmv, debt, minority_discount=0.00): gross_proceeds = shares * fmv discount_amount = gross_proceeds * minority_discount net_proceeds = gross_proceeds - discount_amount - debt return round(max(net_proceeds, 0), 2) Step 3: Process all redemption requests def process_redemptions(csv_file, output_file): fmv = get_fair_market_value_per_share() results = [] Just add a trigger column called redemption_reason and
with open("board_approval_log.txt", "a") as log: log.write(f"datetime.datetime.now() - name redeemed shares shares for $amount\n") Once your simple facility of redemption script works, consider these upgrades: 1. API Integration with Transfer Agent Connect to services like Carta, Shareworks, or Pulley to automatically update the official cap table. 2. Smart Contract Version (for Tokenized Equity) If your shares are tokenized on a blockchain, write a Solidity version of the script that executes redemptions via a smart contract. 3. Multi-Currency Support For global companies, add exchange rate lookups (using Forex API) to pay in EUR, GBP, or SGD. 4. Email Automation Send each shareholder a personalized redemption statement using SMTP. Part 6: Comparison with Off-the-Shelf Solutions | Feature | Manual Spreadsheet | Simple Redemption Script | Enterprise Software (e.g., Carta) | | --- | --- | --- | --- | | Cost | Free (but high labor) | One-time dev cost | $5k–$50k/year | | Speed | Hours per redemption | Milliseconds | Real-time | | Audit trail | Manual | Auto-generated | Comprehensive | | Complexity | Low | Medium | High | | Best for | 1–5 shareholders | 10–100 shareholders | 100+ shareholders |