You are helping your friend who is torn between joining the MBA program in Finance at...

Transcribed Image Text:

You are helping your friend who is torn between joining the MBA program in Finance at Lubin or completing a one-year online certificate program in Business Analytics at MIT. Your friend is now 30 years old and plans to retire at 65. To help your friend to make this decision you collect the following data: Tuition and fees per year (paid at the beginning of each year Length of the program Initial base salary differential at the end of the program completion-paid at the end of each year Annual growth rate of salary differential Certificate $10,000 1 year $10,000 3.5% MBA program a. What should your friend choose if her discount rate is 6%? b. What should your friend choose if she uses the IRR decision criterion? c. At what discount rate, your friend would be indifferent between the two alternatives $50,626 2 years $20,000 d. Construct the rough graph of NPV vs. discount rate for each alternative -- put both NPVs on the same graph. You can do it in Excel and then copy the graph here. 3.5% e. With the help of the graph, as precisely as you can describe which alternative is the best and under which circumstances. You are helping your friend who is torn between joining the MBA program in Finance at Lubin or completing a one-year online certificate program in Business Analytics at MIT. Your friend is now 30 years old and plans to retire at 65. To help your friend to make this decision you collect the following data: Tuition and fees per year (paid at the beginning of each year Length of the program Initial base salary differential at the end of the program completion-paid at the end of each year Annual growth rate of salary differential Certificate $10,000 1 year $10,000 3.5% MBA program a. What should your friend choose if her discount rate is 6%? b. What should your friend choose if she uses the IRR decision criterion? c. At what discount rate, your friend would be indifferent between the two alternatives $50,626 2 years $20,000 d. Construct the rough graph of NPV vs. discount rate for each alternative -- put both NPVs on the same graph. You can do it in Excel and then copy the graph here. 3.5% e. With the help of the graph, as precisely as you can describe which alternative is the best and under which circumstances.