Excel PMT Function - Mortgage Loan
CLASS DATE(s):
Request a Class

COURSE LENGTH: 90 Min

COURSE COST: $99.00

COURSE TIMES: 9:30 - 11:00

Printable version of this course
print

COURSE OVERVIEW

In this 90 Minute training you will learn:
PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate. Use the Excel Formula Coach to figure out a monthly loan payment. At the same time, you'll learn how to use the PMT function in a formula.

AUDIENCE AND PREREQUISITES

Loan Officers Bankers Excel Level 1

  

This course is a 90 minute course instructor led live online course. Course is subject to a minimum enrollment to run. For more information, please contact: 207-775-0244 or email: learn@vtec.org

COURSE TOPICS:


Lesson
How could you use PMT?
PMT Syntax
PMT Traps
Calculate Payment on Personal Loan
Calculate Payment on Canadian Mortgage
Enhance Loan Calculator
Payment Date Calculations