The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excel’s online help. Then use it to develop a spreadsheet model that finds the NPV of the following series: a payment of $25,000 today (assumed to be June 15, 2010), and cash inflows of $10,000 on March 1, 2011; $15,000 on September 15, 2011; $8000 on January 20, 2012; $20,000 on April 1, 2012; and $10,000 on May 15, 2012. Discount these back to “today” using a discount rate of 12%.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.