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 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

Possibly Related Posts:


This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

6 Responses to How to make a Fixed Rate Loan/Mortgage Calculator in Excel

  1. reason012 says:

    im looking for credit card applicants,,
    PROMO IPOD NANO:
    REQUIREMENTS:
    3 months latest payslips
    2 valid ids (sss/license/company id/passport)
    proof of home address
    -
    im looking for credit card applicants,,send me ur email address and i will send you the form,
    if youre interested pls send or email me at reason_012@yahoo.com
    cp: 09176481263

  2. ExcelisHell says:

    @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.

  3. altha2008 says:

    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.

  4. c6cole says:

    Where can I get the 2nd part to this video? I cant find it or the excel download on the site. :( Thanks

  5. ben75h says:

    Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!

  6. adityagusman says:

    many thanks for the video, it helps me a lot. I didn’t know about the PMT function before.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>