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

How to Calculate Annuities Using Excel. Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off.