I’m working on a Excel exercise and need support.

Assignment 1

In a project to purchase a surgical robot, QVC AMC has asked you to conduct an analysis to determine the impact that the number of cases has on NPV. Given a 12% cost of capital and the following information:

Table 6. Example Data

Worst Case

Most Likely

Best Case

Year

# of case 1 Prob.=.25

# of cases 2 Prob. =.50

# of case 3 Prob.= .25

0

($2,000,000)

($2,000,000)

($2,000,000)

1

$750,000

$1,300,000

$1,500,000

2

$1,600,000

$1,800,000

$1,900,000

3

$1,100,000

$1,000,000

$1,200,000

Create an Excel workbook with two tabs in which you answer/solve the following (be sure to label tabs accordingly):

1.What is the project’s expected NPV on the basis of scenario analysis?

2.What is the project’s standard deviation of NPV?

Length: One Excel Workbook

Assignment 2

QVC AMC has a current ratio of 0.4. In a one- to two-page Word document, explain whether or not each of the following decisions would improve or increase this ratio:

1.Use cash to pay off current liabilities.

2.Collect on current outstanding accounts (accounts receivable).

3.Purchase additional medical supplies on credit (accounts payable).

4.Sell some of its medical supplies at cost.

Length: 1-2 page summary

References: Include a minimum of 3 scholarly resources