Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off. Whether you are investing or borrowing money does not change the calculation.

When you use Excel, you can make changes to the amount borrowed, the interest rate and the payment period and immediately see how the loan would change. How to Calculate Business Loan Payments.

Excel has a dedicated function to calculate NPV. The following article explains how to use this function in the case of a calculation of NPV with cash flows that are collected in the same periods ...

Microsoft Excel provides an easy way to calculate payback periods. The payback period is the amount of time needed to recover an initial investment outlay. The main advantage of using the payback ...