http://www.TeachMsOffice.com
This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is actually quite easy to do and after watching this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also explained in the tutorial.
To follow along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website:
http://www.TeachMsOffice.com
Duration : 0:7:24
where is the second …
where is the second part of this tutorials can you show it plzzzzzzzz.thank a lot i’ll wait the part of this tutorials
where is the second …
where is the second part of this video…how can i add..down
Nice combo of …
Nice combo of mortgage calculator and amortization schedule, nice work.
This is an awesome …
This is an awesome idea. Theres also a lot of excellent pre-made mortgage calculators online. I find that the FREE variety and quality of the ones at mortgagecanadacalculator.ca are great for whatever information you’re looking for! They also post the current rates which is helpful
@lichandler Replied …
@lichandler Replied via personal message on here.
I really like this …
I really like this spreadsheet. Thanks for posting.
Here is my situation…hope you can help. These are for my school loans and I have started making payments before they are due (2016). I would like to incorporate these payments showing what was applied to the principal and interest and how much is left to pay.
@altha2008 A lot …
@altha2008 A lot lol. I’m sorry but I can’t do your homework for you. Though, If you have a real problem that you need to calculate you can private message me.
thanks for the post …
thanks for the post sir.
question
if a person got a 30 year loan say for $100,000 payments around $600
If a person makes the next prinipal payment each month.
also, if a person makes an extra whole payment at the first of each year.
also, if a person can set it up on a bi-weekly plan
how far will that reduce the loan.
Where can I get the …
Thanks
Where can I get the 2nd part to this video? I cant find it or the excel download on the site.
Thanks Bro, You are …
Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!
many thanks for the …
many thanks for the video, it helps me a lot. I didn’t know about the PMT function before.