Course Code: 17921

Excel for Mortgages

Class Dates:
10/16/2020
11/12/2020
Length:
2 hours Days
Cost:
$.99
Class Time:
Technology:
Office,Business
Delivery:
Instructor-Led Training

Overview

  • 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
  • This course is intended for experienced excel users with a solid understanding of functions and formulas.

Prerequisites

Course Details