jagomart
digital resources
picture1_Excel Sheet Download 11607 | Value For Money Guide | Sample Application


 254x       Filetype XLSX       File size 0.03 MB       Source: www.galidata.org


File: Excel Sheet Download 11607 | Value For Money Guide | Sample Application
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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 05 Jul 2022 | 3 years ago
Partial file snippet.
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.





















































































































































Sheet 2: 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


Sheet 3: Input Tab
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!

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions in order to complete the worksheet and produce final value for money calculation you will need following program cost amount invested into cohort ventures number of total fulltime employees at time application year after a group comparison once this data has been compiled enter venture both appropriate columns quot tab next fill information input using first three variables highlighted cells b resulting statements can be found output which autopopulate entered example holds some dummy that may useful understanding formulas please note template assumes programs have followup from all see how calculate average with incomplete sample amp components effectiveness analysis costs lt here investment outcomes baseline div per change results net costeffectiveness effectivenesscost...

no reviews yet
Please Login to review.