Excel Forum
Similar Content
PMT Function - Get the Payment Due for a Loan in Excel
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
Get the Row or Column Number of a Cell in Excel
Tutorial: How to get the row or column number of the current cell or any other cell in Excel. This t...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Highline Excel Class 47: PMT function 5 Examples


See 5 examples for the PMT function:
1.Monthly loan payment at the end of each month from the borrowers point of view
2.Monthly loan payment at the beginning of each month from the borrowers point of view
3.Monthly loan payment at the end of each month from the lenders point of view
4.Monthly loan payment at the end of each month from the borrowers point of view with a Balloon payment during the last period
5.Quarterly payment for a loan when payments are delayed during first year.
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.