Excel Forum
Similar Content
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
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 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.