Figure A How to use XLOOKUP () to calculate commissions in Excel Let’s review the commission requirements using real data this time. The first sale value is $1,208.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.