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 twopage 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: 12 page summary
References: Include a minimum of 3 scholarly resources