Tag: Excel
Excel Magic Trick 355: VLOOKUP for Mortgage Calculator
See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other loan. Video Rating: / 5
How to make a Fixed Rate Loan/Mortgage Calculator in Excel
http://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…
Loan Amortization Calculator (Installed Excel Template)
This video shows how to open and use the Loan Amortization Calculator found in Microsoft Excel 2007/2010. Calculator allows you to enter loan amount, annual interest rate, time frame, number of payments per year, start date and any option extra payments. The calculator will output the cumulative loan, principle per payment, interest per payment and…
