A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||
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 | ||||||||||||
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 |