This is a video discussing how to use a Loan Amortization Calculator to determine your payments over the lifetime of a fixed-rate loan. This spreadsheet was created by Dr. Wittwer at Vertex 42, an online resource featuring dozens of powerful downloadable calculators.

The video covers the various input fields, the resulting outputs, the amortization schedule (broken down by principal and interest payments), and the effect of making additional payments at various times.

This spreadsheet is a must-have for anyone who’s trying to better understand the financial impact of borrowing money. **Click here to purchase today!**

{ 11 comments… read them below or add one }

I am trying to set up aschulde for the repayment with monthly payment s of a loan over a period of two years. Twenty four payments

OK

I am trying to find a template that allows me to send a monthly statement to a person I am sending money. I need to be able to keep track of the agreed upon interest rate plus late fees and higher interest rates during periods of default should that occur. I also need to be able to add amounts due to the principal in the event I need to pay for repairs or insurance on the building should the loan go into default.

I am looking for a Loan Amortization Calculator just like yours….

I watched your Video.. Thanks it was great… But I have 3 questions…

1) After downloading your program and unziping it I got 2 error messages

stating that some data might have been lost… ????????????

Next I opened up your excel spread sheet.. It worked “ALMOST” like your movie..

2) I didn’t have a box in the lower right corner ( Rounding ON )… ?????????

3) Are these 2 questions related and will it effect the accuracy of the data ???

In your replay please put Loan Amortization Calculator in the subject line..

Thanks for your help… Mike

Befoer I buy the unlocked version of the loan amortization calculator I need to know if you can change the date the actual payment was made, as this changes the interest amount.

Thanx

To print, you need to purchase the full unlocked version.

I’m looking for a loan repayment calculator that will allow me to specify a principal amount, a specified monthly payment (in round numbers, i.e. $300 per month, or $125 per month, a number that the debtor can live with) and an interest rate, which program will then determine the number of payments at that payment amount, and, rather than calculating a balloon payment at the end, instead will determine a down payment for first payment that takes up all the extra.

An example would be principal amount of $3205.05 and 11 monthly payments and interest rate of 12.84% the monthly payment of $300 needs a final balloon payment at the end of $120.77. I want to have the odd payment be the first payment, so a payment arrangement would be a first payment of $120.77 followed by 11 consecutive monthly payments of $300, but of course just switching the member to the beginning is an ignorant thing to do.

But your calculator have such a feature? Or can you direct me to one that does?

Does such a calculator even have a name?

Don’t get much traffic these days do you?

It’s quiet.

Too quiet.

It’s June.

Too June.