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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

356,428 views October 25, 2008 7:24

Watch on YouTube
ChannelTeachExcel

Description from the creator

Excel Courses: teachexcel.com/premium-courses/


More tutorials: teachexcel.com
Excel Forum: teachexcel.com/talk/microsoft-office?src=yt

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:
TeachExcel.com

About this tutorial

TeachExcel published this 7:24 video tutorial on October 25, 2008. It has been watched 356,428 times on YouTube.

Channel
TeachExcel
Category
Education
Duration
7:24
Published
October 25, 2008
Views
356,428
Likes
1,215

Tags

Share

Further reading

  • Excel Mortgage Calculator excelfunctions.net

    In order to use the above Excel Mortgage Calculator, simply enter your mortgage details into the pink-shaded user-input fields (shown on the right above).The details required are the loan amount, the interest rate, the…

  • Excel Mortgage Calculator | Calculate Mortgages using Excel ... wallstreetmojo.com

    Mortgage Payment Loan Calculator in Excel. Mortgage Calculator in excel is not a built-in feature in excel but we can make our own mortgage calculator using some formulas, to make a mortgage calculator and calculate the…

  • 3 Ways to Create a Mortgage Calculator With Microsoft Excel wikihow.com

    Cross-reference these values with your mortgage calculator. If they match, you've done the formulas correctly. Your principal should match up exactly with the original loan amount. Your payments should match the total c…

This tutorial in other languages