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!
{ 6 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.