Here is the link to my spreadsheet where you can calculate a loan over x years to be paid back monthly. It will give you the amortized payment amount.Use the following formulas to show the total payment, interest portion of the payment, and principal portion of the payment. Use these calculator templates to help you navigate your loans, budgets, net worth, and more. Type the month and year of the first loan payment in cell A8. Check out our amortization calculator excel selection for the very best in unique or custom, handmade pieces from our templates shops. Final values may vary subject to bank's policy. Use this calculator to work out your daily interest for a fixed number of days or months. It's useful for bitcoin and other crypto currency trading.