Calculate the expected CLV (customer lifetime value) of an International undergrad student at SDSU starting in Fall of 2020, using the following information / assumptions:

The student pays out-of-state undergrad tuition ($13,290 per academic year or two semesters)

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

Cost to university per credit hour per student is $1350

The student does not take any summer classes.

In accordance with US immigration rules the international student takes only one online or blended class per semester. ($396/credit hour) (1 class = 3 credit hours)

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

Undergrad student 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 SDSU as an undergrad student, with clear rationale for using.

Please upload an Excel file showing your calculations, and a doc file explaining the process for these calculations.