Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
262x Filetype XLSX File size 0.07 MB Source: www.kdplatform.com
Sheet 1: eLearning ROI
| eLearning ROI Calculator - Investment Worksheet | ||||||
| Use this interactive spreadsheet to calculate your association's return on investment (ROI) for online member education. Use the 'Investment' sheet to track expenses and the 'Revenue' sheet to record earnings. Your Profit/Loss and ROI calculations will be performed as a function of these sheets. | ||||||
| Profit/Loss and ROI | ROI (Actual and Projected) | |||||
| Estimated | Actual | |||||
| Total income | $299,550.00 | $350,680.00 | ||||
| Total expenses | $40,200.00 | $46,375.00 | ||||
| Total profit (or loss) | ||||||
| $259,350.00 | $304,305.00 | |||||
| Return on Investment (ROI) | ||||||
| 545.15% | 556.18% | |||||
| Projected Profit/Loss and ROI (Year 2) | Projected Profit/Loss and ROI (Year 3) | |||||
| Estimated | Estimated | |||||
| Total income | $403,282.00 | Total income | $492,004.04 | |||
| Total expenses | $33,242.20 | Total expenses | $37,069.58 | |||
| Total profit (or loss) | Total profit (or loss) | |||||
| $370,039.80 | $454,934.46 | |||||
| Return on Investment (ROI) | Return on Investment (ROI) | |||||
| 1013.16% | 1127.24% | |||||
| ©2014 Digitec Interactive www.knowledgedirectweb.com | ||||||
| eLearning ROI Calculator - Investment Worksheet | ||||||
| Use this interactive spreadsheet to calculate your association's return on investment (ROI) for online member education. | ||||||
| Investment | Actual Cost Breakdown | |||||
| Content Development | Estimated | Actual | ||||
| Instructional design | $6,000.00 | $5,600.00 | ||||
| V/O Talent | $500.00 | $500.00 | ||||
| Photo licensing | $300.00 | $220.00 | ||||
| Video production | $5,000.00 | $8,000.00 | ||||
| Consulting (SME stipends) | $1,000.00 | $1,150.00 | ||||
| Miscellaneous | $1,500.00 | $800.00 | ||||
| Total | $14,300.00 | $16,270.00 | ||||
| Web Conferencing | Estimated | Actual | ||||
| Annual costs | $5,000.00 | $4,788.00 | ||||
| Miscellaneous | $1,200.00 | $1,188.00 | ||||
| Total | $6,200.00 | $5,976.00 | ||||
| LMS | Estimated | Actual | Estimated vs. Actual | |||
| Annual fixed costs | $5,000.00 | $4,788.00 | ||||
| Licensing (per course/user) | $10.00 | $10.00 | ||||
| Courses sold (year 1) | 1,000 | 1,426 | ||||
| Estimated future growth (%) | 15% | 22% | ||||
| Courses sold (year 2) | 1,150 | 1,740 | ||||
| Courses sold (year 3) | 1,323 | 2,122 | ||||
| Total LMS costs (year 1) | $15,000.00 | $19,048.00 | ||||
| Total LMS costs (year 2) | $16,500.00 | $22,185.20 | ||||
| Total LMS costs (year 3) | $18,225.00 | $26,012.58 | ||||
| Marketing | Estimated | Actual | ||||
| Print collateral | $3,000.00 | $3,235.00 | ||||
| Email marketing system | $1,200.00 | $1,188.00 | ||||
| Miscellaneous | $500.00 | $658.00 | ||||
| Total | $4,700.00 | $5,081.00 | ||||
| Total Expenses | Estimated | Actual | ||||
| $40,200.00 | $46,375.00 | |||||
| Projected Future Expenses | ||||||
| Estimated Total Expense (Year 2) | $33,242.20 | |||||
| Estimated Total Expense (Year 3) | $37,069.58 | |||||
no reviews yet
Please Login to review.
