Creating a monthly payment chart

[Davidns]

I have a spreadsheet that contains the following information:

monthly payment, # of months of the payment to be made.

From this data, I would like to figure out an easy way to create a table showing month 1, month 2, etc in column 1, and the monthly payment in column 2.

Is there an easy way to do this? I have about 500 contracts to analyze, so would very much prefer not to have to manually create the table, but to generate it via the summary information I have.

Thanks!
David

[zbor]

Can you upload example workbook?

make sure to remove all confidential data, but keep same formatting (i.e. John Doe 123$)