Mc

Graw

Hill

SIMnet

Week 6: Excel 2019 In Practice - Ch 6 Independent

Project 6-6

COURSE NAME 155 MY23 Master | Data Analysis with Spreadsheets with Lab-10346

Start Date:06/03/2311:59 PMUS/Mountain Due Date:06/11/2311:59 PMUS/Mountain End Date:06/24/2311:59 PMUS/Mountain

Independent Project 6-6

Print Info

Student Name: Hopkins, Kendra

Student ID: D41195263

Username: D41195263

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 fleink.)

Completed Project File Name: your name]-Clemensonimaging-05.xlsx

Skills Covered in This Project

• Calculate the net present value of a purchase.

• Use TRANSPOSE to reamange labels into a column.

. Concatenate cells to display full names.

• Use SUMIFS to summarize data.

• Calculate procedure times.

• Format times with fractions.

Steps to complete This Project

1.0 Open the Clemenson Imaging-06 workbook and click the Enable Editing button. The file will be renamed automatically

to indude your name.

2. Determine the net present value of a new equipment purchase.

a.Click the Financials sheet tab and select cell HS.

b.Use NPV with a Rate argument of 4.25%.

c. Select calls 07:013 for the Valuef argument and click OK. This is the same as entering each value argument

separately

d. Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.

3. Use TRANSPOSE and CONCAT to display technician names.