Program Type Cost-Benefit Analysis Worksheet

	A	B	C	D	E	F	H	I	J
1	---
2
3			Program Type Cost-Benefit Analysis Worksheet
4			How to use this template: This is a view-only file and cannot be edited. Create your own copy of this template to edit. In the menu, click File > Make a copy...
5
6
7
8
9
10
11
12
13
14
15		View your results at the bottom of this page.
16
17			Which program type would you like to look at?				Full-Time
18			Now, tell us what's important to you.
19
20			Rank the following dimmensions on a scale from 1 to 5, where 1 is not at all important to me and 5 is very important to me.
21
22				Prestige and Brand					Note: This model assumes 3% annual growth in salary.
23				Networking with Other Students					Note: This model assumes 3% annual growth in salary.
24				Mentorship from Professors
25				Rigorous Development of Leadership Skills					Note: This model assumes that only full-time students will be giving up their annual salary, while part-time and online students will not experience this opportunity cost.
26				Ability to Switch Careers
27				Obtaining a Summer Internship
28				Work-Life Balance
29				Avoiding Debt
30			Then, answer a few questions.
31
32			About your degree and salary...
33
34			Is your company likely to sponsor your degree?
35			What percentage of your tuition will your company pay?				Enter a numeric value.
36			What is the annual tuition cost?				Enter a numeric value.
37			How much can you expect to make per year without a graduate degree?				Enter a numeric value.
38			How many years do you anticipate it will take you to complete your degree?				Enter a numeric value.
39			How much can you expectto make during a summer internship?				Enter a numeric value.
40			... Just a few more.
41
42			About your living and travel expenses...
43
44			Are you moving to go to school?				Yes
45			What is your current monthly rent/mortgage payment?				Enter a numeric value.
46			How much do you anticipate you'll pay in monthly rent in your new place?				Enter a numeric value.
47			What will be your moving cost to go to school?				Enter a numeric value.
48			How many times a year do you anticipate traveling home? (i.e., for major holidays, breaks, etc.)				Enter a numeric value.
49			What is the cost of your each of these trips?				Enter a numeric value.
50
51			View Your Results Below!
52
53		Overall, this program is a great fit for your needs!
54		Overall, this program is a great fit for your needs!
55
56			Numbers we crunched:			What we found:
57
58			Number of Summer Internships		#VALUE!
59			Total Money Earned During the Summer		#VALUE!	For Prestige and Brand:		This program is ideal
60			Total Cost of Tuition		#VALUE!	For Networking with Other Students:		This program is ideal
61			Total Tuition Cost You'll Pay Yourself		#VALUE!	For Mentorship from Professors:		This program is ideal
62			Total Salary Lost		$0	For Rigorous Development of Leadership Skills:		This program is ideal
63			Current Annual Living Expenses		#VALUE!	For Ability to Switch Careers:		This program is ideal
64			Anticipated Living Expenses During School		#VALUE!	For Obtaining a Summer Internship:		This program is ideal
65			Difference in Living Expenses		#VALUE!	For Work-Life Balance:		This program is ideal
66			Total Moving and Transportation Cost of School		#VALUE!	For Avoiding Debt:		This program is ideal
67			Net Cost To Attend School		#VALUE!
68
69
70			When you're done, get your template reviewed			here.
71