When a business needs funding it usually looks to obtain loan finance from a bank or other lender. The lender gives an amount of money (the principal) to the borrower, and the borrower agrees to repay the principal together with a fee (usually called interest).
The loan agreement will stipulate the terms of the loan including the principal, interest rate, repayment amounts and date. For example, a business might borrow 100,000 from a bank at 5% interest to be repaid over 5 years at 23,097 per year.
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.
Using the Monthly Loan Amortization Calculator
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.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.