PMT | CSE 148 – Excel Exam 1

PMT explained

Honest truth: you'll never really use the PMT function in anything other than finance.

And straight up, finance can be boring. So let's just bulldoze through this as fast as possible so we get 'er done.

PMT functions are primarily used with two financial instruments: loans and annuities. But within what aspect of these do PMT functions contribute?

The PMT function is used primarily with loans (to calculate periodical payments) and annuities (to calculate returns).

That's all you need to know for now. Let's jump into coding a PMT function with a loan!

Coding a PMT function (loan)

Given the following loan situation, let's code a PMT function to figure out our yearly payment.

Loan amount = $10,000
Interest rate = 6.2%
Periods (in years) = 5

To start, let's check out the PMT function template:


This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 1) or Lifetime Access.

Already purchased? Click here to log in.

Leave a Comment