WEEK 5: INDEPENDENT PROJECT: EXCEL 2019 IN PRACTICE - CH 6 INDEPENDENT PROJECT 6-6

Clemenson Imaging LLC monitors increased revenue from the use of CT scan equipment. You analyze the number of patients and procedures by technician and location.

[Student Learning Outcomes 6.3, 6.4, 6.5, 6.6, 6.7]

File Needed: ClemensonImaging-06.xlsx (Available from the Start file link.)

Completed Project File Name: [your name]-ClemensonImaging-06.xlsx

Skills Covered in This Project

• Calculate the net present value of a purchase.
• Use TRANSPOSE to rearrange labels into a column.
• Concatenate cells to display full names.
• Use SUMIFS to summarize data.
• Calculate procedure times.
• Format times with fractions.

1. Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
2. Determine the net present value of a new equipment purchase.
   1. Click the Financials sheet tab and select cell H5.
   2. Use NPV with a Rate argument of 4.25%.
   3. Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.