Scenario Overview
Let’s model Acme Corporation, a 100-person manufacturing company that established an ESOP in 2020 with a $3M loan. We’ll project 10 years to forecast repurchase obligations.Company Profile:
- 100 employees
- Single ESOP loan from 2020
- $500K annual contribution budget
- Current share price: $100/share
Step 1: Define Plan Rules
The legal framework that rarely changes:Step 2: Set Operating Assumptions
The annual business strategy:Step 3: Provide Initial State
Current ESOP status (simplified for example):Step 4: Configure Simulation
Runtime settings:Step 5: Run Simulation
Execute the forecast:Step 6: Analyze Results
Summary Metrics
Year-by-Year Breakdown
Repurchase Obligation Trend
Participant Analysis
Step 7: Create Scenarios
Compare different contribution strategies:Key Insights from Example
Repurchase obligations peak in 2029
Repurchase obligations peak in 2029
This is when early participants (hired 2014-2016) begin retiring with significant vested balances. Plan sponsors should begin accumulating cash reserves now.
Loan payoff reduces future flexibility
Loan payoff reduces future flexibility
Once the 2020 loan is fully paid (2030), no more suspense shares remain for allocation. Future contributions must be cash, not share releases.
Diversification creates cash demand
Diversification creates cash demand
Participants over 55 with 10+ years can diversify starting in 2025. This creates additional cash needs beyond repurchases.
Share price growth drives obligations
Share price growth drives obligations
.png?fit=max&auto=format&n=_b1oFDtC7brS6c3Z&q=85&s=d3ec56559a51e770e67aa19d77e1da67)
.png?fit=max&auto=format&n=AWN49C5ILGJ2VJNX&q=85&s=9e43d95342e1c0ca7d9eadaa6d3acb0d)