What the NPV value associated with the certificate program

Reference no: EM132029740

Assignment -

SCENARIO - "A 4-year, private, nonsecular college in Tennessee that is suffering from declining enrollments has decided there is an unmet demand for graduate education in Human Resource Management (HRM). The college believes it has an opportunity to counter the enrollment decline by offering a program to in HRM.

The decision it is trying to make is whether or not it would be more beneficial to offer a Masters degree in HRM (39 credit hours) or a Graduate Certificate (18 hours).

The CFO has urged the college to use NPV analysis to evaluate the financial implications of this decision."

ASSUMPTIONS included in the case

"The tables on tab 2 reflect the college's best estimates for the initial or Year 0 (i.e. start-up) assumptions, and for Year 1 assumptions. The college has factored in estimated development and startup costs, and initial enrollment and attrition rates for each option.

Assumptions for rates of change in each of these categories are reflected in the tables in the 2nd tab (hint: look at the formulas).

The college assumed that the rate of tuition increase for the last few years would apply for this analysis. The per-credit tuition cost is the same for each program, but the degree program requires more than twice the number of credit hours.

The college also assumed that the program would not generate any additional costs other than the startup costs. "

INSTRUCTIONS & QUESTIONS

Q1. Using the data in the two charts on tab 2, find the answers to the following 3 questions from the published case. You may create your own table from the template used in the AS 7.3.2. video or use the more expedient Excel NPV function (see AS video 7.4) :

a) What was the NPV value associated with the certificate program (a)?

b) What was the NPV value associated with the complete degree program (b)?

c) Which of the examined academic programs was recommended as a viable contender based on a comparison of the calculated NPV values - and WHY?

Q2. Identify the assumptions embedded in the charts of tab 2 for years 2 - 7:

Enrollment growth rate

Attrition rate

Rate of change in tuition

Q3. What assumption from the five you identified in question 2 above do you think has the biggest potential to impact the calculated NPV if the assumption is innapropriate?

Note: Do not run a sensitivity analysis on the discount rate; assume it has been determined by the CFO and does not need to be tested. Instead, run sensitivity analyses on the assumptions you identity here in #3 as having the biggest possible impact.

Q4. Run at least two sensitivity analyses using different values for the assumption you identified in question 3. (Note: even though the underlying rates of change on tab 2 are releatively constant, you are not locked in to these. Use your insight and critial thinking to determine what assumptions you believe make the most sense. As with prior assignments, it is your thought process that matters most). You are welcome, but not required, to use the ""What If"" analysis for your calculations because it would require an ancillary set of calculations in order to create a table for the assumptions identified in Q2 above. You are also welcome, but not required, to graph your results.

Discuss how the results of your sensitivity analyses would impact your decision.

Attachment:- Assignment File.rar

Reference no: EM132029740

Questions Cloud

History and the environment : "Mirror, Mirror on the Wall . . ." ~ paradoxes in history ~ "heads and tails," i.e. flip sides (ex: good and bad) of the same event, person, or place.

Describe activities to set up emergency operation center : Briefly describe the activities that need to occur to set up the emergency operation center for your company, and where your company should locate.

What would the partial pressure be for each gas present : What would the partial pressure be for each gas present. Also the total pressure of the tank. For scuba dives below 150 ft, helium is often used to replace.

Alpha product line and for the beta product line : What is the total amount of traceable fixed manufacturing overhead for the Alpha product line and for the Beta product line?

What the NPV value associated with the certificate program : The college assumed that the rate of tuition increase for the last few years would apply for this analysis. What NPV value associated with certificate program

What was the significance of the mongol invasion : What was the significance of the Mongol invasion and occupation for Asian History?

Describe the design for a small web site : Develop a 5-6 page Word document that describes the design for a small Web site that meets the following specifications.

What is the trend in the current ratio : What is the trend in the Current Ratio and what does this mean? What is the trend in the DTE ratio and what does this mean?

Illustrate the combined dollar contributions : Prepare a simple Excel graphic to illustrate the combined dollar contributions of employee and employer to FICA compared to those for the self-employed taxpayer

Reviews

len2029740

6/25/2018 5:08:34 AM

Note - Net present value information and analysis, data is available in tab 2 of the attached excel file. Note: Do not run a sensitivity analysis on the discount rate; assume it has been determined by the CFO and does not need to be tested. Instead, run sensitivity analyses on the assumptions you identity here in #3 as having the biggest possible impact.

Write a Review

Required(*) Message

User Account

All Pages