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 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%.