Calculate the expected CLV of an International UG student at UNL starting in Fall 2018, using the following information/assumptions:

1. The student pays out-of-state UG tuition

2. Fees are about $70/credit hour per student, paid at beginning of each semester

3. Cost to university per credit hour per student is $1350

4. The student does not take any summer classes.

5. In accordance with US immigration rules the international student takes only one online or blended class per semester.

6. Student takes all 120 hours from UNL, and graduates in four years (8 semesters).

7. UG stays off campus and does not have a meal plan.

Please state any other information/assumption you employ to calculate the CLV for the student during their tenure at UNL as a UG student, with clear rationale and/or citation for using.

Upload your Excel file showing your calculations, and a doc/docx file explaining your process for your calculations.