Find the IRR and use it as the discount rate that causes NPV to equal zero. Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, to solve for the discount rate ...

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, you must consider the present value of all cash receipts and all cash disbursements related to ...

The next time you cover this topic, consider teaching students how to calculate the issue price by using the net present value function (NPV) in Excel. Here’s an example: Suppose a company issues a $1 ...

Excel 2010 includes a built-in function for computing the trimmed mean. Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," and enter the first number in the data set you want to get ...

Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, to solve for the discount rate that equals zero. Article Sources Investopedia requires writers to use primary ...