Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 7, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video learn about: (00:01) Introduction 1. (02:22) PMT function from Borrower point of view, End Payment (07:10) PMT with Begin Payment 2. (08:19) PMT function from Lender point of view 3. (09:25) PMT function with Balloon payment at end 4. (11:17) PMT function when payments don't start for 1 year 5. (17:20) RATE function: Adjusted APR when there are Points and Fees 6. (23:23) PMT and other formulas: Create an Amortization Table 7. (29:49) CUMIPMT function: to calculate total interest over the life of a loan 8. (30:41) NPER function: How long to pay off your Credit Card Bill 9. (32:20) FV to estimate what you will have at retirement 10. (35:16) PMT to estimate how much you can withdraw each month after you retire 11. (36:55) Calculate total you can withdraw after retirement and how much you actually deposited while saving. 12. (38:25) PMT to calculate how much you have to save each month to have a million dollars when you retire.