ExcelisHell asked:
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 www.TeachMsOffice.com
Student Loan Refinancing
Tags: Excel Tips, Fixed Rate Loan, Free Excel Macros, Free Macros, Loan Calculator, Loan Mortgage, Mortgage Calculator, Pmt Function, Spreadsheet Tutorial, Video Tutorial
7 responses to How to make a Fixed Rate Loan/Mortgage Calculator in Excel
Student Loan Refinancing
@lichandler Replied via personal message on here.
Instant Auto Insurance Quote
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.
How to make a Fixed Rate Loan/Mortgage Calculator in Excel
Consolidating Debts
@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.
Free Checking Account
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.
How to make a Fixed Rate Loan/Mortgage Calculator in Excel
Instant Auto Insurance Quote
Where can I get the 2nd part to this video? I cant find it or the excel download on the site.
Thanks
Instant Auto Insurance Quote
Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!
Instant Auto Insurance Quote
many thanks for the video, it helps me a lot. I didn’t know about the PMT function before.
Leave a reply to How to make a Fixed Rate Loan/Mortgage Calculator in Excel