Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

NPV vs. PV Formula in Excel While you can calculate PV in Excel, you can also calculate net present value (NPV) . Present value is discounted future cash flows.

Now that your input area is finished you can use the information to calculate the issue price of the bond using the NPV function in Excel. From your NPV cell (B14) begin by clicking on the fx button ...

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...