Internal rate of return (IRR) and net present value (NPV) aren’t always equally effective. Compare NPV vs. IRR to learn which to use for capital budgeting.

To determine the value of a bond today—for a fixed principal (par value) to be repaid in the future—we can use an Excel spreadsheet.