Create an Excel Presentation. You must analyze the cost for a current, full time freshman undergraduate student assuming no financial aide at each of the following universities:

? Southern Connecticut State University (state resident)

? University of New Haven

? Quinnipiac University.

? Yale University.

Part One

Cost analysis of attending each university while earning a bachelors degree for one year.

1. Determine the total cost of attending each university for a freshman for the current year (2 semesters). Assume that the student is living on campus and include the cost of campus housing and board (room and food). If the university offers a variety of housing choices, select one priced in the middle. For all students include any additional fees the university might charge excluding health insurance. Include an estimate for textbooks but do not included any costs for transportation to and from the university (i.e. for students living out of state. Organize your data showing a breakdown of costs in a way that facilitates comparisons between the different universities.

2. Create a chart/graph which clearly compares the total cost of each university.

3. Determine the total cost per week of attending classes at each university. Assume each university meets for 15 weeks including exams.

4. Determine the cost per class meeting meaning what does it cost the student every time they step foot into their classroom. The number of class meetings per week varies depending on which course/ course section the student signs up for. Some classes meet once a week while others meet twice a week or more (if a lab class is associated with the course). Make sure you explain your rational for determining this value.

Part Two Cost analysis of earning a bachelors degree in four years.

1. Based on the total cost of attending each university you computed in part one, analyze the total cost each of the four years that a student would spend earning a bachelors degree at each university. Assume that the total cost will increase by 4.5% each year above the cost of the previous year. Set up your spreadsheet so I can easily adjust this interest rate if I wish to.

2. Determine the final cost for earning a bachelors degree in 4 years at each university based on your calculations.

3. Add a chart that demonstrates the difference in cost for students attending the different universities. Use your judgement on what data to present and how best to present it.