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


www.TeachMsOffice.com This video educational will uncover we how to have a bound rate loan or debt electronic caclulator in excel. It is essentially utterly simple to do as well as after examination this step-by-step e.g. as well as walk-through, we will be means to have your own also. This educational uses a PMT() duty to work out a compulsory payments as well as it is additionally clarified in a tutorial. To follow along with a spreadsheet seen in a educational or to get a small giveaway surpass macros or tips & tricks, go to a website www.TeachMsOffice.com

You can follow any responses to this entry through the RSS 2.0 feed.

Comments

  1. On August 17, 2010 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. On August 17, 2010 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. On August 17, 2010 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 plot
    how far will that reduce the loan.

  4. On August 17, 2010 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. On August 17, 2010 ben75h says:

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

  6. On August 17, 2010 adityagusman says:

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

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