Questions: 1. By using choose or Index or Offset, what is the sales quantity in January 2020? (4 points) 2. If the val

[answerhappygod]

Questions:
1. By using choose or Index or Offset, what is the sales
quantity in January 2020? (4 points)
2. If the value of the incremental cash inflow is the same
as the total value of sales, and on 1 Dec 2019 there is an
investment of 1.000.000.000
a. what is the IRR value? (4 points)
b. what is the NPV value assuming a 25% cost of capital.
(4 points)
The formula choices provided are: IRR, XIRR, NPV, XNPV, choose
the most appropriate formula for the answer above.
You are allowed to add another column to calculate the IRR and
NPV of ABC Co