CLASS DATE(s):

9/17/2020

10/16/2020

11/12/2020

COURSE LENGTH: 2 hours

COURSE COST: $.99

COURSE TIMES: TBD

print

register

9/17/2020

10/16/2020

11/12/2020

COURSE LENGTH: 2 hours

COURSE COST: $.99

COURSE TIMES: TBD

register

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.

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

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

PREREQUISITE COURSESFOLLOW UP COURSESBasic formula writing refresher

Relative and absolute formulas

Copy, paste, autofill

PMT

IPMT

PPMT

CUMINT

CUMPRINC

IF

IFERROR

Error correction

Copy/Paste tricks

Goal Seek

What would the interest have to be if...?