Filetype Excel XLSX | Posted on 05 Jul 2022 | 3 years ago
Authentication
digital resources
280x Filetype XLSX File size 0.03 MB Source: www.galidata.org
Sheet 1: Instructions
| Instructions | |||||||||||||||||||||
| In order to complete the worksheet and produce the final Value for Money calculation, you will need the following: | |||||||||||||||||||||
| Program cost | |||||||||||||||||||||
| Amount invested into cohort ventures | |||||||||||||||||||||
| Number of ventures in cohort | |||||||||||||||||||||
| Total number of full-time employees for cohort ventures at the time of application | |||||||||||||||||||||
| Total number of full-time employees for cohort ventures 1 year after application | |||||||||||||||||||||
| Total number of full-time employees for a group of comparison ventures at the time of application | |||||||||||||||||||||
| Total number of full-time employees for a group of comparison ventures 1 year after application | |||||||||||||||||||||
| Once this data has been compiled, enter the venture data for both the cohort and the comparison ventures in the appropriate columns in the "Venture Data" tab. | |||||||||||||||||||||
| Next, fill in the information in the "Input Tab" using the first three variables (program cost, amount invested, and number of ventures in cohort) in the highlighted cells (B3, B4, and B5). | |||||||||||||||||||||
| The final, resulting statements can be found in the "Final Output" tab, which will auto-populate once the data has been entered. | |||||||||||||||||||||
| The "Example" tab holds some dummy data that may be useful in understanding the formulas in this calculation. | |||||||||||||||||||||
| *Please note that this template assumes that programs have complete application and follow-up data from all cohort and comparison group ventures. See the "Example" tab for how to calculate average with incomplete venture data. | |||||||||||||||||||||
| Sample Cohort & Comparison Data | |||||
| Cohort Ventures | Number of Full-Time Employees at Application | Number of Full-Time Employees 1 Year after Application | Comparison Group | Number of Full-Time Employees at Application | Number of Full-Time Employees 1 Year after Application |
| Venture 1 | Comparison Venture 1 | ||||
| Venture 2 | Comparison Venture 2 | ||||
| Venture 3 | Comparison Venture 3 | ||||
| Venture 4 | Comparison Venture 4 | ||||
| Venture 5 | Comparison Venture 5 | ||||
| Venture 6 | Comparison Venture 6 | ||||
| Venture 7 | Comparison Venture 7 | ||||
| Venture 8 | Comparison Venture 8 | ||||
| Venture 9 | Comparison Venture 9 | ||||
| Venture 10 | Comparison Venture 10 | ||||
| Components of Cost Effectiveness Analysis | ||
| Costs | ||
| Program Cost | $100,000 | <--- input program cost here |
| Amount Invested into Cohort Ventures | $50,000 | <--- input investment amount here |
| Number of Ventures in Cohort | 10 | <--- input number of ventures in cohort here |
| Outcomes | ||
| Cohort Ventures | Comparison Group | |
| Baseline Average: Number of Full-time Employees | #DIV/0! | #DIV/0! |
| Follow-up Average: Number of Full-time Employees | #DIV/0! | #DIV/0! |
| Calculation Components | ||
| Cohort Ventures | Comparison Group | |
| Cost Per Venture | $15,000 | |
| Average Change in Number of Full-time Employees | #DIV/0! | #DIV/0! |
| Results | ||
| Average Cost - Effectiveness | #DIV/0! | |
| Average Effectiveness - Cost (per $1,000) | #DIV/0! | |
| Net Cost-Effectiveness | #DIV/0! | |
| Net Effectiveness-Cost (per $1,000) | #DIV/0! | |
