Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...
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




Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR with Points and RATE function


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to do these items:
1. Loan Payment for Annuity Ordinary (End)
2. Loan Payment for Annuity Due (Begin)
3. Loan Payment From Point of View of Borrower
4. Loan Payment From Point of View of Lender
5. Loan Payment with Balloon Payment
6. Loan Payment that is delayed for one year
7. Loan Payment with Points calculate the Adjusted APR using the RATE function.





Got a Question? Ask it Here in the Forum.