Excel Forum

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.