amortization formula excel

If you are looking for amortization formula excel may be the best thing to do will be to have a look  at the workbook attached herewith. This workbook has amortization schedule built in already.
All that you may need to do is to debug/change the formulas a bit to customise it to your requirements.

I hope this helps.