I need to reduce an amortization schedule from the "long" form to a short formula in order to reduce the size of a spreadsheet.

Right now the spreadsheet goes down 360+ rows and I think it can be done in just a couple of rows.

It would also be necessary for the formula to calculate total interest paid and hopefully number of months to pay it off.

No Macros or VB!

I am ready to pay someone to do this so anyone may feel free to contact me ( berry@ablebusinesssolutions.com )

Thank You,
Berry