1. (1 % ) Estimate the NPV, ROI, and payback period for the XYZ project using the information below. Your results should look similar to Figures 2-4 through 2-6 on pp. 46-47. Use the business case financials template. Type your name on the spreadsheet, and type any comments/answers directly on the spreadsheet. Be sure to change the formatting to display one decimal place for the discount rate and ROI and properly note the year of payback (not Year X).

a. Estimated costs for the XYZ project are $250,000 in year 0 and $50,000 each in years 1, 2, and 3. Estimated benefits are $0 in year 0 and $175,000 each year in years 1, 2 and 3. Show the results (entire spreadsheet showing NPV, ROI, and year in which payback occurs) for a discount rate of 5.0%. Scoring: correct NPV, ROI, and payback year, 2 pts each, correct number and other formatting, 2 pts) (8 points)

b. Would you recommend doing this project based on the NPV, ROI, and payback? Why or why not? Be sure to type your response directly on the first tab of the worksheet. (2 pts)

2. (0.5 %) You want to estimate how many years it will take to pay back the money you have spent earning a bachelors degree. Hint Table and Figure similar to Figure 2-7 on page 49.

a. Assume your costs were $40,000 per year for four years (years 1, 2, 3, and 4) by paying for college and not working as many hours, and your after-graduation benefits were $15,000 per year for the next 30 years by getting a better job. Ignoring the time value of money, taxes, etc., in what year will you pay back for your college? (Hint: Find the year where the cumulative cash flow is equal to zero.)

b. Be sure to type your response directly on the second tab of the worksheet with your results and how you calculated them.

3. (0.5 %) Prepare a weighted scoring model (table and chart similar to Figure 2-8 on p. 51) based on the following data, using the template with that name. Your company is trying to decide which of five building locations to build on. Be sure to type your response directly on the third tab of the worksheet. Make sure you add DATA LABELS to your charts.

a. The main criteria and their weights are as follows: Cost 35%; Location 20%, Taxes 10%, Local Governmental Laws 25%, and Local Labor Rates 10%.

b. The ratings for Location 1 are 75, 85, 50, 40, and 80. The ratings for Location 2 are 90, 60, 70, 55, and 30. The ratings for Location 3 are 60, 50, 70, 80, and 90. The ratings for Location 4 are all 65. The ratings for Location 5 are 70, 40, 90, 65, and 90.

c. Find the weighted score for each project (3 points) and describe which one you would recommend and why (1 point) on the spreadsheet. Note: Check/adjust the formulas to make sure they are correct. (4 points)