Student Retention ROI Calculator

Files in This Folder

student-retention-calculator-guide.md - Comprehensive user guide with examples and best practices
student-retention-calculator.csv - Calculator spreadsheet (open in Excel or Google Sheets)
README.md - This file

Quick Start

Option 1: Use in Excel (Recommended)

Open student-retention-calculator.csv in Microsoft Excel
The file will open with sample data (1,000 students, R50K tuition)
Edit yellow-highlighted cells (Rows 8-17) with your institution’s data:
- Total enrollment
- Average tuition
- Current retention rate
- Program duration
- Target improvement
- Investment amounts
Review green-highlighted results (Rows 21-39):
- Annual revenue loss from dropouts
- Students saved by improvement
- ROI, payback period, net value
The CSV includes formula references - for full functionality, apply formulas from the guide

Option 2: Use in Google Sheets

Upload student-retention-calculator.csv to Google Drive
Open with Google Sheets
Apply formulas from the guide for automatic calculations
Share with stakeholders for collaboration

Option 3: Request Excel Template

For a fully-formatted Excel template with:

Automatic calculations
Color-coded cells (yellow inputs, green outputs)
Data validation
Charts and visualizations
Scenario comparison tables

Contact: [your-email]@isutech.co.za

What This Calculator Does

Calculates the financial return on investment from improving student retention using analytics and intervention programs.

Key Outputs:

Annual revenue loss from current dropout rate
Revenue gained from retention improvement
ROI percentage and payback period
3-year net value
Scenario comparisons (conservative, moderate, aggressive)

Example Use Cases

Use Case 1: Internal Business Case

Scenario: CFO needs justification for R500K analytics platform investment

Process:

Input current enrollment and retention data
Model 10% retention improvement (moderate)
Show: R4.3M annual benefit vs. R700K investment = 614% ROI
Result: Business case approved

Use Case 2: Board Presentation

Scenario: Board questioning sustainability of operations

Process:

Calculate current annual revenue loss from dropouts: R10M
Show retention improvement potential: Save R5M annually
Present 1.6-month payback period
Result: Board approves strategic investment

Use Case 3: Sales Conversation

Scenario: Private institution prospect considering MGSLG platform

Process:

Pre-fill calculator with prospect’s public data (from annual reports)
Generate custom ROI analysis during presentation
Show institution-specific financial impact
Result: Differentiated from competitors with data-driven value proof

Interpreting Results

ROI Percentage

<100%: Investment not breaking even (check assumptions)
100-300%: Good return, conservative scenario
300-600%: Strong return, moderate scenario
>600%: Exceptional return, aggressive scenario or large institution

Payback Period

<3 months: Exceptional - immediate value
3-6 months: Very good - typical for retention improvements
6-12 months: Good - strategic investment
>12 months: Reassess assumptions or focus on other value drivers

Annual Net Benefit

This is the actual cash value per year after all costs. Use this to:

Justify budget allocation
Compare to other investments
Calculate multi-year value
Support financial planning

Customization Tips

For Small Institutions (<500 students)

Use conservative improvement assumptions (5%)
Consider Tier 1 platform pricing (R250K-R350K)
Focus on percentage ROI, not absolute amounts

For Large Institutions (>2,000 students)

Scale effects amplify benefits
Use moderate to aggressive assumptions (10-15%)
Consider Tier 3-4 platform pricing (R700K-R1M+)
Absolute dollar benefits are substantial

For High-Tuition Programs

MBA, executive education, professional degrees
Retention improvement ROI is exponential
Each saved student = R80K-R200K+ annual value
Justify premium platform investment easily

For Multi-Campus Institutions

Calculate each campus separately
Aggregate for total organizational ROI
Use multi-campus pricing discounts
Show campus-by-campus improvement potential

Integration with Other Materials

Use this calculator alongside:

Private Institution Pitch Deck (../pitch-deck/private-institution-pitch.md)
- Insert calculator results into Slide 10 (ROI Analysis)
- Customize scenarios for specific prospects
Multi-Campus Pricing Document (../pricing/multi-campus-pricing.md)
- Justify pricing tier based on ROI calculation
- Show how platform cost is fraction of retention benefit
Competitive Analysis (../competitive-analysis/competitive-positioning.md)
- Demonstrate superior ROI vs. generic BI tools
- Fast payback vs. custom development timelines

Common Questions

Q: What if I don’t know my exact retention rate? A: Use these SA private institution averages:

Universities: 82%
Business schools: 87%
Technical colleges: 73%
Distance learning: 65%

Q: Is 10% improvement realistic? A: Yes. Institutions using predictive analytics typically see:

Conservative: 5-8% improvement
Moderate: 8-12% improvement
Aggressive: 12-18% improvement (low baseline institutions)

Q: What counts as “intervention program costs”? A:

Tutoring services: R1,500-R3,000 per at-risk student
Academic counseling: R2,000-R4,000 per student
Engagement programs: R500-R1,500 per student
Typical total: 30-50% of platform cost

Q: Can I share this with prospects? A: Yes! Pre-fill with their data (from public sources) and present as “Here’s your potential ROI”

Next Steps

Read the full guide: student-retention-calculator-guide.md
Input your data: Open CSV and customize with your numbers
Generate scenarios: Test conservative, moderate, aggressive assumptions
Build business case: Use results in presentations and proposals
Request support: Contact us for custom analysis or Excel template

Support

For questions, customization requests, or to request the full Excel template:

Email: [your-email]@isutech.co.za Phone: [your-phone] Service: 1-day ROI workshop (R25,000, credited toward license)

Student Retention ROI Calculator | MGSLG Analytics Platform | iSu Technologies | Version 1.0 | January 2025