Loan Amortization Calculator (Installed Excel Template)

This video shows how to open and use the Loan Amortization Calculator found in Microsoft Excel 2007/2010. Calculator allows you to enter loan amount, annual interest rate, time frame, number of payments per year, start date and any option extra payments. The calculator will output the cumulative loan, principle per payment, interest per payment and more. This video also demonstrates how to unprotect the sheet.

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

[MrDevil]

thank you after bouncing on many videos came across your easy

[nonnie]

Thank you for this quick and simple instruction. It was just what I needed!

nice work, easy to follow Thank you for doing the work. Could you please tell me why when I put "Number of payments" per year to 26 ( fortnightly) I get different number for "Scheduled number of payments"
than "Actual number of payments"
but if i put 12 for the "Number of payments" then there is no problem.

[venchan]

why the loan period in year is not recognize 2.5?

[tupregunta]

In my version of MSO 10 the excel mortgage template shows the euro as the default currency, how do I change the currency symbol?

[tonyohore]

Pls i need ya help recently joined a company we loan for only a month how do i go about it?