Program Type Cost-Benefit Analysis Worksheet
|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...
|View your results at the bottom of this page.|
|Which program type would you like to look at?||Full-Time|
Now, tell us what's important to you.
|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.|
|Prestige and Brand||Note: This model assumes 3% annual growth in salary.|
|Networking with Other Students|
|Mentorship from Professors|
|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.|
|Ability to Switch Careers|
|Obtaining a Summer Internship|
Then, answer a few questions.
About your degree and salary...
|Is your company likely to sponsor your degree?|
|What percentage of your tuition will your company pay?||Enter a numeric value.|
|What is the annual tuition cost?||Enter a numeric value.|
|How much can you expect to make per year without a graduate degree?||Enter a numeric value.|
|How many years do you anticipate it will take you to complete your degree?||Enter a numeric value.|
|How much can you expectto make during a summer internship?||Enter a numeric value.|
|... Just a few more.|
About your living and travel expenses...
|Are you moving to go to school?||Yes|
|What is your current monthly rent/mortgage payment?||Enter a numeric value.|
|How much do you anticipate you'll pay in monthly rent in your new place?||Enter a numeric value.|
|What will be your moving cost to go to school?||Enter a numeric value.|
|How many times a year do you anticipate traveling home? (i.e., for major holidays, breaks, etc.)||Enter a numeric value.|
|What is the cost of your each of these trips?||Enter a numeric value.|
|View Your Results Below!|
|Overall, this program is a great fit for your needs!|
Numbers we crunched:
What we found:
|Number of Summer Internships||#VALUE!|
|Total Money Earned During the Summer||#VALUE!||For Prestige and Brand:||This program is ideal|
|Total Cost of Tuition||#VALUE!||For Networking with Other Students:||This program is ideal|
|Total Tuition Cost You'll Pay Yourself||#VALUE!||For Mentorship from Professors:||This program is ideal|
|Total Salary Lost||$0||For Rigorous Development of Leadership Skills:||This program is ideal|
|Current Annual Living Expenses||#VALUE!||For Ability to Switch Careers:||This program is ideal|
|Anticipated Living Expenses During School||#VALUE!||For Obtaining a Summer Internship:||This program is ideal|
|Difference in Living Expenses||#VALUE!||For Work-Life Balance:||This program is ideal|
|Total Moving and Transportation Cost of School||#VALUE!||For Avoiding Debt:||This program is ideal|
|Net Cost To Attend School||#VALUE!|
|When you're done, get your template reviewed||here.|