When a business needs funding it usually looks to obtain debt finance from a bank or other lender. Loans are defined by the amount borrowed (the principal), the annual interest rate, and the term of the loan.
To give stability in predicting future cash flow requirements, typically a business will borrow from a bank with a fixed annual interest rate compounded monthly and fixed monthly repayments throughout the term of the loan.
This monthly loan amortization calculator can be used for any loan up to a maximum term of 120 months (10 years), and will calculate the monthly repayments due on the loan together with the total amount repayable and total interest payable over the term.
In addition the monthly loan amortization calculator will provide a commercial loan amortization schedule setting out for each month, the opening loan balance, the amount of interest, the repayment, and the closing loan balance.
The Excel monthly loan amortization calculator, available for download below, allows for any loan and interest rate amount and for up to a maximum term of 10 years (120 months), and is used by simply entering values for the loan, rate, and term.
Monthly Loan Amortization Calculator Download
The monthly loan amortization calculator is available for download in Excel format by following the link below.
Users use this monthly loan amortisation calculator template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a business loan repayment calculator that you might use. It is a purely illustrative loan amortization calculation. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the monthly loan amortization calculator, please let us know and we will try to fix it.