Loan amortization table
Originally published: 10/11/2020 09:35
Last version published: 15/02/2021 14:01
Publication number: ELQ-73178-2
View all versions & Certificate
certified

Loan amortization table

A simple loan repayment shedule in Microsoft Excel.

Description
Here is a simple loan amortization table designed to calculate the instalment repayment on a loan, split into principal and interest.

This loan amortization table takes into consideration the following inputs;

Amount borrowed
Interest rate
Loan tenor
Repayment start date
Periodicity of repayment (repayment interval)

Simply key in the necessary inputs as stated above and what you have will be a schedule of your loan repayment plan.

The table can take a period of up to 360 months (30years).
Here is a simple loan amortization table designed to calculate the instalment repayment on a loan, split into principal and interest.

This loan amortization table takes into consideration the following inputs;

Amount borrowed
Interest rate
Loan tenor
Repayment start date
Periodicity of repayment (repayment interval)

Simply key in the necessary inputs as stated above and what you have will be a schedule of your loan repayment plan.

The table can take a period of up to 360 months (30years).
Here is a simple loan amortization table designed to calculate the instalment repayment on a loan, split into principal and interest.

This loan amortization table takes into consideration the following inputs;

Amount borrowed
Interest rate
Loan tenor
Repayment start date
Periodicity of repayment (repayment interval)

Simply key in the necessary inputs as stated above and what you have will be a schedule of your loan repayment plan.

The table can take a period of up to 360 months (30years).

This Best Practice includes
1 Excel worksheet

A. Emmanuel offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...