Excel for Mortgages
CLASS DATE(s):
9/17/2020
10/16/2020
11/12/2020

COURSE LENGTH: 2 hours

COURSE COST: $.99

COURSE TIMES: TBD

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Excel has functions to help determine the cost of a loan, the payment schedule and even calculate the exact payments for a loan. You can work with various “what-if” procedures to accommodate any combination of interest rates, payments, and duration.

  1. using the PMT function
  2. Create an amortization chart
  3. Determine the total interest paid over the course of a loan
  4. Determine the Interest paid for any portion of the load (e.g. each year)
  5. Manipulate interest rate, down payment, and duration to achieve an exact monthly payment

AUDIENCE AND PREREQUISITES

This course is intended for experienced excel users with a solid understanding of functions and formulas. Excel Level Two or equivilent

PREREQUISITE COURSESFOLLOW UP COURSES   

COURSE TOPICS:


Formulas
Basic formula writing refresher
Relative and absolute formulas
Copy, paste, autofill

Financial formulas
PMT
IPMT
PPMT
CUMINT
CUMPRINC

Error Control
IF
IFERROR

Formula Writing Technique
Error correction
Copy/Paste tricks

Use What-If Analysis
Goal Seek
What would the interest have to be if...?

Your House