Example of payment for annuity in Excel
This tutorial shows how to solve for an annuity payment in Excel. An annuity is a series of equal cash flows, spaced equally in time. Case study: Using the PMT function, the goal in this example is to have 100,000 at the end of 10 years, with an interest rate of 5%. Payments are made annually, …