1. Business
  2. Finance
  3. use xnpv to value the following investment assume that the...

Question: use xnpv to value the following investment assume that the...

Question details

Use XNPV to value the following investment. Assume that the annual discount rate is 12 percent. (please provide excel work and functions)

A B
1 Date Cash flow
2 30-Jun-07 -600
3 14-Feb-08 100
4 14-Feb-09 300
5 14-Feb-10 400
6 14-Feb-11 600
7 14-Feb-12 800
8 14-Feb-13 -1,900
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution