Question

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.

Answer 1

Since the student is paying only 70$ per credit hour and cost to university is 1350$ per credit hour, exected CLV is negative assuming students takes 120 hours per semester , expected CLV for 1 semester is -1,53,600$ and total exected CLV at end of 4 years is -2457600$, please find the attachment.

                                                        Expected CLV calculation

Assumptions:-

Assuming student takes 120 hours per semester
Student Paying $70 Per credit hour
Cost to university Per credit hour-$1350

Calculations:-

Total Fees Paid = Fee for credit hour * total number of hours per semester=$120*$70=8400$.

Total cost to university=cost per credit hour per student * total number of hours per semester

                                        =1350*120=$162000

CLV Per semester= Total Fees Paid- Total cost to university

                               =$8400-$162000

                               = $ -153,600.00

Expected CLV=CLV per semester* total semesters

                        =8*153600= $ -2,457,600
? x - Sign in FILE FORMULAS DATA Á A === A E E E HOME INSERT PAGE LAYOUT % Cut Calibri -11 LE Copy B Format Painter IU , Clipboard Font New Microsoft Excel Worksheet - Excel (Product Activation Failed) REVIEW VIEW DEVELOPER ADD-INS POWERPIVOT Ep Wrap Text Accounting D E Merge & Center, $,% , 2.09 Conditional Format as Cell Formatting Table Styles Alignment Number Styles X AutoSumĄy # Paste Insert Delete Format - Cells Fill- Clear Sort & Find & Filter - Select Editing J14 x fc =SUM($B13:13) Assumptions 2 Assuming student takes 120 hours per semester 3 Student Paying $70 Per credit hour 4 Cost to university Per credit hour-$1350 120 70 1350 9 Details 10 11 Total Fees Paid 12 Total cost to university 13 CLV Per semester 14 Expected CLV 15 Year1 Year2 Year3 Year4 Total Semester1 Semester2 Semester3 Semester4 Semester5 Semester6 Semester7 Semester 8 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 8,400.00 $ 67,200.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 162,000.00 $ 1,296,000.00 $(153,600.00) $ (153,600.00) $ (153,600.00) $(153,600.00) $ (153,600.00) $ (153,600.00) $ (153,600.00) $ (153,600.00) $ (1,228,800.00) $ (153,600.00) $ (307,200.00) $ (460,800.00) $ (614,400.00) $ (768,000.00) $ (921,600.00) $(1,075,200.00) $(1,228,800.00) $ (2,457,600.00)| Sheet1 + READY 100% - 73%) 1 Type here to search e @ 9 wi x] U gol -- + 2:11 PM de la 371/2020