|
Featured Tutorial
Featured Macro
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.
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.