This tutorital assumes you have some experience with Microsoft Excel.

Step 1: Create the inputs

First step, create a table similar to the following:

Note we are using Excel's built in function PMT() to calculate our payments.

Here is the same table showing the results.

Step 2: Create Names