Home
ACCA ACCA Course B.Com + ACCA CFA CFA Level 1 CFA Level 2 Financial Modelling & Valuation Placement Support
Success Stories Blogs About Contact & Locations
Enquire Now
Home › Blogs › Knowledge Series
Knowledge Series · Loan amortisation

Amortisation Explained: Understanding Loan Amortisation Through a Simple Example

By Kamal Kishore G Updated 18 November 2026 4 min read
Amortisation Explained: Understanding Loan Amortisation Through a Simple Example
Kamal Kishore G
Written by Kamal Kishore G
CA, CIMA AdvDip, CFA Level 2 cleared, Co-Founder, Skilledgrad
Quick answer

Loan amortisation is the process of gradually repaying a loan over a specified period. Each instalment consists of two components: interest on the outstanding loan balance and repayment of principal. An amortisation schedule helps us calculate these components and track the outstanding loan balance after each payment.

Imagine a company borrows ₹1,00,000 from a bank. It agrees to repay the loan over three years through equal annual instalments.

Contents

The company makes its first payment. Is the entire payment an expense?

No. Part of the payment represents interest on the outstanding loan. The remaining amount reduces the principal borrowed.

This simple distinction is the starting point for understanding loan amortisation.

The same concept also appears in lease accounting, which students encounter in professional finance courses such as ACCA and CFA.

Let’s understand how it works using a practical example.

1. What Is Amortisation?

Amortisation refers to the systematic allocation or reduction of an amount over a period of time.

In loan accounting, it helps us understand how each repayment is divided between interest and the reduction of the outstanding loan balance.

For example, when a company repays a bank loan, the entire instalment is not treated as an interest expense. The interest component is recognised as an expense, while the principal component reduces the liability.

The term amortisation is also used in accounting for intangible assets. However, in this article, we will focus on the amortisation of loans and financial liabilities.

To understand this better, let’s prepare an amortisation table.

2. Loan Amortisation: Let’s Start with Excel

Suppose a company borrows ₹1,00,000 at an annual interest rate of 10%. The loan is repayable over three years through equal annual instalments, paid at the end of each year.

How do we calculate the annual instalment?

We don’t need a complicated mathematical formula. Excel can do this for us.

Using the PMT Function in Excel

Excel has a built-in function called PMT, which calculates the periodic payment required to repay a loan when the interest rate and payments remain constant.

Enter the following formula in Excel:

=PMT(10%,3,-100000)

Excel returns an annual instalment of approximately ₹40,211.48.

Here is what the formula means:

Input Meaning
10% Annual interest rate
3 Number of annual payments
-100000 Initial loan amount

The negative sign follows Excel’s cash flow convention. Entering the loan amount as negative makes the calculated instalment positive.

Now that we know the annual instalment, we can prepare the amortisation table.

Preparing the Amortisation Table

The calculation involves three simple steps:

  1. Calculate interest: Opening loan balance × 10%.

  2. Calculate principal repaid: Annual instalment LESS Interest.

  3. Calculate closing balance: Opening balance LESS Principal repaid.

Repeat the same process for each year.

Loan Amortisation Table

All amounts are in ₹.

Year Opening balance Interest at 10% Annual instalment Principal repaid Closing balance
1 1,00,000.00 10,000.00 40,211.48 30,211.48 69,788.52
2 69,788.52 6,978.85 40,211.48 33,232.63 36,555.89
3 36,555.89 3,655.59 40,211.48 36,555.89 0.00

Minor differences may arise from rounding.

Interest vs. Principal Repayment

Loan amortisation schedule showing interest and principal repayments

As the outstanding loan balance decreases, a greater proportion of each instalment goes towards principal repayment.

Look at what happens over the three years.

  • Interest decreases: Interest is calculated on the outstanding balance, which reduces every year.

  • Principal repayment increases: Since the annual instalment remains constant while interest decreases, more of each payment goes towards principal.

  • The loan balance becomes zero: By the end of Year 3, the entire loan has been repaid.

Understanding the First Instalment

The company pays ₹40,211.48 at the end of Year 1.

Of this amount:

  • ₹10,000 represents interest expense.

  • ₹30,211.48 reduces the outstanding loan.

The closing loan balance is therefore ₹69,788.52.

The important point: the instalment is not the same as the interest expense. The instalment includes both interest and principal repayment.

3. How Does Loan Amortisation Affect Financial Statements?

Using the same example, let’s understand the impact of the first instalment on the company’s financial statements.

Particulars Impact
Income statement Interest expense of ₹10,000
Balance sheet: Loan liability Reduction of ₹30,211.48
Balance sheet: Cash Reduction of ₹40,211.48

Although the company has paid ₹40,211.48, only ₹10,000 is recognised as an expense in this example.

This is an important distinction between cash outflow and expense recognition in accounting.

4. Where Are These Concepts Used in ACCA and CFA?

Students pursuing professional qualifications such as ACCA and CFA encounter these concepts in various areas of their curriculum.

ACCA: Financial Reporting (FR)

  • Leases (IFRS 16): Calculating interest on lease liabilities and determining the outstanding lease liability after each payment.

  • Financial Instruments (IFRS 9): Accounting for financial instruments measured at amortised cost using the effective interest method.

CFA: Financial Statement Analysis (FSA)

  • Understanding the accounting treatment of long-term liabilities.

  • Understanding lease liabilities and their impact on financial statements.

  • Analysing interest expenses and outstanding financial liabilities.

The concept also has practical applications in Financial Modelling, particularly when preparing debt repayment schedules and forecasting interest expenses.

Understanding the Concept Rather Than Memorising the Formula

Amortisation becomes easier when we understand the logic behind the numbers rather than memorising formulas.

Excel helps us calculate the annual instalment. The amortisation table then shows how the payment is divided between interest and principal repayment.

The same basic idea also helps us understand lease liabilities and other financial instruments in professional accounting and finance courses.

Once the concept is clear, the calculations become much easier to follow.

Technical References

Microsoft Excel: PMT Function

ACCA: IFRS 16 Leases

ACCA: What Is a Financial Instrument?

CFA Institute: Topics in Long-Term Liabilities and Equity

Learn with Skilledgrad
ACCA and CFA Coaching in Chennai
Classroom ACCA and CFA batches at Purasaiwakkam and Tambaram. Time value of money, NPV and IRR are core topics in both.
Enquire Now WhatsApp Us

Prepare with Skilledgrad

Classroom coaching at Purasaiwakkam and Tambaram, with structured classes, question practice, tests and one-on-one mentoring. Talk to us about the batch and exam window that suit you.