How to make a Fixed Rate Loan/Mortgage Calculator in Excel
www.TeachMsOffice.com This video tutorial will show you how to make a fixed rate loan or finance calculator in excel. It is really quite simple to do and after watching this step-by-step develop and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the vital payments and it is also clarified 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 www.TeachMsOffice.com
@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 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 plot
how far will that reduce the loan.
Where can I get the 2nd part to this video? I cant find it or the excel download on the site.
Thanks
Thanks Bro, You are fantastic teacher. I wish I had you as my excellent teacher before. Again, thank you very much!!
many thanks for the video, it helps me a lot. I didn’t know about the PMT function before.