Monthly Loan Amortization Calculator

This monthly loan amortization calculator is useful for estimating loan repayments on debt finance for a business startup

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 repayable over 5 years at 23,097 per year.

Furthermore to give stability in predicting future cash flow requirements, typically a business will borrow from a bank with a fixed annual interest rate. In addition the rate is generally compounded monthly with fixed monthly repayments throughout the term of the loan.

Using the Monthly Loan Amortization Calculator

This monthly loan amortization calculator is useful for any loan up to a maximum term of 120 months (10 years). The calculator will calculate the monthly repayments due together with the total amount repayable and interest payable over the term.

Additionally the loan amortization calculator will provide a commercial loan amortization schedule. The schedule sets out the monthly opening and closing balances together with the amount of interest and repayment.

Loan Amortization Calculator v 1.0

The Excel monthly loan amortisation calculator is available for download below. The calculator allows for any loan and interest rate amount and for up to a maximum term of 10 years (120 months). The calculator is used by simply entering values for the loan, rate, and term.

Monthly Loan Amortisation Schedule Download

The monthly loan amortisation calculator is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this monthly loan amortisation calculator template at their own risk. We make no warranty or representation as to its accuracy. 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.
Last modified January 19th, 2023 by Michael Brown

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.

You May Also Like